{ "currentVersion": 10.91, "id": 1, "name": "Mobile_CAMA.DBO.v_gis_cama_mobile_structures", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "v_gis_cama_mobile_structure_attributes", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "structure_id", "composite": false }, { "id": 2, "name": "v_gis_cama_mobile_sections", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "structure_id", "composite": false }, { "id": 0, "name": "v_gis_cama_mobile_parcels", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "parcel_number", "composite": false } ], "isDataVersioned": false, "isDataArchived": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1663902530000 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "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": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "structure_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "last_chg_login", "type": "esriFieldTypeString", "alias": "last_chg_login", "domain": null, "editable": true, "nullable": true, "length": 28, "defaultValue": null, "modelName": "last_chg_login" }, { "name": "last_chg_datetime", "type": "esriFieldTypeDate", "alias": "last_chg_datetime", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_chg_datetime" }, { "name": "parcel_number", "type": "esriFieldTypeString", "alias": "parcel_number", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "parcel_number" }, { "name": "parcel_year", "type": "esriFieldTypeInteger", "alias": "parcel_year", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "parcel_year" }, { "name": "structure_id", "type": "esriFieldTypeInteger", "alias": "structure_id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "structure_id" }, { "name": "manual_id", "type": "esriFieldTypeInteger", "alias": "manual_id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "manual_id" }, { "name": "property_use", "type": "esriFieldTypeString", "alias": "property_use", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "property_use" }, { "name": "quality", "type": "esriFieldTypeInteger", "alias": "quality", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "quality" }, { "name": "structure_value", "type": "esriFieldTypeDouble", "alias": "structure_value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "structure_value" }, { "name": "primary_structure", "type": "esriFieldTypeString", "alias": "primary_structure", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "primary_structure" }, { "name": "primary_area", "type": "esriFieldTypeDouble", "alias": "primary_area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "primary_area" }, { "name": "secondary_structure", "type": "esriFieldTypeString", "alias": "secondary_structure", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "secondary_structure" }, { "name": "secondary_area", "type": "esriFieldTypeDouble", "alias": "secondary_area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "secondary_area" }, { "name": "tertiary_structure", "type": "esriFieldTypeString", "alias": "tertiary_structure", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "tertiary_structure" }, { "name": "tertiary_area", "type": "esriFieldTypeDouble", "alias": "tertiary_area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "tertiary_area" }, { "name": "base_area", "type": "esriFieldTypeDouble", "alias": "base_area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "base_area" }, { "name": "structure_name", "type": "esriFieldTypeString", "alias": "structure_name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "structure_name" }, { "name": "year_built", "type": "esriFieldTypeInteger", "alias": "year_built", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "year_built" }, { "name": "adjusted_age", "type": "esriFieldTypeInteger", "alias": "adjusted_age", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "adjusted_age" }, { "name": "sketch_id", "type": "esriFieldTypeInteger", "alias": "sketch_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sketch_id" }, { "name": "notes", "type": "esriFieldTypeString", "alias": "notes", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "notes" }, { "name": "manual_yn", "type": "esriFieldTypeString", "alias": "manual_yn", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "manual_yn" }, { "name": "original_value", "type": "esriFieldTypeDouble", "alias": "original_value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "original_value" }, { "name": "value_flag", "type": "esriFieldTypeString", "alias": "value_flag", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "value_flag" }, { "name": "value_desc", "type": "esriFieldTypeString", "alias": "value_desc", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "value_desc" }, { "name": "completion_percentage", "type": "esriFieldTypeDouble", "alias": "completion_percentage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "completion_percentage" }, { "name": "remodel_year", "type": "esriFieldTypeInteger", "alias": "remodel_year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "remodel_year" }, { "name": "res_percentage", "type": "esriFieldTypeDouble", "alias": "res_percentage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "res_percentage" }, { "name": "farm_percentage", "type": "esriFieldTypeDouble", "alias": "farm_percentage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "farm_percentage" }, { "name": "com_percentage", "type": "esriFieldTypeDouble", "alias": "com_percentage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "com_percentage" }, { "name": "ind_percentage", "type": "esriFieldTypeDouble", "alias": "ind_percentage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ind_percentage" }, { "name": "building_code", "type": "esriFieldTypeString", "alias": "building_code", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "building_code" }, { "name": "adj_reason", "type": "esriFieldTypeString", "alias": "adj_reason", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "adj_reason" }, { "name": "appraisal_manual_used", "type": "esriFieldTypeString", "alias": "appraisal_manual_used", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "appraisal_manual_used" }, { "name": "appraisal_created_datetime", "type": "esriFieldTypeDate", "alias": "appraisal_created_datetime", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "appraisal_created_datetime" }, { "name": "appraisal_created_year", "type": "esriFieldTypeInteger", "alias": "appraisal_created_year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "appraisal_created_year" }, { "name": "actual_age", "type": "esriFieldTypeInteger", "alias": "actual_age", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "actual_age" }, { "name": "gross_living_area", "type": "esriFieldTypeDouble", "alias": "gross_living_area", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "gross_living_area" }, { "name": "structure_id_for_roll", "type": "esriFieldTypeInteger", "alias": "structure_id_for_roll", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "structure_id_for_roll" }, { "name": "prorate_date", "type": "esriFieldTypeDate", "alias": "prorate_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "prorate_date" }, { "name": "prorate_yn", "type": "esriFieldTypeString", "alias": "prorate_yn", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "prorate_yn" }, { "name": "new_const_orig", "type": "esriFieldTypeDouble", "alias": "new_const_orig", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "new_const_orig" }, { "name": "structure_multiplier", "type": "esriFieldTypeInteger", "alias": "structure_multiplier", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "structure_multiplier" }, { "name": "qv_yn", "type": "esriFieldTypeString", "alias": "qv_yn", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "qv_yn" }, { "name": "qv_value", "type": "esriFieldTypeDouble", "alias": "qv_value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "qv_value" }, { "name": "exceptional_property_factor_yn", "type": "esriFieldTypeString", "alias": "exceptional_property_factor_yn", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "exceptional_property_factor_yn" }, { "name": "exceptional_property_factor", "type": "esriFieldTypeDouble", "alias": "exceptional_property_factor", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "exceptional_property_factor" }, { "name": "tenant_roster", "type": "esriFieldTypeString", "alias": "tenant_roster", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "tenant_roster" }, { "name": "franchise_code", "type": "esriFieldTypeString", "alias": "franchise_code", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "franchise_code" }, { "name": "building_id", "type": "esriFieldTypeInteger", "alias": "building_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "building_id" }, { "name": "sale_yn", "type": "esriFieldTypeString", "alias": "sale_yn", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "sale_yn" }, { "name": "address_id", "type": "esriFieldTypeInteger", "alias": "address_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "address_id" }, { "name": "condition", "type": "esriFieldTypeInteger", "alias": "condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "condition" }, { "name": "source", "type": "esriFieldTypeString", "alias": "source", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "source" }, { "name": "transfer_id", "type": "esriFieldTypeInteger", "alias": "transfer_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "transfer_id" }, { "name": "orig_structure_id", "type": "esriFieldTypeInteger", "alias": "orig_structure_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "orig_structure_id" }, { "name": "orig_image_id", "type": "esriFieldTypeInteger", "alias": "orig_image_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "orig_image_id" }, { "name": "transfer_structure_id", "type": "esriFieldTypeInteger", "alias": "transfer_structure_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "transfer_structure_id" }, { "name": "assignment_id", "type": "esriFieldTypeInteger", "alias": "assignment_id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "assignment_id" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "delete_flag", "type": "esriFieldTypeInteger", "alias": "delete_flag", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "delete_flag" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" } ], "indexes": [ { "name": "UUID_14", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5parcel_number", "fields": "parcel_number", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5structure_id", "fields": "structure_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_14", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Mobile_CAMA.DBO.v_gis_cama_mobile_structures", "description": "", "prototype": { "attributes": { "delete_flag": null, "last_chg_login": null, "last_chg_datetime": null, "parcel_number": " ", "parcel_year": 0, "structure_id": 0, "manual_id": 0, "property_use": null, "quality": null, "structure_value": null, "primary_structure": null, "primary_area": null, "secondary_structure": null, "secondary_area": null, "tertiary_structure": null, "tertiary_area": null, "base_area": null, "structure_name": null, "year_built": null, "adjusted_age": null, "sketch_id": null, "notes": null, "manual_yn": null, "original_value": null, "value_flag": null, "value_desc": null, "completion_percentage": null, "remodel_year": null, "res_percentage": null, "farm_percentage": null, "com_percentage": null, "ind_percentage": null, "building_code": null, "adj_reason": null, "appraisal_manual_used": null, "appraisal_created_datetime": null, "appraisal_created_year": null, "actual_age": null, "gross_living_area": 0, "structure_id_for_roll": null, "prorate_date": null, "prorate_yn": null, "new_const_orig": null, "structure_multiplier": null, "qv_yn": null, "qv_value": null, "exceptional_property_factor_yn": null, "exceptional_property_factor": null, "tenant_roster": null, "franchise_code": null, "building_id": null, "sale_yn": null, "address_id": null, "condition": null, "source": null, "transfer_id": null, "orig_structure_id": null, "orig_image_id": null, "transfer_structure_id": null, "assignment_id": 0 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }