Reputation
220
Top tag
Next privilege 250 Rep.
View close votes
Badges
3 11
Newest
 Yearling
Impact
~8k people reached

45m
comment Indexing PostGIS table by tile boundaries
No, I don't know what that means.
7h
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
Jul
18
asked Adding additional geometry column in PostGIS
Jul
14
comment How to import ECW into my postgis database with raster2pgsql (windows)
check out docker builds of postgis, there are some great ones with massive format support.
Jul
14
revised Keeping Properties When Converting JSON to SHP
input output was switched
Jul
14
suggested approved edit on Keeping Properties When Converting JSON to SHP
Jul
3
comment Add PostGIS spatial functions to a custom schema other than “public” in PostgreSQL
How do you add data to another schema, ie. not public? Adding data with eg. shp2psql to test.table still puts data in public?
Jul
1
comment PostGIS Best Practices with thousands of entries
Just want to add that each file doesn't yield just one row in the table - it can yield > 1M rows (huge files).
Jul
1
revised PostGIS Best Practices with thousands of entries
added 94 characters in body
Jul
1
revised PostGIS Best Practices with thousands of entries
added 80 characters in body
Jul
1
comment PostGIS Best Practices with thousands of entries
@underdark The data is different - it has different columns. They all have a geom column, but otherwise different.
Jun
30
comment PostGIS Best Practices with thousands of entries
Thanks. I edited it down to one question only, I don't know if someone will "unhold" it for me. Personally I don't understand why it's so important to close down questions five minutes after they've been asked, even if they are a bit broad. I'm part of this community also, and I sincerely need answers to this question, and this is the best forum for it.
Jun
30
revised PostGIS Best Practices with thousands of entries
simplified question to ONE specific
Jun
29
asked PostGIS Best Practices with thousands of entries