{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1740612783970}, "relationships": [ { "keyField": "related_guid", "role": "esriRelRoleDestination", "composite": false, "name": "Stream_and_Stormwater_Issues", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "cimVersion": "3.0.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Stream and Stormwater Issues Inspections", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "infrastructure_score": null, "in_stream_obs_notes": null, "bank_erosion": null, "parking_lot_notes": null, "bridge_or_culvert": null, "issue_comments": null, "bank_erosion_notes": null, "building": null, "trail": null, "channel_dc_notes": null, "private_land_loss_notes": null, "inspection_id": null, "scour_at_pipe": null, "buffer": null, "safety_concern": null, "wall_notes": null, "other_infras_notes": null, "sidewalk": null, "roadway_flooding": null, "image_link": null, "in_stream_obs": null, "channel_downcutting": null, "failed_grade_stb": null, "related_guid": null, "site_name": null, "inspection_link": null, "additional_infrastructure": null, "site_id": null, "incised_chnl_notes": null, "roadway": null, "failed_bank_stb_notes": null, "channel_sed_notes": null, "parking_lot": null, "gully_erosion_notes": null, "gen_insp_comments": null, "sanitary_sewer": null, "safety_concern_notes": null, "buffer_notes": null, "inspection_date": null, "utility": null, "failed_bank_stb": null, "channel_sed": null, "sidewalk_notes": null, "issue_score": null, "scour_at_pipe_notes": null, "infrastructure_comments": null, "building_notes": null, "gully_erosion": null, "private_drive_notes": null, "trail_notes": null, "roadway_notes": null, "utility_notes": null, "total_score": null, "failed_grade_stb_notes": null, "other_issue": null, "incised_side_channel": null, "storm_sewer": null, "point_id": null, "additional_issue_score": null, "other_issue_notes": null, "bridge_or_culv_notes": null, "cityworks_inspection_id": null, "sanitary_sewer_notes": null, "other_infrastructure": null, "roadway_flooding_notes": null, "private_land_loss": null, "private_drive": null, "storm_sewer_notes": null, "fence_notes": null, "inspected_by": null, "fence": null, "wall": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.4, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Stream and Stormwater Issues Inspections", "displayField": "site_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "Site_Name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "site_name", "length": 100, "alias": "Site Name", "type": "esriFieldTypeString" }, { "modelName": "Site_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "site_id", "length": 50, "alias": "Site ID", "type": "esriFieldTypeString" }, { "modelName": "Point_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "point_id", "length": 50, "alias": "Point ID", "type": "esriFieldTypeString" }, { "modelName": "Inspection_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspection_id", "length": 50, "alias": "Inspection ID", "type": "esriFieldTypeString" }, { "modelName": "Inspected_By", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspected_by", "length": 50, "alias": "Inspector", "type": "esriFieldTypeString" }, { "modelName": "Inspection_Link", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspection_link", "length": 150, "alias": "Inspection Link", "type": "esriFieldTypeString" }, { "modelName": "Channel_Downcutting", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Issues", "description": "Issues", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "channel_downcutting", "alias": "Channel Downcutting", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Channel_DC_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "channel_dc_notes", "length": 250, "alias": "Channel Downcutting Notes", "type": "esriFieldTypeString" }, { "modelName": "Bank_Erosion", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Issues", "description": "Issues", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "bank_erosion", "alias": "Bank Erosion / Widening", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Bank_Erosion_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bank_erosion_notes", "length": 250, "alias": "Bank Erosion Notes", "type": "esriFieldTypeString" }, { "modelName": "Incised_Side_Channel", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Issues", "description": "Issues", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "incised_side_channel", "alias": "Incised Side Channel", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Incised_Chnl_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "incised_chnl_notes", "length": 250, "alias": "Incised Channel Notes", "type": "esriFieldTypeString" }, { "modelName": "Scour_at_Pipe", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Issues", "description": "Issues", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "scour_at_pipe", "alias": "Scour at Pipe", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Scour_at_Pipe_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scour_at_pipe_notes", "length": 250, "alias": "Scour at Pipe Notes", "type": "esriFieldTypeString" }, { "modelName": "Gully_Erosion", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Issues", "description": "Issues", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "gully_erosion", "alias": "Gully Erosion / Upland Swale", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Gully_Erosion_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gully_erosion_notes", "length": 250, "alias": "Gully Erosion Notes", "type": "esriFieldTypeString" }, { "modelName": "Buffer", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Issues", "description": "Issues", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "buffer", "alias": "Buffer", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Buffer_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "buffer_notes", "length": 250, "alias": "Buffer Notes", "type": "esriFieldTypeString" }, { "modelName": "Failed_Grade_Stb", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Issues", "description": "Issues", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "failed_grade_stb", "alias": "Failed Grade Stabilization", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Failed_Grade_Stb_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "failed_grade_stb_notes", "length": 250, "alias": "Failed Grade Stb Notes", "type": "esriFieldTypeString" }, { "modelName": "Failed_Bank_Stb", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Issues", "description": "Issues", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "failed_bank_stb", "alias": "Failed Bank Stabilization", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Failed_Bank_Stb_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "failed_bank_stb_notes", "length": 250, "alias": "Failed Bank Stb Notes", "type": "esriFieldTypeString" }, { "modelName": "Channel_Sed", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Issues", "description": "Issues", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "channel_sed", "alias": "Channel Sedimentation", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Channel_Sed_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "channel_sed_notes", "length": 250, "alias": "Channel Sed Notes", "type": "esriFieldTypeString" }, { "modelName": "In_Stream_Obs", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Issues", "description": "Issues", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "in_stream_obs", "alias": "In-Stream Obstruction", "type": "esriFieldTypeSmallInteger" }, { "modelName": "In_Stream_Obs_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "in_stream_obs_notes", "length": 250, "alias": "In-Stream Obstruction Notes", "type": "esriFieldTypeString" }, { "modelName": "Roadway_Flooding", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Issues", "description": "Issues", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "roadway_flooding", "alias": "Roadway Flooding", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Roadway_Flooding_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "roadway_flooding_notes", "length": 250, "alias": "Roadway Flooding Notes", "type": "esriFieldTypeString" }, { "modelName": "Other_Issue", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Issues", "description": "Issues", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "other_issue", "alias": "Other Issue", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Other_Issue_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_issue_notes", "length": 250, "alias": "Other Issue Notes", "type": "esriFieldTypeString" }, { "modelName": "Additional_Issue_Score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "additional_issue_score", "alias": "Additional Issue Score", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Issue_Score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "issue_score", "alias": "Current Issue Score", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Issue_Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "issue_comments", "length": 250, "alias": "Issue Comments", "type": "esriFieldTypeString" }, { "modelName": "Sanitary_Sewer", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "sanitary_sewer", "alias": "Sanitary Sewer", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Sanitary_Sewer_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sanitary_sewer_notes", "length": 250, "alias": "Sanitary Sewer Notes", "type": "esriFieldTypeString" }, { "modelName": "Storm_Sewer", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "storm_sewer", "alias": "Storm Sewer", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Storm_Sewer_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "storm_sewer_notes", "length": 250, "alias": "Storm Sewer Notes", "type": "esriFieldTypeString" }, { "modelName": "Utility", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "utility", "alias": "Utility", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Utility_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "utility_notes", "length": 250, "alias": "Utility Notes", "type": "esriFieldTypeString" }, { "modelName": "Roadway", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "roadway", "alias": "Roadway", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Roadway_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "roadway_notes", "length": 250, "alias": "Roadway Notes", "type": "esriFieldTypeString" }, { "modelName": "Bridge_or_Culvert", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "bridge_or_culvert", "alias": "Bridge or Culvert", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Bridge_or_Culv_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bridge_or_culv_notes", "length": 250, "alias": "Bridge or Culvert Notes", "type": "esriFieldTypeString" }, { "modelName": "Building", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "building", "alias": "Building", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Building_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "building_notes", "length": 250, "alias": "Building Notes", "type": "esriFieldTypeString" }, { "modelName": "Fence", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "fence", "alias": "Fence", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Fence_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fence_notes", "length": 250, "alias": "Fence Notes", "type": "esriFieldTypeString" }, { "modelName": "Wall", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "wall", "alias": "Wall", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Wall_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wall_notes", "length": 250, "alias": "Wall Notes", "type": "esriFieldTypeString" }, { "modelName": "Trail", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "trail", "alias": "Trail", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Trail_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "trail_notes", "length": 250, "alias": "Trail Notes", "type": "esriFieldTypeString" }, { "modelName": "Sidewalk", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "sidewalk", "alias": "Sidewalk", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Sidewalk_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sidewalk_notes", "length": 250, "alias": "Sidewalk Notes", "type": "esriFieldTypeString" }, { "modelName": "Safety_Concern", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "safety_concern", "alias": "Safety Concern", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Safety_Concern_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "safety_concern_notes", "length": 250, "alias": "Safety Concern Notes", "type": "esriFieldTypeString" }, { "modelName": "Parking_Lot", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "parking_lot", "alias": "Parking Lot", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Parking_Lot_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parking_lot_notes", "length": 250, "alias": "Parking Lot Notes", "type": "esriFieldTypeString" }, { "modelName": "Private_Drive", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "private_drive", "alias": "Private Drive", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Private_Drive_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "private_drive_notes", "length": 250, "alias": "Private Drive Notes", "type": "esriFieldTypeString" }, { "modelName": "Private_Land_Loss", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "private_land_loss", "alias": "Private Land Loss", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Private_Land_Loss_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "private_land_loss_notes", "length": 250, "alias": "Private Land Loss Notes", "type": "esriFieldTypeString" }, { "modelName": "Other_Infrastructure", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Infrastructure", "description": "Infrastructure", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Low" }, { "code": 2, "name": "Medium" }, { "code": 3, "name": "High" }, { "code": 4, "name": "Immediate Threat" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "other_infrastructure", "alias": "Other Infrastructure", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Other_Infras_Notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_infras_notes", "length": 250, "alias": "Other Infrastructure Notes", "type": "esriFieldTypeString" }, { "modelName": "Additional_Infrastructure", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "additional_infrastructure", "alias": "Additional Infrastructure", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Infrastructure_Score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "infrastructure_score", "alias": "Infrastructure Score", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Infrastructure_Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "infrastructure_comments", "length": 250, "alias": "Infrastructure Comments", "type": "esriFieldTypeString" }, { "modelName": "Total_Score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_score", "alias": "Total Score", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Gen_Insp_Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gen_insp_comments", "length": 1000, "alias": "Overall Inspection Comments", "type": "esriFieldTypeString" }, { "modelName": "Image_Link", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "image_link", "length": 150, "alias": "Image Link", "type": "esriFieldTypeString" }, { "modelName": "Cityworks_Inspection_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cityworks_inspection_id", "length": 150, "alias": "Cityworks_Inspection_ID", "type": "esriFieldTypeString" }, { "modelName": "Related_GUID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "related_guid", "length": 38, "alias": "Related_GUID", "type": "esriFieldTypeGUID" }, { "modelName": "created_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "modelName": "created_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "modelName": "last_edited_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "modelName": "last_edited_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "inspection_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "inspection_date", "length": 29, "alias": "Inspection_Date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g4961point_id", "isUnique": false, "description": "", "fields": "point_id", "isAscending": true }, { "name": "g4961related_gui", "isUnique": false, "description": "", "fields": "related_guid", "isAscending": true }, { "name": "r2474_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_2474", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": true, "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": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "c2688f50cd2345d292182a3b156f3395", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 514343.4292354733, "xmin": 2668463.5688918084, "ymax": 578378.201756224, "xmax": 2759908.8692685515, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 26852, "zTolerance": 0.001, "wkid": 102704, "xyUnits": 3048.006096012192, "mTolerance": 0.001, "falseX": -119097700, "falseY": -96454900, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1740610233282}, "relationships": [ { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": false, "name": "Stream_and_Stormwater_Issues_Inspections", "relatedTableId": 2, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "cimVersion": "3.0.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Stream and Stormwater Issues", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "construction_access": null, "public_or_private": null, "point_id": null, "comments": null, "issue_comments": null, "link": null, "proposed_action": null, "basin": null, "priority": null, "legacy_point_id": null, "site_name": null, "infrastructure_comments": null, "current_total_score": null, "cost_estimate": null, "current_infrastructure_score": null, "location": null, "legacy_objectid": null, "category": null, "current_issue_score": null, "legacy_siteid": null, "timestamp": null, "status": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": true, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Stream and Stormwater Issues", "allowTrueCurvesUpdates": false, "displayField": "site_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "Site_Name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "site_name", "length": 100, "alias": "Site Name", "type": "esriFieldTypeString" }, { "modelName": "Point_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "point_id", "length": 200, "alias": "Point ID", "type": "esriFieldTypeString" }, { "modelName": "Location", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 150, "alias": "Location", "type": "esriFieldTypeString" }, { "modelName": "Construction_Access", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Construction_Access", "description": "Construction_Access", "type": "codedValue", "codedValues": [ { "code": "Poor", "name": "Poor" }, { "code": "Fair", "name": "Fair" }, { "code": "Good", "name": "Good" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "construction_access", "length": 50, "alias": "Construction Access", "type": "esriFieldTypeString" }, { "modelName": "Category", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Category_2", "description": "Category", "type": "codedValue", "codedValues": [ { "code": "0", "name": "Channel Erosion/Degradation" }, { "code": "1", "name": "Localized Drainage/Erosion Issue" }, { "code": "2", "name": "Flooding" }, { "code": "3", "name": "Maintenance" }, { "code": "4", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "category", "length": 100, "alias": "Category", "type": "esriFieldTypeString" }, { "modelName": "Public_or_Private", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Public_or_Private", "description": "Public or Private", "type": "codedValue", "codedValues": [ { "code": "Public", "name": "Public" }, { "code": "Private", "name": "Private" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "public_or_private", "length": 7, "alias": "Public or Private", "type": "esriFieldTypeString" }, { "modelName": "Current_Issue_Score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "current_issue_score", "alias": "Current Issue Score", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Issue_Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "issue_comments", "length": 250, "alias": "Issue Comments", "type": "esriFieldTypeString" }, { "modelName": "Current_Infrastructure_Score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "current_infrastructure_score", "alias": "Infrastructure Score", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Infrastructure_Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "infrastructure_comments", "length": 250, "alias": "Infrastructure Comments", "type": "esriFieldTypeString" }, { "modelName": "Current_Total_Score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "current_total_score", "alias": "Total Score", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Priority", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Priority", "description": "Priority", "type": "codedValue", "codedValues": [ { "code": "Low", "name": "Low" }, { "code": "Medium", "name": "Medium" }, { "code": "High", "name": "High" }, { "code": "Immediate", "name": "Immediate" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "priority", "length": 50, "alias": "Priority", "type": "esriFieldTypeString" }, { "modelName": "Proposed_Action", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "proposed_action", "length": 150, "alias": "Proposed Action", "type": "esriFieldTypeString" }, { "modelName": "Cost_Estimate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cost_estimate", "alias": "Cost Estimate", "type": "esriFieldTypeInteger" }, { "modelName": "Status", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Status_3", "description": "Status", "type": "codedValue", "codedValues": [ { "code": "0", "name": "No Action" }, { "code": "1", "name": "Monitoring" }, { "code": "2", "name": "Work Order Initiated" }, { "code": "3", "name": "Work Order Completed" }, { "code": "4", "name": "Study Initiated" }, { "code": "5", "name": "Study Completed" }, { "code": "6", "name": "Conceptual Design" }, { "code": "7", "name": "Preliminary Design" }, { "code": "8", "name": "Final Design" }, { "code": "9", "name": "Construction" }, { "code": "10", "name": "Project Completed" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "status", "length": 50, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 1000, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "Link", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "link", "length": 150, "alias": "Image Link", "type": "esriFieldTypeString" }, { "modelName": "Legacy_ObjectID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacy_objectid", "alias": "Legacy_ObjectID", "type": "esriFieldTypeInteger" }, { "modelName": "Legacy_SiteID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacy_siteid", "length": 100, "alias": "Legacy_SiteID", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "created_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "modelName": "created_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "modelName": "last_edited_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "modelName": "last_edited_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "modelName": "BASIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "basin", "length": 50, "alias": "Basin", "type": "esriFieldTypeString" }, { "modelName": "TIMESTAMP", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "timestamp", "length": 50, "alias": "Timestamp", "type": "esriFieldTypeString" }, { "modelName": "LEGACY_POINT_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacy_point_id", "length": 200, "alias": "Legacy Point ID", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r2472_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_2472", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a1754_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "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": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "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 }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "c2688f50cd2345d292182a3b156f3395", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportsVCSProjection": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.6 }, "color": [ 230, 0, 0, 153 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "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": 511669.16227431595, "xmin": 2668327.7909481376, "ymax": 578618.2016043067, "xmax": 2761340.618701637, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 26852, "zTolerance": 0.001, "wkid": 102704, "xyUnits": 3048.006096012192, "mTolerance": 0.001, "falseX": -119097700, "falseY": -96454900, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1740610162483}, "relationships": [], "hasViews": true, "supportsAttachmentsResizing": true, "cimVersion": "3.0.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Stream and Stormwater Sites", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "description_of_issue": null, "comments": null, "affected_channel_length": null, "nearest_waterbody": null, "improved_or_unimproved": null, "opw_number": null, "site_name": null, "cip_program": null, "cost_estimate": null, "site_address": null, "contact": null, "site_id": null, "funding_comments": null, "cip_id": null, "current_cip": null, "status": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Stream and Stormwater Sites", "allowTrueCurvesUpdates": false, "displayField": "site_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "Site_Name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "site_name", "length": 50, "alias": "Site Name", "type": "esriFieldTypeString" }, { "modelName": "Site_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "site_id", "length": 50, "alias": "Site ID", "type": "esriFieldTypeString" }, { "modelName": "Site_Address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "site_address", "length": 100, "alias": "Site Location", "type": "esriFieldTypeString" }, { "modelName": "Nearest_Waterbody", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nearest_waterbody", "length": 50, "alias": "Nearest Waterbody", "type": "esriFieldTypeString" }, { "modelName": "Affected_Channel_Length", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "affected_channel_length", "alias": "Affected Channel Length (LF)", "type": "esriFieldTypeDouble" }, { "modelName": "Improved_or_Unimproved", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Improved_or_Unimproved", "description": "Improved or Unimproved", "type": "codedValue", "codedValues": [ { "code": "Improved", "name": "Improved" }, { "code": "Unimproved", "name": "Unimproved" }, { "code": "Unknown", "name": "Unknown" }, { "code": "N/A", "name": "N/A" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "improved_or_unimproved", "length": 50, "alias": "Improved or Unimproved", "type": "esriFieldTypeString" }, { "modelName": "Description_of_Issue", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description_of_issue", "length": 100, "alias": "Description of Issue", "type": "esriFieldTypeString" }, { "modelName": "OPW_Number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "opw_number", "alias": "OPW Number", "type": "esriFieldTypeInteger" }, { "modelName": "Contact", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contact", "length": 50, "alias": "Contact", "type": "esriFieldTypeString" }, { "modelName": "Cost_Estimate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cost_estimate", "alias": "Cost Estimate", "type": "esriFieldTypeInteger" }, { "modelName": "Funding_Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "funding_comments", "length": 150, "alias": "Funding Comments", "type": "esriFieldTypeString" }, { "modelName": "Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 1000, "alias": "General Comments", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "created_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "modelName": "created_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "modelName": "last_edited_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "modelName": "last_edited_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "modelName": "STATUS", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Stream_Storm_Status", "description": "Stream & Stormwater Status", "type": "codedValue", "codedValues": [ { "code": "Complete", "name": "Complete" }, { "code": "Construction", "name": "Construction" }, { "code": "Design", "name": "Design" }, { "code": "Monitoring", "name": "Monitoring" }, { "code": "N/A", "name": "N/A" }, { "code": "Needs Inspection/Reinspection", "name": "Needs Inspection/Reinspection" }, { "code": "Study", "name": "Study" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "status", "length": 30, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "CIP_PROGRAM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "CIP_Program", "description": "CIP Program", "type": "codedValue", "codedValues": [ { "code": "Capital Asset Replacement Program", "name": "Capital Asset Replacement Program" }, { "code": "Channel Rehabilitation Program", "name": "Channel Rehabilitation Program" }, { "code": "Cole Creek Flood Mitigation", "name": "Cole Creek Flood Mitigation" }, { "code": "Combined Sewer Overflow Control Implementations", "name": "Combined Sewer Overflow Control Implementations" }, { "code": "Combined Sewer Renovation Program", "name": "Combined Sewer Renovation Program" }, { "code": "Erosion/Storm Sewer Repair", "name": "Erosion/Storm Sewer Repair" }, { "code": "Local Neighborhood Storm Sewer Improvements", "name": "Local Neighborhood Storm Sewer Improvements" }, { "code": "Missouri River Flood Levee Maintenance & Repairs", "name": "Missouri River Flood Levee Maintenance & Repairs" }, { "code": "Papillion Creek Interceptor Sewers", "name": "Papillion Creek Interceptor Sewers" }, { "code": "Sewer Reconstruction/Rehabilitation", "name": "Sewer Reconstruction/Rehabilitation" }, { "code": "Stormwater Facilities Capital Asset Replacement", "name": "Stormwater Facilities Capital Asset Replacement" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "cip_program", "length": 150, "alias": "CIP Program", "type": "esriFieldTypeString" }, { "modelName": "CIP_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "CIP_ID_2", "description": "CIP ID", "type": "codedValue", "codedValues": [ { "code": " 2011E102", "name": "2011E102" }, { "code": "1982E505", "name": "1982E505" }, { "code": "1982E509", "name": "1982E509" }, { "code": "1991E501", "name": "1991E501" }, { "code": "2000E507", "name": "2000E507" }, { "code": "2007E202", "name": "2007E202" }, { "code": "2007E503", "name": "2007E503" }, { "code": "2007E504", "name": "2007E504" }, { "code": "2009E502", "name": "2009E502" }, { "code": "2018E510", "name": "2018E510" }, { "code": "2019E512", "name": "2019E512" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "cip_id", "length": 20, "alias": "CIP ID", "type": "esriFieldTypeString" }, { "modelName": "CURRENT_CIP", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes No", "description": "Yes or No", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "current_cip", "length": 5, "alias": "Current CIP", "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": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriFeet" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r2473_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_2473", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a1755_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "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": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "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 }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "c2688f50cd2345d292182a3b156f3395", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 132, 0, 168, 255 ], "width": 1.5, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 231, 201, 252, 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 } ] }