Reputation
18,065
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 43 82
Newest
 qgis
Impact
~607k people reached

2h
comment How do I convert WGS84 to Lat, Long to Google Maps in R?
According to your previous question, the correct SRS is EPSG:2263. Get the correct PROJ.4 string there, and it should work.
1d
comment How to accelerate my python looping process for A-star path finding on DEM surface?
See a few answers on SO: A-star search in numpy or python and Elegant grid search in python/numpy
1d
comment Find Overlap Between Two Polygons
@MinhMai you can also see "spatial predicates" for the DE-9IM to understand the language
1d
answered ST_Dwithin Source Code
1d
revised Difference in destination location between pyproj and geopy
edited body
1d
revised Difference in destination location between pyproj and geopy
link source, and improve query
Jul
26
comment PostGIS: Invalid Input Syntax for Type Double Precision
you might have left out part of the error message; was it invalid input syntax for type double precision: ""? If so, you need to filter these out with WHERE lng <> '' AND lat <> ''.
Jul
26
answered Fuzzy least-coarse common partition algorithm
Jul
22
revised Difference in destination location between pyproj and geopy
added 790 characters in body
Jul
22
answered Difference in destination location between pyproj and geopy
Jul
21
revised Adding additional geometry column in PostGIS
added 146 characters in body
Jul
21
comment Adding additional geometry column in PostGIS
If you are using shp2pgsql, use an update statement, see above. A trigger is useful if you need to maintain a table, but not for loading.
Jul
21
revised Adding additional geometry column in PostGIS
show update statement
Jul
21
answered different calculation results
Jul
20
revised Adding additional geometry column in PostGIS
edited tags
Jul
20
answered Adding additional geometry column in PostGIS
Jul
20
comment Is it possible to perform spatial join in PostGIS and keep all features?
You can also use a LEFT JOIN to keep all the records from one of the tables. An OUTER JOIN keeps both tables.
Jul
19
comment Where can I find a binary ogr_FileGDB.dll compilled for Windows?
If you are OK using the development version, currenlty GDAL 2.1, which has a OpenFileGDB driver see gisinternals.com/development.php
Jul
19
comment How to create dynamic leader lines?
@LunarSea I reworked a second example that has one table and one view. The table has trigger functions to determine a default value for the label_geom, and also updates the quadrant value too, so the point_label layer/view is no longer needed.
Jul
19
revised How to create dynamic leader lines?
added 1193 characters in body