{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Projects_eSTIP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ProjName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ProjName", "type": "esriFieldTypeString", "alias": "ProjName", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "ProjName" }, { "name": "ProjStatus", "type": "esriFieldTypeString", "alias": "ProjStatus", "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" }, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "ProjStatus" }, { "name": "ProjProgram", "type": "esriFieldTypeString", "alias": "ProjProgram", "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" }, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "ProjProgram" }, { "name": "PTS_ID", "type": "esriFieldTypeString", "alias": "PTS_ID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PTS_ID" }, { "name": "ReponsibleAgency", "type": "esriFieldTypeString", "alias": "ReponsibleAgency", "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" }, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "ReponsibleAgency" }, { "name": "TIP_ID", "type": "esriFieldTypeInteger", "alias": "TIP_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TIP_ID" }, { "name": "Investment_Type", "type": "esriFieldTypeString", "alias": "Investment_Type", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Investment_Type" }, { "name": "Export_Status", "type": "esriFieldTypeString", "alias": "Export_Status", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Export_Status" }, { "name": "BundleDescription", "type": "esriFieldTypeString", "alias": "BundleDescription", "domain": null, "editable": true, "nullable": true, "length": 600, "defaultValue": null, "modelName": "BundleDescription" } ], "indexes": [ { "name": "R526_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Projects_eSTIP", "description": "", "prototype": { "attributes": { "Export_Status": null, "ProjName": null, "ProjStatus": null, "ProjProgram": null, "PTS_ID": null, "ReponsibleAgency": null, "TIP_ID": null, "Investment_Type": null, "BundleDescription": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "4143b7410e4f44b1b2c26b7dcb56d9fb" }