{ "currentVersion": 10.61, "id": 1, "name": "PROJECTS_DATA_TFA", "type": "Table", "description": "TFA (\"Transportation Funding Act\") Projects Data.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PROJECT_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "PROJECT_ID", "type": "esriFieldTypeString", "alias": "PROJECT_ID", "length": 16, "domain": null }, { "name": "PROJECT_DESCR", "type": "esriFieldTypeString", "alias": "PROJECT_DESCR", "length": 1000, "domain": null }, { "name": "PROJECT_NAME", "type": "esriFieldTypeString", "alias": "PROJECT_NAME", "length": 60, "domain": null }, { "name": "PROJ_MGR_NAME", "type": "esriFieldTypeString", "alias": "PROJ_MGR_NAME", "length": 150, "domain": null }, { "name": "PROJ_MGR_OFFICE", "type": "esriFieldTypeString", "alias": "PROJ_MGR_OFFICE", "length": 30, "domain": null }, { "name": "PROJECT_STATUS_CD", "type": "esriFieldTypeString", "alias": "PROJECT_STATUS_CD", "length": 4, "domain": null }, { "name": "PROJECT_STATUS", "type": "esriFieldTypeString", "alias": "PROJECT_STATUS", "length": 50, "domain": null }, { "name": "PROJECT_TYPE", "type": "esriFieldTypeString", "alias": "PROJECT_TYPE", "length": 30, "domain": null }, { "name": "PRIM_WORK_TYP", "type": "esriFieldTypeString", "alias": "PRIM_WORK_TYP", "length": 30, "domain": null }, { "name": "REC_STATUS", "type": "esriFieldTypeString", "alias": "REC_STATUS", "length": 30, "domain": null }, { "name": "PROJ_ACCTNG_CD", "type": "esriFieldTypeString", "alias": "PROJ_ACCTNG_CD", "length": 20, "domain": null }, { "name": "ROW_ACCTNG_CD", "type": "esriFieldTypeString", "alias": "ROW_ACCTNG_CD", "length": 20, "domain": null }, { "name": "COUNTIES", "type": "esriFieldTypeString", "alias": "COUNTIES", "length": 4000, "domain": null }, { "name": "CONG_DISTRICTS", "type": "esriFieldTypeString", "alias": "CONG_DISTRICTS", "length": 4000, "domain": null }, { "name": "DISTRICTS", "type": "esriFieldTypeString", "alias": "DISTRICTS", "length": 4000, "domain": null }, { "name": "SENATE_DISTRICTS", "type": "esriFieldTypeString", "alias": "SENATE_DISTRICTS", "length": 4000, "domain": null }, { "name": "HOUSE_DISTRICTS", "type": "esriFieldTypeString", "alias": "HOUSE_DISTRICTS", "length": 4000, "domain": null }, { "name": "MGMNT_DIR_LET_DT", "type": "esriFieldTypeDate", "alias": "MGMNT_DIR_LET_DT", "length": 8, "domain": null }, { "name": "MGMNT_DIR_ROW_DT", "type": "esriFieldTypeDate", "alias": "MGMNT_DIR_ROW_DT", "length": 8, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": null }, { "name": "STIP", "type": "esriFieldTypeString", "alias": "STIP", "length": 1, "domain": null }, { "name": "CORRIDOR_DESCR", "type": "esriFieldTypeString", "alias": "CORRIDOR_DESCR", "length": 50, "domain": null }, { "name": "PROJECT_MANAGER_OFFICE", "type": "esriFieldTypeString", "alias": "PROJECT_MANAGER_OFFICE", "length": 30, "domain": null }, { "name": "PROJECT_ACCOUNTING_NUMBER", "type": "esriFieldTypeString", "alias": "PROJECT_ACCOUNTING_NUMBER", "length": 20, "domain": null }, { "name": "PRIMARY_WORK_TYPE", "type": "esriFieldTypeString", "alias": "PRIMARY_WORK_TYPE", "length": 30, "domain": null }, { "name": "LET_STATUS", "type": "esriFieldTypeString", "alias": "LET_STATUS", "length": 5, "domain": null }, { "name": "SUE_CONSULTANT_AGREE_TYP", "type": "esriFieldTypeString", "alias": "SUE_CONSULTANT_AGREE_TYP", "length": 4000, "domain": null }, { "name": "GIS_SHORT_DESCR", "type": "esriFieldTypeString", "alias": "GIS_SHORT_DESCR", "length": 60, "domain": null }, { "name": "NEWPROJECT_DESCR", "type": "esriFieldTypeString", "alias": "NEWPROJECT_DESCR", "length": 60, "domain": null }, { "name": "MGM_LET_DATE", "type": "esriFieldTypeDate", "alias": "MGM_LET_DATE", "length": 8, "domain": null }, { "name": "STATUS_CODE", "type": "esriFieldTypeString", "alias": "STATUS_CODE", "length": 4, "domain": null }, { "name": "PRIORITY_CD", "type": "esriFieldTypeString", "alias": "PRIORITY_CD", "length": 5, "domain": null }, { "name": "MPO_TIP_ID", "type": "esriFieldTypeString", "alias": "MPO_TIP_ID", "length": 15, "domain": null }, { "name": "CORRIDOR_CD", "type": "esriFieldTypeString", "alias": "CORRIDOR_CD", "length": 2, "domain": null }, { "name": "DESCR", "type": "esriFieldTypeString", "alias": "DESCR", "length": 60, "domain": null }, { "name": "TOTAL_COST", "type": "esriFieldTypeDouble", "alias": "TOTAL_COST", "domain": null }, { "name": "TIA_AMOUNT", "type": "esriFieldTypeDouble", "alias": "TIA_AMOUNT", "domain": null }, { "name": "PLOTTED_ON_LET_LIST_MAP_IND", "type": "esriFieldTypeString", "alias": "PLOTTED_ON_LET_LIST_MAP_IND", "length": 1, "domain": null }, { "name": "FUNDING_TYP", "type": "esriFieldTypeString", "alias": "FUNDING_TYP", "length": 4, "domain": null }, { "name": "FUNDING_SOURCE", "type": "esriFieldTypeString", "alias": "FUNDING_SOURCE", "length": 100, "domain": null }, { "name": "GDOT_DISTRICTS", "type": "esriFieldTypeString", "alias": "GDOT_DISTRICTS", "length": 4000, "domain": null }, { "name": "CITIES", "type": "esriFieldTypeString", "alias": "CITIES", "length": 4000, "domain": null }, { "name": "MPOINT_ROUTES", "type": "esriFieldTypeString", "alias": "MPOINT_ROUTES", "length": 4000, "domain": null }, { "name": "ROUTE_NUMS", "type": "esriFieldTypeString", "alias": "ROUTE_NUMS", "length": 4000, "domain": null }, { "name": "MPOINT_BEGS", "type": "esriFieldTypeString", "alias": "MPOINT_BEGS", "length": 4000, "domain": null }, { "name": "MPOINT_ENDS", "type": "esriFieldTypeString", "alias": "MPOINT_ENDS", "length": 4000, "domain": null }, { "name": "RC_LINK", "type": "esriFieldTypeString", "alias": "RC_LINK", "length": 4000, "domain": null }, { "name": "PRIMARY_COUNTY", "type": "esriFieldTypeString", "alias": "PRIMARY_COUNTY", "length": 30, "domain": null }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "COUNTY", "length": 30, "domain": null }, { "name": "MID_POINT", "type": "esriFieldTypeString", "alias": "MID_POINT", "length": 4000, "domain": null }, { "name": "LET_RESP_CD", "type": "esriFieldTypeString", "alias": "LET_RESP_CD", "length": 3, "domain": null }, { "name": "LAST_UPDATED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_UPDATED_DATE", "length": 8, "domain": null }, { "name": "LAST_UPDATED_BY", "type": "esriFieldTypeString", "alias": "LAST_UPDATED_BY", "length": 50, "domain": null }, { "name": "GIS_REFRESH", "type": "esriFieldTypeDouble", "alias": "GIS_REFRESH", "domain": null }, { "name": "SORT_ORDER", "type": "esriFieldTypeDouble", "alias": "SORT_ORDER", "domain": null } ], "indexes": [ { "name": "PROJECT_TFA_ID_IDX", "fields": "PROJECT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "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 }