{ "layers": [ { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 0, "name": "esri_sde.DBO.Streetlights", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Street_Light_Reporting", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "POLE", "composite": false, "catalogID": "{67AC663A-5987-49F0-B6FB-665CAE3ABE7A}" } ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "extent": { "xmin": 1369474.488100797, "ymin": 351176.57119330764, "xmax": 1436807.1241045594, "ymax": 489922.3773625642, "spatialReference": { "wkid": 2893, "latestWkid": 2893, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3.695308229454812E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 2893, "latestWkid": 2893, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "LED_Upgrade", "defaultSymbol": { "type": "esriPMS", "url": "9deca26a15ae010148ce0a51587dc720", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAC60lEQVRIibVWv1PTUBz/5iUh9Gp7bWGBiXqHWweIAw7c0Rh6DuiA/AG6MLmps7Igd+rmxHHqoi7AACxKabnr4bEUf3B2tCw6QZsmhRDyaL1vSmISWyyInyV9716+n/d9+Xw+rxz8Z3DtLEomUyKleh+wbA/Pcd2mYWxzXGAnm/2Q/xeCjqQs32EAJgkDYmcgDISQxkssD5SaIMkyEqxk0unHZyLAHdeATnd2CKlgMAgcxzd9mVJTVFVNlGR57KBandjc3Nz5K4EkSTcJC0uRUAwEQXDmo9EIDA4MWk8/3rx9J0IdipIk3cpkMsstCXDnDKm/CoXCnuLXJQnil/tAKSsQiUassRvxeByezMxAqVRaSiZTV93fxiEYHR3tPaJ0OhKOdbmLT9wet4rOzb105ra2PsHDB/c9JP39V6BQKICqqdhB7x8EtF4fuxQMptzF7d09ffbcM4cEa5mM1Um5rMD8wiIUi0UIBAKg63pPUpYns+n0rIcA1YIL/MXLShmaATtaW8uCopQtEhvhcAh293bvAcBvgqGhoT7CENGvFnFwwDr3VsBd+4E1OJZLYE1UlUXA87zI882leB5gLawJAA0CdKhtoosAIQQ4QejC340OOK4bLhjMiZIsgsMD8z3H8o8uqrhpUlCV6rpDIAjCUa12/MdC1H80Ej0XSSgU1hwCdN6IJG1TaiZsJaHGbcfiE3XfDjAE6bGZz2bTeY8PCCGLqqolYrGYNXZnTrRJ/rTC/v4+PlbssUOAkTsiSeOGYST8bm4Xuq6DcWTk3fHtCTueZW9UKsoPu4uzAI9G01SAem3KPe8hWF1d/Tk8PDxRKpXmNzY+OvPfmzjWv/NKRdkjDNw9Na4RuVxuASP389cvy98KhR7MllYXjmEYcHjYOBbCwJS/eFMCxEme92IqYnBhtqD9bbejzq1jOTbzJqWvc+vrL1p1d+qlfxK5s3hXVDX1GtofHYomQp3bUjwNbf2rwG8DAAvtrPXjF0NvL1wcR4yJAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 18, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 }, "defaultLabel": "Null or Other", "uniqueValueGroups": [ { "heading": "Has LED Upgrade", "classes": [ { "label": "Yes", "description": "Yes", "symbol": { "type": "esriPMS", "url": "9107daca78e0eaba2d3bc66805be7d41", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADA0lEQVRIibVVT0zTcBR+7do6qNuYoGQLEIKJLtElJuMiQuZFwgEIceBZD3Iw4M0ET0pilBsJThLxoAdPyIwZHDRcwAAmxiUqQnZx8kckkEHpxv7QltW8jtatMBiK36Xdb833vff6vq8U/GdQ+TzU1l/rSvKpSoIibIzRULK1KU0bLeTcq1sTgX8RYDxe93UAaCcMhMtcRoGBJpU/aFYCIS6Bx+sOELI8MtT5/v6hBLBicUt+aLTQ9WYbC0zh3nUIccm1sRB1ebzuxrWffOtYz+e5AwU8fe4mwkD4Sx0mMFoY7dzMWOG8tVq5ZuEswJtvL10A8g9Pn7vZd3t8OKcAVi7L8NxakU1eU3oFytgqiIgcmGmr8jsT5WwVPKEfwGqQ87f111ZnvhtNoPnxJTuOpdRhLs4kbyi/ppAOhp5qZzNcAG46urJETp88A2J8Frj5KHZg3yVAE1QjaztWn0muVvcs2JN1NsN9gqmVUaWTiMDB28VBWIyFgC0xQiycsHm87nZfx/iAfkTtbEnBLnJe4GAvYEcfVkaBFzlFREVRhQmWp9c7AOCPwOWuC5UGmnDpt+XciWpl7rmAVeuBHEyhwYmcuFUKo8lS6KJzrOLfALmQEwDSAuhQ1URHAQNNAmOii/FeEUD7wxGDkGW7JpCMJt/RLHXvqMjFuAQbS5ExTaCgiBG2xdSuB3H/LXrn5glrxfGoJoDOa+mtmxbiklPdJNxx1bF4xb3PBxiCQnw74OtIu1lbHYoiXm8sRJ2nHOmKMzPHfIguIssxnP+IxqveYOS29NZdTfKCU+/mfBELJyHJiwFfRnxnLX+KSjWEv/NLaheHAY6GW4gCpIjuzPMsAX/n5K+mRzWtq0Fu6CMxoZ0vboYOrHwtFFkjSfLGvnGNGL475cPI/Tr7ZTg4P2PDbMn1wUnyAmyGE8pYSJLs1pPvKYDYyXM7piIGF2YL2l91O+55eizbATEhvfDfmfTm6m7fANqJ3AH8ViTWhYtof3Qomgj3XF3F/ZBXwuG7Qb18ntXjNyAMN1HzVlSmAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 18, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Yes" ] ] }, { "label": "No", "description": "No", "symbol": { "type": "esriPMS", "url": "63af44c3fc896208a75ae6c0440b40b0", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADAUlEQVRIibVWS08TURQ+86R1rDzKs2lHQMKGzGrcuNMNcYEuDIG4UmOCMWHhKzEkJkpiNBJCNSEuSIwuSEwbcQFujAv5A9VgIxEWpbaVIFIqlHbaKZ2aM+2UmdLWVvBb9HZu75zvnHu/79zS8J9BV7LIPc6L0YTSTlPQZmLJxh1J8VpMpH/gTsBzEALW7eQvZwCGGJoQHXUMMAyh/sBJCsTiCricvAcUeDd4O/CgKgLMOLmbeVRnoXrtrQxwR8iiL8fiiugLyaLLyff5vsv9I0/X/H8lcE3w5xiGmO3uqoH6Y1R+nqppBrP1tDpqqAUAWw+Af+GZCBlYcU3w5wdvBeZKEmDmBAkvOxysIfhR2wCwlh5Iy7+AYpvUZz26LT3A0tfAu5yYdY/zJ/Vnkyd4/cRhw20RukxWffDajmE16ObS/fycFJ6HJuG5gaS+RYBOaQF8QRkrsO0joFiir7WB7tUHR2Dmv75cN8xJGx9hZ9WtVoJVba1Mghz9Cs1WGn6Gd9vcTn5o4GZgykCAammxGo9E3ZbkOhQDVoQkSKBf02ln4dOiNAwAewSPb7S2szQhFqrF3HhGDVAKmHUhMAZnJgWMiapSCZobaZEzF5fivwBjYUwAyBKgQzUTHQYYhgALR1rV2PiB9odDRkbJKkkliPxOv+c4ck+HB0RMUlCu83mChlpKTqUy+xai/vXOrQYn7Gw0T4DOmx5zeGNxRdCUhBrXHIsjSrKi7OMKVuAZzLk5L3yGIt76QrIgdJuy2esyp6qoIrSWAuyw2nOeAFvu9JjjQmQ7LRS6uVKsh3chEk179O3bYF0qA2eXfMkfWAV2ymqAW+MLyvh1VD9vILh4N7j64qG937uceJOiP8DxMo4tzHxpJRlmaOJK2XaNuHovNIMt99vi57mgf6ENe0upCyeynYb1jey2MDQxWhi8KAEi189t2BWxcWFvQftrbked50ZPIqG8ujQSmixVXdlLP9dyp/Cu2NxKn0L7o0PRRKhzTYrlUNG/CjwbAJipZG0h/gD+hTMu73xNWwAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 18, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "No" ] ] }, { "label": "Unknown", "description": "Unknown", "symbol": { "type": "esriPMS", "url": "9deca26a15ae010148ce0a51587dc720", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAC60lEQVRIibVWv1PTUBz/5iUh9Gp7bWGBiXqHWweIAw7c0Rh6DuiA/AG6MLmps7Igd+rmxHHqoi7AACxKabnr4bEUf3B2tCw6QZsmhRDyaL1vSmISWyyInyV9716+n/d9+Xw+rxz8Z3DtLEomUyKleh+wbA/Pcd2mYWxzXGAnm/2Q/xeCjqQs32EAJgkDYmcgDISQxkssD5SaIMkyEqxk0unHZyLAHdeATnd2CKlgMAgcxzd9mVJTVFVNlGR57KBandjc3Nz5K4EkSTcJC0uRUAwEQXDmo9EIDA4MWk8/3rx9J0IdipIk3cpkMsstCXDnDKm/CoXCnuLXJQnil/tAKSsQiUassRvxeByezMxAqVRaSiZTV93fxiEYHR3tPaJ0OhKOdbmLT9wet4rOzb105ra2PsHDB/c9JP39V6BQKICqqdhB7x8EtF4fuxQMptzF7d09ffbcM4cEa5mM1Um5rMD8wiIUi0UIBAKg63pPUpYns+n0rIcA1YIL/MXLShmaATtaW8uCopQtEhvhcAh293bvAcBvgqGhoT7CENGvFnFwwDr3VsBd+4E1OJZLYE1UlUXA87zI882leB5gLawJAA0CdKhtoosAIQQ4QejC340OOK4bLhjMiZIsgsMD8z3H8o8uqrhpUlCV6rpDIAjCUa12/MdC1H80Ej0XSSgU1hwCdN6IJG1TaiZsJaHGbcfiE3XfDjAE6bGZz2bTeY8PCCGLqqolYrGYNXZnTrRJ/rTC/v4+PlbssUOAkTsiSeOGYST8bm4Xuq6DcWTk3fHtCTueZW9UKsoPu4uzAI9G01SAem3KPe8hWF1d/Tk8PDxRKpXmNzY+OvPfmzjWv/NKRdkjDNw9Na4RuVxuASP389cvy98KhR7MllYXjmEYcHjYOBbCwJS/eFMCxEme92IqYnBhtqD9bbejzq1jOTbzJqWvc+vrL1p1d+qlfxK5s3hXVDX1GtofHYomQp3bUjwNbf2rwG8DAAvtrPXjF0NvL1wcR4yJAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 18, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Unknown" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "9107daca78e0eaba2d3bc66805be7d41", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADA0lEQVRIibVVT0zTcBR+7do6qNuYoGQLEIKJLtElJuMiQuZFwgEIceBZD3Iw4M0ET0pilBsJThLxoAdPyIwZHDRcwAAmxiUqQnZx8kckkEHpxv7QltW8jtatMBiK36Xdb833vff6vq8U/GdQ+TzU1l/rSvKpSoIibIzRULK1KU0bLeTcq1sTgX8RYDxe93UAaCcMhMtcRoGBJpU/aFYCIS6Bx+sOELI8MtT5/v6hBLBicUt+aLTQ9WYbC0zh3nUIccm1sRB1ebzuxrWffOtYz+e5AwU8fe4mwkD4Sx0mMFoY7dzMWOG8tVq5ZuEswJtvL10A8g9Pn7vZd3t8OKcAVi7L8NxakU1eU3oFytgqiIgcmGmr8jsT5WwVPKEfwGqQ87f111ZnvhtNoPnxJTuOpdRhLs4kbyi/ppAOhp5qZzNcAG46urJETp88A2J8Frj5KHZg3yVAE1QjaztWn0muVvcs2JN1NsN9gqmVUaWTiMDB28VBWIyFgC0xQiycsHm87nZfx/iAfkTtbEnBLnJe4GAvYEcfVkaBFzlFREVRhQmWp9c7AOCPwOWuC5UGmnDpt+XciWpl7rmAVeuBHEyhwYmcuFUKo8lS6KJzrOLfALmQEwDSAuhQ1URHAQNNAmOii/FeEUD7wxGDkGW7JpCMJt/RLHXvqMjFuAQbS5ExTaCgiBG2xdSuB3H/LXrn5glrxfGoJoDOa+mtmxbiklPdJNxx1bF4xb3PBxiCQnw74OtIu1lbHYoiXm8sRJ2nHOmKMzPHfIguIssxnP+IxqveYOS29NZdTfKCU+/mfBELJyHJiwFfRnxnLX+KSjWEv/NLaheHAY6GW4gCpIjuzPMsAX/n5K+mRzWtq0Fu6CMxoZ0vboYOrHwtFFkjSfLGvnGNGL475cPI/Tr7ZTg4P2PDbMn1wUnyAmyGE8pYSJLs1pPvKYDYyXM7piIGF2YL2l91O+55eizbATEhvfDfmfTm6m7fANqJ3AH8ViTWhYtof3Qomgj3XF3F/ZBXwuG7Qb18ntXjNyAMN1HzVlSmAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 18, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Yes", "label": "Yes" }, { "symbol": { "type": "esriPMS", "url": "63af44c3fc896208a75ae6c0440b40b0", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADAUlEQVRIibVWS08TURQ+86R1rDzKs2lHQMKGzGrcuNMNcYEuDIG4UmOCMWHhKzEkJkpiNBJCNSEuSIwuSEwbcQFujAv5A9VgIxEWpbaVIFIqlHbaKZ2aM+2UmdLWVvBb9HZu75zvnHu/79zS8J9BV7LIPc6L0YTSTlPQZmLJxh1J8VpMpH/gTsBzEALW7eQvZwCGGJoQHXUMMAyh/sBJCsTiCricvAcUeDd4O/CgKgLMOLmbeVRnoXrtrQxwR8iiL8fiiugLyaLLyff5vsv9I0/X/H8lcE3w5xiGmO3uqoH6Y1R+nqppBrP1tDpqqAUAWw+Af+GZCBlYcU3w5wdvBeZKEmDmBAkvOxysIfhR2wCwlh5Iy7+AYpvUZz26LT3A0tfAu5yYdY/zJ/Vnkyd4/cRhw20RukxWffDajmE16ObS/fycFJ6HJuG5gaS+RYBOaQF8QRkrsO0joFiir7WB7tUHR2Dmv75cN8xJGx9hZ9WtVoJVba1Mghz9Cs1WGn6Gd9vcTn5o4GZgykCAammxGo9E3ZbkOhQDVoQkSKBf02ln4dOiNAwAewSPb7S2szQhFqrF3HhGDVAKmHUhMAZnJgWMiapSCZobaZEzF5fivwBjYUwAyBKgQzUTHQYYhgALR1rV2PiB9odDRkbJKkkliPxOv+c4ck+HB0RMUlCu83mChlpKTqUy+xai/vXOrQYn7Gw0T4DOmx5zeGNxRdCUhBrXHIsjSrKi7OMKVuAZzLk5L3yGIt76QrIgdJuy2esyp6qoIrSWAuyw2nOeAFvu9JjjQmQ7LRS6uVKsh3chEk179O3bYF0qA2eXfMkfWAV2ymqAW+MLyvh1VD9vILh4N7j64qG937uceJOiP8DxMo4tzHxpJRlmaOJK2XaNuHovNIMt99vi57mgf6ENe0upCyeynYb1jey2MDQxWhi8KAEi189t2BWxcWFvQftrbked50ZPIqG8ujQSmixVXdlLP9dyp/Cu2NxKn0L7o0PRRKhzTYrlUNG/CjwbAJipZG0h/gD+hTMu73xNWwAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 18, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "No", "label": "No" }, { "symbol": { "type": "esriPMS", "url": "9deca26a15ae010148ce0a51587dc720", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAC60lEQVRIibVWv1PTUBz/5iUh9Gp7bWGBiXqHWweIAw7c0Rh6DuiA/AG6MLmps7Igd+rmxHHqoi7AACxKabnr4bEUf3B2tCw6QZsmhRDyaL1vSmISWyyInyV9716+n/d9+Xw+rxz8Z3DtLEomUyKleh+wbA/Pcd2mYWxzXGAnm/2Q/xeCjqQs32EAJgkDYmcgDISQxkssD5SaIMkyEqxk0unHZyLAHdeATnd2CKlgMAgcxzd9mVJTVFVNlGR57KBandjc3Nz5K4EkSTcJC0uRUAwEQXDmo9EIDA4MWk8/3rx9J0IdipIk3cpkMsstCXDnDKm/CoXCnuLXJQnil/tAKSsQiUassRvxeByezMxAqVRaSiZTV93fxiEYHR3tPaJ0OhKOdbmLT9wet4rOzb105ra2PsHDB/c9JP39V6BQKICqqdhB7x8EtF4fuxQMptzF7d09ffbcM4cEa5mM1Um5rMD8wiIUi0UIBAKg63pPUpYns+n0rIcA1YIL/MXLShmaATtaW8uCopQtEhvhcAh293bvAcBvgqGhoT7CENGvFnFwwDr3VsBd+4E1OJZLYE1UlUXA87zI882leB5gLawJAA0CdKhtoosAIQQ4QejC340OOK4bLhjMiZIsgsMD8z3H8o8uqrhpUlCV6rpDIAjCUa12/MdC1H80Ej0XSSgU1hwCdN6IJG1TaiZsJaHGbcfiE3XfDjAE6bGZz2bTeY8PCCGLqqolYrGYNXZnTrRJ/rTC/v4+PlbssUOAkTsiSeOGYST8bm4Xuq6DcWTk3fHtCTueZW9UKsoPu4uzAI9G01SAem3KPe8hWF1d/Tk8PDxRKpXmNzY+OvPfmzjWv/NKRdkjDNw9Na4RuVxuASP389cvy98KhR7MllYXjmEYcHjYOBbCwJS/eFMCxEme92IqYnBhtqD9bbejzq1jOTbzJqWvc+vrL1p1d+qlfxK5s3hXVDX1GtofHYomQp3bUjwNbf2rwG8DAAvtrPXjF0NvL1wcR4yJAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 18, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Unknown", "label": "Unknown" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 204, 248, 255 ], "toColor": [ 252, 204, 248, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 252, 179, 255 ], "toColor": [ 184, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 243, 252, 255 ], "toColor": [ 184, 243, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 212, 182, 255 ], "toColor": [ 252, 212, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 199, 252, 255 ], "toColor": [ 179, 199, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 251, 252, 182, 255 ], "toColor": [ 251, 252, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 189, 255 ], "toColor": [ 252, 179, 189, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 223, 252, 215, 255 ], "toColor": [ 223, 252, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 250, 179, 252, 255 ], "toColor": [ 250, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 216, 192, 252, 255 ], "toColor": [ 216, 192, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 197, 227, 252, 255 ], "toColor": [ 197, 227, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 231, 255 ], "toColor": [ 182, 252, 231, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 212, 212, 255 ], "toColor": [ 252, 212, 212, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpressionInfo": {"expression": "$feature.POLE"}, "labelPlacement": "esriServerPointLabelPlacementBelowCenter", "deconflictionStrategy": "dynamic", "removeDuplicates": "none", "stackLabel": false, "where": "LED_Upgrade = 'No'", "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "No", "priority": -1, "symbol": { "type": "esriTS", "color": [ 88, 89, 91, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Tahoma", "size": 10, "style": "normal", "weight": "bold", "decoration": "none" } } }, { "labelExpressionInfo": {"expression": "$feature.POLE"}, "labelPlacement": "esriServerPointLabelPlacementBelowCenter", "deconflictionStrategy": "dynamic", "removeDuplicates": "none", "stackLabel": false, "where": "NOT ( LED_Upgrade = 'Yes'\n OR LED_Upgrade = 'No'\n OR LED_Upgrade = 'Unknown')", "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Null or Other", "priority": -1, "symbol": { "type": "esriTS", "color": [ 88, 89, 91, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Tahoma", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } }, { "labelExpressionInfo": {"expression": "$feature.POLE"}, "labelPlacement": "esriServerPointLabelPlacementBelowCenter", "deconflictionStrategy": "dynamic", "removeDuplicates": "none", "stackLabel": false, "where": "LED_Upgrade = 'Unknown'", "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Unknown", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Tahoma", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } }, { "labelExpressionInfo": {"expression": "$feature.POLE"}, "labelPlacement": "esriServerPointLabelPlacementBelowCenter", "deconflictionStrategy": "dynamic", "removeDuplicates": "none", "stackLabel": false, "where": "LED_Upgrade = 'Yes'", "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Yes", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 123, 95, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Tahoma", "size": 10, "style": "normal", "weight": "bold", "decoration": "none" } } } ] }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "POLE", "typeIdField": "LED_Upgrade", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "POLE", "type": "esriFieldTypeString", "alias": "POLE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "POLE" }, { "name": "BGE_POLE", "type": "esriFieldTypeString", "alias": "BGE_POLE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "BGE_POLE" }, { "name": "LED_Upgrade", "type": "esriFieldTypeString", "alias": "LED_Upgrade", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "LED_Upgrade" }, { "name": "BANNER", "type": "esriFieldTypeString", "alias": "BANNER", "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No Domain", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "BANNER" }, { "name": "Fixture_Type", "type": "esriFieldTypeString", "alias": "Fixture_Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Fixture_Type" }, { "name": "Neighborhood", "type": "esriFieldTypeString", "alias": "Neighborhood", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Neighborhood" }, { "name": "X_COORD", "type": "esriFieldTypeDouble", "alias": "X_COORD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "X_COORD" }, { "name": "Y_COORD", "type": "esriFieldTypeDouble", "alias": "Y_COORD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Y_COORD" }, { "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": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R1038_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S957_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [ { "id": "Yes", "name": "Yes", "domains": { "BANNER": {"type": "inherited"} }, "templates": [ { "name": "Yes", "description": "", "prototype": { "attributes": { "X_COORD": null, "Y_COORD": null, "POLE": null, "BGE_POLE": null, "LED_Upgrade": "Yes", "BANNER": null, "Fixture_Type": null, "Neighborhood": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": "No", "name": "No", "domains": { "BANNER": {"type": "inherited"} }, "templates": [ { "name": "No", "description": "", "prototype": { "attributes": { "X_COORD": null, "Y_COORD": null, "POLE": null, "BGE_POLE": null, "LED_Upgrade": "No", "BANNER": null, "Fixture_Type": null, "Neighborhood": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": "Unknown", "name": "Unknown", "domains": { "BANNER": {"type": "inherited"} }, "templates": [ { "name": "Unknown", "description": "", "prototype": { "attributes": { "X_COORD": null, "Y_COORD": null, "POLE": null, "BGE_POLE": null, "LED_Upgrade": "Unknown", "BANNER": null, "Fixture_Type": null, "Neighborhood": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] } ], "templates": [], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "b7c7d1846dd249dc9fba0aa33f3e0a43" } ], "tables": [ { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 1, "name": "esri_sde.DBO.Street_Light_Reporting", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "Streetlights", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Pole", "composite": false, "catalogID": "{67AC663A-5987-49F0-B6FB-665CAE3ABE7A}" } ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Pole", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Pole", "type": "esriFieldTypeString", "alias": "Pole", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Pole" }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ADDRESS" }, { "name": "ISSUES", "type": "esriFieldTypeString", "alias": "ISSUES", "domain": { "type": "codedValue", "name": "Streetlight_Issues", "description": "Typical streetlight issues", "codedValues": [ { "name": "Outage", "code": "Outage" }, { "name": "Day Burner", "code": "Day Burner" }, { "name": "Flickers", "code": "Flickers" }, { "name": "Pole Knocked Down", "code": "Pole Knocked Down" }, { "name": "Pole Loose", "code": "Pole Loose" }, { "name": "Pole Leaning", "code": "Pole Leaning" }, { "name": "Base Plate Open", "code": "Base Plate Open" }, { "name": "Base Plate Missing", "code": "Base Plate Missing" }, { "name": "Exposed Wires", "code": "Exposed Wires" }, { "name": "Fixture Damaged", "code": "Fixture Damaged" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ISSUES" }, { "name": "STARTPOLENUM", "type": "esriFieldTypeString", "alias": "STARTPOLENUM", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "STARTPOLENUM" }, { "name": "ENDPOLENUM", "type": "esriFieldTypeString", "alias": "ENDPOLENUM", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "ENDPOLENUM" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "STREETLIGHTTYPE", "type": "esriFieldTypeInteger", "alias": "STREETLIGHTTYPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STREETLIGHTTYPE" } ], "indexes": [ { "name": "R1103_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "esri_sde.DBO.Street_Light_Reporting", "description": "", "prototype": { "attributes": { "last_edited_date": null, "STREETLIGHTTYPE": null, "Pole": null, "ADDRESS": null, "ISSUES": null, "STARTPOLENUM": null, "ENDPOLENUM": null, "created_user": null, "created_date": null, "last_edited_user": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "b7c7d1846dd249dc9fba0aa33f3e0a43" } ] }