{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "NanaimoSDE.SIGNAGE.Streetlight", "type": "Feature Layer", "description": "

Spatial representation of city owned streetlight poles across the City. Used in Cityworks to track sticker installs, or graffiti clean up by Traffic Unit. Used in Cityworks by PW Dispatch to track service requests for repairs by contractors.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 26910, "latestWkid": 26910, "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": "esriSMS", "style": "esriSMSCircle", "color": [ 173, 58, 133, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 423025.1261999998, "ymin": 5439114.432600001, "xmax": 436907.8411999997, "ymax": 5455542.2502, "spatialReference": { "wkid": 26910, "latestWkid": 26910, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "StLightAssetID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "StLightAssetID", "type": "esriFieldTypeString", "alias": "StLightAssetID", "length": 50, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "sgnStatus", "description": "Status of sign and pole", "codedValues": [ { "name": "Active", "code": "ACTIVE" }, { "name": "Pending", "code": "PENDING" }, { "name": "Removed", "code": "REMOVED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "length": 50, "domain": { "type": "codedValue", "name": "sgnOwner", "description": "Owner of signage assets", "codedValues": [ { "name": "City of Nanaimo", "code": "CITY" }, { "name": "Ministry of Transportation", "code": "MOT" }, { "name": "Nanaimo Port Authority", "code": "NPA" }, { "name": "Parks, Recreation and Culture", "code": "PRC" }, { "name": "Private", "code": "PRIVATE" }, { "name": "Regional District of Nanaimo", "code": "RDN" }, { "name": "Unknown", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleType", "type": "esriFieldTypeString", "alias": "PoleType", "length": 50, "domain": { "type": "codedValue", "name": "sgnStreetlightPoleType", "description": "City Streetlight Pole Types", "codedValues": [ { "name": "Cobra / Galvanized", "code": "COG" }, { "name": "Cobra / Painted", "code": "COP" }, { "name": "Heritage Cobra / Painted", "code": "HCP" }, { "name": "Heritage Post Top / Painted", "code": "HPP" }, { "name": "Marine Style Painted", "code": "MSP" }, { "name": "Post Top / Galvanized", "code": "POG" }, { "name": "Post Top / Painted", "code": "POT" }, { "name": "Unknown", "code": "UN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LuminaireType", "type": "esriFieldTypeString", "alias": "LuminaireType", "length": 50, "domain": { "type": "codedValue", "name": "sgnLuminaireType", "description": "City Streetlight Luminare Types", "codedValues": [ { "name": "Drop Glass / Cobra", "code": "DGC" }, { "name": "Flat Glass / Cobra", "code": "FGC" }, { "name": "Globe", "code": "GLO" }, { "name": "Heritage", "code": "HER" }, { "name": "Lantern", "code": "LAN" }, { "name": "Marine Style", "code": "MSP" }, { "name": "Top Hat", "code": "TOP" }, { "name": "Unknown", "code": "UN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LampType", "type": "esriFieldTypeString", "alias": "LampType", "length": 50, "domain": { "type": "codedValue", "name": "sgnLampType", "description": "City Streetlight Lamp Types", "codedValues": [ { "name": "High Pressure Sodium", "code": "HPS" }, { "name": "Incandescent", "code": "I" }, { "name": "LED", "code": "LED" }, { "name": "Metal Halide", "code": "MH" }, { "name": "Mercury Vapour", "code": "MU" }, { "name": "Unknown", "code": "UN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Wattage", "type": "esriFieldTypeSmallInteger", "alias": "Wattage", "domain": null }, { "name": "Height", "type": "esriFieldTypeDouble", "alias": "Height", "domain": null }, { "name": "Asbuilt", "type": "esriFieldTypeInteger", "alias": "Asbuilt", "domain": null }, { "name": "Dual", "type": "esriFieldTypeString", "alias": "Dual", "length": 5, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "RemovalDate", "type": "esriFieldTypeDate", "alias": "RemovalDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionScore", "type": "esriFieldTypeInteger", "alias": "ConditionScore", "domain": null }, { "name": "ConditionPass", "type": "esriFieldTypeString", "alias": "ConditionPass", "length": 10, "domain": null }, { "name": "Neighbourhood", "type": "esriFieldTypeString", "alias": "Neighbourhood", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 100, "domain": null }, { "name": "H_PoleID", "type": "esriFieldTypeString", "alias": "H_PoleID", "length": 50, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "ReplacedDate", "type": "esriFieldTypeSmallInteger", "alias": "Replaced Date", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_SHAPE", "fields": "SHAPE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Streetlight_LED_Info", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "StLightAssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "NanaimoSDE.SIGNAGE.Streetlight_LED_Info", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "StLightAssetID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "StLightAssetID", "type": "esriFieldTypeString", "alias": "StLightAssetID", "length": 50, "domain": null }, { "name": "H_PoleID", "type": "esriFieldTypeString", "alias": "H_PoleID", "length": 50, "domain": null }, { "name": "LIGHTID", "type": "esriFieldTypeInteger", "alias": "LIGHTID", "domain": null }, { "name": "poleid", "type": "esriFieldTypeInteger", "alias": "poleid", "domain": null }, { "name": "servicevoltage", "type": "esriFieldTypeString", "alias": "servicevoltage", "length": 5, "domain": null }, { "name": "luminairebrand", "type": "esriFieldTypeString", "alias": "luminairebrand", "length": 50, "domain": null }, { "name": "luminaireinstalldate", "type": "esriFieldTypeDate", "alias": "luminaireinstalldate", "length": 8, "domain": null }, { "name": "wiringinstalldate", "type": "esriFieldTypeDate", "alias": "wiringinstalldate", "length": 8, "domain": null }, { "name": "fusetype", "type": "esriFieldTypeString", "alias": "fusetype", "length": 50, "domain": null }, { "name": "wiringcoverreplacedate", "type": "esriFieldTypeDate", "alias": "wiringcoverreplacedate", "length": 8, "domain": null }, { "name": "partnumber", "type": "esriFieldTypeString", "alias": "partnumber", "length": 100, "domain": null }, { "name": "Phase", "type": "esriFieldTypeString", "alias": "Phase", "length": 50, "domain": null }, { "name": "dualsingle", "type": "esriFieldTypeString", "alias": "dualsingle", "length": 50, "domain": null }, { "name": "poleheight", "type": "esriFieldTypeDouble", "alias": "poleheight", "domain": null }, { "name": "poleclassification", "type": "esriFieldTypeString", "alias": "poleclassification", "length": 50, "domain": null }, { "name": "poleinstallyear", "type": "esriFieldTypeInteger", "alias": "poleinstallyear", "domain": null }, { "name": "luminairetype", "type": "esriFieldTypeString", "alias": "luminairetype", "length": 50, "domain": null }, { "name": "luminairecolourtemp", "type": "esriFieldTypeString", "alias": "luminairecolourtemp", "length": 5, "domain": null }, { "name": "NANGID", "type": "esriFieldTypeGUID", "alias": "NANGID", "length": 38, "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 50, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 50, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_globalid", "fields": "globalid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Streetlight", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "StLightAssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }