{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "FACILITY WALL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BUILDINGNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 50, "domain": null }, { "name": "SECTIONDESCRIPTION", "type": "esriFieldTypeString", "alias": "Section Description", "length": 70, "domain": null }, { "name": "MAINWALLTYPE", "type": "esriFieldTypeString", "alias": "Main Wall Type", "length": 50, "domain": { "type": "codedValue", "name": "FacWallTypes", "description": "Facility wall types", "codedValues": [ { "name": "Brick Veneer", "code": "Brick Veneer" }, { "name": "CMU", "code": "CMU" }, { "name": "Curtain Wall", "code": "Curtain Wall" }, { "name": "EFIS", "code": "EFIS" }, { "name": "Insulated Metal Panel", "code": "Insulated Metal Panel" }, { "name": "Plaster", "code": "Plaster" }, { "name": "Poured in Place Concrete", "code": "Poured in Place Concrete" }, { "name": "Pre-Cast Concrete", "code": "Pre-Cast Concrete" }, { "name": "Sloped Glazing", "code": "Sloped Glazing" }, { "name": "Stone Cladding", "code": "Stone Cladding" }, { "name": "Storefront", "code": "Storefront" }, { "name": "Stucco", "code": "Stucco" }, { "name": "Window Wall", "code": "Window Wall" }, { "name": "Transite Panels", "code": "Transite Panels" }, { "name": "Wood", "code": "Wood" }, { "name": "Steel - Stainless Steel", "code": "Steel - Stainledd Steel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINSTRUCTURALTYPE", "type": "esriFieldTypeString", "alias": "Main Structural Type", "length": 50, "domain": { "type": "codedValue", "name": "FacWallStructuralType", "description": "Facility wall structural types", "codedValues": [ { "name": "Load Bearing CMU", "code": "Load Bearing CMU" }, { "name": "Poured in Place Concrete", "code": "Poured in Place Concrete" }, { "name": "Pre-Cast Concrete", "code": "Pre-Cast Concrete" }, { "name": "Steel Framing", "code": "Steel Framing" }, { "name": "Wood", "code": "Wood" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WALLAREASIZE", "type": "esriFieldTypeString", "alias": "Wall Area Size", "length": 50, "domain": null }, { "name": "RATING", "type": "esriFieldTypeString", "alias": "Rating ", "length": 50, "domain": { "type": "codedValue", "name": "Rating", "description": "Ratings", "codedValues": [ { "name": "Poor", "code": "Poor" }, { "name": "Fair", "code": "Fair" }, { "name": "Good", "code": "Good" }, { "name": "Excellent", "code": "Excellent" }, { "name": "N/A", "code": "N/A" }, { "name": "Replace ASAP", "code": "Replace ASAP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CONDITION_INDEX", "type": "esriFieldTypeSmallInteger", "alias": "Condition Index", "domain": null }, { "name": "BUILDINGNAME", "type": "esriFieldTypeString", "alias": "Building Name", "length": 50, "domain": { "type": "codedValue", "name": "FACILITYBUILDINGS", "description": "A list of City owned buildings. Mostly used by Facilities for CityWorks", "codedValues": [ { "name": "Animal Shelter", "code": "Animal Shelter" }, { "name": "Breckinridge Park", "code": "Breckinridge Park" }, { "name": "Canyon Creek Pool", "code": "Canyon Creek Pool" }, { "name": "City Hall / Civic Center", "code": "City Hall / Civic Center" }, { "name": "Eastside Pump Station", "code": "Eastside Pump Station" }, { "name": "Eisemann Center", "code": "Eisemann Center" }, { "name": "Fire Station 1", "code": "Fire Station 1" }, { "name": "Fire Station 2", "code": "Fire Station 2" }, { "name": "Fire Station 3", "code": "Fire Station 3" }, { "name": "Fire Station 4", "code": "Fire Station 4" }, { "name": "Fire Station 5", "code": "Fire Station 5" }, { "name": "Fire Station 6", "code": "Fire Station 6" }, { "name": "Fire Training Center / Emergency Operations Center", "code": "Fire Training Center / Emergency Operations Center" }, { "name": "Glenville Trailer", "code": "Glenville Trailer" }, { "name": "Golf Pavillion", "code": "Golf Pavillion" }, { "name": "Golf Pro Shop", "code": "Golf Prop Shop" }, { "name": "Greenhouse", "code": "Greenhouse" }, { "name": "Gymnastics Center", "code": "Gymnastics Center" }, { "name": "Heights Aquatic Center", "code": "Heights Aquatic Center" }, { "name": "Heights Recreation Center", "code": "Heights Recreation Center" }, { "name": "Huffhines Ballparks", "code": "Huffhines Ballparks" }, { "name": "Huffhines Recreation Center", "code": "Huffhines Recreation Center" }, { "name": "Library", "code": "Library" }, { "name": "Municipal Court", "code": "Municipal Court" }, { "name": "Northside Pump Station", "code": "Northside Pump Station" }, { "name": "Parks North House (Breckinridge)", "code": "Parks North House (Breckinridge)" }, { "name": "Parks Office (Breckinridge)", "code": "Parks Office (Breckinridge)" }, { "name": "Parks South House (Breckinridge)", "code": "Parks South House (Breckinridge)" }, { "name": "Police Public Safety Building", "code": "Police Public Safety Building" }, { "name": "Police Substation", "code": "Police Substation" }, { "name": "Radio Building Site - Centennial EST", "code": "Radio Building Site - Centennial EST" }, { "name": "Radio Building Site - Holly EST", "code": "Radio Building Site - Holly EST" }, { "name": "Radio Building Site - Shiloh", "code": "Radio Building Site - Shiloh" }, { "name": "Senior Center", "code": "Senior Center" }, { "name": "Service Center", "code": "Service Center" }, { "name": "Shiloh Pump Station", "code": "Shiloh Pump Station" }, { "name": "Tennis Center", "code": "Tennis Center" }, { "name": "Westside Pump Station", "code": "Westside Pump Station" }, { "name": "Women's Center", "code": "Women's Center" }, { "name": "Jail/Detention Center", "code": "Jail/Detention Center" }, { "name": "Support Building", "code": "Support Building" }, { "name": "IQHQ", "code": "IQHQ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WALLAREA_INTERIORUSE", "type": "esriFieldTypeString", "alias": "Wall Area - Interior Use", "length": 50, "domain": { "type": "codedValue", "name": "FacInteriorUse", "description": "Facility interior use", "codedValues": [ { "name": "Laboratory", "code": "Laboratory" }, { "name": "High Hazard", "code": "High Hazard" }, { "name": "Assembly", "code": "Assembly" }, { "name": "Business", "code": "Business" }, { "name": "Non-Building", "code": "Non-Building" }, { "name": "Rental", "code": "Rental" }, { "name": "Mercantile", "code": "Mercantile" }, { "name": "Storage", "code": "Storage" }, { "name": "Educational", "code": "Educational" }, { "name": "Factory and Industrial", "code": "Factory and Industrial" }, { "name": "Institutional", "code": "Institutional" }, { "name": "Residential", "code": "Residential" }, { "name": "Utility", "code": "Utility" }, { "name": "Other", "code": "Other" }, { "name": "Cafeteria", "code": "Cafeteria" }, { "name": "Office", "code": "Office" }, { "name": "Maintenance", "code": "Maintenance" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "COSTFACTOR", "type": "esriFieldTypeString", "alias": "Cost Factor", "length": 50, "domain": { "type": "codedValue", "name": "FacilityCostFactor", "description": "Facility cost factors", "codedValues": [ { "name": "Low", "code": "Low" }, { "name": "Medium", "code": "Medium" }, { "name": "High", "code": "High" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "YEARINSTALLED", "type": "esriFieldTypeInteger", "alias": "Year Installed", "domain": null }, { "name": "INSTALLDATECONFIDENCE", "type": "esriFieldTypeString", "alias": "Install Date Confidence", "length": 50, "domain": { "type": "codedValue", "name": "KnownEstimated", "description": "Known/Estimated for install date confidance", "codedValues": [ { "name": "Known", "code": "Known" }, { "name": "Estimated", "code": "Estimated" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "NUMBEROFFLOORS", "type": "esriFieldTypeSmallInteger", "alias": "Number of Floors", "domain": null }, { "name": "WALLHEIGHT", "type": "esriFieldTypeString", "alias": "Wall Height", "length": 50, "domain": null }, { "name": "SUSPECTEDLEADPAINT", "type": "esriFieldTypeString", "alias": "Suspected Lead Paint", "length": 50, "domain": null }, { "name": "INTERIOR_SENSITIVITY", "type": "esriFieldTypeString", "alias": "Interior Sensitivity", "length": 50, "domain": { "type": "codedValue", "name": "FacilityInteriorSensitivity", "description": "Facility interior sensitivity", "codedValues": [ { "name": "Low", "code": "Low" }, { "name": "Normal", "code": "Normal" }, { "name": "High", "code": "High" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FOREIGNKEY", "type": "esriFieldTypeString", "alias": "Foreign Key", "length": 50, "domain": null }, { "name": "AREADETAILDRAWING", "type": "esriFieldTypeString", "alias": "Area Detail Drawing", "length": 80, "domain": null }, { "name": "IMG_1", "type": "esriFieldTypeString", "alias": "Asset Image", "length": 80, "domain": null }, { "name": "LIFECYCLESTATUS", "type": "esriFieldTypeString", "alias": "Life Cycle Status", "length": 50, "domain": { "type": "codedValue", "name": "LifeCycleStatus", "description": "The status or life cycle of the feature", "codedValues": [ { "name": "Abandoned in Place", "code": "Abandoned in Place" }, { "name": "Active", "code": "Active" }, { "name": "Feature Changed", "code": "Feature Changed" }, { "name": "Proposed", "code": "Proposed" }, { "name": "Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G121FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G121FOREIGNKEY", "fields": "FOREIGNKEY", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "facWALL_Detail", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B1436FE0-3929-43CA-BA60-0B6CB3A68545}" }, { "id": 3, "name": "FacilityProperty", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FOREIGNKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{CB472CBE-79FC-4677-AE8B-CF1CFD70FB7E}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }