The tag has no wiki summary.

learn more… | top users | synonyms

20
votes
3answers
6k views

How to make a spatial view in PostGIS and add it as a layer in QGIS?

In PostGIS 2.0, what is the most 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 this question, and the view ...
4
votes
2answers
1k views

Publish SQL Views from Postgres/Postgis to Geoserver

I've trying and reading how to publish a Postgres/Postgis View in Geoserver. I know that I can create an SQL View in Geoserver, but I'd like to define the View in Postgres, not in Geoserver. Does ...
2
votes
1answer
397 views

How to load a postgres view using pyQgis?

Under Qgis 1.8 on Windows 7 I have this problem with my pyArchInit plugin: I need to load on the map canvas my geometries from a postgis layer. Till the 1.7.4 version I use the method explained on the ...
2
votes
0answers
24 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 ...
2
votes
0answers
464 views

View in ArcSDE 10.1 Problem

I have created a view by joining a feature layer and 2-3 other tables in ArcSDE database using help from James Richard Post. The view gets created fine in both SQL Server 2008 and also in SDE. In ...
1
vote
2answers
936 views

How do you create and use a SQL Server spatial view in ArcMap?

All, (using SQL Server 2012, ArcMap 10.1) I have created a SQL spatial statement to test out how a) the union function works, and b) how creating a view of this data will work with ArcGIS. a) the ...
1
vote
1answer
222 views

Can one edit an ArcSDE Oracle spatial view?

By 'edit' I mean edit the geometry in the feature class, not any attributes in the joined table. Unversioned. I really had it in my head that you can, as long as the objectid column is included in ...
1
vote
1answer
569 views

Quantum GIS returns “Invalid Layer” message when trying to add Postgis view

I'm new to Postgis and Quantum GIS. I created a view defined as CREATE OR REPLACE VIEW pupr.vstudentmuni AS SELECT m.id AS munid, m.name AS muname, m.geom, s.code, (s.name::text || ' '::text) ...
1
vote
0answers
71 views

How to create a spatial view when allowing multiple selection in qgis’s edit widget “value relation”?

I've a point layer in qgis and serveral non spatial tables in a spatialite database. In qgis the fields were filled using the edit widget "value relation" (multiple selection allowed for some fields). ...
0
votes
2answers
88 views

ArcSDE 10.1 Spatial View with no records

I can create a spatial view and it renders fine in catalog and ags. But if i modify the sql OR if a situation arises that makes my view devoid of records then all of the sudden sde and ags get really ...
0
votes
1answer
93 views

Publish relationalship data from arcsde

I have feature classes and tables having relationship shored in them.(Feature classes has id as which is primary key in other table ). I want to publish the Feature class as a service on arcgis ...
0
votes
0answers
47 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 ...
0
votes
1answer
129 views

Is there any way to view maps in “perspective” with ArcGIS (ArcMap do not)?

I need to work with ArcGis by the amount of data that I use and the answers I need, but would like to see my maps in perspective and I can't find a way. Does anyone knows how to do it?