meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 3 months |
| seen | 4 hours ago | |
| stats | profile views | 22 |
|
1d |
comment |
How to speed up query through view in postgis? Thank a lot! The new query takes just 336ms on my table. Could you explain the difference between my query and yours so that the speed was so improved, or point me to a source where I can read that? Thanks. |
|
1d |
accepted | How to speed up query through view in postgis? |
|
2d |
asked | How to speed up query through view in postgis? |
|
May 16 |
awarded | Popular Question |
|
Apr 23 |
revised |
Connnect to PostGIS db using QGIS - when not on localhost added 2 characters in body |
|
Apr 23 |
answered | Connnect to PostGIS db using QGIS - when not on localhost |
|
Apr 16 |
accepted | How to split line layer at polygons' boundary of a polygon layer? |
|
Apr 16 |
comment |
How to split line layer at polygons' boundary of a polygon layer? It works (with line layer named 'line' and geometry column named 'line', polygon layer named 'poly' and geometry column named 'polygon'). Thanks! |
|
Apr 16 |
awarded | Caucus |
|
Apr 3 |
answered | No Postgis after installing opengeo suite |
|
Apr 3 |
comment |
No Postgis after installing opengeo suite @jdeolive: your terminal command generated an error: bash: syntax error near unexpected token `('. I tried this command: psql -U opengeo medford -c"select postgis_version();" and it runs fine. |
|
Apr 3 |
comment |
How to split line layer at polygons' boundary of a polygon layer? Are "line" and "polygon" geometry columns in their layer? I've found that ST_UNION() is very slow on my polygon layer. Can you modify the query so that "line" will difference with st_union of "lines_in_polygons"? I think the result will be much faster. As I am new to PostGIS and databases in general, please bear with me. Thank you very much! |
|
Apr 1 |
asked | How to split line layer at polygons' boundary of a polygon layer? |
|
Apr 1 |
comment |
How to label each polygon in a layer? @johnsankey: for new qgis user, I think underdark's blog - anitagraser.com - or this page - qgis.spatialthoughts.com - have valuable infomation. P.S: as your problem is solved, you should write an answer for your question above and accept it so this question can be close. |
|
Apr 1 |
comment |
How to label each polygon in a layer? @johnsankey: To make multi line label, select your layer, go to Menu -> Labeling, put a check next to 'Label this layer with', click the '...' button on the same line and enter formatted string in the Expression box - with '\n' where you want to make a new line. Eg: for your example above, enter the following string and you'll see the effect: 'id: ' || "id" || '\nname: ' || "name" - you can read more here: nathanw.net/2011/10/27/expression-based-labeling |
|
Apr 1 |
comment |
How to label each polygon in a layer? @johnsankey: you should label layers with the tool I suggested because the other way (double click layer, go to tab Labels) is going to be deleted soon by the Qgis Steering Members - so I've heard. |
|
Apr 1 |
comment |
How to label each polygon in a layer? Could you post a screen shot of your layer's attribute table: select the layer - which is 'coop' in your case - in the Layers panel on the left, then select the menu Layer -> Open Attribute Table? I want to check if the buildings' name are in there. |
|
Mar 30 |
comment |
How to label each polygon in a layer? To label the polygons, you may use the labeling tool (menu Layer -> Labeling), put a check next to 'Label this layer with' and select the attribute you want to put in the label (it might be a 'name' column in your example). If you need help styling the polygons of different types in different colors and opacity, first you must explicitly tell what each color and opacity means (at least for the 'townhouse' entry in your legend). |
|
Mar 27 |
comment |
about intersection function of QGIS If you want to add nodes into lines at their intersections, you can open the Sextante Toolbox, then use 'GRASS commands -> Vector -> v.clean' select Cleaning tool: break. Just remember to set the 'GRASS region extent', normally I would use 'Select extent on canvas' and draw a rectangle over the area I want to process. |
|
Mar 23 |
accepted | Is there a simple automated way (plugin preferred) to split all lines in a layer at their vertices? |
