Layers:

Layer: BaytownGIS.SDE.BT_Address (0)


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.

Fields

2014-09-05 Created new version 4

added 1200 poins from the Chambers addresspoint file into this file and populated the fields correctly

2015-12-31 Corrected street types in some areas

2017-0702 - Added fields to collect data on each address

Feature - Address feature represents following - lot - building - garage - parking lot - boat launch etc

Common Name - Residential - retail - Commercial - Industrial

Fac Name - House, apartment - RV - MOBILE HOME - WAREHOUSE - ETC

BUS NAME -

2019-10-09 BOB EXISTING FIELDS

1	ESRI Fields	OBJECTID		OBJECTID
2		AREA		Double
3		PERIMETER		Double
4	County identification number Book/Page/Block/Lot	HCAD_OLD	HARRIS COUNTY APPRAISAL DISTRICT PARENT ID	Text / 13
5		HCAD_NUMBE	HARRIS COUNTY APPRAISAL DISTRICT 13 CHARACTER NUMBER	Text / 13
6		CCAD_OLD	Chambers County Appraisal District Parent ID	Text / 13
7		CCAD_NUMBE	Chambers County Appraisal District Lot number	Text / 13
8	Complete Address Fields	ADR_OLD	Previous Address of the property	Text / 50
9		ADR_NOW	Present Address of the property	Text / 75
10		ADR_NUM	The actual number of the property (according to the mail box)	Text / 10
11		ADR_FRAC	Fractional part (1/8,1/2, 1/5, 1/7)	Text / 6
12		ADR_PREFIX	N, E, S, W	Text / 6
13		ADR_STREET	Street Name according to recorded documents	Text / 50
14		ADR_TYPE	Street Type according to recorded documents	Text / 5
15		ADR_SUF	N, E, S, W	Text / 6
16		ADR_BLDG_I	Building number if more than 1 on property (Apartments and Commercial)	Text / 10
17		ADR_UNIT	Unit Number (1, 2, 3, A, B, C)	Text / 10
18		ADR_CITY	City the property is located. If not "COUNTY"	Text / 50
19		ADR_STATE	State the property is located	Text / 20
20		ADR_ZIP	USPS Zip Code the property is located	Text / 10
21		ADR_COUNTY	County the property is located	Text / 20
22		JURISDICTI	Jurisdiction the property resides in (City, District, County)	Text / 40
23	Property Descriptive Information	FLOOR_ID	The floor of the unit If building has multiple floors Blank id single story	Text / 10
24		TOTAL_FLOO	Total floors in the building	Text / 10
25		TOTAL_UNIT	Total Units in the building	Text / 10
26		FEATURE	Looking at the property, What is it. (Building, structure, Dock, Sign, tower)	Text / 50
27		COM_NAME	Residential, Commercial, Industrial,	Text / 100
28		FAC_NAME	Common Name (House, apartment, retail space, Mobile home, RV)	Text / 100
29		BUS_NAME	Name of the Property, Bob's Apt's, Nathans zoning school, Harolds Patience Center	Text / 100
30		BUS_TYPE	Automotive, Medical, Retail, Trucking	Text / 100
31		BUS_TYPE2	Other descriptive COMPLEX NAME	Text / 100
32		YEAR_BUILT	Year the parcel or existing structure was created(Plat) or built	Text / 10
33	Other Districts	USE_DESCR	Special requirements of the property (RIZ Zone)	Text / 40
34		ZONING	Zoning of the property	Text / 15
35		JURISDIC_1	Council District Number the property resides in if in the City	Text / 40
36		GC_Dist	Goose Creek School District	Text / 10
37		Voter_prec	Voter Precinct of the property	Text / 10
38	Map Labeling	LABEL1	Main Address Number	Text / 40
39		LABEL2	Unit Number (1, 2, 3, A, B, C)	Text / 40
40		LABEL3	Building number if more than 1 on property (Apartments)	Text / 40
41		LABEL4	Name of the property(Subdivision, Commercial name, Park name)	Text / 40
42	Other Software Connections	CP	Is the address in Community Plus	Text / 5
43		Unique_ID	Unique identification of City Works	Text / 25
44	Source of Information	SOURCE_ID	Source of the data	Text /120
45		RECORD_ID	Identification if known of source data	Text / 50
46		COMMENT	Something not covered by present fields	Text / 120
47		USER_FLAG1	Editor use 1	Text / 20
48		USER_FLAG2	Editor use 2	Text / 20
49	GPS Information	X_COORD	GPS coordinate	Double / 12 / 3
50		Y_COORD	GPS coordinate	Double / 12 / 3
51		Z_COORD	GPS coordinate of elevation	Double / 12 / 3
52	Recorded Documents	Subdivisio	Name of the document the property was created	Text / 20
53		Sub_Sectio	The subsection the property was created from	Text / 5
54		Sub_Block	The block number the property was subdivided from	Text / 5
55		Sub_Lots	The lot number of the existing property	Text / 5
56	User Information	DATE_MOD1	Latest editing	Text / 10
57		DATE_MOD2	Previous editing	Text / 10
58		EDITOR	Editor	Text / 10
59		created_us
60		created_da
61		last_edite
62		last_edi_1
63		created__1
64		created__2
65		last_edi_2
66		last_edi_3



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: 3210727.03345031
YMin: 13808850.2476269
XMax: 3306217.82934497
YMax: 13890747.9046974
Spatial Reference: 102740 (2278)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[45,154,173,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

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)
• AREA (type: esriFieldTypeDouble, alias: BaytownGIS.SDE.BT_Address.AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERIMETER (type: esriFieldTypeDouble, alias: PERIMETER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HCAD_OLD (type: esriFieldTypeString, alias: HCAD_OLD, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
• HCAD_NUMBE (type: esriFieldTypeString, alias: HCAD_NUMBE, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
• CCAD_OLD (type: esriFieldTypeString, alias: CCAD_OLD, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
• CCAD_NUMBE (type: esriFieldTypeString, alias: CCAD_NUMBE, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
• ADR_OLD (type: esriFieldTypeString, alias: ADR_OLD, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ADR_NOW (type: esriFieldTypeString, alias: ADR_NOW, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ADR_NUM (type: esriFieldTypeString, alias: ADR_NUM, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ADR_FRAC (type: esriFieldTypeString, alias: ADR_FRAC, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• ADR_PREFIX (type: esriFieldTypeString, alias: ADR_PREFIX, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• ADR_STREET (type: esriFieldTypeString, alias: ADR_STREET, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ADR_TYPE (type: esriFieldTypeString, alias: ADR_TYPE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• ADR_SUF (type: esriFieldTypeString, alias: ADR_SUF, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• ADR_BLDG_I (type: esriFieldTypeString, alias: ADR_BLDG_I, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ADR_UNIT (type: esriFieldTypeString, alias: ADR_UNIT, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ADR_CITY (type: esriFieldTypeString, alias: ADR_CITY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ADR_STATE (type: esriFieldTypeString, alias: ADR_STATE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ADR_ZIP (type: esriFieldTypeString, alias: ADR_ZIP, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ADR_COUNTY (type: esriFieldTypeString, alias: ADR_COUNTY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FLOOR_ID (type: esriFieldTypeString, alias: FLOOR_ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• TOTAL_FLOO (type: esriFieldTypeString, alias: TOTAL_FLOO, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• TOTAL_UNIT (type: esriFieldTypeString, alias: TOTAL_UNIT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• COM_NAME (type: esriFieldTypeString, alias: COM_NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FAC_NAME (type: esriFieldTypeString, alias: FAC_NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BUS_NAME (type: esriFieldTypeString, alias: BUS_NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BUS_TYPE (type: esriFieldTypeString, alias: BUS_TYPE, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BUS_TYPE2 (type: esriFieldTypeString, alias: BUS_TYPE2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ZONING (type: esriFieldTypeString, alias: ZONING, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• YEAR_BUILT (type: esriFieldTypeString, alias: YEAR_BUILT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• USE_DESCR (type: esriFieldTypeString, alias: USE_DESCR, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• JURISDICTI (type: esriFieldTypeString, alias: JURISDICTI, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• JURISDIC_1 (type: esriFieldTypeString, alias: JURISDIC_1, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LABEL1 (type: esriFieldTypeString, alias: LABEL1, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LABEL2 (type: esriFieldTypeString, alias: LABEL2, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LABEL3 (type: esriFieldTypeString, alias: LABEL3, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LABEL4 (type: esriFieldTypeString, alias: LABEL4, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• DATE_MOD1 (type: esriFieldTypeString, alias: DATE_MOD1, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DATE_MOD2 (type: esriFieldTypeString, alias: DATE_MOD2, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• EDITOR (type: esriFieldTypeString, alias: EDITOR, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SOURCE_ID (type: esriFieldTypeString, alias: SOURCE_ID, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• COMMENT (type: esriFieldTypeString, alias: COMMENT, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• USER_FLAG1 (type: esriFieldTypeString, alias: USER_FLAG1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• USER_FLAG2 (type: esriFieldTypeString, alias: USER_FLAG2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RECORD_ID (type: esriFieldTypeString, alias: RECORD_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• X_COORD (type: esriFieldTypeDouble, alias: X_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y_COORD (type: esriFieldTypeDouble, alias: Y_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Z_COORD (type: esriFieldTypeDouble, alias: Z_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Subdivisio (type: esriFieldTypeString, alias: Subdivisio, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Sub_Sectio (type: esriFieldTypeString, alias: Sub_Sectio, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Sub_Lots (type: esriFieldTypeString, alias: Sub_Lots, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• created_us (type: esriFieldTypeString, alias: created_us, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• created_da (type: esriFieldTypeDate, alias: created_da, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edite (type: esriFieldTypeString, alias: last_edite, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• last_edi_1 (type: esriFieldTypeDate, alias: last_edi_1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Sub_Block (type: esriFieldTypeString, alias: Sub_Block, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• GC_Dist (type: esriFieldTypeString, alias: GC_Dist, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Voter_prec (type: esriFieldTypeString, alias: Voter_prec, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FEATURE (type: esriFieldTypeString, alias: FEATURE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• File_Name (type: esriFieldTypeString, alias: File_Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CP (type: esriFieldTypeString, alias: CP, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Unique_ID (type: esriFieldTypeString, alias: Unique_ID, SQL Type: sqlTypeOther, length: 25, 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)
• LIFECYCLE (type: esriFieldTypeString, alias: LIFECYCLE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ACTIVE: ACTIVE], [ABANDONED: ABANDONED], [REMOVED: REMOVED], ... 1 more ...)
• PostalCode (type: esriFieldTypeString, alias: PostalCode, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)

Templates:

Name: BaytownGIS.SDE.BT_Address
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• LIFECYCLE: ACTIVE

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/3/2021 8:27:23 PM

Schema Last Edit Date: 3/3/2021 8:27:23 PM

Data Last Edit Date: 3/3/2021 8:27:23 PM