{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 7, "name": "PW_Streetlights", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "Streetlight poles as located by Siemens and delivered to the city on 10/1/2019. Data was joined to existing PW_Streetlight_Poles layer (from APS) and fields containing links to asset photographs were brought over.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "extent": { "xmin": 412464.7880577445, "ymin": 592426.8700787425, "xmax": 486388.7906824164, "ymax": 629900.787073493, "spatialReference": { "wkid": 2224, "latestWkid": 2224, "xyTolerance": 0.0032808398950131233, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17747400, "falseY": -44068800, "xyUnits": 3048, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 2224, "latestWkid": 2224, "xyTolerance": 0.0032808398950131233, "zTolerance": 2, "mTolerance": 2, "falseX": -17747400, "falseY": -44068800, "xyUnits": 3048, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 101, 53, 173, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "StreetName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Num", "type": "esriFieldTypeDouble", "alias": "Num", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Num" }, { "name": "LightType", "type": "esriFieldTypeString", "alias": "LightType", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LightType" }, { "name": "DualHead", "type": "esriFieldTypeString", "alias": "DualHead", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DualHead" }, { "name": "PostWattage", "type": "esriFieldTypeDouble", "alias": "PostWattage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PostWattage" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Description" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Address" }, { "name": "StreetName", "type": "esriFieldTypeString", "alias": "StreetName", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "StreetName" }, { "name": "APSPoleNum", "type": "esriFieldTypeString", "alias": "APSPoleNum", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "APSPoleNum" }, { "name": "PoleNumTBA", "type": "esriFieldTypeString", "alias": "PoleNumTBA", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoleNumTBA" }, { "name": "PoleNumOnPole", "type": "esriFieldTypeString", "alias": "PoleNumOnPole", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoleNumOnPole" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "InstallationNotes", "type": "esriFieldTypeString", "alias": "InstallationNotes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "InstallationNotes" }, { "name": "Voltage", "type": "esriFieldTypeString", "alias": "Voltage", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Voltage" }, { "name": "IndexNum", "type": "esriFieldTypeDouble", "alias": "IndexNum", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IndexNum" }, { "name": "Zone_", "type": "esriFieldTypeDouble", "alias": "Zone_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Zone_" }, { "name": "MapPage", "type": "esriFieldTypeString", "alias": "MapPage", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MapPage" }, { "name": "LampType", "type": "esriFieldTypeString", "alias": "LampType", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LampType" }, { "name": "PoleType", "type": "esriFieldTypeString", "alias": "PoleType", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoleType" }, { "name": "FoundationType", "type": "esriFieldTypeString", "alias": "FoundationType", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FoundationType" }, { "name": "PoleHeight", "type": "esriFieldTypeDouble", "alias": "PoleHeight", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PoleHeight" }, { "name": "ArmLength", "type": "esriFieldTypeDouble", "alias": "ArmLength", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ArmLength" }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Owner" }, { "name": "Subdivision", "type": "esriFieldTypeString", "alias": "Subdivision", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Subdivision" }, { "name": "FunctionalClass", "type": "esriFieldTypeString", "alias": "FunctionalClass", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FunctionalClass" }, { "name": "Ycoordinate", "type": "esriFieldTypeDouble", "alias": "Ycoordinate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Ycoordinate" }, { "name": "Xcoordinate", "type": "esriFieldTypeDouble", "alias": "Xcoordinate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Xcoordinate" }, { "name": "CityLightID", "type": "esriFieldTypeString", "alias": "CityLightID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CityLightID" }, { "name": "CityPoleID", "type": "esriFieldTypeString", "alias": "CityPoleID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CityPoleID" }, { "name": "CityAddress", "type": "esriFieldTypeString", "alias": "CityAddress", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CityAddress" }, { "name": "CityEquipment", "type": "esriFieldTypeString", "alias": "CityEquipment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CityEquipment" }, { "name": "FunctionalClass20180919", "type": "esriFieldTypeString", "alias": "FunctionalClass20180919", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FunctionalClass20180919" }, { "name": "F46", "type": "esriFieldTypeString", "alias": "F46", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "F46" }, { "name": "F47", "type": "esriFieldTypeString", "alias": "F47", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "F47" }, { "name": "F48", "type": "esriFieldTypeString", "alias": "F48", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "F48" }, { "name": "F49", "type": "esriFieldTypeString", "alias": "F49", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "F49" }, { "name": "F50", "type": "esriFieldTypeString", "alias": "F50", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "F50" }, { "name": "CityPoleID_1", "type": "esriFieldTypeString", "alias": "CityPoleID_1", "domain": null, "editable": true, "nullable": true, "length": 2048, "defaultValue": null, "modelName": "CityPoleID" }, { "name": "PicturePoleBase", "type": "esriFieldTypeString", "alias": "PicturePoleBase", "domain": null, "editable": true, "nullable": true, "length": 2048, "defaultValue": null, "modelName": "PicturePoleBase" }, { "name": "PicturePoleNumber", "type": "esriFieldTypeString", "alias": "PicturePoleNumber", "domain": null, "editable": true, "nullable": true, "length": 2048, "defaultValue": null, "modelName": "PicturePoleNumber" }, { "name": "General", "type": "esriFieldTypeString", "alias": "General", "domain": null, "editable": true, "nullable": true, "length": 2048, "defaultValue": null, "modelName": "General" }, { "name": "LucityAutoID", "type": "esriFieldTypeInteger", "alias": "Link to Lucity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LucityAutoID" }, { "name": "InLucity", "type": "esriFieldTypeSmallInteger", "alias": "In Lucity?", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "InLucity" }, { "name": "LastModBy", "type": "esriFieldTypeString", "alias": "Last Modified By", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "LastModBy" }, { "name": "LastModDate", "type": "esriFieldTypeDate", "alias": "Last Modified Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastModDate" }, { "name": "LastSynDate", "type": "esriFieldTypeDate", "alias": "Last Synchronized Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastSynDate" }, { "name": "AltPoleID", "type": "esriFieldTypeString", "alias": "Alt Pole ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PL_NUM" }, { "name": "LightID", "type": "esriFieldTypeString", "alias": "Streetlight AltID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LightID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 50, "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": 50, "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": "R3098_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_3098", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S2420_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PW_Streetlights", "description": "", "prototype": { "attributes": { "ArmLength": null, "LucityAutoID": null, "LightID": null, "Num": null, "LightType": null, "DualHead": null, "PostWattage": null, "Description": null, "Address": null, "StreetName": null, "APSPoleNum": null, "PoleNumTBA": null, "PoleNumOnPole": null, "InstallationDate": null, "InstallationNotes": null, "Voltage": null, "IndexNum": null, "Zone_": null, "MapPage": null, "LampType": null, "PoleType": null, "FoundationType": null, "PoleHeight": null, "Owner": "City of Yuma", "Subdivision": null, "FunctionalClass": null, "Ycoordinate": null, "Xcoordinate": null, "CityLightID": null, "CityPoleID": null, "CityAddress": null, "CityEquipment": null, "FunctionalClass20180919": null, "F46": null, "F47": null, "F48": null, "F49": null, "F50": null, "CityPoleID_1": null, "PicturePoleBase": null, "PicturePoleNumber": null, "General": null, "InLucity": 1, "LastModBy": null, "LastModDate": null, "LastSynDate": null, "AltPoleID": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "a46a691a550e4153a7a0d7f24582b399" }