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": "esriGeometryPoint",
"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": null,
"subLayers": [],
"minScale": 3000,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "uniqueValue",
"field1": "Placement",
"defaultSymbol": {
"type": "esriSMS",
"style": "esriSMSCircle",
"color": [
130,
130,
130,
255
],
"size": 4,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 0.7
}
},
"defaultLabel": "",
"uniqueValueInfos": [
{
"symbol": {
"type": "esriPMS",
"url": "fac5aa33c55f81991c99701961e76854",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAPCAYAAADtc08vAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABF0lEQVQokaXSPUuCURgG4Gt4XXKxD4yo0UEIIoJcjECKaChwCfpAaZCgAm1pEYIgGhpbanFtFCL6AQVR/yD8AUGbEQ0GLQ01vMWbZj3L4TyH++LhnBP4ZwUdzqc+15u/AAMjVDH2wCwaXQE9bK0wPUj8kMoTm90A6VG2F4mncMXyJcdRU0QCvVQ2SaY+9yUS15y+kPsNMJVleT7UyGCObJ08ztsCSXZLJL73K8RuqT52APILzGQixkqhyPgRJdSigPQQ1XXiEXlQIHbG/sPHv2h8AfpZKzKe+imNPuwwvMdWi3IYSE+yUSDWJg9WUadwxwkaAR/PNkGyiWYnATkS9xw8sxTAK281LmqdkqEKwnfQotzqIhyud8qWNdIM9aVuAAAAAElFTkSuQmCC",
"contentType": "image/png",
"width": 12,
"height": 11,
"angle": 0,
"xoffset": 0,
"yoffset": 0
},
"value": "1",
"label": "Overhead"
},
{
"symbol": {
"type": "esriPMS",
"url": "e1bd8cbf7416d6c2518ed3ba1c075893",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABT0lEQVQ4ja3UPWvCQBwG8KetqaItdHL3M/gRHES4bC5+gSyCg3tAXQxkcHJxVfdgApmyuWYPuFcILq05bV5IOrQGQ6LGmGc57obfPfA/roCcU/hfBwDqD1o6gMEJrLMsSwghmSRFUSDLcqQhCCHgOC5zvRiYV1KBAaUIKMVztZoP6GgaXF3H23D4OOibJixRhGcYKHe7N1teB10Xh9kMznoNAKCTCd5HI4BhsoHeZoPjchnuLUFAmePwUqvdDwaU4jifwzOMyPl3v4+PxQJPlcp9oKNpsAQhdv4jSbBVFaV2Oz0YUApLFC/dhT3Po9hqJbZMBG1VDQeRFM8wYK9WKHU6t0HfNLHn+YvYKV+9Hl4bjdgzioABpThMp7FBJMXf7f6e0Xh8paHrothsgqmn/8l800wGFUVJjUQiSdhutzFQl2U5/IIy5vMcHDwinecXsc+CJVC2feUAAAAASUVORK5CYII=",
"contentType": "image/png",
"width": 15,
"height": 15,
"angle": 0,
"xoffset": 0,
"yoffset": 0
},
"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": 1927828.3802051395,
"ymin": 317821.53770406544,
"xmax": 1965556.7929371446,
"ymax": 379951.5492705554,
"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": "StationNo",
"typeIdField": "Placement",
"subtypeFieldName": "Placement",
"subtypeField": "Placement",
"defaultSubtypeCode": 1,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "Placement",
"type": "esriFieldTypeSmallInteger",
"alias": "Placement",
"domain": null
},
{
"name": "BankKva",
"type": "esriFieldTypeDouble",
"alias": "Bank Kva",
"domain": null
},
{
"name": "StationNo",
"type": "esriFieldTypeString",
"alias": "Station No",
"length": 20,
"domain": null
},
{
"name": "TransformerLabel1",
"type": "esriFieldTypeString",
"alias": "Transformer Label 1",
"length": 20,
"domain": null
},
{
"name": "TransformerLabel2",
"type": "esriFieldTypeString",
"alias": "Transformer Label 2",
"length": 20,
"domain": null
},
{
"name": "TransformerLabel3",
"type": "esriFieldTypeString",
"alias": "Transformer Label 3",
"length": 20,
"domain": null
},
{
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape",
"domain": null
},
{
"name": "ConstructionUnit",
"type": "esriFieldTypeString",
"alias": "ConstructionUnit",
"length": 50,
"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"},
"Type": {"type": "inherited"}
},
"id": 1,
"name": "OH"
},
{
"domains": {
"PhaseCode": {"type": "inherited"},
"Type": {
"type": "codedValue",
"name": "UGTransformerTypes",
"description": "",
"codedValues": [
{
"name": "PAD1",
"code": 4
},
{
"name": "PAD3",
"code": 5
},
{
"name": "PAD2",
"code": 6
},
{
"name": "TNCR",
"code": 7
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
"id": 3,
"name": "UG"
}
],
"subtypes": [
{
"domains": {
"PhaseCode": {"type": "inherited"},
"Type": {"type": "inherited"}
},
"defaultValues": {
"MapNumber": null,
"PhaseCode": null,
"Placement": 1,
"Type": 1,
"ConstructionUnit": null,
"BankKva": null,
"StationNo": null,
"TransformerLabel1": null,
"TransformerLabel2": null,
"TransformerLabel3": null
},
"code": 1,
"name": "OH"
},
{
"domains": {
"PhaseCode": {"type": "inherited"},
"Type": {
"type": "codedValue",
"name": "UGTransformerTypes",
"description": "",
"codedValues": [
{
"name": "PAD1",
"code": 4
},
{
"name": "PAD3",
"code": 5
},
{
"name": "PAD2",
"code": 6
},
{
"name": "TNCR",
"code": 7
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
"defaultValues": {
"MapNumber": null,
"PhaseCode": null,
"Placement": 1,
"Type": 4,
"ConstructionUnit": null,
"BankKva": null,
"StationNo": null,
"TransformerLabel1": null,
"TransformerLabel2": null,
"TransformerLabel3": null
},
"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,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true,
"serviceItemId": "3c865ee03de64093ab03b7b9d737bf1a"
}