Name: GIS.XXDK_SAMS2_GIS_SITUS_STG_TBL
Display Field: STREET_NAME_LIFECYCLE_STATUS
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
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
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
STG_SITUS_ID
(
type: esriFieldTypeOID, alias: STG_SITUS_ID
)
-
ADDRESS_ID
(
type: esriFieldTypeString, alias: ADDRESS_ID, length: 20
)
-
PARCEL_ID
(
type: esriFieldTypeString, alias: PARCEL_ID, length: 30
)
-
PRIMARY_SECONDARY
(
type: esriFieldTypeString, alias: PRIMARY_SECONDARY, length: 15
)
-
TRAN_TYPE
(
type: esriFieldTypeString, alias: TRAN_TYPE, length: 1
)
-
PROCESS_FLAG
(
type: esriFieldTypeString, alias: PROCESS_FLAG, length: 1
)
-
PROCESSED_DATE
(
type: esriFieldTypeDate, alias: PROCESSED_DATE, length: 8
)
-
SITUS_NUMBER
(
type: esriFieldTypeString, alias: SITUS_NUMBER, length: 20
)
-
SITUS_DIRECTION
(
type: esriFieldTypeString, alias: SITUS_DIRECTION, length: 5
)
-
SITUS_PRE_TYPE
(
type: esriFieldTypeString, alias: SITUS_PRE_TYPE, length: 1
)
-
SITUS_STREET
(
type: esriFieldTypeString, alias: SITUS_STREET, length: 75
)
-
SUFFIX_TYPE_USPS
(
type: esriFieldTypeString, alias: SUFFIX_TYPE_USPS, length: 5
)
-
SITUS_STREET_TYPE
(
type: esriFieldTypeString, alias: SITUS_STREET_TYPE, length: 15
)
-
SITUS_DIRECTION2
(
type: esriFieldTypeString, alias: SITUS_DIRECTION2, length: 5
)
-
UNIT_TYPE
(
type: esriFieldTypeString, alias: UNIT_TYPE, length: 10
)
-
SITUS_APARTMENT
(
type: esriFieldTypeString, alias: SITUS_APARTMENT, length: 15
)
-
SITUS_CITY
(
type: esriFieldTypeString, alias: SITUS_CITY, length: 30
)
-
SITUS_STATE
(
type: esriFieldTypeString, alias: SITUS_STATE, length: 2
)
-
SITUS_ZIPCODE
(
type: esriFieldTypeString, alias: SITUS_ZIPCODE, length: 10
)
-
POSTAL_PLUS4_CODE
(
type: esriFieldTypeString, alias: POSTAL_PLUS4_CODE, length: 10
)
-
ADDRESS_TYPE
(
type: esriFieldTypeString, alias: ADDRESS_TYPE, length: 30
)
-
SPECIAL_NOTES
(
type: esriFieldTypeString, alias: SPECIAL_NOTES, length: 200
)
-
SITUS_POINT_X
(
type: esriFieldTypeDouble, alias: SITUS_POINT_X
)
-
SITUS_POINT_Y
(
type: esriFieldTypeDouble, alias: SITUS_POINT_Y
)
-
STREET_NAME_ID
(
type: esriFieldTypeInteger, alias: STREET_NAME_ID
)
-
STREET_NAME_LIFECYCLE_STATUS
(
type: esriFieldTypeString, alias: STREET_NAME_LIFECYCLE_STATUS, length: 150
)
-
LOCATION_DESCRIPTION
(
type: esriFieldTypeString, alias: LOCATION_DESCRIPTION, length: 150
)
-
OLD_STREET_ID
(
type: esriFieldTypeDouble, alias: OLD_STREET_ID
)
-
FULL_STREET_NAME
(
type: esriFieldTypeString, alias: FULL_STREET_NAME, length: 70
)
-
CREATED_BY
(
type: esriFieldTypeString, alias: CREATED_BY, length: 30
)
-
CREATION_DATE
(
type: esriFieldTypeDate, alias: CREATION_DATE, length: 8
)
-
LAST_UPDATED_BY
(
type: esriFieldTypeString, alias: LAST_UPDATED_BY, length: 30
)
-
LAST_UPDATE_DATE
(
type: esriFieldTypeDate, alias: LAST_UPDATE_DATE, length: 8
)
-
REASON_FOR_ERROR
(
type: esriFieldTypeString, alias: REASON_FOR_ERROR, length: 500
)
-
HAN_PROCESS_FLAG
(
type: esriFieldTypeString, alias: HAN_PROCESS_FLAG, length: 1
)
-
HAN_PROCESSED_DATE
(
type: esriFieldTypeDate, alias: HAN_PROCESSED_DATE, length: 8
)
-
HAN_LAST_UPDATE_DATE
(
type: esriFieldTypeDate, alias: HAN_LAST_UPDATE_DATE, length: 8
)
-
HAN_LAST_UPDATED_BY
(
type: esriFieldTypeString, alias: HAN_LAST_UPDATED_BY, length: 30
)
-
OBJECTID
(
type: esriFieldTypeString, alias: OBJECTID, length: 150
)
-
ADDRKEY
(
type: esriFieldTypeInteger, alias: ADDRKEY
)
-
HAN_REASON_FOR_ERROR
(
type: esriFieldTypeString, alias: HAN_REASON_FOR_ERROR, length: 256
)
Supported Operations:
Query
Query Attachments
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata