Name: GIS.XXDK_SAMS2_GIS_SITUS_STG_TBL

Display Field: STREET_NAME_LIFECYCLE_STATUS

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• STG_SITUS_ID ( type: esriFieldTypeOID, alias: STG_SITUS_ID, editable: false, nullable: false, defaultValue: null, modelName: STG_SITUS_ID )
• ADDRESS_ID ( type: esriFieldTypeString, alias: ADDRESS_ID, editable: true, nullable: false, length: 20, defaultValue: null, modelName: ADDRESS_ID )
• PARCEL_ID ( type: esriFieldTypeString, alias: PARCEL_ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PARCEL_ID )
• PRIMARY_SECONDARY ( type: esriFieldTypeString, alias: PRIMARY_SECONDARY, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PRIMARY_SECONDARY )
• TRAN_TYPE ( type: esriFieldTypeString, alias: TRAN_TYPE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: TRAN_TYPE )
• PROCESS_FLAG ( type: esriFieldTypeString, alias: PROCESS_FLAG, editable: true, nullable: true, length: 1, defaultValue: null, modelName: PROCESS_FLAG )
• PROCESSED_DATE ( type: esriFieldTypeDate, alias: PROCESSED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PROCESSED_DATE )
• SITUS_NUMBER ( type: esriFieldTypeString, alias: SITUS_NUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SITUS_NUMBER )
• SITUS_DIRECTION ( type: esriFieldTypeString, alias: SITUS_DIRECTION, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SITUS_DIRECTION )
• SITUS_PRE_TYPE ( type: esriFieldTypeString, alias: SITUS_PRE_TYPE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SITUS_PRE_TYPE )
• SITUS_STREET ( type: esriFieldTypeString, alias: SITUS_STREET, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SITUS_STREET )
• SUFFIX_TYPE_USPS ( type: esriFieldTypeString, alias: SUFFIX_TYPE_USPS, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SUFFIX_TYPE_USPS )
• SITUS_STREET_TYPE ( type: esriFieldTypeString, alias: SITUS_STREET_TYPE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SITUS_STREET_TYPE )
• SITUS_DIRECTION2 ( type: esriFieldTypeString, alias: SITUS_DIRECTION2, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SITUS_DIRECTION2 )
• UNIT_TYPE ( type: esriFieldTypeString, alias: UNIT_TYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UNIT_TYPE )
• SITUS_APARTMENT ( type: esriFieldTypeString, alias: SITUS_APARTMENT, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SITUS_APARTMENT )
• SITUS_CITY ( type: esriFieldTypeString, alias: SITUS_CITY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SITUS_CITY )
• SITUS_STATE ( type: esriFieldTypeString, alias: SITUS_STATE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SITUS_STATE )
• SITUS_ZIPCODE ( type: esriFieldTypeString, alias: SITUS_ZIPCODE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SITUS_ZIPCODE )
• POSTAL_PLUS4_CODE ( type: esriFieldTypeString, alias: POSTAL_PLUS4_CODE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: POSTAL_PLUS4_CODE )
• ADDRESS_TYPE ( type: esriFieldTypeString, alias: ADDRESS_TYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ADDRESS_TYPE )
• SPECIAL_NOTES ( type: esriFieldTypeString, alias: SPECIAL_NOTES, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SPECIAL_NOTES )
• SITUS_POINT_X ( type: esriFieldTypeDouble, alias: SITUS_POINT_X, editable: true, nullable: true, defaultValue: null, modelName: SITUS_POINT_X )
• SITUS_POINT_Y ( type: esriFieldTypeDouble, alias: SITUS_POINT_Y, editable: true, nullable: true, defaultValue: null, modelName: SITUS_POINT_Y )
• STREET_NAME_ID ( type: esriFieldTypeInteger, alias: STREET_NAME_ID, editable: true, nullable: true, defaultValue: null, modelName: STREET_NAME_ID )
• STREET_NAME_LIFECYCLE_STATUS ( type: esriFieldTypeString, alias: STREET_NAME_LIFECYCLE_STATUS, editable: true, nullable: true, length: 150, defaultValue: null, modelName: STREET_NAME_LIFECYCLE_STATUS )
• LOCATION_DESCRIPTION ( type: esriFieldTypeString, alias: LOCATION_DESCRIPTION, editable: true, nullable: true, length: 150, defaultValue: null, modelName: LOCATION_DESCRIPTION )
• OLD_STREET_ID ( type: esriFieldTypeDouble, alias: OLD_STREET_ID, editable: true, nullable: true, defaultValue: null, modelName: OLD_STREET_ID )
• FULL_STREET_NAME ( type: esriFieldTypeString, alias: FULL_STREET_NAME, editable: true, nullable: true, length: 70, defaultValue: null, modelName: FULL_STREET_NAME )
• CREATED_BY ( type: esriFieldTypeString, alias: CREATED_BY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CREATED_BY )
• CREATION_DATE ( type: esriFieldTypeDate, alias: CREATION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATION_DATE )
• LAST_UPDATED_BY ( type: esriFieldTypeString, alias: LAST_UPDATED_BY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LAST_UPDATED_BY )
• LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: LAST_UPDATE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_UPDATE_DATE )
• REASON_FOR_ERROR ( type: esriFieldTypeString, alias: REASON_FOR_ERROR, editable: true, nullable: true, length: 500, defaultValue: null, modelName: REASON_FOR_ERROR )
• HAN_PROCESS_FLAG ( type: esriFieldTypeString, alias: HAN_PROCESS_FLAG, editable: true, nullable: true, length: 1, defaultValue: null, modelName: HAN_PROCESS_FLAG )
• HAN_PROCESSED_DATE ( type: esriFieldTypeDate, alias: HAN_PROCESSED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: HAN_PROCESSED_DATE )
• HAN_LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: HAN_LAST_UPDATE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: HAN_LAST_UPDATE_DATE )
• HAN_LAST_UPDATED_BY ( type: esriFieldTypeString, alias: HAN_LAST_UPDATED_BY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: HAN_LAST_UPDATED_BY )
• OBJECTID ( type: esriFieldTypeString, alias: OBJECTID, editable: true, nullable: true, length: 150, defaultValue: null, modelName: OBJECTID )
• ADDRKEY ( type: esriFieldTypeInteger, alias: ADDRKEY, editable: true, nullable: true, defaultValue: null, modelName: ADDRKEY )
• HAN_REASON_FOR_ERROR ( type: esriFieldTypeString, alias: HAN_REASON_FOR_ERROR, editable: true, nullable: true, length: 256, defaultValue: null, modelName: HAN_REASON_FOR_ERROR )

Templates:

• Name: GIS.XXDK_SAMS2_GIS_SITUS_STG_TBL
  Description:
  Prototype:
  ADDRKEY: null
  HAN_REASON_FOR_ERROR: null
  ADDRESS_ID:
  PARCEL_ID: null
  PRIMARY_SECONDARY: null
  TRAN_TYPE: null
  PROCESS_FLAG: null
  PROCESSED_DATE: null
  SITUS_NUMBER: null
  SITUS_DIRECTION: null
  SITUS_PRE_TYPE: null
  SITUS_STREET: null
  SUFFIX_TYPE_USPS: null
  SITUS_STREET_TYPE: null
  SITUS_DIRECTION2: null
  UNIT_TYPE: null
  SITUS_APARTMENT: null
  SITUS_CITY: null
  SITUS_STATE: null
  SITUS_ZIPCODE: null
  POSTAL_PLUS4_CODE: null
  ADDRESS_TYPE: null
  SPECIAL_NOTES: null
  SITUS_POINT_X: null
  SITUS_POINT_Y: null
  STREET_NAME_ID: null
  STREET_NAME_LIFECYCLE_STATUS: null
  LOCATION_DESCRIPTION: null
  OLD_STREET_ID: null
  FULL_STREET_NAME: null
  CREATED_BY: null
  CREATION_DATE: null
  LAST_UPDATED_BY: null
  LAST_UPDATE_DATE: null
  REASON_FOR_ERROR: null
  HAN_PROCESS_FLAG: null
  HAN_PROCESSED_DATE: null
  HAN_LAST_UPDATE_DATE: null
  HAN_LAST_UPDATED_BY: null
  OBJECTID: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

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

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata