2,575 reputation
516
bio website
location
age
visits member for 2 years, 9 months
seen Dec 22 at 14:22

Dec
22
revised MapInfo, SQL data from multiple tab files which have the same columns
added 476 characters in body
Dec
22
answered MapInfo, SQL data from multiple tab files which have the same columns
Dec
2
comment Attributes in Excel and FME
Are you aware that dbf file can be opened with excel (shp comes with shp , dbf and .prj files) ?
Dec
2
answered Creating new lines from existing lines based on points lying along the lines
Nov
26
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 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 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