The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
174 views

Not able to register spatial view with sde

I am using 10.2 ArcGIS and SOL Server 2008 R2. I have created a cross database spatial view in sql server using following syntax: USE [pipelines] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON ...
0
votes
0answers
71 views

Load Data to Oracle View (ArcCatalog)

Is it possible to load data from a shapefile to an Oracle 11g R2 view (without ArcSDE) in ArcMap 10.2 using ArcCatalog? The shapefile (polygons) was imported from that view, and then edited, but when ...
0
votes
2answers
176 views

Adding Oracle Spatial View as Layer in QGIS?

Is it possible to add an Oracle Spatial View on QGIS MAP? My view is registered on MDSYS metadata but, when I connect with Oracle DB, it is disabled on the list. QGIS Desktop 2.2.0 Oracle Database ...
0
votes
0answers
119 views

Geoserver SQL View layer not displaying on map

I am trying to create a SQL View in GeoServer from my SQL Server 2008 R2 data store. It is a very basic query: SELECT [Id] ,[Location] FROM [schema_name].[table_name] I set the Id column, ...
2
votes
0answers
81 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
139 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
0answers
65 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
2answers
112 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 ...
1
vote
2answers
2k 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
320 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 ...
0
votes
1answer
187 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?
2
votes
1answer
984 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) ...
4
votes
2answers
2k 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
0answers
510 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 ...
0
votes
1answer
98 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 ...
2
votes
1answer
503 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 ...
26
votes
3answers
8k 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 ...