680 reputation
59
bio website pacofvf.com
location Mexico City, Mexico
age
visits member for 3 years, 1 month
seen Dec 4 at 1:16

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
Apr
24
answered Unable to install the PostGIS extension to PostgreSQL on Ubuntu 12.04 LTS
Apr
8
comment What format is lat/long stored in OSM PostGIS?
The lat/lon aren't multiplied by 10, they are in a different projection it is supposed to be EPSG:3857.