Name: dbo.AP_ADDRESS_V

Display Field: CITY_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: GID

Unique ID Field:

Name : GID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• GID (type: esriFieldTypeOID, alias: GID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PARCEL_ID (type: esriFieldTypeInteger, alias: PARCEL_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDRESS_ID (type: esriFieldTypeInteger, alias: ADDRESS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GRIDNUMBER (type: esriFieldTypeString, alias: GRIDNUMBER, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• SNO (type: esriFieldTypeInteger, alias: SNO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TYPE (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• UNIT_NO (type: esriFieldTypeString, alias: UNIT_NO, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• STREET (type: esriFieldTypeString, alias: STREET, SQL Type: sqlTypeOther, length: 65, nullable: true, editable: true)
• CITY_NAME (type: esriFieldTypeString, alias: CITY_NAME, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SZIP (type: esriFieldTypeInteger, alias: SZIP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NEIGHBORHOOD (type: esriFieldTypeString, alias: NEIGHBORHOOD, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• NAME_FULL (type: esriFieldTypeString, alias: NAME_FULL, SQL Type: sqlTypeOther, length: 113, nullable: true, editable: true)
• NAME_DIR (type: esriFieldTypeString, alias: NAME_DIR, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• NAME_BASE (type: esriFieldTypeString, alias: NAME_BASE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NAME_TYPE (type: esriFieldTypeString, alias: NAME_TYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• NAME_DIR2 (type: esriFieldTypeString, alias: NAME_DIR2, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• ADDRESS_FULL (type: esriFieldTypeString, alias: ADDRESS_FULL, SQL Type: sqlTypeOther, length: 144, nullable: true, editable: true)
• X (type: esriFieldTypeInteger, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeInteger, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TS (type: esriFieldTypeString, alias: TS, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• USER_MOD (type: esriFieldTypeString, alias: USER_MOD, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• CENSUS_TYPE (type: esriFieldTypeString, alias: CENSUS_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ZIP4 (type: esriFieldTypeInteger, alias: ZIP4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OWNER_OCCUPIED (type: esriFieldTypeInteger, alias: OWNER_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• XMIN (type: esriFieldTypeInteger, alias: XMIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YMIN (type: esriFieldTypeInteger, alias: YMIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• XMAX (type: esriFieldTypeInteger, alias: XMAX, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YMAX (type: esriFieldTypeInteger, alias: YMAX, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AddressMSAG (type: esriFieldTypeString, alias: AddressMSAG, SQL Type: sqlTypeOther, length: 192, nullable: true, editable: true)
• AddressShort (type: esriFieldTypeString, alias: AddressShort, SQL Type: sqlTypeOther, length: 96, nullable: true, editable: true)
• AddressMetro (type: esriFieldTypeString, alias: AddressMetro, SQL Type: sqlTypeOther, length: 112, nullable: true, editable: true)

Templates:

Name: dbo.AP_ADDRESS_V
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/1/2023 11:42:38 PM

Schema Last Edit Date: 8/1/2023 11:42:38 PM

Data Last Edit Date: 8/1/2023 11:42:38 PM

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