{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "ProdGeoDB.STREETLIGHTS.StreetLightFeaturesAnno", "type": "Annotation Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [ { "id": 0, "name": "One Arm" }, { "id": 1, "name": "Two Arms" }, { "id": 2, "name": "Floodlight/ Wallpak" } ], "minScale": 0, "maxScale": 0, "defaultVisibility": true, "extent": { "xmin": 469005.8191999998, "ymin": 4744660.807, "xmax": 490212.1090000002, "ymax": 4767188.5341, "spatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 4.504455473910538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "TextString", "typeIdField": "AnnotationClassID", "subtypeFieldName": "AnnotationClassID", "subtypeField": "AnnotationClassID", "defaultSubtypeCode": 0, "fields": [ { "name": "FontSize", "type": "esriFieldTypeDouble", "alias": "FontSize", "domain": null }, { "name": "XOffset", "type": "esriFieldTypeDouble", "alias": "XOffset", "domain": null }, { "name": "YOffset", "type": "esriFieldTypeDouble", "alias": "YOffset", "domain": null }, { "name": "Angle", "type": "esriFieldTypeDouble", "alias": "Angle", "domain": null }, { "name": "FontLeading", "type": "esriFieldTypeDouble", "alias": "FontLeading", "domain": null }, { "name": "WordSpacing", "type": "esriFieldTypeDouble", "alias": "WordSpacing", "domain": null }, { "name": "CharacterWidth", "type": "esriFieldTypeDouble", "alias": "CharacterWidth", "domain": null }, { "name": "CharacterSpacing", "type": "esriFieldTypeDouble", "alias": "CharacterSpacing", "domain": null }, { "name": "FlipAngle", "type": "esriFieldTypeDouble", "alias": "FlipAngle", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FeatureID", "type": "esriFieldTypeInteger", "alias": "Feature ID", "domain": null }, { "name": "ZOrder", "type": "esriFieldTypeInteger", "alias": "Z Order", "domain": null }, { "name": "AnnotationClassID", "type": "esriFieldTypeInteger", "alias": "Annotation Class ID", "domain": null }, { "name": "SymbolID", "type": "esriFieldTypeInteger", "alias": "Symbol ID", "domain": null }, { "name": "Status", "type": "esriFieldTypeSmallInteger", "alias": "Status", "domain": { "type": "codedValue", "name": "AnnotationStatus", "description": "Valid annotation state values.", "codedValues": [ { "name": "Placed", "code": 0 }, { "name": "Unplaced", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TextString", "type": "esriFieldTypeString", "alias": "Text String", "length": 255, "domain": null }, { "name": "FontName", "type": "esriFieldTypeString", "alias": "Font Name", "length": 255, "domain": null }, { "name": "FontStyle", "type": "esriFieldTypeString", "alias": "Font Style", "length": 255, "domain": null }, { "name": "Underline", "type": "esriFieldTypeSmallInteger", "alias": "Underline", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "VerticalAlignment", "type": "esriFieldTypeSmallInteger", "alias": "Vertical Alignment", "domain": { "type": "codedValue", "name": "VerticalAlignment", "description": "Valid symbol vertical alignment values.", "codedValues": [ { "name": "Top", "code": 0 }, { "name": "Center", "code": 1 }, { "name": "Baseline", "code": 2 }, { "name": "Bottom", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HorizontalAlignment", "type": "esriFieldTypeSmallInteger", "alias": "Horizontal Alignment", "domain": { "type": "codedValue", "name": "HorizontalAlignment", "description": "Valid horizontal symbol alignment values.", "codedValues": [ { "name": "Left", "code": 0 }, { "name": "Center", "code": 1 }, { "name": "Right", "code": 2 }, { "name": "Full", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Override", "type": "esriFieldTypeInteger", "alias": "Override", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R1475_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1860FeatureID", "fields": "FeatureID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1326_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": { "Status": {"type": "inherited"}, "Underline": {"type": "inherited"}, "VerticalAlignment": {"type": "inherited"}, "HorizontalAlignment": {"type": "inherited"} }, "id": 0, "name": "One Arm" }, { "domains": { "Status": {"type": "inherited"}, "Underline": {"type": "inherited"}, "VerticalAlignment": {"type": "inherited"}, "HorizontalAlignment": {"type": "inherited"} }, "id": 1, "name": "Two Arms" }, { "domains": { "Status": {"type": "inherited"}, "Underline": {"type": "inherited"}, "VerticalAlignment": {"type": "inherited"}, "HorizontalAlignment": {"type": "inherited"} }, "id": 2, "name": "Floodlight/Wallpak" } ], "subtypes": [ { "domains": { "Status": {"type": "inherited"}, "Underline": {"type": "inherited"}, "VerticalAlignment": {"type": "inherited"}, "HorizontalAlignment": {"type": "inherited"} }, "defaultValues": { "FeatureID": null, "ZOrder": null, "AnnotationClassID": null, "Element": null, "SymbolID": null, "Status": 0, "TextString": null, "FontName": null, "FontStyle": null, "FontSize": null, "Underline": null, "VerticalAlignment": null, "HorizontalAlignment": null, "XOffset": null, "YOffset": null, "Angle": null, "FontLeading": null, "WordSpacing": null, "CharacterWidth": null, "CharacterSpacing": null, "FlipAngle": null, "Override": null }, "code": 0, "name": "One Arm" }, { "domains": { "Status": {"type": "inherited"}, "Underline": {"type": "inherited"}, "VerticalAlignment": {"type": "inherited"}, "HorizontalAlignment": {"type": "inherited"} }, "defaultValues": { "FeatureID": null, "ZOrder": null, "AnnotationClassID": null, "Element": null, "SymbolID": null, "Status": 0, "TextString": null, "FontName": null, "FontStyle": null, "FontSize": null, "Underline": null, "VerticalAlignment": null, "HorizontalAlignment": null, "XOffset": null, "YOffset": null, "Angle": null, "FontLeading": null, "WordSpacing": null, "CharacterWidth": null, "CharacterSpacing": null, "FlipAngle": null, "Override": null }, "code": 1, "name": "Two Arms" }, { "domains": { "Status": {"type": "inherited"}, "Underline": {"type": "inherited"}, "VerticalAlignment": {"type": "inherited"}, "HorizontalAlignment": {"type": "inherited"} }, "defaultValues": { "FeatureID": null, "ZOrder": null, "AnnotationClassID": null, "Element": null, "SymbolID": null, "Status": 0, "TextString": null, "FontName": null, "FontStyle": null, "FontSize": null, "Underline": null, "VerticalAlignment": null, "HorizontalAlignment": null, "XOffset": null, "YOffset": null, "Angle": null, "FontLeading": null, "WordSpacing": null, "CharacterWidth": null, "CharacterSpacing": null, "FlipAngle": null, "Override": null }, "code": 2, "name": "Floodlight/Wallpak" } ], "relationships": [ { "id": 0, "name": "Street Lighting - Streetlight Features", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "FeatureID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{3323664E-A335-4F6A-B356-8075DA219377}" } ], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": false }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "One Arm", "type": "Annotation SubLayer", "description": "", "geometryType": null, "copyrightText": "", "parentLayer": { "id": 3, "name": "ProdGeoDB.STREETLIGHTS.StreetLightFeaturesAnno" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "defaultVisibility": true, "extent": { "xmin": 469005.8191999998, "ymin": 4744660.807, "xmax": 490212.1090000002, "ymax": 4767188.5341, "spatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 4.504455473910538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": null, "geometryField": {}, "indexes": [], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map", "supportsStatistics": false, "supportsExceedsLimitStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsPercentileStatistics": false, "supportsHavingClause": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsCountDistinct": false, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": false, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": false }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Two Arms", "type": "Annotation SubLayer", "description": "", "geometryType": null, "copyrightText": "", "parentLayer": { "id": 3, "name": "ProdGeoDB.STREETLIGHTS.StreetLightFeaturesAnno" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "defaultVisibility": true, "extent": { "xmin": 469005.8191999998, "ymin": 4744660.807, "xmax": 490212.1090000002, "ymax": 4767188.5341, "spatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 4.504455473910538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": null, "geometryField": {}, "indexes": [], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map", "supportsStatistics": false, "supportsExceedsLimitStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsPercentileStatistics": false, "supportsHavingClause": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsCountDistinct": false, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": false, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": false }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Floodlight/ Wallpak", "type": "Annotation SubLayer", "description": "", "geometryType": null, "copyrightText": "", "parentLayer": { "id": 3, "name": "ProdGeoDB.STREETLIGHTS.StreetLightFeaturesAnno" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "defaultVisibility": true, "extent": { "xmin": 469005.8191999998, "ymin": 4744660.807, "xmax": 490212.1090000002, "ymax": 4767188.5341, "spatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 4.504455473910538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": null, "geometryField": {}, "indexes": [], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map", "supportsStatistics": false, "supportsExceedsLimitStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsPercentileStatistics": false, "supportsHavingClause": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsCountDistinct": false, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": false, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": false }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "Street Lighting - Hydro Features", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "SubHydroFeature", "defaultSymbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 148, 12, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "defaultLabel": "", "uniqueValueGroups": [ { "heading": "SubHydroFeature", "classes": [ { "label": "Disconnect", "description": "Disconnect", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 158, 153, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "3" ] ] }, { "label": "Hydro Pole", "description": "Hydro Pole", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 163, 30, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "4" ] ] }, { "label": "Power Supply Cabinet", "description": "Power Supply Cabinet", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 166, 86, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "5" ] ] }, { "label": "Riser", "description": "Riser", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 145, 0, 104, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "1" ] ] }, { "label": "Transformer (pad-mount)", "description": "Transformer (pad-mount)", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 52, 163, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "2" ] ] }, { "label": "Transformer (pole-mount)", "description": "Transformer (pole-mount)", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 78, 145, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "6" ] ] }, { "label": "Unknown", "description": "Unknown", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 0, 156, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "0" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 158, 153, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "3", "label": "Disconnect" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 163, 30, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "4", "label": "Hydro Pole" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 166, 86, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "5", "label": "Power Supply Cabinet" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 145, 0, 104, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "1", "label": "Riser" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 52, 163, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "2", "label": "Transformer (pad-mount)" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 78, 145, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "6", "label": "Transformer (pole-mount)" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 0, 156, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "0", "label": "Unknown" } ], "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 469736.858, "ymin": 4744155.5985, "xmax": 493009.16779999994, "ymax": 4767127.1052, "spatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 4.504455473910538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "LastEditor", "typeIdField": "SubHydroFeature", "subtypeFieldName": "SubHydroFeature", "subtypeField": "SubHydroFeature", "defaultSubtypeCode": 0, "fields": [ { "name": "GIS_ID", "type": "esriFieldTypeInteger", "alias": "Unique Hydro Feature ID", "domain": null }, { "name": "SubHydroFeature", "type": "esriFieldTypeInteger", "alias": "Hydro Feature Subtype", "domain": { "type": "codedValue", "name": "StreetLighting_HydroFeatureSubtype", "description": "Street Lighting - Hydro Feature Subtype", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Riser", "code": 1 }, { "name": "Transformer", "code": 2 }, { "name": "Disconnect", "code": 3 }, { "name": "Hydro Pole", "code": 4 }, { "name": "Power Supply Cabinet", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Rotation", "type": "esriFieldTypeDouble", "alias": "Symbol Rotation", "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 25, "domain": null }, { "name": "LastEditDate", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "StreetLighting_StreetlightStatus", "description": "Streetlight Status", "codedValues": [ { "name": "Accepted", "code": "Accepted" }, { "name": "Assumed", "code": "Assumed" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Conditional", "code": "Conditional" }, { "name": "Constructed", "code": "Constructed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R657_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S551_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": { "SubHydroFeature": {"type": "inherited"}, "Status": { "type": "codedValue", "name": "StreetLighting_Status", "description": "Street Lighting - Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 0, "name": "Unknown" }, { "domains": { "SubHydroFeature": {"type": "inherited"}, "Status": { "type": "codedValue", "name": "StreetLighting_Status", "description": "Street Lighting - Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 4, "name": "Hydro Pole" }, { "domains": { "SubHydroFeature": {"type": "inherited"}, "Status": { "type": "codedValue", "name": "StreetLighting_Status", "description": "Street Lighting - Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 3, "name": "Disconnect" }, { "domains": { "SubHydroFeature": {"type": "inherited"}, "Status": { "type": "codedValue", "name": "StreetLighting_Status", "description": "Street Lighting - Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 5, "name": "Power Supply Cabinet" }, { "domains": { "SubHydroFeature": {"type": "inherited"}, "Status": { "type": "codedValue", "name": "StreetLighting_Status", "description": "Street Lighting - Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 1, "name": "Riser" }, { "domains": { "Status": { "type": "codedValue", "name": "StreetLighting_Status", "description": "Street Lighting - Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 2, "name": "Transformer (pad-mount)" }, { "domains": { "Status": { "type": "codedValue", "name": "StreetLighting_Status", "description": "Street Lighting - Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 6, "name": "Transformer (pole-mount)" } ], "subtypes": [ { "domains": { "SubHydroFeature": {"type": "inherited"}, "Status": { "type": "codedValue", "name": "StreetLighting_Status", "description": "Street Lighting - Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "GIS_ID": null, "SubHydroFeature": null, "Rotation": null, "LastEditor": null, "LastEditDate": null, "Status": null }, "code": 0, "name": "Unknown" }, { "domains": { "SubHydroFeature": {"type": "inherited"}, "Status": { "type": "codedValue", "name": "StreetLighting_Status", "description": "Street Lighting - Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "GIS_ID": null, "SubHydroFeature": null, "Rotation": null, "LastEditor": null, "LastEditDate": null, "Status": null }, "code": 4, "name": "Hydro Pole" }, { "domains": { "SubHydroFeature": {"type": "inherited"}, "Status": { "type": "codedValue", "name": "StreetLighting_Status", "description": "Street Lighting - Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "GIS_ID": null, "SubHydroFeature": null, "Rotation": null, "LastEditor": null, "LastEditDate": null, "Status": null }, "code": 3, "name": "Disconnect" }, { "domains": { "SubHydroFeature": {"type": "inherited"}, "Status": { "type": "codedValue", "name": "StreetLighting_Status", "description": "Street Lighting - Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "GIS_ID": null, "SubHydroFeature": null, "Rotation": null, "LastEditor": null, "LastEditDate": null, "Status": null }, "code": 5, "name": "Power Supply Cabinet" }, { "domains": { "SubHydroFeature": {"type": "inherited"}, "Status": { "type": "codedValue", "name": "StreetLighting_Status", "description": "Street Lighting - Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "GIS_ID": null, "SubHydroFeature": null, "Rotation": null, "LastEditor": null, "LastEditDate": null, "Status": null }, "code": 1, "name": "Riser" }, { "domains": { "Status": { "type": "codedValue", "name": "StreetLighting_Status", "description": "Street Lighting - Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "GIS_ID": null, "SubHydroFeature": null, "Rotation": null, "LastEditor": null, "LastEditDate": null, "Status": null }, "code": 2, "name": "Transformer (pad-mount)" }, { "domains": { "Status": { "type": "codedValue", "name": "StreetLighting_Status", "description": "Street Lighting - Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "GIS_ID": null, "SubHydroFeature": null, "Rotation": null, "LastEditor": null, "LastEditDate": null, "Status": null }, "code": 6, "name": "Transformer (pole-mount)" } ], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Street Lighting - Streetlight Features", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "GIS_ID", "defaultSymbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 126, 0, 143, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "defaultLabel": "", "uniqueValueGroups": [ { "heading": "GIS_ID", "classes": [ { "label": "New Subtype", "description": "New Subtype", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 99, 148, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "0" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 99, 148, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "0", "label": "New Subtype" } ], "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 468998.54000000004, "ymin": 4744653.3036, "xmax": 490226.7318000002, "ymax": 4767190.784700001, "spatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 4.504455473910538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "MapTile", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GIS_ID", "type": "esriFieldTypeInteger", "alias": "Unique Street Light ID", "domain": null }, { "name": "RLA", "type": "esriFieldTypeInteger", "alias": "Relamping Area", "domain": null }, { "name": "MapTile", "type": "esriFieldTypeString", "alias": "Map Tile", "length": 5, "domain": null }, { "name": "Rotation", "type": "esriFieldTypeDouble", "alias": "Symbol Rotation", "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 25, "domain": null }, { "name": "LastEditDate", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "CartoSymbolType", "type": "esriFieldTypeString", "alias": "Cartographic Type (internal)", "length": 75, "domain": { "type": "codedValue", "name": "StreetLighting_CartographicSymbolType", "description": "Street Llghting - Cartographic Symbol Type", "codedValues": [ { "name": "Arm - 1 Head - 100w", "code": "Arm - 1 Head - 100w" }, { "name": "Arm - 1 Head - 150w", "code": "Arm - 1 Head - 150w" }, { "name": "Arm - 1 Head - 150w - w/ Pedestrian Globe", "code": "Arm - 1 Head - 150w - w/ Pedestrian Globe" }, { "name": "Arm - 1 Head - 175w", "code": "Arm - 1 Head - 175w" }, { "name": "Arm - 1 Head - 200w", "code": "Arm - 1 Head - 200w" }, { "name": "Arm - 1 Head - 200w - w/ Pedestrian Globe", "code": "Arm - 1 Head - 200w - w/ Pedestrian Globe" }, { "name": "Arm - 1 Head - 250w", "code": "Arm - 1 Head - 250w" }, { "name": "Arm - 1 Head - 400w", "code": "Arm - 1 Head - 400w" }, { "name": "Arm - 1 Head - 50w", "code": "Arm - 1 Head - 50w" }, { "name": "Arm - 1 Head - 70w", "code": "Arm - 1 Head - 70w" }, { "name": "Arm - 1 Head - LED", "code": "Arm - 1 Head - LED" }, { "name": "Arm - 1 Head - LED - w/ Pedestrian Globe", "code": "Arm - 1 Head - LED - w/ Pedestrian Globe" }, { "name": "Arm - 2 Heads - 100w", "code": "Arm - 2 Heads - 100w" }, { "name": "Arm - 2 Heads - 100w (90 deg)", "code": "Arm - 2 Heads - 100w (90 deg)" }, { "name": "Arm - 2 Heads - 150w", "code": "Arm - 2 Heads - 150w" }, { "name": "Arm - 2 Heads - 150w (90 deg)", "code": "Arm - 2 Heads - 150w (90 deg)" }, { "name": "Arm - 2 Heads - 150w + 200w", "code": "Arm - 2 Heads - 150w + 200w" }, { "name": "Arm - 2 Heads - 200w", "code": "Arm - 2 Heads - 200w" }, { "name": "Arm - 2 Heads - 200w + 250w", "code": "Arm - 2 Heads - 200w + 250w" }, { "name": "Arm - 2 Heads - 250w", "code": "Arm - 2 Heads - 250w" }, { "name": "Arm - 2 Heads - 50w", "code": "Arm - 2 Heads - 50w" }, { "name": "Arm - 2 Heads - 70w", "code": "Arm - 2 Heads - 70w" }, { "name": "Arm - 2 Heads - 70w + 250w", "code": "Arm - 2 Heads - 70w + 250w" }, { "name": "Arm - 2 Heads - LED", "code": "Arm - 2 Heads - LED" }, { "name": "Arm - 2 Heads - LED (90 deg)", "code": "Arm - 2 Heads - LED (90 deg)" }, { "name": "Flood Light", "code": "Flood Light" }, { "name": "Future Streetlight", "code": "Future Streetlight" }, { "name": "Pedestrian Globe", "code": "Pedestrian Globe" }, { "name": "Post Top - 1 Head - 250w", "code": "Post Top - 1 Head - 250w" }, { "name": "Post Top - 1 Head - 100w", "code": "Post Top - 1 Head - 100w" }, { "name": "Post Top - 1 Head - 150w", "code": "Post Top - 1 Head - 150w" }, { "name": "Post Top - 1 Head - 200w", "code": "Post Top - 1 Head - 200w" }, { "name": "Post Top - 1 Head - 50w", "code": "Post Top - 1 Head - 50w" }, { "name": "Post Top - 1 Head - 70w", "code": "Post Top - 1 Head - 70w" }, { "name": "Post Top - 1 Head - Gas", "code": "Post Top - 1 Head - Gas" }, { "name": "Post Top - 1 Head - LED", "code": "Post Top - 1 Head - LED" }, { "name": "Post Top - 2 Heads - 100w", "code": "Post Top - 2 Heads - 100w" }, { "name": "Post Top - 2 Heads - 150w", "code": "Post Top - 2 Heads - 150w" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Wall Pack", "code": "Wall Pack" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PublicCartoSymbolType", "type": "esriFieldTypeString", "alias": "Cartography Type (public)", "length": 100, "domain": { "type": "codedValue", "name": "Streetlighting_PublicCartoSymbolType", "description": "Street Lighting - Public Cartographic Symbol Type", "codedValues": [ { "name": "1 Arm - 1 Head", "code": "1 Arm - 1 Head" }, { "name": "1 Arm - 1 Head with Pedestrian Globe", "code": "1 Arm - 1 Head with Pedestrian Globe" }, { "name": "2 Arms - 2 Heads", "code": "2 Arms - 2 Heads" }, { "name": "Post Top - 1 Head", "code": "Post Top - 1 Head" }, { "name": "Post Top - 2 Heads", "code": "Post Top - 2 Heads" }, { "name": "Pedestrian Globe", "code": "Pedestrian Globe" }, { "name": "Flood Light/ Wall Pack", "code": "Flood Light/ Wall Pack" }, { "name": "Future Street Light Location or Installed but not Assumed by City", "code": "Future Street Light Location or Installed but not Assumed by City" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RoadClass", "type": "esriFieldTypeString", "alias": "Road Class", "length": 50, "domain": { "type": "codedValue", "name": "StreetLighting_RoadClass", "description": "Street Lighting - Road Class", "codedValues": [ { "name": "Arterial", "code": "Arterial" }, { "name": "Secondary Collector", "code": "Secondary Collector" }, { "name": "Local", "code": "Local" }, { "name": "Walkway", "code": "Walkway" }, { "name": "Primary Collector", "code": "Primary Collector" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "StreetLighting_StreetlightStatus", "description": "Streetlight Status", "codedValues": [ { "name": "Accepted", "code": "Accepted" }, { "name": "Assumed", "code": "Assumed" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Conditional", "code": "Conditional" }, { "name": "Constructed", "code": "Constructed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "PoleMaterial", "type": "esriFieldTypeString", "alias": "Material", "length": 8, "domain": { "type": "codedValue", "name": "StreetLighting_PoleMaterial", "description": "Street Lighting - Pole Material", "codedValues": [ { "name": "Other", "code": "Other" }, { "name": "Aluminum", "code": "Aluminum" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Steel", "code": "Steel" }, { "name": "Wood", "code": "Wood" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspected", "type": "esriFieldTypeString", "alias": "Pole Inspected", "length": 255, "domain": { "type": "codedValue", "name": "StreetLighting_Boolean", "description": "Street Lighting - Boolean Value", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R1470_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1855GIS_ID", "fields": "GIS_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1855Status", "fields": "Status", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1325_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Lamp Attributes", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "GIS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{29609916-B90D-40B8-958D-9FC6E0CC190C}" }, { "id": 2, "name": "Inspection Attributes", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "GIS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{E52FD24A-D7FF-4BF8-A287-C0C4D7C49E8A}" }, { "id": 0, "name": "GeoDbGeomatics.STREETLIGHTS.Street_Lighting___Streetlight_FeaturesAnno", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{3323664E-A335-4F6A-B356-8075DA219377}" }, { "id": 3, "name": "Arm Attributes", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "GIS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{914FBDB2-1F5A-4B3B-89EB-9030DD87765A}" }, { "id": 4, "name": "Pole Attributes", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "GIS_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{64108B9E-15CA-4BCF-B46C-3556E970B9F3}" } ], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "Street Lighting - Hydro Feeds", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "FeedSubtype", "defaultSymbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 138, 46, 0, 255 ], "width": 1 }, "defaultLabel": "", "uniqueValueGroups": [ { "heading": "FeedSubtype", "classes": [ { "label": "Overhead Feed", "description": "Overhead Feed", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 90, 0, 163, 255 ], "width": 1 }, "values": [ [ "2" ] ] }, { "label": "Underground Feed", "description": "Underground Feed", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 74, 153, 255 ], "width": 1 }, "values": [ [ "1" ] ] }, { "label": "Unknown", "description": "Unknown", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 135, 0, 77, 255 ], "width": 1 }, "values": [ [ "0" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 90, 0, 163, 255 ], "width": 1 }, "value": "2", "label": "Overhead Feed" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 74, 153, 255 ], "width": 1 }, "value": "1", "label": "Underground Feed" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 135, 0, 77, 255 ], "width": 1 }, "value": "0", "label": "Unknown" } ], "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 469695.46079999954, "ymin": 4744152.2382, "xmax": 490226.7318000002, "ymax": 4767194.1280000005, "spatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 4.504455473910538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Comments", "typeIdField": "FeedSubtype", "subtypeFieldName": "FeedSubtype", "subtypeField": "FeedSubtype", "defaultSubtypeCode": 0, "fields": [ { "name": "GIS_ID", "type": "esriFieldTypeInteger", "alias": "Unique Feed ID", "domain": null }, { "name": "FeedSubtype", "type": "esriFieldTypeInteger", "alias": "Feed Subtype", "domain": { "type": "codedValue", "name": "StreetLighting_FeedSubtype", "description": "Street Lighting - Feed Subtype", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Underground Feed", "code": 1 }, { "name": "Overhead Feed", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 25, "domain": null }, { "name": "LastEditDate", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1073741822, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "StreetLighting_StreetlightStatus", "description": "Streetlight Status", "codedValues": [ { "name": "Accepted", "code": "Accepted" }, { "name": "Assumed", "code": "Assumed" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Conditional", "code": "Conditional" }, { "name": "Constructed", "code": "Constructed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R656_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S550_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": { "FeedSubtype": {"type": "inherited"} }, "id": 1, "name": "Underground Feed" }, { "domains": { "FeedSubtype": {"type": "inherited"} }, "id": 2, "name": "Overhead Feed" }, { "domains": { "FeedSubtype": {"type": "inherited"} }, "id": 0, "name": "Unknown" } ], "subtypes": [ { "domains": { "FeedSubtype": {"type": "inherited"} }, "defaultValues": { "GIS_ID": null, "FeedSubtype": 1, "Comments": null, "LastEditor": null, "LastEditDate": null, "Status": null }, "code": 1, "name": "Underground Feed" }, { "domains": { "FeedSubtype": {"type": "inherited"} }, "defaultValues": { "GIS_ID": null, "FeedSubtype": 1, "Comments": null, "LastEditor": null, "LastEditDate": null, "Status": null }, "code": 2, "name": "Overhead Feed" }, { "domains": { "FeedSubtype": {"type": "inherited"} }, "defaultValues": { "GIS_ID": null, "FeedSubtype": 1, "Comments": null, "LastEditor": null, "LastEditDate": null, "Status": null }, "code": 0, "name": "Unknown" } ], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "Street Lighting - Map Tile Grid", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 198, 201, 245, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 467000, "ymin": 4740000, "xmax": 493000, "ymax": 4770000, "spatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 4.504455473910538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "TileLabel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GIS_ID", "type": "esriFieldTypeInteger", "alias": "Unique Map Tile ID", "domain": null }, { "name": "TileLabel", "type": "esriFieldTypeString", "alias": "Tile Label", "length": 5, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 25, "domain": null }, { "name": "LastEditDate", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "ActivePageNo", "type": "esriFieldTypeSmallInteger", "alias": "Active Page No", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "StreetLighting_MapTileStatus", "description": "Street Lighting - Map Tile Status", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Not Active", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R658_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S552_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "Street Lighting - Relamping Program Areas", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 244, 191, 245, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 468138.88329999987, "ymin": 4741394.2963, "xmax": 491254.47809999995, "ymax": 4768945.4657000005, "spatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 4.504455473910538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "RLA_Label", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GIS_ID", "type": "esriFieldTypeInteger", "alias": "Unique Relamping Area ID", "domain": null }, { "name": "RLA_Label", "type": "esriFieldTypeString", "alias": "Relamping Area Label", "length": 20, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 25, "domain": null }, { "name": "LastEditDate", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "PageScale", "type": "esriFieldTypeDouble", "alias": "PageScale", "domain": null }, { "name": "PageRotation", "type": "esriFieldTypeDouble", "alias": "PageRotation", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R659_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S553_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "ProdGeoDB.STREETLIGHTS.StreetLighting_Arms", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "GIS_FeatureKey", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GIS_ID", "type": "esriFieldTypeInteger", "alias": "Streetlight GIS ID", "domain": null }, { "name": "GIS_FeatureKey", "type": "esriFieldTypeString", "alias": "Unique Arm ID", "length": 20, "domain": null }, { "name": "ArmLength", "type": "esriFieldTypeString", "alias": "Length", "length": 5, "domain": { "type": "codedValue", "name": "StreetLighting_ArmLength", "description": "Street Lighting - Arm Length", "codedValues": [ { "name": "0.6 m (2 ft)", "code": "2" }, { "name": "1.2 m (4 ft)", "code": "4" }, { "name": "1.8 m (6 ft)", "code": "6" }, { "name": "2.4 m (8 ft)", "code": "8" }, { "name": "3.0 m (9.8 ft)", "code": "9.8" }, { "name": "3.6 m (11.8 ft)", "code": "11.8" }, { "name": "4.6 m (15 ft)", "code": "15" }, { "name": "5.5 m (18 ft)", "code": "18" }, { "name": "6.1 m (20 ft)", "code": "20" }, { "name": "6.7 m (22 ft)", "code": "22" }, { "name": "7.6 m (25 ft)", "code": "25" }, { "name": "3.2 m (10.5 ft)", "code": "10.5" }, { "name": "0.2 m (0.5 ft)", "code": "0.5" }, { "name": "0.3 m (1 ft)", "code": "1" }, { "name": "2.7 m (8.8 ft)", "code": "8.8" }, { "name": "Uknown", "code": "UKN" }, { "name": "Other", "code": "OTH" }, { "name": "N/A", "code": "N/A" }, { "name": "0.8 m (2.5 ft)", "code": "2.5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ArmColour", "type": "esriFieldTypeString", "alias": "Colour", "length": 25, "domain": { "type": "codedValue", "name": "StreetLighting_Colour", "description": "Street Lighting - Colour", "codedValues": [ { "name": "Other", "code": "Other" }, { "name": "Black", "code": "Black" }, { "name": "Green", "code": "Green" }, { "name": "Grey", "code": "Grey" }, { "name": "N/A", "code": "N/A" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ArmStyle", "type": "esriFieldTypeString", "alias": "Style", "length": 8, "domain": { "type": "codedValue", "name": "StreetLighting_ArmStyle", "description": "Street Lighting - Arm Style", "codedValues": [ { "name": "Downtown Decorative (Stresscrete)", "code": "DD-S" }, { "name": "Decorative (Candy Cane)", "code": "D-CC" }, { "name": "Scroll Arm", "code": "SCROLL" }, { "name": "N/A", "code": "N/A" }, { "name": "Standard", "code": "STND" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1073741822, "domain": null } ], "indexes": [ { "name": "R1472_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1857GIS_ID", "fields": "GIS_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "StreetLight Features", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "GIS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{914FBDB2-1F5A-4B3B-89EB-9030DD87765A}" } ], "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "ProdGeoDB.STREETLIGHTS.StreetLighting_Inspections", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "GIS_FeatureKey", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GIS_ID", "type": "esriFieldTypeInteger", "alias": "Streetlight GIS ID", "domain": null }, { "name": "GIS_FeatureKey", "type": "esriFieldTypeString", "alias": "Unique Inspection ID", "length": 20, "domain": null }, { "name": "DateOfInspection", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Name of Inspector", "length": 50, "domain": null }, { "name": "Deficiency_HandHoleCoverMissing", "type": "esriFieldTypeString", "alias": "Deficiency - Hand Hole Cover Missing", "length": 1, "domain": { "type": "codedValue", "name": "StreetLighting_Boolean", "description": "Street Lighting - Boolean Value", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Deficiency_HeadTilted", "type": "esriFieldTypeString", "alias": "Deficiency - Head Tilted", "length": 1, "domain": { "type": "codedValue", "name": "StreetLighting_Boolean", "description": "Street Lighting - Boolean Value", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Deficiency_TreeBlocking", "type": "esriFieldTypeString", "alias": "Deficiency - Tree Blocking", "length": 1, "domain": { "type": "codedValue", "name": "StreetLighting_Boolean", "description": "Street Lighting - Boolean Value", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Deficiency_LensBroken", "type": "esriFieldTypeString", "alias": "Deficiency - Lens Broken", "length": 1, "domain": { "type": "codedValue", "name": "StreetLighting_Boolean", "description": "Street Lighting - Boolean Value", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Deficiency_HeadMissing", "type": "esriFieldTypeString", "alias": "Deficiency - Head Missing", "length": 1, "domain": { "type": "codedValue", "name": "StreetLighting_Boolean", "description": "Street Lighting - Boolean Value", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Deficiency_Leaning", "type": "esriFieldTypeString", "alias": "Deficiency - Leaning", "length": 1, "domain": { "type": "codedValue", "name": "StreetLighting_Boolean", "description": "Street Lighting - Boolean Value", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Deficiency_LightOn", "type": "esriFieldTypeString", "alias": "Deficiency - Light On", "length": 1, "domain": { "type": "codedValue", "name": "StreetLighting_Boolean", "description": "Street Lighting - Boolean Value", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Damage_RustCondition", "type": "esriFieldTypeString", "alias": "Damage - Rusting Condition", "length": 9, "domain": { "type": "codedValue", "name": "StreetLighting_Boolean", "description": "Street Lighting - Boolean Value", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Damage_HolesCracks", "type": "esriFieldTypeString", "alias": "Damage Condition - Holes or Cracks", "length": 6, "domain": { "type": "codedValue", "name": "StreetLighting_Boolean", "description": "Street Lighting - Boolean Value", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Damage_Dents", "type": "esriFieldTypeString", "alias": "Damage Condition - Dents", "length": 6, "domain": { "type": "codedValue", "name": "StreetLighting_Boolean", "description": "Street Lighting - Boolean Value", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Replace", "type": "esriFieldTypeString", "alias": "Replacement Required", "length": 12, "domain": { "type": "codedValue", "name": "StreetLighting_InspectionReplacement", "description": "Street Lighting - Replacement Required", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Near Future", "code": "Near Future" }, { "name": "Immediately", "code": "Immediately" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments_Recommendations", "type": "esriFieldTypeString", "alias": "Provide Comments/Recommendations", "length": 1073741822, "domain": null }, { "name": "Deficiency_PoleBase", "type": "esriFieldTypeString", "alias": "Provide Pole Base Condition", "length": 255, "domain": { "type": "codedValue", "name": "Streetlighting_PoleBase", "description": "Streetlighting - Pole Base", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Needs Monitoring", "code": "Needs Monitoring" }, { "name": "Requires Replacement", "code": "Requires Replacement" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R1473_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1858GIS_ID", "fields": "GIS_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "StreetLight Feature", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "GIS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{E52FD24A-D7FF-4BF8-A287-C0C4D7C49E8A}" } ], "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "ProdGeoDB.STREETLIGHTS.StreetLighting_Lamps", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ModelName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GIS_ID", "type": "esriFieldTypeInteger", "alias": "Streetlight GIS ID", "domain": null }, { "name": "GIS_FeatureKey", "type": "esriFieldTypeString", "alias": "Unique Lamp ID", "length": 20, "domain": null }, { "name": "LampStyle", "type": "esriFieldTypeString", "alias": "Lamp Style", "length": 5, "domain": { "type": "codedValue", "name": "StreetLighting_LampStyle", "description": "Street Lighting - Lamp Style ", "codedValues": [ { "name": "Gas", "code": "GAS" }, { "name": "Light Emitting Diode (LED)", "code": "LED" }, { "name": "High Pressure Sodium (HPS)", "code": "HPS" }, { "name": "Metal Halide (MH)", "code": "MH" }, { "name": "Mercury Vapor (MV)", "code": "MV" }, { "name": "Low Pressure Sodium (LPS)", "code": "LPS" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FixtureStyle", "type": "esriFieldTypeString", "alias": "Fixture Style", "length": 5, "domain": { "type": "codedValue", "name": "StreetLighting_FixtureStyle", "description": "Street Lighting - Fixture Style", "codedValues": [ { "name": "Box Light", "code": "BL" }, { "name": "Coach Lantern", "code": "CL" }, { "name": "Cobra", "code": "COB" }, { "name": "Decorative Acorn (King)", "code": "DA-K" }, { "name": "Decorative Acorn (Quattro)", "code": "DA-Q" }, { "name": "DuraStar", "code": "DS" }, { "name": "DuraStar - w/ Pedestrian Globe", "code": "DS+PG" }, { "name": "Flood Light", "code": "FL" }, { "name": "Helios", "code": "HEL" }, { "name": "Light Emitting Diode", "code": "LED" }, { "name": "Lumec Urbanscape (Philips)", "code": "LUM" }, { "name": "Ornamental Post Top", "code": "OPT" }, { "name": "Other", "code": "OTH" }, { "name": "Pedestrian Globe", "code": "PG" }, { "name": "Post Top Crook Arm", "code": "PTCA" }, { "name": "Unknown", "code": "UKN" }, { "name": "Wall Pack", "code": "WP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ControlType", "type": "esriFieldTypeString", "alias": "Control Type", "length": 5, "domain": { "type": "codedValue", "name": "StreetLighting_ControlType", "description": "Street Lighting - Control Type", "codedValues": [ { "name": "Photo Electric", "code": "Photo" }, { "name": "Relay", "code": "Relay" }, { "name": "N/A", "code": "NA" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MountType", "type": "esriFieldTypeString", "alias": "Mount Type", "length": 8, "domain": { "type": "codedValue", "name": "StreetLighting_FixtureMountType", "description": "Street Lighting - Fixture Mount Type", "codedValues": [ { "name": "Arm", "code": "Arm" }, { "name": "Other", "code": "Other" }, { "name": "Post Top", "code": "Post Top" }, { "name": "Standard", "code": "Standard" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MountHeight", "type": "esriFieldTypeString", "alias": "Mount Height", "length": 5, "domain": { "type": "codedValue", "name": "StreetLighting_FixtureMountHeight", "description": "Street Lighting - Fixture Mount Height", "codedValues": [ { "name": "2.7 m (9 ft)", "code": "9" }, { "name": "2.9 m (9.5 ft)", "code": "9.5" }, { "name": "3.0 m (10 ft)", "code": "10" }, { "name": "3.2 m (10.5 ft)", "code": "10.5" }, { "name": "3.3 m (11 ft)", "code": "11" }, { "name": "3.5 m (11.5 ft)", "code": "11.5" }, { "name": "3.7 m (12 ft)", "code": "12" }, { "name": "3.8 m (12.5 ft)", "code": "12.5" }, { "name": "4.0 m (13 ft)", "code": "13" }, { "name": "4.1 m (13.5 ft)", "code": "13.5" }, { "name": "4.3 m (14 ft)", "code": "14" }, { "name": "4.4 m (14.5 ft)", "code": "14.5" }, { "name": "4.6 m (15 ft)", "code": "15" }, { "name": "4.7 m (15.5 ft)", "code": "15.5" }, { "name": "4.9 m (16 ft)", "code": "16" }, { "name": "5.0 m (16.5)", "code": "16.5" }, { "name": "5.2 m (17 ft)", "code": "17" }, { "name": "5.3 m (17.5 ft)", "code": "17.5" }, { "name": "5.5 m (18 ft)", "code": "18" }, { "name": "5.6 m (18.5 ft)", "code": "18.5" }, { "name": "5.8 m (19 ft)", "code": "19" }, { "name": "5.9 m (19.5 ft)", "code": "19.5" }, { "name": "6.1 m (20 ft)", "code": "20" }, { "name": "6.2 m (20.5 ft)", "code": "20.5" }, { "name": "6.4 m (21 ft)", "code": "21" }, { "name": "6.6 m (21.5 ft)", "code": "21.5" }, { "name": "6.7 m (22 ft)", "code": "22" }, { "name": "6.9 m (22.5 ft)", "code": "22.5" }, { "name": "7.0 m (23 ft)", "code": "23" }, { "name": "7.2 m (23.5 ft)", "code": "23.5" }, { "name": "7.3 m (24 ft)", "code": "24" }, { "name": "7.5 m (24.5 ft)", "code": "24.5" }, { "name": "7.8 m (25.5 ft)", "code": "25.5" }, { "name": "7.9 m (26 ft)", "code": "26" }, { "name": "8.1 m (26.5 ft)", "code": "26.5" }, { "name": "8.2 m (27 ft)", "code": "27" }, { "name": "8.5 m (28 ft)", "code": "28" }, { "name": "8.7 m (28.5 ft)", "code": "28.5" }, { "name": "8.4 m (8.4 ft)", "code": "27.5" }, { "name": "7.6 m (25 ft)", "code": "25" }, { "name": "8.8 m (29 ft)", "code": "29" }, { "name": "9.0 m (29.5 ft)", "code": "29.5" }, { "name": "9.1 m (30 ft)", "code": "30" }, { "name": "9.3 m (30.5 ft)", "code": "30.5" }, { "name": "9.4 m (31 ft)", "code": "31" }, { "name": "9.6 m (31.5 ft)", "code": "31.5" }, { "name": "9.8 m (32 ft)", "code": "32" }, { "name": "9.9 m (32.5 ft)", "code": "32.5" }, { "name": "10.1 m (33 ft)", "code": "33" }, { "name": "10.2 m (33.5 ft)", "code": "33.5" }, { "name": "10.4 m (34 ft)", "code": "34" }, { "name": "10.5 m (34.5 ft)", "code": "34.5" }, { "name": "10.7 m (35 ft)", "code": "35" }, { "name": "10.8 m (35.5 ft)", "code": "35.5" }, { "name": "11.0 m (36 ft)", "code": "36" }, { "name": "11.1 m (36.5 ft)", "code": "36.5" }, { "name": "11.3 m (37 ft)", "code": "37" }, { "name": "11.4 m (37.5 ft)", "code": "37.5" }, { "name": "11.6 m (38 ft)", "code": "38" }, { "name": "11.7 m (38.5 ft)", "code": "38.5" }, { "name": "11.9 m (39 ft)", "code": "39" }, { "name": "12.0 m (39.5 ft)", "code": "39.5" }, { "name": "12.2 m (40 ft)", "code": "40" }, { "name": "12.3 m (40.5 ft)", "code": "40.5" }, { "name": "12.5 m (41 ft)", "code": "41" }, { "name": "12.6 m (41.5 ft)", "code": "41.5" }, { "name": "12.8 m (42 ft)", "code": "42" }, { "name": "13.0 m (42.5 ft)", "code": "42.5" }, { "name": "13.1 m (43 ft)", "code": "43" }, { "name": "13.3 m (43.5 ft)", "code": "43.5" }, { "name": "13.4 m (44 ft)", "code": "44" }, { "name": "13.6 m (44.5 ft)", "code": "44.5" }, { "name": "13.7 m (45 ft)", "code": "45" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ModelName", "type": "esriFieldTypeString", "alias": "Model Name", "length": 50, "domain": { "type": "codedValue", "name": "FixtureModelName", "description": "Fixture Model Name", "codedValues": [ { "name": "Autobahn ATB0", "code": "Autobahn ATB0\nAutobahn ATB0\nAutobahn ATB0" }, { "name": "Autobahn ATB1", "code": "Autobahn ATB1" }, { "name": "Autobahn ATB2", "code": "Autobahn ATB2" }, { "name": "Evolve ERS1", "code": "Evolve ERS1" }, { "name": "Evolve ERS2", "code": "Evolve ERS2" }, { "name": "Evolve ERS3", "code": "Evolve ERS3" }, { "name": "Evolve ERS4", "code": "Evolve ERS4" }, { "name": "LEDgend", "code": "LEDgend" }, { "name": "LEDway", "code": "LEDway" }, { "name": "NXT", "code": "NXT" }, { "name": "OVH", "code": "OVH" }, { "name": "Roadstar", "code": "Roadstar" }, { "name": "Roadview", "code": "Roadview" }, { "name": "Satellite", "code": "Satellite" }, { "name": "Streetworks", "code": "Streetworks" }, { "name": "TunnelPass LED", "code": "TunnelPass LED" }, { "name": "USSL", "code": "USSL" }, { "name": "Verdeon", "code": "Verdeon" }, { "name": "XSP", "code": "XSP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": { "type": "codedValue", "name": "FixtureModelNumber", "description": "", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "DistributionType", "type": "esriFieldTypeString", "alias": "Distribution Type", "length": 50, "domain": { "type": "codedValue", "name": "FixtureDistributionType", "description": "Fixture Distribution Type", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CatalogNumber", "type": "esriFieldTypeString", "alias": "Catalog Number", "length": 50, "domain": { "type": "codedValue", "name": "FixtureCatalogueNumber", "description": "Fixture Catalog Number", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Voltage", "type": "esriFieldTypeInteger", "alias": "Voltage", "domain": { "type": "codedValue", "name": "StreetLighting_Voltage", "description": "Street Lighting - Voltage", "codedValues": [ { "name": "120 volts", "code": 120 }, { "name": "240 volts", "code": 240 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Wattage", "type": "esriFieldTypeString", "alias": "Wattage", "length": 5, "domain": { "type": "codedValue", "name": "StreetLighting_Wattage", "description": "Street Lighting - Wattage", "codedValues": [ { "name": "100 watts", "code": "100" }, { "name": "101 watts", "code": "101" }, { "name": "103 Watts", "code": "103" }, { "name": "104 Watts", "code": "104" }, { "name": "105 Watts", "code": "105" }, { "name": "110 watts", "code": "110" }, { "name": "111 Watts", "code": "111" }, { "name": "112 watts", "code": "112" }, { "name": "120 Watts", "code": "120" }, { "name": "126 Watts", "code": "126" }, { "name": "130 watts", "code": "130" }, { "name": "132 Watts", "code": "132" }, { "name": "133 Watts", "code": "133" }, { "name": "134 watts", "code": "134" }, { "name": "138 Watts", "code": "138" }, { "name": "139 Watts", "code": "139" }, { "name": "140 watts", "code": "140" }, { "name": "143 Watts", "code": "143" }, { "name": "145 watts", "code": "145" }, { "name": "148 Watts", "code": "148" }, { "name": "15 Watts", "code": "15" }, { "name": "150 watts", "code": "150" }, { "name": "153 watts", "code": "153" }, { "name": "155 Watts", "code": "155" }, { "name": "156 Watts", "code": "156" }, { "name": "16 Watts", "code": "16" }, { "name": "160 watts", "code": "160" }, { "name": "165 Watts", "code": "165" }, { "name": "168 watts", "code": "168" }, { "name": "170 Watts", "code": "170" }, { "name": "174 Watts", "code": "174" }, { "name": "175 watts", "code": "175" }, { "name": "177 Watts", "code": "177" }, { "name": "178 Watts", "code": "178" }, { "name": "18 Watts", "code": "18" }, { "name": "180 watts", "code": "180" }, { "name": "182 Watts", "code": "182" }, { "name": "183 Watts", "code": "183" }, { "name": "185 watts", "code": "185" }, { "name": "197 Watts", "code": "197" }, { "name": "199 Watts", "code": "199" }, { "name": "200 watts", "code": "200" }, { "name": "204 Watts", "code": "204" }, { "name": "213 Watts", "code": "213" }, { "name": "215 watts", "code": "215" }, { "name": "230 Watts", "code": "230" }, { "name": "24 Watts", "code": "24" }, { "name": "244 Watts", "code": "244" }, { "name": "25 Watts", "code": "25" }, { "name": "250 watts", "code": "250" }, { "name": "252 watts", "code": "252" }, { "name": "26 Watts", "code": "26" }, { "name": "268 Watts", "code": "268" }, { "name": "275 Watts", "code": "275" }, { "name": "276 watts", "code": "276" }, { "name": "28 Watts", "code": "28" }, { "name": "280 Watts", "code": "280" }, { "name": "284 watts", "code": "284" }, { "name": "307 Watts", "code": "307" }, { "name": "32 Watts", "code": "32" }, { "name": "35 Watts", "code": "35" }, { "name": "36 Watts", "code": "36" }, { "name": "40 Watts", "code": "40" }, { "name": "400 watts", "code": "400" }, { "name": "43 watts", "code": "43" }, { "name": "45 Watts", "code": "45" }, { "name": "47 Watts", "code": "47" }, { "name": "48 Watts", "code": "48" }, { "name": "50 Watts", "code": "50" }, { "name": "51 Watts", "code": "51" }, { "name": "52 Watts", "code": "52" }, { "name": "53 watts", "code": "53" }, { "name": "54 Watts", "code": "54" }, { "name": "55 Watts", "code": "55" }, { "name": "56 Watts", "code": "56" }, { "name": "57 Watts", "code": "57" }, { "name": "59 Watts", "code": "59" }, { "name": "60 Watts", "code": "60" }, { "name": "65 watts", "code": "65" }, { "name": "67 Watts", "code": "67" }, { "name": "68 Watts", "code": "68" }, { "name": "69 Watts", "code": "69" }, { "name": "70 watts", "code": "70" }, { "name": "71 Watts", "code": "71" }, { "name": "72 Watts", "code": "72" }, { "name": "73 watts", "code": "73" }, { "name": "75 Watts", "code": "75" }, { "name": "77 Watts", "code": "77" }, { "name": "78 Watts", "code": "78" }, { "name": "79 Watts", "code": "79" }, { "name": "80 Watts", "code": "80" }, { "name": "83 watts", "code": "83" }, { "name": "84 Watts", "code": "84" }, { "name": "85 Watts", "code": "85" }, { "name": "87 watts", "code": "87" }, { "name": "88 Watts", "code": "88" }, { "name": "90 watts", "code": "90" }, { "name": "91 watts", "code": "91" }, { "name": "92 Watts", "code": "92" }, { "name": "95 Watts", "code": "95" }, { "name": "N/A", "code": "N/A" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UKN" }, { "name": "66 Watts", "code": "66" }, { "name": "44 Watts", "code": "44" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 1073741822, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": { "type": "codedValue", "name": "FixtureManufacturer", "description": "Fixture Manufacturer", "codedValues": [ { "name": "American Electric Lighting", "code": "American Electric Lighting" }, { "name": "Cooper Lighting", "code": "Cooper Lighting" }, { "name": "Cree", "code": "Cree" }, { "name": "Eaton/Cooper", "code": "Eaton/Cooper" }, { "name": "GE Lighting Solutions", "code": "GE Lighting Solutions" }, { "name": "Holophane", "code": "Holophane" }, { "name": "LED Roadway Lighting", "code": "LED Roadway Lighting" }, { "name": "Lithonia", "code": "Lithonia" }, { "name": "Philips Lumec", "code": "Philips Lumec" }, { "name": "Quattro", "code": "Quattro" }, { "name": "RUDD", "code": "RUDD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CorrelatedColourTemperature", "type": "esriFieldTypeSmallInteger", "alias": "CorrelatedColourTemperature", "domain": { "type": "codedValue", "name": "CCT", "description": "Correlated Colour Temperature Specification", "codedValues": [ { "name": "3000 K", "code": 3000 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LampBase", "type": "esriFieldTypeString", "alias": "Lamp Base", "length": 255, "domain": { "type": "codedValue", "name": "StreetLighting_LampBase", "description": "Street Lighting - Lamp Base", "codedValues": [ { "name": "Mogul", "code": "Mogul" }, { "name": "Medium", "code": "Medium" }, { "name": "Long", "code": "Long" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R1474_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1859GIS_ID", "fields": "GIS_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "StreetLight Features", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "GIS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{29609916-B90D-40B8-958D-9FC6E0CC190C}" } ], "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "ProdGeoDB.STREETLIGHTS.StreetLighting_Poles", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "GIS_FeatureKey", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GIS_ID", "type": "esriFieldTypeInteger", "alias": "Streetlight GIS ID", "domain": null }, { "name": "GIS_FeatureKey", "type": "esriFieldTypeString", "alias": "Unique Pole ID", "length": 20, "domain": null }, { "name": "PoleLength", "type": "esriFieldTypeString", "alias": "Length", "length": 4, "domain": { "type": "codedValue", "name": "StreetLighting_PoleLength", "description": "Street Lighting - Pole Length", "codedValues": [ { "name": "4.6 m (15 ft)", "code": "15" }, { "name": "5.5 m (18 ft)", "code": "18" }, { "name": "5.6m (18.5 ft)", "code": "18.5" }, { "name": "5.8m (19 ft)", "code": "19" }, { "name": "6.0 m (19.5 ft)", "code": "19.5" }, { "name": "6.1m (20 ft)", "code": "20" }, { "name": "6.6m (21.5 ft)", "code": "21.5" }, { "name": "6.7m (22 ft)", "code": "22" }, { "name": "6.9 m (22.5 ft)", "code": "22.5" }, { "name": "7.3 m (24 ft)", "code": "24" }, { "name": "7.6 m (25 ft)", "code": "25" }, { "name": "8.4 m (27.5 ft)", "code": "27.5" }, { "name": "9.1m (30 ft)", "code": "30" }, { "name": "9.8m (32 ft)", "code": "32" }, { "name": "9.9 m (32.5 ft)", "code": "32.5" }, { "name": "10 m (33 ft)", "code": "33" }, { "name": "10.7 m (35 ft)", "code": "35" }, { "name": "11.4 m (37.5 ft)", "code": "37.5" }, { "name": "11.6 m (38 ft)", "code": "38" }, { "name": "12.2 m (40 ft)", "code": "40" }, { "name": "6.4m (20.5 ft)", "code": "6.4" }, { "name": "7.9 m (26 ft)", "code": "7.9" }, { "name": "2.7 m (9 ft)", "code": "9" }, { "name": "N/A", "code": "N/A" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleMaterial", "type": "esriFieldTypeString", "alias": "Material", "length": 8, "domain": { "type": "codedValue", "name": "StreetLighting_PoleMaterial", "description": "Street Lighting - Pole Material", "codedValues": [ { "name": "Other", "code": "Other" }, { "name": "Aluminum", "code": "Aluminum" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Steel", "code": "Steel" }, { "name": "Wood", "code": "Wood" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleFoundation", "type": "esriFieldTypeString", "alias": "Foundation", "length": 13, "domain": { "type": "codedValue", "name": "StreetLighting_PoleFoundation", "description": "Street Lighting - Pole Foundation", "codedValues": [ { "name": "Concrete", "code": "Concrete" }, { "name": "Direct Buried", "code": "Direct Buried" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleStyle", "type": "esriFieldTypeString", "alias": "Style", "length": 14, "domain": { "type": "codedValue", "name": "StreetLighting_PoleStyle", "description": "Street Lighting - Pole Style", "codedValues": [ { "name": "Other", "code": "Other" }, { "name": "Decorative", "code": "D" }, { "name": "Non-Decorative", "code": "ND" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleColour", "type": "esriFieldTypeString", "alias": "Colour", "length": 25, "domain": { "type": "codedValue", "name": "StreetLighting_Colour", "description": "Street Lighting - Colour", "codedValues": [ { "name": "Other", "code": "Other" }, { "name": "Black", "code": "Black" }, { "name": "Green", "code": "Green" }, { "name": "Grey", "code": "Grey" }, { "name": "N/A", "code": "N/A" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleUse", "type": "esriFieldTypeString", "alias": "Use", "length": 4, "domain": { "type": "codedValue", "name": "StreetLighting_PoleUse", "description": "Street Lighting - Pole Use", "codedValues": [ { "name": "Single Use", "code": "SU" }, { "name": "Joint Use - Traffic", "code": "JU-T" }, { "name": "Joint Use - Hydro", "code": "JU-H" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HeadCount", "type": "esriFieldTypeInteger", "alias": "Head Count", "domain": { "type": "codedValue", "name": "StreetLighting_HeadCount", "description": "Street Lighting - Head Count", "codedValues": [ { "name": "1 Head", "code": 1 }, { "name": "2 Heads", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FeedSubtype", "type": "esriFieldTypeString", "alias": "Feed Type", "length": 7, "domain": { "type": "codedValue", "name": "StreetLighting_Feedtype", "description": "Street Lighting - Feed type", "codedValues": [ { "name": "Underground Feed", "code": "UGF" }, { "name": "Overhead Feed", "code": "OHF" }, { "name": "N/A", "code": "N/A" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1073741822, "domain": null } ], "indexes": [ { "name": "R1471_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1856GIS_ID", "fields": "GIS_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "StreetLight Features", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "GIS_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{64108B9E-15CA-4BCF-B46C-3556E970B9F3}" } ], "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }