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 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