PostGIS - nealf/safe_walk_blacksburg GitHub Wiki

Some PostGIS queries for reference:

SELECT ST_AsGeoJSON(ST_Transform(ST_SetSRID(ST_MakePoint(-80.390180, 37.202092), 4326),2284));

Distance query: SELECT *, ST_Distance(geom, ST_Transform(ST_SetSRID(ST_MakePoint(-80.390180, 37.202092), 4326),2284)) AS distance1 FROM bbrcl ORDER BY ST_Distance(geom, ST_Transform(ST_SetSRID(ST_MakePoint(-80.390180, 37.202092), 4326),2284)) LIMIT 10;