{ "layers": [ { "currentVersion": 10.91, "id": 0, "name": "v_gis_cama_mobile_parcels", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 217, 205, 247, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -8704168.685364023, "ymin": 4243088.023188233, "xmax": -8647487.260341272, "ymax": 4281675.382693142, "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "parcel_number", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "parcel_number", "type": "esriFieldTypeString", "alias": "parcel_number", "length": 20, "domain": null }, { "name": "parcel_year", "type": "esriFieldTypeInteger", "alias": "parcel_year", "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "address", "length": 135, "domain": null }, { "name": "land_use", "type": "esriFieldTypeString", "alias": "land_use", "length": 10, "domain": null }, { "name": "use_code_group", "type": "esriFieldTypeString", "alias": "use_code_group", "length": 10, "domain": null }, { "name": "neighborhood_code", "type": "esriFieldTypeString", "alias": "neighborhood_code", "length": 10, "domain": null }, { "name": "py_tax_code", "type": "esriFieldTypeString", "alias": "py_tax_code", "length": 10, "domain": null }, { "name": "tax_status", "type": "esriFieldTypeString", "alias": "tax_status", "length": 10, "domain": null }, { "name": "assignment_id", "type": "esriFieldTypeInteger", "alias": "assignment_id", "domain": null }, { "name": "packet", "type": "esriFieldTypeString", "alias": "packet", "length": 20, "domain": null }, { "name": "type", "type": "esriFieldTypeString", "alias": "type", "length": 255, "domain": null }, { "name": "status", "type": "esriFieldTypeString", "alias": "status", "length": 255, "domain": null }, { "name": "priority", "type": "esriFieldTypeString", "alias": "priority", "length": 255, "domain": null }, { "name": "notes", "type": "esriFieldTypeString", "alias": "notes", "length": 1073741822, "domain": null }, { "name": "assigned_login", "type": "esriFieldTypeString", "alias": "assigned_login", "length": 50, "domain": null }, { "name": "due_datetime", "type": "esriFieldTypeDate", "alias": "due_datetime", "length": 8, "domain": null }, { "name": "last_push_datetime", "type": "esriFieldTypeDate", "alias": "last_push_datetime", "length": 8, "domain": null }, { "name": "last_pull_datetime", "type": "esriFieldTypeDate", "alias": "last_pull_datetime", "length": 8, "domain": null }, { "name": "checked_out_yn", "type": "esriFieldTypeString", "alias": "checked_out_yn", "length": 1, "domain": null }, { "name": "property_class", "type": "esriFieldTypeString", "alias": "property_class", "length": 38, "domain": null }, { "name": "tax_code", "type": "esriFieldTypeString", "alias": "tax_code", "length": 73, "domain": null }, { "name": "township", "type": "esriFieldTypeString", "alias": "township", "length": 25, "domain": null }, { "name": "neighborhood", "type": "esriFieldTypeString", "alias": "neighborhood", "length": 53, "domain": null }, { "name": "owner_names", "type": "esriFieldTypeString", "alias": "owner_names", "length": 600, "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": "notification_code", "type": "esriFieldTypeSmallInteger", "alias": "notification_code", "domain": null }, { "name": "note_id", "type": "esriFieldTypeSmallInteger", "alias": "note_id", "domain": null }, { "name": "delete_flag", "type": "esriFieldTypeSmallInteger", "alias": "delete_flag", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "UUID_27", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G18parcel_number", "fields": "parcel_number", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_27", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S2_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "v_gis_cama_mobile_structures", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "parcel_number", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriMeters" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.91, "id": 1, "name": "Mobile_CAMA.DBO.v_gis_cama_mobile_structures", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "structure_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": "manual_id", "type": "esriFieldTypeInteger", "alias": "manual_id", "domain": null }, { "name": "property_use", "type": "esriFieldTypeString", "alias": "property_use", "length": 10, "domain": null }, { "name": "quality", "type": "esriFieldTypeInteger", "alias": "quality", "domain": null }, { "name": "structure_value", "type": "esriFieldTypeDouble", "alias": "structure_value", "domain": null }, { "name": "primary_structure", "type": "esriFieldTypeString", "alias": "primary_structure", "length": 50, "domain": null }, { "name": "primary_area", "type": "esriFieldTypeDouble", "alias": "primary_area", "domain": null }, { "name": "secondary_structure", "type": "esriFieldTypeString", "alias": "secondary_structure", "length": 50, "domain": null }, { "name": "secondary_area", "type": "esriFieldTypeDouble", "alias": "secondary_area", "domain": null }, { "name": "tertiary_structure", "type": "esriFieldTypeString", "alias": "tertiary_structure", "length": 50, "domain": null }, { "name": "tertiary_area", "type": "esriFieldTypeDouble", "alias": "tertiary_area", "domain": null }, { "name": "base_area", "type": "esriFieldTypeDouble", "alias": "base_area", "domain": null }, { "name": "structure_name", "type": "esriFieldTypeString", "alias": "structure_name", "length": 50, "domain": null }, { "name": "year_built", "type": "esriFieldTypeInteger", "alias": "year_built", "domain": null }, { "name": "adjusted_age", "type": "esriFieldTypeInteger", "alias": "adjusted_age", "domain": null }, { "name": "sketch_id", "type": "esriFieldTypeInteger", "alias": "sketch_id", "domain": null }, { "name": "notes", "type": "esriFieldTypeString", "alias": "notes", "length": 1073741822, "domain": null }, { "name": "manual_yn", "type": "esriFieldTypeString", "alias": "manual_yn", "length": 1, "domain": null }, { "name": "original_value", "type": "esriFieldTypeDouble", "alias": "original_value", "domain": null }, { "name": "value_flag", "type": "esriFieldTypeString", "alias": "value_flag", "length": 10, "domain": null }, { "name": "value_desc", "type": "esriFieldTypeString", "alias": "value_desc", "length": 100, "domain": null }, { "name": "completion_percentage", "type": "esriFieldTypeDouble", "alias": "completion_percentage", "domain": null }, { "name": "remodel_year", "type": "esriFieldTypeInteger", "alias": "remodel_year", "domain": null }, { "name": "res_percentage", "type": "esriFieldTypeDouble", "alias": "res_percentage", "domain": null }, { "name": "farm_percentage", "type": "esriFieldTypeDouble", "alias": "farm_percentage", "domain": null }, { "name": "com_percentage", "type": "esriFieldTypeDouble", "alias": "com_percentage", "domain": null }, { "name": "ind_percentage", "type": "esriFieldTypeDouble", "alias": "ind_percentage", "domain": null }, { "name": "building_code", "type": "esriFieldTypeString", "alias": "building_code", "length": 4, "domain": null }, { "name": "adj_reason", "type": "esriFieldTypeString", "alias": "adj_reason", "length": 1073741822, "domain": null }, { "name": "appraisal_manual_used", "type": "esriFieldTypeString", "alias": "appraisal_manual_used", "length": 10, "domain": null }, { "name": "appraisal_created_datetime", "type": "esriFieldTypeDate", "alias": "appraisal_created_datetime", "length": 8, "domain": null }, { "name": "appraisal_created_year", "type": "esriFieldTypeInteger", "alias": "appraisal_created_year", "domain": null }, { "name": "actual_age", "type": "esriFieldTypeInteger", "alias": "actual_age", "domain": null }, { "name": "gross_living_area", "type": "esriFieldTypeDouble", "alias": "gross_living_area", "domain": null }, { "name": "structure_id_for_roll", "type": "esriFieldTypeInteger", "alias": "structure_id_for_roll", "domain": null }, { "name": "prorate_date", "type": "esriFieldTypeDate", "alias": "prorate_date", "length": 8, "domain": null }, { "name": "prorate_yn", "type": "esriFieldTypeString", "alias": "prorate_yn", "length": 1, "domain": null }, { "name": "new_const_orig", "type": "esriFieldTypeDouble", "alias": "new_const_orig", "domain": null }, { "name": "structure_multiplier", "type": "esriFieldTypeInteger", "alias": "structure_multiplier", "domain": null }, { "name": "qv_yn", "type": "esriFieldTypeString", "alias": "qv_yn", "length": 1, "domain": null }, { "name": "qv_value", "type": "esriFieldTypeDouble", "alias": "qv_value", "domain": null }, { "name": "exceptional_property_factor_yn", "type": "esriFieldTypeString", "alias": "exceptional_property_factor_yn", "length": 1, "domain": null }, { "name": "exceptional_property_factor", "type": "esriFieldTypeDouble", "alias": "exceptional_property_factor", "domain": null }, { "name": "tenant_roster", "type": "esriFieldTypeString", "alias": "tenant_roster", "length": 1073741822, "domain": null }, { "name": "franchise_code", "type": "esriFieldTypeString", "alias": "franchise_code", "length": 10, "domain": null }, { "name": "building_id", "type": "esriFieldTypeInteger", "alias": "building_id", "domain": null }, { "name": "sale_yn", "type": "esriFieldTypeString", "alias": "sale_yn", "length": 1, "domain": null }, { "name": "address_id", "type": "esriFieldTypeInteger", "alias": "address_id", "domain": null }, { "name": "condition", "type": "esriFieldTypeInteger", "alias": "condition", "domain": null }, { "name": "source", "type": "esriFieldTypeString", "alias": "source", "length": 10, "domain": null }, { "name": "transfer_id", "type": "esriFieldTypeInteger", "alias": "transfer_id", "domain": null }, { "name": "orig_structure_id", "type": "esriFieldTypeInteger", "alias": "orig_structure_id", "domain": null }, { "name": "orig_image_id", "type": "esriFieldTypeInteger", "alias": "orig_image_id", "domain": null }, { "name": "transfer_structure_id", "type": "esriFieldTypeInteger", "alias": "transfer_structure_id", "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_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": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "v_gis_cama_mobile_structure_attributes", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "structure_id", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "v_gis_cama_mobile_sections", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "structure_id", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 0, "name": "v_gis_cama_mobile_parcels", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "parcel_number", "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 }, { "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 }, { "currentVersion": 10.91, "id": 3, "name": "Mobile_CAMA.DBO.v_gis_cama_mobile_sections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "last_chg_login", "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": "section_id", "type": "esriFieldTypeInteger", "alias": "section_id", "domain": null }, { "name": "improvement_number", "type": "esriFieldTypeInteger", "alias": "improvement_number", "domain": null }, { "name": "construction_type", "type": "esriFieldTypeString", "alias": "construction_type", "length": 10, "domain": null }, { "name": "section_desc", "type": "esriFieldTypeString", "alias": "section_desc", "length": 100, "domain": null }, { "name": "sq_ft_per_floor", "type": "esriFieldTypeInteger", "alias": "sq_ft_per_floor", "domain": null }, { "name": "number_of_levels_section", "type": "esriFieldTypeDouble", "alias": "number_of_levels_section", "domain": null }, { "name": "number_of_levels_building", "type": "esriFieldTypeDouble", "alias": "number_of_levels_building", "domain": null }, { "name": "perimeter", "type": "esriFieldTypeInteger", "alias": "perimeter", "domain": null }, { "name": "shape", "type": "esriFieldTypeString", "alias": "shape", "length": 10, "domain": null }, { "name": "effective_age", "type": "esriFieldTypeInteger", "alias": "effective_age", "domain": null }, { "name": "base_date", "type": "esriFieldTypeDate", "alias": "base_date", "length": 8, "domain": null }, { "name": "depreciation_id", "type": "esriFieldTypeInteger", "alias": "depreciation_id", "domain": null }, { "name": "lower_level_height", "type": "esriFieldTypeDouble", "alias": "lower_level_height", "domain": null }, { "name": "main_level_height", "type": "esriFieldTypeDouble", "alias": "main_level_height", "domain": null }, { "name": "upper_level_height", "type": "esriFieldTypeDouble", "alias": "upper_level_height", "domain": null }, { "name": "market_adjustment", "type": "esriFieldTypeDouble", "alias": "market_adjustment", "domain": null }, { "name": "identical_buildings", "type": "esriFieldTypeDouble", "alias": "identical_buildings", "domain": null }, { "name": "orig_section_id", "type": "esriFieldTypeInteger", "alias": "orig_section_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": "transfer_structure_id", "type": "esriFieldTypeInteger", "alias": "transfer_structure_id", "domain": null }, { "name": "transfer_section_id", "type": "esriFieldTypeInteger", "alias": "transfer_section_id", "domain": null }, { "name": "section_id_for_roll", "type": "esriFieldTypeInteger", "alias": "section_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_23", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G14structure_id", "fields": "structure_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G14section_id", "fields": "section_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_23", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "v_gis_cama_mobile_section_attributes", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "section_id", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "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 }, { "currentVersion": 10.91, "id": 4, "name": "Mobile_CAMA.DBO.v_gis_cama_mobile_section_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_15", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G6section_id", "fields": "section_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_15", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "v_gis_cama_mobile_sections", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "section_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 } ] }