{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "Real_Estate_Data2", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "prop_street", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "LRSN", "type": "esriFieldTypeInteger", "alias": "LRSN", "domain": null }, { "name": "Parcel_id", "type": "esriFieldTypeString", "alias": "Parcel_id", "length": 26, "domain": null }, { "name": "extension", "type": "esriFieldTypeString", "alias": "extension", "length": 3, "domain": null }, { "name": "extbldgnum", "type": "esriFieldTypeInteger", "alias": "extbldgnum", "domain": null }, { "name": "ext_description", "type": "esriFieldTypeString", "alias": "ext_description", "length": 30, "domain": null }, { "name": "Parent_parcel_id", "type": "esriFieldTypeString", "alias": "Parent_parcel_id", "length": 26, "domain": null }, { "name": "Routing_number", "type": "esriFieldTypeString", "alias": "Routing_number", "length": 16, "domain": null }, { "name": "Leg_description", "type": "esriFieldTypeString", "alias": "Leg_description", "length": 4000, "domain": null }, { "name": "prop_street", "type": "esriFieldTypeString", "alias": "prop_street", "length": 4000, "domain": null }, { "name": "prop_city", "type": "esriFieldTypeString", "alias": "prop_city", "length": 4000, "domain": null }, { "name": "prop_state", "type": "esriFieldTypeString", "alias": "prop_state", "length": 4, "domain": null }, { "name": "prop_zip", "type": "esriFieldTypeString", "alias": "prop_zip", "length": 16, "domain": null }, { "name": "Owner1", "type": "esriFieldTypeString", "alias": "Owner1", "length": 4000, "domain": null }, { "name": "Own_street", "type": "esriFieldTypeString", "alias": "Own_street", "length": 4000, "domain": null }, { "name": "Own_City", "type": "esriFieldTypeString", "alias": "Own_City", "length": 4000, "domain": null }, { "name": "own_state", "type": "esriFieldTypeString", "alias": "own_state", "length": 4, "domain": null }, { "name": "own_zip", "type": "esriFieldTypeString", "alias": "own_zip", "length": 16, "domain": null }, { "name": "ImagePath", "type": "esriFieldTypeString", "alias": "ImagePath", "length": 256, "domain": null }, { "name": "SketchPath", "type": "esriFieldTypeString", "alias": "SketchPath", "length": 256, "domain": null }, { "name": "strtnum", "type": "esriFieldTypeInteger", "alias": "strtnum", "domain": null }, { "name": "SNumSufx", "type": "esriFieldTypeString", "alias": "SNumSufx", "length": 4000, "domain": null }, { "name": "strtDir", "type": "esriFieldTypeString", "alias": "strtDir", "length": 4000, "domain": null }, { "name": "StrtName", "type": "esriFieldTypeString", "alias": "StrtName", "length": 4000, "domain": null }, { "name": "strttype", "type": "esriFieldTypeString", "alias": "strttype", "length": 4, "domain": null }, { "name": "StrtSufx", "type": "esriFieldTypeString", "alias": "StrtSufx", "length": 2, "domain": null }, { "name": "UnitNum", "type": "esriFieldTypeString", "alias": "UnitNum", "length": 8, "domain": null }, { "name": "StrtCity", "type": "esriFieldTypeString", "alias": "StrtCity", "length": 4000, "domain": null }, { "name": "StrtZip", "type": "esriFieldTypeString", "alias": "StrtZip", "length": 16, "domain": null }, { "name": "acreage", "type": "esriFieldTypeDouble", "alias": "acreage", "domain": null }, { "name": "square_feet", "type": "esriFieldTypeDouble", "alias": "square_feet", "domain": null }, { "name": "acreage1", "type": "esriFieldTypeString", "alias": "acreage1", "length": 30, "domain": null }, { "name": "square_feet1", "type": "esriFieldTypeString", "alias": "square_feet1", "length": 30, "domain": null }, { "name": "Section_Plat", "type": "esriFieldTypeString", "alias": "Section_Plat", "length": 7, "domain": null }, { "name": "improvement_id", "type": "esriFieldTypeString", "alias": "improvement_id", "length": 3, "domain": null }, { "name": "property_class", "type": "esriFieldTypeInteger", "alias": "property_class", "domain": null }, { "name": "PropClassDesc", "type": "esriFieldTypeString", "alias": "PropClassDesc", "length": 30, "domain": null }, { "name": "property_use", "type": "esriFieldTypeString", "alias": "property_use", "length": 26, "domain": null }, { "name": "Neighborhood", "type": "esriFieldTypeInteger", "alias": "Neighborhood", "domain": null }, { "name": "finish_living_area", "type": "esriFieldTypeInteger", "alias": "finish_living_area", "domain": null }, { "name": "dwelling_year_built", "type": "esriFieldTypeInteger", "alias": "dwelling_year_built", "domain": null }, { "name": "dwelling_Condition", "type": "esriFieldTypeString", "alias": "dwelling_Condition", "length": 2, "domain": null }, { "name": "Grade", "type": "esriFieldTypeString", "alias": "Grade", "length": 30, "domain": null }, { "name": "simplified_grade", "type": "esriFieldTypeString", "alias": "simplified_grade", "length": 9, "domain": null }, { "name": "bedrooms", "type": "esriFieldTypeInteger", "alias": "bedrooms", "domain": null }, { "name": "full_baths", "type": "esriFieldTypeInteger", "alias": "full_baths", "domain": null }, { "name": "half_baths", "type": "esriFieldTypeInteger", "alias": "half_baths", "domain": null }, { "name": "fireplace_adj1", "type": "esriFieldTypeInteger", "alias": "fireplace_adj1", "domain": null }, { "name": "fireplace_indicator", "type": "esriFieldTypeString", "alias": "fireplace_indicator", "length": 3, "domain": null }, { "name": "central_air", "type": "esriFieldTypeString", "alias": "central_air", "length": 30, "domain": null }, { "name": "story_height", "type": "esriFieldTypeString", "alias": "story_height", "length": 5, "domain": null }, { "name": "attic_code", "type": "esriFieldTypeString", "alias": "attic_code", "length": 24, "domain": null }, { "name": "crawl_code", "type": "esriFieldTypeString", "alias": "crawl_code", "length": 16, "domain": null }, { "name": "mkt_house_type", "type": "esriFieldTypeString", "alias": "mkt_house_type", "length": 30, "domain": null }, { "name": "heating", "type": "esriFieldTypeString", "alias": "heating", "length": 30, "domain": null }, { "name": "roof_type", "type": "esriFieldTypeString", "alias": "roof_type", "length": 30, "domain": null }, { "name": "main_roof_material", "type": "esriFieldTypeString", "alias": "main_roof_material", "length": 30, "domain": null }, { "name": "wall_framing_material", "type": "esriFieldTypeString", "alias": "wall_framing_material", "length": 30, "domain": null }, { "name": "main_exterior_cover", "type": "esriFieldTypeString", "alias": "main_exterior_cover", "length": 30, "domain": null }, { "name": "main_interior_finish", "type": "esriFieldTypeString", "alias": "main_interior_finish", "length": 30, "domain": null }, { "name": "exterior_cover", "type": "esriFieldTypeString", "alias": "exterior_cover", "length": 30, "domain": null }, { "name": "framing", "type": "esriFieldTypeString", "alias": "framing", "length": 30, "domain": null }, { "name": "finished_attic", "type": "esriFieldTypeInteger", "alias": "finished_attic", "domain": null }, { "name": "base_attic", "type": "esriFieldTypeInteger", "alias": "base_attic", "domain": null }, { "name": "bsmnt_fin_area", "type": "esriFieldTypeInteger", "alias": "bsmnt_fin_area", "domain": null }, { "name": "base_basement", "type": "esriFieldTypeInteger", "alias": "base_basement", "domain": null }, { "name": "attgarage_Imp_size", "type": "esriFieldTypeInteger", "alias": "attgarage_Imp_size", "domain": null }, { "name": "detgarage_Imp_size", "type": "esriFieldTypeInteger", "alias": "detgarage_Imp_size", "domain": null }, { "name": "open_porch", "type": "esriFieldTypeString", "alias": "open_porch", "length": 3, "domain": null }, { "name": "enclosed_porch", "type": "esriFieldTypeString", "alias": "enclosed_porch", "length": 3, "domain": null }, { "name": "wood_deck", "type": "esriFieldTypeString", "alias": "wood_deck", "length": 3, "domain": null }, { "name": "solarium", "type": "esriFieldTypeString", "alias": "solarium", "length": 3, "domain": null }, { "name": "stoop", "type": "esriFieldTypeString", "alias": "stoop", "length": 3, "domain": null }, { "name": "patio", "type": "esriFieldTypeString", "alias": "patio", "length": 3, "domain": null }, { "name": "canopy", "type": "esriFieldTypeString", "alias": "canopy", "length": 3, "domain": null }, { "name": "balcony", "type": "esriFieldTypeString", "alias": "balcony", "length": 3, "domain": null }, { "name": "bay_window", "type": "esriFieldTypeString", "alias": "bay_window", "length": 3, "domain": null }, { "name": "integrated_carport", "type": "esriFieldTypeString", "alias": "integrated_carport", "length": 3, "domain": null }, { "name": "carport", "type": "esriFieldTypeString", "alias": "carport", "length": 3, "domain": null }, { "name": "bath_house", "type": "esriFieldTypeString", "alias": "bath_house", "length": 3, "domain": null }, { "name": "boat_dock", "type": "esriFieldTypeString", "alias": "boat_dock", "length": 3, "domain": null }, { "name": "boat_lift", "type": "esriFieldTypeString", "alias": "boat_lift", "length": 3, "domain": null }, { "name": "boat_house", "type": "esriFieldTypeString", "alias": "boat_house", "length": 3, "domain": null }, { "name": "boat_slip", "type": "esriFieldTypeString", "alias": "boat_slip", "length": 3, "domain": null }, { "name": "bulkhead", "type": "esriFieldTypeString", "alias": "bulkhead", "length": 3, "domain": null }, { "name": "concrete_apron", "type": "esriFieldTypeString", "alias": "concrete_apron", "length": 3, "domain": null }, { "name": "fence_walls", "type": "esriFieldTypeString", "alias": "fence_walls", "length": 3, "domain": null }, { "name": "gazebo", "type": "esriFieldTypeString", "alias": "gazebo", "length": 3, "domain": null }, { "name": "greenhouse", "type": "esriFieldTypeString", "alias": "greenhouse", "length": 3, "domain": null }, { "name": "hottub", "type": "esriFieldTypeString", "alias": "hottub", "length": 3, "domain": null }, { "name": "irrigation", "type": "esriFieldTypeString", "alias": "irrigation", "length": 3, "domain": null }, { "name": "paving", "type": "esriFieldTypeString", "alias": "paving", "length": 3, "domain": null }, { "name": "pier", "type": "esriFieldTypeString", "alias": "pier", "length": 3, "domain": null }, { "name": "piling", "type": "esriFieldTypeString", "alias": "piling", "length": 3, "domain": null }, { "name": "pool", "type": "esriFieldTypeString", "alias": "pool", "length": 3, "domain": null }, { "name": "riprap", "type": "esriFieldTypeString", "alias": "riprap", "length": 3, "domain": null }, { "name": "sauna", "type": "esriFieldTypeString", "alias": "sauna", "length": 3, "domain": null }, { "name": "shed", "type": "esriFieldTypeString", "alias": "shed", "length": 3, "domain": null }, { "name": "tennis_court", "type": "esriFieldTypeString", "alias": "tennis_court", "length": 3, "domain": null }, { "name": "workshop", "type": "esriFieldTypeString", "alias": "workshop", "length": 3, "domain": null }, { "name": "tower_summary", "type": "esriFieldTypeString", "alias": "tower_summary", "length": 30, "domain": null }, { "name": "number_units", "type": "esriFieldTypeInteger", "alias": "number_units", "domain": null }, { "name": "floor_count", "type": "esriFieldTypeInteger", "alias": "floor_count", "domain": null }, { "name": "hvac", "type": "esriFieldTypeString", "alias": "hvac", "length": 30, "domain": null }, { "name": "use_code", "type": "esriFieldTypeString", "alias": "use_code", "length": 30, "domain": null }, { "name": "class", "type": "esriFieldTypeString", "alias": "class", "length": 30, "domain": null }, { "name": "sprinkler", "type": "esriFieldTypeString", "alias": "sprinkler", "length": 24, "domain": null }, { "name": "paving_sf", "type": "esriFieldTypeInteger", "alias": "paving_sf", "domain": null }, { "name": "imp_val1", "type": "esriFieldTypeInteger", "alias": "imp_val1", "domain": null }, { "name": "Land_market_val1", "type": "esriFieldTypeInteger", "alias": "Land_market_val1", "domain": null }, { "name": "Total1", "type": "esriFieldTypeInteger", "alias": "Total1", "domain": null }, { "name": "Eff_year1", "type": "esriFieldTypeString", "alias": "Eff_year1", "length": 10, "domain": null }, { "name": "imp_val2", "type": "esriFieldTypeInteger", "alias": "imp_val2", "domain": null }, { "name": "Land_market_val2", "type": "esriFieldTypeInteger", "alias": "Land_market_val2", "domain": null }, { "name": "Total2", "type": "esriFieldTypeInteger", "alias": "Total2", "domain": null }, { "name": "Eff_year2", "type": "esriFieldTypeString", "alias": "Eff_year2", "length": 10, "domain": null }, { "name": "imp_val3", "type": "esriFieldTypeInteger", "alias": "imp_val3", "domain": null }, { "name": "Land_market_val3", "type": "esriFieldTypeInteger", "alias": "Land_market_val3", "domain": null }, { "name": "Total3", "type": "esriFieldTypeInteger", "alias": "Total3", "domain": null }, { "name": "Eff_year3", "type": "esriFieldTypeString", "alias": "Eff_year3", "length": 10, "domain": null }, { "name": "imp_val4", "type": "esriFieldTypeInteger", "alias": "imp_val4", "domain": null }, { "name": "Land_market_val4", "type": "esriFieldTypeInteger", "alias": "Land_market_val4", "domain": null }, { "name": "Total4", "type": "esriFieldTypeInteger", "alias": "Total4", "domain": null }, { "name": "Eff_year4", "type": "esriFieldTypeString", "alias": "Eff_year4", "length": 10, "domain": null }, { "name": "imp_val5", "type": "esriFieldTypeInteger", "alias": "imp_val5", "domain": null }, { "name": "Land_market_val5", "type": "esriFieldTypeInteger", "alias": "Land_market_val5", "domain": null }, { "name": "Total5", "type": "esriFieldTypeInteger", "alias": "Total5", "domain": null }, { "name": "Eff_year5", "type": "esriFieldTypeString", "alias": "Eff_year5", "length": 10, "domain": null }, { "name": "Pxfer_date1", "type": "esriFieldTypeDate", "alias": "Pxfer_date1", "length": 8, "domain": null }, { "name": "owners1", "type": "esriFieldTypeString", "alias": "owners1", "length": 4000, "domain": null }, { "name": "Grantee1", "type": "esriFieldTypeString", "alias": "Grantee1", "length": 4000, "domain": null }, { "name": "consideration1", "type": "esriFieldTypeInteger", "alias": "consideration1", "domain": null }, { "name": "DocNum1", "type": "esriFieldTypeString", "alias": "DocNum1", "length": 10, "domain": null }, { "name": "Deed_Book1", "type": "esriFieldTypeString", "alias": "Deed_Book1", "length": 8, "domain": null }, { "name": "Deed_Page1", "type": "esriFieldTypeString", "alias": "Deed_Page1", "length": 8, "domain": null }, { "name": "TransType1", "type": "esriFieldTypeString", "alias": "TransType1", "length": 2, "domain": null }, { "name": "deedtype1", "type": "esriFieldTypeString", "alias": "deedtype1", "length": 2, "domain": null }, { "name": "Pxfer_date2", "type": "esriFieldTypeDate", "alias": "Pxfer_date2", "length": 8, "domain": null }, { "name": "owners2", "type": "esriFieldTypeString", "alias": "owners2", "length": 4000, "domain": null }, { "name": "Grantee2", "type": "esriFieldTypeString", "alias": "Grantee2", "length": 4000, "domain": null }, { "name": "consideration2", "type": "esriFieldTypeInteger", "alias": "consideration2", "domain": null }, { "name": "DocNum2", "type": "esriFieldTypeString", "alias": "DocNum2", "length": 10, "domain": null }, { "name": "Deed_Book2", "type": "esriFieldTypeString", "alias": "Deed_Book2", "length": 8, "domain": null }, { "name": "Deed_Page2", "type": "esriFieldTypeString", "alias": "Deed_Page2", "length": 8, "domain": null }, { "name": "TransType2", "type": "esriFieldTypeString", "alias": "TransType2", "length": 2, "domain": null }, { "name": "deedtype2", "type": "esriFieldTypeString", "alias": "deedtype2", "length": 2, "domain": null }, { "name": "Pxfer_date3", "type": "esriFieldTypeDate", "alias": "Pxfer_date3", "length": 8, "domain": null }, { "name": "owners3", "type": "esriFieldTypeString", "alias": "owners3", "length": 4000, "domain": null }, { "name": "Grantee3", "type": "esriFieldTypeString", "alias": "Grantee3", "length": 4000, "domain": null }, { "name": "consideration3", "type": "esriFieldTypeInteger", "alias": "consideration3", "domain": null }, { "name": "DocNum3", "type": "esriFieldTypeString", "alias": "DocNum3", "length": 10, "domain": null }, { "name": "Deed_Book3", "type": "esriFieldTypeString", "alias": "Deed_Book3", "length": 8, "domain": null }, { "name": "Deed_Page3", "type": "esriFieldTypeString", "alias": "Deed_Page3", "length": 8, "domain": null }, { "name": "TransType3", "type": "esriFieldTypeString", "alias": "TransType3", "length": 2, "domain": null }, { "name": "deedtype3", "type": "esriFieldTypeString", "alias": "deedtype3", "length": 2, "domain": null }, { "name": "quart_imp", "type": "esriFieldTypeInteger", "alias": "quart_imp", "domain": null }, { "name": "quart_land", "type": "esriFieldTypeInteger", "alias": "quart_land", "domain": null }, { "name": "quart_total", "type": "esriFieldTypeInteger", "alias": "quart_total", "domain": null }, { "name": "quart_effdate", "type": "esriFieldTypeString", "alias": "quart_effdate", "length": 10, "domain": null }, { "name": "SiteRating", "type": "esriFieldTypeString", "alias": "SiteRating", "length": 12, "domain": null }, { "name": "SiteRatingDesc", "type": "esriFieldTypeString", "alias": "SiteRatingDesc", "length": 8, "domain": null }, { "name": "PARCELS.NORFOLKGIS.Real_Estate_Data2.area", "type": "esriFieldTypeInteger", "alias": "area", "domain": null }, { "name": "UpdtDate", "type": "esriFieldTypeDate", "alias": "UpdtDate", "length": 8, "domain": null } ], "indexes": [ { "name": "R14717_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_28457_Routin", "fields": "Routing_number", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PARCELS.NORFOLKGIS.Parcels", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Routing_number", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }