meta user
network profile
| bio | website | burhum.com |
|---|---|---|
| location | San Francisco, CA | |
| age | ||
| visits | member for | 2 years, 3 months |
| seen | yesterday | |
| stats | profile views | 679 |
Geo Architect.
Co-Founder of AmigoCloud (Mobile GIS Data Collection Apps).
LinkedIn: http://www.linkedin.com/in/rburhum
Previously at ESRI, Microsoft and others.
|
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 |
|
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 |
