Tag Info

New answers tagged

0

Here's one ESRI plugin for "weighted voronoi diagrams". @martinf pointed me in the right direction. An ArcGIS Extension for Generating and Updating Ordinary and Multiplicatively Weighted Voronoi Diagrams for Points, Lines, and Polygons Unfortunately I don't have access to ArcGIS, so this particular solution isn't much good to me. It's still useful to see ...


2

Loading 20GB of data, either from disk or over the web, will kill almost every desktop application. You have to restrict the data volume to the rendered canvas extent, e.g. using virtual index files or a postgis server with spatial indices, and use overviews (pyramids) for lower zoom levels to get reasonable fast results on the screen.


1

You could get the geometry by joining your query result's id2/edge with your layers's geometry ID (gid): SELECT s.seq, s.node, s.edge, s.cost, b.gid, b.geom FROM ( SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_dijkstra(' SELECT gid AS id, source::integer, target::integer, ...


1

Following the 2nd example from ST_MakeLine, you could join the nodes from your routing output, to nodes representing a Postgis point, and use this to create a line, something like: SELECT ST_MakeLine(gm.the_geom ORDER BY rt.seq) As route_geom FROM route rt inner join geometry gm on rt.node = gm.node ; where route is the output from pgRouting and geometry ...


0

Hey also had the same problem figured out these two options, either place cdb.vis.Vis.addInfowindow(map, layer.getSubLayer(0), ['name']); in place of: sublayer.infowindow.set('template', $('#infowindow_template').html()); Or Use cartodb.createLayer(map, {'http://documentation.cartodb.com/api/v2/viz/2b13c956-e7c1-11e2-806b-5404a6a683d5/viz.json'}); ...


0

When you are writing your SQL query after importing the USA dataset (as Javier referenced above), be sure to select 1) "the_geom", 2) "the_geom_webmercator", and 3) "cartodb_id". See my code underneath: SELECT ne_50m_admin_1_states.the_geom, ne_50m_admin_1_states.the_geom_webmercator, ne_50m_admin_1_states.cartodb_id FROM ne_50m_admin_1_states WHERE ...


0

I encourage you to import a USA states dataset where it is placed in the common data section (http://{{ yourusername }}.cartodb.com/dashboard/common_data/Administrative%20regions). Then, you can remove all the polygons or states you don't need and only leave Alaska. Hope it helps you! Cheers, Javier Á.


2

Many thanks to @jakub for pointing me on the right track. I'm posting the Python code snippet that I used in case it helps anyone. I looped through each borehole to find the XY coordinates, then looped through the soil readings to create 0.5m deep segments. One tip is that it (seems to be) necessary to offset one of the vertices by a small amount to avoid ...


3

It is possible to turn borehole logs (XYZ points) into 3D polylines. I wrote a sript a few years ago that did just that but it was with ArcObjects. Each group of points had a unique value and I just looped and constructed 3D lines using the points as ToPoint and FromPoint and assigned soil type attribute to each line. Once complete I symbolized on soil type ...



Top 50 recent answers are included