{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 11, "name": "BUILDING_DETAILS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "STRAP", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "STRAP", "type": "esriFieldTypeString", "alias": "STRAP", "length": 25, "domain": null }, { "name": "BuildingNumber", "type": "esriFieldTypeInteger", "alias": "BuildingNumber", "domain": null }, { "name": "EffectiveYearBuilt", "type": "esriFieldTypeSmallInteger", "alias": "EffectiveYearBuilt", "domain": null }, { "name": "YearBuilt", "type": "esriFieldTypeSmallInteger", "alias": "YearBuilt", "domain": null }, { "name": "BuildingType", "type": "esriFieldTypeString", "alias": "BuildingType", "length": 50, "domain": { "type": "codedValue", "name": "Building_ExtType", "description": "Building exterior type", "codedValues": [ { "name": "Auditorium", "code": "CAUD" }, { "name": "Bank-Central Office", "code": "CBBG" }, { "name": "Bank-Branch", "code": "CBBR" }, { "name": "Boat Storage Building", "code": "CBOA" }, { "name": "Bowling Alley", "code": "CBOW" }, { "name": "Mini-Bank (Walkup & Drivethrough)", "code": "CBSM" }, { "name": "Commercial Condo (Flex/Warehouse)", "code": "CCFX" }, { "name": "Country Club", "code": "CCLB" }, { "name": "Clubhouse", "code": "CCLH" }, { "name": "Commercial Condo (Retail/Office/Medical)", "code": "CCND" }, { "name": "Convenience Store", "code": "CCON" }, { "name": "Department Store", "code": "CDPT" }, { "name": "Dormitory", "code": "CDRM" }, { "name": "Drug Store", "code": "CDRU" }, { "name": "Discount Store", "code": "CDSC" }, { "name": "Golf Cart Storage", "code": "CGLF" }, { "name": "Greenhouse", "code": "CGRN" }, { "name": "Hotel Full Service", "code": "CHFS" }, { "name": "Hotel Limited Service", "code": "CHLT" }, { "name": "Motel", "code": "CHMT" }, { "name": "Hotel Condominium", "code": "CHTC" }, { "name": "Kennel", "code": "CKEN" }, { "name": "Drycleaner", "code": "CLDC" }, { "name": "Laundry", "code": "CLDY" }, { "name": "Condo Cluster", "code": "CLUS" }, { "name": "Retail Mall", "code": "CMAL" }, { "name": "Medical Office Building", "code": "CMED" }, { "name": "Multifamily Structure (Comm)", "code": "CMFR" }, { "name": "Commercial Manufactured Housing Structure", "code": "CMHS" }, { "name": "Museum", "code": "CMUS" }, { "name": "Office Building", "code": "COFF" }, { "name": "Parking Structure", "code": "CPKG" }, { "name": "Metal, Pole, Quonset", "code": "CPOL" }, { "name": "Bar", "code": "CRBR" }, { "name": "Cafeteria", "code": "CRCF" }, { "name": "Retail Store", "code": "CRET" }, { "name": "Quick Service Restaurant", "code": "CRFF" }, { "name": "Lounge", "code": "CRLG" }, { "name": "Restroom Building", "code": "CRRB" }, { "name": "Casual Dining Restaurant", "code": "CRST" }, { "name": "Shopping Center", "code": "CSCT" }, { "name": "Single Family Structure (Comm)", "code": "CSFR" }, { "name": "Commercial Studio", "code": "CSTD" }, { "name": "Supermarket", "code": "CSUP" }, { "name": "Theater", "code": "CTHE" }, { "name": "Commercial Utility Building", "code": "CUTB" }, { "name": "Veterinary Hospital", "code": "CVET" }, { "name": "Car Wash Building", "code": "CWSH" }, { "name": "Condo Detached", "code": "DETC" }, { "name": "Condo Duplex", "code": "DUPL" }, { "name": "Government Building", "code": "GBLG" }, { "name": "Post Office", "code": "GFPO" }, { "name": "Fire Station", "code": "GFST" }, { "name": "Library", "code": "GLIB" }, { "name": "Condo High-Rise", "code": "HRIS" }, { "name": "Assisted Living Facility/Memory Care", "code": "IASL" }, { "name": "Church", "code": "ICHU" }, { "name": "Church W/Sunday School", "code": "ICHX" }, { "name": "Fellowship Hall", "code": "IFLW" }, { "name": "Fraternal Building", "code": "IFRA" }, { "name": "Hospital General", "code": "IHSG" }, { "name": "Outpatient (Surgical) Center", "code": "IHSO" }, { "name": "Independent Living Facility", "code": "IILF" }, { "name": "Mausoleum/Crypt/Niches", "code": "IMAU" }, { "name": "Mortuary", "code": "IMOR" }, { "name": "Nursing Home", "code": "INSG" }, { "name": "School, Elementary & Secondary", "code": "ISC1" }, { "name": "School, Colleges & Universities", "code": "ISC2" }, { "name": "Day-Care Center", "code": "ISCP" }, { "name": "Condo Low-Rise", "code": "LRIS" }, { "name": "Apartments Garden", "code": "MFGA" }, { "name": "Apartments High Rise", "code": "MFHR" }, { "name": "Apartments Mid Rise", "code": "MFMR" }, { "name": "Multi-Family Conversion", "code": "MFRC" }, { "name": "Multi-Family Res Structure", "code": "MFRS" }, { "name": "MfH home dbl-wide", "code": "MHDW" }, { "name": "MfH/mobile home single", "code": "MHSW" }, { "name": "Condo Mid-Rise", "code": "MRIS" }, { "name": "Mini-Lube Building", "code": "NAML" }, { "name": "Vehicular Service Center", "code": "NASC" }, { "name": "Complete Auto Dealership", "code": "NASR" }, { "name": "Broadcasting Facilities", "code": "NBRD" }, { "name": "Distribution Warehouse", "code": "NDST" }, { "name": "Industrial Flexspace", "code": "NFLX" }, { "name": "Heavy Industrial Warehouse", "code": "NHVY" }, { "name": "Light Industrial Warehouse", "code": "NLGT" }, { "name": "Manufacturing Warehouse", "code": "NMAN" }, { "name": "Mini-Storage High Rise", "code": "NMHR" }, { "name": "Mini-Storage", "code": "NMIN" }, { "name": "Mega Warehouse", "code": "NMWH" }, { "name": "Storage/Warehouse", "code": "NSTO" }, { "name": "Service Garage", "code": "NSVC" }, { "name": "Telephone Building", "code": "NTEL" }, { "name": "Res Accessory Bldg", "code": "RACC" }, { "name": "Complex Congregate Living Facility", "code": "RCLF" }, { "name": "Condo Rowhouse", "code": "ROW" }, { "name": "Single Family - Att/End", "code": "SFAE" }, { "name": "Single Family - Att/Inside", "code": "SFAI" }, { "name": "Single Family Detached", "code": "SFRD" }, { "name": "Res Studio Unit", "code": "STDO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TotalBuildingArea", "type": "esriFieldTypeInteger", "alias": "TotalBuildingArea", "domain": null }, { "name": "FinishedArea", "type": "esriFieldTypeInteger", "alias": "FinishedArea", "domain": null }, { "name": "PropertyAddress", "type": "esriFieldTypeString", "alias": "PropertyAddress", "length": 255, "domain": null }, { "name": "ExteriorWalls", "type": "esriFieldTypeString", "alias": "ExteriorWalls", "length": 55, "domain": null }, { "name": "FIREPLACE", "type": "esriFieldTypeString", "alias": "Fireplace", "length": 55, "domain": null }, { "name": "FRAME", "type": "esriFieldTypeString", "alias": "FRAME", "length": 55, "domain": { "type": "codedValue", "name": "Building_Frame", "description": "Building frame field", "codedValues": [ { "name": "Masonry or poured concrete load bearing walls", "code": "1" }, { "name": "Metal Bents, columns girders w/o fireproofing", "code": "2" }, { "name": "Reinf conc columns & beams fire resistant constr", "code": "3" }, { "name": "Fireproof structural steel columns and beams", "code": "4" }, { "name": "Wood and/or steel studs in bearing walls", "code": "5" }, { "name": "Poles w/purlins", "code": "6" }, { "name": "Structural insulated panel", "code": "7" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HeatAir", "type": "esriFieldTypeString", "alias": "HeatAir", "length": 55, "domain": { "type": "codedValue", "name": "Building_HeatAir", "description": "Building HVAC", "codedValues": [ { "name": "Heat-Ventilation-Air Cond", "code": "1" }, { "name": "Air Cond, ducted or pkg unit", "code": "2" }, { "name": "Heat only or window A/C", "code": "3" }, { "name": "Heat & Air Cond, ducted", "code": "4" }, { "name": "Wall A/C", "code": "5" }, { "name": "No Air Cond or Heat", "code": "6" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RoofStructure", "type": "esriFieldTypeString", "alias": "RoofStructure", "length": 55, "domain": { "type": "codedValue", "name": "Building_Roof_Structure", "description": "Building roof structure txt", "codedValues": [ { "name": "Round/Dome", "code": "1" }, { "name": "Flat (<2:12 pitch)", "code": "2" }, { "name": "Low pitch shed roof", "code": "3" }, { "name": "Gable", "code": "4" }, { "name": "Gable (Primarily)", "code": "5" }, { "name": "Gambrel", "code": "6" }, { "name": "Hip roof", "code": "7" }, { "name": "Hip (Primarily)", "code": "8" }, { "name": "Mansard", "code": "9" }, { "name": "Monitor", "code": "10" }, { "name": "None", "code": "11" }, { "name": "Sawtooth", "code": "12" }, { "name": "Shed roof", "code": "13" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RoofMaterial", "type": "esriFieldTypeString", "alias": "RoofMaterial", "length": 55, "domain": { "type": "codedValue", "name": "Building_RoofCover", "description": "Building type of roofing", "codedValues": [ { "name": "Corrugated Asbestos", "code": "1" }, { "name": "Asbestos Shingles (Pre-1960)", "code": "2" }, { "name": "Asphalt or fbrgls shingles", "code": "3" }, { "name": "Built-up tar & gravel", "code": "4" }, { "name": "Cedar Shakes", "code": "5" }, { "name": "Clay Tile", "code": "6" }, { "name": "Concrete", "code": "7" }, { "name": "ConcTile", "code": "8" }, { "name": "Enameled Metal", "code": "9" }, { "name": "Fiberglass sheets", "code": "10" }, { "name": "Elastomeric Membrane", "code": "11" }, { "name": "Metal, galvanized", "code": "12" }, { "name": "Metal, finished", "code": "13" }, { "name": "None", "code": "14" }, { "name": "Composition, roll", "code": "15" }, { "name": "Sheet Mtl corrugated", "code": "16" }, { "name": "Slate", "code": "17" }, { "name": "Solar Tile", "code": "18" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LivingUnits", "type": "esriFieldTypeString", "alias": "LivingUnits", "length": 10, "domain": null }, { "name": "BATHROOMS", "type": "esriFieldTypeString", "alias": "BATHROOMS", "length": 10, "domain": null }, { "name": "BEDROOMS", "type": "esriFieldTypeString", "alias": "BEDROOMS", "length": 10, "domain": null }, { "name": "NumberOfStories", "type": "esriFieldTypeString", "alias": "NumberOfStories", "length": 10, "domain": null }, { "name": "HalfBaths", "type": "esriFieldTypeString", "alias": "HalfBaths", "length": 10, "domain": null }, { "name": "ROOMS", "type": "esriFieldTypeString", "alias": "ROOMS", "length": 10, "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 } ], "indexes": [ { "name": "R1227_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "bb6bad4bb17b4173add34720487ad004" }