{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Projects_eSTIP", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ProjName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ProjName", "type": "esriFieldTypeString", "alias": "ProjName", "length": 250, "domain": null }, { "name": "ProjStatus", "type": "esriFieldTypeString", "alias": "ProjStatus", "length": 250, "domain": { "type": "codedValue", "name": "WS5_Proj_Status", "description": "used for stip", "codedValues": [ { "name": "Advertised", "code": "Advertised" }, { "name": "Cancelled", "code": "Cancelled" }, { "name": "Construction - Active", "code": "Construction - Active" }, { "name": "Construction - Substantially Complete", "code": "Construction - Substantially Complete" }, { "name": "Construction - To be Finaled", "code": "Construction - To be Finaled" }, { "name": "Construction - Quality Control", "code": "Construction - Quality Control" }, { "name": "Design", "code": "Design" }, { "name": "Finaled", "code": "Finaled" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Legal Settlement", "code": "Legal Settlement" }, { "name": "On Hold", "code": "On Hold" }, { "name": "Planning", "code": "Planning" }, { "name": "Scoping", "code": "Scoping" }, { "name": "Stormwater - Construction", "code": "Stormwater - Construction" }, { "name": "Suspended", "code": "Suspended" }, { "name": "Transit - Subrecipient", "code": "Transit - Subrecipient" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ProjProgram", "type": "esriFieldTypeString", "alias": "ProjProgram", "length": 250, "domain": { "type": "codedValue", "name": "WS5_Proj_Program", "description": "used for stip", "codedValues": [ { "name": "Active Transportation Program", "code": "Active Transportation Program" }, { "name": "RIDOT Transit Program", "code": "RIDOT Transit Program" }, { "name": "RIDOT NHTSA Program", "code": "RIDOT NHTSA Program" }, { "name": "RIDOT Bridge Program", "code": "RIDOT Bridge Program" }, { "name": "RIDOT Pavement Program", "code": "RIDOT Pavement Program" }, { "name": "RIDOT Major Capital Projects Program", "code": "RIDOT Major Capital Projects Program" }, { "name": "RIDOT Stormwater Program", "code": "RIDOT Stormwater Program" }, { "name": "RIDOT Maintenance Operations Program", "code": "RIDOT Maintenance Operations Program" }, { "name": "RIDOT Headquarters Operations Program", "code": "RIDOT Headquarters Operations Program" }, { "name": "RIDOT Study and Development Program", "code": "RIDOT Study and Development Program" }, { "name": "RIDOT Debt Service Program", "code": "RIDOT Debt Service Program" }, { "name": "RIDOT Corridor Projects Program", "code": "RIDOT Corridor Projects Program" }, { "name": "RIDOT Traffic Safety Program", "code": "RIDOT Traffic Safety Program" }, { "name": "RIPTA Transit Capital", "code": "RIPTA Transit Capital" }, { "name": "RIPTA Transit Service", "code": "RIPTA Transit Service" }, { "name": "RIPTA Transit Support Operations", "code": "RIPTA Transit Support Operations" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PTS_ID", "type": "esriFieldTypeString", "alias": "PTS_ID", "length": 10, "domain": null }, { "name": "ReponsibleAgency", "type": "esriFieldTypeString", "alias": "ReponsibleAgency", "length": 150, "domain": { "type": "codedValue", "name": "dResponsibleParty_1", "description": "Domain for Responsible parties", "codedValues": [ { "name": "Barrington", "code": "1.0" }, { "name": "Bristol", "code": "2.0" }, { "name": "Burrillville", "code": "3.0" }, { "name": "Central Falls", "code": "4.0" }, { "name": "Charlestown", "code": "5.0" }, { "name": "Coventry", "code": "6.0" }, { "name": "Cranston", "code": "7.0" }, { "name": "Cumberland", "code": "8.0" }, { "name": "East Greenwich", "code": "9.0" }, { "name": "East Providence", "code": "10.0" }, { "name": "Exeter", "code": "11.0" }, { "name": "Foster", "code": "12.0" }, { "name": "Glocester", "code": "13.0" }, { "name": "Hopkinton", "code": "14.0" }, { "name": "Jamestown", "code": "15.0" }, { "name": "Johnston", "code": "16.0" }, { "name": "Lincoln", "code": "17.0" }, { "name": "Little Compton", "code": "18.0" }, { "name": "Middletown", "code": "19.0" }, { "name": "Narraganset", "code": "20.0" }, { "name": "Newport", "code": "21.0" }, { "name": "New Shoreham", "code": "22.0" }, { "name": "North Kingstown", "code": "23.0" }, { "name": "North Providence", "code": "24.0" }, { "name": "North Smithfield", "code": "25.0" }, { "name": "Pawtucket", "code": "26.0" }, { "name": "Portsmouth", "code": "27.0" }, { "name": "Providence", "code": "28.0" }, { "name": "Richmond", "code": "29.0" }, { "name": "Scituate", "code": "30.0" }, { "name": "Smithfield", "code": "31.0" }, { "name": "South Kingstown", "code": "32.0" }, { "name": "Tiverton", "code": "33.0" }, { "name": "Warren", "code": "34.0" }, { "name": "Warwick", "code": "35.0" }, { "name": "Westerly", "code": "36.0" }, { "name": "West Greenwich", "code": "37.0" }, { "name": "West Warwick", "code": "38.0" }, { "name": "Woonsocket", "code": "39.0" }, { "name": "RIDOT", "code": "40.0" }, { "name": "RIPTA", "code": "41.0" }, { "name": "RIDEM", "code": "42.0" }, { "name": "Statewide(DOA)", "code": "43.0" }, { "name": "AMTRAK", "code": "44.0" }, { "name": "Quonset Development Corp", "code": "45.0" }, { "name": "Providence & Worcester RR", "code": "46.0" }, { "name": "Newport Secondary RR", "code": "47.0" }, { "name": "RI Airport Corporation RIAC", "code": "48.0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TIP_ID", "type": "esriFieldTypeInteger", "alias": "TIP_ID", "domain": null }, { "name": "Investment_Type", "type": "esriFieldTypeString", "alias": "Investment_Type", "length": 255, "domain": { "type": "codedValue", "name": "WS5_Invest_Type", "description": "used for stip", "codedValues": [ { "name": "Bicycle Enhancement", "code": "Bicycle Enhancement" }, { "name": "Pedestrian Enhancement", "code": "Pedestrian Enhancement" }, { "name": "Debt Service", "code": "Debt Service" }, { "name": "Operations", "code": "Operations" }, { "name": "Roadway / Bridge / Drainage", "code": "Roadway / Bridge / Drainage" }, { "name": "Studies / Engineering", "code": "Studies / Engineering" }, { "name": "Safety Improvements", "code": "Safety Improvements" }, { "name": "Transit Rail", "code": "Transit Rail" }, { "name": "Transit Bus", "code": "Transit Bus" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Export_Status", "type": "esriFieldTypeString", "alias": "Export_Status", "length": 255, "domain": { "type": "codedValue", "name": "dBundleStatus", "description": "", "codedValues": [ { "name": "Review", "code": "Review" }, { "name": "Draft", "code": "Draft" }, { "name": "Accepted", "code": "Accepted" }, { "name": "Rejected", "code": "Rejected" }, { "name": "Final", "code": "Final" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BundleDescription", "type": "esriFieldTypeString", "alias": "BundleDescription", "length": 600, "domain": null } ], "indexes": [ { "name": "R526_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,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": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "6877fa836af2404dab4a400781e0c392" }