Reputation
720
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
5 10
Newest
 Nice Answer
Impact
~35k people reached

  • 0 posts edited
  • 0 helpful flags
  • 10 votes cast
Jul
28
awarded  Nice Answer
Jul
8
comment How do I get the distance meter value between two geometries in PostGIS?
The maximum distance would be earth_radius - minimum_distance, which would be traveling the opposite way. (heading + 180º)
Nov
18
awarded  Yearling
Nov
11
comment How to export a postgis table to a pbf file?
thanks, this command osmosis --read-pgsql --write-pbf does the trick( many parameters are missing, leaving this for future reference : Osmosis: Detailed Usage ).
Nov
11
accepted How to export a postgis table to a pbf file?
Oct
29
revised How to export a postgis table to a pbf file?
edited title
Oct
29
asked How to export a postgis table to a pbf file?
Oct
16
comment one label for two-lane roads (osm, qgis, postgis)
I've nicknamed labels table as "a" and "b", and label_id column(osm_id) as label_id_1 and label_id_2 with the "AS" statement, I had to because in the deepest subquery we have two columns(label_id) and two tables(labels) with the same name.
Oct
10
answered one label for two-lane roads (osm, qgis, postgis)
Sep
23
comment How to calculate the intersection between WFS layer and a PostGIS table
here are all the GDAL binaries , choose the appropriate OS and arch. Also here is a guide to manage packages with YUM.
Sep
21
awarded  Notable Question
Sep
17
answered How to calculate the intersection between WFS layer and a PostGIS table
Jan
21
awarded  Necromancer
Nov
18
awarded  Yearling
Oct
24
answered Plotting multiple addresses with distance to specific POI
Oct
24
comment How to get polygon coordinates for Google Map from .poly files (preferably in nodejs)?
you need to know the projection, do you know where is this? I mean in WGS84, (aka WGS 1984, EPSG:4326), use the share function from google maps to know the coordinates (they are in WGS84).
Aug
6
awarded  Popular Question
Aug
5
comment Large buffers in PostGIS (5000 km radius)
Since ST_buffer only has that problem with geographies, theoretically you could transform(cast) everything to geometry and do all the operations that you want, and then transform back to geography when you are done.
Jul
25
answered Google maps on iOS - query string to achieve what I need
Jun
28
answered Looking for a web service for change detection