{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "FACILITY WALL DETAIL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACBUILDINGNAME", "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": "DETAILTYPE", "type": "esriFieldTypeString", "alias": "Detail Type", "length": 50, "domain": { "type": "codedValue", "name": "FacWallDetailType", "description": "Wall detail type", "codedValues": [ { "name": "Joint", "code": "Joint" }, { "name": "Window", "code": "Window" }, { "name": "Penetration", "code": "Penetration" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DETAILDESCRIPTION", "type": "esriFieldTypeString", "alias": "Detail Description", "length": 50, "domain": { "type": "codedValue", "name": "FacWallDetailDescription", "description": "Wall detail descriptions", "codedValues": [ { "name": "Control Joint", "code": "Control Joint" }, { "name": "Expansion Joint", "code": "Expansion Joint" }, { "name": "Frame Sealant", "code": "Frame Sealant" }, { "name": "Glazing / Putty", "code": "Glazing / Putty" }, { "name": "Structural Gasket", "code": "Structural Gasket" }, { "name": "Frame", "code": "Frame" }, { "name": "Punched", "code": "Punched" }, { "name": "Ribbon", "code": "Ribbon" }, { "name": "Strip", "code": "Strip" }, { "name": "Window Wall", "code": "Window Wall" }, { "name": "Doors", "code": "Doors" }, { "name": "Duct Work", "code": "Duct Work" }, { "name": "Entrances", "code": "Entrances" }, { "name": "Louvers", "code": "Louvers" }, { "name": "Piping", "code": "Piping" }, { "name": "Roll Up / Overhead Door", "code": "Roll Up / Overhead Door" }, { "name": "Air Conditioner", "code": "Air Conditioner" }, { "name": "Scupper", "code": "Scupper" }, { "name": "Supports", "code": "Supports" }, { "name": "Light Fixture", "code": "Light Fixture" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DETAILCONDITION", "type": "esriFieldTypeString", "alias": "Detail Condition", "length": 50, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DETAILQTY", "type": "esriFieldTypeInteger", "alias": "Detail Quanity", "domain": null }, { "name": "DETAILUNIT", "type": "esriFieldTypeString", "alias": "Detail Unit", "length": 50, "domain": null }, { "name": "DETAILPENETRATIONCOUNT", "type": "esriFieldTypeSmallInteger", "alias": "Detail Penetration Count", "domain": null }, { "name": "FACBUILDINGNAME", "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": "FACSECTIONAREA", "type": "esriFieldTypeString", "alias": "Facility Section Area", "length": 50, "domain": null }, { "name": "FACSECTIONDESCRIPTION", "type": "esriFieldTypeString", "alias": "Facility Section Description", "length": 100, "domain": null }, { "name": "FOREIGNKEY", "type": "esriFieldTypeString", "alias": "Foreign Key", "length": 50, "domain": null }, { "name": "DETAIL_IMG", "type": "esriFieldTypeString", "alias": "Detail Image", "length": 90, "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": "G131FOREIGNKEY", "fields": "FOREIGNKEY", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "facWALL", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "FOREIGNKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B1436FE0-3929-43CA-BA60-0B6CB3A68545}" } ], "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 } }