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:

• 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 )
• 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 )
• ZIPCODE ( type: esriFieldTypeDouble, alias: Zip Code, editable: false, nullable: true, defaultValue: null, modelName: ZIPCODE )
• SSL ( type: esriFieldTypeString, alias: Square, Suffix, Lot, editable: false, nullable: true, length: 12, defaultValue: null, modelName: SSL )
• 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 )
• STREET_TYPE ( type: esriFieldTypeString, alias: Street Type, editable: false, nullable: true, length: 50, defaultValue: null, modelName: STREET_TYPE )
• METADATA_ID ( type: esriFieldTypeDouble, alias: Metadata Identifier, editable: false, nullable: true, defaultValue: null, modelName: METADATA_ID )
• WARD ( type: esriFieldTypeString, alias: Ward, editable: false, nullable: true, length: 25, defaultValue: null, modelName: WARD )
• HAS_SSL ( type: esriFieldTypeString, alias: Has Square, Suffix, Lot, editable: false, nullable: true, length: 1, defaultValue: null, modelName: HAS_SSL )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: false, nullable: true, length: 15, defaultValue: null, modelName: STATUS )
• 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 )
• MAR_ID ( type: esriFieldTypeDouble, alias: Master Address Repository Identifier, editable: false, nullable: true, defaultValue: null, modelName: MAR_ID )
• 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: Route Identifier, editable: false, nullable: true, length: 50, defaultValue: null, modelName: ROUTEID )
• BLOCKKEY ( type: esriFieldTypeString, alias: Block Key, editable: false, nullable: true, length: 100, defaultValue: null, modelName: BLOCKKEY )
• SUBBLOCKKEY ( type: esriFieldTypeString, alias: SubBlock Key, 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: Square, Suffix, Lot 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 Square, Suffix, Lot, 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 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, precision: 1, defaultValue: null, modelName: LAST_EDITED_DATE )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, length: 8, defaultValue: null, modelName: OBJECTID )

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