10,804 reputation
3163
bio website burhum.com
location San Francisco, CA
age
visits member for 3 years, 6 months
seen 22 hours ago

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
14
comment Working with temporary files in ArcObjects using Geodatabases?
If memory serves me right, the InMemoryWorkspace will switch internally to a ScratchWorkspace once it hits a threshold of certain amount of features and then rearrange its internal references to make it transparent. So you are then really interacting with a ScratchWorkspace, you just do not know it. I don't remember if I added code for that or not, but I think I did... or maybe it was the ArcGIS Server folks when they were implementing disconnected editing, but I think that is how it works.
Oct
14
comment One dimensional map of the world?
No no, there are so many cities that it seems to be a straight continuos line, but it is not :)
Oct
13
comment Why do we need Mapserver/Geoserver to present data from spatial database to web browser?
How would you style your data otherwise? (I got about 30+ questions like this that I can give you )
Oct
13
answered getsubcurve from multipart polyline ArcGIS
Oct
13
comment How to maintain integrity between changing street network and geocoded points?
@MWrenn is right. A split can be treated as either an update+Insert or a Delete+Insert+Insert of features (with unique ids). An easy solution would be to, for every point, save the geocoded string + the edge that it was matched to. The cases where the point touches the edge with the same id can be assumed to be correct (hoping that the geometry of that edge has not changed that drastically), while the edges that dont match anymore need to be thrown back to the same geocoding process again.
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.