{
 "tables": [
  {
   "isCoGoEnabled": false,
   "isDataBranchVersioned": false,
   "supportsApplyEditsWithGlobalIds": true,
   "maxRecordCount": 1000,
   "infoInEstimates": [
    "extent",
    "count"
   ],
   "datesInUnknownTimezone": false,
   "type": "Table",
   "supportsAttachmentsByUploadId": true,
   "editingInfo": {"lastEditDate": 1793641366712},
   "relationships": [
    {
     "keyField": "parentrowid",
     "role": "esriRelRoleDestination",
     "composite": false,
     "name": "Crew_Day_ExportFeatures",
     "relatedTableId": 0,
     "id": 0,
     "cardinality": "esriRelCardinalityOneToMany"
    }
   ],
   "hasViews": true,
   "supportsAttachmentsResizing": true,
   "cimVersion": "3.5.0",
   "isDataArchived": true,
   "id": 1,
   "supportsSubtypeEditing": true,
   "supportsStatistics": true,
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "standardMaxRecordCount": 16000,
   "isDataVersioned": false,
   "templates": [
    {
     "name": "crew_positions",
     "description": "",
     "drawingTool": "esriFeatureEditToolNone",
     "prototype": {
      "attributes": {
       "created_user": null,
       "materials_used": null,
       "calc_position": null,
       "parentrowid": null,
       "equipment": null,
       "last_edited_user": null,
       "uniquerowid": null,
       "assigned_employee": null,
       "crew1_weekday": null,
       "hours_worked": null,
       "last_edited_date": null,
       "created_date": null,
       "report_completed": "https://bucogis.maps.arcgis.com/sharing/rest/content/items/e22d30e916d046a7816cbbac10dd09b5/data",
       "labor_cost": null,
       "crew1_date": null,
       "material_unit": null,
       "crewnumber": null,
       "material_cost": null
      }
     }
    }
   ],
   "supportsAdvancedQueries": true,
   "currentVersion": 11.5,
   "advancedEditingCapabilities": {
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportsReturnEditResults": true,
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "objectIdField": "objectid",
   "supportsQuantizationEditMode": true,
   "hasContingentValuesDefinition": false,
   "name": "crew_positions",
   "displayField": "crew1_weekday",
   "supportsCalculate": true,
   "fields": [
    {
     "nullable": false,
     "defaultValue": null,
     "editable": false,
     "length": 4,
     "type": "esriFieldTypeOID",
     "modelName": "objectid",
     "domain": null,
     "name": "objectid",
     "alias": "ObjectID"
    },
    {
     "nullable": false,
     "editable": false,
     "defaultValue": null,
     "length": 38,
     "type": "esriFieldTypeGlobalID",
     "modelName": "globalid",
     "domain": null,
     "name": "globalid",
     "alias": "GlobalID"
    },
    {
     "modelName": "crew1_date",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "precision": 1,
     "name": "crew1_date",
     "length": 29,
     "alias": "Crew Date",
     "type": "esriFieldTypeDate"
    },
    {
     "modelName": "crew1_weekday",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "crew1_weekday",
     "length": 255,
     "alias": "Crew Weekday",
     "type": "esriFieldTypeString"
    },
    {
     "modelName": "calc_position",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "calc_position",
     "alias": "calc_position",
     "type": "esriFieldTypeInteger"
    },
    {
     "modelName": "assigned_employee",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "assigned_employee",
     "length": 255,
     "alias": "Assigned Employee",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "length": 255,
     "type": "esriFieldTypeString",
     "modelName": "equipment",
     "domain": {
      "name": "service_26f5f9df663d4ce0ac43ba875bf2fcd6_service_26f5f9df663d4ce0ac43ba875bf2fcd6_cvd_equipment",
      "type": "codedValue",
      "codedValues": [
       {
        "code": "labor",
        "name": "Labor"
       },
       {
        "code": "equipment_rider",
        "name": "Equipment Rider"
       },
       {
        "code": "equipment_operator",
        "name": "Equipment/Truck/Pickup Operator"
       }
      ]
     },
     "name": "equipment",
     "alias": "Equipment"
    },
    {
     "modelName": "parentrowid",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "parentrowid",
     "length": 38,
     "alias": "ParentRowID",
     "type": "esriFieldTypeGUID"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "precision": 1,
     "length": 29,
     "type": "esriFieldTypeDate",
     "required": true,
     "modelName": "created_date",
     "domain": null,
     "name": "created_date",
     "alias": "created_date"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "length": 255,
     "type": "esriFieldTypeString",
     "required": true,
     "modelName": "created_user",
     "domain": null,
     "name": "created_user",
     "alias": "created_user"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "precision": 1,
     "length": 29,
     "type": "esriFieldTypeDate",
     "required": true,
     "modelName": "last_edited_date",
     "domain": null,
     "name": "last_edited_date",
     "alias": "last_edited_date"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "length": 255,
     "type": "esriFieldTypeString",
     "required": true,
     "modelName": "last_edited_user",
     "domain": null,
     "name": "last_edited_user",
     "alias": "last_edited_user"
    },
    {
     "modelName": "crewnumber",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "crewnumber",
     "length": 256,
     "alias": "Crew Number",
     "type": "esriFieldTypeString"
    },
    {
     "modelName": "hours_worked",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "hours_worked",
     "alias": "Hours Worked",
     "type": "esriFieldTypeDouble"
    },
    {
     "modelName": "materials_used",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "materials_used",
     "length": 256,
     "alias": "Materials Used",
     "type": "esriFieldTypeString"
    },
    {
     "modelName": "material_unit",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "material_unit",
     "length": 256,
     "alias": "Material Unit",
     "type": "esriFieldTypeString"
    },
    {
     "modelName": "material_cost",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "material_cost",
     "alias": "Material Cost",
     "type": "esriFieldTypeDouble"
    },
    {
     "modelName": "labor_cost",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "labor_cost",
     "alias": "Labor Cost",
     "type": "esriFieldTypeDouble"
    },
    {
     "modelName": "report_completed",
     "nullable": true,
     "editable": true,
     "defaultValue": "https://bucogis.maps.arcgis.com/sharing/rest/content/items/e22d30e916d046a7816cbbac10dd09b5/data",
     "domain": null,
     "name": "report_completed",
     "length": 256,
     "alias": "report_completed",
     "type": "esriFieldTypeString"
    },
    {
     "modelName": "uniquerowid",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "uniquerowid",
     "length": 38,
     "alias": "Unique Row ID",
     "type": "esriFieldTypeGUID"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "equipment_condition",
     "length": 255,
     "alias": "Equipment Condition",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "assigned_project",
     "length": 255,
     "alias": "Assigned Project",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "task_condition",
     "length": 255,
     "alias": "Task Detail Condition",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": {
      "name": "service_26f5f9df663d4ce0ac43ba875bf2fcd6_crew_positions_task_detail_d590dbad4fd04a1b831ccaf1febd3319",
      "type": "codedValue",
      "codedValues": [
       {
        "code": "labor",
        "name": "Labor"
       },
       {
        "code": "laydown_machine",
        "name": "Laydown Machine"
       },
       {
        "code": "chip_spreader",
        "name": "Chip Spreader"
       },
       {
        "code": "shouldering_machine",
        "name": "Shouldering Machine"
       },
       {
        "code": "backhoe",
        "name": "Backhoe"
       },
       {
        "code": "pickup_traffic",
        "name": "Pickup - Traffic Control"
       },
       {
        "code": "pickup",
        "name": "Pickup"
       },
       {
        "code": "excavator",
        "name": "Excavator"
       },
       {
        "code": "grader",
        "name": "Grader"
       },
       {
        "code": "loader",
        "name": "Loader"
       },
       {
        "code": "mini_excavator",
        "name": "Mini Excavator"
       },
       {
        "code": "oil_distributor",
        "name": "Oil Distributor"
       },
       {
        "code": "power_broom",
        "name": "Power Broom"
       },
       {
        "code": "roller",
        "name": "Roller"
       },
       {
        "code": "semi",
        "name": "Semi"
       },
       {
        "code": "skid_steer",
        "name": "Skid Steer"
       },
       {
        "code": "tandem",
        "name": "Tandem"
       },
       {
        "code": "tractor",
        "name": "Tractor"
       }
      ]
     },
     "name": "task_detail",
     "length": 255,
     "alias": "Task Detail",
     "type": "esriFieldTypeString"
    }
   ],
   "maxRecordCountFactor": 1,
   "dateFieldsTimeReference": {
    "timeZoneIANA": "Etc/UTC",
    "respectsDaylightSaving": false,
    "timeZone": "UTC"
   },
   "supportsFieldDescriptionProperty": true,
   "allowGeometryUpdates": true,
   "supportsDurableUrlForSyncModelNone": false,
   "useStandardizedQueries": true,
   "globalIdField": "globalid",
   "description": "",
   "syncCanReturnChanges": true,
   "supportsAsyncDelete": true,
   "supportedSpatialRelationships": [
    "esriSpatialRelIntersects",
    "esriSpatialRelContains",
    "esriSpatialRelCrosses",
    "esriSpatialRelEnvelopeIntersects",
    "esriSpatialRelOverlaps",
    "esriSpatialRelTouches",
    "esriSpatialRelWithin"
   ],
   "supportsRollbackOnFailureParameter": true,
   "isDataReplicaTracked": true,
   "supportsTruncate": false,
   "indexes": [
    {
     "name": "g6646parentrowid",
     "isUnique": false,
     "description": "",
     "fields": "parentrowid",
     "isAscending": true
    },
    {
     "name": "g6646uniquerowid",
     "isUnique": false,
     "description": "",
     "fields": "uniquerowid",
     "isAscending": true
    },
    {
     "name": "r2231_sde_rowid_uk",
     "isUnique": false,
     "description": "",
     "fields": "objectid",
     "isAscending": true
    },
    {
     "name": "uuid_2231",
     "isUnique": true,
     "description": "",
     "fields": "globalid",
     "isAscending": true
    }
   ],
   "supportedAppendSourceFilterFormats": "featureService",
   "editFieldsInfo": null,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "GUIDFormat": "O",
   "hasAttachments": false,
   "queryBinsCapabilities": {
    "supportsFirstDayOfWeek": false,
    "supportedNormalizationTypes": [
     "boxCox",
     "field",
     "inverse",
     "log",
     "naturalLog",
     "percentOfTotal",
     "squareRoot"
    ],
    "supportedStatisticTypes": [
     "count",
     "sum",
     "min",
     "max",
     "avg",
     "stddev",
     "var",
     "percentile_cont",
     "percentile_disc"
    ],
    "supportsNormalization": true,
    "supportsSnapToData": true,
    "supportsFixedIntervalBin": true,
    "supportsStackBy": true,
    "supportsAutoIntervalBin": true,
    "supportsFixedBoundariesBin": true,
    "supportsDateBin": true,
    "supportsSplitBy": true,
    "supportsReturnFullIntervalBin": true
   },
   "advancedQueryCapabilities": {
    "supportsSqlExpression": true,
    "supportsQueryWithResultType": true,
    "supportsQueryRelatedPagination": true,
    "supportsQueryWithCacheHint": false,
    "supportsQueryWithDatumTransformation": true,
    "supportsCurrentUserQueries": true,
    "supportsQueryAttachmentsWithReturnUrl": true,
    "fullTextSearchCapabilities": {
     "supportsOperator": true,
     "supportsSearchOperator": true
    },
    "supportsDefaultSR": true,
    "supportsQueryDateBins": false,
    "supportsQueryWithLodSR": false,
    "supportsPaginationOnAggregatedQueries": true,
    "supportsMaxRecordCountFactor": true,
    "supportsPagination": true,
    "fullTextSearchableFields": [],
    "supportsStatistics": true,
    "supportsOrderBy": true,
    "supportsFullTextSearch": true,
    "supportsLod": false,
    "supportsSpatialAggregationStatistics": false,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryAttachments": true,
    "supportsQueryAttachmentsCountOnly": true,
    "supportsReturningQueryExtent": true,
    "supportsOrderByOnlyOnLayerFields": false,
    "supportsOutFieldSqlExpression": true,
    "supportsTopFeaturesQuery": true,
    "supportsDistinct": true,
    "supportsQueryAnalytic": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true
   },
   "subtypeField": "",
   "supportsValidateSQL": true,
   "enableZDefaults": true,
   "serviceItemId": "e26e04f1ade94fad88561b072e706195",
   "allowUpdateWithoutMValues": true,
   "supportsCoordinatesQuantization": true,
   "types": [],
   "capabilities": "Query,Create,Update,Delete,Editing,Sync,Uploads",
   "supportsAppend": true,
   "supportsExceedsLimitStatistics": true,
   "sourceSchemaChangesAllowed": true,
   "advancedQueryAnalyticCapabilities": {
    "supportsAsync": true,
    "supportsLinearRegression": true,
    "supportsPercentileAnalytic": false
   },
   "hasMetadata": true,
   "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile",
   "tileMaxRecordCount": 4000,
   "typeIdField": "",
   "supportsASyncCalculate": true,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "sqlParserVersion": "PG_11.4.0",
   "copyrightText": "",
   "zDefault": 0,
   "supportsLayerOverrides": true
  },
  {
   "isCoGoEnabled": false,
   "isDataBranchVersioned": false,
   "supportsApplyEditsWithGlobalIds": true,
   "maxRecordCount": 1000,
   "infoInEstimates": [
    "extent",
    "count"
   ],
   "datesInUnknownTimezone": false,
   "type": "Table",
   "supportsAttachmentsByUploadId": true,
   "editingInfo": {"lastEditDate": 1789590663794},
   "relationships": [],
   "supportsAttachmentsResizing": true,
   "cimVersion": "3.5.0",
   "isDataArchived": true,
   "id": 2,
   "supportsSubtypeEditing": true,
   "supportsStatistics": true,
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "standardMaxRecordCount": 16000,
   "isDataVersioned": false,
   "templates": [
    {
     "name": "Materials",
     "description": "",
     "drawingTool": "esriFeatureEditToolNone",
     "prototype": {
      "attributes": {
       "editor": null,
       "creationdate": null,
       "creator": null,
       "parentglobalid": null,
       "rateperunit": null,
       "materials_used": null,
       "material_amount": null,
       "editdate": null,
       "material_unit": null,
       "material_cost": null
      }
     }
    }
   ],
   "supportsAdvancedQueries": true,
   "currentVersion": 11.5,
   "advancedEditingCapabilities": {
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportsReturnEditResults": true,
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "objectIdField": "objectid",
   "supportsQuantizationEditMode": true,
   "hasContingentValuesDefinition": false,
   "name": "Materials",
   "displayField": "materials_used",
   "supportsCalculate": true,
   "fields": [
    {
     "nullable": false,
     "defaultValue": null,
     "editable": false,
     "length": 4,
     "type": "esriFieldTypeOID",
     "modelName": "objectid",
     "domain": null,
     "name": "objectid",
     "alias": "OBJECTID"
    },
    {
     "modelName": "parentglobalid",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "parentglobalid",
     "length": 38,
     "alias": "parentGlobalID",
     "type": "esriFieldTypeGUID"
    },
    {
     "modelName": "materials_used",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "materials_used",
     "length": 255,
     "alias": "materials_used",
     "type": "esriFieldTypeString"
    },
    {
     "modelName": "material_amount",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "material_amount",
     "alias": "material_amount",
     "type": "esriFieldTypeDouble"
    },
    {
     "modelName": "material_unit",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "material_unit",
     "length": 255,
     "alias": "material_unit",
     "type": "esriFieldTypeString"
    },
    {
     "modelName": "material_cost",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "material_cost",
     "alias": "material_cost",
     "type": "esriFieldTypeDouble"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "precision": 1,
     "length": 29,
     "type": "esriFieldTypeDate",
     "required": true,
     "modelName": "creationdate",
     "domain": null,
     "name": "creationdate",
     "alias": "CreationDate"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "length": 255,
     "type": "esriFieldTypeString",
     "required": true,
     "modelName": "creator",
     "domain": null,
     "name": "creator",
     "alias": "Creator"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "precision": 1,
     "length": 29,
     "type": "esriFieldTypeDate",
     "required": true,
     "modelName": "editdate",
     "domain": null,
     "name": "editdate",
     "alias": "EditDate"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "length": 255,
     "type": "esriFieldTypeString",
     "required": true,
     "modelName": "editor",
     "domain": null,
     "name": "editor",
     "alias": "Editor"
    },
    {
     "nullable": false,
     "editable": false,
     "defaultValue": null,
     "length": 38,
     "type": "esriFieldTypeGlobalID",
     "modelName": "globalid",
     "domain": null,
     "name": "globalid",
     "alias": "globalid"
    },
    {
     "modelName": "rateperunit",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "rateperunit",
     "alias": "Rate Per Unit",
     "type": "esriFieldTypeDouble"
    }
   ],
   "maxRecordCountFactor": 1,
   "dateFieldsTimeReference": {
    "timeZoneIANA": "Etc/UTC",
    "respectsDaylightSaving": false,
    "timeZone": "UTC"
   },
   "supportsFieldDescriptionProperty": true,
   "allowGeometryUpdates": true,
   "supportsDurableUrlForSyncModelNone": false,
   "useStandardizedQueries": true,
   "globalIdField": "globalid",
   "description": "",
   "syncCanReturnChanges": true,
   "supportsAsyncDelete": true,
   "supportedSpatialRelationships": [
    "esriSpatialRelIntersects",
    "esriSpatialRelContains",
    "esriSpatialRelCrosses",
    "esriSpatialRelEnvelopeIntersects",
    "esriSpatialRelOverlaps",
    "esriSpatialRelTouches",
    "esriSpatialRelWithin"
   ],
   "supportsRollbackOnFailureParameter": true,
   "isDataReplicaTracked": true,
   "supportsTruncate": false,
   "indexes": [
    {
     "name": "r2232_sde_rowid_uk",
     "isUnique": false,
     "description": "",
     "fields": "objectid",
     "isAscending": true
    },
    {
     "name": "uuid_2232",
     "isUnique": true,
     "description": "",
     "fields": "globalid",
     "isAscending": true
    }
   ],
   "supportedAppendSourceFilterFormats": "featureService",
   "editFieldsInfo": null,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "GUIDFormat": "O",
   "hasAttachments": false,
   "queryBinsCapabilities": {
    "supportsFirstDayOfWeek": false,
    "supportedNormalizationTypes": [
     "boxCox",
     "field",
     "inverse",
     "log",
     "naturalLog",
     "percentOfTotal",
     "squareRoot"
    ],
    "supportedStatisticTypes": [
     "count",
     "sum",
     "min",
     "max",
     "avg",
     "stddev",
     "var",
     "percentile_cont",
     "percentile_disc"
    ],
    "supportsNormalization": true,
    "supportsSnapToData": true,
    "supportsFixedIntervalBin": true,
    "supportsStackBy": true,
    "supportsAutoIntervalBin": true,
    "supportsFixedBoundariesBin": true,
    "supportsDateBin": true,
    "supportsSplitBy": true,
    "supportsReturnFullIntervalBin": true
   },
   "advancedQueryCapabilities": {
    "supportsSqlExpression": true,
    "supportsQueryWithResultType": true,
    "supportsQueryRelatedPagination": true,
    "supportsQueryWithCacheHint": false,
    "supportsQueryWithDatumTransformation": true,
    "supportsCurrentUserQueries": true,
    "supportsQueryAttachmentsWithReturnUrl": true,
    "fullTextSearchCapabilities": {
     "supportsOperator": true,
     "supportsSearchOperator": true
    },
    "supportsDefaultSR": true,
    "supportsQueryDateBins": false,
    "supportsQueryWithLodSR": false,
    "supportsPaginationOnAggregatedQueries": true,
    "supportsMaxRecordCountFactor": true,
    "supportsPagination": true,
    "fullTextSearchableFields": [],
    "supportsStatistics": true,
    "supportsOrderBy": true,
    "supportsFullTextSearch": true,
    "supportsLod": false,
    "supportsSpatialAggregationStatistics": false,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryAttachments": true,
    "supportsQueryAttachmentsCountOnly": true,
    "supportsReturningQueryExtent": true,
    "supportsOrderByOnlyOnLayerFields": false,
    "supportsOutFieldSqlExpression": true,
    "supportsTopFeaturesQuery": true,
    "supportsDistinct": true,
    "supportsQueryAnalytic": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true
   },
   "subtypeField": "",
   "supportsValidateSQL": true,
   "enableZDefaults": true,
   "serviceItemId": "e26e04f1ade94fad88561b072e706195",
   "allowUpdateWithoutMValues": true,
   "supportsCoordinatesQuantization": true,
   "types": [],
   "capabilities": "Query,Create,Update,Delete,Editing,Sync,Uploads",
   "supportsAppend": true,
   "supportsExceedsLimitStatistics": true,
   "advancedQueryAnalyticCapabilities": {
    "supportsAsync": true,
    "supportsLinearRegression": true,
    "supportsPercentileAnalytic": false
   },
   "hasMetadata": true,
   "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile",
   "tileMaxRecordCount": 4000,
   "typeIdField": "",
   "supportsASyncCalculate": true,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "sqlParserVersion": "PG_11.4.0",
   "copyrightText": "",
   "zDefault": 0,
   "supportsLayerOverrides": true
  }
 ],
 "layers": [
  {
   "isCoGoEnabled": false,
   "extent": {
    "ymin": "NaN",
    "xmin": "NaN",
    "ymax": "NaN",
    "xmax": "NaN",
    "spatialReference": {
     "falseM": -100000,
     "xyTolerance": 0.003280833333333333,
     "mUnits": 10000,
     "zUnits": 10000,
     "latestWkid": 3420,
     "zTolerance": 0.001,
     "wkid": 102678,
     "xyUnits": 3048.0060960121928,
     "mTolerance": 0.001,
     "falseX": -121025700,
     "falseY": -93674900,
     "falseZ": -100000
    }
   },
   "isDataBranchVersioned": false,
   "supportsApplyEditsWithGlobalIds": true,
   "maxRecordCount": 1000,
   "infoInEstimates": [
    "extent",
    "count"
   ],
   "datesInUnknownTimezone": false,
   "type": "Feature Layer",
   "onlyAllowTrueCurveUpdatesByTrueCurveClients": true,
   "supportsAttachmentsByUploadId": true,
   "editingInfo": {"lastEditDate": 1793641234521},
   "relationships": [
    {
     "keyField": "uniquerowid",
     "role": "esriRelRoleOrigin",
     "composite": false,
     "name": "crew_positions_ExportTable",
     "relatedTableId": 1,
     "id": 0,
     "cardinality": "esriRelCardinalityOneToMany"
    }
   ],
   "hasViews": true,
   "supportsAttachmentsResizing": true,
   "cimVersion": "3.5.0",
   "isDataArchived": true,
   "id": 0,
   "spatialReference": {
    "falseM": -100000,
    "xyTolerance": 0.003280833333333333,
    "mUnits": 10000,
    "zUnits": 10000,
    "latestWkid": 3420,
    "zTolerance": 0.001,
    "wkid": 102678,
    "xyUnits": 3048.0060960121928,
    "mTolerance": 0.001,
    "falseX": -121025700,
    "falseY": -93674900,
    "falseZ": -100000
   },
   "supportsSubtypeEditing": true,
   "supportsStatistics": true,
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "standardMaxRecordCount": 16000,
   "isDataVersioned": false,
   "templates": [
    {
     "name": "Crew_Day",
     "description": "",
     "drawingTool": "esriFeatureEditToolPoint",
     "prototype": {
      "attributes": {
       "choice_filter4": null,
       "choice_filter5": null,
       "choice_filter2": null,
       "choice_filter3": null,
       "project_name": null,
       "selected_crew": null,
       "crew_task_detail_list": null,
       "uniquerowid": null,
       "default_crew_condition": null,
       "crewnumber1": null,
       "crew1": null,
       "selected_count": null,
       "crew2": null,
       "last_edited_date": null,
       "crew_equipment_list": null,
       "day_of_week": null,
       "created_user": null,
       "workdate": null,
       "crewdatekey": null,
       "default_crew": null,
       "choice_filter": null,
       "last_edited_user": null,
       "choice_filter6": null,
       "default_crew_assignment": null,
       "created_date": null,
       "crewnumber": null
      }
     }
    }
   ],
   "supportsAdvancedQueries": true,
   "parentLayer": null,
   "currentVersion": 11.5,
   "canScaleSymbols": false,
   "hasZ": false,
   "advancedEditingCapabilities": {
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportsReturnEditResults": true,
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "objectIdField": "objectid",
   "supportsQuantizationEditMode": true,
   "hasContingentValuesDefinition": false,
   "name": "Crew_Day",
   "allowTrueCurvesUpdates": false,
   "displayField": "crewnumber",
   "supportsCalculate": true,
   "fields": [
    {
     "nullable": false,
     "defaultValue": null,
     "editable": false,
     "length": 4,
     "type": "esriFieldTypeOID",
     "modelName": "objectid",
     "domain": null,
     "name": "objectid",
     "alias": "ObjectID"
    },
    {
     "nullable": false,
     "editable": false,
     "defaultValue": null,
     "length": 38,
     "type": "esriFieldTypeGlobalID",
     "modelName": "globalid",
     "domain": null,
     "name": "globalid",
     "alias": "GlobalID"
    },
    {
     "modelName": "uniquerowid",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "uniquerowid",
     "length": 38,
     "alias": "RowID",
     "type": "esriFieldTypeGUID"
    },
    {
     "modelName": "workdate",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "precision": 1,
     "name": "workdate",
     "length": 29,
     "alias": "Work Date",
     "type": "esriFieldTypeDate"
    },
    {
     "modelName": "crewnumber",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": {
      "splitPolicy": "esriSPTDefaultValue",
      "name": "service_26f5f9df663d4ce0ac43ba875bf2fcd6_cvd_crewnumber",
      "description": "",
      "type": "codedValue",
      "codedValues": [
       {
        "code": "1",
        "name": "1"
       },
       {
        "code": "2",
        "name": "2"
       },
       {
        "code": "3",
        "name": "3"
       },
       {
        "code": "4",
        "name": "4"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue"
     },
     "name": "crewnumber",
     "length": 255,
     "alias": "Crew Number",
     "type": "esriFieldTypeString"
    },
    {
     "modelName": "crewdatekey",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "crewdatekey",
     "length": 255,
     "alias": "Crew Datekey",
     "type": "esriFieldTypeString"
    },
    {
     "modelName": "selected_count",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "selected_count",
     "alias": "Selected Count",
     "type": "esriFieldTypeInteger"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "precision": 1,
     "length": 29,
     "type": "esriFieldTypeDate",
     "required": true,
     "modelName": "created_date",
     "domain": null,
     "name": "created_date",
     "alias": "created_date"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "length": 255,
     "type": "esriFieldTypeString",
     "required": true,
     "modelName": "created_user",
     "domain": null,
     "name": "created_user",
     "alias": "created_user"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "precision": 1,
     "length": 29,
     "type": "esriFieldTypeDate",
     "required": true,
     "modelName": "last_edited_date",
     "domain": null,
     "name": "last_edited_date",
     "alias": "last_edited_date"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "length": 255,
     "type": "esriFieldTypeString",
     "required": true,
     "modelName": "last_edited_user",
     "domain": null,
     "name": "last_edited_user",
     "alias": "last_edited_user"
    },
    {
     "modelName": "choice_filter4",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "choice_filter4",
     "length": 255,
     "alias": "Choice Filter",
     "type": "esriFieldTypeString"
    },
    {
     "modelName": "crewnumber1",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "crewnumber1",
     "length": 256,
     "alias": "Crew Number",
     "type": "esriFieldTypeString"
    },
    {
     "modelName": "choice_filter5",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "choice_filter5",
     "length": 256,
     "alias": "Choice Filter",
     "type": "esriFieldTypeString"
    },
    {
     "modelName": "choice_filter6",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "choice_filter6",
     "length": 256,
     "alias": "Choice Filter",
     "type": "esriFieldTypeString"
    },
    {
     "modelName": "day_of_week",
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "day_of_week",
     "length": 255,
     "alias": "Day of Week",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": {
      "name": "service_26f5f9df663d4ce0ac43ba875bf2fcd6_cvd_assign_default",
      "type": "codedValue",
      "codedValues": [
       {
        "code": "yes",
        "name": "Yes"
       },
       {
        "code": "no",
        "name": "No"
       }
      ]
     },
     "name": "assign_default",
     "length": 255,
     "alias": "Assign Default Crew",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "name": "choice_filter",
     "length": 10000,
     "alias": "choice_filter",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "name": "choice_filter2",
     "length": 10000,
     "alias": "choice_filter2",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "name": "choice_filter3",
     "length": 10000,
     "alias": "choice_filter3",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "name": "project_name",
     "length": 40000,
     "alias": "project_name",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": {
      "name": "service_26f5f9df663d4ce0ac43ba875bf2fcd6_cvd_daily_default",
      "type": "codedValue",
      "codedValues": [
       {
        "code": "yes",
        "name": "Yes"
       },
       {
        "code": "no",
        "name": "No"
       }
      ]
     },
     "name": "daily_default",
     "length": 255,
     "alias": "Daily Default Crew",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "domain": null,
     "name": "default_project",
     "length": 255,
     "alias": "Default Project",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "name": "selected_crew",
     "length": 10000,
     "alias": "selected_crew",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "name": "default_crew",
     "length": 10000,
     "alias": "default_crew",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "name": "crew_equipment_list",
     "length": 10000,
     "alias": "crew_equipment_list",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "name": "default_crew_assignment",
     "length": 10000,
     "alias": "default_crew_assignment",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "name": "default_crew_condition",
     "length": 10000,
     "alias": "default_crew_condition",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "name": "crew1",
     "length": 10000,
     "alias": "crew1",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "name": "crew2",
     "length": 10000,
     "alias": "crew2",
     "type": "esriFieldTypeString"
    },
    {
     "nullable": true,
     "editable": true,
     "defaultValue": null,
     "name": "crew_task_detail_list",
     "length": 10000,
     "alias": "crew_task_detail_list",
     "type": "esriFieldTypeString"
    }
   ],
   "maxRecordCountFactor": 1,
   "dateFieldsTimeReference": {
    "timeZoneIANA": "Etc/UTC",
    "respectsDaylightSaving": false,
    "timeZone": "UTC"
   },
   "supportsFieldDescriptionProperty": true,
   "hasM": false,
   "allowGeometryUpdates": true,
   "supportsDurableUrlForSyncModelNone": false,
   "useStandardizedQueries": true,
   "globalIdField": "globalid",
   "sourceSpatialReference": {
    "wkt": "PROJCS[\"NAD_1983_StatePlane_Kansas_South_FIPS_1502_Feet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Lambert_Conformal_Conic\"],PARAMETER[\"False_Easting\",1312333.333333333],PARAMETER[\"False_Northing\",1312333.333333333],PARAMETER[\"Central_Meridian\",-98.5],PARAMETER[\"Standard_Parallel_1\",37.26666666666667],PARAMETER[\"Standard_Parallel_2\",38.56666666666667],PARAMETER[\"Latitude_Of_Origin\",36.66666666666666],UNIT[\"Foot_US\",0.3048006096012192]]",
    "falseM": -100000,
    "mUnits": 10000,
    "zUnits": 10000,
    "zTolerance": 0.001,
    "wkid": 3420,
    "xyUnits": 3048.0060960121928,
    "mTolerance": 0.001,
    "falseX": -121025700,
    "falseY": -93674900,
    "falseZ": -100000
   },
   "description": "",
   "syncCanReturnChanges": true,
   "supportsAsyncDelete": true,
   "supportedSpatialRelationships": [
    "esriSpatialRelIntersects",
    "esriSpatialRelContains",
    "esriSpatialRelCrosses",
    "esriSpatialRelEnvelopeIntersects",
    "esriSpatialRelOverlaps",
    "esriSpatialRelTouches",
    "esriSpatialRelWithin"
   ],
   "supportsRollbackOnFailureParameter": true,
   "isDataReplicaTracked": true,
   "standardMaxRecordCountNoGeometry": 16000,
   "supportsTruncate": false,
   "indexes": [
    {
     "name": "g6645uniquerowid",
     "isUnique": false,
     "description": "",
     "fields": "uniquerowid",
     "isAscending": true
    },
    {
     "name": "r2230_sde_rowid_uk",
     "isUnique": false,
     "description": "",
     "fields": "objectid",
     "isAscending": true
    },
    {
     "name": "uuid_2230",
     "isUnique": true,
     "description": "",
     "fields": "globalid",
     "isAscending": true
    },
    {
     "name": "a997_ix1",
     "isUnique": false,
     "description": "",
     "fields": "shape",
     "isAscending": true
    }
   ],
   "supportedAppendSourceFilterFormats": "featureService",
   "editFieldsInfo": null,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "GUIDFormat": "O",
   "minScale": 0,
   "hasAttachments": false,
   "queryBinsCapabilities": {
    "supportsFirstDayOfWeek": false,
    "supportedNormalizationTypes": [
     "boxCox",
     "field",
     "inverse",
     "log",
     "naturalLog",
     "percentOfTotal",
     "squareRoot"
    ],
    "supportedStatisticTypes": [
     "count",
     "sum",
     "min",
     "max",
     "avg",
     "stddev",
     "var",
     "percentile_cont",
     "percentile_disc"
    ],
    "supportsNormalization": true,
    "supportsSnapToData": true,
    "supportsFixedIntervalBin": true,
    "supportsStackBy": true,
    "supportsAutoIntervalBin": true,
    "supportsFixedBoundariesBin": true,
    "supportsDateBin": true,
    "supportsSplitBy": true,
    "supportsReturnFullIntervalBin": true
   },
   "advancedQueryCapabilities": {
    "supportsSqlExpression": true,
    "supportsQueryWithResultType": true,
    "supportsQueryRelatedPagination": true,
    "supportsQueryWithCacheHint": false,
    "supportsQueryWithDatumTransformation": true,
    "supportsCurrentUserQueries": true,
    "supportsQueryAttachmentsWithReturnUrl": true,
    "fullTextSearchCapabilities": {
     "supportsOperator": true,
     "supportsSearchOperator": true
    },
    "supportsDefaultSR": true,
    "supportsQueryDateBins": false,
    "supportsQueryWithLodSR": true,
    "supportsPaginationOnAggregatedQueries": true,
    "supportsPagination": true,
    "supportsMaxRecordCountFactor": true,
    "fullTextSearchableFields": [],
    "supportsStatistics": true,
    "supportsOrderBy": true,
    "supportsFullTextSearch": true,
    "supportsQueryWithDistance": true,
    "supportsLod": true,
    "supportsSpatialAggregationStatistics": false,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryAttachments": true,
    "supportsReturningQueryExtent": true,
    "supportsQueryAttachmentsCountOnly": true,
    "supportsOrderByOnlyOnLayerFields": false,
    "supportsOutFieldSqlExpression": true,
    "supportsTopFeaturesQuery": true,
    "supportsReturningGeometryEnvelope": false,
    "supportsDistinct": true,
    "supportsReturningGeometryCentroid": false,
    "supportsQueryAnalytic": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true
   },
   "subtypeField": "",
   "supportsValidateSQL": true,
   "enableZDefaults": true,
   "serviceItemId": "e26e04f1ade94fad88561b072e706195",
   "allowUpdateWithoutMValues": true,
   "supportsCoordinatesQuantization": true,
   "types": [],
   "capabilities": "Query,Create,Update,Delete,Editing,Sync,Uploads",
   "maxScale": 0,
   "supportsAppend": true,
   "supportsExceedsLimitStatistics": true,
   "sourceSchemaChangesAllowed": true,
   "defaultVisibility": true,
   "advancedQueryAnalyticCapabilities": {
    "supportsAsync": true,
    "supportsLinearRegression": true,
    "supportsPercentileAnalytic": false
   },
   "hasMetadata": true,
   "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile",
   "tileMaxRecordCount": 4000,
   "typeIdField": "",
   "supportsASyncCalculate": true,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "sqlParserVersion": "PG_11.4.0",
   "drawingInfo": {
    "renderer": {
     "symbol": {
      "outline": {
       "color": [
        0,
        0,
        0,
        255
       ],
       "width": 0.7
      },
      "color": [
       86,
       60,
       135,
       255
      ],
      "size": 4,
      "yoffset": 0,
      "xoffset": 0,
      "angle": 0,
      "style": "esriSMSCircle",
      "type": "esriSMS"
     },
     "type": "simple"
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "geometryField": {
    "sqlType": "sqlTypeDistinct",
    "nullable": true,
    "editable": true,
    "name": "shape",
    "typeName": "st_point",
    "length": 2147483647,
    "type": "esriFieldTypeGeometry"
   },
   "copyrightText": "",
   "zDefault": 0,
   "geometryType": "esriGeometryPoint",
   "supportsLayerOverrides": true
  }
 ]
}