Name: Address

Display Field: L1_str_name

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• source_seq_nbr (type: esriFieldTypeInteger, alias: Source Sequence Number, SQL Type: sqlTypeOther, nullable: false, editable: true)
• L1_primary_addr_flg (type: esriFieldTypeString, alias: Primary Address Flag, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• L1_hse_nbr_start (type: esriFieldTypeInteger, alias: House Number Start, SQL Type: sqlTypeOther, nullable: true, editable: true)
• L1_hse_nbr_end (type: esriFieldTypeInteger, alias: House Number End, SQL Type: sqlTypeOther, nullable: true, editable: true)
• L1_hse_frac_nbr_start (type: esriFieldTypeString, alias: House Fraction Number Start, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [1/2: 1/2], [1/4: 1/4], [3/4: 3/4], ... 7 more ...)
• L1_hse_frac_nbr_end (type: esriFieldTypeString, alias: House Fraction Number End, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• L1_unit_start (type: esriFieldTypeString, alias: Unit Start, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• L1_unit_end (type: esriFieldTypeString, alias: Unit End, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• L1_unit_type (type: esriFieldTypeString, alias: Unit Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Apt: Apartment], [Area: Area], [Bldg: Building], ... 32 more ...)
• L1_str_dir (type: esriFieldTypeString, alias: Street Direction, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [E: E], [N: N], [S: S], ... 5 more ...)
• L1_str_name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 160, nullable: true, editable: true)
• L1_str_prefix (type: esriFieldTypeString, alias: Street Prefix, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Aly: Alley], [Anx: Annex], [Arc: Arcade], ... 196 more ...)
• L1_str_suffix (type: esriFieldTypeString, alias: Street Suffix, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true, Coded Values: [Aly: Alley], [Anx: Annex], [Arc: Arcade], ... 196 more ...)
• L1_str_suffix_dir (type: esriFieldTypeString, alias: Street Suffix Direction, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [E: E], [N: N], [S: S], ... 5 more ...)
• L1_insp_district_prefix (type: esriFieldTypeString, alias: Inspection District Prefix, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• L1_insp_district (type: esriFieldTypeString, alias: Inspection District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• L1_situs_nbrhd_prefix (type: esriFieldTypeString, alias: Situs Neighborhood Prefix, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• L1_situs_nbrhd (type: esriFieldTypeString, alias: Situs Neighborhood, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• L1_situs_city (type: esriFieldTypeString, alias: Situs City, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• L1_situs_county (type: esriFieldTypeString, alias: Situs County, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• L1_situs_state (type: esriFieldTypeString, alias: Situs State, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• L1_situs_zip (type: esriFieldTypeString, alias: Situs ZIP, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• L1_situs_country (type: esriFieldTypeString, alias: Situs Country, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• L1_x_coord (type: esriFieldTypeDouble, alias: X-Coordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• L1_y_coord (type: esriFieldTypeDouble, alias: Y-Coordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• L1_addr_status (type: esriFieldTypeString, alias: Address Status, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [A: A], [I: I])
• L1_addr_desc (type: esriFieldTypeString, alias: Address Description, SQL Type: sqlTypeOther, length: 1020, nullable: true, editable: true)
• rec_date (type: esriFieldTypeDate, alias: Record Date, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)
• L1_situs_country_code (type: esriFieldTypeString, alias: Situs Country Code, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• L1_full_address (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• ext_uid (type: esriFieldTypeString, alias: External Unique ID, SQL Type: sqlTypeOther, length: 400, nullable: true, editable: true)
• L1_address1 (type: esriFieldTypeString, alias: Address 1, SQL Type: sqlTypeOther, length: 800, nullable: true, editable: true)
• L1_address2 (type: esriFieldTypeString, alias: Address 2, SQL Type: sqlTypeOther, length: 800, nullable: true, editable: true)
• L1_validate_addr_flag (type: esriFieldTypeString, alias: Validate Address Flag, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)

Templates:

Name: Address
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• source_seq_nbr: 0
• L1_addr_status: A

Relationships:

• Address_Type (0) -- Related To: Address_Type (12)
• X_Parcel_Address (1) -- Related To: X_Parcel_Address (33)
• Address_Attribute (2) -- Related To: Address_Attribute (11)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/22/2026 3:07:58 PM

Schema Last Edit Date: 11/10/2025 10:38:42 PM

Data Last Edit Date: 9/22/2026 3:07:58 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat