{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 5, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "'Haul Tickets$'", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "truckcert": null, "ticket_type": null, "measuremonitor": null, "disposalsitetype": null, "num_tare_ton": null, "scale_receipt": null, "type": null, "hin": null, "latitude_mt": null, "longitude_mt": null, "trucktype": null, "num_tare": null, "debristype": null, "zone": null, "longitude_dt": null, "incidentid": null, "loaddate": null, "highway": null, "payableweight": null, "dispoweight": null, "percentload": null, "longitude": null, "mileage": null, "note_uniqueid": null, "ticket_status": null, "loadtime": null, "type2": null, "created_user": null, "roe_id": null, "latitue_dt": null, "report_type": null, "num_tare_lb": null, "strap": null, "subcontactor": null, "version": null, "unitbarcode": null, "offense_number": null, "wg_freon": null, "netweight": null, "milemarker": null, "registration": null, "netweight_lb": null, "truckid": null, "contractor": null, "countunits": null, "city": null, "netweight_ton": null, "payableunit": null, "latitude": null, "globalid": null, "streetnum": null, "dispoweight_ton": null, "payablecy": null, "debristype_other": null, "totalpayable": null, "capacity": null, "measuresite": null, "payableunitvalue": null, "loadmonitor": null, "street": null, "tph_ticketid": null, "landuse": null, "last_edited_date": null, "num_tare_hydrated": null, "num_tare_final": null, "measuretime": null, "make": null, "ticketid": null, "measuredate": null, "comments": null, "address": null, "percentfull": null, "length_titledproperty_ft": null, "length": null, "dispoweight_lb": null, "dispoestimate": null, "last_edited_user": null, "dev_measureuniqueid": null, "created_date": null, "highwayoffset": null, "unit_weight": null, "attachment_count": null, "objectid": null, "dev_loaduniqueid": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid_1", "supportsQuantizationEditMode": true, "name": "'Haul Tickets$'", "displayField": "globalid", "supportsCalculate": true, "fields": [ { "modelName": "globalid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "globalid", "length": 255, "alias": "GlobalID", "type": "esriFieldTypeString" }, { "modelName": "incidentid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "incidentid", "length": 255, "alias": "incidentid", "type": "esriFieldTypeString" }, { "modelName": "loaddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "loaddate", "length": 29, "alias": "loaddate", "type": "esriFieldTypeDate" }, { "modelName": "ticketid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ticketid", "alias": "ticketid", "type": "esriFieldTypeDouble" }, { "modelName": "truckid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "truckid", "alias": "truckid", "type": "esriFieldTypeDouble" }, { "modelName": "contractor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor", "length": 255, "alias": "contractor", "type": "esriFieldTypeString" }, { "modelName": "subcontactor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subcontactor", "length": 255, "alias": "subcontactor", "type": "esriFieldTypeString" }, { "modelName": "capacity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "capacity", "alias": "capacity", "type": "esriFieldTypeDouble" }, { "modelName": "trucktype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "trucktype", "length": 255, "alias": "truckType", "type": "esriFieldTypeString" }, { "modelName": "truckcert", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "truckcert", "length": 255, "alias": "truckCert", "type": "esriFieldTypeString" }, { "modelName": "debristype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "debristype", "length": 255, "alias": "debristype", "type": "esriFieldTypeString" }, { "modelName": "payableunit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "payableunit", "length": 255, "alias": "payableunit", "type": "esriFieldTypeString" }, { "modelName": "comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "comments", "type": "esriFieldTypeString" }, { "modelName": "loadmonitor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "loadmonitor", "length": 255, "alias": "loadMonitor", "type": "esriFieldTypeString" }, { "modelName": "city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "modelName": "zone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zone", "length": 255, "alias": "zone", "type": "esriFieldTypeString" }, { "modelName": "highway", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "highway", "length": 255, "alias": "highway", "type": "esriFieldTypeString" }, { "modelName": "milemarker", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "milemarker", "length": 255, "alias": "mileMarker", "type": "esriFieldTypeString" }, { "modelName": "highwayoffset", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "highwayoffset", "length": 255, "alias": "highwayOffset", "type": "esriFieldTypeString" }, { "modelName": "version", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "version", "length": 255, "alias": "version", "type": "esriFieldTypeString" }, { "modelName": "latitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latitude", "alias": "latitude", "type": "esriFieldTypeDouble" }, { "modelName": "longitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longitude", "alias": "longitude", "type": "esriFieldTypeDouble" }, { "modelName": "unitbarcode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitbarcode", "length": 255, "alias": "unitbarcode", "type": "esriFieldTypeString" }, { "modelName": "percentfull", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "percentfull", "length": 255, "alias": "percentFull", "type": "esriFieldTypeString" }, { "modelName": "measuresite", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "measuresite", "length": 255, "alias": "measureSite", "type": "esriFieldTypeString" }, { "modelName": "measuredate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "measuredate", "length": 29, "alias": "measureDate", "type": "esriFieldTypeDate" }, { "modelName": "unit_weight", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unit_weight", "length": 255, "alias": "unit_weight", "type": "esriFieldTypeString" }, { "modelName": "dispoweight_lb", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dispoweight_lb", "length": 255, "alias": "dispoweight_lb", "type": "esriFieldTypeString" }, { "modelName": "num_tare_lb", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "num_tare_lb", "length": 255, "alias": "num_tare_lb", "type": "esriFieldTypeString" }, { "modelName": "dispoweight_ton", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dispoweight_ton", "length": 255, "alias": "dispoweight_ton", "type": "esriFieldTypeString" }, { "modelName": "num_tare_ton", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "num_tare_ton", "length": 255, "alias": "num_tare_ton", "type": "esriFieldTypeString" }, { "modelName": "netweight_ton", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "netweight_ton", "alias": "netweight_ton", "type": "esriFieldTypeDouble" }, { "modelName": "dispoweight", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dispoweight", "length": 255, "alias": "dispoweight", "type": "esriFieldTypeString" }, { "modelName": "num_tare", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "num_tare", "length": 255, "alias": "num_tare", "type": "esriFieldTypeString" }, { "modelName": "payableweight", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "payableweight", "length": 255, "alias": "payableWeight", "type": "esriFieldTypeString" }, { "modelName": "netweight", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "netweight", "length": 255, "alias": "netweight", "type": "esriFieldTypeString" }, { "modelName": "dispoestimate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dispoestimate", "alias": "dispoestimate", "type": "esriFieldTypeDouble" }, { "modelName": "totalpayable", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "totalpayable", "alias": "totalPayable", "type": "esriFieldTypeDouble" }, { "modelName": "scale_receipt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scale_receipt", "alias": "scale_receipt", "type": "esriFieldTypeDouble" }, { "modelName": "measuremonitor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "measuremonitor", "length": 255, "alias": "measureMonitor", "type": "esriFieldTypeString" }, { "modelName": "mileage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mileage", "alias": "mileage", "type": "esriFieldTypeDouble" }, { "modelName": "created_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "modelName": "created_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "modelName": "last_edited_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "modelName": "last_edited_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "modelName": "attachment_count", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "attachment_count", "alias": "Attachment Count", "type": "esriFieldTypeDouble" }, { "modelName": "payableunitvalue", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "payableunitvalue", "length": 255, "alias": "payableUnitValue", "type": "esriFieldTypeString" }, { "modelName": "type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "type", "length": 255, "alias": "type", "type": "esriFieldTypeString" }, { "modelName": "countunits", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "countunits", "length": 255, "alias": "countUnits", "type": "esriFieldTypeString" }, { "modelName": "netweight_lb", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "netweight_lb", "length": 255, "alias": "netweight_lb", "type": "esriFieldTypeString" }, { "modelName": "num_tare_hydrated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "num_tare_hydrated", "length": 255, "alias": "num_tare_hydrated", "type": "esriFieldTypeString" }, { "modelName": "num_tare_final", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "num_tare_final", "length": 255, "alias": "num_tare_final", "type": "esriFieldTypeString" }, { "modelName": "payablecy", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "payablecy", "alias": "payableCY", "type": "esriFieldTypeDouble" }, { "modelName": "latitude_mt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latitude_mt", "alias": "latitude_mt", "type": "esriFieldTypeDouble" }, { "modelName": "longitude_mt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longitude_mt", "alias": "longitude_mt", "type": "esriFieldTypeDouble" }, { "modelName": "longitude_dt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longitude_dt", "length": 255, "alias": "longitude_dt", "type": "esriFieldTypeString" }, { "modelName": "latitue_dt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latitue_dt", "length": 255, "alias": "latitue_dt", "type": "esriFieldTypeString" }, { "modelName": "ticket_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ticket_type", "length": 255, "alias": "Ticket type", "type": "esriFieldTypeString" }, { "modelName": "measuretime", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "measuretime", "length": 29, "alias": "measureTime", "type": "esriFieldTypeDate" }, { "modelName": "loadtime", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "loadtime", "length": 29, "alias": "loadtime", "type": "esriFieldTypeDate" }, { "modelName": "streetnum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streetnum", "length": 255, "alias": "streetnum", "type": "esriFieldTypeString" }, { "modelName": "street", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "street", "length": 255, "alias": "street", "type": "esriFieldTypeString" }, { "modelName": "tph_ticketid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tph_ticketid", "length": 255, "alias": "TPH_ticketid", "type": "esriFieldTypeString" }, { "modelName": "note_uniqueid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "note_uniqueid", "length": 255, "alias": "note_uniqueid", "type": "esriFieldTypeString" }, { "modelName": "debristype_other", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "debristype_other", "length": 255, "alias": "debristype_other", "type": "esriFieldTypeString" }, { "modelName": "strap", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "strap", "length": 255, "alias": "Strap", "type": "esriFieldTypeString" }, { "modelName": "landuse", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "landuse", "length": 255, "alias": "Landuse", "type": "esriFieldTypeString" }, { "modelName": "address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 255, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "disposalsitetype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "disposalsitetype", "length": 255, "alias": "disposalsitetype", "type": "esriFieldTypeString" }, { "modelName": "wg_freon", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wg_freon", "length": 255, "alias": "wg_freon", "type": "esriFieldTypeString" }, { "modelName": "length_titledproperty_ft", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "length_titledproperty_ft", "length": 255, "alias": "length_titledproperty_ft", "type": "esriFieldTypeString" }, { "modelName": "ticket_status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ticket_status", "length": 255, "alias": "ticket_status", "type": "esriFieldTypeString" }, { "modelName": "offense_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "offense_number", "length": 255, "alias": "Offense Number", "type": "esriFieldTypeString" }, { "modelName": "length", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "length", "length": 255, "alias": "Length", "type": "esriFieldTypeString" }, { "modelName": "registration", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "registration", "length": 255, "alias": "Registration", "type": "esriFieldTypeString" }, { "modelName": "hin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hin", "length": 255, "alias": "HIN", "type": "esriFieldTypeString" }, { "modelName": "make", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "make", "length": 255, "alias": "Make", "type": "esriFieldTypeString" }, { "modelName": "type2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "type2", "length": 255, "alias": "Type2", "type": "esriFieldTypeString" }, { "modelName": "percentload", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "percentload", "length": 255, "alias": "percentLoad", "type": "esriFieldTypeString" }, { "modelName": "roe_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "roe_id", "length": 255, "alias": "ROE_ID", "type": "esriFieldTypeString" }, { "modelName": "dev_loaduniqueid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dev_loaduniqueid", "length": 255, "alias": "DEV_LoadUniqueID", "type": "esriFieldTypeString" }, { "modelName": "dev_measureuniqueid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dev_measureuniqueid", "length": 255, "alias": "DEV_MeasureUniqueID", "type": "esriFieldTypeString" }, { "modelName": "objectid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeDouble" }, { "modelName": "report_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "report_type", "length": 255, "alias": "Report Type", "type": "esriFieldTypeString" }, { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid_1", "domain": null, "name": "objectid_1", "alias": "ObjectID_1" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "load_date_conv", "length": 29, "alias": "Load_Date_Conv", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "wg_w_freon", "alias": "wg_w_freon", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "wg_wo", "alias": "wg_wo", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "total_wg", "alias": "total_wg", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r2315_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid_1", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "960464b234b74809aec9433ffddb89bd", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Uploads,Query,Update,Delete,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }