11,302 reputation
3666
bio website burhum.com
location San Francisco, CA
age
visits member for 3 years, 10 months
seen Dec 15 at 21:47

Geo Architect.

Co-Founder of AmigoCloud (Mobile GIS Data Collection Apps).

LinkedIn: http://www.linkedin.com/in/rburhum

Twitter: @rburhum

Blog: http://blog.burhum.com

Previously at ESRI, Microsoft and others.


Oct
13
comment How to find nearest neighbors between two tables with point locations in SpatiaLite?
@Radek the pure knngist solution is also faster than anything currently on PostGIS. Is as portable as postgres... so you are right that mobile would not be included. You would need to modify spatialite itself in a very non-trivial way to achieve something remotely similar.
Oct
13
comment Does google maps use elevation to calculate travel distance?
Clearly you guys do not live in SF
Oct
13
comment How to find nearest neighbors between two tables with point locations in SpatiaLite?
actually faster than GRASS, ArcGIS, QGIS, SQLServer and pretty much any other spatial db/Desktop GIS (have not tried Oracle nearest neighbour functionality though).Just let me know if it is an option.
Oct
13
comment How to find nearest neighbors between two tables with point locations in SpatiaLite?
I can give you an approach that is several orders of magnitude faster, but it would require you to use postgresql 9 knngist index instead of spatialite...
Oct
12
comment How do you navigate the ArcObjects OMDS?
Navigate through the co-classes. If you like an interface, find your way back to the co-class, rinse, repeat :)
Oct
12
comment Options for displaying PostGIS rasters in OpenLayers
Yes you can load it directly to openlayers from st_aspng, but it will require extra work. You then have to keep track of the bbox, and specificy it when you load it dev.openlayers.org/apidocs/files/OpenLayers/Layer/Image-js.html Trust me, it is the long route. You are better off letting geoserver or mapserver do this. They give you back WMS/WMTS and you use two lines of code to add it to openlayers.
Oct
12
revised Rename postGIS table and updating the GeoServer?
added example for update statement
Oct
12
comment Rename postGIS table and updating the GeoServer?
Look at the implementation from probe_geometry_columns trac.osgeo.org/postgis/changeset/7548 It is going through every single table in the db, finding if the schema has the string "geometrytype" and inserting a new record if the required entry does not exist in geometry_columns. Nevertheless, orphan records are left as they are. So why not just do: UPDATE geometry_columns SET f_table_name = 'new_table_name' where f_table_name = 'old_table_name'
Oct
12
comment One dimensional map of the world?
No no, the 1D paper is completely full already. It has one line on it!
Oct
11
comment How to avoid Google map geocode limit?
@Mapperz I have been trying to tell him to do exactly that, but he is not listening :)
Oct
11
answered Rename postGIS table and updating the GeoServer?
Oct
11
comment One dimensional map of the world?
draw a line in latitude 0 from - 180 to 180. Pick the cities that you want and snap them to the line. Or just use my awesome 1D map above!
Oct
11
answered One dimensional map of the world?
Oct
10
comment How to maintain integrity between changing street network and geocoded points?
"Topological integrity" is a very broad term, and I am curious as to exactly what you mean by it. Do you want the nodes that you geocoded to be part of the street edges? Because using parcel-level geocoding with corrections can easily put the geocoded points on some part of the parcels and still be "topologically correct"
Oct
10
comment Options for displaying PostGIS rasters in OpenLayers
@celenius Mapserver and GeoServer will both allow you to do that.
Oct
10
comment Options for displaying PostGIS rasters in OpenLayers
Mapserver is definitely a great alternative from GeoServer (I use it for some other projects). Generally, I pick geoserver for my customers because it has an easy to use interface. Nevertheless, I wanted to point out that serving tile caches is serving static content, and any solution based on nginx (or any other non-blocking server) would be far faster than any apache solution - in either process-based isolation or threaded mode.
Oct
10
revised Options for displaying PostGIS rasters in OpenLayers
added link to rasters
Oct
10
answered Options for displaying PostGIS rasters in OpenLayers
Oct
7
answered How to script shapefile editing with open source tools?
Oct
5
comment How to avoid Google map geocode limit?
For the javascript portion, I assume you know how to create a web service, so the call would use something like this api.jquery.com/jQuery.ajax of whatever you decide to do. Going into more details about how to write a web service or ajax call to a webservice is really outside of the scope of this forum