Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [spatial-view]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
49
votes
4answers
32k views

Making spatial view in PostGIS and adding it as layer in QGIS?

In PostGIS 2.0, I am seeking an efficient way to create a spatially enabled view that is viewable in QGIS. I followed the context of Part 2 of @Mike Toews answer to How to create a table from ...
1
vote
2answers
1k views

How to make a Spatialite View (with geometries) for QGIS based on two table

There are several posts (1), 2)) and manuals to create a spatial view within a Spatialite Database and to work with it in QGIS. The important thing is to register the view in geometry_columns table: ...
7
votes
1answer
595 views

Get ArcMap to recognize ST_POINT (SDE.ST_GEOMETRY)

I have a sde.st_geometry line feature class called ROADS. I've created a view using a st_geometry function called st_startpoint which returns an st_point column. st_point is a subclass of st_geometry; ...
4
votes
1answer
477 views

How to set posgis default sequential value in a QGIS “editable” view?

Introduction In a QGIS project I have a VIEW, that I want to became editable (I'm trying to replicate the versioning system used DB Manager with some tweeks). Therefore I created a few rules to ...
1
vote
0answers
102 views

Is there a limitation in quantity of joined tables using spatialite views?

I've one point layer in qgis and several non spatial tables in a spatialite database. Now I want to create a view as you can see in the following: CREATE VIEW testansicht10 AS SELECT baumkataster....