{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Support Poles", "type": "Feature Layer", "description": "The City of McKinney Engineering Department provides safe and efficient mobility for people, goods and services through planning, design and implementation of transportation improvements in a proficient and courteous manner.Traffic and Transportation Engineering Contact Information:Web: https://www.mckinneytexas.org/247/Traffic-Transportation-EngineeringPhone 8am to 5pm: 972-547-7420This point layer documents the physical location of support poles throughout the city, this layer links to a variety of related tables. Related tables include information for support pole maintance, the sign assets secured to those support poles and their maintenance records. This dataset is updated continuously by the Engineering Traffic team field staff as they inspect/install traffic assets throughout the city.The primary workflow for data edits is through ArcCollector in the field by Engineering Traffic staff, the secondary workflow is through an AGOL web-based application by the Engineering Traffic supervisor.Last Updated: July 8, 2019Update Schedule: Continuous", "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 GIS Department, Development Services, Engineering, Traffic, Transportation", "parentLayer": null, "subLayers": [], "minScale": 5000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "SupportStatus", "defaultSymbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 255, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.25 } }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 56, 168, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.25 } }, "value": "Active", "label": "Active In Service" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 170, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.25 } }, "value": "Not Validated", "label": "Not Validated" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 230, 0, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.25 } }, "value": "Retired", "label": "Retired Decommissioned" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 233, 252, 197, 255 ], "toColor": [ 233, 252, 197, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 239, 179, 252, 255 ], "toColor": [ 239, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 187, 225, 252, 255 ], "toColor": [ 187, 225, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 185, 182, 255 ], "toColor": [ 252, 185, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 252, 238, 255 ], "toColor": [ 189, 252, 238, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 207, 237, 255 ], "toColor": [ 252, 207, 237, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 233, 215, 255 ], "toColor": [ 252, 233, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 196, 194, 252, 255 ], "toColor": [ 196, 194, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 191, 255 ], "toColor": [ 179, 252, 191, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 238, 182, 255 ], "toColor": [ 252, 238, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 218, 255 ], "toColor": [ 252, 215, 218, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 246, 252, 255 ], "toColor": [ 212, 246, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 224, 215, 252, 255 ], "toColor": [ 224, 215, 252, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2469596.820993215, "ymin": 7067210.997512147, "xmax": 2588435.718191892, "ymax": 7176417.673645854, "spatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 5.120000004768374E-4, "zTolerance": 2, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3.592069011000888E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "SupportType", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SupportType", "type": "esriFieldTypeString", "alias": "SupportType", "length": 10, "domain": { "type": "codedValue", "name": "SP_SupportType", "description": "Support Pole Support Type", "codedValues": [ { "name": "Round Post", "code": "Round Post" }, { "name": "Decorative", "code": "Decorative" }, { "name": "Signal", "code": "Signal" }, { "name": "Flasher", "code": "Flasher" }, { "name": "U-Channel", "code": "U-Channel" }, { "name": "Square Post", "code": "SQ Post" }, { "name": "Wayfinding - Square Post", "code": "WF-SqPost" }, { "name": "Wayfinding - Vehicular", "code": "WF-Vehic" }, { "name": "Wayfinding - Kiosk", "code": "WF-Kiosk" }, { "name": "Light Pole", "code": "LightPole" }, { "name": "Utility Pole", "code": "Util-Pole" }, { "name": "TxDOT single", "code": "TxDsingle" }, { "name": "TxDOT multi", "code": "TxDmulti" }, { "name": "Wooden Pole", "code": "WoodenPole" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "length": 8, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "SupportStatus", "type": "esriFieldTypeString", "alias": "Support Status", "length": 255, "domain": { "type": "codedValue", "name": "SP_OperationalStatus", "description": "Support Pole Operational Status of Sign", "codedValues": [ { "name": "Not Validated", "code": "Not Validated" }, { "name": "Active - In Service", "code": "Active" }, { "name": "Retired - Decommissioned", "code": "Retired" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "ParentSuppportPoleGUID", "length": 38, "domain": null }, { "name": "ZoneNumber", "type": "esriFieldTypeSmallInteger", "alias": "ZoneNumber", "domain": { "type": "codedValue", "name": "TS_SignalZoneNumber", "description": "Traffic Signal Zone Number", "codedValues": [ { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "SupportColor", "type": "esriFieldTypeString", "alias": "Support Color", "length": 50, "domain": { "type": "codedValue", "name": "SP_SupportColor", "description": "Support Pole Color Types", "codedValues": [ { "name": "Brown", "code": "Brown" }, { "name": "White", "code": "White" }, { "name": "Galvanized", "code": "Galvanized" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AdditionalNotes", "type": "esriFieldTypeString", "alias": "Additional Notes", "length": 255, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R1209_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1209", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1209", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S994_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "PoleMaintenance", "relatedTableId": 66, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "PoleSign", "relatedTableId": 64, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "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": 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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "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 }