meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | 41 | |
| visits | member for | 1 year, 3 months |
| seen | 12 hours ago | |
| stats | profile views | 15 |
GIS Manager for a civil engineering firm -- Currently doing most of my work with QGIS, postGIS, spatiaLite. Working to bring GIS to smalltown, USA.
|
Apr 16 |
comment |
How to save a joined spatialite table when each table contains PKUID fields? QGIS should load the view just like a table if you use the composer or otherwise INSERT the appropriate info into views_geometry_columns. Typically, for materializing views I create the view and make sure it's right, then I create a table with the same schema and use an INSERT statement with SELECT * FROM the_view. |
|
Apr 15 |
comment |
How to save a joined spatialite table when each table contains PKUID fields? @user12711 It is indeed a view, but QGIS will load it just fine. If you need to edit the related data, then triggers can handle that. If I remember correctly, the Spatialite GUI version 1.6 or higher View Composer will write the triggers for you. One caveat, you may need to create any new databases with version 1.5 or lower, as QGIS 1.8 chokes on any database I create with the latest SpatiaLite GUI. Hope that helps. If you absolutely need to create a new table, that can be done, but it's a longer answer. |
|
Apr 15 |
comment |
How to save a joined spatialite table when each table contains PKUID fields? @user12711 Answered above. |
|
Apr 15 |
revised |
How to save a joined spatialite table when each table contains PKUID fields? added 473 characters in body |
|
Apr 13 |
answered | How to save a joined spatialite table when each table contains PKUID fields? |
|
Mar 31 |
comment |
Leaflet offline tiles problem If I remember correctly, leave out the $ symbols. |
|
Mar 20 |
comment |
What's the best way to run a visibility analysis in PostGIS 2? I made the same assumption. Another assumption here is that the distances are short enough to ignore the whole geometry vs. geography great circle issue. |
|
Mar 20 |
answered | What's the best way to run a visibility analysis in PostGIS 2? |
|
Mar 20 |
comment |
What's the best way to run a visibility analysis in PostGIS 2? Is this a 2D analysis? |
|
Mar 13 |
answered | Bounded box on postgis |
|
Mar 13 |
answered | PostGIS ST_Contains question |
|
Mar 8 |
comment |
PostGIS Union Between Two Tables, Preserving Attributes Note that Centroid function does not guarantee a point that lies within the polygon. ST_PointOnSurface does. |
|
Mar 8 |
answered | PostGIS Union Between Two Tables, Preserving Attributes |
|
Mar 5 |
comment |
Contours: Interrupt contour lines beneath a elevation number Would you accept an answer that requires PostGIS? |
|
Feb 27 |
comment |
Contours: Interrupt contour lines beneath a elevation number @MAP - Sponsor a developer, or submit a feature request and wait on the benevolence of others. :) |
|
Feb 26 |
comment |
Contours: Interrupt contour lines beneath a elevation number @MAP A knockout erases the pixels beneath it. If that were an option, in this case you would choose to knockout the contour layer. |
|
Feb 25 |
comment |
Contours: Interrupt contour lines beneath a elevation number I never thought of it before, but it would be convenient if instead of assigning a color for the buffer, you could choose to apply it as a 'knockout' to selected layers. |
|
Feb 25 |
answered | Contours: Interrupt contour lines beneath a elevation number |
|
Feb 15 |
comment |
PostGIS spacial data type to represent geo-located polygons Yes, as long as the spatial meta data is correct. And the coord order is always x,y. Sorry if I goofed it. |
|
Feb 15 |
revised |
PostGIS spacial data type to represent geo-located polygons Response to comment |
