Stormwater pipes is an inventory based on known construction asbuilt data and field inspections.<\/SPAN><\/P><\/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": [],
"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
},
"hasGeometryProperties": true,
"geometryProperties": {
"shapeLengthFieldName": "Shape__Length",
"units": "esriFeet"
},
"hasMetadata": true,
"extent": {
"xmin": 1657678.94833605,
"ymin": 115145.7153723985,
"xmax": 1875101.1296325475,
"ymax": 348020.77455572784,
"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": "esriSLS",
"style": "esriSLSDash",
"color": [
255,
170,
0,
255
],
"width": 2.5
},
"defaultLabel": "",
"uniqueValueInfos": [
{
"symbol": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
255,
170,
0,
255
],
"width": 2.5
},
"value": "1",
"label": "Our Agency"
}
],
"fieldDelimiter": ",",
"authoringInfo": {
"colorRamp": {
"type": "algorithmic",
"algorithm": "esriHSVAlgorithm",
"fromColor": [
214,
214,
255,
255
],
"toColor": [
0,
57,
148,
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_Stormwater_Line_Pipe",
"description": "",
"codedValues": [
{
"name": "Unknown",
"code": 0
},
{
"name": "ABS Plastic - ABS",
"code": 1
},
{
"name": "Asphalt - ASP",
"code": 3
},
{
"name": "Concrete (Non-Reinforced) - CP",
"code": 7
},
{
"name": "Corrugated Metal - CMP",
"code": 10
},
{
"name": "Earthen - EAR",
"code": 16
},
{
"name": "Galvanized Pipe - GP",
"code": 18
},
{
"name": "High Density Polyethylene - HDPE",
"code": 20
},
{
"name": "Polyethylene - PE",
"code": 23
},
{
"name": "Polypropylene - PP",
"code": 24
},
{
"name": "Polyvinyl Chloride - PVC",
"code": 25
},
{
"name": "Reinforced Concrete - RCP",
"code": 27
},
{
"name": "Steel - SP",
"code": 30
},
{
"name": "Wood - WD",
"code": 33
},
{
"name": "Corrugated Polyethylene - CPE",
"code": 34
},
{
"name": "Rock - ROCK",
"code": 35
},
{
"name": "Corrugated Steel Pipe - CSP",
"code": 36
},
{
"name": "Other - OTH",
"code": 100
},
{
"name": "Ductile Iron - DI",
"code": 37
}
],
"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": "diameter",
"type": "esriFieldTypeDouble",
"alias": "Diameter",
"domain": {
"type": "codedValue",
"name": "Stormwater_Pipe_Diameter",
"description": "",
"codedValues": [
{
"name": "Unknown",
"code": 0
},
{
"name": "1/2\"",
"code": 0.5
},
{
"name": "3/4\"",
"code": 0.75
},
{
"name": "1\"",
"code": 1
},
{
"name": "1 1/4\"",
"code": 1.25
},
{
"name": "1 1/2\"",
"code": 1.5
},
{
"name": "2\"",
"code": 2
},
{
"name": "2 1/2\"",
"code": 2.5
},
{
"name": "3\"",
"code": 3
},
{
"name": "4\"",
"code": 4
},
{
"name": "6\"",
"code": 6
},
{
"name": "8\"",
"code": 8
},
{
"name": "10\"",
"code": 10
},
{
"name": "12\"",
"code": 12
},
{
"name": "14\"",
"code": 14
},
{
"name": "15\"",
"code": 15
},
{
"name": "16\"",
"code": 16
},
{
"name": "18\"",
"code": 18
},
{
"name": "20\"",
"code": 20
},
{
"name": "24\"",
"code": 24
},
{
"name": "30\"",
"code": 30
},
{
"name": "36\"",
"code": 36
},
{
"name": "40\"",
"code": 40
},
{
"name": "42\"",
"code": 42
},
{
"name": "48\"",
"code": 48
},
{
"name": "54\"",
"code": 54
},
{
"name": "60\"",
"code": 60
},
{
"name": "66\"",
"code": 66
},
{
"name": "72\"",
"code": 72
},
{
"name": "75\"",
"code": 75
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "diameter"
},
{
"name": "upelev",
"type": "esriFieldTypeDouble",
"alias": "Upstream Elevation",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "upelev"
},
{
"name": "downelev",
"type": "esriFieldTypeDouble",
"alias": "Downstream Elevation",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "downelev"
},
{
"name": "slope",
"type": "esriFieldTypeDouble",
"alias": "Slope",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "slope"
},
{
"name": "pipeshape",
"type": "esriFieldTypeSmallInteger",
"alias": "Shape",
"domain": {
"type": "codedValue",
"name": "Stormwater_Pipe_Shape",
"description": "",
"codedValues": [
{
"name": "Unknown",
"code": 0
},
{
"name": "Circular",
"code": 1
},
{
"name": "Horseshoe",
"code": 2
},
{
"name": "Oblong",
"code": 3
},
{
"name": "Rectangular",
"code": 4
},
{
"name": "Trapezoidal",
"code": 5
},
{
"name": "Triangular",
"code": 6
},
{
"name": "Other",
"code": 100
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "pipeshape"
},
{
"name": "type",
"type": "esriFieldTypeSmallInteger",
"alias": "Type",
"domain": {
"type": "codedValue",
"name": "Stormwater_AssetType_Stormwater_Line_TypePipe",
"description": "",
"codedValues": [
{
"name": "Unknown",
"code": 0
},
{
"name": "Perforated",
"code": 1
},
{
"name": "Roof Drain",
"code": 2
},
{
"name": "Underground Drain",
"code": 3
},
{
"name": "French Drain",
"code": 4
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "type"
},
{
"name": "lined",
"type": "esriFieldTypeSmallInteger",
"alias": "Lined?",
"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": "lined"
},
{
"name": "lineryear",
"type": "esriFieldTypeSmallInteger",
"alias": "Liner Year",
"domain": {
"type": "range",
"name": "Stormwater_Pipe_Liner_Year",
"description": "",
"range": [
1800,
2060
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "lineryear"
},
{
"name": "linermethod",
"type": "esriFieldTypeSmallInteger",
"alias": "Liner Method",
"domain": {
"type": "codedValue",
"name": "Stormwater_Pipe_Liner_Method",
"description": "",
"codedValues": [
{
"name": "Unknown",
"code": 0
},
{
"name": "Cured in Place Pipe - CIP",
"code": 1
},
{
"name": "Fold and Form or Deform/Reform - FF",
"code": 2
},
{
"name": "Formed-In-Place Liner - FP",
"code": 3
},
{
"name": "Grout-In-Place Liner - GP",
"code": 4
},
{
"name": "Glass Reinforced Cement - GRC",
"code": 5
},
{
"name": "None - N",
"code": 6
},
{
"name": "Continuous Slip Liner - SC",
"code": 7
},
{
"name": "Sectional Slip Liner - SE",
"code": 8
},
{
"name": "Spray Liner - SL",
"code": 9
},
{
"name": "Segmented Panel - SN",
"code": 10
},
{
"name": "Segmented Pipe - SP",
"code": 11
},
{
"name": "Spiral Wound - SW",
"code": 12
},
{
"name": "Other - ZZ",
"code": 100
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "linermethod"
},
{
"name": "asset_type_lbl",
"type": "esriFieldTypeString",
"alias": "Asset Type Label",
"domain": {
"type": "codedValue",
"name": "Stormwater_Asset_Type_Stormwater_Line_Pipe_Label",
"description": "",
"codedValues": [
{
"name": "Unknown",
"code": "UNK"
},
{
"name": "ABS Plastic",
"code": "ABS"
},
{
"name": "Asphalt",
"code": "ASP"
},
{
"name": "Concrete (Non-Reinforced)",
"code": "CP"
},
{
"name": "Corrugated Metal",
"code": "CMP"
},
{
"name": "Earth",
"code": "EAR"
},
{
"name": "Galvanized Pipe",
"code": "GP"
},
{
"name": "High Density Polyethylene",
"code": "HDPE"
},
{
"name": "Polyethylene",
"code": "PE"
},
{
"name": "Polypropylene",
"code": "PP"
},
{
"name": "Polyvinyl Chloride",
"code": "PVC"
},
{
"name": "Reinforced Concrete",
"code": "RCP"
},
{
"name": "Steel",
"code": "SP"
},
{
"name": "Wood",
"code": "WD"
},
{
"name": "Corrugated Polyethylene",
"code": "CPE"
},
{
"name": "Rock",
"code": "ROCK"
},
{
"name": "Corrugated Steel Pipe",
"code": "CSP"
},
{
"name": "Other",
"code": "OTH"
},
{
"name": "Ductile Iron",
"code": "DI"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "asset_type"
},
{
"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": "Shape__Length",
"type": "esriFieldTypeDouble",
"alias": "Shape.Length",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "shape.STLength()"
},
{
"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"
}
],
"geometryField": {
"name": "shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape",
"domain": null,
"editable": false,
"nullable": true,
"defaultValue": null,
"modelName": "shape"
},
"indexes": [
{
"name": "R931_pk",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_931",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_OID_931",
"fields": "GlobalID,OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "S665_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"},
"diameter": {"type": "inherited"},
"pipeshape": {"type": "inherited"},
"type": {"type": "inherited"},
"lined": {"type": "inherited"},
"lineryear": {"type": "inherited"},
"linermethod": {"type": "inherited"},
"asset_type_lbl": {"type": "inherited"},
"lifecyclestatus": {"type": "inherited"}
},
"templates": [
{
"name": "Our Agency",
"description": "",
"prototype": {
"attributes": {"ownedby": 1}
},
"drawingTool": "esriFeatureEditToolLine"
}
]
}
],
"templates": [],
"maxRecordCount": 2000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb",
"capabilities": "Query,Sync",
"useStandardizedQueries": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"standardMaxRecordCount": 8000,
"tileMaxRecordCount": 4000,
"standardMaxRecordCountNoGeometry": 32000,
"maxRecordCountFactor": 1,
"serviceItemId": "1c71013e72324a68aae3d42a14a6103c"
}
],
"tables": []
}