{ "currentVersion": 10.81, "id": 15, "name": "Life Safety", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 50, "domain": null }, { "name": "Location_Desc", "type": "esriFieldTypeString", "alias": "Location Description", "length": 250, "domain": null }, { "name": "Install_Date", "type": "esriFieldTypeDate", "alias": "Installation Date", "length": 8, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 100, "domain": null }, { "name": "Serial_Number", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 100, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "Size", "type": "esriFieldTypeDouble", "alias": "Size", "domain": null }, { "name": "Warranty_Date", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeInteger", "alias": "Condition", "domain": null }, { "name": "Condition_Date", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "Image_File", "type": "esriFieldTypeString", "alias": "Image", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "AssetType", "type": "esriFieldTypeString", "alias": "AssetType", "length": 20, "domain": { "type": "codedValue", "name": "PW.Facilities.AssetType", "description": "City Works", "codedValues": [ { "name": "A/C Unit", "code": "AC" }, { "name": "AHU", "code": "AHU" }, { "name": "Air Quality", "code": "AQ" }, { "name": "Appliance", "code": "A" }, { "name": "Blower", "code": "BL" }, { "name": "Boiler", "code": "BO" }, { "name": "Car Wash System", "code": "CWS" }, { "name": "Ceiling", "code": "CEI" }, { "name": "Chiller", "code": "CHI" }, { "name": "Coil", "code": "COI" }, { "name": "Condenser", "code": "CON" }, { "name": "Door", "code": "DOR" }, { "name": "Electrical Service", "code": "ES" }, { "name": "Elevator", "code": "ELE" }, { "name": "Equipment", "code": "EQU" }, { "name": "EV Charging Station", "code": "EVCS" }, { "name": "Exhaust Fan", "code": "EF" }, { "name": "Eye Wash", "code": "EW" }, { "name": "Facade", "code": "FAC" }, { "name": "Fan", "code": "FAN" }, { "name": "Filter Frame", "code": "FF" }, { "name": "Fire Alarm", "code": "FA" }, { "name": "Fire Extinguisher", "code": "FE" }, { "name": "Fire Suppression", "code": "FS" }, { "name": "Fixture", "code": "FIX" }, { "name": "Floor", "code": "FLR" }, { "name": "Fuel Pump", "code": "FP" }, { "name": "Fuel Tank", "code": "FT" }, { "name": "Garage Door Opener", "code": "GDO" }, { "name": "Gas Range", "code": "GR" }, { "name": "Generator", "code": "GEN" }, { "name": "Heater", "code": "HTR" }, { "name": "HVAC Control System", "code": "HVACCS" }, { "name": "Ice Machine", "code": "IM" }, { "name": "Industrial Fan", "code": "IF" }, { "name": "Infrared Heater", "code": "IH" }, { "name": "Instrumentation/Control Panel", "code": "ICP" }, { "name": "Inverter and Solar Panels", "code": "ISP" }, { "name": "Lavatory", "code": "LAV" }, { "name": "Leak Detection", "code": "LD" }, { "name": "Lighting", "code": "LGT" }, { "name": "Lighting Controls", "code": "LC" }, { "name": "Meter", "code": "MET" }, { "name": "Oil Seperator", "code": "OS" }, { "name": "Parking", "code": "PAR" }, { "name": "Piping", "code": "PIP" }, { "name": "Pump", "code": "PUM" }, { "name": "Range Hood", "code": "RH" }, { "name": "Roof", "code": "ROF" }, { "name": "Septic Pump and Alarm Control Panel", "code": "SPACP" }, { "name": "Sign", "code": "SGN" }, { "name": "Sprinkler", "code": "SPR" }, { "name": "Stadium Lighting Controls", "code": "SLC" }, { "name": "Storage Unit", "code": "SU" }, { "name": "Transformer", "code": "TRAN" }, { "name": "Truss", "code": "TRU" }, { "name": "VFD", "code": "VFD" }, { "name": "Wall", "code": "WAL" }, { "name": "Washing Machine", "code": "WM" }, { "name": "Water Closet", "code": "WC" }, { "name": "Water Heater", "code": "WH" }, { "name": "Windows", "code": "WIN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "ParentID", "length": 20, "domain": { "type": "codedValue", "name": "PW.Facilities.ParentID", "description": "City Works ", "codedValues": [ { "name": "Carrboro Elementary School", "code": "CES" }, { "name": "Century Center Building", "code": "CCB" }, { "name": "Fire Station 1", "code": "FS1" }, { "name": "Fire Station 2", "code": "FS2" }, { "name": "Groundskeeper Building", "code": "GB" }, { "name": "Public Works", "code": "PW" }, { "name": "Town Commons", "code": "TC" }, { "name": "Town Hall", "code": "TH" }, { "name": "Well House", "code": "WH" }, { "name": "Hank Anderson Park", "code": "HAP" }, { "name": "Wilson Park", "code": "WP" }, { "name": "Adams Tract Trail", "code": "AT" }, { "name": "Anderson Park Dog Park", "code": "DP" }, { "name": "Municipal Parking Weaver Street lot", "code": "tWS" }, { "name": "Municipal Parking S Greensboro lot", "code": "tSG" }, { "name": "Municipal Parking E Main lot", "code": "tEM" }, { "name": "Municipal Parking Laurel lot", "code": "tLA" }, { "name": "Municipal Parking Rosemary lot", "code": "tRS" }, { "name": "Municipal Parking Century Center lot", "code": "tCC" }, { "name": "Municipal Parking Town Commons lot", "code": "tTC" }, { "name": "Municipal Parking Town Hall lot", "code": "tTH" }, { "name": "Martin Luther King Park", "code": "MLK" }, { "name": "Baldwin Park", "code": "BP" }, { "name": "Public Works Outbuildings", "code": "PWO" }, { "name": "Municipal Parking gravel lot Roberson and E Main", "code": "tARG" }, { "name": "Municipal Parking Century Center Police lot", "code": "tPD" }, { "name": "Municipal Parking Fire Station 2 lot", "code": "tFS2" }, { "name": "Municipal Parking Anderson Park lot", "code": "tHAP" }, { "name": "Municipal Parking Public Works lot", "code": "tPW" }, { "name": "Municipal Parking Wilson Park lot", "code": "tWP" }, { "name": "Westwood Cemetery", "code": "pWEST" }, { "name": "Old Cemetery", "code": "pOLD" }, { "name": "Weaver Cemetery", "code": "pWEAV" }, { "name": "Century Center Property", "code": "pCC" }, { "name": "Town Hall Property", "code": "pTH" }, { "name": "Public Works Property", "code": "pPW" }, { "name": "Fire Station 2 Property", "code": "pFS2" }, { "name": "108 Bim Street Property", "code": "pBIM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 100, "domain": null }, { "name": "AssetStatus", "type": "esriFieldTypeString", "alias": "AssetStatus", "length": 20, "domain": { "type": "codedValue", "name": "PW.Facilities.AssetStatus", "description": "City Works", "codedValues": [ { "name": "Active", "code": "ACT" }, { "name": "Abandoned", "code": "ABD" }, { "name": "Disposed", "code": "DIS" }, { "name": "Under Repair", "code": "UR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SizeUnit", "type": "esriFieldTypeString", "alias": "SizeUnit", "length": 10, "domain": { "type": "codedValue", "name": "PW.Facilities.SizeUnits", "description": "City Works", "codedValues": [ { "name": "Inches", "code": "in" }, { "name": "Feet", "code": "ft" }, { "name": "Yards", "code": "yd" }, { "name": "Square Feet", "code": "sq ft" }, { "name": "Acres", "code": "acre" }, { "name": "Cubic Inches", "code": "cu in" }, { "name": "Cubic Feet", "code": "cu ft" }, { "name": "Cubic Yards", "code": "cu yd" }, { "name": "Fluid Ounces", "code": "fl oz" }, { "name": "Gallons", "code": "gal" }, { "name": "Ounces", "code": "oz" }, { "name": "Pounds", "code": "lb" }, { "name": "Kilograms", "code": "kg" }, { "name": "Horsepower", "code": "hp" }, { "name": "Meters", "code": "m" }, { "name": "Gallons per Minute", "code": "gpm" }, { "name": "Tons", "code": "t" }, { "name": "BTUs", "code": "btu" }, { "name": "Cubic Feet per Minute", "code": "cfm" }, { "name": "Pounds per Square Inch", "code": "psi" }, { "name": "Watts", "code": "w" }, { "name": "Amperes", "code": "amp" }, { "name": "Kilo-Volt-Ampere", "code": "kva" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Name", "length": 100, "domain": null } ], "indexes": [ { "name": "R264_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_264", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3436ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_264", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Buildings", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 20, "name": "Parks", "relatedTableId": 20, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "ParkingLots", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }