{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Trailers", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "SDE.Workorder", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "WorkOrderGlobalId", "composite": false, "catalogID": "{B671BD84-6479-4C53-B664-BA741B9E6B04}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "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": "Unit", "typeIdField": "Subtype", "subtypeField": "Subtype", "defaultSubtypeCode": 0, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Unit", "type": "esriFieldTypeString", "alias": "Unit", "domain": { "type": "codedValue", "name": "swsTrailers", "description": "Sanitation Trailers", "codedValues": [ { "name": "637-0100", "code": "637-0100 " }, { "name": "637-0101", "code": "637-0101" }, { "name": "637-0102", "code": "637-0102 " }, { "name": "637-0103", "code": "637-0103 " }, { "name": "637-0104", "code": "637-0104 " }, { "name": "637-0105", "code": "637-0105 " }, { "name": "637-0106", "code": "637-0106" }, { "name": "637-0108", "code": "637-0108" }, { "name": "637-0109", "code": "637-0109" }, { "name": "637-0111", "code": "637-0111" }, { "name": "637-0112", "code": "637-0112" }, { "name": "637-0113", "code": "637-0113" }, { "name": "637-0114", "code": "637-0114" }, { "name": "637-0115", "code": "637-0115" }, { "name": "637-0116", "code": "637-0116" }, { "name": "637-0117", "code": "637-0117" }, { "name": "637-0118", "code": "637-0118" }, { "name": "637-0119", "code": "637-0119" }, { "name": "637-0120", "code": "637-0120" }, { "name": "637-0121", "code": "637-0121" }, { "name": "637-0122", "code": "637-0122" }, { "name": "637-0123", "code": "637-0123" }, { "name": "637-0124", "code": "637-0124" }, { "name": "637-0125", "code": "637-0125" }, { "name": "637-0126", "code": "637-0126" }, { "name": "637-0127", "code": "637-0127" }, { "name": "637-0128", "code": "637-0128" }, { "name": "637-0129", "code": "637-0129" }, { "name": "637-0130", "code": "637-0130" }, { "name": "637-0132", "code": "637-0132" }, { "name": "637-0133", "code": "637-0133" }, { "name": "637-0135", "code": "637-0135" }, { "name": "637-0136", "code": "637-0136" }, { "name": "637-0138", "code": "637-0138" }, { "name": "637-0139", "code": "637-0139" }, { "name": "637-0140", "code": "637-0140" }, { "name": "637-0141", "code": "637-0141" }, { "name": "637-0142", "code": "637-0142" }, { "name": "637-0143", "code": "637-0143" }, { "name": "637-0144", "code": "637-0144" }, { "name": "637-0145", "code": "637-0145" }, { "name": "637-0149", "code": "637-0149" }, { "name": "637-0151", "code": "637-0151" }, { "name": "637-0152", "code": "637-0152" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Unit" }, { "name": "SerialNum", "type": "esriFieldTypeString", "alias": "SerialNum", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SerialNum" }, { "name": "MfgYear", "type": "esriFieldTypeDate", "alias": "MfgYear", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MfgYear" }, { "name": "VehMake", "type": "esriFieldTypeString", "alias": "VehicleMake", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "VehMake" }, { "name": "WorkOrderObjID", "type": "esriFieldTypeInteger", "alias": "WorkOrderObjID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WorkOrderObjID" }, { "name": "Subtype", "type": "esriFieldTypeSmallInteger", "alias": "Subtype", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Subtype" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comments" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "WorkOrderGlobalId", "type": "esriFieldTypeGUID", "alias": "WorkOrderGlobalId", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "WorkOrderGlobalId" } ], "indexes": [ { "name": "R68_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_68", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2140_WorkOrd", "fields": "WorkOrderObjID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "types": [ { "id": 0, "name": "Horticulture", "domains": { "Unit": { "type": "codedValue", "name": "htTrailers", "description": "Horticulture Trailers", "codedValues": [ { "name": "621-0724 Trailer", "code": "621-0724 Trailer" }, { "name": "630-9711 Landscape Trailer", "code": "630-9711 Landscape Trailer " }, { "name": "621-5659T trailer", "code": "621-5659T trailer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "templates": [ { "name": "Horticulture", "description": "", "prototype": { "attributes": { "WorkOrderObjID": null, "last_edited_date": null, "WorkOrderGlobalId": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "Subtype": 0, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null } }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 1, "name": "Maintenance", "domains": {}, "templates": [ { "name": "Maintenance", "description": "", "prototype": { "attributes": { "WorkOrderObjID": null, "last_edited_date": null, "WorkOrderGlobalId": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "Subtype": 1, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null } }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 2, "name": "Signals Signs", "domains": {}, "templates": [ { "name": "Signals Signs", "description": "", "prototype": { "attributes": { "WorkOrderObjID": null, "last_edited_date": null, "WorkOrderGlobalId": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "Subtype": 2, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null } }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 3, "name": "Storm Water", "domains": { "Unit": { "type": "codedValue", "name": "swTrailers", "description": "Storm Water Trailers", "codedValues": [ { "name": "630-9714 Towmaster", "code": "630-9714 Towmaster" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "templates": [ { "name": "Storm Water", "description": "", "prototype": { "attributes": { "WorkOrderObjID": null, "last_edited_date": null, "WorkOrderGlobalId": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "Subtype": 3, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null } }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 4, "name": "Streets", "domains": { "Unit": { "type": "codedValue", "name": "stTrailers", "description": "Streets Trailers", "codedValues": [ { "name": "621-0103 Trailer", "code": "621-0103 Trailer" }, { "name": "621-0920 Trailer", "code": "621-0920 Trailer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "templates": [ { "name": "Streets", "description": "", "prototype": { "attributes": { "WorkOrderObjID": null, "last_edited_date": null, "WorkOrderGlobalId": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "Subtype": 4, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null } }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 5, "name": "Sanitation", "domains": { "Unit": {"type": "inherited"} }, "templates": [ { "name": "Sanitation", "description": "", "prototype": { "attributes": { "WorkOrderObjID": null, "last_edited_date": null, "WorkOrderGlobalId": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "Subtype": 5, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null } }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 6, "name": "PW Training", "domains": { "Unit": { "type": "codedValue", "name": "pwTrailers", "description": "Test domain for pw training", "codedValues": [ { "name": "PPW Training Trailer", "code": "PPW Training Trailer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "templates": [ { "name": "PW Training", "description": "", "prototype": { "attributes": { "WorkOrderObjID": null, "last_edited_date": null, "WorkOrderGlobalId": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "Subtype": 6, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null } }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 7, "name": "Administration", "domains": { "Unit": { "type": "codedValue", "name": "adminTrailer", "description": "Test domain for admin trailers", "codedValues": [ { "name": "Admin Trailer", "code": "Admin Trailer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "templates": [ { "name": "Administration", "description": "", "prototype": { "attributes": { "WorkOrderObjID": null, "last_edited_date": null, "WorkOrderGlobalId": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "Subtype": 7, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null } }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 12, "name": "Storm", "domains": {}, "templates": [ { "name": "Storm", "description": "", "prototype": { "attributes": { "last_edited_date": null, "last_edited_user": null, "WorkOrderGlobalId": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": 12, "Comments": null, "created_user": null, "created_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ] } ], "templates": [], "subtypes": [ { "code": 0, "name": "Horticulture", "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": 0, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "domains": { "Unit": { "type": "codedValue", "name": "htTrailers", "description": "Horticulture Trailers", "codedValues": [ { "name": "621-0724 Trailer", "code": "621-0724 Trailer" }, { "name": "630-9711 Landscape Trailer", "code": "630-9711 Landscape Trailer " }, { "name": "621-5659T trailer", "code": "621-5659T trailer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } }, { "code": 1, "name": "Maintenance", "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": 1, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "domains": {} }, { "code": 2, "name": "Signals Signs", "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": 2, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "domains": {} }, { "code": 3, "name": "Storm Water", "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": 3, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "domains": { "Unit": { "type": "codedValue", "name": "swTrailers", "description": "Storm Water Trailers", "codedValues": [ { "name": "630-9714 Towmaster", "code": "630-9714 Towmaster" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } }, { "code": 4, "name": "Streets", "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": 4, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "domains": { "Unit": { "type": "codedValue", "name": "stTrailers", "description": "Streets Trailers", "codedValues": [ { "name": "621-0103 Trailer", "code": "621-0103 Trailer" }, { "name": "621-0920 Trailer", "code": "621-0920 Trailer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } }, { "code": 5, "name": "Sanitation", "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": 5, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "domains": { "Unit": {"type": "inherited"} } }, { "code": 6, "name": "PW Training", "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": 6, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "domains": { "Unit": { "type": "codedValue", "name": "pwTrailers", "description": "Test domain for pw training", "codedValues": [ { "name": "PPW Training Trailer", "code": "PPW Training Trailer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } }, { "code": 7, "name": "Administration", "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": 7, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "domains": { "Unit": { "type": "codedValue", "name": "adminTrailer", "description": "Test domain for admin trailers", "codedValues": [ { "name": "Admin Trailer", "code": "Admin Trailer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } }, { "code": 12, "name": "Storm", "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": 12, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "domains": {} } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Uploads,Editing,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": 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, "serviceItemId": "88c311680fe747f18428257a523e294c" }