Construction Projects Endpoints for Funded Roads in Colorado 2017

Name: Construction Projects Endpoints for Funded Roads in Colorado 2017
Creator: CDOT
Published: 2017-05-19T02:05:49

Point locations of mileposts for start and end of road projects and associated improvement codes and timelines for active construction projects on funded roads in Colorado August 2010 through March 2017 from the Colorado Department of Transportation (CDOT). Use this data with Construction Projects Line Segments.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"colorado-gov/construction-projects-endpoints-for-funded-roads-py3d-8rcb\".\"construction_projects_endpoints_for_funded_roads\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

Preview

construction_projects_endpoints_for_funded_roads

Left sidebar is currently unimplemented

Right sidebar is currently unimplemented

Upstream Metadata

GeospatialCollection MethodNot specifiedHorizontal AccuracyNot specifiedCoordinate System DisclaimerNOTE: To maintain source projection, select “Export Original” from export menu. To display on the web, export using any other option.Horizontal Coordinate SystemEPSG:29613, NAD83/ UTM zone 13NWeb Display Coordinate SystemWGS84

Data QualityExpected Update FrequencyStatic

Data UpdatesUpdate TypeStaticUpdate MethodNoneUpdate ScheduleNoneSource Update ScheduleNot specifiedTotal Records At Initial PublishNot specified

Data DescriptionSingle RowVector point locations of mile markers for the start and end of current construction projectsCollection ModeProjects Systems SAP, joined with GIS road segmentsLong DescriptionPoint locations of mileposts for start and end of road projects and associated improvement codes and timelines for active construction projects on funded roads in Colorado August 2010 through March 2017 from the Colorado Department of Transportation (CDOT). Use this data with Construction Projects Line Segments.Related DatasetsJoinable to: Construction Project Line Segments for Funded Roads in Colorado 2017 based on "PROJECT_ID"Collection MethodDepending on the project, data is updated daily, weekly and monthly as projects move through timelinesNewest Record in Dataset03/14/2017Oldest Record in Dataset08/02/2010Data Collection InstrumentData is collected by transportation divisionsField Names, comma delimitedproject_id, saplongid, sapprojecttype, sapprojectdescription, saprecid, route, refpt, endrefpt, beginx, beginy, endx, endy, guid, lrs_date, tpr, mpo, proj_pspid, zzconshd_endate, zzproj_endate, zzf_imp_cd, zzac_ad_dt, zzshelf_dt, zzactletdate, zzconexdate, zzest_pcd, ztp_arra_pspid, zconstrtdate, fedimpcode, fedimpdesc, laneq, rdcf, rdcs, rdcr, countydesc, congdist, commdistDate of Initial Dataset CreationNot specified

Dataset CoverageGranularityNot specifiedUnit of AnalysisVector pointGeographic CoverageState

Contributing Agency InformationCitationCDOT - Colorado Department of TransportationData SourceNot specifiedAgency Program Pagehttps://www.codot.gov/Agency Data Series Pagehttps://www.codot.gov/projects/active-construction-projects

Additional Dataset DocumentationData DictionaryNot specifiedAdditional MetadataNot specifiedTechnical DocumentationNot specified

About

Construction Projects Endpoints for Funded Roads in Colorado 2017

11 months ago (updated)

11 months ago (indexed)

Topics