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.<\/SPAN><\/P>Traffic and Transportation Engineering Contact Information:<\/SPAN><\/P>Web: https://www.mckinneytexas.org/247/Traffic-Transportation-Engineering<\/SPAN><\/P>Phone 8am to 5pm: 972-547-7420<\/SPAN><\/P>This 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.<\/SPAN><\/P>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.<\/SPAN><\/P><\/P>
Last Updated: July 8, 2019<\/SPAN><\/P>Update Schedule: Continuous<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>",
"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": [
130,
130,
130,
255
],
"size": 4,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 0.7
}
},
"defaultLabel": "",
"uniqueValueInfos": [
{
"symbol": {
"type": "esriSMS",
"style": "esriSMSCircle",
"color": [
56,
168,
0,
255
],
"size": 8,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 1
}
},
"value": "Active",
"label": "Active - In Service"
},
{
"symbol": {
"type": "esriSMS",
"style": "esriSMSCircle",
"color": [
230,
152,
0,
255
],
"size": 8,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 0.5
}
},
"value": "Not Validated",
"label": "Not Validated"
},
{
"symbol": {
"type": "esriSMS",
"style": "esriSMSCircle",
"color": [
230,
0,
0,
255
],
"size": 8,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 0.5
}
},
"value": "Retired",
"label": "Retired - Decommissioned"
}
],
"fieldDelimiter": ",",
"authoringInfo": {
"colorRamp": {
"type": "multipart",
"colorRamps": [
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
184,
252,
255
],
"toColor": [
252,
184,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
196,
252,
179,
255
],
"toColor": [
196,
252,
179,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
179,
233,
252,
255
],
"toColor": [
179,
233,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
209,
189,
255
],
"toColor": [
252,
209,
189,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
189,
199,
252,
255
],
"toColor": [
189,
199,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
207,
234,
255
],
"toColor": [
252,
207,
234,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
247,
252,
210,
255
],
"toColor": [
247,
252,
210,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
182,
252,
231,
255
],
"toColor": [
182,
252,
231,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
179,
183,
255
],
"toColor": [
252,
179,
183,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
228,
179,
255
],
"toColor": [
252,
228,
179,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
228,
215,
252,
255
],
"toColor": [
228,
215,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
221,
189,
252,
255
],
"toColor": [
221,
189,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
212,
252,
207,
255
],
"toColor": [
212,
252,
207,
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": 0,
"name": "PoleSign",
"relatedTableId": 9,
"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": {
"timeZone": "Central Standard Time",
"respectsDaylightSaving": false
},
"preferredTimeReference": {
"timeZone": "Central Standard Time",
"respectsDaylightSaving": true
},
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
}