colorado-gov/construction-project-line-segments-for-funded-ibqw-39av
Icon for Socrata external plugin
  •  
    Overview
  •  
    Tables
  •  
    REST API
  •  
    SQL Query
Open repository in Console
 
Readme
Updated 11 months ago
‧
Indexed 11 months ago

Construction Project Line Segments for Funded Roads in Colorado 2017

Line segments and associated project 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 Endpoints for Funded Roads in Colorado.

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-project-line-segments-for-funded-ibqw-39av\".\"construction_project_line_segments_for_funded\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • construction_project_line_segments_for_funded
     
    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 SystemNot specifiedWeb Display Coordinate SystemWGS84
Data QualityExpected Update FrequencyStatic
Data UpdatesUpdate TypeStaticUpdate MethodNoneUpdate ScheduleNoneSource Update ScheduleNot specifiedTotal Records At Initial PublishNot specified
Data DescriptionSingle RowVector line segments detailing the location of current construction projectsCollection ModeNot specifiedLong DescriptionRoad construction project and associated construction project id, road location id, beginning and ending milepoint, project timeline dates, improvement type, county, congressional jurisdiction, CDOT jurisdiction. Fields include road construction project and all related dates as the project moves through funding, into production, and then through project closing procedures. Associated dataset https://data.colorado.gov/Transportation/Construction-Projects-Endpoints-for-Funded-Roads-i/7bzf-vissRelated DatasetsJoinable to: Construction Projects Endpoints for Funded Roads in Colorado 2017 based on "PROJECT_ID"Collection MethodNot specifiedNewest Record in Dataset03/13/2017Oldest Record in Dataset06/23/2010Data Collection InstrumentNot specifiedField Names, comma delimitedsaplongid, 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, projectid, recordid, projectty, pratx, laneq, rdcf, rdcs, rdcr, countydesc, congdist, commdist, fid, shape, project_id, saplongid, sapproject, sapproje_1Date of Initial Dataset CreationNot specified
Dataset CoverageGranularityNot specifiedUnit of AnalysisVector lineGeographic 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 Project Line Segments for Funded Roads in Colorado 2017
11 months ago (updated)
11 months ago (indexed)
Loading...

Topics

  • active projects
  • bic
  • cdot
  • colorado
  • colorado department of transportation
  • + 9

Sources

  • Colorado Information Marketplace - Construction Project Line Segments for Funded Roads in Colorado 2017
  • CDOT (creator)

License

Public Domain