Name: MLSA

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Inspections 2023_Multnomah","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• License_number (type: esriFieldTypeString, alias: Local ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Calcname (type: esriFieldTypeString, alias: Calcname, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Premise_Name (type: esriFieldTypeString, alias: Premise Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Calcadd (type: esriFieldTypeString, alias: Calcadd, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Premise_address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Premises_Type (type: esriFieldTypeString, alias: Premises Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Vape shop], [2: Department store], [3: Drug store], ... 8 more ...)
• Adult_Inspector (type: esriFieldTypeString, alias: Adult Inspector name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Marc], [2: Max], [3: Mike])
• YA_Inspector (type: esriFieldTypeString, alias: Young adult inspector name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [107: Cyrus], [108: Austin], [109: Amanda], ... 12 more ...)
• gender (type: esriFieldTypeString, alias: Young adult inspector's gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Male], [2: Female], [3: Non-binary])
• Inspection_date (type: esriFieldTypeDate, alias: Date and time of inspection (12 hour time), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Mercant_eligible (type: esriFieldTypeString, alias: Is merchant eligible?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Reasons_ineligible (type: esriFieldTypeString, alias: Why is this merchange ineligible?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [I1: Out of business], [I2: Does not sell tobacco products], [I4: Personal residence], ... 4 more ...)
• eligible_other (type: esriFieldTypeString, alias: You selected 'Other' reason for ineligibility. Breifly describe other reason (be specific)., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Tobacco_Type (type: esriFieldTypeString, alias: Type of tobacco attempted to purchase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Cigarettes], [2: Cigarillos], [3: E-cigarettes], ... 1 more ...)
• id_request (type: esriFieldTypeString, alias: ID requested?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• minor_access (type: esriFieldTypeString, alias: Under 21 can enter?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Inspection_comp (type: esriFieldTypeString, alias: Was inspection completed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• reasons_not_comp (type: esriFieldTypeString, alias: Why was inspection not completed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [N1: In operation but closed at time of visit], [N2: Unsafe to access], [N3: Presence of police], ... 6 more ...)
• notcomp_other (type: esriFieldTypeString, alias: You selected 'Other' reason for not completing the inspection. Breifly describe other reason (be specific)., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sale_made (type: esriFieldTypeString, alias: Was sale made?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• notes (type: esriFieldTypeString, alias: Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/1/2023 11:12:33 PM

Schema Last Edit Date: 9/1/2023 11:12:33 PM

Data Last Edit Date: 9/1/2023 11:12:33 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat