{ "tables": [], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 33.79932022100007, "xmin": -111.96487248599999, "ymax": 33.84542945700008, "xmax": -111.87449792999996, "spatialReference": { "falseM": -100000, "xyTolerance": 8.983152841195215E-9, "mUnits": 10000, "zUnits": 10000, "latestWkid": 4326, "zTolerance": 0.001, "wkid": 4326, "xyUnits": 9.999999999999999E8, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": true, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "inventory_120Water", "allowTrueCurvesUpdates": false, "displayField": "location_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "locationid_external", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "locationid_external", "length": 2147483647, "alias": "EXTERNAL LOCATION ID", "type": "esriFieldTypeString" }, { "modelName": "customerid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "customerid", "length": 2147483647, "alias": "CUSTOMER ID", "type": "esriFieldTypeString" }, { "modelName": "assetid_120water", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assetid_120water", "alias": "120WATER ASSET ID", "type": "esriFieldTypeInteger" }, { "modelName": "assetid_external", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assetid_external", "length": 2147483647, "alias": "EXTERNAL ASSET ID", "type": "esriFieldTypeString" }, { "modelName": "address1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address1", "length": 50, "alias": "ADDRESS LINE 1", "type": "esriFieldTypeString" }, { "modelName": "address2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address2", "length": 2147483647, "alias": "ADDRESS LINE 2", "type": "esriFieldTypeString" }, { "modelName": "city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 2147483647, "alias": "CITY", "type": "esriFieldTypeString" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 2147483647, "alias": "STATE", "type": "esriFieldTypeString" }, { "modelName": "zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 2147483647, "alias": "ZIP", "type": "esriFieldTypeString" }, { "modelName": "county", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "county", "length": 2147483647, "alias": "COUNTY", "type": "esriFieldTypeString" }, { "modelName": "mailing_address1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mailing_address1", "length": 2147483647, "alias": "MAILING ADDRESS LINE 1", "type": "esriFieldTypeString" }, { "modelName": "mailing_address2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mailing_address2", "length": 2147483647, "alias": "MAILING ADDRESS LINE 2", "type": "esriFieldTypeString" }, { "modelName": "mailing_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mailing_city", "length": 2147483647, "alias": "MAILING CITY", "type": "esriFieldTypeString" }, { "modelName": "mailing_state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mailing_state", "length": 2147483647, "alias": "MAILING STATE", "type": "esriFieldTypeString" }, { "modelName": "mailing_zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mailing_zip", "length": 2147483647, "alias": "MAILING ZIP", "type": "esriFieldTypeString" }, { "modelName": "building", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "building", "length": 2147483647, "alias": "BUILDING", "type": "esriFieldTypeString" }, { "modelName": "neighborhood", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "neighborhood", "length": 2147483647, "alias": "NEIGHBORHOOD", "type": "esriFieldTypeString" }, { "modelName": "location_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location_name", "length": 2147483647, "alias": "LOCATION NAME", "type": "esriFieldTypeString" }, { "modelName": "latitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latitude", "alias": "LATITUDE", "type": "esriFieldTypeDouble" }, { "modelName": "longitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longitude", "alias": "LONGITUDE", "type": "esriFieldTypeDouble" }, { "modelName": "locationid_gis", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "locationid_gis", "length": 2147483647, "alias": "GIS LOCATION ID", "type": "esriFieldTypeString" }, { "modelName": "dwelr_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dwelr_code", "length": 2147483647, "alias": "DWELR CODE", "type": "esriFieldTypeString" }, { "modelName": "lcr_tier", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lcr_tier", "length": 2147483647, "alias": "LCR TIER", "type": "esriFieldTypeString" }, { "modelName": "property_class", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PropertyClass", "description": "", "type": "codedValue", "codedValues": [ { "code": "SingleFamilyResidence", "name": "SingleFamilyResidence" }, { "code": "Single Family Residence", "name": "Single Family Residence" }, { "code": "Commercial", "name": "Commercial" }, { "code": "Industrial", "name": "Industrial" }, { "code": "Public", "name": "Public" }, { "code": "MultiFamilyResidence", "name": "MultiFamilyResidence" }, { "code": "Multi-Family Residence", "name": "Multi-Family Residence" }, { "code": "ElementarySchool", "name": "ElementarySchool" }, { "code": "Elementary School", "name": "Elementary School" }, { "code": "SecondarySchool", "name": "SecondarySchool" }, { "code": "Secondary School", "name": "Secondary School" }, { "code": "ChildcareFacility", "name": "ChildcareFacility" }, { "code": "Childcare Facility", "name": "Childcare Facility" }, { "code": "NonResidential", "name": "NonResidential" }, { "code": "Non-Residential", "name": "Non-Residential" }, { "code": "SingleFamilyResidenceWChildcare", "name": "SingleFamilyResidenceWChildcare" }, { "code": "Single Family Residence w/ Childcare", "name": "Single Family Residence w/ Childcare" }, { "code": "MultiFamilyResidenceWChildcare", "name": "MultiFamilyResidenceWChildcare" }, { "code": "Multi-Family Residence w/ Childcare", "name": "Multi-Family Residence w/ Childcare" }, { "code": "HospitalOrMedicalCareFacility", "name": "HospitalOrMedicalCareFacility" }, { "code": "Hospital or Medical Care Facility", "name": "Hospital or Medical Care Facility" }, { "code": "NursingHome", "name": "NursingHome" }, { "code": "Nursing Home", "name": "Nursing Home" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "property_class", "length": 2147483647, "alias": "PROPERTY CLASSIFICATION", "type": "esriFieldTypeString" }, { "modelName": "parcel_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parcel_number", "length": 2147483647, "alias": "PARCEL NUMBER", "type": "esriFieldTypeString" }, { "modelName": "yrbuilt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "yrbuilt", "alias": "YEAR BUILT", "type": "esriFieldTypeSmallInteger" }, { "modelName": "lot_sqfeet", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lot_sqfeet", "alias": "LOT SQUARE FEET", "type": "esriFieldTypeDouble" }, { "modelName": "main_material", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "main_material", "length": 2147483647, "alias": "WATER MAIN MATERIAL", "type": "esriFieldTypeString" }, { "modelName": "main_size", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "main_size", "alias": "WATER MAIN SIZE", "type": "esriFieldTypeDouble" }, { "modelName": "main_install_year", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "main_install_year", "alias": "WATER MAIN INSTALLED YEAR", "type": "esriFieldTypeSmallInteger" }, { "modelName": "curb_size", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "curb_size", "alias": "CURB STOP SIZE", "type": "esriFieldTypeDouble" }, { "modelName": "curb_install_year", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "curb_install_year", "alias": "CURB STOP INSTALLED YEAR", "type": "esriFieldTypeSmallInteger" }, { "modelName": "meter_material", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "meter_material", "length": 2147483647, "alias": "METER MATERIAL", "type": "esriFieldTypeString" }, { "modelName": "meter_size", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "meter_size", "alias": "METER SIZE", "type": "esriFieldTypeDouble" }, { "modelName": "meter_install_year", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "meter_install_year", "alias": "METER INSTALLED YEAR", "type": "esriFieldTypeSmallInteger" }, { "modelName": "other_buildings", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TrueFalse", "description": "", "type": "codedValue", "codedValues": [ { "code": "False", "name": "False" }, { "code": "True", "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "other_buildings", "length": 2147483647, "alias": "OTHER BUILDINGS ON PROPERTY", "type": "esriFieldTypeString" }, { "modelName": "children_under_7", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TrueFalse", "description": "", "type": "codedValue", "codedValues": [ { "code": "False", "name": "False" }, { "code": "True", "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "children_under_7", "length": 2147483647, "alias": "HAS CHILDREN UNDER 7", "type": "esriFieldTypeString" }, { "modelName": "pregnant_women", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TrueFalse", "description": "", "type": "codedValue", "codedValues": [ { "code": "False", "name": "False" }, { "code": "True", "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "pregnant_women", "length": 2147483647, "alias": "HAS PREGNANT WOMEN", "type": "esriFieldTypeString" }, { "modelName": "disadvantaged_neighborhood", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TrueFalse", "description": "", "type": "codedValue", "codedValues": [ { "code": "False", "name": "False" }, { "code": "True", "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "disadvantaged_neighborhood", "length": 2147483647, "alias": "DISADVANTAGED NEIGHBORHOOD", "type": "esriFieldTypeString" }, { "modelName": "owned_by_business", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TrueFalse", "description": "", "type": "codedValue", "codedValues": [ { "code": "False", "name": "False" }, { "code": "True", "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "owned_by_business", "length": 2147483647, "alias": "PROPERTY OWNED BY BUSINESS", "type": "esriFieldTypeString" }, { "modelName": "business_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "business_name", "length": 2147483647, "alias": "BUSINESS NAME", "type": "esriFieldTypeString" }, { "modelName": "estimated_value", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "estimated_value", "length": 2147483647, "alias": "ESTIMATED HOME VALUE", "type": "esriFieldTypeString" }, { "modelName": "notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 2147483647, "alias": "NOTES", "type": "esriFieldTypeString" }, { "modelName": "point_of_entry", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNoUnknown", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "point_of_entry", "length": 2147483647, "alias": "POINT OF ENTRY OR POINT OF USE TREATMENT", "type": "esriFieldTypeString" }, { "modelName": "plumbing_lead_solder", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNoUnknown", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "plumbing_lead_solder", "length": 2147483647, "alias": "BUILDING PLUMBING LEAD SOLDER", "type": "esriFieldTypeString" }, { "modelName": "sample_site", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNoUnknown", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "sample_site", "length": 2147483647, "alias": "CURRENT LCR SAMPLING SITE", "type": "esriFieldTypeString" }, { "modelName": "sensitive_pop", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sensitive_pop", "length": 2147483647, "alias": "SENSITIVE POPULATION", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 2147483647, "alias": "DESCRIPTION", "type": "esriFieldTypeString" }, { "modelName": "status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 2147483647, "alias": "STATUS", "type": "esriFieldTypeString" }, { "modelName": "cust_material", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Material", "description": "", "type": "codedValue", "codedValues": [ { "code": "UNK", "name": "Unknown - Material Unknown" }, { "code": "LLD", "name": "Unknown - Likely Lead" }, { "code": "LEAD", "name": "Lead" }, { "code": "ASB", "name": "Non-Lead - Asbestos Cement" }, { "code": "CI", "name": "Non-Lead - Cast Iron" }, { "code": "HDPE", "name": "Non-Lead - HDPE" }, { "code": "PB", "name": "Non-Lead - Polybutylene" }, { "code": "PE", "name": "Non-Lead - Polyethylene" }, { "code": "PVC", "name": "Non-Lead - PVC" }, { "code": "ST", "name": "Non-Lead - Steel" }, { "code": "NL", "name": "Non-Lead - Other" }, { "code": "NA", "name": "N/A - Single Ownership" }, { "code": "LNLD", "name": "Unknown - Unlikely Lead" }, { "code": "LGI", "name": "Unknown - Likely Galvanized Iron/Steel" }, { "code": "WI", "name": "Non-Lead - Wrought Iron" }, { "code": "DI", "name": "Non-Lead - Ductile Iron" }, { "code": "CU", "name": "Non-Lead - Copper" }, { "code": "BR", "name": "Non-Lead - Brass" }, { "code": "PLAST", "name": "Non-Lead - Plastic" }, { "code": "GRR", "name": "Galvanized Iron/Steel - Requiring Replacement" }, { "code": "GNRR", "name": "Galvanized Iron/Steel - No Lead Contact" }, { "code": "LLGI", "name": "Lead-Lined Galvanized Iron/Steel" }, { "code": "GI", "name": "Galvanized Iron/Steel - Lead Contact Unknown" }, { "code": "SST", "name": "Non-Lead - Stainless Steel" }, { "code": "PEX", "name": "Non-Lead - PEX" }, { "code": "ABS", "name": "Non-Lead - ABS" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "cust_material", "length": 2147483647, "alias": "CUSTOMER OWNED MATERIAL", "type": "esriFieldTypeString" }, { "modelName": "cust_lead_solder", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNoUnknown", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "cust_lead_solder", "length": 2147483647, "alias": "CUSTOMER OWNED LEAD SOLDER", "type": "esriFieldTypeString" }, { "modelName": "cust_verif_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cust_verif_by", "length": 2147483647, "alias": "CUSTOMER OWNED VERIFIED BY", "type": "esriFieldTypeString" }, { "modelName": "cust_verif_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "cust_verif_date", "length": 29, "alias": "CUSTOMER OWNED VERIFIED DATE", "type": "esriFieldTypeDate" }, { "modelName": "cust_verif_method", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "VerificationMethod", "description": "", "type": "codedValue", "codedValues": [ { "code": "VisualExcavation", "name": "VisualExcavation" }, { "code": "Visual - Excavation", "name": "Visual - Excavation" }, { "code": "Records", "name": "Records" }, { "code": "Age", "name": "Age" }, { "code": "Other", "name": "Other" }, { "code": "Visual", "name": "Visual" }, { "code": "VisualSwab", "name": "VisualSwab" }, { "code": "Visual - Swab", "name": "Visual - Swab" }, { "code": "VisualMeter", "name": "VisualMeter" }, { "code": "Visual Inspection at the Meter Pit", "name": "Visual Inspection at the Meter Pit" }, { "code": "VisualAtInsideBuilding", "name": "VisualAtInsideBuilding" }, { "code": "Visual Inspection at/inside Building", "name": "Visual Inspection at/inside Building" }, { "code": "Customer", "name": "Customer" }, { "code": "Customer Self-Identification", "name": "Customer Self-Identification" }, { "code": "CctvInternal", "name": "CctvInternal" }, { "code": "CCTV Inspection at Curb Box - Internal", "name": "CCTV Inspection at Curb Box - Internal" }, { "code": "CctvExternal", "name": "CctvExternal" }, { "code": "CCTV Inspection at Curb Box - External", "name": "CCTV Inspection at Curb Box - External" }, { "code": "MechanicalExcavation", "name": "MechanicalExcavation" }, { "code": "Mechanical Excavation", "name": "Mechanical Excavation" }, { "code": "VacuumExcavation", "name": "VacuumExcavation" }, { "code": "Vacuum Excavation", "name": "Vacuum Excavation" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "cust_verif_method", "length": 2147483647, "alias": "CUSTOMER OWNED VERIFICATION METHOD", "type": "esriFieldTypeString" }, { "modelName": "cust_removal_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "cust_removal_date", "length": 29, "alias": "CUSTOMER OWNED REMOVAL DATE", "type": "esriFieldTypeDate" }, { "modelName": "cust_install_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "cust_install_date", "length": 29, "alias": "CUSTOMER OWNED INSTALLED DATE", "type": "esriFieldTypeDate" }, { "modelName": "cust_depth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cust_depth", "alias": "CUSTOMER OWNED LINE DEPTH", "type": "esriFieldTypeSmallInteger" }, { "modelName": "cust_diameter", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Diameter", "description": "", "type": "codedValue", "codedValues": [ { "code": "0.375", "name": "3/8\"" }, { "code": "0.5", "name": "1/2\"" }, { "code": "0.625", "name": "5/8\"" }, { "code": "0.75", "name": "3/4\"" }, { "code": "1.0", "name": "1\"" }, { "code": "1.25", "name": "1-1/4\"" }, { "code": "1.5", "name": "1-1/2\"" }, { "code": "1.75", "name": "1-3/4\"\"" }, { "code": "2.0", "name": "2\"" }, { "code": "3.0", "name": "3\"" }, { "code": "4.0", "name": "4\"" }, { "code": "6.0", "name": "6\"" }, { "code": "8.0", "name": "8\"" }, { "code": "10.0", "name": "10\"" }, { "code": "12.0", "name": "12\"" }, { "code": "14.0", "name": "14\"" }, { "code": "16.0", "name": "16\"" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "cust_diameter", "length": 2147483647, "alias": "CUSTOMER OWNED LINE DIAMETER", "type": "esriFieldTypeString" }, { "modelName": "util_material", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Material", "description": "", "type": "codedValue", "codedValues": [ { "code": "UNK", "name": "Unknown - Material Unknown" }, { "code": "LLD", "name": "Unknown - Likely Lead" }, { "code": "LEAD", "name": "Lead" }, { "code": "ASB", "name": "Non-Lead - Asbestos Cement" }, { "code": "CI", "name": "Non-Lead - Cast Iron" }, { "code": "HDPE", "name": "Non-Lead - HDPE" }, { "code": "PB", "name": "Non-Lead - Polybutylene" }, { "code": "PE", "name": "Non-Lead - Polyethylene" }, { "code": "PVC", "name": "Non-Lead - PVC" }, { "code": "ST", "name": "Non-Lead - Steel" }, { "code": "NL", "name": "Non-Lead - Other" }, { "code": "NA", "name": "N/A - Single Ownership" }, { "code": "LNLD", "name": "Unknown - Unlikely Lead" }, { "code": "LGI", "name": "Unknown - Likely Galvanized Iron/Steel" }, { "code": "WI", "name": "Non-Lead - Wrought Iron" }, { "code": "DI", "name": "Non-Lead - Ductile Iron" }, { "code": "CU", "name": "Non-Lead - Copper" }, { "code": "BR", "name": "Non-Lead - Brass" }, { "code": "PLAST", "name": "Non-Lead - Plastic" }, { "code": "GRR", "name": "Galvanized Iron/Steel - Requiring Replacement" }, { "code": "GNRR", "name": "Galvanized Iron/Steel - No Lead Contact" }, { "code": "LLGI", "name": "Lead-Lined Galvanized Iron/Steel" }, { "code": "GI", "name": "Galvanized Iron/Steel - Lead Contact Unknown" }, { "code": "SST", "name": "Non-Lead - Stainless Steel" }, { "code": "PEX", "name": "Non-Lead - PEX" }, { "code": "ABS", "name": "Non-Lead - ABS" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "util_material", "length": 2147483647, "alias": "SYSTEM OWNED MATERIAL", "type": "esriFieldTypeString" }, { "modelName": "util_lead_solder", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNoUnknown", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "util_lead_solder", "length": 2147483647, "alias": "SYSTEM OWNED LEAD SOLDER", "type": "esriFieldTypeString" }, { "modelName": "util_verif_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "util_verif_by", "length": 2147483647, "alias": "SYSTEM OWNED VERIFIED BY", "type": "esriFieldTypeString" }, { "modelName": "util_verif_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "util_verif_date", "length": 29, "alias": "SYSTEM OWNED VERIFIED DATE", "type": "esriFieldTypeDate" }, { "modelName": "util_verif_method", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "VerificationMethod", "description": "", "type": "codedValue", "codedValues": [ { "code": "VisualExcavation", "name": "VisualExcavation" }, { "code": "Visual - Excavation", "name": "Visual - Excavation" }, { "code": "Records", "name": "Records" }, { "code": "Age", "name": "Age" }, { "code": "Other", "name": "Other" }, { "code": "Visual", "name": "Visual" }, { "code": "VisualSwab", "name": "VisualSwab" }, { "code": "Visual - Swab", "name": "Visual - Swab" }, { "code": "VisualMeter", "name": "VisualMeter" }, { "code": "Visual Inspection at the Meter Pit", "name": "Visual Inspection at the Meter Pit" }, { "code": "VisualAtInsideBuilding", "name": "VisualAtInsideBuilding" }, { "code": "Visual Inspection at/inside Building", "name": "Visual Inspection at/inside Building" }, { "code": "Customer", "name": "Customer" }, { "code": "Customer Self-Identification", "name": "Customer Self-Identification" }, { "code": "CctvInternal", "name": "CctvInternal" }, { "code": "CCTV Inspection at Curb Box - Internal", "name": "CCTV Inspection at Curb Box - Internal" }, { "code": "CctvExternal", "name": "CctvExternal" }, { "code": "CCTV Inspection at Curb Box - External", "name": "CCTV Inspection at Curb Box - External" }, { "code": "MechanicalExcavation", "name": "MechanicalExcavation" }, { "code": "Mechanical Excavation", "name": "Mechanical Excavation" }, { "code": "VacuumExcavation", "name": "VacuumExcavation" }, { "code": "Vacuum Excavation", "name": "Vacuum Excavation" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "util_verif_method", "length": 2147483647, "alias": "SYSTEM OWNED VERIFICATION METHOD", "type": "esriFieldTypeString" }, { "modelName": "util_removal_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "util_removal_date", "length": 29, "alias": "SYSTEM OWNED REMOVAL DATE", "type": "esriFieldTypeDate" }, { "modelName": "util_install_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "util_install_date", "length": 29, "alias": "SYSTEM OWNED INSTALLED DATE", "type": "esriFieldTypeDate" }, { "modelName": "util_depth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "util_depth", "alias": "SYSTEM OWNED LINE DEPTH", "type": "esriFieldTypeSmallInteger" }, { "modelName": "util_diameter", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Diameter", "description": "", "type": "codedValue", "codedValues": [ { "code": "0.375", "name": "3/8\"" }, { "code": "0.5", "name": "1/2\"" }, { "code": "0.625", "name": "5/8\"" }, { "code": "0.75", "name": "3/4\"" }, { "code": "1.0", "name": "1\"" }, { "code": "1.25", "name": "1-1/4\"" }, { "code": "1.5", "name": "1-1/2\"" }, { "code": "1.75", "name": "1-3/4\"\"" }, { "code": "2.0", "name": "2\"" }, { "code": "3.0", "name": "3\"" }, { "code": "4.0", "name": "4\"" }, { "code": "6.0", "name": "6\"" }, { "code": "8.0", "name": "8\"" }, { "code": "10.0", "name": "10\"" }, { "code": "12.0", "name": "12\"" }, { "code": "14.0", "name": "14\"" }, { "code": "16.0", "name": "16\"" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "util_diameter", "length": 2147483647, "alias": "SYSTEM OWNED LINE DIAMETER", "type": "esriFieldTypeString" }, { "modelName": "lead_fitting", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNoUnknown", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lead_fitting", "length": 2147483647, "alias": "LEAD FITTINGS", "type": "esriFieldTypeString" }, { "modelName": "fitting_verif_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fitting_verif_by", "length": 2147483647, "alias": "FITTING VERIFIED BY", "type": "esriFieldTypeString" }, { "modelName": "fitting_verif_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "fitting_verif_date", "length": 29, "alias": "FITTINGS VERIFIED DATE", "type": "esriFieldTypeDate" }, { "modelName": "fitting_verif_method", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "VerificationMethod", "description": "", "type": "codedValue", "codedValues": [ { "code": "VisualExcavation", "name": "VisualExcavation" }, { "code": "Visual - Excavation", "name": "Visual - Excavation" }, { "code": "Records", "name": "Records" }, { "code": "Age", "name": "Age" }, { "code": "Other", "name": "Other" }, { "code": "Visual", "name": "Visual" }, { "code": "VisualSwab", "name": "VisualSwab" }, { "code": "Visual - Swab", "name": "Visual - Swab" }, { "code": "VisualMeter", "name": "VisualMeter" }, { "code": "Visual Inspection at the Meter Pit", "name": "Visual Inspection at the Meter Pit" }, { "code": "VisualAtInsideBuilding", "name": "VisualAtInsideBuilding" }, { "code": "Visual Inspection at/inside Building", "name": "Visual Inspection at/inside Building" }, { "code": "Customer", "name": "Customer" }, { "code": "Customer Self-Identification", "name": "Customer Self-Identification" }, { "code": "CctvInternal", "name": "CctvInternal" }, { "code": "CCTV Inspection at Curb Box - Internal", "name": "CCTV Inspection at Curb Box - Internal" }, { "code": "CctvExternal", "name": "CctvExternal" }, { "code": "CCTV Inspection at Curb Box - External", "name": "CCTV Inspection at Curb Box - External" }, { "code": "MechanicalExcavation", "name": "MechanicalExcavation" }, { "code": "Mechanical Excavation", "name": "Mechanical Excavation" }, { "code": "VacuumExcavation", "name": "VacuumExcavation" }, { "code": "Vacuum Excavation", "name": "Vacuum Excavation" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "fitting_verif_method", "length": 2147483647, "alias": "FITTINGS VERIFICATION METHOD", "type": "esriFieldTypeString" }, { "modelName": "util_classification_method", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ClassBasis", "description": "", "type": "codedValue", "codedValues": [ { "code": "Other", "name": "Other" }, { "code": "Age", "name": "Age" }, { "code": "Modeling", "name": "Modeling" }, { "code": "Records", "name": "Records" }, { "code": "Visual", "name": "Visual" }, { "code": "Excavation", "name": "Excavation" }, { "code": "Visual - Excavation", "name": "Visual - Excavation" }, { "code": "Meter", "name": "Meter" }, { "code": "Visual - Meter", "name": "Visual - Meter" }, { "code": "NotAvailable", "name": "NotAvailable" }, { "code": "N/A", "name": "N/A" }, { "code": "PredictiveModeling", "name": "PredictiveModeling" }, { "code": "Predictive Modeling", "name": "Predictive Modeling" }, { "code": "Swab", "name": "Swab" }, { "code": "Visual - Swab", "name": "Visual - Swab" }, { "code": "WQSTargeted", "name": "WQSTargeted" }, { "code": "Water Quality Sampling - Targeted", "name": "Water Quality Sampling - Targeted" }, { "code": "WQSFlushed", "name": "WQSFlushed" }, { "code": "Water Quality Sampling - Flushed", "name": "Water Quality Sampling - Flushed" }, { "code": "WQSSequential", "name": "WQSSequential" }, { "code": "Water Quality Sampling - Sequential", "name": "Water Quality Sampling - Sequential" }, { "code": "WQSOther", "name": "WQSOther" }, { "code": "Water Quality Sampling - Other", "name": "Water Quality Sampling - Other" }, { "code": "ServiceLine2", "name": "ServiceLine2" }, { "code": "Service Line > 2\"", "name": "Service Line >2\"" }, { "code": "OperatorInterview", "name": "OperatorInterview" }, { "code": "Operator Interview", "name": "Operator Interview" }, { "code": "CustomerIdentification", "name": "CustomerIdentification" }, { "code": "Customer Identification", "name": "Customer Identification" }, { "code": "Interpolation", "name": "Interpolation" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "util_classification_method", "length": 2147483647, "alias": "SYSTEM OWNED CLASSIFICATION BASIS", "type": "esriFieldTypeString" }, { "modelName": "cust_classification_method", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ClassBasis", "description": "", "type": "codedValue", "codedValues": [ { "code": "Other", "name": "Other" }, { "code": "Age", "name": "Age" }, { "code": "Modeling", "name": "Modeling" }, { "code": "Records", "name": "Records" }, { "code": "Visual", "name": "Visual" }, { "code": "Excavation", "name": "Excavation" }, { "code": "Visual - Excavation", "name": "Visual - Excavation" }, { "code": "Meter", "name": "Meter" }, { "code": "Visual - Meter", "name": "Visual - Meter" }, { "code": "NotAvailable", "name": "NotAvailable" }, { "code": "N/A", "name": "N/A" }, { "code": "PredictiveModeling", "name": "PredictiveModeling" }, { "code": "Predictive Modeling", "name": "Predictive Modeling" }, { "code": "Swab", "name": "Swab" }, { "code": "Visual - Swab", "name": "Visual - Swab" }, { "code": "WQSTargeted", "name": "WQSTargeted" }, { "code": "Water Quality Sampling - Targeted", "name": "Water Quality Sampling - Targeted" }, { "code": "WQSFlushed", "name": "WQSFlushed" }, { "code": "Water Quality Sampling - Flushed", "name": "Water Quality Sampling - Flushed" }, { "code": "WQSSequential", "name": "WQSSequential" }, { "code": "Water Quality Sampling - Sequential", "name": "Water Quality Sampling - Sequential" }, { "code": "WQSOther", "name": "WQSOther" }, { "code": "Water Quality Sampling - Other", "name": "Water Quality Sampling - Other" }, { "code": "ServiceLine2", "name": "ServiceLine2" }, { "code": "Service Line > 2\"", "name": "Service Line >2\"" }, { "code": "OperatorInterview", "name": "OperatorInterview" }, { "code": "Operator Interview", "name": "Operator Interview" }, { "code": "CustomerIdentification", "name": "CustomerIdentification" }, { "code": "Customer Identification", "name": "Customer Identification" }, { "code": "Interpolation", "name": "Interpolation" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "cust_classification_method", "length": 2147483647, "alias": "CUSTOMER OWNED CLASSIFICATION BASIS", "type": "esriFieldTypeString" }, { "modelName": "util_notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "util_notes", "length": 2147483647, "alias": "SYSTEM OWNED NOTES", "type": "esriFieldTypeString" }, { "modelName": "cust_notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cust_notes", "length": 2147483647, "alias": "CUSTOMER OWNED NOTES", "type": "esriFieldTypeString" }, { "modelName": "util_previous_lead", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNoUnknown", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "util_previous_lead", "length": 2147483647, "alias": "SYSTEM OWNED PREVIOUSLY LEAD", "type": "esriFieldTypeString" }, { "modelName": "lead_solder", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNoUnknown", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lead_solder", "length": 2147483647, "alias": "LEAD SOLDER", "type": "esriFieldTypeString" }, { "modelName": "lead_other", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lead_other", "length": 2147483647, "alias": "OTHER LEAD EQUIPMENT", "type": "esriFieldTypeString" }, { "modelName": "cust_verif", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TrueFalse", "description": "", "type": "codedValue", "codedValues": [ { "code": "False", "name": "False" }, { "code": "True", "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "cust_verif", "length": 2147483647, "alias": "CUSTOMER OWNED VERIFIED", "type": "esriFieldTypeString" }, { "modelName": "util_verif", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TrueFalse", "description": "", "type": "codedValue", "codedValues": [ { "code": "False", "name": "False" }, { "code": "True", "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "util_verif", "length": 2147483647, "alias": "SYSTEM OWNED VERIFIED", "type": "esriFieldTypeString" }, { "modelName": "util_material_other", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "util_material_other", "length": 2147483647, "alias": "SYSTEM OWNED MATERIAL OTHER", "type": "esriFieldTypeString" }, { "modelName": "util_verif_method_other", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "util_verif_method_other", "length": 2147483647, "alias": "SYSTEM OWNED VERIFICATION METHOD OTHER", "type": "esriFieldTypeString" }, { "modelName": "cust_material_other", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cust_material_other", "length": 2147483647, "alias": "CUSTOMER OWNED MATERIAL OTHER", "type": "esriFieldTypeString" }, { "modelName": "cust_verif_method_other", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cust_verif_method_other", "length": 2147483647, "alias": "CUSTOMER OWNED VERIFICATION METHOD OTHER", "type": "esriFieldTypeString" }, { "modelName": "fitting_verif_method_other", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fitting_verif_method_other", "length": 2147483647, "alias": "FITTINGS VERIFICATION METHOD OTHER", "type": "esriFieldTypeString" }, { "modelName": "util_after_lead_ban", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "util_after_lead_ban", "length": 2147483647, "alias": "SYSTEM OWNED INSTALLED AFTER LEAD BAN", "type": "esriFieldTypeString" }, { "modelName": "cust_after_lead_ban", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cust_after_lead_ban", "length": 2147483647, "alias": "CUSTOMER OWNED INSTALLED AFTER LEAD BAN", "type": "esriFieldTypeString" }, { "modelName": "ownership", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Ownership", "description": "", "type": "codedValue", "codedValues": [ { "code": "Split", "name": "Split" }, { "code": "System-Owned", "name": "System-Owned" }, { "code": "Customer-Owned", "name": "Customer-Owned" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownership", "length": 2147483647, "alias": "OWNERSHIP", "type": "esriFieldTypeString" }, { "modelName": "util_diameter_over_2in", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "util_diameter_over_2in", "length": 2147483647, "alias": "SYSTEM OWNED DIAMETER OVER TWO INCHES", "type": "esriFieldTypeString" }, { "modelName": "cust_diameter_over_2in", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cust_diameter_over_2in", "length": 2147483647, "alias": "CUSTOMER OWNED DIAMETER OVER TWO INCHES", "type": "esriFieldTypeString" }, { "modelName": "cust_notice_complete", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TrueFalse", "description": "", "type": "codedValue", "codedValues": [ { "code": "False", "name": "False" }, { "code": "True", "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "cust_notice_complete", "length": 2147483647, "alias": "CONSUMER NOTICE COMPLETED", "type": "esriFieldTypeString" }, { "modelName": "cust_notice_complete_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "cust_notice_complete_date", "length": 29, "alias": "CONSUMER NOTICE COMPLETION DATE", "type": "esriFieldTypeDate" }, { "modelName": "cust_classification_method_notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cust_classification_method_note", "length": 2147483647, "alias": "CUSTOMER OWNED CLASSIFICATION BASIS NOTES", "type": "esriFieldTypeString" }, { "modelName": "util_classification_method_notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "util_classification_method_note", "length": 2147483647, "alias": "SYSTEM OWNED CLASSIFICATION BASIS NOTES", "type": "esriFieldTypeString" }, { "modelName": "cws_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cws_id", "length": 255, "alias": "cws_id", "type": "esriFieldTypeString" }, { "modelName": "cws_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cws_name", "length": 255, "alias": "cws_name", "type": "esriFieldTypeString" }, { "modelName": "hazenid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hazenid", "length": 255, "alias": "hazenid", "type": "esriFieldTypeString" }, { "modelName": "NEAR_FID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "near_fid", "alias": "NEAR_FID", "type": "esriFieldTypeInteger" }, { "modelName": "NEAR_DIST", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "near_dist", "alias": "NEAR_DIST", "type": "esriFieldTypeDouble" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r1588_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a1343_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "62f59b8d992b47bc9d994be8ad7be85c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [ { "templates": [ { "name": "", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "cust_verif_by": null, "county": null, "property_class": null, "util_classification_method": null, "building": null, "cust_diameter_over_2in": null, "cust_notice_complete": null, "plumbing_lead_solder": null, "state": null, "zip": null, "business_name": null, "cust_depth": null, "cust_lead_solder": null, "util_notes": null, "near_dist": null, "location_name": null, "cust_classification_method_note": null, "util_classification_method_note": null, "util_after_lead_ban": null, "point_of_entry": null, "cust_classification_method": null, "util_verif_by": null, "status": null, "main_material": null, "other_buildings": null, "city": null, "cust_notice_complete_date": null, "latitude": null, "lead_fitting": null, "hazenid": null, "cust_notes": null, "util_previous_lead": null, "util_verif": null, "mailing_address1": null, "mailing_address2": null, "cust_after_lead_ban": null, "locationid_external": null, "cws_id": null, "cust_install_date": null, "curb_size": null, "ownership": null, "fitting_verif_method_other": null, "assetid_external": null, "lot_sqfeet": null, "util_diameter": null, "notes": null, "cust_removal_date": null, "cust_material": null, "cws_name": null, "disadvantaged_neighborhood": null, "cust_verif_date": null, "lead_solder": null, "util_lead_solder": null, "parcel_number": null, "fitting_verif_by": null, "util_depth": null, "estimated_value": null, "sample_site": null, "longitude": null, "util_material": null, "cust_diameter": null, "util_verif_method": null, "owned_by_business": null, "util_verif_date": null, "curb_install_year": null, "cust_verif_method": null, "customerid": null, "neighborhood": null, "cust_material_other": null, "fitting_verif_date": null, "assetid_120water": null, "util_diameter_over_2in": null, "util_material_other": null, "cust_verif_method_other": null, "children_under_7": null, "lead_other": null, "lcr_tier": null, "description": null, "util_verif_method_other": null, "main_size": null, "util_removal_date": null, "meter_install_year": null, "meter_material": null, "util_install_date": null, "locationid_gis": null, "mailing_city": null, "mailing_state": null, "near_fid": null, "address2": null, "address1": null, "cust_verif": null, "meter_size": null, "mailing_zip": null, "main_install_year": null, "yrbuilt": null, "pregnant_women": null, "fitting_verif_method": null, "sensitive_pop": null, "dwelr_code": null } } } ], "name": "", "domains": { "util_diameter": {"type": "inherited"}, "other_buildings": {"type": "inherited"}, "children_under_7": {"type": "inherited"}, "property_class": {"type": "inherited"}, "cust_material": {"type": "inherited"}, "util_classification_method": {"type": "inherited"}, "cust_notice_complete": {"type": "inherited"}, "disadvantaged_neighborhood": {"type": "inherited"}, "plumbing_lead_solder": {"type": "inherited"}, "lead_fitting": {"type": "inherited"}, "lead_solder": {"type": "inherited"}, "util_lead_solder": {"type": "inherited"}, "util_previous_lead": {"type": "inherited"}, "util_verif": {"type": "inherited"}, "sample_site": {"type": "inherited"}, "util_material": {"type": "inherited"}, "cust_verif": {"type": "inherited"}, "cust_diameter": {"type": "inherited"}, "util_verif_method": {"type": "inherited"}, "cust_lead_solder": {"type": "inherited"}, "owned_by_business": {"type": "inherited"}, "ownership": {"type": "inherited"}, "pregnant_women": {"type": "inherited"}, "cust_verif_method": {"type": "inherited"}, "fitting_verif_method": {"type": "inherited"}, "point_of_entry": {"type": "inherited"}, "cust_classification_method": {"type": "inherited"} }, "id": null }, { "templates": [ { "name": "matched", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "cust_verif_by": null, "county": null, "property_class": null, "util_classification_method": null, "building": null, "cust_diameter_over_2in": null, "cust_notice_complete": null, "plumbing_lead_solder": null, "state": null, "zip": null, "business_name": null, "cust_depth": null, "cust_lead_solder": null, "util_notes": null, "near_dist": null, "location_name": null, "cust_classification_method_note": null, "util_classification_method_note": null, "util_after_lead_ban": null, "point_of_entry": null, "cust_classification_method": null, "util_verif_by": null, "status": "matched", "main_material": null, "other_buildings": null, "city": null, "cust_notice_complete_date": null, "latitude": null, "lead_fitting": null, "hazenid": null, "cust_notes": null, "util_previous_lead": null, "util_verif": null, "mailing_address1": null, "mailing_address2": null, "cust_after_lead_ban": null, "locationid_external": null, "cws_id": null, "cust_install_date": null, "curb_size": null, "ownership": null, "fitting_verif_method_other": null, "assetid_external": null, "lot_sqfeet": null, "util_diameter": null, "notes": null, "cust_removal_date": null, "cust_material": null, "cws_name": null, "disadvantaged_neighborhood": null, "cust_verif_date": null, "lead_solder": null, "util_lead_solder": null, "parcel_number": null, "fitting_verif_by": null, "util_depth": null, "estimated_value": null, "sample_site": null, "longitude": null, "util_material": null, "cust_diameter": null, "util_verif_method": null, "owned_by_business": null, "util_verif_date": null, "curb_install_year": null, "cust_verif_method": null, "customerid": null, "neighborhood": null, "cust_material_other": null, "fitting_verif_date": null, "assetid_120water": null, "util_diameter_over_2in": null, "util_material_other": null, "cust_verif_method_other": null, "children_under_7": null, "lead_other": null, "lcr_tier": null, "description": null, "util_verif_method_other": null, "main_size": null, "util_removal_date": null, "meter_install_year": null, "meter_material": null, "util_install_date": null, "locationid_gis": null, "mailing_city": null, "mailing_state": null, "near_fid": null, "address2": null, "address1": null, "cust_verif": null, "meter_size": null, "mailing_zip": null, "main_install_year": null, "yrbuilt": null, "pregnant_women": null, "fitting_verif_method": null, "sensitive_pop": null, "dwelr_code": null } } } ], "name": "matched", "domains": { "util_diameter": {"type": "inherited"}, "other_buildings": {"type": "inherited"}, "children_under_7": {"type": "inherited"}, "property_class": {"type": "inherited"}, "cust_material": {"type": "inherited"}, "util_classification_method": {"type": "inherited"}, "cust_notice_complete": {"type": "inherited"}, "disadvantaged_neighborhood": {"type": "inherited"}, "plumbing_lead_solder": {"type": "inherited"}, "lead_fitting": {"type": "inherited"}, "lead_solder": {"type": "inherited"}, "util_lead_solder": {"type": "inherited"}, "util_previous_lead": {"type": "inherited"}, "util_verif": {"type": "inherited"}, "sample_site": {"type": "inherited"}, "util_material": {"type": "inherited"}, "cust_verif": {"type": "inherited"}, "cust_diameter": {"type": "inherited"}, "util_verif_method": {"type": "inherited"}, "cust_lead_solder": {"type": "inherited"}, "owned_by_business": {"type": "inherited"}, "ownership": {"type": "inherited"}, "pregnant_women": {"type": "inherited"}, "cust_verif_method": {"type": "inherited"}, "fitting_verif_method": {"type": "inherited"}, "point_of_entry": {"type": "inherited"}, "cust_classification_method": {"type": "inherited"} }, "id": "matched" } ], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "status", "supportsASyncCalculate": true, "supportsVCSProjection": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "uniqueValueGroups": [ { "heading": "STATUS", "classes": [ { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAACgAAAAoCAYAAACM/rhtAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACJElEQVRYhd2XMW7bMBiFH1t2LlpkUXyDrtQRCiSLPOcE6hj0BLYHH0K+gjKVuUCHbCYyJVtWcQngpUOBoGHxJBkQDMGiZDkm8gDBsgRCn37y53uSCFwSgUsicEkELonAJRG4JAKXROCSCFwS7w3QOZcAKIQQpue4FMCtEKI4GmAN96s+/yGEWHmOm79aO/sQRTyP+7yc7Au3mU7xryhwtl5nzjl0QRLuxZjZn8UCBPycZes+kH0qWE4N4V6MwXMcd0I24f5qjU9K4dVagp4DGBeQb8xpJRThuiBdC9xXrQm3EELoo6xBQhCmC9Lth5sftYvbIB/iGDdJkgFgp6rJZIKLKMLSmIPgBgHuQj7EMX4agydl8H0N9UUBG1Pg96rApQHuD4AbDNiEvEmSjHCK9atFSP6/s8DV9fUqz/NBcAcBbiEBpKxc2/1vMyCP89Z7b2l1ihVrU339dIDOuTkbgmuuDXJT7XT2JIDbreQiisqGaK7BrR4XQJqmUZZlqa8tjgLY3OeWxpTdyobgmqu6uII708BSlWX0ssVRANs24Xutq26tGoKHZeUI52uLowDuc4h8ZyvhtPLHxxZHAWSeY2TytS+x3xatrx/3qeAt4xIPX/sSO5AfzxliSnmH1j5ppmCOY56rI5OXfTUh60vTowTWRuSKmef6RCZRQdohnwpD0gwfYAaM0xig9/dV99aSCFwSgUsicEkELonAJRG45KkBuvQfnl+ND0M2mSEAAAAASUVORK5CYII=", "yoffset": 0, "width": 30, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "12a1bc916bae56153aa21414fb21469f", "height": 30 }, "values": [ [ "" ] ], "description": "", "label": "" }, { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAtElEQVQ4je3TUQrDIAwGYAOeotcL6TXWHmMNnmJ38hhxhJXhipEILXtp3gT9wPxJDBdVvOH/tSKlNCFi7j3u3YnWAxF5MvOLiLbWHWZeRGQOIUxuGBGzogCgeDjiigLAo5SyDreCiDZFj3iNEtEyDLdw/bYHdU0FVbiePagL3qsOqDspbph/g8pWoEMwN4JqBToEs5G+NS0jCzJbQVW4Logfxs+aNjeqxi3UhM+oG/7WZa14AxC0if1cV8S1AAAAAElFTkSuQmCC", "yoffset": 0, "width": 16, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "f0c36957e43b4d709332ce86d0416387", "height": 16 }, "values": [ [ "matched" ] ], "description": "matched", "label": "matched" } ] } ], "field1": "status", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 197, 252, 252, 255 ], "fromColor": [ 197, 252, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 182, 238, 255 ], "fromColor": [ 252, 182, 238, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 245, 252, 182, 255 ], "fromColor": [ 245, 252, 182, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 196, 182, 255 ], "fromColor": [ 252, 196, 182, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 189, 208, 252, 255 ], "fromColor": [ 189, 208, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 179, 252, 185, 255 ], "fromColor": [ 179, 252, 185, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 212, 234, 255 ], "fromColor": [ 252, 212, 234, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 240, 207, 255 ], "fromColor": [ 252, 240, 207, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 210, 179, 252, 255 ], "fromColor": [ 210, 179, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 219, 252, 212, 255 ], "fromColor": [ 219, 252, 212, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 184, 231, 252, 255 ], "fromColor": [ 184, 231, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 179, 191, 255 ], "fromColor": [ 252, 179, 191, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 234, 202, 252, 255 ], "fromColor": [ 234, 202, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" } }, "defaultSymbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 130, 130, 130, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAACgAAAAoCAYAAACM/rhtAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACJElEQVRYhd2XMW7bMBiFH1t2LlpkUXyDrtQRCiSLPOcE6hj0BLYHH0K+gjKVuUCHbCYyJVtWcQngpUOBoGHxJBkQDMGiZDkm8gDBsgRCn37y53uSCFwSgUsicEkELonAJRG4JAKXROCSCFwS7w3QOZcAKIQQpue4FMCtEKI4GmAN96s+/yGEWHmOm79aO/sQRTyP+7yc7Au3mU7xryhwtl5nzjl0QRLuxZjZn8UCBPycZes+kH0qWE4N4V6MwXMcd0I24f5qjU9K4dVagp4DGBeQb8xpJRThuiBdC9xXrQm3EELoo6xBQhCmC9Lth5sftYvbIB/iGDdJkgFgp6rJZIKLKMLSmIPgBgHuQj7EMX4agydl8H0N9UUBG1Pg96rApQHuD4AbDNiEvEmSjHCK9atFSP6/s8DV9fUqz/NBcAcBbiEBpKxc2/1vMyCP89Z7b2l1ihVrU339dIDOuTkbgmuuDXJT7XT2JIDbreQiisqGaK7BrR4XQJqmUZZlqa8tjgLY3OeWxpTdyobgmqu6uII708BSlWX0ssVRANs24Xutq26tGoKHZeUI52uLowDuc4h8ZyvhtPLHxxZHAWSeY2TytS+x3xatrx/3qeAt4xIPX/sSO5AfzxliSnmH1j5ppmCOY56rI5OXfTUh60vTowTWRuSKmef6RCZRQdohnwpD0gwfYAaM0xig9/dV99aSCFwSgUsicEkELonAJRG45KkBuvQfnl+ND0M2mSEAAAAASUVORK5CYII=", "yoffset": 0, "width": 30, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "12a1bc916bae56153aa21414fb21469f", "height": 30 }, "label": "", "value": "" }, { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAtElEQVQ4je3TUQrDIAwGYAOeotcL6TXWHmMNnmJ38hhxhJXhipEILXtp3gT9wPxJDBdVvOH/tSKlNCFi7j3u3YnWAxF5MvOLiLbWHWZeRGQOIUxuGBGzogCgeDjiigLAo5SyDreCiDZFj3iNEtEyDLdw/bYHdU0FVbiePagL3qsOqDspbph/g8pWoEMwN4JqBToEs5G+NS0jCzJbQVW4Logfxs+aNjeqxi3UhM+oG/7WZa14AxC0if1cV8S1AAAAAElFTkSuQmCC", "yoffset": 0, "width": 16, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "f0c36957e43b4d709332ce86d0416387", "height": 16 }, "label": "matched", "value": "matched" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "removeDuplicates": "none", "symbol": { "backgroundColor": null, "kerning": true, "color": [ 0, 0, 0, 255 ], "yoffset": 0, "xoffset": 0, "haloColor": null, "type": "esriTS", "borderLineColor": null, "borderLineSize": null, "horizontalAlignment": "left", "haloSize": null, "angle": 0, "rightToLeft": false, "verticalAlignment": "bottom", "font": { "size": 10, "weight": "normal", "style": "normal", "family": "Tahoma", "decoration": "none" } }, "stackLabel": false, "maxScale": 0, "name": "Class 1", "where": "status IS NULL", "minScale": 1800, "labelExpressionInfo": { "expression": "$feature.address1", "title": "Custom" }, "deconflictionStrategy": "dynamic", "priority": -1, "labelPlacement": "esriServerPointLabelPlacementAboveRight", "useCodedValues": true } ] }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 33.79963590400007, "xmin": -111.96294575099995, "ymax": 33.845394542000065, "xmax": -111.87412199999994, "spatialReference": { "falseM": -100000, "xyTolerance": 8.983152841195215E-9, "mUnits": 10000, "zUnits": 10000, "latestWkid": 4326, "zTolerance": 0.001, "wkid": 4326, "xyUnits": 9.999999999999999E8, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "id", "supportsQuantizationEditMode": true, "name": "meter_locations", "allowTrueCurvesUpdates": false, "displayField": "account_full_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "id", "domain": null, "name": "id", "alias": "ID" }, { "modelName": "location_no", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location_no", "length": 255, "alias": "Location_No", "type": "esriFieldTypeString" }, { "modelName": "acct_no", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "acct_no", "length": 255, "alias": "Acct_No", "type": "esriFieldTypeString" }, { "modelName": "meter_no", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "meter_no", "length": 255, "alias": "Meter_No", "type": "esriFieldTypeString" }, { "modelName": "transmitter_no", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "transmitter_no", "length": 255, "alias": "Transmitter_No", "type": "esriFieldTypeString" }, { "modelName": "meter_size", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "meter_size", "length": 255, "alias": "Meter_Size", "type": "esriFieldTypeString" }, { "modelName": "account_full_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "account_full_name", "length": 255, "alias": "Account_Full_Name", "type": "esriFieldTypeString" }, { "modelName": "address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 255, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "route", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "route", "length": 255, "alias": "Route", "type": "esriFieldTypeString" }, { "modelName": "service_address_in_ums", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "service_address_in_ums", "length": 255, "alias": "Service_Address_in_UMS", "type": "esriFieldTypeString" }, { "modelName": "unit_no", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unit_no", "length": 255, "alias": "Unit_No", "type": "esriFieldTypeString" }, { "modelName": "latitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latitude", "alias": "Latitude", "type": "esriFieldTypeDouble" }, { "modelName": "longitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longitude", "alias": "Longitude", "type": "esriFieldTypeDouble" }, { "modelName": "matchsource", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matchsource", "length": 255, "alias": "MatchSource", "type": "esriFieldTypeString" }, { "modelName": "hazenid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hazenid", "length": 255, "alias": "HazenID", "type": "esriFieldTypeString" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r1590_sde_rowid_uk", "isUnique": true, "description": "", "fields": "id", "isAscending": true }, { "name": "a1345_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "62f59b8d992b47bc9d994be8ad7be85c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [ { "templates": [ { "name": "", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "location_no": null, "account_full_name": null, "matchsource": null, "address": null, "service_address_in_ums": null, "latitude": null, "meter_size": null, "hazenid": null, "route": null, "unit_no": null, "acct_no": " ", "meter_no": " ", "transmitter_no": null, "longitude": null } } } ], "name": "", "domains": {}, "id": null }, { "templates": [ { "name": "noGeoLoc", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "location_no": null, "account_full_name": null, "matchsource": "noGeoLoc", "address": null, "service_address_in_ums": null, "latitude": null, "meter_size": null, "hazenid": null, "route": null, "unit_no": null, "acct_no": " ", "meter_no": " ", "transmitter_no": null, "longitude": null } } } ], "name": "noGeoLoc", "domains": {}, "id": "noGeoLoc" }, { "templates": [ { "name": "verified", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "location_no": null, "account_full_name": null, "matchsource": "verified", "address": null, "service_address_in_ums": null, "latitude": null, "meter_size": null, "hazenid": null, "route": null, "unit_no": null, "acct_no": " ", "meter_no": " ", "transmitter_no": null, "longitude": null } } } ], "name": "verified", "domains": {}, "id": "verified" } ], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "matchsource", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "uniqueValueGroups": [ { "heading": "MatchSource", "classes": [ { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 204, 227, 252, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "values": [ [ "" ] ], "description": "", "label": "" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.6 }, "color": [ 230, 0, 0, 255 ], "size": 10, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "values": [ [ "noGeoLoc" ] ], "description": "noGeoLoc", "label": "noGeoLoc" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 255, 255, 255, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "values": [ [ "verified" ] ], "description": "verified", "label": "verified" } ] } ], "field1": "matchsource", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 197, 252, 252, 255 ], "fromColor": [ 197, 252, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 182, 238, 255 ], "fromColor": [ 252, 182, 238, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 245, 252, 182, 255 ], "fromColor": [ 245, 252, 182, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 196, 182, 255 ], "fromColor": [ 252, 196, 182, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 189, 208, 252, 255 ], "fromColor": [ 189, 208, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 179, 252, 185, 255 ], "fromColor": [ 179, 252, 185, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 212, 234, 255 ], "fromColor": [ 252, 212, 234, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 240, 207, 255 ], "fromColor": [ 252, 240, 207, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 210, 179, 252, 255 ], "fromColor": [ 210, 179, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 219, 252, 212, 255 ], "fromColor": [ 219, 252, 212, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 184, 231, 252, 255 ], "fromColor": [ 184, 231, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 179, 191, 255 ], "fromColor": [ 252, 179, 191, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 234, 202, 252, 255 ], "fromColor": [ 234, 202, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" } }, "defaultSymbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 130, 130, 130, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 204, 227, 252, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "", "value": "" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.6 }, "color": [ 230, 0, 0, 255 ], "size": 10, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "noGeoLoc", "value": "noGeoLoc" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 255, 255, 255, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "verified", "value": "verified" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "symbol": { "backgroundColor": null, "kerning": true, "color": [ 0, 0, 0, 255 ], "yoffset": 0, "xoffset": 0, "haloColor": null, "type": "esriTS", "borderLineColor": null, "borderLineSize": null, "horizontalAlignment": "left", "haloSize": null, "angle": 0, "rightToLeft": false, "verticalAlignment": "bottom", "font": { "size": 10, "weight": "normal", "style": "normal", "family": "Tahoma", "decoration": "none" } }, "stackLabel": true, "stackRowLength": 24, "maxScale": 0, "labelExpressionInfo": { "expression": "$feature.Service_Address_in_UMS", "title": "Custom" }, "deconflictionStrategy": "dynamic", "priority": -1, "labelPlacement": "esriServerPointLabelPlacementAboveRight", "removeDuplicates": "none", "name": "Class 1", "where": "MatchSource = 'noGeoLoc'", "minScale": 3600, "stackAlignment": "dynamic", "useCodedValues": true } ] }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": false, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 33.79929853700003, "xmin": -111.96497226899999, "ymax": 33.84542945700008, "xmax": -111.90540247799998, "spatialReference": { "falseM": -100000, "xyTolerance": 8.983152841195215E-9, "mUnits": 10000, "zUnits": 10000, "latestWkid": 4326, "zTolerance": 0.001, "wkid": 4326, "xyUnits": 9.999999999999999E8, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "wLateralLine", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "operatingdistrict": null, "datasourcetype": null, "facilityid": null, "installdate": null, "pof": null, "enabled": 1, "operatingcompany": null, "bre": null, "diameter": null, "safetyrequirements": null, "warrantydate": null, "watertype": "Potable", "ownedby": 1, "projectid": null, "address": null, "lifecyclestatuschangedate": null, "lateraltype": null, "activeflag": "Active", "depth": null, "system": null, "material": null, "cipnumber": null, "datasourcereference": null, "pipeaccesstype": "Public", "location": null, "maintby": 1, "cof": null, "operatingdivision": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": { "name": "Utilities", "id": 2 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "wLateralLine", "allowTrueCurvesUpdates": false, "displayField": "facilityid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 20, "alias": "Service ID", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "WARRANTYDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "warrantydate", "length": 29, "alias": "Warranty Date", "type": "esriFieldTypeDate" }, { "modelName": "MATERIAL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "type": "codedValue", "codedValues": [ { "code": "ABS", "name": "Acrylonitrile Butadiene Styrene" }, { "code": "AC", "name": "Asbestos Cement" }, { "code": "BR", "name": "Brass" }, { "code": "CI", "name": "Cast Iron" }, { "code": "CIPP", "name": "Cured In Place Pipe" }, { "code": "CP", "name": "Concrete (Non-Reinforced)" }, { "code": "CU", "name": "Copper" }, { "code": "DI", "name": "Ductile Iron" }, { "code": "FRP", "name": "Fiberglass Reinforced" }, { "code": "GALV", "name": "Galvanized Pipe" }, { "code": "HDPE", "name": "High Density Polyethylene" }, { "code": "PCCP", "name": "Prestressed Concrete Cylindrical Pipe" }, { "code": "PE", "name": "Polyethylene" }, { "code": "PP", "name": "Polypropylene" }, { "code": "PVC", "name": "Polyvinyl Chloride" }, { "code": "RCP", "name": "Reinforced Concrete" }, { "code": "ST", "name": "Steel" }, { "code": "UNK", "name": "Unknown" }, { "code": "VCP", "name": "Vitrified Clay" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "material", "length": 20, "alias": "Material", "type": "esriFieldTypeString" }, { "modelName": "LATERALTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wLateralType", "description": "The type of water lateral line", "type": "codedValue", "codedValues": [ { "code": "Commercial", "name": "Commercial" }, { "code": "Domestic", "name": "Domestic" }, { "code": "Fire", "name": "Fire" }, { "code": "Hydrant", "name": "Hydrant" }, { "code": "Industrial", "name": "Industrial" }, { "code": "Irrigation", "name": "Irrigation" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lateraltype", "length": 20, "alias": "Lateral Type", "type": "esriFieldTypeString" }, { "modelName": "ADDRESS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 50, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 50, "alias": "Location\\Cross Street", "type": "esriFieldTypeString" }, { "modelName": "DIAMETER", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "piPipeDiameter", "description": "A list of pipe diameters", "type": "codedValue", "codedValues": [ { "code": 0.75, "name": "3/4\"" }, { "code": 1, "name": "1\"" }, { "code": 1.25, "name": "1 1/4\"" }, { "code": 1.5, "name": "1 1/2\"" }, { "code": 1.75, "name": "1 3/4\"" }, { "code": 2, "name": "2\"" }, { "code": 2.5, "name": "2 1/2\"" }, { "code": 3, "name": "3\"" }, { "code": 4, "name": "4\"" }, { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 12, "name": "12\"" }, { "code": 14, "name": "14\"" }, { "code": 15, "name": "15\"" }, { "code": 16, "name": "16\"" }, { "code": 18, "name": "18\"" }, { "code": 20, "name": "20\"" }, { "code": 21, "name": "21\"" }, { "code": 24, "name": "24\"" }, { "code": 27, "name": "27\"" }, { "code": 30, "name": "30\"" }, { "code": 33, "name": "33\"" }, { "code": 36, "name": "36\"" }, { "code": 40, "name": "40\"" }, { "code": 42, "name": "42\"" }, { "code": 48, "name": "48\"" }, { "code": 54, "name": "54\"" }, { "code": 60, "name": "60\"" }, { "code": 66, "name": "66\"" }, { "code": 72, "name": "72\"" }, { "code": 75, "name": "75\"" }, { "code": 0, "name": "Unknown" }, { "code": 2.75, "name": "2 3/4\"" }, { "code": 22, "name": "22\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "diameter", "alias": "Diameter", "type": "esriFieldTypeDouble" }, { "modelName": "DEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "depth", "alias": "Depth", "type": "esriFieldTypeDouble" }, { "modelName": "WATERTYPE", "nullable": true, "editable": true, "defaultValue": "Potable", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wWaterType", "description": "The type of water flowing through pipe", "type": "codedValue", "codedValues": [ { "code": "Potable", "name": "Potable Water" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Well", "name": "Well Water" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "watertype", "length": 30, "alias": "Water Type", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LifeCycleStatus_6", "description": "Status of an asset", "type": "codedValue", "codedValues": [ { "code": "Abandoned", "name": "Abandoned" }, { "code": "Active", "name": "Active" }, { "code": "Cancelled", "name": "Cancelled" }, { "code": "Out of Service", "name": "Out of Service" }, { "code": "Pending", "name": "Pending" }, { "code": "Proposed", "name": "Proposed" }, { "code": "Retired / Scrapped", "name": "Retired / Scrapped" }, { "code": "Retired in Place", "name": "Retired in Place" }, { "code": "Transferred", "name": "Transferred" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "length": 20, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetOwner_6", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Unknown" }, { "code": 1, "name": "Town of Cave Creek" }, { "code": 2, "name": "City Of Phoenix" }, { "code": 3, "name": "Liberty Utilities" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetManager_2", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" }, { "code": 1, "name": "Cave Creek Utilities" }, { "code": 2, "name": "City of Phoenix" }, { "code": 3, "name": "Liberty Utilities" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintby", "alias": "Managed By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OPERATINGCOMPANY", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingCompany_2", "description": "Operating Company", "type": "codedValue", "codedValues": [ { "code": "-1", "name": "Unknown" }, { "code": "1", "name": "Cave Creek utilities" }, { "code": "2", "name": "Liberty Utilities" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingcompany", "length": 32, "alias": "OperatingCompany", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDIVISION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDivision_2", "description": "Division with Operating Company", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdivision", "length": 32, "alias": "OperatingDivision", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDISTRICT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDistrict_2", "description": "Operating District within Operating Division", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdistrict", "length": 32, "alias": "OperatingDistrict", "type": "esriFieldTypeString" }, { "modelName": "SYSTEM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PWSIDNumber", "description": "Public Water System Number", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "system", "length": 20, "alias": "System", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUSCHANGEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lifecyclestatuschangedate", "length": 29, "alias": "LifeCycleStatusChangeDate", "type": "esriFieldTypeDate" }, { "modelName": "PROJECTID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectid", "length": 15, "alias": "Project ID", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DataSourceType", "description": "Data source of feature", "type": "codedValue", "codedValues": [ { "code": "Asbuilt", "name": "As-built Record Plan" }, { "code": "Construction", "name": "Construction Plan" }, { "code": "Conventional Survey", "name": "Conventional Survey" }, { "code": "Estimated", "name": "Estimated Feature Location" }, { "code": "Existing", "name": "Existing Records" }, { "code": "Field Measured", "name": "Field Measured" }, { "code": "Field Notes", "name": "Field Notes" }, { "code": "GPSCM", "name": "Subcentimeter GPS" }, { "code": "GPSM", "name": "Submeter GPS" }, { "code": "Markup", "name": "Markup" }, { "code": "Overall", "name": "Overall System Map" }, { "code": "Planimetric Landbase", "name": "Planimetric Landbase" }, { "code": "Record Drawing", "name": "Record Drawing" }, { "code": "Sketch", "name": "Sketch" }, { "code": "SubFoot GPS", "name": "SubFoot GPS" }, { "code": "TaxMap", "name": "Tax Map" }, { "code": "VRS Collected", "name": "VRS Collected" }, { "code": "AutoCAD Drawing", "name": "AutoCAD Drawing" }, { "code": "KML", "name": "Google Earth kml sketch" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasourcetype", "length": 20, "alias": "DataSourceType", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCEREFERENCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datasourcereference", "length": 50, "alias": "DataSourceReference", "type": "esriFieldTypeString" }, { "modelName": "CIPNUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cipnumber", "length": 15, "alias": "CIP Number", "type": "esriFieldTypeString" }, { "modelName": "PIPEACCESSTYPE", "nullable": true, "editable": true, "defaultValue": "Public", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PipeLocation", "description": "The legal location of an asset", "type": "codedValue", "codedValues": [ { "code": "Easement", "name": "Easement" }, { "code": "EPCOR", "name": "EPCOR" }, { "code": "Private", "name": "Private ROW" }, { "code": "Public", "name": "Public ROW" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "pipeaccesstype", "length": 15, "alias": "Pipe Access Type", "type": "esriFieldTypeString" }, { "modelName": "SAFETYREQUIREMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "safetyrequirements", "length": 30, "alias": "Safety Requirements", "type": "esriFieldTypeString" }, { "modelName": "COF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cof", "alias": "Consequence of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "POF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pof", "alias": "Probability of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "BRE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bre", "alias": "Business Risk Exposure", "type": "esriFieldTypeInteger" }, { "modelName": "CREATEEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "createeditor", "length": 20, "alias": "Creation User", "type": "esriFieldTypeString" }, { "modelName": "CREATEDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "createdate", "length": 29, "alias": "Date Created", "type": "esriFieldTypeDate" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "Enabled", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r1593_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a1348_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "lastupdate", "editorField": "lasteditor", "creationDateField": "createdate", "creatorField": "createeditor" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "62f59b8d992b47bc9d994be8ad7be85c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "color": [ 0, 92, 230, 255 ], "width": 0.6, "style": "esriSLSSolid", "type": "esriSLS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 33.68706610900006, "xmin": -112.09713278599997, "ymax": 33.88021255000007, "xmax": -111.87386425599999, "spatialReference": { "falseM": -100000, "xyTolerance": 8.983152841195215E-9, "mUnits": 10000, "zUnits": 10000, "latestWkid": 4326, "zTolerance": 0.001, "wkid": 4326, "xyUnits": 9.999999999999999E8, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "wMain", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "operatingdistrict": null, "pressureclass": null, "datasourcetype": null, "pressurezonehgl": null, "facilityid": null, "installdate": null, "planref": null, "pof": null, "globalid": null, "createdate": null, "enabled": 1, "operatingcompany": "EPCOR AZ", "gpscollectiontype": null, "diameter": null, "exteriorprotectionorwrap": null, "bre": null, "safetyrequirements": null, "differentthannormaldepth": "No", "warrantydate": null, "watertype": "Potable", "gpsdate": null, "ownedby": 1, "projectid": null, "conditiondate": null, "lifecyclestatuschangedate": null, "measuredlength": null, "cathodicprotection": null, "lasteditor": null, "activeflag": "Active", "gpsfieldnotes": null, "condition": null, "depth": null, "system": null, "inmodel": null, "material": null, "createeditor": null, "cipnumber": null, "datasourcereference": null, "pressurezonename": null, "gpsestacc": null, "liningtype": null, "pipeaccesstype": "Public", "restrained": null, "maintby": 1, "cof": null, "lastupdate": null, "operatingdivision": null, "pipetype": "Distribution" } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": { "name": "Utilities", "id": 2 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "wMain", "allowTrueCurvesUpdates": false, "displayField": "pressurezonename", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 20, "alias": "Facility Identifier", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "WARRANTYDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "warrantydate", "length": 29, "alias": "Warranty Date", "type": "esriFieldTypeDate" }, { "modelName": "MATERIAL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "type": "codedValue", "codedValues": [ { "code": "ABS", "name": "Acrylonitrile Butadiene Styrene" }, { "code": "AC", "name": "Asbestos Cement" }, { "code": "BR", "name": "Brass" }, { "code": "CI", "name": "Cast Iron" }, { "code": "CIPP", "name": "Cured In Place Pipe" }, { "code": "CP", "name": "Concrete (Non-Reinforced)" }, { "code": "CU", "name": "Copper" }, { "code": "DI", "name": "Ductile Iron" }, { "code": "FRP", "name": "Fiberglass Reinforced" }, { "code": "GALV", "name": "Galvanized Pipe" }, { "code": "HDPE", "name": "High Density Polyethylene" }, { "code": "PCCP", "name": "Prestressed Concrete Cylindrical Pipe" }, { "code": "PE", "name": "Polyethylene" }, { "code": "PP", "name": "Polypropylene" }, { "code": "PVC", "name": "Polyvinyl Chloride" }, { "code": "RCP", "name": "Reinforced Concrete" }, { "code": "ST", "name": "Steel" }, { "code": "UNK", "name": "Unknown" }, { "code": "VCP", "name": "Vitrified Clay" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "material", "length": 20, "alias": "Material", "type": "esriFieldTypeString" }, { "modelName": "DIAMETER", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "piPipeDiameter", "description": "A list of pipe diameters", "type": "codedValue", "codedValues": [ { "code": 0.75, "name": "3/4\"" }, { "code": 1, "name": "1\"" }, { "code": 1.25, "name": "1 1/4\"" }, { "code": 1.5, "name": "1 1/2\"" }, { "code": 1.75, "name": "1 3/4\"" }, { "code": 2, "name": "2\"" }, { "code": 2.5, "name": "2 1/2\"" }, { "code": 3, "name": "3\"" }, { "code": 4, "name": "4\"" }, { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 12, "name": "12\"" }, { "code": 14, "name": "14\"" }, { "code": 15, "name": "15\"" }, { "code": 16, "name": "16\"" }, { "code": 18, "name": "18\"" }, { "code": 20, "name": "20\"" }, { "code": 21, "name": "21\"" }, { "code": 24, "name": "24\"" }, { "code": 27, "name": "27\"" }, { "code": 30, "name": "30\"" }, { "code": 33, "name": "33\"" }, { "code": 36, "name": "36\"" }, { "code": 40, "name": "40\"" }, { "code": 42, "name": "42\"" }, { "code": 48, "name": "48\"" }, { "code": 54, "name": "54\"" }, { "code": 60, "name": "60\"" }, { "code": 66, "name": "66\"" }, { "code": 72, "name": "72\"" }, { "code": 75, "name": "75\"" }, { "code": 0, "name": "Unknown" }, { "code": 2.75, "name": "2 3/4\"" }, { "code": 22, "name": "22\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "diameter", "alias": "Diameter", "type": "esriFieldTypeDouble" }, { "modelName": "DEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "depth", "alias": "Depth", "type": "esriFieldTypeDouble" }, { "modelName": "WATERTYPE", "nullable": true, "editable": true, "defaultValue": "Potable", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wWaterType", "description": "The type of water flowing through pipe", "type": "codedValue", "codedValues": [ { "code": "Potable", "name": "Potable Water" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Well", "name": "Well Water" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "watertype", "length": 30, "alias": "Water Type", "type": "esriFieldTypeString" }, { "modelName": "PIPETYPE", "nullable": true, "editable": true, "defaultValue": "Distribution", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "piPipeType", "description": "Water pipe type", "type": "codedValue", "codedValues": [ { "code": "Distribution", "name": "Distribution" }, { "code": "Plant", "name": "Plant" }, { "code": "Transmission", "name": "Transmission" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "pipetype", "length": 15, "alias": "Pipe Type", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": null, "name": "activeflag", "length": 20, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "maintby", "alias": "Managed By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "CONDITION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Condition_7", "description": "The condition of the asset", "type": "codedValue", "codedValues": [ { "code": "1", "name": "Excellent" }, { "code": "0", "name": "Unknown" }, { "code": "2", "name": "Good" }, { "code": "3", "name": "Fair" }, { "code": "4", "name": "Poor" }, { "code": "5", "name": "Immediate Attention" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "condition", "length": 1, "alias": "Condition", "type": "esriFieldTypeString" }, { "modelName": "CONDITIONDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "conditiondate", "length": 29, "alias": "Condition Date", "type": "esriFieldTypeDate" }, { "modelName": "OPERATINGCOMPANY", "nullable": true, "editable": true, "defaultValue": "EPCOR AZ", "domain": null, "name": "operatingcompany", "length": 32, "alias": "OperatingCompany", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDIVISION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operatingdivision", "length": 32, "alias": "OperatingDivision", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDISTRICT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operatingdistrict", "length": 32, "alias": "OperatingDistrict", "type": "esriFieldTypeString" }, { "modelName": "SYSTEM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PWSIDNumber", "description": "Public Water System Number", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "system", "length": 20, "alias": "System", "type": "esriFieldTypeString" }, { "modelName": "CATHODICPROTECTION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "cathodicprotection", "length": 3, "alias": "CathodicProtection", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUSCHANGEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lifecyclestatuschangedate", "length": 29, "alias": "LifeCycleStatusChangeDate", "type": "esriFieldTypeDate" }, { "modelName": "MEASUREDLENGTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "measuredlength", "alias": "MeasuredLength", "type": "esriFieldTypeDouble" }, { "modelName": "PROJECTID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectid", "length": 15, "alias": "Project ID", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DataSourceType", "description": "Data source of feature", "type": "codedValue", "codedValues": [ { "code": "Asbuilt", "name": "As-built Record Plan" }, { "code": "Construction", "name": "Construction Plan" }, { "code": "Conventional Survey", "name": "Conventional Survey" }, { "code": "Estimated", "name": "Estimated Feature Location" }, { "code": "Existing", "name": "Existing Records" }, { "code": "Field Measured", "name": "Field Measured" }, { "code": "Field Notes", "name": "Field Notes" }, { "code": "GPSCM", "name": "Subcentimeter GPS" }, { "code": "GPSM", "name": "Submeter GPS" }, { "code": "Markup", "name": "Markup" }, { "code": "Overall", "name": "Overall System Map" }, { "code": "Planimetric Landbase", "name": "Planimetric Landbase" }, { "code": "Record Drawing", "name": "Record Drawing" }, { "code": "Sketch", "name": "Sketch" }, { "code": "SubFoot GPS", "name": "SubFoot GPS" }, { "code": "TaxMap", "name": "Tax Map" }, { "code": "VRS Collected", "name": "VRS Collected" }, { "code": "AutoCAD Drawing", "name": "AutoCAD Drawing" }, { "code": "KML", "name": "Google Earth kml sketch" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasourcetype", "length": 20, "alias": "DataSourceType", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCEREFERENCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datasourcereference", "length": 50, "alias": "DataSourceReference", "type": "esriFieldTypeString" }, { "modelName": "PRESSUREZONENAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressurezonename", "length": 50, "alias": "PressureZoneName", "type": "esriFieldTypeString" }, { "modelName": "PRESSUREZONEHGL", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressurezonehgl", "alias": "PressureZoneHGL", "type": "esriFieldTypeInteger" }, { "modelName": "CIPNUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cipnumber", "length": 15, "alias": "CIP Number", "type": "esriFieldTypeString" }, { "modelName": "PIPEACCESSTYPE", "nullable": true, "editable": true, "defaultValue": "Public", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PipeLocation", "description": "The legal location of an asset", "type": "codedValue", "codedValues": [ { "code": "Easement", "name": "Easement" }, { "code": "EPCOR", "name": "EPCOR" }, { "code": "Private", "name": "Private ROW" }, { "code": "Public", "name": "Public ROW" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "pipeaccesstype", "length": 15, "alias": "Pipe Access Type", "type": "esriFieldTypeString" }, { "modelName": "GPSCOLLECTIONTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpscollectiontype", "length": 25, "alias": "GPSCollectionType", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPS_Date", "type": "esriFieldTypeDate" }, { "modelName": "GPSESTACC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsestacc", "alias": "GPSEstAcc", "type": "esriFieldTypeDouble" }, { "modelName": "GPSFIELDNOTES", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsfieldnotes", "length": 100, "alias": "GPSFieldNotes", "type": "esriFieldTypeString" }, { "modelName": "DIFFERENTTHANNORMALDEPTH", "nullable": true, "editable": true, "defaultValue": "No", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "differentthannormaldepth", "length": 10, "alias": "DifferentThanNormalDepth", "type": "esriFieldTypeString" }, { "modelName": "EXTERIORPROTECTIONORWRAP", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ExteriorProtection", "description": "External pipe protection type", "type": "codedValue", "codedValues": [ { "code": "CathodicProtection", "name": "CathodicProtection" }, { "code": "Polywrapped", "name": "Polywrapped" }, { "code": "Tracer", "name": "Tracer" }, { "code": "Wrapped", "name": "Wrapped" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "exteriorprotectionorwrap", "length": 20, "alias": "ExteriorProtectionorWrap", "type": "esriFieldTypeString" }, { "modelName": "LININGTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LiningType", "description": "Internal pipe lining type", "type": "codedValue", "codedValues": [ { "code": "Cement", "name": "Cement Mortar Lining" }, { "code": "Epoxy", "name": "Epoxy Spray Lining" }, { "code": "Glass", "name": "Glass Fiber" }, { "code": "PE", "name": "Polyethylene" }, { "code": "PVC", "name": "Fusible PVC" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "liningtype", "length": 20, "alias": "LiningType", "type": "esriFieldTypeString" }, { "modelName": "PRESSURECLASS", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PressureClass", "description": "Pipe pressure class", "type": "codedValue", "codedValues": [ { "code": "DI-150", "name": "DI-150" }, { "code": "DI-200", "name": "DI-200" }, { "code": "DI-250", "name": "DI-250" }, { "code": "DI-300", "name": "DI-300" }, { "code": "DI-350", "name": "DI-350" }, { "code": "RCP-III", "name": "RCP-III" }, { "code": "RCP-IV", "name": "RCP-IV" }, { "code": "RCP-V", "name": "RCP-V" }, { "code": "RCP-VI", "name": "RCP-VI" }, { "code": "Schedule40", "name": "Schedule40" }, { "code": "Schedule80", "name": "Schedule80" }, { "code": "SDR-14", "name": "SDR-14" }, { "code": "SDR-18", "name": "SDR-18" }, { "code": "SDR-21", "name": "SDR-21" }, { "code": "SDR-25", "name": "SDR-25" }, { "code": "SDR-26", "name": "SDR-26" }, { "code": "SDR-32.5", "name": "SDR-32.5" }, { "code": "SDR-41", "name": "SDR-41" }, { "code": "SDR-51", "name": "SDR-51" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "pressureclass", "length": 20, "alias": "PressureClass", "type": "esriFieldTypeString" }, { "modelName": "RESTRAINED", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "restrained", "length": 4, "alias": "Restrained", "type": "esriFieldTypeString" }, { "modelName": "INMODEL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "inmodel", "length": 4, "alias": "InModel", "type": "esriFieldTypeString" }, { "modelName": "SAFETYREQUIREMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "safetyrequirements", "length": 30, "alias": "Safety Requirements", "type": "esriFieldTypeString" }, { "modelName": "COF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cof", "alias": "Consequence of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "POF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pof", "alias": "Probability of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "BRE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bre", "alias": "Business Risk Exposure", "type": "esriFieldTypeInteger" }, { "modelName": "CREATEEDITOR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "createeditor", "length": 20, "alias": "Creation User", "type": "esriFieldTypeString" }, { "modelName": "CREATEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "createdate", "length": 29, "alias": "Date Created", "type": "esriFieldTypeDate" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "Enabled", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "modelName": "PlanRef", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "planref", "length": 255, "alias": "PlanRef", "type": "esriFieldTypeString" }, { "modelName": "GlobalID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGUID" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r1592_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a1347_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "62f59b8d992b47bc9d994be8ad7be85c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "color": [ 0, 92, 230, 255 ], "width": 2, "style": "esriSLSSolid", "type": "esriSLS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 33.79790973000007, "xmin": -111.96640937799998, "ymax": 33.84750735400007, "xmax": -111.87257004499997, "spatialReference": { "falseM": -100000, "xyTolerance": 8.983152841195215E-9, "mUnits": 10000, "zUnits": 10000, "latestWkid": 4326, "zTolerance": 0.001, "wkid": 4326, "xyUnits": 9.999999999999999E8, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 6, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "CF_addresses", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "zip": null, "uspscityalias": null, "stsufx": null, "unitno": null, "stdir": null, "sttype": null, "addresswithcityandzip": null, "hseno": null, "x": null, "y": null, "addresstype": null, "addresswithcity": null, "stname": null, "hsenosufx": null, "addresswithzip": null } } } ], "supportsAdvancedQueries": true, "parentLayer": { "name": "Basemap", "id": 5 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "CF_addresses", "allowTrueCurvesUpdates": false, "displayField": "stname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "X", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "x", "alias": "X", "type": "esriFieldTypeDouble" }, { "modelName": "Y", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "y", "alias": "Y", "type": "esriFieldTypeDouble" }, { "modelName": "HseNo", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hseno", "length": 6, "alias": "HSENO", "type": "esriFieldTypeString" }, { "modelName": "StDir", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stdir", "length": 2, "alias": "STDIR", "type": "esriFieldTypeString" }, { "modelName": "StName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stname", "length": 40, "alias": "STNAME", "type": "esriFieldTypeString" }, { "modelName": "StType", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sttype", "length": 12, "alias": "STTYPE", "type": "esriFieldTypeString" }, { "modelName": "StSufx", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stsufx", "length": 10, "alias": "STSUFX", "type": "esriFieldTypeString" }, { "modelName": "Zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 5, "alias": "ZIP", "type": "esriFieldTypeString" }, { "modelName": "AddressType", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addresstype", "length": 15, "alias": "ADDRESSTYPE", "type": "esriFieldTypeString" }, { "modelName": "HseNoSufx", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hsenosufx", "length": 3, "alias": "HseNoSufx", "type": "esriFieldTypeString" }, { "modelName": "UnitNo", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitno", "length": 9, "alias": "UnitNo", "type": "esriFieldTypeString" }, { "modelName": "USPSCityAlias", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uspscityalias", "length": 30, "alias": "USPSCityAlias", "type": "esriFieldTypeString" }, { "modelName": "AddressWithZip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addresswithzip", "length": 120, "alias": "AddressWithZip", "type": "esriFieldTypeString" }, { "modelName": "AddressWithCity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addresswithcity", "length": 150, "alias": "AddressWithCity", "type": "esriFieldTypeString" }, { "modelName": "AddressWithCityAndZip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addresswithcityandzip", "length": 170, "alias": "AddressWithCityAndZip", "type": "esriFieldTypeString" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "The address feature class is intended to show address locations in Maricopa County, Arizona.", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r1589_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a1344_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 5000, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "62f59b8d992b47bc9d994be8ad7be85c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 0 ], "width": 0.7 }, "color": [ 255, 170, 0, 255 ], "size": 3, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "symbol": { "backgroundColor": null, "kerning": true, "color": [ 168, 112, 0, 255 ], "yoffset": 0, "xoffset": 0, "haloColor": null, "type": "esriTS", "borderLineColor": null, "borderLineSize": null, "horizontalAlignment": "left", "haloSize": null, "angle": 0, "rightToLeft": false, "verticalAlignment": "bottom", "font": { "size": 10, "weight": "normal", "style": "normal", "family": "Tahoma", "decoration": "none" } }, "stackLabel": true, "stackRowLength": 24, "maxScale": 1, "labelExpressionInfo": { "expression": "$feature.HseNo", "title": "Custom" }, "deconflictionStrategy": "dynamic", "priority": -1, "labelPlacement": "esriServerPointLabelPlacementAboveRight", "removeDuplicates": "none", "name": "Class 1", "minScale": 2400, "stackAlignment": "dynamic", "useCodedValues": true } ] }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "Maricopa County Recorder GIS Department \nhttp://www.recorder.maricopa.gov", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 33.792028350000066, "xmin": -111.96727457999998, "ymax": 33.86402972700006, "xmax": -111.87012684999996, "spatialReference": { "falseM": -100000, "xyTolerance": 8.983152841195215E-9, "mUnits": 10000, "zUnits": 10000, "latestWkid": 4326, "zTolerance": 0.001, "wkid": 4326, "xyUnits": 9.999999999999999E8, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 7, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "CF_streets", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "addtype": 0, "stsufx": null, "notes": null, "stdir": null, "cityright": null, "removaldate": null, "isdeadend": 0, "source": null, "isgated": 0, "sttype": null, "lrsfix": null, "zipright": null, "routenum": null, "traveldir": null, "isbuilt": 1, "munl": null, "ispublic": 1, "builddate": null, "projectid": null, "routename": null, "telev": 1, "munr": null, "height": null, "mcsonotes": null, "cityleft": null, "faddlfactl": "0", "faddlftheo": "0", "zipleft": null, "weight": null, "faddrttheo": "0", "oneway": null, "taddlfactl": "0", "felev": 1, "culdesac": 0, "taddrttheo": "0", "speedlimit": 1, "altrtenum": null, "segmentid": 0, "subclass": 17, "width": null, "faddrtactl": "0", "taddrtactl": "0", "taddlftheo": "0", "stname": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": { "name": "Basemap", "id": 5 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "CF_streets", "allowTrueCurvesUpdates": false, "displayField": "stname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FAddLfActl", "nullable": true, "editable": true, "defaultValue": "0", "domain": null, "name": "faddlfactl", "length": 11, "alias": "Actual Left From Address", "type": "esriFieldTypeString" }, { "modelName": "FAddRtActl", "nullable": true, "editable": true, "defaultValue": "0", "domain": null, "name": "faddrtactl", "length": 11, "alias": "Actual Right From Address", "type": "esriFieldTypeString" }, { "modelName": "TAddLfActl", "nullable": true, "editable": true, "defaultValue": "0", "domain": null, "name": "taddlfactl", "length": 11, "alias": "Actual Left To Address", "type": "esriFieldTypeString" }, { "modelName": "TAddRtActl", "nullable": true, "editable": true, "defaultValue": "0", "domain": null, "name": "taddrtactl", "length": 11, "alias": "Actual Right To Address", "type": "esriFieldTypeString" }, { "modelName": "FAddLfTheo", "nullable": true, "editable": true, "defaultValue": "0", "domain": null, "name": "faddlftheo", "length": 11, "alias": "Theoretical Left From Address", "type": "esriFieldTypeString" }, { "modelName": "FAddRtTheo", "nullable": true, "editable": true, "defaultValue": "0", "domain": null, "name": "faddrttheo", "length": 11, "alias": "Theoretical Right From Address", "type": "esriFieldTypeString" }, { "modelName": "TAddLfTheo", "nullable": true, "editable": true, "defaultValue": "0", "domain": null, "name": "taddlftheo", "length": 11, "alias": "Theoretical Left To Address", "type": "esriFieldTypeString" }, { "modelName": "TAddRtTheo", "nullable": true, "editable": true, "defaultValue": "0", "domain": null, "name": "taddrttheo", "length": 11, "alias": "Theoretical Right To Address", "type": "esriFieldTypeString" }, { "modelName": "AddType", "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "addtype", "alias": "Addressing Type", "type": "esriFieldTypeSmallInteger" }, { "modelName": "StDir", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stdir", "length": 2, "alias": "Street Pre-Direction", "type": "esriFieldTypeString" }, { "modelName": "StName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stname", "length": 50, "alias": "Street Name", "type": "esriFieldTypeString" }, { "modelName": "StType", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sttype", "length": 12, "alias": "Street Type", "type": "esriFieldTypeString" }, { "modelName": "StSufx", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stsufx", "length": 2, "alias": "Street Post-Direction", "type": "esriFieldTypeString" }, { "modelName": "ZipLeft", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zipleft", "length": 5, "alias": "Postal Zip Code Left", "type": "esriFieldTypeString" }, { "modelName": "ZipRight", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zipright", "length": 5, "alias": "Postal Zip Code Right", "type": "esriFieldTypeString" }, { "modelName": "CityLeft", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cityleft", "length": 25, "alias": "City Left", "type": "esriFieldTypeString" }, { "modelName": "CityRight", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cityright", "length": 25, "alias": "City Right", "type": "esriFieldTypeString" }, { "modelName": "MunL", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "munl", "length": 5, "alias": "Municipal Response Code Left", "type": "esriFieldTypeString" }, { "modelName": "MunR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "munr", "length": 5, "alias": "Municipal Response Code Right", "type": "esriFieldTypeString" }, { "modelName": "RouteNum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "routenum", "alias": "Route Number", "type": "esriFieldTypeSmallInteger" }, { "modelName": "SubClass", "nullable": true, "editable": true, "defaultValue": 17, "domain": null, "name": "subclass", "alias": "SubClass", "type": "esriFieldTypeSmallInteger" }, { "modelName": "FElev", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "felev", "alias": "From Elevation", "type": "esriFieldTypeSmallInteger" }, { "modelName": "TElev", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "telev", "alias": "To Elevation", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OneWay", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "oneway", "length": 3, "alias": "One Way", "type": "esriFieldTypeString" }, { "modelName": "IsDeadEnd", "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "isdeadend", "alias": "Dead End", "type": "esriFieldTypeSmallInteger" }, { "modelName": "SpeedLimit", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "speedlimit", "alias": "Speed Limit", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Height", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "height", "alias": "Maximum Height", "type": "esriFieldTypeDouble" }, { "modelName": "Width", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "width", "alias": "Maximum Width", "type": "esriFieldTypeDouble" }, { "modelName": "Weight", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "weight", "alias": "Maximum Weight", "type": "esriFieldTypeDouble" }, { "modelName": "IsBuilt", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "isbuilt", "alias": "Is Street Built", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MCSONotes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mcsonotes", "length": 255, "alias": "MCSO Notes", "type": "esriFieldTypeString" }, { "modelName": "Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 255, "alias": "Notes", "type": "esriFieldTypeString" }, { "modelName": "Source", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source", "length": 35, "alias": "Data Source", "type": "esriFieldTypeString" }, { "modelName": "SegmentID", "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "segmentid", "alias": "Segment ID", "type": "esriFieldTypeInteger" }, { "modelName": "ProjectID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectid", "length": 100, "alias": "Project ID", "type": "esriFieldTypeString" }, { "modelName": "RouteName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "routename", "length": 100, "alias": "Route Name", "type": "esriFieldTypeString" }, { "modelName": "TravelDir", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "traveldir", "length": 2, "alias": "Travel Direction", "type": "esriFieldTypeString" }, { "modelName": "IsPublic", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "ispublic", "alias": "Is Public", "type": "esriFieldTypeSmallInteger" }, { "modelName": "BuildDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "builddate", "length": 29, "alias": "BuildDate", "type": "esriFieldTypeDate" }, { "modelName": "RemovalDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "removaldate", "length": 29, "alias": "RemovalDate", "type": "esriFieldTypeDate" }, { "modelName": "AltRteNum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "altrtenum", "length": 12, "alias": "AlternateRouteNumber", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "CulDeSac", "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "culdesac", "alias": "CulDeSac", "type": "esriFieldTypeInteger" }, { "modelName": "LRSFix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lrsfix", "length": 6, "alias": "LRSFix", "type": "esriFieldTypeString" }, { "modelName": "IsGated", "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "isgated", "alias": "IsGated", "type": "esriFieldTypeSmallInteger" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "The centerlines feature class is intended to show current and future street centerlines in Maricopa County, Arizona.", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r1591_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_1591", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a1346_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "62f59b8d992b47bc9d994be8ad7be85c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "color": [ 255, 211, 127, 255 ], "width": 0.5, "style": "esriSLSSolid", "type": "esriSLS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "symbol": { "backgroundColor": null, "kerning": true, "color": [ 104, 104, 104, 255 ], "yoffset": 0, "xoffset": 0, "haloColor": null, "type": "esriTS", "borderLineColor": null, "borderLineSize": null, "horizontalAlignment": "left", "haloSize": null, "angle": 0, "rightToLeft": false, "verticalAlignment": "bottom", "font": { "size": 10, "weight": "normal", "style": "normal", "family": "Tahoma", "decoration": "none" } }, "stackLabel": true, "stackRowLength": 24, "offsetDistance": 3, "maxScale": 0, "allowOverrun": true, "lineConnection": "minimizeLabels", "useClippedGeometry": true, "labelExpressionInfo": { "expression": "$feature.StName + \" \" + $feature.StType", "title": "Custom" }, "deconflictionStrategy": "dynamic", "priority": -1, "labelPlacement": "esriServerLinePlacementAboveAlong", "removeDuplicates": "none", "textLayout": "followFeature", "name": "Class 1", "repeatLabel": false, "minScale": 0, "stackAlignment": "dynamic", "useCodedValues": true } ] }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "Maricopa County Elections GIS Department \nhttp://www.recorder.maricopa.gov/elections", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 33.79924926900003, "xmin": -111.96721927499999, "ymax": 33.86083335700005, "xmax": -111.85835948699997, "spatialReference": { "falseM": -100000, "xyTolerance": 8.983152841195215E-9, "mUnits": 10000, "zUnits": 10000, "latestWkid": 4326, "zTolerance": 0.001, "wkid": 4326, "xyUnits": 9.999999999999999E8, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 8, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Parcels", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "total_sq_ft": null, "tract": null, "deed_type": null, "deed_number": null, "landclass": null, "mcr_number": null, "subdivision_name": null, "limited_property_value": null, "owner_mail_zip_code": null, "lot": null, "owner_mail_country": null, "sale_date": null, "parcel_number": null, "deed_date": null, "owner_mail_state": null, "property_type": null, "block": null, "property_use_code": null, "improvement_full_cash_value": null, "number_of_units": null, "situs_zip_code": null, "owner_name": null, "contruction_year": null, "tax_area_cd": null, "pool_size": null, "owner_mail_address_1": null, "owner_mail_city": null, "owner_mail_address_2": null, "improvementclass": null, "sale_price": null, "situs_suite": null, "land_full_cash_value": null, "lpv_assessed": null, "total_full_cash_value": null, "situs_city": null, "rental_indicator": null, "living_area": null, "total_full_cash_assessed_value": null, "situs_address": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": { "name": "Basemap", "id": 5 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Parcels", "allowTrueCurvesUpdates": false, "displayField": "owner_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "Object ID" }, { "modelName": "parcel_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parcel_number", "length": 8000, "alias": "PARCEL_NUMBER", "type": "esriFieldTypeString" }, { "modelName": "owner_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owner_name", "length": 8000, "alias": "OWNER_NAME", "type": "esriFieldTypeString" }, { "modelName": "owner_mail_address_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owner_mail_address_1", "length": 8000, "alias": "OWNER_MAIL_ADDRESS_1", "type": "esriFieldTypeString" }, { "modelName": "owner_mail_address_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owner_mail_address_2", "length": 8000, "alias": "OWNER_MAIL_ADDRESS_2", "type": "esriFieldTypeString" }, { "modelName": "owner_mail_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owner_mail_city", "length": 8000, "alias": "OWNER_MAIL_CITY", "type": "esriFieldTypeString" }, { "modelName": "owner_mail_state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owner_mail_state", "length": 8000, "alias": "OWNER_MAIL_STATE", "type": "esriFieldTypeString" }, { "modelName": "owner_mail_zip_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owner_mail_zip_code", "length": 8000, "alias": "OWNER_MAIL_ZIP_CODE", "type": "esriFieldTypeString" }, { "modelName": "owner_mail_country", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owner_mail_country", "length": 8000, "alias": "OWNER_MAIL_COUNTRY", "type": "esriFieldTypeString" }, { "modelName": "situs_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "situs_address", "length": 8000, "alias": "SITUS_ADDRESS", "type": "esriFieldTypeString" }, { "modelName": "situs_suite", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "situs_suite", "length": 8000, "alias": "SITUS_SUITE", "type": "esriFieldTypeString" }, { "modelName": "situs_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "situs_city", "length": 8000, "alias": "SITUS_CITY", "type": "esriFieldTypeString" }, { "modelName": "situs_zip_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "situs_zip_code", "alias": "SITUS_ZIP_CODE", "type": "esriFieldTypeInteger" }, { "modelName": "property_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_type", "length": 8000, "alias": "PROPERTY_TYPE", "type": "esriFieldTypeString" }, { "modelName": "deed_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deed_number", "length": 8000, "alias": "DEED_NUMBER", "type": "esriFieldTypeString" }, { "modelName": "deed_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deed_date", "alias": "DEED_DATE", "type": "esriFieldTypeInteger" }, { "modelName": "deed_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deed_type", "length": 8000, "alias": "DEED_TYPE", "type": "esriFieldTypeString" }, { "modelName": "land_full_cash_value", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "land_full_cash_value", "alias": "LAND_FULL_CASH_VALUE", "type": "esriFieldTypeInteger" }, { "modelName": "improvement_full_cash_value", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "improvement_full_cash_value", "alias": "IMPROVEMENT_FULL_CASH_VALUE", "type": "esriFieldTypeInteger" }, { "modelName": "total_full_cash_value", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_full_cash_value", "alias": "TOTAL_FULL_CASH_VALUE", "type": "esriFieldTypeInteger" }, { "modelName": "total_full_cash_assessed_value", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_full_cash_assessed_value", "alias": "TOTAL_FULL_CASH_ASSESSED_VALUE", "type": "esriFieldTypeInteger" }, { "modelName": "limited_property_value", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "limited_property_value", "alias": "LIMITED_PROPERTY_VALUE", "type": "esriFieldTypeInteger" }, { "modelName": "lpv_assessed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lpv_assessed", "alias": "LPV_ASSESSED", "type": "esriFieldTypeInteger" }, { "modelName": "property_use_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_use_code", "alias": "PROPERTY_USE_CODE", "type": "esriFieldTypeInteger" }, { "modelName": "lot", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lot", "alias": "LOT", "type": "esriFieldTypeInteger" }, { "modelName": "block", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "block", "length": 8000, "alias": "BLOCK", "type": "esriFieldTypeString" }, { "modelName": "tract", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tract", "length": 8000, "alias": "TRACT", "type": "esriFieldTypeString" }, { "modelName": "landclass", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "landclass", "length": 8000, "alias": "LandClass", "type": "esriFieldTypeString" }, { "modelName": "improvementclass", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "improvementclass", "length": 8000, "alias": "ImprovementClass", "type": "esriFieldTypeString" }, { "modelName": "rental_indicator", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rental_indicator", "length": 8000, "alias": "RENTAL_INDICATOR", "type": "esriFieldTypeString" }, { "modelName": "living_area", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "living_area", "alias": "LIVING_AREA", "type": "esriFieldTypeInteger" }, { "modelName": "total_sq_ft", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_sq_ft", "alias": "TOTAL_SQ_FT", "type": "esriFieldTypeInteger" }, { "modelName": "contruction_year", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contruction_year", "alias": "CONTRUCTION_YEAR", "type": "esriFieldTypeInteger" }, { "modelName": "pool_size", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pool_size", "alias": "POOL_SIZE", "type": "esriFieldTypeInteger" }, { "modelName": "sale_price", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sale_price", "alias": "SALE_PRICE", "type": "esriFieldTypeInteger" }, { "modelName": "sale_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sale_date", "alias": "SALE_DATE", "type": "esriFieldTypeInteger" }, { "modelName": "mcr_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mcr_number", "alias": "MCR_NUMBER", "type": "esriFieldTypeInteger" }, { "modelName": "subdivision_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subdivision_name", "length": 8000, "alias": "SUBDIVISION_NAME", "type": "esriFieldTypeString" }, { "modelName": "number_of_units", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "number_of_units", "alias": "NUMBER_OF_UNITS", "type": "esriFieldTypeInteger" }, { "modelName": "tax_area_cd", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tax_area_cd", "alias": "TAX_AREA_CD", "type": "esriFieldTypeInteger" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r1594_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a1349_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "62f59b8d992b47bc9d994be8ad7be85c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 204, 204, 204, 255 ], "width": 0.7, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 252, 194, 206, 0 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true } ] }