Name: VaccinesExampleSchema_Jan6th

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: -74.234425
YMin: -1E-06
XMax: 1E-06
YMax: 40.8995388000001
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"101ecf964f4a8cad33eaf976d5dbf6ea","imageData":"iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACyklEQVQ4jb3UwUvbcBQH8G9NmrjWxLZpq/0dtAXJcDgvZYMx0IIXYUpATzl5EPYP7L8ZFHbLaYWAIqyX7tJd7MWViUU2ZdDqmkhN2iZtmnSXKkaLbDD2ru+9D4/f7/1+NP5h0P8Ny6sqF3bd1LDnxgEgwFJah6Iau5Jk/jGWV1WOhELZZDyZi/C8SAcpAQAGjqu3DKN2UCyW6t1u5T76ACsUCkImk9mM8PzOVHgqGw6HOZZlAACdXw0ETr+bQWewGiVpRVGUPVmW62OxvKpymUxmczaRfBeLRZcYhrnNDa512OV9BL5VuOTrNzk7MUNGPcrNhD6MhELZCM/v3IfcrgnzsATj8DMm50VEni7DiyXEgTeQSatVA1DyYXlV5ZLxZO4JvOxQq8N2+j5scK0jtLCE0GIWAMB4DqLTkSyZJTlVVSuSJJm3WNh1UxGeFycufnCX5X04zca4u0H3tIpgIoXY2jb4Zy+4mG2JR8c9AuDkFhv23DgdpISAocH48gnd069jMQAILTwHt/wKUzQNAAIdCAgPzgwAWJIGQ9KPYsyoxvM8OH2HBcD4sABLaQPH1Sdm04isbMA+P4F9Xhs7VWxtG5PzIizLRt/pa9RwqPuwDkU1WoZR43nOjK5sck6zgWbhPfrN2zUCkyAQ1mVEVjZAhThYmm52OlaVZdkzH7YrSeZBsVianuZWw6lULryYhTkn+qYKxlNgSBr0tADLtnFtmtW20S5L4/as3u1Worqu0BM04WfmxMT2W3hd/zOcnBdh2TaaTa2q6VcfdP2ycpPzYbuSZCqKsgcAA0GQoy/Xs1Ge42iahud5sCwblmWZ142LqqZffaj/PP+4tbWlj8UAQJblel5VFdJq1cgsycVsSwQgOH2H7Tt9rdOxqm2jXdb1y8pdaCx2MyGAkqqqlaPjHhntEUMNhzrLsmfS33xBNzFqOnms5m78BmMYO5ku3wqcAAAAAElFTkSuQmCC","contentType":"image/png","width":14,"height":14,"angle":0,"xoffset":0,"yoffset":0}},"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: Facility Name, SQL Type: sqlTypeOther, length: 8000, 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)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Address2 (type: esriFieldTypeString, alias: Address 2, 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 Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AdditionalInfo (type: esriFieldTypeString, alias: Additional Information, SQL Type: sqlTypeOther, length: 8000, 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)
• Hours_Monday (type: esriFieldTypeString, alias: Hours - Monday, SQL Type: sqlTypeOther, length: 256, 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: 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: 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: 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: 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: 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: 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)
• 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)
• AgesServed (type: esriFieldTypeString, alias: Ages Served, 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)
• Intake_WalkIn (type: esriFieldTypeString, alias: Intake - Walk Ins Welcome, 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)
• Payment_Cash (type: esriFieldTypeString, alias: Payment Cash, 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_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_Sliding (type: esriFieldTypeString, alias: Payment Sliding Scale, 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)
• FacilityType (type: esriFieldTypeString, alias: Facility Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Website (type: esriFieldTypeString, alias: Website URL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WebsiteLabel (type: esriFieldTypeString, alias: Website Label, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ServiceID (type: esriFieldTypeString, alias: Service ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LocationID (type: esriFieldTypeString, alias: Location ID, SQL Type: sqlTypeOther, length: 8000, 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])
• LastModifiedDate (type: esriFieldTypeDate, alias: Last Modified Date, SQL Type: sqlTypeOther, length: 0, nullable: true, editable: true)
• FacilityFlag (type: esriFieldTypeString, alias: Facility Flag for Public vs Private, SQL Type: sqlTypeOther, length: 256, 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])
• AvailabilityCount (type: esriFieldTypeInteger, alias: Availability Count, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: VaccinesExampleSchema_Jan6th
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: 2/17/2021 11:11:14 PM

Schema Last Edit Date: 2/17/2021 11:11:14 PM

Data Last Edit Date: 2/17/2021 11:11:14 PM

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