{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 20, "name": "Lights", "type": "Feature Layer", "parentLayer": { "id": 19, "name": "Lights & Fiber" }, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 70, "name": "sde.sde.workorder__task", "relatedTableId": 33, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "globalid", "composite": false, "catalogID": "{3D3AF772-C350-41D2-AE28-8F0EB455033C}" }, { "id": 71, "name": "sde.sde.workorder__task", "relatedTableId": 34, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "globalid", "composite": false, "catalogID": "{3D3AF772-C350-41D2-AE28-8F0EB455033C}" }, { "id": 72, "name": "sde.sde.workorder__task", "relatedTableId": 42, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "globalid", "composite": false, "catalogID": "{3D3AF772-C350-41D2-AE28-8F0EB455033C}" }, { "id": 73, "name": "sde.ags.tbl_media5", "relatedTableId": 59, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "globalid", "composite": false, "catalogID": "{CB849B1F-1910-4ABE-A714-3163B040306A}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "extent": { "xmin": 501182.2110000001, "ymin": 4977280.5888, "xmax": 505226.12590000033, "ymax": 4986614.017200001, "spatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "spatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "sourceSpatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "bbd6ea43f3960a30e61a8dc7fa65026b", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABcAAAAkCAYAAABixKGjAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEKklEQVRIie2VW2hcVRSG/73PmWtuJXYw1miUaAu2paUBpZq2wVtS0EZLRkEoimLBPvnggyCBgEKhKFhRUEtNFFF0rAarpBXRIY7VYCexzVhvTcWQWpuYyThzbnMue8k50zSZTJuJSUUfXC+z99mzP9b5/7XWkfEPhvyvw7du315vk9SYV3IVqq6kkonEGACxdHhXFxdDqREO8hNxkCPZTTdvfjJ5pP+5JcNbjx+/HOD+2XeI+GMAlg7nNqsTbO5TWlHu3gXht0ejNZJJBwGsd5kCKEEDCDRt3JKd3piS0zCcSEyVhXMTbQCaATC6eFKcgKrpjc+W2wG87r7S/HCGtzgDe/QuHffcYhYfnvUDv9cWPepN5fH0p+prG25qsQcH4m+WwFui0UoZqGW6CBARr60WWHONg4kMLwJRFqBccQWuqfMQDBIeb2pu7nc3hiynv4vHFe8kaLG7CWIvJObpm1E5OrsrSrTQFR2acl7q4iDaQI501F36HfEEgDc8uGBsGAJ7ONH1XGY72240seIygVcOBhH0Ex5szXv37TRgpYNIawLd3xi4c6Ufa6+Q8UJCg+WAMbA93h+F/O15WT754J0UgFTbtugqEO1c3WCjZb2FfR8HQQTc25yfpXkAQ6dt9Bw1sG11ABsbfNj7heYdJ7+KP3tRQ41sxa+BGgXPHwjh1Y9Cnvd5i+GBZ6q9c03RoSsZ6BZ59dl5SIXEAbtgw/BcpYrgkYhqZU3AMBmMWYWSzhVKXVMBVZ0xdEovMvfkvPBYLCZa2zsQChCiW0ykfpEw+LOMh7caCPldvRly42G8PWTg6mUSbrvOB9UCXvpSA4F+nBfues4AYdqM10cc3NBg49iIjFVXOVjXaHuaHxuUsX+AsKMpiE3X+tB/yvIu+jg/UA7uGjgpBCJjExyb1loIBwln0hzrGgvnv2UF8jahrqrQA6MZx+sA8rGxsnAw+oyI3f/1CR86NptYWe9g4IQPdzSZkAD0nzI9A+trOAQB8RHTNT4ucrnJsnDG2A9u+WUUBlkmr96/H5Wg5xkqAZw516F+iUHJEyYUb7T9lEwm7bJwB3avxOTO8QznHV3VsB0GywZ27K6CoeqYmCowbn15Cg4BhkVAQe+SOVc6uDg/SwLuK0Y0Y2bauplrec8TLxRzhiWZ4nSJvBeCV0vS5J+Os4uBLwuHw/vmSAbuds25EEIcUVW1Z/nyivEFwWOxmNs+70WjUYn7/UVwIQRoOvVCnJQsrbuvr89eEPxSxrxwIngZMXdaT3/uCO5gcYvbDWdR8FgsJu576JGou9ZU7UUiXKlpGnRdHw+Hw09JPmmScXk0Ho87i8mc3u3Z3+suWts7dru/lmnBNPKa0MzDAwPxko78O/Alx//w/6osJHYRY5UkCAJcC4Xoj0sGP/zh+58vKInFwBcbfwEog9SlP6vX2AAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 17, "height": 27, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "objectid", "globalIdField": "globalid", "displayField": "old_id", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "old_id", "type": "esriFieldTypeInteger", "alias": "old_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "old_id" }, { "name": "light_owner", "type": "esriFieldTypeString", "alias": "light_owner", "domain": { "type": "codedValue", "name": "lights_owner", "description": "Street Light Ownership", "codedValues": [ { "name": "City", "code": "City" }, { "name": "County", "code": "County" }, { "name": "MNDOT", "code": "MNDOT" }, { "name": "North St. Paul", "code": "North St. Paul" }, { "name": "Private", "code": "Private" }, { "name": "Xcel", "code": "Xcel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "light_owner" }, { "name": "light_type", "type": "esriFieldTypeString", "alias": "light_type", "domain": { "type": "codedValue", "name": "lights_type", "description": "Street Light Types", "codedValues": [ { "name": "13ft Concrete", "code": "13ft Concrete" }, { "name": "13ft Fiberglass", "code": "13ft Fiberglass" }, { "name": "15ft", "code": "15ft" }, { "name": "25ft Aluminum", "code": "25ft Aluminum" }, { "name": "30ft Aluminum", "code": "30ft Aluminum" }, { "name": "30ft Fiberglass", "code": "30ft Fiberglass" }, { "name": "30ft Steel", "code": "30ft Steel" }, { "name": "City Cobra", "code": "City Cobra" }, { "name": "City Double", "code": "City Double" }, { "name": "Cobra", "code": "Cobra" }, { "name": "core10", "code": "core10" }, { "name": "Field Light", "code": "Field Light" }, { "name": "LED", "code": "LED" }, { "name": "MNDOT Cobra", "code": "MNDOT Cobra" }, { "name": "Private", "code": "Private" }, { "name": "Xcel Cobra", "code": "Xcel Cobra" }, { "name": "Xcel Lantern", "code": "Xcel Lantern" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "light_type" }, { "name": "light_crack_class", "type": "esriFieldTypeString", "alias": "light_crack_class", "domain": { "type": "codedValue", "name": "lights_cracking", "description": "Street Light Cracking Class", "codedValues": [ { "name": "CRACKED", "code": "CRACKED" }, { "name": "NOT CRACKED", "code": "NOT CRACKED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "light_crack_class" }, { "name": "light_nsp_number", "type": "esriFieldTypeDouble", "alias": "light_nsp_number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "light_nsp_number" }, { "name": "light_installed_date", "type": "esriFieldTypeDate", "alias": "light_installed_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "light_installed_date" }, { "name": "light_current_bulb_type", "type": "esriFieldTypeString", "alias": "light_current_bulb_type", "domain": { "type": "codedValue", "name": "lights_bulb_type", "description": "Street Light Bulb Type", "codedValues": [ { "name": "100 HPS", "code": "100 HPS" }, { "name": "150 HPS", "code": "150 HPS" }, { "name": "200 HPS", "code": "200 HPS" }, { "name": "250 HPS", "code": "250 HPS" }, { "name": "400 HPS", "code": "400 HPS" }, { "name": "LED 135w", "code": "LED 135w" }, { "name": "LED 55w", "code": "LED 55w" }, { "name": "LED 60w", "code": "LED 60w" }, { "name": "LED 45w", "code": "LED 45w" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "light_current_bulb_type" }, { "name": "light_current_bulb_maintainer", "type": "esriFieldTypeString", "alias": "light_current_bulb_maintainer", "domain": { "type": "codedValue", "name": "lights_bulb_maintainer", "description": "Street Light Bult Maintainer", "codedValues": [ { "name": "City", "code": "City" }, { "name": "County", "code": "County" }, { "name": "Lake Elmo", "code": "Lake Elmo" }, { "name": "Maplewood", "code": "Maplewood" }, { "name": "MNDOT", "code": "MNDOT" }, { "name": "North St. Paul", "code": "North St. Paul" }, { "name": "Private", "code": "Private" }, { "name": "Ramsey County", "code": "Ramsey County" }, { "name": "Xcel", "code": "Xcel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "light_current_bulb_maintainer" }, { "name": "originaloid", "type": "esriFieldTypeInteger", "alias": "OriginalOID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "originaloid" }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "globalid" }, { "name": "asset_id", "type": "esriFieldTypeString", "alias": "asset_id", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "asset_id" }, { "name": "asset_status", "type": "esriFieldTypeString", "alias": "asset_status", "domain": { "type": "codedValue", "name": "asset_status", "description": "Active Abandoned Retire(Delete)", "codedValues": [ { "name": "Active", "code": "1" }, { "name": "Retired_Needs_Delete", "code": "3" }, { "name": "Abandoned", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "asset_status" }, { "name": "asbuilt", "type": "esriFieldTypeString", "alias": "asbuilt", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "asbuilt" }, { "name": "source", "type": "esriFieldTypeString", "alias": "source", "domain": { "type": "codedValue", "name": "source", "description": "Source used for GIS Edits", "codedValues": [ { "name": "Asbuilt", "code": "1" }, { "name": "Field Edit", "code": "2" }, { "name": "GPS", "code": "3" }, { "name": "Digitized", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "source" }, { "name": "source_date", "type": "esriFieldTypeDate", "alias": "source_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "source_date" }, { "name": "gis_reviewed", "type": "esriFieldTypeString", "alias": "gis_reviewed", "domain": { "type": "codedValue", "name": "yes or no", "description": "Yes or No", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "gis_reviewed" }, { "name": "gis_reviewed_date", "type": "esriFieldTypeDate", "alias": "gis_reviewed_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "gis_reviewed_date" }, { "name": "notes", "type": "esriFieldTypeString", "alias": "notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "notes" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "shape" }, "indexes": [ { "name": "index_71", "isAscending": true, "isUnique": true, "description": "", "fields": "globalid" }, { "name": "r95_sde_rowid_uk", "isAscending": true, "isUnique": true, "description": "", "fields": "objectid" }, { "name": "a76_ix1", "isAscending": true, "isUnique": true, "description": "", "fields": "shape" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Lights", "description": "", "prototype": { "attributes": { "gis_reviewed_date": null, "notes": null, "old_id": null, "light_owner": null, "light_type": null, "light_crack_class": null, "light_nsp_number": null, "light_installed_date": null, "light_current_bulb_type": null, "light_current_bulb_maintainer": null, "originaloid": null, "gis_reviewed": null, "asset_id": null, "asset_status": null, "asbuilt": null, "source": null, "source_date": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "5dabca1d632c4527b975c832db5519c6" }