Name: VaccineFinderSchema

Display Field: FacilityName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

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:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[155,37,102,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FacilityName (type: esriFieldTypeString, alias: FacilityName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Address2 (type: esriFieldTypeString, alias: Address2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Borough (type: esriFieldTypeString, alias: Borough, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Zipcode (type: esriFieldTypeInteger, alias: Zipcode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AdditionalInfo (type: esriFieldTypeString, alias: AdditionalInfo, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Website (type: esriFieldTypeString, alias: Website, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LocationID (type: esriFieldTypeString, alias: LocationID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HoursStart_Monday (type: esriFieldTypeInteger, alias: Opening Hour - Monday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClosingHour_Monday (type: esriFieldTypeInteger, alias: Closing Hour - Monday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hours_Tuesday (type: esriFieldTypeString, alias: Store Hours - Tuesday, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• HoursStart_Tuesday (type: esriFieldTypeInteger, alias: Opening Hour - Tuesday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClosingHour_Tuesday (type: esriFieldTypeInteger, alias: Closing Hour - Tuesday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hours_Wednesday (type: esriFieldTypeString, alias: Store Hours - Wednesday, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• HoursStart_Wednesday (type: esriFieldTypeInteger, alias: Opening Hour - Wednesday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClosingHour_Wednesday (type: esriFieldTypeInteger, alias: Closing Hour - Wednesday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hours_Thursday (type: esriFieldTypeString, alias: Store Hours - Thursday, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• HoursStart_Thursday (type: esriFieldTypeInteger, alias: Opening Hour - Thursday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClosingHour_Thursday (type: esriFieldTypeInteger, alias: Closing Hour - Thursday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hours_Friday (type: esriFieldTypeString, alias: Store Hours - Friday, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• HoursStart_Friday (type: esriFieldTypeInteger, alias: Opening Time - Friday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClosingHour_Friday (type: esriFieldTypeInteger, alias: Closing Hour - Friday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hours_Saturday (type: esriFieldTypeString, alias: Store Hours - Saturday, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• HoursStart_Saturday (type: esriFieldTypeInteger, alias: Opening Hour - Saturday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClosingHour_Saturday (type: esriFieldTypeInteger, alias: Closing Hour - Saturday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hours_Sunday (type: esriFieldTypeString, alias: Store Hours - Sunday, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• HoursStart_Sunday (type: esriFieldTypeInteger, alias: Opening Hour - Sunday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClosingHour_Sunday (type: esriFieldTypeInteger, alias: Closing Hour - Sunday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hours_Monday (type: esriFieldTypeString, alias: Store Hours - Monday, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ServiceCategory (type: esriFieldTypeString, alias: Service Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ServiceType (type: esriFieldTypeString, alias: Service Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• StartDate (type: esriFieldTypeDate, alias: Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EndDate (type: esriFieldTypeDate, alias: End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AgesServed (type: esriFieldTypeString, alias: Ages Served, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Intake_WalkIn (type: esriFieldTypeString, alias: Intake - Walk Ins Welcome, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AgesServed2 (type: esriFieldTypeString, alias: AgesServed2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AgesServed3 (type: esriFieldTypeString, alias: AgesServed3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Payment_Medicaid (type: esriFieldTypeString, alias: Payment Medicaid, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Payment_Medicare (type: esriFieldTypeString, alias: Payment Medicare, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Payment_Private (type: esriFieldTypeString, alias: Payment Private Insurance, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Payment_Uninsured (type: esriFieldTypeString, alias: Payment Uninsured, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Payment_Sliding (type: esriFieldTypeString, alias: Payment Sliding Scale, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Payment_Free (type: esriFieldTypeString, alias: Payment Free, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Payment_Cash (type: esriFieldTypeString, alias: Payment Cash, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FacilityType (type: esriFieldTypeString, alias: Facility Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ServiceID (type: esriFieldTypeString, alias: Service ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AppointmentAvailability (type: esriFieldTypeString, alias: Appointment Availability, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Available: Available], [NotAvailable: Not Available], [Unknown: Unknown])
• WebsiteLabel (type: esriFieldTypeString, alias: Website Label, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AgesServed_Under18 (type: esriFieldTypeString, alias: Ages Served - 17 and Younger, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AgesServed_Over18 (type: esriFieldTypeString, alias: Ages Served - 18 and Older, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Intake_ApptPreferred (type: esriFieldTypeString, alias: Intake - Appointment Preferred, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Intake_ApptRequired (type: esriFieldTypeString, alias: Intake - Appointment Required, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LastModifiedDate (type: esriFieldTypeDate, alias: Last Modified Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FacilityFlag (type: esriFieldTypeString, alias: Facility Flag for Public vs Private, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ServiceType_Pfizer (type: esriFieldTypeString, alias: Service Type - Pfizer, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ServiceType_Moderna (type: esriFieldTypeString, alias: Service Type - Moderna, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ADA_Compliant (type: esriFieldTypeString, alias: ADA Compliant, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Priority_EssentialWorkers (type: esriFieldTypeString, alias: Priority Essential Workers, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• AvailabilityETLLastModified (type: esriFieldTypeDate, alias: Availability ETL Last Modified, SQL Type: sqlTypeOther, length: 0, nullable: true, editable: true)
• AvailabilitySourceLastModified (type: esriFieldTypeDate, alias: Availability Source Last Modified, SQL Type: sqlTypeOther, length: 0, nullable: true, editable: true)
• AvailabilitySource (type: esriFieldTypeString, alias: Availability Source, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [NYCDoITT: NYC DoITT Salesforce], [NYState: NY State Salesforce], [NYCHandH: NYC H and H Epic], ... 3 more ...)
• AvailabilityCount (type: esriFieldTypeInteger, alias: Availability Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vaccine_Restrictions (type: esriFieldTypeString, alias: Vaccine Restrictions, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• ServiceType_JohnsonAndJohnson (type: esriFieldTypeString, alias: Service Type - Johnson and Johnson, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: VaccineFinderSchema
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ServiceCategory: Vaccine

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/7/2022 7:34:43 PM

Schema Last Edit Date: 10/7/2022 7:34:43 PM

Data Last Edit Date: 10/7/2022 7:34:43 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat