Name: Address Table

Display Field: STREET_NAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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: true
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: false
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:

Fields:

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

Templates:

• Name: Address Table
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata