Name: Address Table

Display Field: STREET_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 15 )
• SSL ( type: esriFieldTypeString, alias: SSL, length: 12 )
• STREET_TYPE ( type: esriFieldTypeString, alias: STREET_TYPE, length: 50 )
• QUADRANT ( type: esriFieldTypeString, alias: QUADRANT, length: 2 )
• CITY ( type: esriFieldTypeString, alias: CITY, length: 25 )
• STATE ( type: esriFieldTypeString, alias: STATE, length: 25 )
• METADATA_ID ( type: esriFieldTypeDouble, alias: METADATA_ID )
• WARD ( type: esriFieldTypeString, alias: WARD, length: 25 )
• SQUARE ( type: esriFieldTypeString, alias: SQUARE, length: 4 )
• SUFFIX ( type: esriFieldTypeString, alias: SUFFIX, length: 4 )
• LOT ( type: esriFieldTypeString, alias: LOT, length: 4 )
• ZIPCODE ( type: esriFieldTypeDouble, alias: ZIPCODE )
• HAS_SSL ( type: esriFieldTypeString, alias: HAS_SSL, length: 1 )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• MAR_ID ( type: esriFieldTypeDouble, alias: MAR_ID )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 255 )
• ADDRESS_NUMBER ( type: esriFieldTypeInteger, alias: ADDRESS_NUMBER )
• ADDRESS_NUMBER_SUFFIX ( type: esriFieldTypeString, alias: ADDRESS_NUMBER_SUFFIX, length: 6 )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 30 )
• COUNTRY ( type: esriFieldTypeString, alias: COUNTRY, length: 50 )
• X_COORDINATE ( type: esriFieldTypeDouble, alias: X_COORDINATE )
• Y_COORDINATE ( type: esriFieldTypeDouble, alias: Y_COORDINATE )
• ADDRESS_TYPE ( type: esriFieldTypeString, alias: ADDRESS_TYPE, length: 30 )
• ROUTEID ( type: esriFieldTypeString, alias: ROUTEID, length: 50 )
• BLOCKKEY ( type: esriFieldTypeString, alias: BLOCKKEY, length: 100 )
• SUBBLOCKKEY ( type: esriFieldTypeString, alias: SUBBLOCKKEY, length: 100 )
• NATIONAL_GRID ( type: esriFieldTypeString, alias: NATIONAL_GRID, length: 20 )
• HAS_PLACE_NAME ( type: esriFieldTypeString, alias: HAS_PLACE_NAME, length: 1 )
• HAS_CONDO ( type: esriFieldTypeString, alias: HAS_CONDO, length: 1 )
• HAS_RESIDENTIAL_UNIT ( type: esriFieldTypeString, alias: HAS_RESIDENTIAL_UNIT, length: 1 )
• STREET_VIEW_URL ( type: esriFieldTypeString, alias: STREET_VIEW_URL, length: 200 )
• RESIDENTIAL_TYPE ( type: esriFieldTypeString, alias: RESIDENTIAL_TYPE, length: 20 )
• PLACEMENT ( type: esriFieldTypeString, alias: PLACEMENT, length: 25 )
• SSL_ALIGNMENT ( type: esriFieldTypeString, alias: SSL_ALIGNMENT, length: 20 )
• BUILDING ( type: esriFieldTypeString, alias: BUILDING, length: 20 )
• MULTIPLE_LAND_SSL ( type: esriFieldTypeString, alias: MULTIPLE_LAND_SSL, length: 20 )
• GRID_DIRECTION ( type: esriFieldTypeString, alias: GRID_DIRECTION, length: 20 )
• HOUSING_UNIT_COUNT ( type: esriFieldTypeDouble, alias: HOUSING_UNIT_COUNT )
• RESIDENTIAL_UNIT_COUNT ( type: esriFieldTypeDouble, alias: RESIDENTIAL_UNIT_COUNT )
• BEFORE_DATE ( type: esriFieldTypeDate, alias: BEFORE_DATE, length: 8 )
• BEFORE_DATE_SOURCE ( type: esriFieldTypeString, alias: BEFORE_DATE_SOURCE, length: 25 )
• BEGIN_DATE ( type: esriFieldTypeDate, alias: BEGIN_DATE, length: 8 )
• BEGIN_DATE_SOURCE ( type: esriFieldTypeString, alias: BEGIN_DATE_SOURCE, length: 25 )
• FIRST_KNOWN_DATE ( type: esriFieldTypeDate, alias: FIRST_KNOWN_DATE, length: 8 )
• FIRST_KNOWN_DATE_SOURCE ( type: esriFieldTypeString, alias: FIRST_KNOWN_DATE_SOURCE, length: 25 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 25 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 25 )

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

  Iteminfo   Thumbnail   Metadata