search

cyipt / cyipt-website

CyIPT website
https://www.cyipt.bike/
0 stars 2 forks source link

Update PCT layer #27

Open Robinlovelace opened 6 years ago

Robinlovelace commented 6 years ago

Put the PCT routes in there.

mem48 commented 6 years ago

I'm going to add the Quiet routes as a separate table. Or does PostGIS support multiple geometry columns?

Robinlovelace commented 6 years ago

Yes for sure, just like with sf. See here: https://gis.stackexchange.com/questions/176263/can-a-postgis-table-or-view-have-two-geometry-columns

mem48 commented 6 years ago

New data in the pctlsoa table

idn INT PRIMARY KEY, id VARCHAR(19) NOT NULL, allCommuters INT NULL, onfoot INT NULL, carorvan INT NULL, pctcensus INT NULL, pctgov INT NULL, pctgen INT NULL, pctdutch INT NULL, pctebike INT NULL, fastDist REAL NULL, fastTime REAL NULL, fastSlope REAL NULL, fastGeom GEOMETRY NULL, quietDist REAL NULL, quietSlope REAL NULL, quietTime REAL NULL, quietGeom GEOMETRY NULL, straightDist REAL NULL, straightGeom GEOMETRY NULL, fastCircuity REAL NULL, quietCircuity REAL NULL, quietDiversion REAL NULL, quietDiverTime REAL NULL

There are 3 geometries in here fast routes, quiet routes, and straight line, with spatial index built on the fast routes.

I'd sugges that we add a new layer call missing links allowing filtering on the different circuity options