{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "Fleet Assets", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "EQUIPMENTID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "EQUIPMENTID", "type": "esriFieldTypeString", "alias": "EQUIPMENTID", "length": 255, "domain": null }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "LEGACYID", "length": 255, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 255, "domain": null }, { "name": "EQUIPMENT_YEAR", "type": "esriFieldTypeSmallInteger", "alias": "Year", "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 255, "domain": { "type": "codedValue", "name": "Fleet_Make", "description": "Fleet_Make", "codedValues": [ { "name": "Admiral", "code": "Admiral" }, { "name": "AGCO", "code": "AGCO" }, { "name": "Alamo", "code": "Alamo" }, { "name": "Atlas", "code": "Atlas" }, { "name": "Bannerman", "code": "Bannerman" }, { "name": "Barber", "code": "Barber" }, { "name": "Bombardier", "code": "Bombardier" }, { "name": "Bomford", "code": "Bomford" }, { "name": "Bucher", "code": "Bucher" }, { "name": "C.T. Trailers", "code": "C.T. Trailers" }, { "name": "Canadian Trailers", "code": "Canadian Trailers" }, { "name": "Cant", "code": "Cant" }, { "name": "Case IH", "code": "Case IH" }, { "name": "CAT", "code": "CAT" }, { "name": "Champion", "code": "Champion" }, { "name": "Chevrolet", "code": "Chevrolet" }, { "name": "Chrysler", "code": "Chrysler" }, { "name": "Clark", "code": "Clark" }, { "name": "Club Car", "code": "Club Car" }, { "name": "Dodge", "code": "Dodge" }, { "name": "Doosan", "code": "Doosan" }, { "name": "EXPL", "code": "EXPL" }, { "name": "Ferris", "code": "Ferris" }, { "name": "Foamstream", "code": "Foamstream" }, { "name": "Ford", "code": "Ford" }, { "name": "Freightliner", "code": "Freightliner" }, { "name": "GMC", "code": "GMC" }, { "name": "Gravely", "code": "Gravely" }, { "name": "Homemade", "code": "Homemade" }, { "name": "Honda", "code": "Honda" }, { "name": "Husqvarna", "code": "Husqvarna" }, { "name": "Hyundai", "code": "Hyundai" }, { "name": "International", "code": "International" }, { "name": "J & J Trailers", "code": "J & J Trailers" }, { "name": "J.C. Trailers", "code": "J.C. Trailers" }, { "name": "Jacobsen", "code": "Jacobsen" }, { "name": "JCB", "code": "JCB" }, { "name": "JCTR", "code": "JCTR" }, { "name": "JLG", "code": "JLG" }, { "name": "John Deere", "code": "John Deere" }, { "name": "Kioti", "code": "Kioti" }, { "name": "Lafrance", "code": "Lafrance" }, { "name": "Land Pride", "code": "Land Pride" }, { "name": "Line Lazer V", "code": "Line Lazer V" }, { "name": "Marathon", "code": "Marathon" }, { "name": "Marine Cradle", "code": "Marine Cradle" }, { "name": "Mathieu", "code": "Mathieu" }, { "name": "Mercedes", "code": "Mercedes" }, { "name": "Mighty Truck", "code": "Mighty Truck" }, { "name": "Miska", "code": "Miska" }, { "name": "Morbark", "code": "Morbark" }, { "name": "Multiquip", "code": "Multiquip" }, { "name": "New Holland", "code": "New Holland" }, { "name": "Nilfisk-Advance", "code": "Nilfisk-Advance" }, { "name": "Nusurface", "code": "Nusurface" }, { "name": "Pierce", "code": "Pierce" }, { "name": "Ram", "code": "Ram" }, { "name": "Ravo", "code": "Ravo" }, { "name": "Redemix", "code": "Redemix" }, { "name": "Rosenbauer", "code": "Rosenbauer" }, { "name": "Ryan", "code": "Ryan" }, { "name": "Segaway", "code": "Segaway" }, { "name": "Smeal", "code": "Smeal" }, { "name": "Smeal/Spartan", "code": "Smeal/Spartan" }, { "name": "Spartan", "code": "Spartan" }, { "name": "Stageline", "code": "Stageline" }, { "name": "Sterling", "code": "Sterling" }, { "name": "Thompson", "code": "Thompson" }, { "name": "Toro", "code": "Toro" }, { "name": "Trackless", "code": "Trackless" }, { "name": "Vermeer", "code": "Vermeer" }, { "name": "Vredo", "code": "Vredo" }, { "name": "Wacker", "code": "Wacker" }, { "name": "Webe", "code": "Webe" }, { "name": "Weberlane", "code": "Weberlane" }, { "name": "Zamboni", "code": "Zamboni" }, { "name": "Isuzu", "code": "Isuzu" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 255, "domain": null }, { "name": "LICENCE", "type": "esriFieldTypeString", "alias": "Licence Plate", "length": 255, "domain": null }, { "name": "SERIAL_NUM", "type": "esriFieldTypeString", "alias": "VIN orSerial #", "length": 255, "domain": null }, { "name": "CHARGE_TO", "type": "esriFieldTypeString", "alias": "CHARGE_TO", "length": 255, "domain": null }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "length": 8, "domain": null }, { "name": "LIFE_CYCLE", "type": "esriFieldTypeDouble", "alias": "LIFE_CYCLE", "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "ODOMETERREADING", "type": "esriFieldTypeDouble", "alias": "ODOMETERREADING", "domain": null }, { "name": "SITEID", "type": "esriFieldTypeInteger", "alias": "SITEID", "domain": null }, { "name": "GPS", "type": "esriFieldTypeString", "alias": "GPS", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ENGINE_SIZE", "type": "esriFieldTypeString", "alias": "ENGINE_SIZE", "length": 30, "domain": null }, { "name": "IMAGE_FIELD", "type": "esriFieldTypeString", "alias": "IMAGE_FIELD", "length": 255, "domain": null }, { "name": "FRONT_TIRE", "type": "esriFieldTypeString", "alias": "FrontTire", "length": 30, "domain": null }, { "name": "REAR_TIRE", "type": "esriFieldTypeString", "alias": "Rear", "length": 30, "domain": null }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "length": 8, "domain": null }, { "name": "RATE", "type": "esriFieldTypeString", "alias": "RATE", "length": 15, "domain": null }, { "name": "PURCHASE_PRICE", "type": "esriFieldTypeString", "alias": "PURCHASE_PRICE", "length": 20, "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 50, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": { "type": "codedValue", "name": "Fleet_Status_2", "description": "", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "Sold", "code": "Sold" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RELATIONSHIPCLASS", "type": "esriFieldTypeInteger", "alias": "RelationshipClass", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "RATE_NUM", "type": "esriFieldTypeDouble", "alias": "RATE_NUM", "domain": null }, { "name": "PURCHASE_PRICE_NUM", "type": "esriFieldTypeDouble", "alias": "PURCHASE_PRICE_NUM", "domain": null }, { "name": "CREATOR", "type": "esriFieldTypeString", "alias": "CREATOR", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITOR", "type": "esriFieldTypeString", "alias": "LAST_EDITOR", "length": 255, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null } ], "indexes": [ { "name": "GDB_115281_RELAT", "fields": "RELATIONSHIPCLASS", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R453416_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_453416", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GISADMIN.Ajax_Border_Polygon", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "RelationshipClass", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3276C825-B1BD-4D9A-AB58-9CA67968FFDE}" } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1747347423000 } }