Layer: RestaurantInspections (ID:0)

View In: Map Viewer

Name: RestaurantInspections

Display Field: establishmentname

Type: Feature Layer

Geometry Type: esriGeometryPoint

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:

Drawing Info:

{"renderer":{"field1":"GRADE","fieldDelimiter":",","uniqueValueInfos":[{"symbol":{"imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAA29JREFUSIm1lUFo22YYhp/Gkmcn0rY6cnBsNtNBwCfDUA297JJebTbSgwchLDvUhiWwsZ5GD3WgG7v4UEZNbQZbVjZaBj3MvebQnjw8UQgbSy8bYdgOS2qyyi2ubcU7/LZsR3YaBntPQvr1Pf/36v0/SfzPkk6xRiaZ1fEoUc4QpNOW6VpVpOkSm5eN/w5YuhrGOxcH1lG1CFMSuGRwSWB1oGnCSu6AV6bv8fXqOtA+PWD1VoIj6zqKFmXmLMgeAIKqG4Cq2QJVA6uj8fwwxUpuCat1iR8+efhywPJXSWTvHVQ/eBT7th5S+OWjtwE4n3uEUWmIblQNPIpG/a8HpG+nya8UJgNWbyWQvXfwvSFeHlJmMWxf599d4Hzu0eCh7AHtHBz8mSeZ3ebulZITsHQ1zJF1HdXvKK6HFOIRH0alQfBVN3pIQQ8poou+XJKAtHaKgN8J8M7FUbTosC19pWLzANx/XGdedZOKBcgshknc/m10oUsCdVZj+cYa3398cxggA+vMnHUU10MKqViAmtkis7VLsAeIR3zOLgBUP5hPMsAQIJnVUbVIPy0jgKDoqLhTB0SCCuU9UrEAicisE+CSYOY1jWT2AnevlATAo0SZcgYqqLrJXBQft1Cu2fcL5RqpWIBri2+S2dp1vMeUBK/PRYEe4AxBXLJjXTziY151UyjvjezUqDQwKg3bvkJ5b/RFtxcO9sMDizpt+XhyYPBxjYppH7LhLvKhBTIXw07AkETVrlXF6hwrHkAPCf/z7y1MLNBP1QjE6sC02h4ApOkSTVOcymO7v79TF6NhjBI9Cx1dNE1otYoDwOZlgw8LB1gdDZdk775mtpxZH1Ia6H7+DvOqm0TEJ5LWbsKLxjbfrRkDgPDpHs8PU6iavft+NE9SP7LXFsNifbMBLmnMqPgmnWYlt6S/FdD63g9Hc5I2tnbtjnW/hFHdN/g2/akTAPDP35eMX39/EPriCKakid4Pq2q2CH35s7DG3Ae6G8Cz8YCfMg/5IJ+u/vE4j3bOMfQmQupP4bAGh9X3+fGz4vAzZ4XNdIFkdpvWThF1Vhs3XW21m8Jzc9+A7sbx4uMBQG+e+1m+sYb5JINnRkP2iBMKg1/mi8Y2LqnU8/zZuFIneyBG7k2S2Qt4lChPxfG3f/q9KJ6k05ksOiq9dN0Y/QvSa0NYzuuTDgAAAABJRU5ErkJggg==","contentType":"image/png","width":18,"url":"5a0739f6-bea6-4437-b8e2-3a3aae12b9a0","angle":0,"yoffset":0,"type":"esriPMS","height":18,"xoffset":0},"value":"A","label":"A"},{"symbol":{"imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAA7hJREFUSIm1ls9r22YYx7+1ftjOKytObYm6wUvAZBRSDEsvJYfAbsHUF4f8gDEw2RKPNeQwxk47tJC/wKztbELJ2AZJy3LxyMpu9cH4khxCfJkphJnUxU0a2YrmWJalHWJriSWn2WDf2/vyoM/z630e0fifRV/Bhokno3ecHAlfM3BTUzVGN4zXzj5H/kn8+fZ/BsRWIkPe6+57hoElXiS3KNoBiqFA0Q60NB2ncgML6elDJ3FufvfJT0sAmlcGJFZnoi3dWOEFEiYDbrBuxmLDCwQtTfcrx/XFhfR0TFVbUz8sbWbfC/j8+9gsS9h1XiAYD30Mjum3jbAo7aGslMALBC6O9R/9Kb1cfvZpIjnzY7onILE6E2UJu+77wAuKdmDEexsj3lFbwMTgJABga38DO5UcxJAPlVdHqXgyuru2nMlbALGVyFA7LaBoR5e3BexUcubZw/L4SBhHgAQRGZ6FrNZQlPYghnw4KGgZAIIF4L3uvscLJOzyOC3eymoVRWnvwt1OJYfPRr9GgAQxMTiJorQHinbAIxD//OOp+0+//OXReQBjGFgiA27bdPRSUSogQIIX7niRg/xWeQDgH0A8Gb3Di+SWXbdcJo7hTVBHFO1A34DbH09G764tZ/I0ADg5Eu7O+3l52P4LnnJMP0a8oxgTx1FWShfq04HwN7xhAGeAawZuUgzVEzDiHbXtpuzBC2QPfrPcs24GtTcnQ0A7RZqqMZdFUJQKkNWqeQ6QoFncicFJs1XtRAOAbhivW5reEyCrVWztb1juI8OzGBPHERmeRVkpoayUAAAtTYeLdzVNgLPPkT+VG+AF0hNip639DYyJ42ZUHcCp3ECr2ciYgCfx59tfrM0dtjTdf1mq7FRWSgiQIG70nTWBWm+iLjd2VxfPJq350Azd2FSO64v/JopOLQDgzV9t709UULTDOipS8xuJhfR0zMWx/u73ECBBjHhvm2cPy4Nj+s30lJUS/jguQK03Uaso26n5ja8sAACoVqpTjIt+KYZ8F+ZRgAQx++GCJYKTZg07lRyyBy/wrnYIqSwDuv4QgGILePbt79nE07lE5dVRSgz5sFPJmYXrVlHag6zWcNKsQq03IZVlvCtJcz9/82vmvJ1lH6Tm19PxZHT3oKBlakLOz4ucZbp2pNabOD1RUaso29D1h90ftwUAQHueC/OPp+7Lb5UHLo/Tz7hoc7N1VmZdbuxStCPfzrli961Ll3575D6KJ6N3nRwJd55/Z+l3WvEyXeWvohNR/r2GNvobL/OBGrKjaSwAAAAASUVORK5CYII=","contentType":"image/png","width":18,"url":"9e661e2f-3d37-4085-872d-c220fc5b0444","angle":0,"yoffset":0,"type":"esriPMS","height":18,"xoffset":0},"value":"B","label":"B"},{"symbol":{"imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAA2xJREFUSIm1lr9rG2cYxz/o7rV8p1iSowuVFBxDF2USGC0BU+hSgsHyYA/11iEgFeJJS4pNWhvHlA7J5AzSX6DJlB6kBU9JcdDQo+BNSzEI2QlIbWQ3Jy4nnTqc7uRY8o8Y+oyv3vt+3ud5n+f7SuZ/DvkKe0S5QCYSIk2PpGUjHDgMjVG5v4lxbcD2A6aTGvM9h5XEJHeFBEIGWYJOF1om6Ks0JsbZ+fJ7VgD7yoAXa2Q7Dk8SUdKxCVCDw3viUbC7aM0Tcvoqix8slpae8upSwM/f8XVonHI8ChF1sB5Qk4hYhoCaQFKTdM1DRNNASAZhBe2vt7z8fYv8F2uUzgW8WCMbGqf8+WcgJHdNaBlCM+sEp+ZHJYvdMBCv86Rkg2qdYrnA/vIzKkOA7QdMdxyexKMDcSWVIzxb9IU6TQPHPMJuGATUBDdm1hFahpsLfxDYXSCFTvsAHbg1BEhqzCeipL2yBKeyvni7WuJ4Lz90+na15O+xajpCgngEbecRDxd/4vlpgOg5rMQmBmW5TNyLs7/FJ+FNi3U4BSgXyCQmuet1i9y/TMc84t8/N84VHxVCgtgNtHKBe8vPqMgAkRBpr+4AwTtZP23HPPwkgAe5HSMNfQA9kuJUPwWUBACOefTJ4gBKEOp/Mw39Elk2Qj6VgaQmAehe4/RnQwZw4LDTHSxaNR0llSN4J0u7Wjrv23Oj04WI6lqHDBAao9Iy3fGHQWlELHOtU7dM+NBB9wH3NzF+e0zD7qIJCcxqidDMDwTUBOHZ4oVtCq6NeM1gWtAy2V/40XVa/2p7DjvNE3LxKDjmIe92F4h+9QtKKgcM97sX4dkiSirH8V7enZk2iMAIq5jbIq+vshhW0NSgew/He3lfQI5l6DQN7Ib7BEhqkrGpeYSWwW64FmJacPQPxtwWhSEAQL3JkiJ4mbrt9nK7WqLTNHyzE1oGJfVxBnbD4OR1nlbdoNaEXo8N4P1IwLdFXv36mHy1TtGD2A2Dd7vu4AWnsr5dWzXdz8a0oNaEg7csf7PtXu5IAMDcJqVygf32AXo8ghafHLirVfvoW0wLjttuWXo9Ns6KjwQA9P381s4jHr5psR5W0NQxd0Jh8GS2TPZFgEq/5u9HaV346Pct93m5wL1IiLTVH3/v0fda8aK4yr8KL6PKpRtHxH/CPlBfdZrrdAAAAABJRU5ErkJggg==","contentType":"image/png","width":18,"url":"a26678eb-a2dc-4705-a395-de467b999fe8","angle":0,"yoffset":0,"type":"esriPMS","height":18,"xoffset":0},"value":"C","label":"C"}],"type":"uniqueValue"},"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: grade

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
establishmentname (type: esriFieldTypeString, alias: Establishment Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
address (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
county (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
state (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
zip (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
identifier (type: esriFieldTypeString, alias: Identifier, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
permnum (type: esriFieldTypeString, alias: Permit Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
capacity (type: esriFieldTypeInteger, alias: Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
inspdate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
inspdesc (type: esriFieldTypeString, alias: Inspection Description, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Routine: Routine], [Follow-Up: Follow-Up], [Temporary: Temporary])
score (type: esriFieldTypeSmallInteger, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
grade (type: esriFieldTypeString, alias: Restaurant Grade, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
risktype (type: esriFieldTypeSmallInteger, alias: Risk Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Inspected one time per year], [2: Inspected two times per year], [3: Inspected 3 times per year])
supervision (type: esriFieldTypeString, alias: Supervision, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
employeehealth (type: esriFieldTypeString, alias: Employee Health, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
approvedsource (type: esriFieldTypeString, alias: Approved Source, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
protectionfromcontamination (type: esriFieldTypeString, alias: Protection from Contamination, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
consumeradvisory (type: esriFieldTypeString, alias: Consumer Advisory, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
hazardousfoodholding (type: esriFieldTypeString, alias: Hazardous Food Holding, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
hsp (type: esriFieldTypeString, alias: HSP, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
chemicals (type: esriFieldTypeString, alias: Chemicals, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
inspfrequency (type: esriFieldTypeString, alias: Inspection Frequency, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
previnspdate (type: esriFieldTypeDate, alias: Previous Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
previnspdesc (type: esriFieldTypeString, alias: Previous Inspection Description, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
previnspscore (type: esriFieldTypeSmallInteger, alias: Previous Inspection Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
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)

Types:

Field Name: risktype
Inherited
Field Name: protectionfromcontamination
Inherited
Field Name: employeehealth
Inherited
Field Name: hsp
Inherited
Field Name: consumeradvisory
Inherited
Field Name: inspdesc
Inherited
Field Name: hazardousfoodholding
Inherited
Field Name: supervision
Inherited
Field Name: chemicals
Inherited
Field Name: approvedsource
Inherited

grade: A

Field Name: risktype
Inherited
Field Name: protectionfromcontamination
Inherited
Field Name: employeehealth
Inherited
Field Name: hsp
Inherited
Field Name: consumeradvisory
Inherited
Field Name: inspdesc
Inherited
Field Name: hazardousfoodholding
Inherited
Field Name: supervision
Inherited
Field Name: chemicals
Inherited
Field Name: approvedsource
Inherited

grade: B

Field Name: risktype
Inherited
Field Name: protectionfromcontamination
Inherited
Field Name: employeehealth
Inherited
Field Name: hsp
Inherited
Field Name: consumeradvisory
Inherited
Field Name: inspdesc
Inherited
Field Name: hazardousfoodholding
Inherited
Field Name: supervision
Inherited
Field Name: chemicals
Inherited
Field Name: approvedsource
Inherited

grade: C

Relationships:

InspectionHistory (0) -- Related To: InspectionHistory (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/14/2022 12:43:55 AM

Schema Last Edit Date: 9/14/2022 12:43:55 AM

Data Last Edit Date: 9/14/2022 12:43:55 AM

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