{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Stormwater - Manhole", "type": "Feature Layer", "description": "

Stormwater manholes is an inventory based on known construction asbuilt data and field inspections.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102748, "latestWkid": 2285, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "Schema provided by ESRI's small stormwater system", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "ownedby", "defaultSymbol": { "type": "esriPMS", "url": "45826085d9155b93d49ce33d2b7bae02", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABUElEQVQ4jaWTsY3DMAxFX5FWA4QLaIBoAfWGF3CfywKu7dRewEivCZLeC9gDaAFmAC9wRSRDCRLkgCPghvp85JepHf+M3Yf8IX0C7IEbsAD6F0APdNZajDEYY4gxHlUV4JzOPwKuIlJ577HWbknvPapKCKFb17UC3DtALyLV6XR660lEaNuWcRwPqtrnSTLgAHR1XT8VpbERkS3XNA3DMHTABdANYK19EoYQiDEC4Jwjw40xWGuJMVbAJQPEGPPUORcDzPOMc25rkLRSWtiXgG+RtPsScIsxHr33m2fnHPM8A/BqL013LwGLqqKqm7Cua5xzG7C0ly73WgIUOIcQurZtN3FZmGOaJnj8gaUEAPTrulbjOB6apuH1TlSVaZqIMS7AT86/bqJT1X4Yhk5EEJG8ynnsS1n8DgCPDbuoaqWq+THdk+flVfzpNWrq9jV+AV63iV3gVlOEAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "f89f1845112a1b507e40eab302f1eb15", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABVElEQVQ4jaWTsYrCQBCGv0LQLuWihddZLki0vE7BIo8g2HkP4AMktoIvkE64N9DiIHaWEoQtLa+IpNzO8ordNRuJ3MENBMLszDf/n8y2+Ge0XuRD+/SALnAAcqD4CyAB4qkA0QbRgaxkqTQAa3v+ErCXAdFqAFNRJVcDUBoWZ+LyTgSMmgCJDIi+3ps9yQAuE5idCJUmcUocIATijaw3WdnIoMrtxjA8EgMpUDwAU1EvXJwhK837vA8OLjrGXlYSAakD9ES7Ptk1A3x+w/ytGmBre76Frug0e28KW9v1AYesZLkaVJ7nfTMZjGTfnlV38wG50ka6K9xII9sBfXv24+59QAGsF2fiy6Qq9htdbK+A+QO5DwBIyjvR7ES4Gz981iZvr5CV5MCHyz9v4khpkuGRWAZGgV1lJzv1m5sAYDYsVZpI6cdlulnP+XPxq9tY2Gm/xg+PDGX6FH0eyQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "1", "label": "Our Agency" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 187, 252, 208, 255 ], "toColor": [ 187, 252, 208, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 250, 179, 252, 255 ], "toColor": [ 250, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 201, 189, 255 ], "toColor": [ 252, 201, 189, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 217, 252, 255 ], "toColor": [ 179, 217, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 240, 179, 255 ], "toColor": [ 252, 240, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 184, 252, 255 ], "toColor": [ 184, 184, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 252, 255 ], "toColor": [ 252, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 204, 252, 252, 255 ], "toColor": [ 204, 252, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 218, 252, 179, 255 ], "toColor": [ 218, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 199, 255 ], "toColor": [ 252, 179, 199, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 240, 215, 255 ], "toColor": [ 252, 240, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 234, 252, 207, 255 ], "toColor": [ 234, 252, 207, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 223, 192, 252, 255 ], "toColor": [ 223, 192, 252, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1682248.834235549, "ymin": 115157.11856481433, "xmax": 1815268.3821723014, "ymax": 337493.7536150664, "spatialReference": { "wkid": 102748, "latestWkid": 2285, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "assettype", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "domain": null }, { "name": "assetid", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 50, "domain": null }, { "name": "assettype", "type": "esriFieldTypeSmallInteger", "alias": "Asset Type", "domain": { "type": "codedValue", "name": "Stormwater_Asset_Type_Structure_Junction_Manhole", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Manhole Type 1", "code": 2 }, { "name": "Manhole Type 2", "code": 3 }, { "name": "Manhole Type 3", "code": 6 }, { "name": "Standard", "code": 7 }, { "name": "Drop", "code": 8 }, { "name": "Split", "code": 9 }, { "name": "Diversion", "code": 10 }, { "name": "Sedimentation", "code": 11 }, { "name": "Other", "code": 12 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "installdate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "ownedby", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "Stormwater_Asset_Owner", "description": "", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": 2 }, { "name": "Other", "code": 100 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "maintby", "type": "esriFieldTypeSmallInteger", "alias": "Maintained By", "domain": { "type": "codedValue", "name": "Stormwater_Asset_Manager", "description": "", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": 2 }, { "name": "Other", "code": 100 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "conetype", "type": "esriFieldTypeSmallInteger", "alias": "Cone Type", "domain": { "type": "codedValue", "name": "Stormwater_Structure_Manhole_Cone", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Straight", "code": 1 }, { "name": "Offset", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "location", "type": "esriFieldTypeSmallInteger", "alias": "Manhole Location", "domain": { "type": "codedValue", "name": "Stormwater_Structure_Manhole_Location", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Main Highway", "code": 1 }, { "name": "Light Highway", "code": 2 }, { "name": "Easement/Right of Way", "code": 3 }, { "name": "Woods", "code": 4 }, { "name": "Sidewalk", "code": 5 }, { "name": "Parking Lot", "code": 6 }, { "name": "Alley", "code": 7 }, { "name": "Ditch", "code": 8 }, { "name": "Building", "code": 9 }, { "name": "Creek", "code": 10 }, { "name": "Railway", "code": 11 }, { "name": "Airport", "code": 12 }, { "name": "Yard", "code": 13 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "surface", "type": "esriFieldTypeSmallInteger", "alias": "Manhole Surface Type", "domain": { "type": "codedValue", "name": "Stormwater_Structure_Manhole_Surface", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Asphalt", "code": 1 }, { "name": "Concrete Pavement", "code": 2 }, { "name": "Concrete Collar", "code": 3 }, { "name": "Grass/Dirt", "code": 4 }, { "name": "Gravel", "code": 5 }, { "name": "Other", "code": 100 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "covershape", "type": "esriFieldTypeSmallInteger", "alias": "Cover Shape", "domain": { "type": "codedValue", "name": "Stormwater_Structure_Manhole_Cover_Shape", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Arched (with flat bottom) - A", "code": 3 }, { "name": "Barrel - B", "code": 4 }, { "name": "Circular - C", "code": 5 }, { "name": "Egg shaped - E", "code": 6 }, { "name": "Horseshoe - H", "code": 7 }, { "name": "Oval or Elliptical - O", "code": 8 }, { "name": "Rectangular - R", "code": 9 }, { "name": "Square - S", "code": 10 }, { "name": "Trapezoidal - T", "code": 11 }, { "name": "U-Shaped with flat top (straight walls) - U", "code": 12 }, { "name": "Other - Z", "code": 100 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "type", "type": "esriFieldTypeSmallInteger", "alias": "Cover Type", "domain": { "type": "codedValue", "name": "Stormwater_Structure_Manhole_Cover_Type", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Solid", "code": 3 }, { "name": "Vented/Slotted", "code": 4 }, { "name": "Gasketed", "code": 5 }, { "name": "Bolted", "code": 6 }, { "name": "Inner Cover", "code": 7 }, { "name": "Locking", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "channel", "type": "esriFieldTypeSmallInteger", "alias": "Channel", "domain": { "type": "codedValue", "name": "Stormwater_Yes_No", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "bench", "type": "esriFieldTypeSmallInteger", "alias": "Bench", "domain": { "type": "codedValue", "name": "Stormwater_Yes_No", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "material", "type": "esriFieldTypeSmallInteger", "alias": "Frame Material", "domain": { "type": "codedValue", "name": "Stormwater_Structure_Manhole_Frame_Material", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Acrylonitrile Butadiene Styrene - ABS", "code": 1 }, { "name": "Cast Iron - CAS", "code": 5 }, { "name": "Ductile Iron Pipe - DIP", "code": 11 }, { "name": "High Density Polyethelyene - HDPE", "code": 15 }, { "name": "Plastic/Steel Composite - PSC", "code": 17 }, { "name": "Polyethylene - PE", "code": 18 }, { "name": "Polypropylene - PP", "code": 19 }, { "name": "Polyvinyle Chloride - PVC", "code": 20 }, { "name": "Reinforced Plastic Pipe (Truss Pipe) - RPM", "code": 23 }, { "name": "Steel Pipe - SP", "code": 25 }, { "name": "Other", "code": 100 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "wall", "type": "esriFieldTypeSmallInteger", "alias": "Wall", "domain": { "type": "codedValue", "name": "Stormwater_Yes_No", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "numsteps", "type": "esriFieldTypeSmallInteger", "alias": "Number of Steps", "domain": null }, { "name": "stepmaterial", "type": "esriFieldTypeSmallInteger", "alias": "Step Material", "domain": { "type": "codedValue", "name": "Stormwater_Structure_Manhole_Step_Material", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Metal - M", "code": 1 }, { "name": "Plastic - P", "code": 2 }, { "name": "Brick - B", "code": 3 }, { "name": "Other - Z", "code": 100 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "symbolrotation", "type": "esriFieldTypeSmallInteger", "alias": "Symbol Rotation", "domain": { "type": "range", "name": "Stormwater_Symbol_Rotation", "description": "", "range": [ 0, 359 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "surfacewater", "type": "esriFieldTypeSmallInteger", "alias": "Receives Surface Water", "domain": { "type": "codedValue", "name": "Stormwater_Yes_No", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "exitsystem", "type": "esriFieldTypeSmallInteger", "alias": "Water Existing System", "domain": { "type": "codedValue", "name": "Stormwater_Exiting_System", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Waterway", "code": 1 }, { "name": "Other System", "code": 2 }, { "name": "None", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "rimelev", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null }, { "name": "invertelev", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null }, { "name": "depth", "type": "esriFieldTypeDouble", "alias": "Depth", "domain": null }, { "name": "highpipeelev", "type": "esriFieldTypeDouble", "alias": "High Pipe Elevation", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "lifecyclestatus", "type": "esriFieldTypeSmallInteger", "alias": "Life Cycle Status", "domain": { "type": "codedValue", "name": "Stormwater_Lifecycle_Status", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Proposed", "code": 1 }, { "name": "Proposed - Approved", "code": 2 }, { "name": "Under Construction", "code": 4 }, { "name": "In Service", "code": 8 }, { "name": "In Service - To Be Retired", "code": 16 }, { "name": "Abandoned", "code": 32 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created User", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edited Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited User", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "Global ID", "length": 38, "domain": null }, { "name": "lastinspection", "type": "esriFieldTypeDate", "alias": "Last Inspection", "length": 8, "domain": null }, { "name": "inspectioncycle", "type": "esriFieldTypeSmallInteger", "alias": "Inspection Cycle", "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R899_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_899", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ManholeIndex", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S645_idx", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PWSDE.SDE.ManholeInspection", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "8d618345848b41cd8c928f7c452dc0c8" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "Manhole Inspection", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "InspectPerf", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "InspectPerf", "type": "esriFieldTypeString", "alias": "Was an inspection performed?", "length": 10, "domain": { "type": "codedValue", "name": "Stormwater_Inspection_Performed_Inspection", "description": "Was an inspection performed", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OverallCond", "type": "esriFieldTypeString", "alias": "What is the overall condition?", "length": 50, "domain": { "type": "codedValue", "name": "Stormwater_Inspection_Overall_Condition", "description": "What is the overall condition", "codedValues": [ { "name": "Unknown", "code": "1" }, { "name": "Poor", "code": "2" }, { "name": "Fair", "code": "3" }, { "name": "Good", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintPerf", "type": "esriFieldTypeString", "alias": "What maintenance was done?", "length": 50, "domain": { "type": "codedValue", "name": "Stormwater_Inspection_Maintenance_Performed", "description": "Was maintenance performed", "codedValues": [ { "name": "None", "code": "5" }, { "name": "Cleaned", "code": "6" }, { "name": "Repaired", "code": "7" }, { "name": "Replaced", "code": "8" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintNeed", "type": "esriFieldTypeString", "alias": "What maintenance is still needed?", "length": 50, "domain": { "type": "codedValue", "name": "Stormwater_Inspection_Maintenance_Needed", "description": "What additional maintenance is still needed", "codedValues": [ { "name": "None", "code": "9" }, { "name": "Clean", "code": "10" }, { "name": "Repair", "code": "11" }, { "name": "Replace", "code": "12" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "parentguid", "type": "esriFieldTypeGUID", "alias": "Parent GUID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R971_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_13829_Parent", "fields": "parentguid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_971", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_971", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PWSDE.SDE.Manhole", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ParentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "8d618345848b41cd8c928f7c452dc0c8" } ] }