11,172 reputation
3264
bio website burhum.com
location San Francisco, CA
age
visits member for 3 years, 8 months
seen 8 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
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
Oct
5
comment How to avoid Google map geocode limit?
OK. Php then. This bit from the Google Documentation should include the mysql and php part code.google.com/apis/maps/articles/phpsqlgeocode.html
Oct
5
comment How to call a DLL file from VBA?
Mike's answer is correct. The ESRI object browser will only show you objects that are registered in the right component category (did it come with a separate reg file???)Kirk's remark is very valid, too. You could be dealing with a pre-9 dll and it would not work since the object libraries got refactored for 9.0 My question to you is why are you trying to do this. If it is to create Thiessen polygons, this equivalent to driving from LA to Vegas, with a minor bathroom stop in Taiwan.
Oct
5
comment How to avoid Google map geocode limit?
Also, you will need to give more context about how the marker data gets into your system in the first place
Oct
5
comment How to avoid Google map geocode limit?
What is your backend CMS? (I assume you can/know how change it and just want a simple example that shows how to do that in your language of choice. You don't need an example of a client side js, or do you? Are you using any js framework like jquery?
Oct
5
comment How to obfuscate data when using Google Maps?
+1 for Fusion Tables
Oct
5
answered How to avoid Google map geocode limit?
Oct
5
revised When Versioning with ArcSDE can posted edits be cancelled or rejected?
edited tags