Layers:

Layer: Food Permits (0)

Name: Food Permits

Display Field: inspection_cycle

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Last Updated: May 31, 2019Update Schedule: NightlyThe Health Compliance Team is located within Code Services, a Department of the Development Services Division in the City of McKinney. Health Compliance is tasked with permitting and inspecting food establishments, swimming pools, and is responsible for disease vector control.Health Compliance Contact Information:Web: https://www.mckinneytexas.org/218/Health-Compliance | Email: healthinfo@mckinneytexas.orgPhone 8am - 5pm: 972-547-7440This point layer documents all permitted food establishments, an aggregation of attributes from the four most recent inspections, and all food inspection sheets as pdf attachments. This data is extracted from the Energov system on a nightly basis.In addition to pdf attachments, the following data are captured:last inspection date, permit number, work class, permit statusaddress, parcel number, description, average score, tending statustotal number of inspections, number of critical violations within last 4 inspection period

Copyright Text: City of McKinney GIS, Development Services, Code Services, Health Compliance Team jcarmona@mckinneytexas.org; healthinfo@mckinneytexas.org https://mckinneygis-mck.opendata.arcgis.com/

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 2498514.61718522
YMin: 7097437.023960397
XMax: 2550977.1028112173
YMax: 7145122.017172888
Spatial Reference: 102738  (2276)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [170, 42, 91, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• last_inspection ( type: esriFieldTypeDate, alias: last_inspection, length: 8 )
• next_inspection ( type: esriFieldTypeDate, alias: next_inspection, length: 8 )
• inspection_cycle ( type: esriFieldTypeString, alias: inspection_cycle, length: 50 )
• link_number ( type: esriFieldTypeString, alias: link_number, length: 50 )
• WORK_CLASS ( type: esriFieldTypeString, alias: WORK_CLASS, length: 50 )
• PERMIT_STATUS ( type: esriFieldTypeString, alias: PERMIT_STATUS, length: 50 )
• ADDRESS_LINE1 ( type: esriFieldTypeString, alias: ADDRESS_LINE1, length: 736 )
• PARCELNUMBER ( type: esriFieldTypeString, alias: PARCELNUMBER, length: 50 )
• expiration_date ( type: esriFieldTypeDate, alias: expiration_date, length: 8 )
• description ( type: esriFieldTypeString, alias: description, length: 1073741822 )
• avg_score ( type: esriFieldTypeString, alias: avg_score, length: 10 )
• trend ( type: esriFieldTypeString, alias: trend, length: 50 )
• inspections ( type: esriFieldTypeInteger, alias: inspections )
• critical_violations ( type: esriFieldTypeInteger, alias: critical_violations )
• POINT_X ( type: esriFieldTypeString, alias: POINT_X, length: 20 )
• POINT_Y ( type: esriFieldTypeString, alias: POINT_Y, length: 20 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• energov.SDE.HealthFoodSafety (1) -- Related To: Food Inspections (4)

Layer: Mobile & Temporary Food Vendors (1)

Name: Mobile & Temporary Food Vendors

Display Field: inspection_cycle

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Last Updated: May 31, 2019Update Schedule: NightlyThe Health Compliance Team is located within Code Services, a Department of the Development Services Division in the City of McKinney. Health Compliance is tasked with permitting and inspecting food establishments, swimming pools, and is responsible for disease vector control.Health Compliance Contact Information:Web: https://www.mckinneytexas.org/218/Health-Compliance | Email: healthinfo@mckinneytexas.orgPhone 8am - 5pm: 972-547-7440This point layer documents all permitted food establishments, an aggregation of attributes from the four most recent inspections, and all food inspection sheets as pdf attachments. This data is extracted from the Energov system on a nightly basis.In addition to pdf attachments, the following data are captured:last inspection date, permit number, work class, permit statusaddress, parcel number, description, average score, tending statustotal number of inspections, number of critical violations within last 4 inspection period

Copyright Text: City of McKinney GIS, Development Services, Code Services, Health Compliance Team jcarmona@mckinneytexas.org; healthinfo@mckinneytexas.org https://mckinneygis-mck.opendata.arcgis.com/

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 2498514.61718522
YMin: 7097437.023960397
XMax: 2550977.1028112173
YMax: 7145122.017172888
Spatial Reference: 102738  (2276)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [67, 144, 165, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• last_inspection ( type: esriFieldTypeDate, alias: last_inspection, length: 8 )
• next_inspection ( type: esriFieldTypeDate, alias: next_inspection, length: 8 )
• inspection_cycle ( type: esriFieldTypeString, alias: inspection_cycle, length: 50 )
• link_number ( type: esriFieldTypeString, alias: link_number, length: 50 )
• WORK_CLASS ( type: esriFieldTypeString, alias: WORK_CLASS, length: 50 )
• PERMIT_STATUS ( type: esriFieldTypeString, alias: PERMIT_STATUS, length: 50 )
• ADDRESS_LINE1 ( type: esriFieldTypeString, alias: ADDRESS_LINE1, length: 736 )
• PARCELNUMBER ( type: esriFieldTypeString, alias: PARCELNUMBER, length: 50 )
• expiration_date ( type: esriFieldTypeDate, alias: expiration_date, length: 8 )
• description ( type: esriFieldTypeString, alias: description, length: 1073741822 )
• avg_score ( type: esriFieldTypeString, alias: avg_score, length: 10 )
• trend ( type: esriFieldTypeString, alias: trend, length: 50 )
• inspections ( type: esriFieldTypeInteger, alias: inspections )
• critical_violations ( type: esriFieldTypeInteger, alias: critical_violations )
• POINT_X ( type: esriFieldTypeString, alias: POINT_X, length: 20 )
• POINT_Y ( type: esriFieldTypeString, alias: POINT_Y, length: 20 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• energov.SDE.HealthFoodSafety (3) -- Related To: Food Inspections (4)

Layer: Trades Day & Farmers Market (2)

Name: Trades Day & Farmers Market

Display Field: inspection_cycle

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Last Updated: May 31, 2019Update Schedule: NightlyThe Health Compliance Team is located within Code Services, a Department of the Development Services Division in the City of McKinney. Health Compliance is tasked with permitting and inspecting food establishments, swimming pools, and is responsible for disease vector control.Health Compliance Contact Information:Web: https://www.mckinneytexas.org/218/Health-Compliance | Email: healthinfo@mckinneytexas.orgPhone 8am - 5pm: 972-547-7440This point layer documents all permitted food establishments, an aggregation of attributes from the four most recent inspections, and all food inspection sheets as pdf attachments. This data is extracted from the Energov system on a nightly basis.In addition to pdf attachments, the following data are captured:last inspection date, permit number, work class, permit statusaddress, parcel number, description, average score, tending statustotal number of inspections, number of critical violations within last 4 inspection period

Copyright Text: City of McKinney GIS, Development Services, Code Services, Health Compliance Team jcarmona@mckinneytexas.org; healthinfo@mckinneytexas.org https://mckinneygis-mck.opendata.arcgis.com/

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 2498514.61718522
YMin: 7097437.023960397
XMax: 2550977.1028112173
YMax: 7145122.017172888
Spatial Reference: 102738  (2276)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [175, 65, 118, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• last_inspection ( type: esriFieldTypeDate, alias: last_inspection, length: 8 )
• next_inspection ( type: esriFieldTypeDate, alias: next_inspection, length: 8 )
• inspection_cycle ( type: esriFieldTypeString, alias: inspection_cycle, length: 50 )
• link_number ( type: esriFieldTypeString, alias: link_number, length: 50 )
• WORK_CLASS ( type: esriFieldTypeString, alias: WORK_CLASS, length: 50 )
• PERMIT_STATUS ( type: esriFieldTypeString, alias: PERMIT_STATUS, length: 50 )
• ADDRESS_LINE1 ( type: esriFieldTypeString, alias: ADDRESS_LINE1, length: 736 )
• PARCELNUMBER ( type: esriFieldTypeString, alias: PARCELNUMBER, length: 50 )
• expiration_date ( type: esriFieldTypeDate, alias: expiration_date, length: 8 )
• description ( type: esriFieldTypeString, alias: description, length: 1073741822 )
• avg_score ( type: esriFieldTypeString, alias: avg_score, length: 10 )
• trend ( type: esriFieldTypeString, alias: trend, length: 50 )
• inspections ( type: esriFieldTypeInteger, alias: inspections )
• critical_violations ( type: esriFieldTypeInteger, alias: critical_violations )
• POINT_X ( type: esriFieldTypeString, alias: POINT_X, length: 20 )
• POINT_Y ( type: esriFieldTypeString, alias: POINT_Y, length: 20 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• energov.SDE.HealthFoodSafety (5) -- Related To: Food Inspections (4)

Layer: Schools & Daycares (3)

Name: Schools & Daycares

Display Field: inspection_cycle

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Last Updated: May 31, 2019Update Schedule: NightlyThe Health Compliance Team is located within Code Services, a Department of the Development Services Division in the City of McKinney. Health Compliance is tasked with permitting and inspecting food establishments, swimming pools, and is responsible for disease vector control.Health Compliance Contact Information:Web: https://www.mckinneytexas.org/218/Health-Compliance | Email: healthinfo@mckinneytexas.orgPhone 8am - 5pm: 972-547-7440This point layer documents all permitted food establishments, an aggregation of attributes from the four most recent inspections, and all food inspection sheets as pdf attachments. This data is extracted from the Energov system on a nightly basis.In addition to pdf attachments, the following data are captured:last inspection date, permit number, work class, permit statusaddress, parcel number, description, average score, tending statustotal number of inspections, number of critical violations within last 4 inspection period

Copyright Text: City of McKinney GIS, Development Services, Code Services, Health Compliance Team jcarmona@mckinneytexas.org; healthinfo@mckinneytexas.org https://mckinneygis-mck.opendata.arcgis.com/

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 2498514.61718522
YMin: 7097437.023960397
XMax: 2550977.1028112173
YMax: 7145122.017172888
Spatial Reference: 102738  (2276)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [130, 55, 46, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• last_inspection ( type: esriFieldTypeDate, alias: last_inspection, length: 8 )
• next_inspection ( type: esriFieldTypeDate, alias: next_inspection, length: 8 )
• inspection_cycle ( type: esriFieldTypeString, alias: inspection_cycle, length: 50 )
• link_number ( type: esriFieldTypeString, alias: link_number, length: 50 )
• WORK_CLASS ( type: esriFieldTypeString, alias: WORK_CLASS, length: 50 )
• PERMIT_STATUS ( type: esriFieldTypeString, alias: PERMIT_STATUS, length: 50 )
• ADDRESS_LINE1 ( type: esriFieldTypeString, alias: ADDRESS_LINE1, length: 736 )
• PARCELNUMBER ( type: esriFieldTypeString, alias: PARCELNUMBER, length: 50 )
• expiration_date ( type: esriFieldTypeDate, alias: expiration_date, length: 8 )
• description ( type: esriFieldTypeString, alias: description, length: 1073741822 )
• avg_score ( type: esriFieldTypeString, alias: avg_score, length: 10 )
• trend ( type: esriFieldTypeString, alias: trend, length: 50 )
• inspections ( type: esriFieldTypeInteger, alias: inspections )
• critical_violations ( type: esriFieldTypeInteger, alias: critical_violations )
• POINT_X ( type: esriFieldTypeString, alias: POINT_X, length: 20 )
• POINT_Y ( type: esriFieldTypeString, alias: POINT_Y, length: 20 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• energov.SDE.HealthFoodSafety (7) -- Related To: Food Inspections (4)

Layer: Food Inspections (4)

Name: Food Inspections

Display Field: permitted_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Last Updated: May 31, 2019Update Schedule: NightlyThe Health Compliance Team is located within Code Services, a Department of the Development Services Division in the City of McKinney. Health Compliance is tasked with permitting and inspecting food establishments, swimming pools, and is responsible for disease vector control.Health Compliance Contact Information:Web: https://www.mckinneytexas.org/218/Health-Compliance | Email: healthinfo@mckinneytexas.orgPhone 8am - 5pm: 972-547-7440This point layer documents all permitted food establishments, an aggregation of attributes from the four most recent inspections, and all food inspection sheets as pdf attachments. This data is extracted from the Energov system on a nightly basis.In addition to pdf attachments, the following data are captured:last inspection date, permit number, work class, permit statusaddress, parcel number, description, average score, tending statustotal number of inspections, number of critical violations within last 4 inspection period

Copyright Text: City of McKinney GIS, Development Services, Code Services, Health Compliance Team jcarmona@mckinneytexas.org; healthinfo@mckinneytexas.org https://mckinneygis-mck.opendata.arcgis.com/

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 2498364.946880892
YMin: 7097772.258526146
XMax: 2550977.1028112173
YMax: 7145122.017172888
Spatial Reference: 102738  (2276)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [40, 40, 163, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspection_number ( type: esriFieldTypeString, alias: inspection_number, length: 50 )
• requested_date ( type: esriFieldTypeDate, alias: requested_date, length: 8 )
• actual_start_date ( type: esriFieldTypeDate, alias: actual_start_date, length: 8 )
• actual_end_date ( type: esriFieldTypeDate, alias: actual_end_date, length: 8 )
• link_number ( type: esriFieldTypeString, alias: link_number, length: 50 )
• link_type ( type: esriFieldTypeString, alias: link_type, length: 50 )
• permitted_name ( type: esriFieldTypeString, alias: permitted_name, length: 1073741822 )
• date_entered ( type: esriFieldTypeDate, alias: date_entered, length: 8 )
• comments ( type: esriFieldTypeString, alias: comments, length: 1073741822 )
• status ( type: esriFieldTypeString, alias: status, length: 50 )
• inspection_type ( type: esriFieldTypeString, alias: inspection_type, length: 50 )
• inspector_name ( type: esriFieldTypeString, alias: inspector_name, length: 62 )
• main_address ( type: esriFieldTypeString, alias: main_address, length: 736 )
• main_address2 ( type: esriFieldTypeString, alias: main_address2, length: 736 )
• main_parcel_no ( type: esriFieldTypeString, alias: main_parcel_no, length: 50 )
• temp_cooling_time ( type: esriFieldTypeInteger, alias: temp_cooling_time )
• temp_cold_holding ( type: esriFieldTypeInteger, alias: temp_cold_holding )
• temp_hot_holding ( type: esriFieldTypeInteger, alias: temp_hot_holding )
• temp_cooking_time ( type: esriFieldTypeInteger, alias: temp_cooking_time )
• reheating_procedure ( type: esriFieldTypeInteger, alias: reheating_procedure )
• time_as_health_control ( type: esriFieldTypeInteger, alias: time_as_health_control )
• approved_source ( type: esriFieldTypeInteger, alias: approved_source )
• food_received_at_temp ( type: esriFieldTypeInteger, alias: food_received_at_temp )
• food_separated_protected ( type: esriFieldTypeInteger, alias: food_separated_protected )
• food_surfaces_returnables ( type: esriFieldTypeInteger, alias: food_surfaces_returnables )
• condition_of ( type: esriFieldTypeInteger, alias: condition_of )
• knowledge_and_reporting ( type: esriFieldTypeInteger, alias: knowledge_and_reporting )
• proper_restriction_exclusion ( type: esriFieldTypeInteger, alias: proper_restriction_exclusion )
• hands_clean_washed ( type: esriFieldTypeInteger, alias: hands_clean_washed )
• no_bare_hands ( type: esriFieldTypeInteger, alias: no_bare_hands )
• pastuerized_foods ( type: esriFieldTypeInteger, alias: pastuerized_foods )
• food_additives ( type: esriFieldTypeInteger, alias: food_additives )
• toxic_substances ( type: esriFieldTypeInteger, alias: toxic_substances )
• approved_water_source ( type: esriFieldTypeInteger, alias: approved_water_source )
• approved_sewage ( type: esriFieldTypeInteger, alias: approved_sewage )
• certified_food_manager ( type: esriFieldTypeInteger, alias: certified_food_manager )
• food_handler_cards ( type: esriFieldTypeInteger, alias: food_handler_cards )
• available_hot_cold_water ( type: esriFieldTypeInteger, alias: available_hot_cold_water )
• available_records ( type: esriFieldTypeInteger, alias: available_records )
• compliance_with_variance ( type: esriFieldTypeInteger, alias: compliance_with_variance )
• consumer_advisories ( type: esriFieldTypeInteger, alias: consumer_advisories )
• proper_cooling_method ( type: esriFieldTypeInteger, alias: proper_cooling_method )
• proper_date_marking ( type: esriFieldTypeInteger, alias: proper_date_marking )
• thermometers_accurate ( type: esriFieldTypeInteger, alias: thermometers_accurate )
• food_establishment_permit ( type: esriFieldTypeInteger, alias: food_establishment_permit )
• handwashing_facilities ( type: esriFieldTypeInteger, alias: handwashing_facilities )
• cleanable_surfaces ( type: esriFieldTypeInteger, alias: cleanable_surfaces )
• warewashing_facilities ( type: esriFieldTypeInteger, alias: warewashing_facilities )
• no_insect_contamination ( type: esriFieldTypeInteger, alias: no_insect_contamination )
• personal_cleanliness ( type: esriFieldTypeInteger, alias: personal_cleanliness )
• wiping_cloths ( type: esriFieldTypeInteger, alias: wiping_cloths )
• environmental_contamination ( type: esriFieldTypeInteger, alias: environmental_contamination )
• approved_thawing ( type: esriFieldTypeInteger, alias: approved_thawing )
• utensils_and_linens ( type: esriFieldTypeInteger, alias: utensils_and_linens )
• single_service_use ( type: esriFieldTypeInteger, alias: single_service_use )
• original_container_labeling ( type: esriFieldTypeInteger, alias: original_container_labeling )
• nonfood_surfaces_clean ( type: esriFieldTypeInteger, alias: nonfood_surfaces_clean )
• adequate_ventilation_lighting ( type: esriFieldTypeInteger, alias: adequate_ventilation_lighting )
• garbage_and_refuse ( type: esriFieldTypeInteger, alias: garbage_and_refuse )
• physical_facilities_maintained ( type: esriFieldTypeInteger, alias: physical_facilities_maintained )
• toilet_facilities ( type: esriFieldTypeInteger, alias: toilet_facilities )
• other_violations ( type: esriFieldTypeInteger, alias: other_violations )
• total_score ( type: esriFieldTypeInteger, alias: total_score )
• purpose_of_inspection ( type: esriFieldTypeString, alias: purpose_of_inspection, length: 50 )
• bare_hand_approved ( type: esriFieldTypeString, alias: bare_hand_approved, length: 50 )
• custom_comments ( type: esriFieldTypeString, alias: custom_comments, length: 1073741822 )
• sanitized_ppm ( type: esriFieldTypeString, alias: sanitized_ppm, length: 50 )
• attach_guid ( type: esriFieldTypeString, alias: attach_guid, length: 36 )
• attach_filename ( type: esriFieldTypeString, alias: attach_filename, length: 260 )
• attach_filepath ( type: esriFieldTypeString, alias: attach_filepath, length: 1073741822 )
• attach_fullpath ( type: esriFieldTypeString, alias: attach_fullpath, length: 1073741822 )
• POINT_X ( type: esriFieldTypeString, alias: POINT_X, length: 20 )
• POINT_Y ( type: esriFieldTypeString, alias: POINT_Y, length: 20 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• energov.SDE.HealthFoodPermits (1) -- Related To: Food Permits (0)
• energov.SDE.HealthFoodPermits (3) -- Related To: Mobile & Temporary Food Vendors (1)
• energov.SDE.HealthFoodPermits (5) -- Related To: Trades Day & Farmers Market (2)
• energov.SDE.HealthFoodPermits (7) -- Related To: Schools & Daycares (3)

Tables:

Table: Attachments (5)

Name: Attachments

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )
• REL_OBJECTID ( type: esriFieldTypeInteger, alias: REL_OBJECTID )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )