{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 19, "name": "EQUIPMENT", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LegacyID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "EstimatedEffectiveLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedEffectiveLife", "domain": null }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "length": 5, "domain": { "type": "codedValue", "name": "faFacilityName", "description": "Facility Name", "codedValues": [ { "name": "City Hall", "code": "CTYHL" }, { "name": "City Hall Garage", "code": "CTYHG" }, { "name": "Cromwell Park Restroom", "code": "CROM" }, { "name": "Echo Lake Park Restroom", "code": "ECHO" }, { "name": "Hamlin Maintenance Facility-Parks", "code": "HAMPR" }, { "name": "Hamlin Maintenance Facility-PW", "code": "HAMPW" }, { "name": "Hamlin Park Lower Restroom", "code": "HAML" }, { "name": "Hamlin Park Upper Restroom", "code": "HAMU" }, { "name": "Highland Plaza--Jensen's", "code": "HPLZB" }, { "name": "Highland Plaza--Jersey's", "code": "HPLZA" }, { "name": "Hillwood Park Restroom", "code": "HILL" }, { "name": "Kruckeberg Botanical Garden", "code": "KRUK" }, { "name": "Kruckeberg Garden Greenhouse", "code": "KRUKG" }, { "name": "North Maintenance Facility", "code": "NM" }, { "name": "North Maintenance Fueling Facility", "code": "NMFF" }, { "name": "Paramount School Park Restroom", "code": "PMNT" }, { "name": "Police Station", "code": "POLST" }, { "name": "Richmond Highlands Greenhouse", "code": "RHGH" }, { "name": "Richmond Highlands Rec Center", "code": "RHRC" }, { "name": "Richmond Highlands Restroom", "code": "RHRR" }, { "name": "Saltwater Park Lower Restroom", "code": "SALTL" }, { "name": "Saltwater Park Rental Home", "code": "SALTG" }, { "name": "Saltwater Park Upper Restroom", "code": "SALTU" }, { "name": "Shoreline Park Restroom", "code": "SHPRR" }, { "name": "Shoreline Pool", "code": "POOL" }, { "name": "Shoreview Park Lower Restroom", "code": "SHVPL" }, { "name": "Shoreview Park Upper Restroom", "code": "SHVPU" }, { "name": "Spartan Recreation Center", "code": "SPART" }, { "name": "Twin Ponds Park Restroom", "code": "TWPP" }, { "name": "Kayu Kayu Ac Restroom", "code": "KKA" }, { "name": "Ronald Office", "code": "RWWO" }, { "name": "Ronald Vehicle Storage", "code": "RWWVS" }, { "name": "Ronald Lift Station #1", "code": "RWWLS1" }, { "name": "Ronald Lift Station #2", "code": "RWWLS2" }, { "name": "Ronald Lift Station #3", "code": "RWWLS3" }, { "name": "Ronald Lift Station #4", "code": "RWWLS4" }, { "name": "Ronald Lift Station #5", "code": "RWWLS5" }, { "name": "Ronald Lift Station #6", "code": "RWWLS6" }, { "name": "Ronald Lift Station #7", "code": "RWWLS7" }, { "name": "Ronald Lift Station #8", "code": "RWWLS8" }, { "name": "Ronald Lift Station #9", "code": "RWWLS9" }, { "name": "Ronald Lift Station #11", "code": "RWWLS11" }, { "name": "Ronald Lift Station #12", "code": "RWWLS12" }, { "name": "Ronald Lift Station #13", "code": "RWWLS13" }, { "name": "Ronald Lift Station #14", "code": "RWWLS14" }, { "name": "Ronald Lift Station #15", "code": "RWWLS15" }, { "name": "City Hall Police Station", "code": "CTYPD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InstallYear", "type": "esriFieldTypeSmallInteger", "alias": "InstallYear", "domain": null }, { "name": "LicenseNum", "type": "esriFieldTypeString", "alias": "LicenseNum", "length": 10, "domain": null }, { "name": "LifeCycle", "type": "esriFieldTypeString", "alias": "LifeCycle", "length": 5, "domain": { "type": "codedValue", "name": "faLifeCycle", "description": "Facility Life Cycle", "codedValues": [ { "name": "Active", "code": "AC" }, { "name": "Inactive", "code": "INAC" }, { "name": "Retired", "code": "RET" }, { "name": "Replaced", "code": "REP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "UnitType", "type": "esriFieldTypeString", "alias": "UnitType", "length": 5, "domain": { "type": "codedValue", "name": "faEquipmentType", "description": "Equipment Type", "codedValues": [ { "name": "Generator", "code": "GEN" }, { "name": "Snow Plow", "code": "SNPL" }, { "name": "Mower", "code": "MOW" }, { "name": "Brush Chipper", "code": "BRCH" }, { "name": "Tractor", "code": "TRCTR" }, { "name": "Utility Vehicle", "code": "UV" }, { "name": "Utility Trailer", "code": "UTLTR" }, { "name": "Water Trailer", "code": "WTRTR" }, { "name": "Compressor", "code": "CMPRS" }, { "name": "Speed Display Trailer", "code": "SDT" }, { "name": "Boom Lift, Trailer-mounted", "code": "BLIFT" }, { "name": "Asphalt Crack Sealer", "code": "ASCRS" }, { "name": "Mower, Arm", "code": "MOWAR" }, { "name": "Bunker Rake, Power", "code": "BRPWR" }, { "name": "Grapple Rake, Loader Attachment", "code": "GRRLA" }, { "name": "Hopper Spreader", "code": "HOPSP" }, { "name": "Roller, Power", "code": "PROLL" }, { "name": "Power Rake, Loader Attachment", "code": "PRAKE" }, { "name": "Trencher, Loader Attachment", "code": "TRNCH" }, { "name": "Saw, Concrete", "code": "CNCSW" }, { "name": "Grinder, Concrete", "code": "CNCGR" }, { "name": "Street Sweeper", "code": "STRSW" }, { "name": "Leveller", "code": "LEV" }, { "name": "Fork", "code": "FRK" }, { "name": "Clamshell", "code": "CLAM" }, { "name": "Auger", "code": "AUG" }, { "name": "Broom", "code": "BROOM" }, { "name": "Snow Blade", "code": "BLADE" }, { "name": "Asphalt Patching", "code": "ASPHP" }, { "name": "Backhoe", "code": "BACKH" }, { "name": "Rotoliller", "code": "ROTTL" }, { "name": "All Terrain Vehicle", "code": "ATV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "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 }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 30, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 130, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "OwnedBy", "type": "esriFieldTypeString", "alias": "OwnedBy", "length": 6, "domain": null }, { "name": "FloorID", "type": "esriFieldTypeString", "alias": "FloorID", "length": 5, "domain": { "type": "codedValue", "name": "faFloorID", "description": "Floor level number", "codedValues": [ { "name": "Basement", "code": "B" }, { "name": "Roof", "code": "R" }, { "name": "1st Floor", "code": "1" }, { "name": "2nd Floor", "code": "2" }, { "name": "3rd Floor", "code": "3" }, { "name": "4th Floor", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BuildingID", "type": "esriFieldTypeString", "alias": "BuildingID", "length": 35, "domain": null }, { "name": "Year", "type": "esriFieldTypeString", "alias": "Year", "length": 4, "domain": null }, { "name": "EquipmentID", "type": "esriFieldTypeString", "alias": "EquipmentID", "length": 50, "domain": null }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Vendor", "length": 50, "domain": null }, { "name": "RetireDate", "type": "esriFieldTypeDate", "alias": "RetireDate", "length": 8, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 55, "domain": null } ], "indexes": [ { "name": "R2003_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2003", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_2003", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_55622_Facili", "fields": "Facility", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_55622_Buildi", "fields": "BuildingID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": false }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "5e76749e36944cb68b8e665b9ceaa45e" }