{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 5, "name": "Street Lights", "type": "Feature Layer", "description": "This dataset contains street lights for the City of McKinney, Texas. It's updated with data collected in the field for street lights maintained by the City of McKinney and also with data provided by CoServ, GCEC and Oncor. Oncor didn't provide their data for 2021 so any Oncor data in this layer is not current.Contact information:GCEC: Vic McTeeGrayson Collin Electric Cooperative903.482.7130vmctee@gcec.netCoServ:Donna Wood, CKAECOMMUNITY SUPPORT SPECIALIST| Community EngagementO (940) 270-6816 | M (469) 261-9944 7701 S Stemmons, Corinth, TX 76210dwood@coserv.comOncor:Paul Hernandez Area Manager OncorPaul.Hernandez@oncor.comLast updated: 5/5/2021Update frequency: As needed", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 5.120000004768374E-4, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -1.234076999999192E8, "falseY": -8.612349999993451E7, "xyUnits": 15624.999985448077, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "Created and maintained by the City of McKinney Public Works Department, Streets Division.", "parentLayer": { "id": 15, "name": "Transportation" }, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 66, 145, 144, 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": false, "extent": { "xmin": 2498373.0207000226, "ymin": 7098719.0630774945, "xmax": 2568104.264732957, "ymax": 7153405.342872426, "spatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 5.120000004768374E-4, "zTolerance": 2.0E-5, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3.592069011000888E7, "falseZ": 0, "zUnits": 99999.99999999999, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "LightPoleStyle", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "LightPoleStyle", "type": "esriFieldTypeString", "alias": "Light Pole Style", "length": 50, "domain": { "type": "codedValue", "name": "StreetLightPoleStyle", "description": "Street Light Pole Style", "codedValues": [ { "name": "Cobra Head", "code": "1" }, { "name": "Decorative", "code": "2" }, { "name": "McKinney Standard", "code": "3" }, { "name": "Shoebox", "code": "4" }, { "name": "High Mast", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LightPoleMaterial", "type": "esriFieldTypeString", "alias": "Light Pole Material", "length": 20, "domain": { "type": "codedValue", "name": "StreetLightPoleMaterial", "description": "Street Light Pole Material", "codedValues": [ { "name": "Decorative", "code": "1" }, { "name": "Galvanized Steel", "code": "2" }, { "name": "Wood", "code": "3" }, { "name": "Black Powder-Coated Steel", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BulbType", "type": "esriFieldTypeString", "alias": "Bulb Type", "length": 50, "domain": { "type": "codedValue", "name": "StreetLightsBulbType", "description": "Street Light Bulb Type", "codedValues": [ { "name": "High-Pressure Sodium (HPS)", "code": "1" }, { "name": "Hetal-Halide (MH)", "code": "2" }, { "name": "Mercury-Vapor (MV)", "code": "3" }, { "name": "LED", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LightPoleVoltage", "type": "esriFieldTypeString", "alias": "Light Pole Voltage", "length": 50, "domain": { "type": "codedValue", "name": "StreetLightPoleVoltage", "description": "Street Light Pole Voltage", "codedValues": [ { "name": "120/240", "code": "1" }, { "name": "480", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BulbWattage", "type": "esriFieldTypeInteger", "alias": "Bulb Wattage", "domain": null }, { "name": "NumberOfFixtures", "type": "esriFieldTypeString", "alias": "Number of Fixtures", "length": 50, "domain": { "type": "codedValue", "name": "StreetLightFixtureNumber", "description": "Street Light Fixture Number", "codedValues": [ { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "6", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "Installation Date", "length": 8, "domain": null }, { "name": "ElectricProvider", "type": "esriFieldTypeString", "alias": "Electric Provider", "length": 50, "domain": { "type": "codedValue", "name": "StreetLightElectricProvider", "description": "Street Light Electric Provider", "codedValues": [ { "name": "CoServ", "code": "1" }, { "name": "GCEC", "code": "2" }, { "name": "Oncor", "code": "3" }, { "name": "Solar", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintenanceResponsibility", "type": "esriFieldTypeString", "alias": "Maintenance Responsibility", "length": 30, "domain": { "type": "codedValue", "name": "StreetLightMaintenanceResponsibility", "description": "Street Light Maintenance Responsibility", "codedValues": [ { "name": "CoServ", "code": "1" }, { "name": "GCEC", "code": "2" }, { "name": "Oncor", "code": "3" }, { "name": "City - Building Maintenance", "code": "4" }, { "name": "City - Traffic", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FixtureType", "type": "esriFieldTypeString", "alias": "Fixture Type", "length": 50, "domain": null }, { "name": "ColorTemperature", "type": "esriFieldTypeString", "alias": "Color Temperature", "length": 50, "domain": { "type": "codedValue", "name": "StreetLightColorTemperature", "description": "Street Light Color Temperature", "codedValues": [ { "name": "3000K", "code": "1" }, { "name": "4000K", "code": "2" }, { "name": "5000K", "code": "3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleColor", "type": "esriFieldTypeString", "alias": "Pole Color", "length": 50, "domain": { "type": "codedValue", "name": "StreetLightPoleColorType", "description": "Street Light Pole Color Types", "codedValues": [ { "name": "Black", "code": "1" }, { "name": "Bronze/Brown", "code": "2" }, { "name": "Green", "code": "3" }, { "name": "Black & Green", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleHeight", "type": "esriFieldTypeString", "alias": "Pole Height (ft)", "length": 50, "domain": null }, { "name": "Verified", "type": "esriFieldTypeString", "alias": "Verified", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Point Creator", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Point Creation Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Point Editor", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Point Edit Date", "length": 8, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "LifeCycle", "type": "esriFieldTypeString", "alias": "Light Pole Status", "length": 50, "domain": { "type": "codedValue", "name": "LifeCycle", "description": "Life Cycle", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Proposed", "code": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "AssociatedMeter", "type": "esriFieldTypeString", "alias": "Associated Meter", "length": 255, "domain": null }, { "name": "AdditionalNotes", "type": "esriFieldTypeString", "alias": "Additional Notes", "length": 60, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "PoleTagCode", "type": "esriFieldTypeString", "alias": "PoleTagCode", "length": 255, "domain": { "type": "codedValue", "name": "StreetLightPoleTagCodes", "description": "Street Light Pole Tag Codes", "codedValues": [ { "name": "ARPT", "code": "AirportDr" }, { "name": "ALMA", "code": "AlmaRd" }, { "name": "BLMD", "code": "BloomdaleRd" }, { "name": "BRAY", "code": "BrayCentralDr" }, { "name": "CNTR", "code": "CentralCir" }, { "name": "NCXW", "code": "CentralExpwy" }, { "name": "CHUR", "code": "ChurchSt" }, { "name": "CMCP", "code": "CollinMcKiPkwy" }, { "name": "CMMR", "code": "CommerceDr" }, { "name": "CMTY", "code": "CommunityAve" }, { "name": "CORP", "code": "CorporateDr" }, { "name": "CGHP", "code": "CoughlinPkwy" }, { "name": "CRGD", "code": "CraigDr" }, { "name": "CRPW", "code": "CraigRanchPkwy" }, { "name": "CUST", "code": "CusterRd" }, { "name": "DAVS", "code": "DavisSt" }, { "name": "ELDR", "code": "EldoradoDr" }, { "name": "ELMS", "code": "ElmSt" }, { "name": "FRSC", "code": "FriscoRd" }, { "name": "GATE", "code": "GatewayBlvd" }, { "name": "GLEN", "code": "GlenOaksDr" }, { "name": "GRVS", "code": "GravesSt" }, { "name": "HRDN", "code": "HardinBlvd" }, { "name": "HMCK", "code": "HarryMcKillopBlvd" }, { "name": "HENN", "code": "HennemanWay" }, { "name": "HRTB", "code": "HeritageBlvd" }, { "name": "HRTD", "code": "HeritageDr" }, { "name": "HERN", "code": "HerndonSt" }, { "name": "HDXN", "code": "HudsonXing" }, { "name": "HUNT", "code": "HuntSt" }, { "name": "INDP", "code": "IndependencePkwy" }, { "name": "INDS", "code": "IndustrialBlvd" }, { "name": "KENT", "code": "KentuckySt" }, { "name": "LFDR", "code": "LakeForestDr" }, { "name": "LHPW", "code": "LaudHowellPkwy" }, { "name": "LOUS", "code": "LouisianaSt" }, { "name": "MRKT", "code": "MarketplaceDr" }, { "name": "MCDN", "code": "McDonaldSt" }, { "name": "MCPL", "code": "McKPlaceDr" }, { "name": "MRPW", "code": "McKRanchPkwy" }, { "name": "MDCL", "code": "MedicalCenterDr" }, { "name": "PKVW", "code": "ParkViewAve" }, { "name": "PRSN", "code": "PearsonAve" }, { "name": "RDBD", "code": "RedbudBlvd" }, { "name": "RIDG", "code": "RidgeRd" }, { "name": "ROCK", "code": "RockhillRd" }, { "name": "SLVR", "code": "SilveradoTrl" }, { "name": "STCY", "code": "StacyRd" }, { "name": "STEW", "code": "StewartRd" }, { "name": "STBR", "code": "StonebridgeDr" }, { "name": "TYBK", "code": "TaylorBurkDr" }, { "name": "TELE", "code": "TelephoneRd" }, { "name": "TENN", "code": "TennesseeSt" }, { "name": "TFPW", "code": "TrinityFallsPkwy" }, { "name": "UNIV", "code": "UniversityDr" }, { "name": "VAPW", "code": "VirginiaPkwy" }, { "name": "VAST", "code": "VirginiaSt" }, { "name": "WRDG", "code": "WestridgeBlvd" }, { "name": "WHTE", "code": "WhiteAve" }, { "name": "WILM", "code": "WilmethRd" }, { "name": "WLSN", "code": "WilsonCreekPkwy" }, { "name": "P-HUNT", "code": "HuntParking" }, { "name": "P-MTCH", "code": "MitchellParking" }, { "name": "P-NKEN", "code": "NKentuckyParking" }, { "name": "P-SKEN", "code": "SKentucky Parking" }, { "name": "P-SHER", "code": "Sheraton-CollinCollegeParking" }, { "name": "P-TENN", "code": "TennesseeParking-I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleTagNumber", "type": "esriFieldTypeSmallInteger", "alias": "PoleTagNumber", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R1439_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1439", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1439", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1188_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }