Name: BaytownGIS.SDE.BT_Address

Display Field: COM_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: 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

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.267257E8
YMin: -7.78288E7
XMax: 3553616.6206356287
YMax: 4.534502449601838E7
Spatial Reference: 102740  (2278)  VCSWkid(115702)  LatestVCSWkid(115702)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 137, 168, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• BaytownGIS.SDE.BT_Address.AREA ( type: esriFieldTypeDouble, alias: AREA )
• HCAD_OLD ( type: esriFieldTypeString, alias: HCAD_OLD, length: 13 )
• HCAD_NUMBE ( type: esriFieldTypeString, alias: HCAD_NUMBE, length: 13 )
• CCAD_OLD ( type: esriFieldTypeString, alias: CCAD_OLD, length: 13 )
• CCAD_NUMBE ( type: esriFieldTypeString, alias: CCAD_NUMBE, length: 13 )
• ADR_OLD ( type: esriFieldTypeString, alias: ADR_OLD, length: 50 )
• ADR_NOW ( type: esriFieldTypeString, alias: ADR_NOW, length: 50 )
• ADR_NUM ( type: esriFieldTypeString, alias: ADR_NUM, length: 10 )
• ADR_FRAC ( type: esriFieldTypeString, alias: ADR_FRAC, length: 6 )
• ADR_PREFIX ( type: esriFieldTypeString, alias: ADR_PREFIX, length: 6 )
• ADR_STREET ( type: esriFieldTypeString, alias: ADR_STREET, length: 50 )
• ADR_TYPE ( type: esriFieldTypeString, alias: ADR_TYPE, length: 5 )
• ADR_SUF ( type: esriFieldTypeString, alias: ADR_SUF, length: 6 )
• ADR_BLDG_I ( type: esriFieldTypeString, alias: ADR_BLDG_I, length: 10 )
• ADR_UNIT ( type: esriFieldTypeString, alias: ADR_UNIT, length: 20 )
• ADR_CITY ( type: esriFieldTypeString, alias: ADR_CITY, length: 50 )
• ADR_STATE ( type: esriFieldTypeString, alias: ADR_STATE, length: 20 )
• ADR_ZIP ( type: esriFieldTypeString, alias: ADR_ZIP, length: 10 )
• ADR_COUNTY ( type: esriFieldTypeString, alias: ADR_COUNTY, length: 20 )
• FLOOR_ID ( type: esriFieldTypeString, alias: FLOOR_ID, length: 10 )
• TOTAL_FLOO ( type: esriFieldTypeString, alias: TOTAL_FLOO, length: 10 )
• TOTAL_UNIT ( type: esriFieldTypeString, alias: TOTAL_UNIT, length: 10 )
• COM_NAME ( type: esriFieldTypeString, alias: COM_NAME, length: 100 )
• FAC_NAME ( type: esriFieldTypeString, alias: FAC_NAME, length: 100 )
• BUS_NAME ( type: esriFieldTypeString, alias: BUS_NAME, length: 100 )
• BUS_TYPE ( type: esriFieldTypeString, alias: BUS_TYPE, length: 100 )
• BUS_TYPE2 ( type: esriFieldTypeString, alias: BUS_TYPE2, length: 100 )
• ZONING ( type: esriFieldTypeString, alias: ZONING, length: 15 )
• YEAR_BUILT ( type: esriFieldTypeString, alias: YEAR_BUILT, length: 10 )
• JURISDICTI ( type: esriFieldTypeString, alias: JURISDICTI, length: 40 )
• JURISDIC_1 ( type: esriFieldTypeString, alias: JURISDIC_1, length: 40 )
• LABEL1 ( type: esriFieldTypeString, alias: LABEL1, length: 40 )
• LABEL2 ( type: esriFieldTypeString, alias: LABEL2, length: 40 )
• LABEL3 ( type: esriFieldTypeString, alias: LABEL3, length: 40 )
• LABEL4 ( type: esriFieldTypeString, alias: LABEL4, length: 40 )
• SOURCE_ID ( type: esriFieldTypeString, alias: SOURCE_ID, length: 120 )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, length: 120 )
• Subdivisio ( type: esriFieldTypeString, alias: Subdivisio, length: 25 )
• Sub_Sectio ( type: esriFieldTypeString, alias: Sub_Sectio, length: 5 )
• Sub_Lots ( type: esriFieldTypeString, alias: Sub_Lots, length: 5 )
• Sub_Block ( type: esriFieldTypeString, alias: Sub_Block, length: 5 )
• GC_Dist ( type: esriFieldTypeString, alias: GC_Dist, length: 10 )
• Voter_prec ( type: esriFieldTypeString, alias: Voter_prec, length: 10 )
• FEATURE ( type: esriFieldTypeString, alias: FEATURE, length: 50 )
• File_Name ( type: esriFieldTypeString, alias: File_Name, length: 50 )
• CP ( type: esriFieldTypeString, alias: CP, length: 5 )
• Unique_ID ( type: esriFieldTypeString, alias: Unique_ID, length: 25 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• LIFECYCLE ( type: esriFieldTypeString, alias: LIFECYCLE, length: 50 , Coded Values: [ACTIVE: ACTIVE] , [ABANDONED: ABANDONED] , [REMOVED: REMOVED] , ...1 more... )
• PostalCode ( type: esriFieldTypeString, alias: PostalCode, length: 10 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata