AddressPoints
Created from copy of existing address file (SDE.HGAC/sde.SDE.AddressPTS on 2014-08-16) so that new fields could be added. These new fields will be the basic metadata fields to describe the following modifications to the file as we proceed forward with GIS. Fields2014-09-05 Created new version 4 added 1200 poins from the Chambers addresspoint file into this file and populated the fields correctly2015-12-31 Corrected street types in some areas2017-0702 - Added fields to collect data on each addressFeature - Address feature represents following - lot - building - garage - parking lot - boat launch etcCommon Name - Residential - retail - Commercial - IndustrialFac Name - House, apartment - RV - MOBILE HOME - WAREHOUSE - ETCBUS NAME - 2019-10-09 BOB EXISTING FIELDS2021-07-15 - Bob - reviewed meta datqa and updated - still need to add cityworks, energov, Road surface software and 911 fields added by other entities 1ESRIFieldsOBJECTIDOBJECTID2AREADouble3PERIMETERDouble4CountyidentificationnumberBook/Page/Block/LotHCAD_OLDHARRIS COUNTY APPRAISAL DISTRICT PARENT IDText / 13 5HCAD_NUMBEHARRIS COUNTY APPRAISAL DISTRICT 13 CHARACTER NUMBERText / 13 6CCAD_OLDChambers County Appraisal District Parent IDText / 13 7CCAD_NUMBEChambers County Appraisal District Lot number Text / 13 8CompleteAddressFieldsADR_OLDPrevious Address of the propertyText / 509ADR_NOWPresent Address of the propertyText / 7510ADR_NUMThe actual number of the property (according to the mail box)Text / 1011ADR_FRACFractional part (1/8,1/2, 1/5, 1/7)Text / 612ADR_PREFIXN, E, S, WText / 613ADR_STREETStreet Name according to recorded documentsText / 5014ADR_TYPEStreet Type according to recorded documentsText / 515ADR_SUFN, E, S, WText / 616ADR_BLDG_IBuilding number if more than 1 on property (Apartments and Commercial)Text / 1017ADR_UNITUnit Number (1, 2, 3, A, B, C)Text / 1018ADR_CITYCity the property is located. If not "COUNTY"Text / 5019ADR_STATEState the property is locatedText / 2020ADR_ZIPUSPS Zip Code the property is locatedText / 1021ADR_COUNTYCounty the property is locatedText / 2022JURISDICTIJurisdiction the property resides in (City, District, County)Text / 4023PropertyDescriptiveInformationFLOOR_IDThe floor of the unit If building has multiple floors Blank id single storyText / 1024TOTAL_FLOOTotal floors in the buildingText / 1025TOTAL_UNITTotal Units in the buildingText / 1026FEATURELooking at the property, What is it. (Building, structure, Dock, Sign, tower)Text / 5027COM_NAMEResidential, Commercial, Industrial, Text / 10028FAC_NAMECommon Name (House, apartment, retail space, Mobile home, RV)Text / 10029BUS_NAMEName of the Property, Bob's Apt's, Nathans zoning school, Harolds Patience CenterText / 10030BUS_TYPEAutomotive, Medical, Retail, TruckingText / 10031BUS_TYPE2Other descriptive COMPLEX NAMEText / 10032YEAR_BUILTYear the parcel or existing structure was created(Plat) or builtText / 1033Other DistrictsUSE_DESCRSpecial requirements of the property (RIZ Zone)Text / 4034ZONINGZoning of the propertyText / 1535JURISDIC_1Council District Number the property resides in if in the CityText / 4036GC_DistGoose Creek School District Text / 1037Voter_precVoter Precinct of the propertyText / 1038MapLabelingLABEL1Main Address NumberText / 4039LABEL2Unit Number (1, 2, 3, A, B, C)Text / 4040LABEL3Building number if more than 1 on property (Apartments)Text / 4041LABEL4Name of the property(Subdivision, Commercial name, Park name)Text / 4042Other SoftwareConnectionsCPIs the address in Community PlusText / 543Unique_IDUnique identification of City WorksText / 2544Source ofInformationSOURCE_IDSource of the data documents tht the informtion is garnered fromText /12045RECORD_IDIdentification if known of source dataText / 5046COMMENTSomething not covered by present fieldsText / 12047USER_FLAG1Editor use 1Text / 2048USER_FLAG2Editor use 2Text / 2049GPSInformationX_COORDGPS coordinateDouble / 12 / 350Y_COORDGPS coordinateDouble / 12 / 351Z_COORDGPS coordinate of elevationDouble / 12 / 352RecordedDocumentsSubdivisioName of the plat or document the property was created and recordedText / 2053Sub_SectioThe subsection the property was created fromText / 554Sub_BlockThe block number the property was subdivided fromText / 555Sub_LotsThe lot number of the existing propertyText / 556User InformationDATE_MOD1Latest editingText / 1057DATE_MOD2Previous editingText / 1058EDITOREditorText / 1059created_us60created_da61last_edite62last_edi_163created__164created__265last_edi_266last_edi_3
[]
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'domain': None}, {'name': 'BaytownGIS.SDE.BT_Address.AREA', 'type': 'esriFieldTypeDouble', 'alias': 'BaytownGIS.SDE.BT_Address.AREA', 'domain': None}, {'name': 'HCAD_OLD', 'type': 'esriFieldTypeString', 'alias': 'HCAD_OLD', 'length': 13, 'domain': None}, {'name': 'HCAD_NUMBE', 'type': 'esriFieldTypeString', 'alias': 'HCAD_NUMBE', 'length': 13, 'domain': None}, {'name': 'CCAD_OLD', 'type': 'esriFieldTypeString', 'alias': 'CCAD_OLD', 'length': 13, 'domain': None}, {'name': 'CCAD_NUMBE', 'type': 'esriFieldTypeString', 'alias': 'CCAD_NUMBE', 'length': 13, 'domain': None}, {'name': 'ADR_OLD', 'type': 'esriFieldTypeString', 'alias': 'ADR_OLD', 'length': 50, 'domain': None}, {'name': 'ADR_NOW', 'type': 'esriFieldTypeString', 'alias': 'ADR_NOW', 'length': 50, 'domain': None}, {'name': 'ADR_NUM', 'type': 'esriFieldTypeString', 'alias': 'ADR_NUM', 'length': 10, 'domain': None}, {'name': 'ADR_FRAC', 'type': 'esriFieldTypeString', 'alias': 'ADR_FRAC', 'length': 6, 'domain': None}, {'name': 'ADR_PREFIX', 'type': 'esriFieldTypeString', 'alias': 'ADR_PREFIX', 'length': 6, 'domain': None}, {'name': 'ADR_STREET', 'type': 'esriFieldTypeString', 'alias': 'ADR_STREET', 'length': 50, 'domain': None}, {'name': 'ADR_TYPE', 'type': 'esriFieldTypeString', 'alias': 'ADR_TYPE', 'length': 5, 'domain': None}, {'name': 'ADR_SUF', 'type': 'esriFieldTypeString', 'alias': 'ADR_SUF', 'length': 6, 'domain': None}, {'name': 'ADR_BLDG_I', 'type': 'esriFieldTypeString', 'alias': 'ADR_BLDG_I', 'length': 10, 'domain': None}, {'name': 'ADR_UNIT', 'type': 'esriFieldTypeString', 'alias': 'ADR_UNIT', 'length': 20, 'domain': None}, {'name': 'ADR_CITY', 'type': 'esriFieldTypeString', 'alias': 'ADR_CITY', 'length': 50, 'domain': None}, {'name': 'ADR_STATE', 'type': 'esriFieldTypeString', 'alias': 'ADR_STATE', 'length': 20, 'domain': None}, {'name': 'ADR_ZIP', 'type': 'esriFieldTypeString', 'alias': 'ADR_ZIP', 'length': 10, 'domain': None}, {'name': 'ADR_COUNTY', 'type': 'esriFieldTypeString', 'alias': 'ADR_COUNTY', 'length': 20, 'domain': None}, {'name': 'FLOOR_ID', 'type': 'esriFieldTypeString', 'alias': 'FLOOR_ID', 'length': 10, 'domain': None}, {'name': 'TOTAL_FLOO', 'type': 'esriFieldTypeString', 'alias': 'TOTAL_FLOO', 'length': 10, 'domain': None}, {'name': 'TOTAL_UNIT', 'type': 'esriFieldTypeString', 'alias': 'TOTAL_UNIT', 'length': 10, 'domain': None}, {'name': 'COM_NAME', 'type': 'esriFieldTypeString', 'alias': 'COM_NAME', 'length': 100, 'domain': None}, {'name': 'FAC_NAME', 'type': 'esriFieldTypeString', 'alias': 'FAC_NAME', 'length': 100, 'domain': None}, {'name': 'BUS_NAME', 'type': 'esriFieldTypeString', 'alias': 'BUS_NAME', 'length': 100, 'domain': None}, {'name': 'BUS_TYPE', 'type': 'esriFieldTypeString', 'alias': 'BUS_TYPE', 'length': 100, 'domain': None}, {'name': 'BUS_TYPE2', 'type': 'esriFieldTypeString', 'alias': 'BUS_TYPE2', 'length': 100, 'domain': None}, {'name': 'ZONING', 'type': 'esriFieldTypeString', 'alias': 'ZONING', 'length': 15, 'domain': None}, {'name': 'YEAR_BUILT', 'type': 'esriFieldTypeString', 'alias': 'YEAR_BUILT', 'length': 10, 'domain': None}, {'name': 'JURISDICTI', 'type': 'esriFieldTypeString', 'alias': 'JURISDICTI', 'length': 40, 'domain': None}, {'name': 'JURISDIC_1', 'type': 'esriFieldTypeString', 'alias': 'JURISDIC_1', 'length': 40, 'domain': None}, {'name': 'LABEL1', 'type': 'esriFieldTypeString', 'alias': 'LABEL1', 'length': 40, 'domain': None}, {'name': 'LABEL2', 'type': 'esriFieldTypeString', 'alias': 'LABEL2', 'length': 40, 'domain': None}, {'name': 'LABEL3', 'type': 'esriFieldTypeString', 'alias': 'LABEL3', 'length': 40, 'domain': None}, {'name': 'LABEL4', 'type': 'esriFieldTypeString', 'alias': 'LABEL4', 'length': 40, 'domain': None}, {'name': 'SOURCE_ID', 'type': 'esriFieldTypeString', 'alias': 'SOURCE_ID', 'length': 120, 'domain': None}, {'name': 'COMMENT', 'type': 'esriFieldTypeString', 'alias': 'COMMENT', 'length': 120, 'domain': None}, {'name': 'Subdivisio', 'type': 'esriFieldTypeString', 'alias': 'Subdivisio', 'length': 25, 'domain': None}, {'name': 'Sub_Sectio', 'type': 'esriFieldTypeString', 'alias': 'Sub_Sectio', 'length': 5, 'domain': None}, {'name': 'Sub_Lots', 'type': 'esriFieldTypeString', 'alias': 'Sub_Lots', 'length': 5, 'domain': None}, {'name': 'Sub_Block', 'type': 'esriFieldTypeString', 'alias': 'Sub_Block', 'length': 5, 'domain': None}, {'name': 'GC_Dist', 'type': 'esriFieldTypeString', 'alias': 'GC_Dist', 'length': 10, 'domain': None}, {'name': 'Voter_prec', 'type': 'esriFieldTypeString', 'alias': 'Voter_prec', 'length': 10, 'domain': None}, {'name': 'FEATURE', 'type': 'esriFieldTypeString', 'alias': 'FEATURE', 'length': 50, 'domain': None}, {'name': 'File_Name', 'type': 'esriFieldTypeString', 'alias': 'File_Name', 'length': 50, 'domain': None}, {'name': 'CP', 'type': 'esriFieldTypeString', 'alias': 'CP', 'length': 5, 'domain': None}, {'name': 'Unique_ID', 'type': 'esriFieldTypeString', 'alias': 'Unique_ID', 'length': 25, 'domain': None}, {'name': 'Shape', 'type': 'esriFieldTypeGeometry', 'alias': 'Shape', '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': 'LIFECYCLE', 'type': 'esriFieldTypeString', 'alias': 'LIFECYCLE', 'length': 50, 'domain': {'type': 'codedValue', 'name': 'LIFECYCLE', 'description': 'ASSET LIFE CYCLE', 'codedValues': [{'name': 'ACTIVE', 'code': 'ACTIVE'}, {'name': 'ABANDONED', 'code': 'ABANDONED'}, {'name': 'REMOVED', 'code': 'REMOVED'}, {'name': 'INACTIVE', 'code': 'INACTIVE'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'PostalCode', 'type': 'esriFieldTypeString', 'alias': 'PostalCode', 'length': 10, 'domain': None}]
[{'name': 'R11_pk', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': ''}, {'name': 'S6_idx', 'fields': 'Shape', 'isAscending': True, 'isUnique': True, 'description': ''}]
[]
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriSMS', 'style': 'esriSMSCircle', 'color': [108, 0, 158, 255], 'size': 4, 'angle': 0, 'xoffset': 0, 'yoffset': 0, 'outline': {'color': [0, 0, 0, 255], 'width': 1}}}, 'transparency': 0, 'labelingInfo': [{'labelExpression': '[ADR_NUM]', 'labelPlacement': 'esriServerPointLabelPlacementAboveRight', 'deconflictionStrategy': 'dynamic', 'allowOverlapOfFeatureInterior': 'allow', 'stackLabel': True, 'stackAlignment': 'dynamic', 'removeDuplicates': 'none', 'useCodedValues': True, 'maxScale': 0, 'minScale': 0, 'name': 'Default', 'priority': 1, 'symbol': {'type': 'esriTS', 'color': [0, 0, 0, 255], 'backgroundColor': None, 'borderLineColor': None, 'borderLineSize': None, 'verticalAlignment': 'baseline', 'horizontalAlignment': 'left', 'rightToLeft': False, 'angle': 0, 'xoffset': 0, 'yoffset': 0, 'kerning': True, 'haloColor': None, 'haloSize': None, 'font': {'family': 'Arial', 'size': 8, 'style': 'normal', 'weight': 'normal', 'decoration': 'none'}}}]}
nan
nan