Layers:

Layer: BaytownGIS.SDE.RoadCenterline (0)


Name: BaytownGIS.SDE.RoadCenterline

Display Field: FULLNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

20200925 - Massive amount of corrections and modifications to improve the dataset.

corrections to

20210129 - Finance request for information -

Used field STATELEFT due to no field availible for editing work

2 indicates records used

3 indicates records not used

Process to extract information - Query City limits for City only - Remve Limited Annexations and Strip Annexations

Select from road centerline file (911 road file) using City limts

Unselect Private roads, Vacated and Proposed roads

Remove roads not in City limts that query grabbed

used the field (Shape.STLength()) statistics sum to get total feet

Process from feet to miles

Send to finance for year end report.



Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 3197070.54370297
YMin: 13809049.4224254
XMax: 3305567.2079428
YMax: 13923008.3044153
Spatial Reference: 102740 (2278)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[114,153,36,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field:

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• CENTERLINEID (type: esriFieldTypeString, alias: Centerline ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FROMLEFT (type: esriFieldTypeInteger, alias: Left From Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOLEFT (type: esriFieldTypeInteger, alias: Left To Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FROMRIGHT (type: esriFieldTypeInteger, alias: Right From Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TORIGHT (type: esriFieldTypeInteger, alias: Right To Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FULLNAME (type: esriFieldTypeString, alias: Full Road Name, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• FEDROUTE (type: esriFieldTypeString, alias: Federal Route, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FEDRTETYPE (type: esriFieldTypeString, alias: Federal Route Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• AFEDRTE (type: esriFieldTypeString, alias: Alternate Federal Route, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• AFEDRTETYPE (type: esriFieldTypeString, alias: Alternate Federal Route Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• STROUTE (type: esriFieldTypeString, alias: State Route, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• STRTETYPE (type: esriFieldTypeString, alias: State Route Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ASTRTE (type: esriFieldTypeString, alias: Alternate State Route, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ASTRTETYPE (type: esriFieldTypeString, alias: Alternate State Route Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CTYROUTE (type: esriFieldTypeString, alias: County Route, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ONEWAYDIR (type: esriFieldTypeString, alias: One Way Indicator, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ROADLEVEL (type: esriFieldTypeInteger, alias: Above or Below Grade, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INWATER (type: esriFieldTypeString, alias: In Water, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• ROADCLASS (type: esriFieldTypeString, alias: Road Class, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MTFCC (type: esriFieldTypeString, alias: Census MTFCC Code, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• MUNILEFT (type: esriFieldTypeString, alias: Municipality on Left, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• MUNIRIGHT (type: esriFieldTypeString, alias: Municipality on Right, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• STATELEFT (type: esriFieldTypeString, alias: State on Left, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• STATERIGHT (type: esriFieldTypeString, alias: State on Right, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ZIPLEFT (type: esriFieldTypeString, alias: Zip on Left, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• ZIPRIGHT (type: esriFieldTypeString, alias: Zip on Right, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• MSAGLEFT (type: esriFieldTypeString, alias: MSAG on Left, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• MSAGRIGHT (type: esriFieldTypeString, alias: MSAG on Right, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• ESNLEFT (type: esriFieldTypeString, alias: ESN on Left, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• ESNRIGHT (type: esriFieldTypeString, alias: ESN on Right, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• LASTUPDATE (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTEDITOR (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SOURCE (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BT_JOIN (type: esriFieldTypeInteger, alias: City Join, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GHC_JOIN (type: esriFieldTypeInteger, alias: GHC911 Join, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PREFIX (type: esriFieldTypeString, alias: PREFIX, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• STREETNAME (type: esriFieldTypeString, alias: STREETNAME, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• TYPE (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SUFFIX (type: esriFieldTypeString, alias: SUFFIX, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• COUNTYLEFT (type: esriFieldTypeString, alias: COUNTYLEFT, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• COUNTYRIGHT (type: esriFieldTypeString, alias: COUNTYRIGHT, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• PAVEMENTID (type: esriFieldTypeString, alias: PAVEMENTID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GCPLEFT (type: esriFieldTypeString, alias: GCPLEFT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• GCPRIGHT (type: esriFieldTypeString, alias: GCPRIGHT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• HCVPLEFT (type: esriFieldTypeString, alias: HCVPLEFT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• HCVPRIGHT (type: esriFieldTypeString, alias: HCVPRIGHT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• NETWORKID (type: esriFieldTypeString, alias: NETWORKID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• NETWORKNAME (type: esriFieldTypeString, alias: NETWORKNAME, SQL Type: sqlTypeOther, length: 61, nullable: true, editable: true)
• BRANCHID (type: esriFieldTypeString, alias: BRANCHID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• BRANCHNAME (type: esriFieldTypeString, alias: BRANCHNAME, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• ROADUSE (type: esriFieldTypeString, alias: ROADUSE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FROMSTREET (type: esriFieldTypeString, alias: FROMSTREET, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• TOSTREET (type: esriFieldTypeString, alias: TOSTREET, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• RANK (type: esriFieldTypeString, alias: RANK, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SURFACE (type: esriFieldTypeString, alias: SURFACE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• WIDTH (type: esriFieldTypeDouble, alias: WIDTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONSTRUCTIONDATE (type: esriFieldTypeDate, alias: CONSTRUCTIONDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PCI (type: esriFieldTypeSmallInteger, alias: PCI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PAVEMENT_ID_2017 (type: esriFieldTypeString, alias: PAVEMENT_ID_2017, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UpdatedSection (type: esriFieldTypeString, alias: UpdatedSection, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Unique_ID (type: esriFieldTypeString, alias: Unique_ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• ConditionDate (type: esriFieldTypeDate, alias: ConditionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• MAINTAINED (type: esriFieldTypeString, alias: MAINTAINED, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• NewLeftTo (type: esriFieldTypeInteger, alias: NewLeftTo, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NewLeftFrom (type: esriFieldTypeInteger, alias: NewLeftFrom, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NewRightTo (type: esriFieldTypeInteger, alias: NewRightTo, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NewRightFrom (type: esriFieldTypeInteger, alias: NewRightFrom, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: BaytownGIS.SDE.RoadCenterline
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/3/2021 8:24:52 PM

Schema Last Edit Date: 3/3/2021 8:24:52 PM

Data Last Edit Date: 3/3/2021 8:24:52 PM