{ "currentVersion": 10.61, "id": 18, "name": "Petersburg.DBO.CAMA", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "StreetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Account_Number", "type": "esriFieldTypeDouble", "alias": "Account_Number", "domain": null }, { "name": "Card_num", "type": "esriFieldTypeDouble", "alias": "Card_num", "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 255, "domain": null }, { "name": "Legal_Description", "type": "esriFieldTypeString", "alias": "Legal_Description", "length": 255, "domain": null }, { "name": "Legal_Acres", "type": "esriFieldTypeDouble", "alias": "Legal_Acres", "domain": null }, { "name": "GIS_Acres", "type": "esriFieldTypeString", "alias": "GIS_Acres", "length": 255, "domain": null }, { "name": "Petersburg_DBO_CAMA_Area", "type": "esriFieldTypeString", "alias": "Petersburg.DBO.CAMA.Area", "length": 255, "domain": null }, { "name": "Lot_Depth", "type": "esriFieldTypeString", "alias": "Lot_Depth", "length": 255, "domain": null }, { "name": "Lot_Front", "type": "esriFieldTypeString", "alias": "Lot_Front", "length": 255, "domain": null }, { "name": "StreetNumber", "type": "esriFieldTypeString", "alias": "StreetNumber", "length": 255, "domain": null }, { "name": "StreetName", "type": "esriFieldTypeString", "alias": "StreetName", "length": 255, "domain": null }, { "name": "Street_Name_and_Number", "type": "esriFieldTypeString", "alias": "Street_Name_and_Number", "length": 255, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 255, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 255, "domain": null }, { "name": "Zip", "type": "esriFieldTypeString", "alias": "Zip", "length": 255, "domain": null }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "length": 255, "domain": null }, { "name": "Owner_2", "type": "esriFieldTypeString", "alias": "Owner_2", "length": 255, "domain": null }, { "name": "Owner_Mail_Street", "type": "esriFieldTypeString", "alias": "Owner_Mail_Street", "length": 255, "domain": null }, { "name": "Owner_Mail_City", "type": "esriFieldTypeString", "alias": "Owner_Mail_City", "length": 255, "domain": null }, { "name": "Owner_Mail_State", "type": "esriFieldTypeString", "alias": "Owner_Mail_State", "length": 255, "domain": null }, { "name": "Owner_Mail_Zip", "type": "esriFieldTypeString", "alias": "Owner_Mail_Zip", "length": 255, "domain": null }, { "name": "Property_Use_Number", "type": "esriFieldTypeString", "alias": "Property_Use_Number", "length": 255, "domain": null }, { "name": "Property_Use_Name", "type": "esriFieldTypeString", "alias": "Property_Use_Name", "length": 255, "domain": null }, { "name": "Zoning", "type": "esriFieldTypeString", "alias": "Zoning", "length": 255, "domain": null }, { "name": "Zoning_Name", "type": "esriFieldTypeString", "alias": "Zoning_Name", "length": 255, "domain": null }, { "name": "State_Class", "type": "esriFieldTypeDouble", "alias": "State_Class", "domain": null }, { "name": "State_Class_Name", "type": "esriFieldTypeString", "alias": "State_Class_Name", "length": 255, "domain": null }, { "name": "Subdivision", "type": "esriFieldTypeString", "alias": "Subdivision", "length": 255, "domain": null }, { "name": "Subdivision_Name", "type": "esriFieldTypeString", "alias": "Subdivision_Name", "length": 255, "domain": null }, { "name": "Assessment_Neighborhood", "type": "esriFieldTypeString", "alias": "Assessment_Neighborhood", "length": 255, "domain": null }, { "name": "Assessment_Neighborhood_Name", "type": "esriFieldTypeString", "alias": "Assessment_Neighborhood_Name", "length": 255, "domain": null }, { "name": "Local_Historic_District", "type": "esriFieldTypeString", "alias": "Local_Historic_District", "length": 255, "domain": null }, { "name": "National_Historic_District", "type": "esriFieldTypeString", "alias": "National_Historic_District", "length": 255, "domain": null }, { "name": "Enterprise_Zone", "type": "esriFieldTypeString", "alias": "Enterprise_Zone", "length": 255, "domain": null }, { "name": "Opportunity_Zone", "type": "esriFieldTypeString", "alias": "Opportunity_Zone", "length": 255, "domain": null }, { "name": "VA_Senate_District", "type": "esriFieldTypeDouble", "alias": "VA_Senate_District", "domain": null }, { "name": "VA_House_District", "type": "esriFieldTypeDouble", "alias": "VA_House_District", "domain": null }, { "name": "US_Congressional_District", "type": "esriFieldTypeDouble", "alias": "US_Congressional_District", "domain": null }, { "name": "City_Ward", "type": "esriFieldTypeDouble", "alias": "City_Ward", "domain": null }, { "name": "Polling_Place", "type": "esriFieldTypeString", "alias": "Polling_Place", "length": 255, "domain": null }, { "name": "Census_Tract", "type": "esriFieldTypeString", "alias": "Census_Tract", "length": 255, "domain": null }, { "name": "Utilities", "type": "esriFieldTypeString", "alias": "Utilities", "length": 255, "domain": null }, { "name": "Elementary_School", "type": "esriFieldTypeString", "alias": "Elementary_School", "length": 255, "domain": null }, { "name": "Middle_School", "type": "esriFieldTypeString", "alias": "Middle_School", "length": 255, "domain": null }, { "name": "High_School", "type": "esriFieldTypeString", "alias": "High_School", "length": 255, "domain": null }, { "name": "Year_Built", "type": "esriFieldTypeDouble", "alias": "Year_Built", "domain": null }, { "name": "Effective_Age", "type": "esriFieldTypeDouble", "alias": "Effective_Age", "domain": null }, { "name": "Quality", "type": "esriFieldTypeString", "alias": "Quality", "length": 255, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": null }, { "name": "Stories", "type": "esriFieldTypeString", "alias": "Stories", "length": 255, "domain": null }, { "name": "Finished_Square_Feet", "type": "esriFieldTypeDouble", "alias": "Finished_Square_Feet", "domain": null }, { "name": "Basement_Square_Feet", "type": "esriFieldTypeString", "alias": "Basement_Square_Feet", "length": 255, "domain": null }, { "name": "Attached_Garage", "type": "esriFieldTypeString", "alias": "Attached_Garage", "length": 255, "domain": null }, { "name": "Detached_Garage", "type": "esriFieldTypeString", "alias": "Detached_Garage", "length": 255, "domain": null }, { "name": "Enclosed_Porch", "type": "esriFieldTypeString", "alias": "Enclosed_Porch", "length": 255, "domain": null }, { "name": "Open_Porch", "type": "esriFieldTypeString", "alias": "Open_Porch", "length": 255, "domain": null }, { "name": "Deck_Patio", "type": "esriFieldTypeString", "alias": "Deck_Patio", "length": 255, "domain": null }, { "name": "Shed", "type": "esriFieldTypeString", "alias": "Shed", "length": 255, "domain": null }, { "name": "Rooms", "type": "esriFieldTypeDouble", "alias": "Rooms", "domain": null }, { "name": "Bedrooms", "type": "esriFieldTypeDouble", "alias": "Bedrooms", "domain": null }, { "name": "Baths", "type": "esriFieldTypeDouble", "alias": "Baths", "domain": null }, { "name": "Half_Baths", "type": "esriFieldTypeDouble", "alias": "Half_Baths", "domain": null }, { "name": "Foundation", "type": "esriFieldTypeString", "alias": "Foundation", "length": 255, "domain": null }, { "name": "Frame", "type": "esriFieldTypeString", "alias": "Frame", "length": 255, "domain": null }, { "name": "Exterior_Wall", "type": "esriFieldTypeString", "alias": "Exterior_Wall", "length": 255, "domain": null }, { "name": "Roof_Type", "type": "esriFieldTypeString", "alias": "Roof_Type", "length": 255, "domain": null }, { "name": "Heat_Type", "type": "esriFieldTypeString", "alias": "Heat_Type", "length": 255, "domain": null }, { "name": "AC", "type": "esriFieldTypeString", "alias": "AC", "length": 255, "domain": null }, { "name": "Fireplace", "type": "esriFieldTypeDouble", "alias": "Fireplace", "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "Sketch_Path", "type": "esriFieldTypeString", "alias": "Sketch_Path", "length": 255, "domain": null }, { "name": "Grantor", "type": "esriFieldTypeString", "alias": "Grantor", "length": 255, "domain": null }, { "name": "Previous_Owner", "type": "esriFieldTypeString", "alias": "Previous_Owner", "length": 255, "domain": null }, { "name": "Deed_Book", "type": "esriFieldTypeString", "alias": "Deed_Book", "length": 255, "domain": null }, { "name": "Deed_Page", "type": "esriFieldTypeString", "alias": "Deed_Page", "length": 255, "domain": null }, { "name": "Document", "type": "esriFieldTypeString", "alias": "Document", "length": 255, "domain": null }, { "name": "Sale_Date", "type": "esriFieldTypeDate", "alias": "Sale_Date", "length": 8, "domain": null }, { "name": "Sale_Price", "type": "esriFieldTypeDouble", "alias": "Sale_Price", "domain": null }, { "name": "Sale_Type", "type": "esriFieldTypeString", "alias": "Sale_Type", "length": 255, "domain": null }, { "name": "Previous_Owner_2", "type": "esriFieldTypeString", "alias": "Previous_Owner_2", "length": 255, "domain": null }, { "name": "Document_2", "type": "esriFieldTypeString", "alias": "Document_2", "length": 255, "domain": null }, { "name": "Sale_Date_2", "type": "esriFieldTypeString", "alias": "Sale_Date_2", "length": 255, "domain": null }, { "name": "Sale_Price_2", "type": "esriFieldTypeString", "alias": "Sale_Price_2", "length": 255, "domain": null }, { "name": "Sale_Type_2", "type": "esriFieldTypeString", "alias": "Sale_Type_2", "length": 255, "domain": null }, { "name": "Previous_Owner_3", "type": "esriFieldTypeString", "alias": "Previous_Owner_3", "length": 255, "domain": null }, { "name": "Document_3", "type": "esriFieldTypeString", "alias": "Document_3", "length": 255, "domain": null }, { "name": "Sale_Date_3", "type": "esriFieldTypeString", "alias": "Sale_Date_3", "length": 255, "domain": null }, { "name": "Sale_Price_3", "type": "esriFieldTypeString", "alias": "Sale_Price_3", "length": 255, "domain": null }, { "name": "Sale_Type_3", "type": "esriFieldTypeString", "alias": "Sale_Type_3", "length": 255, "domain": null }, { "name": "Valuation_Date", "type": "esriFieldTypeString", "alias": "Valuation_Date", "length": 255, "domain": null }, { "name": "Billing_Date", "type": "esriFieldTypeString", "alias": "Billing_Date", "length": 255, "domain": null }, { "name": "Reason", "type": "esriFieldTypeString", "alias": "Reason", "length": 255, "domain": null }, { "name": "Land_Value", "type": "esriFieldTypeDouble", "alias": "Land_Value", "domain": null }, { "name": "Improvement_Value", "type": "esriFieldTypeDouble", "alias": "Improvement_Value", "domain": null }, { "name": "Total_Value", "type": "esriFieldTypeDouble", "alias": "Total_Value", "domain": null }, { "name": "Pre_Valuation_Date", "type": "esriFieldTypeString", "alias": "Pre_Valuation_Date", "length": 255, "domain": null }, { "name": "Pre_Billing_Date", "type": "esriFieldTypeString", "alias": "Pre_Billing_Date", "length": 255, "domain": null }, { "name": "Pre_Reason", "type": "esriFieldTypeString", "alias": "Pre_Reason", "length": 255, "domain": null }, { "name": "Pre_Land", "type": "esriFieldTypeDouble", "alias": "Pre_Land", "domain": null }, { "name": "Pre_Improvement", "type": "esriFieldTypeDouble", "alias": "Pre_Improvement", "domain": null }, { "name": "Pre_Total", "type": "esriFieldTypeDouble", "alias": "Pre_Total", "domain": null }, { "name": "Valuation_Date_3", "type": "esriFieldTypeString", "alias": "Valuation_Date_3", "length": 255, "domain": null }, { "name": "Billing_Date_3", "type": "esriFieldTypeString", "alias": "Billing_Date_3", "length": 255, "domain": null }, { "name": "Reason_3", "type": "esriFieldTypeString", "alias": "Reason_3", "length": 255, "domain": null }, { "name": "Land_3", "type": "esriFieldTypeDouble", "alias": "Land_3", "domain": null }, { "name": "Improvement_3", "type": "esriFieldTypeDouble", "alias": "Improvement_3", "domain": null }, { "name": "Total_3", "type": "esriFieldTypeDouble", "alias": "Total_3", "domain": null }, { "name": "Valuation_Date_4", "type": "esriFieldTypeString", "alias": "Valuation_Date_4", "length": 255, "domain": null }, { "name": "Billing_Date_4", "type": "esriFieldTypeString", "alias": "Billing_Date_4", "length": 255, "domain": null }, { "name": "Reason_4", "type": "esriFieldTypeString", "alias": "Reason_4", "length": 255, "domain": null }, { "name": "Land_4", "type": "esriFieldTypeDouble", "alias": "Land_4", "domain": null }, { "name": "Improvement_4", "type": "esriFieldTypeDouble", "alias": "Improvement_4", "domain": null }, { "name": "Total_4", "type": "esriFieldTypeDouble", "alias": "Total_4", "domain": null }, { "name": "Valuation_Date_5", "type": "esriFieldTypeString", "alias": "Valuation_Date_5", "length": 255, "domain": null }, { "name": "Billing_Date_5", "type": "esriFieldTypeString", "alias": "Billing_Date_5", "length": 255, "domain": null }, { "name": "Reason_5", "type": "esriFieldTypeString", "alias": "Reason_5", "length": 255, "domain": null }, { "name": "Land_5", "type": "esriFieldTypeDouble", "alias": "Land_5", "domain": null }, { "name": "Improvement_5", "type": "esriFieldTypeDouble", "alias": "Improvement_5", "domain": null }, { "name": "Total_5", "type": "esriFieldTypeDouble", "alias": "Total_5", "domain": null }, { "name": "Date_of_Data", "type": "esriFieldTypeString", "alias": "Date_of_Data", "length": 255, "domain": null }, { "name": "owncode", "type": "esriFieldTypeDouble", "alias": "owncode", "domain": null }, { "name": "loccode", "type": "esriFieldTypeString", "alias": "loccode", "length": 255, "domain": null }, { "name": "Field123", "type": "esriFieldTypeString", "alias": "Field123", "length": 255, "domain": null } ], "indexes": [ { "name": "R22_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "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 }