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>",
"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": {
"id": 10,
"name": "Structure"
},
"subLayers": [],
"minScale": 3000,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "uniqueValue",
"field1": "Type",
"defaultSymbol": {
"type": "esriSMS",
"style": "esriSMSSquare",
"color": [
255,
0,
0,
255
],
"size": 6,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 0
}
},
"defaultLabel": "",
"uniqueValueInfos": [
{
"symbol": {
"type": "esriSMS",
"style": "esriSMSCircle",
"color": [
255,
0,
0,
255
],
"size": 7,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 0.7
}
},
"value": "1",
"label": "Pole"
},
{
"symbol": {
"type": "esriSMS",
"style": "esriSMSSquare",
"color": [
230,
0,
0,
255
],
"size": 10,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 1
}
},
"value": "10",
"label": "Utlity Vault"
},
{
"symbol": {
"type": "esriPMS",
"url": "791f03c44eb091f03db991f5c1efbef0",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAYAAACprHcmAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA1klEQVQYlZ3RMU7DQBAF0L+eXblJEacCewu6iFQ5A00OgSzRoDmStaJAwuI+KdJQpLG0dooUxq13bApkBDIU4dfvj0YzGhdE/xuXZXndtu2LUioFUBljcmY+z3BRFFnXdQdr7ZKIEELYeO/fnHPrqfCFReQ5y7IlEX1O0Rppmq7qun4FsPuBlVJ2glOMMRjH8Wa2hoicROT2e6HvewDwMxzH8aP3fm+tXURRhBACmqZ5T5LkfoaZ+eic21ZV9UREV8MweK31Q57nza+nY+YjgDv8kYue8gFF30usXpRtFAAAAABJRU5ErkJggg==",
"contentType": "image/png",
"width": 8,
"height": 8,
"angle": 0,
"xoffset": 0,
"yoffset": 0
},
"value": "2",
"label": "Light"
},
{
"symbol": {
"type": "esriPMS",
"url": "53562205c9429a3970ad488072a24aac",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAwUlEQVQ4jeXTMQqDMABA0S+Im4vi4ubm4JbBS0jFE3gBwcHNydFNvITgJPQeuYZXcBI7VKxQpDZ164dAQsgjGaJzUTrAAgJwFQ2pwaivC5equiPEl4SEqrqxg0AIiCLFS61PO1VRQJaB5/0ItS0kyQXQh/4WWhbQtNd6Pz8NhSGUJcQxTBPMM5imAhQE0DRgWdD3YNvg+wpQXUOeQ5qC68IwgGEoQI4DXXe4fQxJefrQ1ji+QXL9xSrJDdJg5DmUewAg8CeONsbJNAAAAABJRU5ErkJggg==",
"contentType": "image/png",
"width": 13,
"height": 13,
"angle": 0,
"xoffset": 0,
"yoffset": 0
},
"value": "3",
"label": "Junction Cabinet"
},
{
"symbol": {
"type": "esriPMS",
"url": "a17b97036b5c423a18c3e067774f4975",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABf0lEQVRIid2Tv0tCURTHP08MdHAQnihuDTq9TcuhwSFwyaGwBw7vnwgVx7SGluDZIvYgosFBMQrcLJvc3pD/Q4vQINVgIvUaLvSDouK9kuzAhXs5h+/nnvO9180vh3uqACuXW/0RVZ/vQiqVbt8BMIwTUiln4qYJqroGnL4HhMPQajkDaNqb43Q9+KeAoyOoViEQAMMQPl1eQj4PoxFsb8Pysk3A3R3U69DrQb8PW1tQqcDGBjQa4PXCygosLYHHYxNgWeBywcICuN3Q6UAmA8GgqNF1mExsAsJhUBSIRGB9HYpF0c38/EtNPP6pxNce6LoYycEBZLOgqjAev+QtCyTJJuD8HIZDIVouQzoN0SicnYkxARQKIp9I2AAoihCVZbi+FqYmk7C5Cc2muHm3Czs7NjsIhWB/Hw4Pwe+HWk2IHh/D3h7c30O7DXNzNgEAsZhYr0OWxfv/RvyBnzxbgMEAFhcfHSleXUlo2sOHAOnmRsI0HekDsLv7vJ19D54AaaJjjbve1mIAAAAASUVORK5CYII=",
"contentType": "image/png",
"width": 18,
"height": 18,
"angle": 0,
"xoffset": 0,
"yoffset": 0
},
"value": "4",
"label": "Switch Cabinet"
},
{
"symbol": {
"type": "esriPMS",
"url": "87a2c9a1e24e1126cfb3b7d1916e453f",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAAA8AAAAaCAYAAABozQZiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABGUlEQVQ4jc3RsWrCUBjF8f8FJRgXu2TyAbI7ZQgOWVvq4BNIHyBDhixuTm4SzCJd8zTiljGQQdwMDgEjl2CXtpDaeEUL6dk+Lj/OgdvigbSax2fPe2W3e1OKbjcRq5Vbbc6yFwzjmcGgHp5OEIYH4AcGGA5hNKrHeQ5heDn7nvwjnCQJjuMAIIRA0zRs22Y+n/PUbl/HUkqklMRxDEBRFLiui+d5vC8W6tlCCHq93vc9mUzwfV89G6AsS9I0BSDLMoIgwLbt2/B+v2c8HiOEQNd1LMtiOp3C+azGhmGwXq8vH/JcjW/N32LTNNlutw00N4STBH77oq8cjzW400mJogNRdL2u30/ZbKpYLJczYKbc+gmrzXfkIfwB88BWQZ+xLNoAAAAASUVORK5CYII=",
"contentType": "image/png",
"width": 11,
"height": 19,
"angle": 0,
"xoffset": 0,
"yoffset": 0
},
"value": "5",
"label": "Pedestal"
},
{
"symbol": {
"type": "esriPMS",
"url": "87a2c9a1e24e1126cfb3b7d1916e453f",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAAA8AAAAaCAYAAABozQZiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABGUlEQVQ4jc3RsWrCUBjF8f8FJRgXu2TyAbI7ZQgOWVvq4BNIHyBDhixuTm4SzCJd8zTiljGQQdwMDgEjl2CXtpDaeEUL6dk+Lj/OgdvigbSax2fPe2W3e1OKbjcRq5Vbbc6yFwzjmcGgHp5OEIYH4AcGGA5hNKrHeQ5heDn7nvwjnCQJjuMAIIRA0zRs22Y+n/PUbl/HUkqklMRxDEBRFLiui+d5vC8W6tlCCHq93vc9mUzwfV89G6AsS9I0BSDLMoIgwLbt2/B+v2c8HiOEQNd1LMtiOp3C+azGhmGwXq8vH/JcjW/N32LTNNlutw00N4STBH77oq8cjzW400mJogNRdL2u30/ZbKpYLJczYKbc+gmrzXfkIfwB88BWQZ+xLNoAAAAASUVORK5CYII=",
"contentType": "image/png",
"width": 11,
"height": 19,
"angle": 0,
"xoffset": 0,
"yoffset": 0
},
"value": "8",
"label": "Pedestal"
}
],
"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": 317272.4833559692,
"xmax": 1965596.3469918817,
"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": "Type",
"typeIdField": "Type",
"subtypeFieldName": "Type",
"subtypeField": "Type",
"defaultSubtypeCode": 1,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "Type",
"type": "esriFieldTypeSmallInteger",
"alias": "Type",
"domain": null
},
{
"name": "StationNo",
"type": "esriFieldTypeString",
"alias": "Station No",
"length": 10,
"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": {},
"id": 1,
"name": "Pole"
},
{
"domains": {},
"id": 2,
"name": "Light"
},
{
"domains": {},
"id": 4,
"name": "SwitchCabinet"
},
{
"domains": {},
"id": 5,
"name": "Pedestal"
},
{
"domains": {},
"id": 6,
"name": "BUSBAR"
},
{
"domains": {},
"id": 3,
"name": "JunctionCabinet"
},
{
"domains": {},
"id": 0,
"name": "PadLocation"
},
{
"domains": {},
"id": 7,
"name": "Irrigation"
},
{
"domains": {},
"id": 8,
"name": "DisconnectPedestal"
},
{
"domains": {},
"id": 9,
"name": "PrimaryMeteringCabinet"
},
{
"domains": {},
"id": 10,
"name": "UtlityVault"
},
{
"domains": {},
"id": 11,
"name": "SubmersibleTransformer"
},
{
"domains": {},
"id": 12,
"name": "PadCapBank"
}
],
"subtypes": [
{
"domains": {},
"defaultValues": {
"MapNumber": null,
"ConstructionUnit": null,
"Type": 1,
"StationNo": null
},
"code": 1,
"name": "Pole"
},
{
"domains": {},
"defaultValues": {
"MapNumber": null,
"ConstructionUnit": null,
"Type": 1,
"StationNo": null
},
"code": 2,
"name": "Light"
},
{
"domains": {},
"defaultValues": {
"MapNumber": null,
"ConstructionUnit": null,
"Type": 1,
"StationNo": null
},
"code": 4,
"name": "SwitchCabinet"
},
{
"domains": {},
"defaultValues": {
"MapNumber": null,
"ConstructionUnit": null,
"Type": 1,
"StationNo": null
},
"code": 5,
"name": "Pedestal"
},
{
"domains": {},
"defaultValues": {
"MapNumber": null,
"ConstructionUnit": null,
"Type": 1,
"StationNo": null
},
"code": 6,
"name": "BUSBAR"
},
{
"domains": {},
"defaultValues": {
"MapNumber": null,
"ConstructionUnit": null,
"Type": 1,
"StationNo": null
},
"code": 3,
"name": "JunctionCabinet"
},
{
"domains": {},
"defaultValues": {
"MapNumber": null,
"ConstructionUnit": null,
"Type": 1,
"StationNo": null
},
"code": 0,
"name": "PadLocation"
},
{
"domains": {},
"defaultValues": {
"MapNumber": null,
"ConstructionUnit": null,
"Type": null,
"StationNo": null
},
"code": 7,
"name": "Irrigation"
},
{
"domains": {},
"defaultValues": {
"MapNumber": null,
"ConstructionUnit": null,
"Type": null,
"StationNo": null
},
"code": 8,
"name": "DisconnectPedestal"
},
{
"domains": {},
"defaultValues": {
"MapNumber": null,
"ConstructionUnit": null,
"Type": null,
"StationNo": null
},
"code": 9,
"name": "PrimaryMeteringCabinet"
},
{
"domains": {},
"defaultValues": {
"MapNumber": null,
"ConstructionUnit": null,
"Type": null,
"StationNo": null
},
"code": 10,
"name": "UtlityVault"
},
{
"domains": {},
"defaultValues": {
"MapNumber": null,
"ConstructionUnit": null,
"Type": null,
"StationNo": null
},
"code": 11,
"name": "SubmersibleTransformer"
},
{
"domains": {},
"defaultValues": {
"MapNumber": null,
"ConstructionUnit": null,
"Type": null,
"StationNo": null
},
"code": 12,
"name": "PadCapBank"
}
],
"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"
}