{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 7, "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": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "SupportStatus", "field2": "MaintenanceResponsibility", "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 56, 168, 0, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1.6666666666666667 } }, "value": "Active,", "label": "Active - In Service" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 56, 168, 0, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1.6666666666666667 } }, "value": "Active,McKinney", "label": "Active - In Service" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 170, 0, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1.6666666666666667 } }, "value": "Not Validated,McKinney", "label": "Not Validated" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 168, 0, 0, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1.6666666666666667 } }, "value": "Retired,McKinney", "label": "Retired - Decommissioned" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 112, 255, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1.6666666666666667 } }, "value": ",TxDOT", "label": "TxDOT" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 112, 255, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1.6666666666666667 } }, "value": "Active,TxDOT", "label": "TxDOT" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 112, 255, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1.6666666666666667 } }, "value": "Not Validated,TxDOT", "label": "TxDOT" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 112, 255, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1.6666666666666667 } }, "value": "Retired,TxDOT", "label": "TxDOT" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 156, 156, 156, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1.6666666666666667 } }, "value": "Not Validated,Private", "label": "Other" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 156, 156, 156, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1.6666666666666667 } }, "value": "Retired,", "label": "Other" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 156, 156, 156, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1.6666666666666667 } }, "value": "Not Validated,", "label": "Other" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 156, 156, 156, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1.6666666666666667 } }, "value": ",", "label": "Other" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 166, 76, 56, 255 ], "toColor": [ 166, 76, 56, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 52, 47, 196, 255 ], "toColor": [ 52, 47, 196, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 51, 189, 65, 255 ], "toColor": [ 51, 189, 65, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 60, 150, 186, 255 ], "toColor": [ 60, 150, 186, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 153, 50, 134, 255 ], "toColor": [ 153, 50, 134, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 166, 40, 255 ], "toColor": [ 189, 166, 40, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 66, 201, 165, 255 ], "toColor": [ 66, 201, 165, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 42, 97, 191, 255 ], "toColor": [ 42, 97, 191, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 201, 64, 112, 255 ], "toColor": [ 201, 64, 112, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 196, 122, 43, 255 ], "toColor": [ 196, 122, 43, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 180, 58, 201, 255 ], "toColor": [ 180, 58, 201, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 111, 66, 173, 255 ], "toColor": [ 111, 66, 173, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 133, 173, 47, 255 ], "toColor": [ 133, 173, 47, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 2469596.820993215, "ymin": 7067210.997512147, "xmax": 2588435.718191892, "ymax": 7176417.673645854, "spatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 6.561666666666666E-4, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "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 }, { "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": "MaintenanceResponsibility", "type": "esriFieldTypeString", "alias": "MaintenanceResponsibility", "length": 255, "domain": { "type": "codedValue", "name": "SupportPoleMaintenanceResponsibility", "description": "Maintenance Responsibility for Support Poles and Related Signs", "codedValues": [ { "name": "McKinney", "code": "McKinney" }, { "name": "TxDOT", "code": "TxDOT" }, { "name": "County", "code": "County" }, { "name": "Private", "code": "Private" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "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": 0, "name": "PoleSign", "relatedTableId": 39, "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 }