{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Stormwater - Manhole", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "

Stormwater manholes is an inventory based on known construction asbuilt data and field inspections.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "copyrightText": "Schema provided by ESRI's small stormwater system", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user", "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "PWSDE.SDE.ManholeInspection", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": true } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": 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 } }, "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 }, "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": [ 195, 252, 192, 255 ], "toColor": [ 195, 252, 192, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 252, 255 ], "toColor": [ 252, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 223, 252, 255 ], "toColor": [ 184, 223, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 201, 189, 255 ], "toColor": [ 252, 201, 189, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 183, 252, 255 ], "toColor": [ 182, 183, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 243, 197, 255 ], "toColor": [ 252, 243, 197, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 243, 255 ], "toColor": [ 182, 252, 243, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 251, 255 ], "toColor": [ 252, 215, 251, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 202, 255 ], "toColor": [ 252, 179, 202, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 209, 207, 252, 255 ], "toColor": [ 209, 207, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 207, 252, 220, 255 ], "toColor": [ 207, 252, 220, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 229, 192, 252, 255 ], "toColor": [ 229, 192, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 242, 252, 182, 255 ], "toColor": [ 242, 252, 182, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": true, "enableZDefaults": true, "zDefault": 0, "supportsVCSProjection": true, "allowUpdateWithoutMValues": true, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "assettype", "typeIdField": "ownedby", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "assetid", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "assetid" }, { "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" }, "editable": true, "nullable": false, "defaultValue": null, "modelName": "assettype" }, { "name": "installdate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "installdate" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ownedby" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "maintby" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "conetype" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "location" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "surface" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "covershape" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "type" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "channel" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "bench" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "material" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "wall" }, { "name": "numsteps", "type": "esriFieldTypeSmallInteger", "alias": "Number of Steps", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "numsteps" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "stepmaterial" }, { "name": "symbolrotation", "type": "esriFieldTypeSmallInteger", "alias": "Symbol Rotation", "domain": { "type": "range", "name": "Stormwater_Symbol_Rotation", "description": "", "range": [ 0, 359 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "symbolrotation" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "surfacewater" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "exitsystem" }, { "name": "rimelev", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "rimelev" }, { "name": "invertelev", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "invertelev" }, { "name": "depth", "type": "esriFieldTypeDouble", "alias": "Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "depth" }, { "name": "highpipeelev", "type": "esriFieldTypeDouble", "alias": "High Pipe Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "highpipeelev" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comments" }, { "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" }, "editable": true, "nullable": false, "defaultValue": 8, "modelName": "lifecyclestatus" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created User", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edited Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited User", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "Global ID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "lastinspection", "type": "esriFieldTypeDate", "alias": "Last Inspection", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "lastinspection" }, { "name": "inspectioncycle", "type": "esriFieldTypeSmallInteger", "alias": "Inspection Cycle", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "inspectioncycle" } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [ { "id": 1, "name": "Our Agency", "domains": { "assettype": {"type": "inherited"}, "ownedby": {"type": "inherited"}, "maintby": {"type": "inherited"}, "conetype": {"type": "inherited"}, "location": {"type": "inherited"}, "surface": {"type": "inherited"}, "covershape": {"type": "inherited"}, "type": {"type": "inherited"}, "channel": {"type": "inherited"}, "bench": {"type": "inherited"}, "material": {"type": "inherited"}, "wall": {"type": "inherited"}, "stepmaterial": {"type": "inherited"}, "symbolrotation": {"type": "inherited"}, "surfacewater": {"type": "inherited"}, "exitsystem": {"type": "inherited"}, "lifecyclestatus": {"type": "inherited"} }, "templates": [ { "name": "Our Agency", "description": "", "prototype": { "attributes": {"ownedby": 1} }, "drawingTool": "esriFeatureEditToolPoint" } ] } ], "templates": [], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Uploads,Editing,Sync", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "f021e04aca4d4771aa7075f3510a0902" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "Manhole Inspection", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user", "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "PWSDE.SDE.Manhole", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentGUID", "composite": true } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "InspectPerf", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "InspectPerf", "type": "esriFieldTypeString", "alias": "Was an inspection performed?", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "InspectPerf" }, { "name": "OverallCond", "type": "esriFieldTypeString", "alias": "What is the overall condition?", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OverallCond" }, { "name": "MaintPerf", "type": "esriFieldTypeString", "alias": "What maintenance was done?", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MaintPerf" }, { "name": "MaintNeed", "type": "esriFieldTypeString", "alias": "What maintenance is still needed?", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MaintNeed" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Notes" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "parentguid", "type": "esriFieldTypeGUID", "alias": "Parent GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "parentguid" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Manhole Inspection", "description": "", "prototype": { "attributes": { "parentguid": null, "Notes": null, "InspectPerf": null, "OverallCond": null, "MaintPerf": null, "MaintNeed": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Uploads,Editing,Sync", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "f021e04aca4d4771aa7075f3510a0902" } ] }