{ "currentVersion": 10.91, "id": 2, "name": "GIS.XXDK_SAMS2_GIS_SITUS_STG_TBL", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "STG_SITUS_ID", "globalIdField": "", "displayField": "STREET_NAME_LIFECYCLE_STATUS", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "STG_SITUS_ID", "type": "esriFieldTypeOID", "alias": "STG_SITUS_ID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "STG_SITUS_ID" }, { "name": "ADDRESS_ID", "type": "esriFieldTypeString", "alias": "ADDRESS_ID", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "ADDRESS_ID" }, { "name": "PARCEL_ID", "type": "esriFieldTypeString", "alias": "PARCEL_ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PARCEL_ID" }, { "name": "PRIMARY_SECONDARY", "type": "esriFieldTypeString", "alias": "PRIMARY_SECONDARY", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PRIMARY_SECONDARY" }, { "name": "TRAN_TYPE", "type": "esriFieldTypeString", "alias": "TRAN_TYPE", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "TRAN_TYPE" }, { "name": "PROCESS_FLAG", "type": "esriFieldTypeString", "alias": "PROCESS_FLAG", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "PROCESS_FLAG" }, { "name": "PROCESSED_DATE", "type": "esriFieldTypeDate", "alias": "PROCESSED_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PROCESSED_DATE" }, { "name": "SITUS_NUMBER", "type": "esriFieldTypeString", "alias": "SITUS_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SITUS_NUMBER" }, { "name": "SITUS_DIRECTION", "type": "esriFieldTypeString", "alias": "SITUS_DIRECTION", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SITUS_DIRECTION" }, { "name": "SITUS_PRE_TYPE", "type": "esriFieldTypeString", "alias": "SITUS_PRE_TYPE", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "SITUS_PRE_TYPE" }, { "name": "SITUS_STREET", "type": "esriFieldTypeString", "alias": "SITUS_STREET", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "SITUS_STREET" }, { "name": "SUFFIX_TYPE_USPS", "type": "esriFieldTypeString", "alias": "SUFFIX_TYPE_USPS", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SUFFIX_TYPE_USPS" }, { "name": "SITUS_STREET_TYPE", "type": "esriFieldTypeString", "alias": "SITUS_STREET_TYPE", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "SITUS_STREET_TYPE" }, { "name": "SITUS_DIRECTION2", "type": "esriFieldTypeString", "alias": "SITUS_DIRECTION2", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SITUS_DIRECTION2" }, { "name": "UNIT_TYPE", "type": "esriFieldTypeString", "alias": "UNIT_TYPE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "UNIT_TYPE" }, { "name": "SITUS_APARTMENT", "type": "esriFieldTypeString", "alias": "SITUS_APARTMENT", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "SITUS_APARTMENT" }, { "name": "SITUS_CITY", "type": "esriFieldTypeString", "alias": "SITUS_CITY", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "SITUS_CITY" }, { "name": "SITUS_STATE", "type": "esriFieldTypeString", "alias": "SITUS_STATE", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "SITUS_STATE" }, { "name": "SITUS_ZIPCODE", "type": "esriFieldTypeString", "alias": "SITUS_ZIPCODE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SITUS_ZIPCODE" }, { "name": "POSTAL_PLUS4_CODE", "type": "esriFieldTypeString", "alias": "POSTAL_PLUS4_CODE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "POSTAL_PLUS4_CODE" }, { "name": "ADDRESS_TYPE", "type": "esriFieldTypeString", "alias": "ADDRESS_TYPE", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "ADDRESS_TYPE" }, { "name": "SPECIAL_NOTES", "type": "esriFieldTypeString", "alias": "SPECIAL_NOTES", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "SPECIAL_NOTES" }, { "name": "SITUS_POINT_X", "type": "esriFieldTypeDouble", "alias": "SITUS_POINT_X", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SITUS_POINT_X" }, { "name": "SITUS_POINT_Y", "type": "esriFieldTypeDouble", "alias": "SITUS_POINT_Y", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SITUS_POINT_Y" }, { "name": "STREET_NAME_ID", "type": "esriFieldTypeInteger", "alias": "STREET_NAME_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STREET_NAME_ID" }, { "name": "STREET_NAME_LIFECYCLE_STATUS", "type": "esriFieldTypeString", "alias": "STREET_NAME_LIFECYCLE_STATUS", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "STREET_NAME_LIFECYCLE_STATUS" }, { "name": "LOCATION_DESCRIPTION", "type": "esriFieldTypeString", "alias": "LOCATION_DESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "LOCATION_DESCRIPTION" }, { "name": "OLD_STREET_ID", "type": "esriFieldTypeDouble", "alias": "OLD_STREET_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OLD_STREET_ID" }, { "name": "FULL_STREET_NAME", "type": "esriFieldTypeString", "alias": "FULL_STREET_NAME", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "FULL_STREET_NAME" }, { "name": "CREATED_BY", "type": "esriFieldTypeString", "alias": "CREATED_BY", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CREATED_BY" }, { "name": "CREATION_DATE", "type": "esriFieldTypeDate", "alias": "CREATION_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATION_DATE" }, { "name": "LAST_UPDATED_BY", "type": "esriFieldTypeString", "alias": "LAST_UPDATED_BY", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "LAST_UPDATED_BY" }, { "name": "LAST_UPDATE_DATE", "type": "esriFieldTypeDate", "alias": "LAST_UPDATE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_UPDATE_DATE" }, { "name": "REASON_FOR_ERROR", "type": "esriFieldTypeString", "alias": "REASON_FOR_ERROR", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "REASON_FOR_ERROR" }, { "name": "HAN_PROCESS_FLAG", "type": "esriFieldTypeString", "alias": "HAN_PROCESS_FLAG", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "HAN_PROCESS_FLAG" }, { "name": "HAN_PROCESSED_DATE", "type": "esriFieldTypeDate", "alias": "HAN_PROCESSED_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "HAN_PROCESSED_DATE" }, { "name": "HAN_LAST_UPDATE_DATE", "type": "esriFieldTypeDate", "alias": "HAN_LAST_UPDATE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "HAN_LAST_UPDATE_DATE" }, { "name": "HAN_LAST_UPDATED_BY", "type": "esriFieldTypeString", "alias": "HAN_LAST_UPDATED_BY", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "HAN_LAST_UPDATED_BY" }, { "name": "OBJECTID", "type": "esriFieldTypeString", "alias": "OBJECTID", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ADDRKEY", "type": "esriFieldTypeInteger", "alias": "ADDRKEY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ADDRKEY" }, { "name": "HAN_REASON_FOR_ERROR", "type": "esriFieldTypeString", "alias": "HAN_REASON_FOR_ERROR", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "HAN_REASON_FOR_ERROR" } ], "indexes": [ { "name": "R7987_SDE_ROWID_UK", "fields": "STG_SITUS_ID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "GIS.XXDK_SAMS2_GIS_SITUS_STG_TBL", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }