In 2018 the City of Richland Energy Services Department used ESRI data models to create an ArcSDE database to store the cities electrical network providing power to Richland. Data was obtained from AutoCAD drawings and older database systems and has been migrated into a network feature dataset as well as a non-network dataset containing supporting structures for our infrastructure.<\/SPAN><\/P><\/P><\/DIV><\/DIV><\/DIV>",
"geometryType": "esriGeometryPolyline",
"sourceSpatialReference": {
"wkid": 102749,
"latestWkid": 2286,
"xyTolerance": 0.003280833333333333,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -117498300,
"falseY": -98850300,
"xyUnits": 3048.0060960121928,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
},
"copyrightText": "City of Richland Energy Services Engineering Department",
"parentLayer": {
"id": 11,
"name": "Secondary Conductor"
},
"subLayers": [],
"minScale": 6000,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "uniqueValue",
"field1": "Placement",
"defaultSymbol": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
130,
130,
130,
255
],
"width": 1
},
"defaultLabel": "",
"uniqueValueInfos": [
{
"symbol": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
0,
0,
0,
255
],
"width": 0.4
},
"value": "1",
"label": "Overhead"
},
{
"symbol": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
255,
0,
0,
255
],
"width": 0.4
},
"value": "3",
"label": "Underground"
}
],
"fieldDelimiter": ",",
"authoringInfo": {
"colorRamp": {
"type": "multipart",
"colorRamps": [
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
194,
230,
252,
255
],
"toColor": [
194,
230,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
201,
252,
179,
255
],
"toColor": [
201,
252,
179,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
249,
182,
252,
255
],
"toColor": [
249,
182,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
214,
184,
255
],
"toColor": [
252,
214,
184,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
179,
183,
252,
255
],
"toColor": [
179,
183,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
202,
252,
229,
255
],
"toColor": [
202,
252,
229,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
192,
209,
255
],
"toColor": [
252,
192,
209,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
251,
192,
255
],
"toColor": [
252,
251,
192,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
249,
215,
252,
255
],
"toColor": [
249,
215,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
204,
208,
252,
255
],
"toColor": [
204,
208,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
222,
252,
210,
255
],
"toColor": [
222,
252,
210,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
216,
215,
255
],
"toColor": [
252,
216,
215,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
240,
207,
255
],
"toColor": [
252,
240,
207,
255
]
}
]
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": true,
"extent": {
"xmin": 1927802.5734982193,
"ymin": 317272.4833559692,
"xmax": 1965603.2725029737,
"ymax": 379967.67456638813,
"spatialReference": {
"wkid": 102749,
"latestWkid": 2286,
"xyTolerance": 0.003280833333333333,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -117498300,
"falseY": -98850300,
"xyUnits": 3048.0060960121928,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "Conductor",
"typeIdField": "Placement",
"subtypeFieldName": "Placement",
"subtypeField": "Placement",
"defaultSubtypeCode": 1,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "PhaseCode",
"type": "esriFieldTypeSmallInteger",
"alias": "Phase Code",
"domain": {
"type": "codedValue",
"name": "PhaseCode",
"description": "Present phases.",
"codedValues": [
{
"name": "A",
"code": 129
},
{
"name": "B",
"code": 130
},
{
"name": "AB",
"code": 131
},
{
"name": "C",
"code": 132
},
{
"name": "AC",
"code": 133
},
{
"name": "BC",
"code": 134
},
{
"name": "ABC",
"code": 135
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "Placement",
"type": "esriFieldTypeSmallInteger",
"alias": "Placement",
"domain": null
},
{
"name": "Conductor",
"type": "esriFieldTypeString",
"alias": "Conductor",
"length": 50,
"domain": {
"type": "codedValue",
"name": "OHSecondaryConductor",
"description": "ConstructionCode",
"codedValues": [
{
"name": "LSU#6ALX",
"code": "LSU#6ALX"
},
{
"name": "LSO10ALX",
"code": "LSO10ALX"
},
{
"name": "LRO10ALX",
"code": "LRO10ALX"
},
{
"name": "NS40ALX",
"code": "NS40ALX"
},
{
"name": "NS20ALX",
"code": "NS20ALX"
},
{
"name": "NS10ALX",
"code": "NS10ALX"
},
{
"name": "NS#6ALX",
"code": "NS#6ALX"
},
{
"name": "NS#4ALX",
"code": "NS#4ALX"
},
{
"name": "NS#2ALX",
"code": "NS#2ALX"
},
{
"name": "NS40ALQ",
"code": "NS40ALQ"
},
{
"name": "NS10ALQ",
"code": "NS10ALQ"
},
{
"name": "LS#6ALDE",
"code": "LS#6ALDE"
},
{
"name": "LR CO",
"code": "LR CO"
},
{
"name": "NS40WP",
"code": "NS40WP"
},
{
"name": "NS40CU",
"code": "NS40CU"
},
{
"name": "NS20CU",
"code": "NS20CU"
},
{
"name": "NS10WP",
"code": "NS10WP"
},
{
"name": "NS10CU",
"code": "NS10CU"
},
{
"name": "NS#6WP",
"code": "NS#6WP"
},
{
"name": "NS#4WP",
"code": "NS#4WP"
},
{
"name": "NS#2WP",
"code": "NS#2WP"
},
{
"name": "LS#6ALX",
"code": "LS#6ALX"
},
{
"name": "LR#6ALX",
"code": "LR#6ALX"
},
{
"name": "LS#6ALS",
"code": "LS#6ALS"
},
{
"name": "SEC-UNK",
"code": "SEC-UNK"
},
{
"name": "Customer Owned",
"code": "CO-WIRE"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "Type",
"type": "esriFieldTypeSmallInteger",
"alias": "Type",
"domain": {
"type": "codedValue",
"name": "SecondaryType",
"description": "",
"codedValues": [
{
"name": "Secondary",
"code": 0
},
{
"name": "Service",
"code": 1
},
{
"name": "Underbuild",
"code": 2
},
{
"name": "MOP",
"code": 3
},
{
"name": "MultiMeterBank",
"code": 4
},
{
"name": "CustomerOwned",
"code": 5
},
{
"name": "StreetLight",
"code": 6
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape",
"domain": null
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "FDO_Shape",
"fields": "Shape",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"types": [
{
"domains": {
"PhaseCode": {"type": "inherited"},
"Conductor": {"type": "inherited"},
"Type": {"type": "inherited"}
},
"id": 1,
"name": "OH"
},
{
"domains": {
"PhaseCode": {"type": "inherited"},
"Conductor": {
"type": "codedValue",
"name": "UGSecondaryConductor",
"description": "ConstructionCode",
"codedValues": [
{
"name": "NUS50CU",
"code": "NUS50CU"
},
{
"name": "NUS50ALX",
"code": "NUS50ALX"
},
{
"name": "NUS50ALQ",
"code": "NUS50ALQ"
},
{
"name": "NUS40ALX",
"code": "NUS40ALX"
},
{
"name": "NUS40ALQ",
"code": "NUS40ALQ"
},
{
"name": "NUS35ALX",
"code": "NUS35ALX"
},
{
"name": "NUS35ALQ",
"code": "NUS35ALQ"
},
{
"name": "NUS10ALX",
"code": "NUS10ALX"
},
{
"name": "NUS10ALQ",
"code": "NUS10ALQ"
},
{
"name": "NUS06AL",
"code": "NUS06AL"
},
{
"name": "LS2ALX",
"code": "LS2ALX"
},
{
"name": "LRU#6ALX",
"code": "LRU#6ALX"
},
{
"name": "LR2ALX",
"code": "LR2ALX"
},
{
"name": "LS10ALX",
"code": "LS10ALX"
},
{
"name": "LR10ALX",
"code": "LR10ALX"
},
{
"name": "LS#6ALDP",
"code": "LS#6ALDP"
},
{
"name": "LR#6ALDP",
"code": "LR#6ALDP"
},
{
"name": "SEC-UNK",
"code": "SEC-UNK"
},
{
"name": "C.O. SERVICE",
"code": "CO-WIRE"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"Type": {"type": "inherited"}
},
"id": 3,
"name": "UG"
}
],
"subtypes": [
{
"domains": {
"PhaseCode": {"type": "inherited"},
"Conductor": {"type": "inherited"},
"Type": {"type": "inherited"}
},
"defaultValues": {
"MapNumber": null,
"PhaseCode": null,
"Placement": null,
"Conductor": null,
"Type": 1
},
"code": 1,
"name": "OH"
},
{
"domains": {
"PhaseCode": {"type": "inherited"},
"Conductor": {
"type": "codedValue",
"name": "UGSecondaryConductor",
"description": "ConstructionCode",
"codedValues": [
{
"name": "NUS50CU",
"code": "NUS50CU"
},
{
"name": "NUS50ALX",
"code": "NUS50ALX"
},
{
"name": "NUS50ALQ",
"code": "NUS50ALQ"
},
{
"name": "NUS40ALX",
"code": "NUS40ALX"
},
{
"name": "NUS40ALQ",
"code": "NUS40ALQ"
},
{
"name": "NUS35ALX",
"code": "NUS35ALX"
},
{
"name": "NUS35ALQ",
"code": "NUS35ALQ"
},
{
"name": "NUS10ALX",
"code": "NUS10ALX"
},
{
"name": "NUS10ALQ",
"code": "NUS10ALQ"
},
{
"name": "NUS06AL",
"code": "NUS06AL"
},
{
"name": "LS2ALX",
"code": "LS2ALX"
},
{
"name": "LRU#6ALX",
"code": "LRU#6ALX"
},
{
"name": "LR2ALX",
"code": "LR2ALX"
},
{
"name": "LS10ALX",
"code": "LS10ALX"
},
{
"name": "LR10ALX",
"code": "LR10ALX"
},
{
"name": "LS#6ALDP",
"code": "LS#6ALDP"
},
{
"name": "LR#6ALDP",
"code": "LR#6ALDP"
},
{
"name": "SEC-UNK",
"code": "SEC-UNK"
},
{
"name": "C.O. SERVICE",
"code": "CO-WIRE"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"Type": {"type": "inherited"}
},
"defaultValues": {
"MapNumber": null,
"PhaseCode": null,
"Placement": null,
"Conductor": null,
"Type": 1
},
"code": 3,
"name": "UG"
}
],
"relationships": [],
"canModifyLayer": true,
"canScaleSymbols": false,
"hasLabels": false,
"capabilities": "Query,Map,Data",
"maxRecordCount": 2000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"isDataVersioned": false,
"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": false
},
"supportsDatumTransformation": true,
"dateFieldsTimeReference": {
"timeZone": "Pacific Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": {
"timeZone": "Pacific Standard Time",
"respectsDaylightSaving": true
},
"datesInUnknownTimezone": false,
"hasGeometryProperties": true,
"geometryProperties": {
"shapeLengthFieldName": "Shape_Length",
"units": "esriFeet"
},
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true,
"serviceItemId": "3c865ee03de64093ab03b7b9d737bf1a"
}