All Layers and Tables (Code)

Layers:

Layer: Planning.PLN.ADRCode (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"MERGE_SRC","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,92,230,255],"size":2,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"Energov.SDE.AnimalControlCodeCases","label":"Energov.SDE.AnimalControlCodeCases"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,85,0,255],"size":2,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"Energov.SDE.CodeEnforcementCodeCases","label":"Energov.SDE.CodeEnforcementCodeCases"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,197,202,255],"toColor":[252,197,202,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,182,255],"toColor":[182,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,183,252,255],"toColor":[182,183,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,247,252,255],"toColor":[207,247,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,252,212,255],"toColor":[252,252,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,241,255],"toColor":[252,179,241,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[233,212,252,255],"toColor":[233,212,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,224,255],"toColor":[187,252,224,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,213,187,255],"toColor":[252,213,187,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[244,252,179,255],"toColor":[244,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,220,252,255],"toColor":[187,220,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[224,187,252,255],"toColor":[224,187,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[221,252,199,255],"toColor":[221,252,199,255]}]}}},"scaleSymbols":true,"transparency":1,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
CaseNumber (type: esriFieldTypeString, alias: CaseNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
CaseType (type: esriFieldTypeString, alias: CaseType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
CaseStatus (type: esriFieldTypeString, alias: CaseStatus, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
CaseDescription (type: esriFieldTypeString, alias: CaseDescription, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
AssignedTo (type: esriFieldTypeString, alias: AssignedTo, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
OpenDate (type: esriFieldTypeDate, alias: OpenDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CloseDate (type: esriFieldTypeDate, alias: CloseDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Parcel (type: esriFieldTypeString, alias: Parcel, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
MERGE_SRC (type: esriFieldTypeString, alias: MERGE_SRC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Types:

MERGE_SRC: Energov.SDE.AnimalControlCodeCases

MERGE_SRC: Energov.SDE.CodeEnforcementCodeCases

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Layer: Planning.PLN.MajorRoads (1)

Name:

Display Field:

Type:

Geometry Type:

Description:

This dataset contains major roads for the City of McKinney, Texas.

Last updated:

Update frequency: As needed.

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":2}},"scaleSymbols":true,"transparency":21,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.STREET_NAM"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"followFeature","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"all","removeDuplicatesDistance":144,"useCodedValues":true,"maxScale":0,"minScale":0,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[130,130,130,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":0.5,"font":{"family":"Tahoma","size":4,"style":"normal","weight":"bold","decoration":"none"}}}]}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
FNODE_ (type: esriFieldTypeDouble, alias: FNODE_, SQL Type: sqlTypeOther, nullable: true, editable: true)
TNODE_ (type: esriFieldTypeDouble, alias: TNODE_, SQL Type: sqlTypeOther, nullable: true, editable: true)
LPOLY_ (type: esriFieldTypeDouble, alias: LPOLY_, SQL Type: sqlTypeOther, nullable: true, editable: true)
RPOLY_ (type: esriFieldTypeDouble, alias: RPOLY_, SQL Type: sqlTypeOther, nullable: true, editable: true)
LENGTH (type: esriFieldTypeDouble, alias: LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
ROADMAJOR_ (type: esriFieldTypeDouble, alias: ROADMAJOR_, SQL Type: sqlTypeOther, nullable: true, editable: true)
ROADMAJOR1 (type: esriFieldTypeDouble, alias: ROADMAJOR1, SQL Type: sqlTypeOther, nullable: true, editable: true)
FNODE_1 (type: esriFieldTypeDouble, alias: FNODE_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
TNODE_1 (type: esriFieldTypeDouble, alias: TNODE_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
LPOLY_1 (type: esriFieldTypeDouble, alias: LPOLY_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
RPOLY_1 (type: esriFieldTypeDouble, alias: RPOLY_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
THBIS_ (type: esriFieldTypeDouble, alias: THBIS_, SQL Type: sqlTypeOther, nullable: true, editable: true)
THBIS_ID (type: esriFieldTypeDouble, alias: THBIS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
STREET_NAM (type: esriFieldTypeString, alias: STREET_NAM, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
FC_CLASS (type: esriFieldTypeString, alias: FC_CLASS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ARTERIAL: ARTERIAL], [COLLECTOR: COLLECTOR], [LOCAL STREET: LOCAL STREET], ... 4 more ...)
TYPE (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [2 LANES ONE-WAY PAIRING: 2 LANES ONE-WAY PAIRING], [4 LANE GREENWAY ARTERIAL (G4D): 4 LANE GREENWAY ARTERIAL (G4D)], [4 LANE MAJOR COLLECTORS: 4 LANE MAJOR COLLECTORS], ... 3 more ...)
STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
ROW2 (type: esriFieldTypeString, alias: ROW2, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Layer: Planning.PLN.CityLimits (2)

Name:

Display Field:

Type:

Geometry Type:

Description:

This data contains City Limits for the City of McKinney. This layer was produced based on City of McKinney Annexation Ordinances. City of McKinney GIS - worked with City Secretary and Planning to update layer.

Previous Update history: 1/10/2019 (Annex Ord 2018-12-091), 5/18/2021 (Annex Ord 2021-03-020, 2021-03-022), 8/20/2021 (Annex Ord 2021-07-066 , 2021-07-076, 2021-08-083)

Last updated: 01/21/2022 (Annex Ord ,2021-10-108, 2022-01-004)

Update frequency: As Needed

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[255,255,255,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":1}}},"scaleSymbols":true,"transparency":21,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Layer: Planning.PLN.ETJ (3)

Name:

Display Field:

Type:

Geometry Type:

Description:

This data contains the Extra Territorial Jurisdiction Layer for the City of McKinney, Texas. The layer is complete, pending any proposed boundary agreement changes. This layer was produced based on the City of McKinney Boundary agreements with adjacent cities.

Updated on 09/17/2021 because of the New Hope Interlocal ETJ Boundary Agreement.

Last updated: 09/17/2021

Update frequency: Not Planned

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[204,204,204,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":0.7}}},"scaleSymbols":true,"transparency":33,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
PERIMETER (type: esriFieldTypeDouble, alias: PERIMETER, SQL Type: sqlTypeOther, nullable: false, editable: true)
Hectares (type: esriFieldTypeDouble, alias: Hectares, SQL Type: sqlTypeOther, nullable: false, editable: true)
Acres (type: esriFieldTypeDouble, alias: Acres, SQL Type: sqlTypeOther, nullable: false, editable: true)
Sq_Miles (type: esriFieldTypeDouble, alias: Sq_Miles, SQL Type: sqlTypeOther, nullable: false, editable: true)
Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 35, nullable: false, editable: true)
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Sq_Miles: 0
Notes:
PERIMETER: 0
Hectares: 0
Acres: 0

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Layer: Trinity Falls (4)

Name:

Display Field:

Type:

Geometry Type:

Description:

This data contains the Council Districts Layer for the City of McKinney, Texas.

Last updated:

Update frequency: As Needed

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[158,187,215,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":0.4}}},"scaleSymbols":true,"transparency":56,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.Boundary"},"labelPlacement":"esriServerPolygonPlacementAlwaysHorizontal","multiPart":"labelLargest","allowOverrun":true,"deconflictionStrategy":"static","repeatLabel":false,"stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"none","useCodedValues":true,"maxScale":0,"minScale":0,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[52,52,52,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,127],"haloSize":0.5,"font":{"family":"Tahoma","size":4,"style":"normal","weight":"bold","decoration":"none"}}}]}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Boundary (type: esriFieldTypeString, alias: Boundary, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Layer: Planning.PLN.CityLimits (5)

Name:

Display Field:

Type:

Geometry Type:

Description:

Previous Update history: 1/10/2019 (Annex Ord 2018-12-091), 5/18/2021 (Annex Ord 2021-03-020, 2021-03-022), 8/20/2021 (Annex Ord 2021-07-066 , 2021-07-076, 2021-08-083)

Last updated: 01/21/2022 (Annex Ord ,2021-10-108, 2022-01-004)

Update frequency: As Needed

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[248,245,237,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":1}}},"scaleSymbols":true,"transparency":21,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Layer: Planning.PLN.ETJ (6)

Name:

Display Field:

Type:

Geometry Type:

Description:

Updated on 09/17/2021 because of the New Hope Interlocal ETJ Boundary Agreement.

Last updated: 09/17/2021

Update frequency: Not Planned

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[201,190,171,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":66,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
PERIMETER (type: esriFieldTypeDouble, alias: PERIMETER, SQL Type: sqlTypeOther, nullable: false, editable: true)
Hectares (type: esriFieldTypeDouble, alias: Hectares, SQL Type: sqlTypeOther, nullable: false, editable: true)
Acres (type: esriFieldTypeDouble, alias: Acres, SQL Type: sqlTypeOther, nullable: false, editable: true)
Sq_Miles (type: esriFieldTypeDouble, alias: Sq_Miles, SQL Type: sqlTypeOther, nullable: false, editable: true)
Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 35, nullable: false, editable: true)
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Sq_Miles: 0
Notes:
PERIMETER: 0
Hectares: 0
Acres: 0

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: