Name: survey
Display Field: objectid
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: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)
Drawing Info:
{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Kitchen Inspection Form","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false
HasM: false
Has Attachments: true
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: objectid
Unique ID Field:
IsSystemMaintained : True
Global ID Field: globalid
Type ID Field:
Fields:
- objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
- inspection_date (type: esriFieldTypeDate, alias: INSPECTION DATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- auditor_name (type: esriFieldTypeString, alias: AUDITOR NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- location (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Home Plate Texas Rangers: Home Plate Texas Rangers Golf Club], [Café Lake Arlington: Café Lake Arlington Golf Club], [Ventana Grille Tierra Verde: Ventana Grille Tierra Verde Golf Club])
- time_temp_food_cooked (type: esriFieldTypeInteger, alias: Food cooked to Proper Temperature, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- time_temp_food_cooked_c (type: esriFieldTypeString, alias: Food Cooked Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- time_temp_proper_cooling (type: esriFieldTypeInteger, alias: Proper Cooling Time and Temperature, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- time_temp_proper_cooling_c (type: esriFieldTypeString, alias: Proper Cooling Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- time_temp_proper_cold (type: esriFieldTypeInteger, alias: Proper Cold Holding Temperature (refrigeration 39 or below, freezer 0 or below), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- time_temp_proper_cold_c (type: esriFieldTypeString, alias: Proper Cold Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- time_temp_proper_hot (type: esriFieldTypeInteger, alias: Proper Hot Holding Temperature (135 minimum), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- time_temp_proper_hot_c (type: esriFieldTypeString, alias: Proper Hot Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- time_temp_food_reheated (type: esriFieldTypeInteger, alias: Food reheated properly (to 165) and held for 2 hours or less, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- time_temp_food_reheated_c (type: esriFieldTypeString, alias: Food Reheated Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- time_temp_labeled_dated (type: esriFieldTypeInteger, alias: All Items are clearly Labeled and are Dated, if not, they are discarded, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- time_temp_labeled_dated_c (type: esriFieldTypeString, alias: Labeled Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- time_temp_toss_outdated (type: esriFieldTypeInteger, alias: Time as a Public Health Control, procedures (toss if outdated), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- time_temp_toss_outdated_c (type: esriFieldTypeString, alias: Toss Outdated Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- approved_source_food_ice (type: esriFieldTypeInteger, alias: Food and Ice purchased from approved source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- approved_source_food_ice_c (type: esriFieldTypeString, alias: Food And Ice Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- approved_source_food_condition (type: esriFieldTypeInteger, alias: Food in condition upon arrival, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- approved_source_food_conditin_c (type: esriFieldTypeString, alias: Food Arrival Condition Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- approved_source_proper_temp (type: esriFieldTypeInteger, alias: Food Received Proper Temperature, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- approved_source_proper_temp_c (type: esriFieldTypeString, alias: Food Received Temp Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- protect_contam_food_protected (type: esriFieldTypeInteger, alias: Food Protected from Cross Contamination, storage hierarchy utilized properly, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- protect_contam_food_protected_c (type: esriFieldTypeString, alias: Food Protected Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- protect_contam_sanitizer_used (type: esriFieldTypeInteger, alias: Sanitizer Buckets and/or Spray Bottles are evident and in use, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- protect_contam_sanitizer_used_c (type: esriFieldTypeString, alias: Sanitizer Buckets Spray Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- protect_contam_quaternary_used (type: esriFieldTypeInteger, alias: Quaternary Sanitizer used, Test Strips available, and is at proper Concentration, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- protect_contam_quaternary_usd_c (type: esriFieldTypeString, alias: Quaternary Sanitizer Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- protect_contam_surface_sanitize (type: esriFieldTypeInteger, alias: Food Contact Surfaces Cleaned and Sanitized, including all kitchen equipment, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- protect_contam_surface_sanitz_c (type: esriFieldTypeString, alias: Food Contact Surfaces Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- protect_contam_proper_returned (type: esriFieldTypeInteger, alias: Proper Disposition of Returned and/or Previously served Items, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- protect_contam_proper_returnd_c (type: esriFieldTypeString, alias: Proper Returned Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- employee_health_sick_notallowed (type: esriFieldTypeInteger, alias: Sick Employees not allowed to work (Fever or Discharge), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- employee_health_sick_notallwd_c (type: esriFieldTypeString, alias: Sick Employees Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- prevent_contam_hands_cleaned (type: esriFieldTypeInteger, alias: Hands Cleaned and Washed Properly (changing tasks and changing gloves), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- prevent_contam_hands_cleaned_c (type: esriFieldTypeString, alias: Hands Cleaned Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- prevent_contam_gloves_used (type: esriFieldTypeInteger, alias: Gloves used Properly, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- prevent_contam_gloves_used_c (type: esriFieldTypeString, alias: Gloves Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- prevent_contam_no_barehands (type: esriFieldTypeInteger, alias: No Bare Hand contact with Ready to Eat Food, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- prevent_contam_no_barehands_c (type: esriFieldTypeString, alias: No Bare Hand Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- chemicals_fruitveg_washed (type: esriFieldTypeInteger, alias: Fruits and vegetables are washed, approved Chemical used as directed, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- chemicals_fruitveg_washed_c (type: esriFieldTypeString, alias: Fruits And Vegetables Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- chemicals_toxics_labeled (type: esriFieldTypeInteger, alias: Toxic Substances properly labeled with SDS sticker, and Properly Stored and Used, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- chemicals_toxics_labeled_c (type: esriFieldTypeString, alias: Toxic Substances Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- chemicals_no_moldpresent (type: esriFieldTypeInteger, alias: No Mold Present in Operation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- chemicals_no_moldpresent_c (type: esriFieldTypeString, alias: No Mold Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- water_plumbing_proper_water (type: esriFieldTypeInteger, alias: Water from Approved Source, Plumbing Installed, Proper Backflow Devices, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- water_plumbing_proper_water_c (type: esriFieldTypeString, alias: Water From Approved Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- water_plumbing_proper_sewage (type: esriFieldTypeInteger, alias: Approved Sewage/Wastewater Disposal System, Proper Disposal, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
- water_plumbing_proper_sewage_c (type: esriFieldTypeString, alias: Approved Sewage Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- dem_know_cert_foodsafetymgr (type: esriFieldTypeInteger, alias: Certified Food Safety Manager is Present, demonstrates Knowledge and performs Duties, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- dem_know_cert_foodsafetymgr_c (type: esriFieldTypeString, alias: Certified Food Safety Manager Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- dem_know_reg_foodsafetymgr (type: esriFieldTypeInteger, alias: A Minimum of one Certified Food Safety Manager is registered with the City, registration publicly posted, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- dem_know_reg_foodsafetymgr_c (type: esriFieldTypeString, alias: Registered Food Safety Manager Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- dem_know_cert_foodhandlers (type: esriFieldTypeInteger, alias: All Personnel in Operation have Current Food Handlers Certification, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- dem_know_cert_foodhandlers_c (type: esriFieldTypeString, alias: Certified Food Handlers Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- dem_know_no_outsidepersonnel (type: esriFieldTypeInteger, alias: No Outside Personnel in Operation (Uncertified), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- dem_know_no_outsidepersonnel_c (type: esriFieldTypeString, alias: No Outside Personnel Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- safe_waterrecs_hotcold_water (type: esriFieldTypeInteger, alias: Hot and Cold Water Available, adequate Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- safe_waterrecs_hotcold_water_c (type: esriFieldTypeString, alias: Hot And Cold Water Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- safe_waterrecs_req_recordsavail (type: esriFieldTypeInteger, alias: Required records available (shellfish tags) and Packaged Food is Labeled properly, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- safe_waterrecs_req_recordsavl_c (type: esriFieldTypeString, alias: Required Records Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- consumer_advisory_posted_asreq (type: esriFieldTypeInteger, alias: Posting of Consumer Advisories as required, Raw or Undercooked Foods, Allergen Labels as required (pre-packaged food), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- consumer_advisory_posted_asrq_c (type: esriFieldTypeString, alias: Consumer Advisories Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- foodtemp_control_proper_cooling (type: esriFieldTypeInteger, alias: Proper Cooling methods utilized, cool to 70 degrees within 2 hours, 41 within another 4 hours, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- foodtemp_control_proper_coolg_c (type: esriFieldTypeString, alias: Proper Cooling Methods Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- foodtemp_control_equip_adequate (type: esriFieldTypeInteger, alias: Equipment is adequate to maintain product temperature, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- foodtemp_control_equip_adequt_c (type: esriFieldTypeString, alias: Equipment Adequate Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- foodtemp_control_proper_dating (type: esriFieldTypeInteger, alias: Proper date marking is utilized, Disposition of out of date product is evident, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- foodtemp_control_proper_datg_c (type: esriFieldTypeString, alias: Proper Date Marking Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- foodtemp_control_thermometers (type: esriFieldTypeInteger, alias: Thermometers are provided, are calibrated, and are accurate, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- foodtemp_control_thermometers_c (type: esriFieldTypeString, alias: Thermometers Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- permit_req_food_permitdisplayed (type: esriFieldTypeInteger, alias: Food Establishment permit is current, valid, and publicly displayed, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- permit_req_food_permitdisplyd_c (type: esriFieldTypeString, alias: Permit Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- utensil_equip_handwash_facility (type: esriFieldTypeInteger, alias: Adequate hand washing facilities, accessible, properly supplied, and properly used, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- utensil_equip_handwash_faclty_c (type: esriFieldTypeString, alias: Hand Washing Facilities Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- utensil_equip_warewash_facility (type: esriFieldTypeInteger, alias: Warewashing facilities, installed, maintained, and properly used, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- utensil_equip_warewash_faclty_c (type: esriFieldTypeString, alias: Warewashing Facilities Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- utensil_equip_food_surfaces (type: esriFieldTypeInteger, alias: Food and non contact food surfaces are cleanable, and are properly designed, constructed, and used (includes small equipment such as can opener), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- utensil_equip_food_surfaces_c (type: esriFieldTypeString, alias: Cleanable Food Services Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- utensil_equip_no_dentedopencans (type: esriFieldTypeInteger, alias: No dented Cans in operation, and opened can contents are placed in a food service container, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- utensil_equip_no_dentedopncan_c (type: esriFieldTypeString, alias: No Dented Cans Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- utensil_equip_approved_utensils (type: esriFieldTypeInteger, alias: Approved utensils used in operations, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Yes], [0: No])
- utensil_equip_approved_utensl_c (type: esriFieldTypeString, alias: Approved Utensils Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- prevent_contam_no_animalcontam (type: esriFieldTypeInteger, alias: No evidence of insect, rodent or other animal contamination, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- prevent_contam_no_animalcontm_c (type: esriFieldTypeString, alias: Animal Contamination Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- prevent_contam_pestcontrol_reps (type: esriFieldTypeInteger, alias: Pest Control Reports maintained on site, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- prevent_contam_pestcontrol_rp_c (type: esriFieldTypeString, alias: Pest Control Reports Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- prevent_contam_personal_clean (type: esriFieldTypeInteger, alias: Personal Cleanliness, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- prevent_contam_personal_clean_c (type: esriFieldTypeString, alias: Personal Cleanliness Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- prevent_contam_no_eatdrinksmoke (type: esriFieldTypeInteger, alias: No Eating, Drinking or Tobacco use in food service areas, drinks covered and with a straw, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- prevent_contam_no_eatdrinksmk_c (type: esriFieldTypeString, alias: No Eating, Drinking Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- prevent_contam_empfood_separate (type: esriFieldTypeInteger, alias: Employee food stored separately from restaurant food, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- prevent_contam_empfood_separt_c (type: esriFieldTypeString, alias: Employee Food Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- prevent_contam_wipecloth_stored (type: esriFieldTypeInteger, alias: Wiping cloths properly stored in sanitizer or cleaning solution and properly used, not used for any other purpose, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- prevent_contam_wipecloth_strd_c (type: esriFieldTypeString, alias: Wiping Cloths Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- prevent_contam_items_covered (type: esriFieldTypeInteger, alias: Environmental Contamination, all items are covered and not subject to outside contamination, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- prevent_contam_items_covered_c (type: esriFieldTypeString, alias: Environmental Contamination Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- prevent_contam_approved_thawing (type: esriFieldTypeInteger, alias: Approved thawing method utilized, 1 of 3: in refrigerator, under running water, or in a microwave, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- prevent_contam_approved_thawg_c (type: esriFieldTypeString, alias: Approved Thawing Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- proper_utensil_storage_handling (type: esriFieldTypeInteger, alias: Utensils, smallwares, linens: properly stored, used, cleaned, dried and handled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- proper_utensil_storage_handlg_c (type: esriFieldTypeString, alias: Utensils, Smallwares Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- proper_utensil_singleuse_stored (type: esriFieldTypeInteger, alias: Single service and single use items properly stored and used, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- proper_utensil_singleuse_strd_c (type: esriFieldTypeString, alias: Single Service Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- food_id_proper_containerlabels (type: esriFieldTypeInteger, alias: Original container labeling, properly identified, date received and date opened, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- food_id_proper_containerlabls_c (type: esriFieldTypeString, alias: Original Container Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- physical_fac_nonfoodsurf_clean (type: esriFieldTypeInteger, alias: Non food contact surfaces are clean, including ovens, grills, storage bins, coolers, shelving, cooler gaskets, floors…, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- physical_fac_nonfoodsurf_cln_c (type: esriFieldTypeString, alias: Non Food Contact Surfaces Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- physical_fac_adequate_ventlight (type: esriFieldTypeInteger, alias: Adequate ventilation and lighting, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- physical_fac_adequate_ventlit_c (type: esriFieldTypeString, alias: Ventilation And Lighting Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- physical_fac_proper_garbaging (type: esriFieldTypeInteger, alias: Garbage disposed of properly, facilities properly maintained, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- physical_fac_proper_garbaging_c (type: esriFieldTypeString, alias: Garbage Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- physical_fac_proper_toileting (type: esriFieldTypeInteger, alias: Toilet Facilities properly installed, maintained, clean, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
- physical_fac_proper_toileting_c (type: esriFieldTypeString, alias: Toilet Facilities Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- audit_score (type: esriFieldTypeInteger, alias: Audit Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
- comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- date_signed (type: esriFieldTypeDate, alias: Date signed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- 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)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/21/2026 4:44:39 PM
Schema Last Edit Date: 9/21/2026 2:25:15 PM
Data Last Edit Date: 9/21/2026 4:44:39 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Attachments
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat