Timeline for Querying PostgreSQL with GIS to get GeoJSON for GeoJSON tile layer?
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 15, 2019 at 9:19 | history | edited | PolyGeo♦ | CC BY-SA 4.0 |
deleted 32 characters in body; edited title
|
| Apr 13, 2015 at 14:46 | answer | added | elrobis | timeline score: 1 | |
| Apr 10, 2015 at 20:55 | comment | added | elrobis |
hmm.. one thing that might work.. I'm just spit-balling here. But you could write a script to iterate over the levels/tiles in your area of interest and build a sort of lookup table containing the gid values for the features you wanted represented in every potential tile position {z}{x}{y}. The goal of the script would be to keep track of all the features in your dataset for every zoom level and allocate them to the {x}{y} ranges they fell into, and then DENY them from neighbor ranges if they've been previously allocated. (Plus, I think the lookup would be stupid-fast.)
|
|
| Apr 10, 2015 at 20:48 | comment | added | elrobis | Welcome to the community. One thing I wonder--neighboring tile areas will certainly have some shared polygons. So unless you don't mind duplicating their transfer over the wire and their subsequent rendering in your map, you'll want a strategy for dealing with the redundancy. If you give the polys some fill opacity, you should see the duplicated features as being darker than the non-duplicated features. ..unfortunately I don't have any good advice for how to handle that issue. I always do one big map-area select and just deal with it. haha | |
| Nov 18, 2014 at 21:31 | answer | added | Ash Catchem | timeline score: 1 | |
| Sep 2, 2014 at 10:02 | history | edited | Nighthawk | CC BY-SA 3.0 |
added 87 characters in body
|
| Sep 2, 2014 at 9:51 | history | asked | Nighthawk | CC BY-SA 3.0 |