2,545 reputation
516
bio website
location
age
visits member for 2 years, 8 months
seen 7 hours ago

2d
awarded  Popular Question
Nov
19
comment Software for amateur topographic surveys
Have you tested QGIS ?
Nov
18
comment Computing intersections for each geometry in a table
Used SQL server and query would be nice and create table query and create index code
Nov
12
comment Counting self intersections of linestring using PostGIS?
ST_IsValidReason probably helps, example documentation shows only one error per geometry so maybe you need to run it in recursive loop . see postgis.net/docs/manual-dev/ST_IsValidReason.html
Oct
14
reviewed Reject suggested edit on Would you consider online geocoding a breach of privacy?
Oct
9
comment (When) should I use a GIS-enabled database?
I would like to add that spatial reference system handling is also very good feature in PostGIS, far as i know MySQL and MSSQL spatial dont do that in database. Also if plan is to display data using WMS/WFS etc. using geoserver and/or Openlayers it will be much easier to visualise data from spatial database than relational.
Oct
1
reviewed Approve suggested edit on Using OpenLayers' Refresh strategy for GeoJSON
Sep
30
comment How to compute the smallest network that connects all points using PostGIS?
i not sure that i understand question but does docs.pgrouting.org/2.0/en/src/tsp/doc/index.html#pgr-tsp Traveling Sales Person algorithm help you ?
Sep
19
comment Finding areas with high POINT density from PostGIS table using Python
1. depends. Which distance function you use and how you store data in database (geography or geometry. If you use suitable srid for data for your local area it is "accurate" 2. depends. what srid you use (if you are using geometry type) or do you use geography. if 4236 for geometry then its decimal degrees, it may be feets or meters, if geography then those are decimal degrees
Sep
12
comment Shapefile to Network xml
did you try to use that pgrouting 2.0 manual ? it works for data that has linestrings and start/end points are in tolerance
Sep
11
comment Projecting Data with Transformations - Alignment Issue
try convert all data to srid:900973 or 3857
Sep
9
answered How to perform SQL query using .STContains in MS SQL Server
Sep
3
comment Query to find all lines connected to other
in PostGIs there is st_startpoint and st_endpoint, so where st_endpoint(blue_line) = st_startpoint(green_line) AND ... other combinations of end and startpoints. This usable for use case s ehre you try to create noded network table
Aug
20
comment Problem measuring area with gps coordinates
see proj4js (proj4 lib).
Aug
19
awarded  Constituent
Aug
18
awarded  Caucus
Jul
11
comment Maintaining times with points2one in QGIS?
have you considered postgis ?
Jul
11
comment Postgis create polygon extent/convex hull from spatial table
CREATE OR REPLACE VIEW AS SELECT 1 as gid, ST_ConvexHULL(st_Collect(geom))::geometry(POLYGON,4326) as geom FROM xxx should do the job
Jul
4
comment Transform wkb to gml geometry using FME
now you need to select GML writer in FME and write data to there.
Jul
3
answered Transform wkb to gml geometry using FME