{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Trailers", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Unit", "typeIdField": "Subtype", "subtypeFieldName": "Subtype", "subtypeField": "Subtype", "defaultSubtypeCode": 0, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Unit", "type": "esriFieldTypeString", "alias": "Unit", "length": 255, "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" } }, { "name": "SerialNum", "type": "esriFieldTypeString", "alias": "SerialNum", "length": 255, "domain": null }, { "name": "MfgYear", "type": "esriFieldTypeDate", "alias": "MfgYear", "length": 8, "domain": null }, { "name": "VehMake", "type": "esriFieldTypeString", "alias": "VehicleMake", "length": 255, "domain": null }, { "name": "WorkOrderObjID", "type": "esriFieldTypeInteger", "alias": "WorkOrderObjID", "domain": null }, { "name": "Subtype", "type": "esriFieldTypeSmallInteger", "alias": "Subtype", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "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": "WorkOrderGlobalId", "type": "esriFieldTypeGUID", "alias": "WorkOrderGlobalId", "length": 38, "domain": null } ], "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": "" } ], "types": [ { "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" } }, "id": 0, "name": "Horticulture" }, { "domains": {}, "id": 1, "name": "Maintenance" }, { "domains": {}, "id": 2, "name": "Signals Signs" }, { "domains": { "Unit": { "type": "codedValue", "name": "swTrailers", "description": "Storm Water Trailers", "codedValues": [ { "name": "630-9714 Towmaster", "code": "630-9714 Towmaster" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 3, "name": "Storm Water" }, { "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" } }, "id": 4, "name": "Streets" }, { "domains": { "Unit": {"type": "inherited"} }, "id": 5, "name": "Sanitation" }, { "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" } }, "id": 6, "name": "PW Training" }, { "domains": { "Unit": { "type": "codedValue", "name": "adminTrailer", "description": "Test domain for admin trailers", "codedValues": [ { "name": "Admin Trailer", "code": "Admin Trailer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 7, "name": "Administration" }, { "domains": {}, "id": 12, "name": "Storm" } ], "subtypes": [ { "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" } }, "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": null, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "code": 0, "name": "Horticulture" }, { "domains": {}, "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": null, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "code": 1, "name": "Maintenance" }, { "domains": {}, "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": null, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "code": 2, "name": "Signals Signs" }, { "domains": { "Unit": { "type": "codedValue", "name": "swTrailers", "description": "Storm Water Trailers", "codedValues": [ { "name": "630-9714 Towmaster", "code": "630-9714 Towmaster" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": null, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "code": 3, "name": "Storm Water" }, { "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" } }, "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": null, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "code": 4, "name": "Streets" }, { "domains": { "Unit": {"type": "inherited"} }, "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": null, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "code": 5, "name": "Sanitation" }, { "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" } }, "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": null, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "code": 6, "name": "PW Training" }, { "domains": { "Unit": { "type": "codedValue", "name": "adminTrailer", "description": "Test domain for admin trailers", "codedValues": [ { "name": "Admin Trailer", "code": "Admin Trailer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": null, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "code": 7, "name": "Administration" }, { "domains": {}, "defaultValues": { "GlobalID": null, "Unit": null, "SerialNum": null, "MfgYear": null, "VehMake": null, "WorkOrderObjID": null, "Subtype": null, "Comments": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "WorkOrderGlobalId": null }, "code": 12, "name": "Storm" } ], "relationships": [ { "id": 1, "name": "SDE.Workorder", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "WorkOrderGlobalId", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B671BD84-6479-4C53-B664-BA741B9E6B04}" } ], "capabilities": "Query,Map,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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "872ce9edd5cc4cf2bd87bf857756054b" }