{ "currentVersion": 10.81, "id": 1211, "name": "Ditching - Excavator or Backhoe Historic", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "mv_id", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "dwr_unit_id", "type": "esriFieldTypeDouble", "alias": "DWR Unit Id", "domain": null }, { "name": "crew", "type": "esriFieldTypeString", "alias": "CREW", "length": 20, "domain": null }, { "name": "unit_descr", "type": "esriFieldTypeString", "alias": "DWR Unit Description", "length": 50, "domain": null }, { "name": "dwr_reg", "type": "esriFieldTypeString", "alias": "DWR Region", "length": 1, "domain": null }, { "name": "dwr_sys_id", "type": "esriFieldTypeDouble", "alias": "DWR Sys Id", "domain": null }, { "name": "dwr_year", "type": "esriFieldTypeDouble", "alias": "DWR Year", "domain": null }, { "name": "dwr_fy", "type": "esriFieldTypeDouble", "alias": "DWR Fiscal Year", "domain": null }, { "name": "act_descr", "type": "esriFieldTypeString", "alias": "Activity Description", "length": 50, "domain": null }, { "name": "accomp_qty", "type": "esriFieldTypeDouble", "alias": "Accomplishment Qty", "domain": null }, { "name": "accomp_uom", "type": "esriFieldTypeString", "alias": "Accomplishment UOM", "length": 6, "domain": null }, { "name": "rt_code", "type": "esriFieldTypeString", "alias": "Route Code", "length": 20, "domain": null }, { "name": "bmp", "type": "esriFieldTypeDouble", "alias": "Begin Mile Point", "domain": null }, { "name": "begin_town", "type": "esriFieldTypeString", "alias": "Begin Town", "length": 50, "domain": null }, { "name": "emp", "type": "esriFieldTypeDouble", "alias": "End Mile Point", "domain": null }, { "name": "end_town", "type": "esriFieldTypeString", "alias": "End Town", "length": 50, "domain": null }, { "name": "side_of_road", "type": "esriFieldTypeString", "alias": "Side of Road", "length": 50, "domain": null }, { "name": "asset_sys_id", "type": "esriFieldTypeDouble", "alias": "Asset Sys Id", "domain": null }, { "name": "asset_descr", "type": "esriFieldTypeString", "alias": "Asset Description", "length": 60, "domain": null }, { "name": "asset_display_code", "type": "esriFieldTypeString", "alias": "Asset Display Code", "length": 50, "domain": null }, { "name": "txn_wr_sys_id", "type": "esriFieldTypeDouble", "alias": "Work Request ID", "domain": null }, { "name": "wr_descr", "type": "esriFieldTypeString", "alias": "Work Request Description", "length": 50, "domain": null }, { "name": "win", "type": "esriFieldTypeString", "alias": "WIN", "length": 20, "domain": null }, { "name": "win_ea_descr", "type": "esriFieldTypeString", "alias": "Expenditure Account Description", "length": 50, "domain": null }, { "name": "txn_br_sys_id", "type": "esriFieldTypeDouble", "alias": "Budget Request Sys Id", "domain": null }, { "name": "br_descr", "type": "esriFieldTypeString", "alias": "Budget Request Description", "length": 50, "domain": null }, { "name": "br_priority", "type": "esriFieldTypeString", "alias": "Budget Request Priority", "length": 50, "domain": null }, { "name": "br_type", "type": "esriFieldTypeString", "alias": "Budget Request Type", "length": 50, "domain": null }, { "name": "num_geo_points", "type": "esriFieldTypeInteger", "alias": "Number of Geopoints", "domain": null }, { "name": "ag_sys_id", "type": "esriFieldTypeDouble", "alias": "Asset Group Sys Id", "domain": null }, { "name": "ag_descr", "type": "esriFieldTypeString", "alias": "Asset Group Description", "length": 50, "domain": null }, { "name": "asset_type_sys_id", "type": "esriFieldTypeDouble", "alias": "Asset Type Sys Id", "domain": null }, { "name": "asset_type_descr", "type": "esriFieldTypeString", "alias": "Asset Type Description", "length": 50, "domain": null }, { "name": "dwr_date", "type": "esriFieldTypeDate", "alias": "DWR Date", "length": 8, "domain": null }, { "name": "mv_id", "type": "esriFieldTypeInteger", "alias": "Map Viewer ID", "domain": null } ], "indexes": [ { "name": "r84_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }