{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 18, "name": "SMALL APPLIANCES", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BUILDING_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 20, "domain": null }, { "name": "BUILDING_NAME", "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": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "Asset Type", "length": 50, "domain": { "type": "codedValue", "name": "facSmallApplianceAssetType", "description": "Asset types for the facility small appliance table", "codedValues": [ { "name": "Refrigerator", "code": "Refrigerator" }, { "name": "Ice Machine", "code": "Ice Machine" }, { "name": "Dish Washer", "code": "Dish Washer" }, { "name": "Washer", "code": "Washer" }, { "name": "Dryer", "code": "Dryer" }, { "name": "Water Cooler", "code": "Water Cooler" }, { "name": "Oven", "code": "Oven" }, { "name": "Hot Water Heater", "code": "Hot Water Heater" }, { "name": "Disposal", "code": "Disposal" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ASSET_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Asset Description", "length": 50, "domain": null }, { "name": "CONDITION_INDEX", "type": "esriFieldTypeString", "alias": "Condition Index", "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": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SERIAL_NUMBER", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "EQUIPMENT_TYPE", "type": "esriFieldTypeString", "alias": "Equipment Type", "length": 50, "domain": null }, { "name": "EST_SERVICE_LIFE", "type": "esriFieldTypeString", "alias": "Estimated Service Life", "length": 50, "domain": null }, { "name": "YEAR_INSTALLED", "type": "esriFieldTypeString", "alias": "Year Installed", "length": 50, "domain": null }, { "name": "INSTALLDATE_CONFIDENCE", "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": "AREA_SERVED", "type": "esriFieldTypeString", "alias": "Area Served", "length": 50, "domain": null }, { "name": "AMPS", "type": "esriFieldTypeString", "alias": "Amps", "length": 50, "domain": null }, { "name": "REFRIGERANT_TYPE", "type": "esriFieldTypeString", "alias": "Refrigerant Type", "length": 50, "domain": null }, { "name": "SIZE", "type": "esriFieldTypeString", "alias": "Size", "length": 50, "domain": null }, { "name": "VOLTAGE", "type": "esriFieldTypeString", "alias": "Voltage", "length": 50, "domain": null }, { "name": "POWER_SUPPLY", "type": "esriFieldTypeString", "alias": "Power Supply", "length": 50, "domain": null }, { "name": "DUTY", "type": "esriFieldTypeString", "alias": "Duty", "length": 50, "domain": { "type": "codedValue", "name": "facSmallApplianceDuty", "description": "Duty types for the facility small appliance table", "codedValues": [ { "name": "Commercial", "code": "Commercial" }, { "name": "Residential", "code": "Residential" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "IMG_1", "type": "esriFieldTypeString", "alias": "Asset Image 1", "length": 100, "domain": null }, { "name": "IMG_2", "type": "esriFieldTypeString", "alias": "Asset Image 2", "length": 100, "domain": null }, { "name": "NOTES_1", "type": "esriFieldTypeString", "alias": "Notes", "length": 100, "domain": null }, { "name": "NOTES_2", "type": "esriFieldTypeString", "alias": "Notes 2", "length": 100, "domain": null }, { "name": "LIFE_CYCLE", "type": "esriFieldTypeString", "alias": "Life Cycle", "length": 50, "domain": null }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeString", "alias": "Warranty Date", "length": 50, "domain": null }, { "name": "FLOOR", "type": "esriFieldTypeString", "alias": "Floor", "length": 50, "domain": null }, { "name": "UNIT_LOCATION", "type": "esriFieldTypeString", "alias": "Unit Location", "length": 50, "domain": null }, { "name": "LOCATION_NOTES", "type": "esriFieldTypeString", "alias": "Location Notes", "length": 150, "domain": null }, { "name": "FILTER", "type": "esriFieldTypeString", "alias": "Filter", "length": 50, "domain": null }, { "name": "BELT", "type": "esriFieldTypeString", "alias": "Belt", "length": 50, "domain": null }, { "name": "DEFICIENCIES", "type": "esriFieldTypeString", "alias": "Deficiencies", "length": 50, "domain": null }, { "name": "PRODUCT_DOCUMENTATION", "type": "esriFieldTypeString", "alias": "Product Documentation", "length": 150, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "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" } }, { "name": "FOREIGNKEY", "type": "esriFieldTypeString", "alias": "Foreign Key", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G128FOREIGNKEY", "fields": "FOREIGNKEY", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "LGM.FacilityProperty", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FOREIGNKEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3418AD87-E85D-49A6-AB45-11127087EADF}" } ], "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 } }