Road Maintenance
20160301 - Fields added and many updates 20160224 - Bob - Many weeks adding and populating BT_FD_L and BT_FD_R (Baytown_Fire_District_Left and Right) with the corrected District data20160317 - Bob - Updated the HCVP_Left and Right fields with the 2016 voter precincts changes. Precinct 103 was cut at Barbers Hill and the northern half was added to 53120160507 - Bob - Updated and imported into SDE the latest road file for Web Map applications20160721 - Bob - Added BT_CD_LEFT and BT_CD_R fields for Baytown Council Districts left and right and updated the SDE layer______________________________________________________FIELDSUnique_ID = Todays date dash 4 digit number starting with 0001 for that day. Should never change!!Ex: 20160301-0001 equals Year-Month-Day-0001 is the first record created that day. Crossing - Does the road cross any features, canals, railroads tracks, pipelines, other roadsBridge - Does the crossing go over a structure (Bridge) or a pipe covered over with dirt with no structureCorrigated pipeline has a 30 year life span used in culverts to 15 foot dia canalsBT_FD_L = Baytown Fire District Left side (Going from low to high address)BT_FD_R = Baytown Fire District Right side (Going from low to high address)HC_FD_L = Harris County Fire District Left - What Harris County Emergency Service District says it isHC_FD_R = Harris County Fire District Right - What Harris County Emergency Service District says it isGCP_Left = Goose Creek School District voter Precinct LeftGCP_Right = Goose Creek School District voter Precinct RightHCVP_Left = Harris County Voter Precinct LeftHCVP_Right = Harris County Voter Precinct RightOWNER = Public, Private, Who does the maintenance on the roadROW_Date = Date the road was created if knownExit_Num = Highway exit number from State of Texas Department of Tranportation.From Name = Cross Street starting from lowest address range To_Name = Cross Street starting from Highest address rangeLabel _1 = Field used to label streetsMaintained = Reponsible agency or other for maintenance of the roadwayAdded the following fields for the creation of an Atlas for fire and other departmentsFireGrid_1 = FireGrid_2FireGrid_3INDEX_TEXTINDEX_2BT_CD_LEFT = Field for Elections to distingush Baytown Council Districts Left BT_CD_R  = Field for Elections to distingush Baytown Council Districts Left
[]
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'domain': None}, {'name': 'CENTERLINEID', 'type': 'esriFieldTypeString', 'alias': 'Centerline ID', 'length': 20, 'domain': None}, {'name': 'FROMLEFT', 'type': 'esriFieldTypeInteger', 'alias': 'Left From Address', 'domain': None}, {'name': 'TOLEFT', 'type': 'esriFieldTypeInteger', 'alias': 'Left To Address', 'domain': None}, {'name': 'FROMRIGHT', 'type': 'esriFieldTypeInteger', 'alias': 'Right From Address', 'domain': None}, {'name': 'TORIGHT', 'type': 'esriFieldTypeInteger', 'alias': 'Right To Address', 'domain': None}, {'name': 'FULLNAME', 'type': 'esriFieldTypeString', 'alias': 'Full Road Name', 'length': 125, 'domain': None}, {'name': 'FEDROUTE', 'type': 'esriFieldTypeString', 'alias': 'Federal Route', 'length': 10, 'domain': None}, {'name': 'FEDRTETYPE', 'type': 'esriFieldTypeString', 'alias': 'Federal Route Type', 'length': 20, 'domain': None}, {'name': 'AFEDRTE', 'type': 'esriFieldTypeString', 'alias': 'Alternate Federal Route', 'length': 10, 'domain': None}, {'name': 'AFEDRTETYPE', 'type': 'esriFieldTypeString', 'alias': 'Alternate Federal Route Type', 'length': 20, 'domain': None}, {'name': 'STROUTE', 'type': 'esriFieldTypeString', 'alias': 'State Route', 'length': 10, 'domain': None}, {'name': 'STRTETYPE', 'type': 'esriFieldTypeString', 'alias': 'State Route Type', 'length': 20, 'domain': None}, {'name': 'ASTRTE', 'type': 'esriFieldTypeString', 'alias': 'Alternate State Route', 'length': 10, 'domain': None}, {'name': 'ASTRTETYPE', 'type': 'esriFieldTypeString', 'alias': 'Alternate State Route Type', 'length': 20, 'domain': None}, {'name': 'CTYROUTE', 'type': 'esriFieldTypeString', 'alias': 'County Route', 'length': 10, 'domain': None}, {'name': 'ONEWAYDIR', 'type': 'esriFieldTypeString', 'alias': 'One Way Indicator', 'length': 10, 'domain': None}, {'name': 'ROADLEVEL', 'type': 'esriFieldTypeInteger', 'alias': 'Above or Below Grade', 'domain': None}, {'name': 'INWATER', 'type': 'esriFieldTypeString', 'alias': 'In Water', 'length': 5, 'domain': None}, {'name': 'ROADCLASS', 'type': 'esriFieldTypeString', 'alias': 'Road Class', 'length': 20, 'domain': None}, {'name': 'MTFCC', 'type': 'esriFieldTypeString', 'alias': 'Census MTFCC Code', 'length': 5, 'domain': None}, {'name': 'MUNILEFT', 'type': 'esriFieldTypeString', 'alias': 'Municipality on Left', 'length': 100, 'domain': None}, {'name': 'MUNIRIGHT', 'type': 'esriFieldTypeString', 'alias': 'Municipality on Right', 'length': 100, 'domain': None}, {'name': 'STATELEFT', 'type': 'esriFieldTypeString', 'alias': 'State on Left', 'length': 2, 'domain': None}, {'name': 'STATERIGHT', 'type': 'esriFieldTypeString', 'alias': 'State on Right', 'length': 2, 'domain': None}, {'name': 'ZIPLEFT', 'type': 'esriFieldTypeString', 'alias': 'Zip on Left', 'length': 5, 'domain': None}, {'name': 'ZIPRIGHT', 'type': 'esriFieldTypeString', 'alias': 'Zip on Right', 'length': 5, 'domain': None}, {'name': 'MSAGLEFT', 'type': 'esriFieldTypeString', 'alias': 'MSAG on Left', 'length': 35, 'domain': None}, {'name': 'MSAGRIGHT', 'type': 'esriFieldTypeString', 'alias': 'MSAG on Right', 'length': 35, 'domain': None}, {'name': 'ESNLEFT', 'type': 'esriFieldTypeString', 'alias': 'ESN on Left', 'length': 5, 'domain': None}, {'name': 'ESNRIGHT', 'type': 'esriFieldTypeString', 'alias': 'ESN on Right', 'length': 5, 'domain': None}, {'name': 'LASTUPDATE', 'type': 'esriFieldTypeDate', 'alias': 'Last Update Date', 'length': 8, 'domain': None}, {'name': 'LASTEDITOR', 'type': 'esriFieldTypeString', 'alias': 'Last Editor', 'length': 50, 'domain': None}, {'name': 'SOURCE', 'type': 'esriFieldTypeString', 'alias': 'Source', 'length': 50, 'domain': None}, {'name': 'BT_JOIN', 'type': 'esriFieldTypeInteger', 'alias': 'City Join', 'domain': None}, {'name': 'GHC_JOIN', 'type': 'esriFieldTypeInteger', 'alias': 'GHC911 Join', 'domain': None}, {'name': 'PREFIX', 'type': 'esriFieldTypeString', 'alias': 'PREFIX', 'length': 10, 'domain': None}, {'name': 'STREETNAME', 'type': 'esriFieldTypeString', 'alias': 'STREETNAME', 'length': 200, 'domain': None}, {'name': 'TYPE', 'type': 'esriFieldTypeString', 'alias': 'TYPE', 'length': 10, 'domain': None}, {'name': 'SUFFIX', 'type': 'esriFieldTypeString', 'alias': 'SUFFIX', 'length': 10, 'domain': None}, {'name': 'COUNTYLEFT', 'type': 'esriFieldTypeString', 'alias': 'COUNTYLEFT', 'length': 30, 'domain': None}, {'name': 'COUNTYRIGHT', 'type': 'esriFieldTypeString', 'alias': 'COUNTYRIGHT', 'length': 30, 'domain': None}, {'name': 'PAVEMENTID', 'type': 'esriFieldTypeString', 'alias': 'PAVEMENTID', 'length': 50, 'domain': None}, {'name': 'OWNER', 'type': 'esriFieldTypeString', 'alias': 'OWNER', 'length': 50, 'domain': None}, {'name': 'GCPLEFT', 'type': 'esriFieldTypeString', 'alias': 'GCPLEFT', 'length': 10, 'domain': None}, {'name': 'GCPRIGHT', 'type': 'esriFieldTypeString', 'alias': 'GCPRIGHT', 'length': 10, 'domain': None}, {'name': 'HCVPLEFT', 'type': 'esriFieldTypeString', 'alias': 'HCVPLEFT', 'length': 10, 'domain': None}, {'name': 'HCVPRIGHT', 'type': 'esriFieldTypeString', 'alias': 'HCVPRIGHT', 'length': 10, 'domain': None}, {'name': 'NETWORKID', 'type': 'esriFieldTypeString', 'alias': 'NETWORKID', 'length': 10, 'domain': None}, {'name': 'NETWORKNAME', 'type': 'esriFieldTypeString', 'alias': 'NETWORKNAME', 'length': 61, 'domain': None}, {'name': 'BRANCHID', 'type': 'esriFieldTypeString', 'alias': 'BRANCHID', 'length': 10, 'domain': None}, {'name': 'BRANCHNAME', 'type': 'esriFieldTypeString', 'alias': 'BRANCHNAME', 'length': 35, 'domain': None}, {'name': 'ROADUSE', 'type': 'esriFieldTypeString', 'alias': 'ROADUSE', 'length': 20, 'domain': None}, {'name': 'FROMSTREET', 'type': 'esriFieldTypeString', 'alias': 'FROMSTREET', 'length': 35, 'domain': None}, {'name': 'TOSTREET', 'type': 'esriFieldTypeString', 'alias': 'TOSTREET', 'length': 35, 'domain': None}, {'name': 'RANK', 'type': 'esriFieldTypeString', 'alias': 'RANK', 'length': 20, 'domain': None}, {'name': 'SURFACE', 'type': 'esriFieldTypeString', 'alias': 'SURFACE', 'length': 20, 'domain': None}, {'name': 'WIDTH', 'type': 'esriFieldTypeDouble', 'alias': 'WIDTH', 'domain': None}, {'name': 'CONSTRUCTIONDATE', 'type': 'esriFieldTypeDate', 'alias': 'CONSTRUCTIONDATE', 'length': 8, 'domain': None}, {'name': 'PCI', 'type': 'esriFieldTypeSmallInteger', 'alias': 'PCI', 'domain': None}, {'name': 'PAVEMENT_ID_2017', 'type': 'esriFieldTypeString', 'alias': 'PAVEMENT_ID_2017', 'length': 50, 'domain': None}, {'name': 'UpdatedSection', 'type': 'esriFieldTypeString', 'alias': 'UpdatedSection', 'length': 3, 'domain': None}, {'name': 'Unique_ID', 'type': 'esriFieldTypeString', 'alias': 'Unique_ID', 'length': 10, 'domain': None}, {'name': 'created_user', 'type': 'esriFieldTypeString', 'alias': 'created_user', 'length': 255, 'domain': None}, {'name': 'created_date', 'type': 'esriFieldTypeDate', 'alias': 'created_date', 'length': 8, 'domain': None}, {'name': 'last_edited_user', 'type': 'esriFieldTypeString', 'alias': 'last_edited_user', 'length': 255, 'domain': None}, {'name': 'last_edited_date', 'type': 'esriFieldTypeDate', 'alias': 'last_edited_date', 'length': 8, 'domain': None}, {'name': 'Shape', 'type': 'esriFieldTypeGeometry', 'alias': 'Shape', 'domain': None}, {'name': 'ConditionDate', 'type': 'esriFieldTypeDate', 'alias': 'ConditionDate', 'length': 8, 'domain': None}, {'name': 'COMMENTS', 'type': 'esriFieldTypeString', 'alias': 'COMMENTS', 'length': 150, 'domain': None}, {'name': 'MAINTAINED', 'type': 'esriFieldTypeString', 'alias': 'MAINTAINED', 'length': 20, 'domain': None}, {'name': 'NewLeftTo', 'type': 'esriFieldTypeInteger', 'alias': 'NewLeftTo', 'domain': None}, {'name': 'NewLeftFrom', 'type': 'esriFieldTypeInteger', 'alias': 'NewLeftFrom', 'domain': None}, {'name': 'NewRightTo', 'type': 'esriFieldTypeInteger', 'alias': 'NewRightTo', 'domain': None}, {'name': 'NewRightFrom', 'type': 'esriFieldTypeInteger', 'alias': 'NewRightFrom', 'domain': None}, {'name': 'Shape.STLength()', 'type': 'esriFieldTypeDouble', 'alias': 'Shape.STLength()', 'domain': None}]
[{'name': 'R1033_pk', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': ''}, {'name': 'GDB_2470_CENTERL', 'fields': 'CENTERLINEID', 'isAscending': True, 'isUnique': False, 'description': ''}, {'name': 'S780_idx', 'fields': 'Shape', 'isAscending': True, 'isUnique': True, 'description': ''}]
[]
{'renderer': {'type': 'uniqueValue', 'field1': 'MAINTAINED', 'uniqueValueInfos': [{'symbol': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [56, 168, 0, 255], 'width': 2}, 'value': 'CITY MAINTAINED', 'label': 'CITY MAINTAINED'}, {'symbol': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [223, 115, 255, 255], 'width': 2}, 'value': 'County_Maintained', 'label': 'County_Maintained'}, {'symbol': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [255, 0, 0, 255], 'width': 2}, 'value': 'Future City Maintain', 'label': 'Future City Maintain'}, {'symbol': {'type': 'esriSLS', 'style': 'esriSLSDash', 'color': [255, 170, 0, 255], 'width': 2}, 'value': 'Owner_Maintained', 'label': 'Owner_Maintained'}, {'symbol': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [156, 156, 156, 255], 'width': 2}, 'value': 'TxDOT', 'label': 'TxDOT'}, {'symbol': {'type': 'esriSLS', 'style': 'esriSLSDash', 'color': [0, 0, 0, 255], 'width': 2}, 'value': 'VACATED', 'label': 'VACATED'}], 'fieldDelimiter': ','}, 'transparency': 0, 'labelingInfo': None}
nan
nan