2,535 reputation
515
bio website
location
age
visits member for 2 years, 7 months
seen yesterday

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
Jul
3
comment Transform wkb to gml geometry using FME
is WKB as WKB in SQL or as geometry, if geometry just add sql spatial reader and it just works. Or if it is as WKB use STGeomFromWKB (assuming 2008 r2+ version of ms sql) to convert it to geometry and use normal sql spatial reader
Jun
26
comment Generating a routing database for the entire world while keeping the tags
i recommend to modify postgresql.conf to have bigger memory limits after installation
Jun
26
comment ST_buffer display creates big circle
or you can use geography type instead of geometry , see postgis.net/docs/manual-2.1/ST_Buffer.html .
Jun
26
comment ST_buffer display creates big circle
as it should, well technically results is polygon (area)