{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "Fleet Assets", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CREATED_DATE", "creatorField": "CREATOR", "editDateField": "LAST_EDITED_DATE", "editorField": "LAST_EDITOR" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "GISADMIN.Ajax_Border_Polygon", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelationshipClass", "composite": false, "catalogID": "{3276C825-B1BD-4D9A-AB58-9CA67968FFDE}" } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1747347423000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "EQUIPMENTID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "EQUIPMENTID", "type": "esriFieldTypeString", "alias": "EQUIPMENTID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "EQUIPMENTID" }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "LEGACYID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LEGACYID" }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "EQUIPMENT_YEAR", "type": "esriFieldTypeSmallInteger", "alias": "Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Equipment_Year" }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MAKE" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "LICENCE", "type": "esriFieldTypeString", "alias": "Licence Plate", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Licence" }, { "name": "SERIAL_NUM", "type": "esriFieldTypeString", "alias": "VIN orSerial #", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Serial_Num" }, { "name": "CHARGE_TO", "type": "esriFieldTypeString", "alias": "CHARGE_TO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CHARGE_TO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "LIFE_CYCLE", "type": "esriFieldTypeDouble", "alias": "LIFE_CYCLE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFE_CYCLE" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "ODOMETERREADING", "type": "esriFieldTypeDouble", "alias": "ODOMETERREADING", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ODOMETERREADING" }, { "name": "SITEID", "type": "esriFieldTypeInteger", "alias": "SITEID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SITEID" }, { "name": "GPS", "type": "esriFieldTypeString", "alias": "GPS", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "GPS" }, { "name": "ENGINE_SIZE", "type": "esriFieldTypeString", "alias": "ENGINE_SIZE", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "ENGINE_SIZE" }, { "name": "IMAGE_FIELD", "type": "esriFieldTypeString", "alias": "IMAGE_FIELD", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IMAGE_FIELD" }, { "name": "FRONT_TIRE", "type": "esriFieldTypeString", "alias": "FrontTire", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Front_Tire" }, { "name": "REAR_TIRE", "type": "esriFieldTypeString", "alias": "Rear", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Rear_Tire" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "RATE", "type": "esriFieldTypeString", "alias": "RATE", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "RATE" }, { "name": "PURCHASE_PRICE", "type": "esriFieldTypeString", "alias": "PURCHASE_PRICE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PURCHASE_PRICE" }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ASSETID" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": { "type": "codedValue", "name": "Fleet_Status_2", "description": "", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "Sold", "code": "Sold" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STATUS" }, { "name": "RELATIONSHIPCLASS", "type": "esriFieldTypeInteger", "alias": "RelationshipClass", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "RELATIONSHIPCLASS" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "RATE_NUM", "type": "esriFieldTypeDouble", "alias": "RATE_NUM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RATE_NUM" }, { "name": "PURCHASE_PRICE_NUM", "type": "esriFieldTypeDouble", "alias": "PURCHASE_PRICE_NUM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PURCHASE_PRICE_NUM" }, { "name": "CREATOR", "type": "esriFieldTypeString", "alias": "CREATOR", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CREATOR" }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATED_DATE" }, { "name": "LAST_EDITOR", "type": "esriFieldTypeString", "alias": "LAST_EDITOR", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LAST_EDITOR" }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_EDITED_DATE" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Fleet Assets", "description": "", "prototype": { "attributes": { "RATE_NUM": null, "EQUIPMENTID": null, "LEGACYID": null, "DESCRIPTION": null, "EQUIPMENT_YEAR": null, "MAKE": null, "MODEL": null, "LICENCE": null, "SERIAL_NUM": null, "CHARGE_TO": null, "PURCHASE_DATE": null, "LIFE_CYCLE": null, "COMMENTS": null, "ODOMETERREADING": null, "SITEID": null, "GPS": null, "ENGINE_SIZE": null, "IMAGE_FIELD": null, "FRONT_TIRE": null, "REAR_TIRE": null, "WARRANTY_DATE": null, "RATE": null, "PURCHASE_PRICE": null, "PURCHASE_PRICE_NUM": null, "STATUS": null, "RELATIONSHIPCLASS": 1 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Uploads,Editing,ChangeTracking", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }