Name: Food Inspections

Display Field: permitted_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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)  LatestVCSWkid(0)

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:

Feature Draw Order:

N/A

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

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:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata