{ "currentVersion": 10.91, "id": 2, "name": "Mobile_CAMA.DBO.v_gis_cama_mobile_structure_attributes", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "attribute_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "last_chg_login", "type": "esriFieldTypeString", "alias": "last_chg_login", "length": 28, "domain": null }, { "name": "last_chg_datetime", "type": "esriFieldTypeDate", "alias": "last_chg_datetime", "length": 8, "domain": null }, { "name": "parcel_number", "type": "esriFieldTypeString", "alias": "parcel_number", "length": 20, "domain": null }, { "name": "parcel_year", "type": "esriFieldTypeInteger", "alias": "parcel_year", "domain": null }, { "name": "structure_id", "type": "esriFieldTypeInteger", "alias": "structure_id", "domain": null }, { "name": "attribute_id", "type": "esriFieldTypeInteger", "alias": "attribute_id", "domain": null }, { "name": "property_use", "type": "esriFieldTypeString", "alias": "property_use", "length": 10, "domain": null }, { "name": "grouping", "type": "esriFieldTypeString", "alias": "grouping", "length": 30, "domain": null }, { "name": "structure", "type": "esriFieldTypeString", "alias": "structure", "length": 50, "domain": null }, { "name": "heading", "type": "esriFieldTypeString", "alias": "heading", "length": 30, "domain": null }, { "name": "attribute_name", "type": "esriFieldTypeString", "alias": "attribute_name", "length": 50, "domain": null }, { "name": "quality", "type": "esriFieldTypeInteger", "alias": "quality", "domain": null }, { "name": "sequence_no", "type": "esriFieldTypeInteger", "alias": "sequence_no", "domain": null }, { "name": "keyin_type", "type": "esriFieldTypeString", "alias": "keyin_type", "length": 10, "domain": null }, { "name": "keyin_tag", "type": "esriFieldTypeString", "alias": "keyin_tag", "length": 20, "domain": null }, { "name": "keyin_value", "type": "esriFieldTypeDouble", "alias": "keyin_value", "domain": null }, { "name": "table_value", "type": "esriFieldTypeDouble", "alias": "table_value", "domain": null }, { "name": "attribute_value", "type": "esriFieldTypeDouble", "alias": "attribute_value", "domain": null }, { "name": "effective_age", "type": "esriFieldTypeInteger", "alias": "effective_age", "domain": null }, { "name": "depreciation_factor", "type": "esriFieldTypeInteger", "alias": "depreciation_factor", "domain": null }, { "name": "structure_factor", "type": "esriFieldTypeDouble", "alias": "structure_factor", "domain": null }, { "name": "size_factor", "type": "esriFieldTypeDouble", "alias": "size_factor", "domain": null }, { "name": "misc_factor", "type": "esriFieldTypeDouble", "alias": "misc_factor", "domain": null }, { "name": "comparison_code", "type": "esriFieldTypeString", "alias": "comparison_code", "length": 20, "domain": null }, { "name": "manual_override", "type": "esriFieldTypeString", "alias": "manual_override", "length": 1, "domain": null }, { "name": "year_built", "type": "esriFieldTypeInteger", "alias": "year_built", "domain": null }, { "name": "base_value", "type": "esriFieldTypeDouble", "alias": "base_value", "domain": null }, { "name": "adjustment_value", "type": "esriFieldTypeDouble", "alias": "adjustment_value", "domain": null }, { "name": "condition", "type": "esriFieldTypeDouble", "alias": "condition", "domain": null }, { "name": "units", "type": "esriFieldTypeDouble", "alias": "units", "domain": null }, { "name": "actual_age", "type": "esriFieldTypeInteger", "alias": "actual_age", "domain": null }, { "name": "keyin_width", "type": "esriFieldTypeDouble", "alias": "keyin_width", "domain": null }, { "name": "keyin_length", "type": "esriFieldTypeDouble", "alias": "keyin_length", "domain": null }, { "name": "nc_percent_complete", "type": "esriFieldTypeDouble", "alias": "nc_percent_complete", "domain": null }, { "name": "demo_percent_complete", "type": "esriFieldTypeDouble", "alias": "demo_percent_complete", "domain": null }, { "name": "omitted_percent_complete", "type": "esriFieldTypeDouble", "alias": "omitted_percent_complete", "domain": null }, { "name": "obsolescence_factor", "type": "esriFieldTypeDouble", "alias": "obsolescence_factor", "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "length": 255, "domain": null }, { "name": "manual_size_factor", "type": "esriFieldTypeDouble", "alias": "manual_size_factor", "domain": null }, { "name": "manual_story_factor", "type": "esriFieldTypeDouble", "alias": "manual_story_factor", "domain": null }, { "name": "manual_perimeter_factor", "type": "esriFieldTypeDouble", "alias": "manual_perimeter_factor", "domain": null }, { "name": "manual_height_factor", "type": "esriFieldTypeDouble", "alias": "manual_height_factor", "domain": null }, { "name": "keyin_stories", "type": "esriFieldTypeDouble", "alias": "keyin_stories", "domain": null }, { "name": "floor_level_label", "type": "esriFieldTypeString", "alias": "floor_level_label", "length": 20, "domain": null }, { "name": "func_depreciation_factor", "type": "esriFieldTypeDouble", "alias": "func_depreciation_factor", "domain": null }, { "name": "econ_depreciation_factor", "type": "esriFieldTypeDouble", "alias": "econ_depreciation_factor", "domain": null }, { "name": "multiplier", "type": "esriFieldTypeInteger", "alias": "multiplier", "domain": null }, { "name": "exemption_percent", "type": "esriFieldTypeDouble", "alias": "exemption_percent", "domain": null }, { "name": "exemption_code", "type": "esriFieldTypeString", "alias": "exemption_code", "length": 10, "domain": null }, { "name": "section_id", "type": "esriFieldTypeInteger", "alias": "section_id", "domain": null }, { "name": "seq_no", "type": "esriFieldTypeInteger", "alias": "seq_no", "domain": null }, { "name": "improvement_no", "type": "esriFieldTypeInteger", "alias": "improvement_no", "domain": null }, { "name": "transfer_structure_id", "type": "esriFieldTypeInteger", "alias": "transfer_structure_id", "domain": null }, { "name": "transfer_attribute_id", "type": "esriFieldTypeInteger", "alias": "transfer_attribute_id", "domain": null }, { "name": "transfer_section_id", "type": "esriFieldTypeInteger", "alias": "transfer_section_id", "domain": null }, { "name": "orig_attribute_id", "type": "esriFieldTypeInteger", "alias": "orig_attribute_id", "domain": null }, { "name": "orig_structure_id", "type": "esriFieldTypeInteger", "alias": "orig_structure_id", "domain": null }, { "name": "transfer_id", "type": "esriFieldTypeInteger", "alias": "transfer_id", "domain": null }, { "name": "attribute_id_for_roll", "type": "esriFieldTypeInteger", "alias": "attribute_id_for_roll", "domain": null }, { "name": "assignment_id", "type": "esriFieldTypeInteger", "alias": "assignment_id", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "delete_flag", "type": "esriFieldTypeInteger", "alias": "delete_flag", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_21", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G12structure_id", "fields": "structure_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_21", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "v_gis_cama_mobile_structures", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "structure_id", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }