Reputation
254
Top tag
Next privilege 300 Rep.
Create new tags
Badges
3 12
Newest
 Teacher
Impact
~9k people reached

Aug
3
awarded  Teacher
Aug
3
answered How can I do a subquery inside a subquery in PostGIS?
Aug
3
comment How can I do a subquery inside a subquery in PostGIS?
How can I do that exactly?
Aug
3
revised How can I do a subquery inside a subquery in PostGIS?
added 85 characters in body
Aug
3
asked How can I do a subquery inside a subquery in PostGIS?
Aug
3
comment How to SELECT all points within a GeoJSON polygon in PostGIS
How can I do a subquery on this also? ie. instead of FROM select * from table, I want to do FROM (select * from table where height>1500) as sub - but this doesn't work. Why?
Aug
3
revised How to SELECT all points within a GeoJSON polygon in PostGIS
added working solution for me, but keeping the good answer
Aug
3
suggested approved edit on How to SELECT all points within a GeoJSON polygon in PostGIS
Aug
3
accepted How to SELECT all points within a GeoJSON polygon in PostGIS
Aug
3
comment How to SELECT all points within a GeoJSON polygon in PostGIS
Thanks a lot. ST_Intersects works also.
Aug
3
comment How to SELECT all points within a GeoJSON polygon in PostGIS
I have it as a JSON object.
Aug
3
asked How to SELECT all points within a GeoJSON polygon in PostGIS
Jul
31
comment Indexing PostGIS table by tile boundaries
No, I don't know what that means.
Jul
31
asked Indexing PostGIS table by tile boundaries
Jul
21
accepted Adding additional geometry column in PostGIS
Jul
21
comment Adding additional geometry column in PostGIS
I'm adding data to postgis with shp2psql and table is created when piped through psql. So I can't really add a trigger before table exists?
Jul
21
comment Adding additional geometry column in PostGIS
Thanks for a great answer. It's real neat to use triggers, I will start doing so. Could I add that trigger to the database instead, so that i dont have to add this trigger for every new table?
Jul
19
accepted PostGIS Best Practices with thousands of entries
Jul
18
comment Adding additional geometry column in PostGIS
Thanks for your answer. Is there any way to do this on already existing tables (ie. without using staging tables)? Let's say I already have a table, with a geom column, and I simply want to add another the_geom_webmercator column. How would I do that?
Jul
18
revised Adding additional geometry column in PostGIS
added 4 characters in body