Questions tagged [view]

Views are a feature provided by SQL that allow you to store the result of a query, and query it as if it were a table

Filter by
Sorted by
Tagged with
0
votes
1answer
31 views

Filter same Value Map to show specific values in different columns in QGIS

I am using QGIS 3.12.2 on Windows 10. I have created one large table layer to use as a ValueMap for multiple columns in a project. I need each column to show only the relevant values. I have tried to ...
0
votes
0answers
33 views

Geometry loss/mix up of a spatialite view joining two tables

I have two Spatialite tables: - Sites (with geometry column) (ca. 5000 single sites) - Samples (ca. 6800 samples) To display the samples in QGIS I want to create a spatial view showing all samples at ...
1
vote
0answers
35 views

How to split attribute field of a view in ArcGIS Enterprise Portal

I am working with a view in ArcGIS Enterprise Portal. This view contains combined information about the same asset, for example, pipelines. Some of the information has been combined into a single ...
0
votes
0answers
15 views

Map Service: How is the shape column in an XY event layer different from a shape column in a registered view?

I have a non-spatial table with XY columns in an Oracle 18c/10.7.1 geodatabase. With that table, I'm able to create a registered view with a shape column (based on the XY via the st_geometry function)...
0
votes
2answers
49 views

Creating a view in ArcCatalog - ORA-01722 [closed]

I'm creating a view in ArcCatalog 10.6 on an Oracle DB. Never created a view before but with some Googling, I've managed the SQL below. The view works but only partially. In ArcCatalog, preview shows ...
1
vote
2answers
94 views

Layer from PostGIS view with dissolve slower than without in GeoServer

I created a view of a table containing line segments, where many lines may be part of the same project (and not necessarily adjacent) in PostgresSQL/PostGIS. The segments are joined to another table ...
0
votes
0answers
29 views

Getting SQL explain-plan for ArcGIS Map service

My organization has an ArcGIS map service that contains registered views from an Oracle 18c/10.7.1 geodatabse. I'm having some performance issues with the layers/views in the map service. I want to ...
1
vote
0answers
32 views

Spatialite queries not loading entirely on canvas

I connected a SQLite database to my QGIS project. I wrote a query in the DB manager whose result contains 261 elements. Then, I tried to load the result on the canvas (from the load button at the ...
0
votes
1answer
183 views

Publish WFS from PostGIS SQL view [closed]

I am trying to create a public WFS service with GeoServer from a PostGIS SQL view, but this does not load in QGIS. If I publish from a PostGIS table the WFS service is loaded normally. Is it possible ...
1
vote
1answer
123 views

“Error 999999: Error executing function - Attribute conversion error” when running RegisterWithGeodatabase

I am using ArcPy to run through all of the spatial views in an enterprise GDB, register them with the GDB, and assign domains to the registered view. It runs great for most of the views in the GDB, ...
2
votes
1answer
46 views

Creating a table view using SQL?

I'm trying to create a table view using SQL to join a table and a feature class together. When I try to create the view, I get an error saying there is an incorrect syntax near the keyword 'CREATE'. I'...
3
votes
0answers
53 views

Registered view gets buggy when database link added [closed]

I have a view in an Oracle 12c geodatabse: create or replace view parcel_vw as ( select p.* from parcel p left join for_gis.gis_locations@gistomax loc --<-- Join to database link ...
0
votes
1answer
14 views

Converted timezone does not display properly in ArcMap

(Oracle 12c geodatabase) I have a view that converts a UTC timestamp to Eastern Time using the from_tz function: create or replace view test_vw as ( select cast(rownum as number(38,0)) as ...
0
votes
1answer
105 views

Register view with geodatabase fails (view selects table from different user)

I have two users/schemas in an Oracle 18c geodatabase (10.7.1): USER_A USER_B Scenario 1: I can create a view in USER_A: SELECT * FROM USER_A.TEST_TBL. I am able to successfully register the ...
0
votes
2answers
224 views

AGOL View layer symbology is not updated when updating hosted feature layer

I have a feature layer called map in AGOL. I want to change the symbology, so I open arcgis Pro and I open this map and overwrite it with new symbols. I see that the feature layer in AGOL is updated ...
2
votes
1answer
184 views

Fit view to ImageStatic size

In OpenLayer 5, i've a long rectangular SVG image (like 7000x600 px) as main layer. I need to limit the view and pan only to its bounds. I tried the code below, but when zooming the layer can't panned ...
0
votes
0answers
215 views

Multiple OL views for single OL Map instance

I need to show multiple views of the same OpenLayer Map instance. Each view would have a different extent, but display the same layers visible on the Map instance. Is that possible? It's important to ...
2
votes
1answer
235 views

Create view table with QGIS and Geopackage

Working with QGIS 3.4.9 and Geopackage. I created a View table. The command runs without errors, the view is created but does not appear in QGIS. What do I need to do?
1
vote
3answers
1k views

PostgreSQL/PostGIS error “pseudo-type record”

I've got, in PostgreSQL/PostGIS, create table datos ( gbifID int primary key, orden varchar (50), eventDate varchar (50), geom geometry); When I run select distinct (geom,eventdate), geom from ...
0
votes
1answer
83 views

How to filter a csvLayer based on attributes?

Ill start out by just explaining what I'm trying to achieve. I'm running an arcgis application based on the javascript API. I'm Rendering a CSVLayer into my SceneView like such: require(["esri/Map", ...
2
votes
0answers
90 views

QGIS 3 crashes when adding a PostGIS view as a map layer?

I am trying to load a PostGIS view public.view1 into QGIS (3.6) as follows (per Add PostGIS layer to QGIS via Python Console): tablename = "view1" geometrycol = "geom" from qgis.core import ...
2
votes
1answer
134 views

Creating Spatial View … GIS/SQL

I have created an enterprise geodatabase in my local instance of SQL Server and I want to create one select statement of multiple select statements within multiple tables and feed this into a view. ...
0
votes
0answers
79 views

How do I create a view across a server using postgres_fdw?

My understanding is that you can query across servers if you use postgres_fdw. I have set this connection up successfully following the official documentation. However, I am struggling to construct ...
1
vote
1answer
324 views

PostGIS view on multiple geometry columns

I have two PostGIS tables, ‘filelinks’ and ‘maricopa_plss_qtrqtrs’. The filelinks table has a geometry type column named ‘geom_p’ and the maricopa_plss_qtrqtrs has a geometry type column named ‘geom’. ...
2
votes
1answer
48 views

How to hide certain views from ArcCatalog?

I have users that connect to an enterprise geodatabase via OS authentication. They use a couple of methods: An .SDE connection in ArcMap A ODBC connection for MS Office The users need to be able to ...
0
votes
1answer
370 views

Altering SQL View GeoServer from application

I am making an application and I want to access a lot of weather data. Now I want to use the SQL View option to let the WMS layer know which timestamp to use and then it shows me all the data from ...
1
vote
0answers
50 views

QGIS Web View doesn't show up picture correctly

As a part of my graduation project, im working in data system that can show up features about a railway inspection. One of the features are images that show up failures. These images are from URL ...
1
vote
0answers
106 views

PostgreSQL Views with geometry on QGIS

Not entirely sure what kind of rules does QGIS need to consume SQL views So I've had some success in using an id column and a geometry column but now that I'm doing something a bit more complex, it's ...
0
votes
1answer
355 views

Create Database View with ST_Within Query

I see several other questions similar but none that apply directly to mine. I am using ArcGIS Desktop 10.6.1 with SQL Server running my Enterprise Geodatabase. I have a very large point feature ...
0
votes
1answer
546 views

Edit a view of a PostGIS table in QGIS

I have a simple layer in PostGIS created as follows: CREATE TABLE layer ( id serial PRIMARY KEY, geom geometry(LINESTRING, 31370), ... ) To avoid duplicate information, I created a view ...
0
votes
2answers
215 views

GeoServer WFS viewParams for complex features

In GeoServer, I installed an app-schema linked to a PostGIS database. When I call the layer via the WFS GetFeature I have an INSPIRE compliant GML file that looks like (small portion of the GML): <...
1
vote
1answer
48 views

How do I create a view in Postgres?

I have two layers. Layer one is a multipolygon layer (can be split to single polygons if needed). Layer two contains points, lines and polygons. Using layer one, I want to spatially filter layer ...
8
votes
1answer
313 views

Creating SpatiaLite view (for use in QGIS) from non-spatial SQLite database?

I have a plain SQLite database that contains X, Y coordinates in a table. Data are edited via an MS Access front-end using the ODBC driver and so I want to avoid storing them in a geometry blob that ...
3
votes
0answers
307 views

Problem with insert into PostGIS view table via QGIS

I use a PostgreSQL 9.5.14 (PostGIS) and QGIS 2.18.7. The problem is that when I try to add a new object to the View via a QGIS, the following error occurs: ERROR: column "geom" is of type ...
3
votes
1answer
71 views

QGIS “ERROR” written in all fields in attribute table of a View coming from PostgreSQL/PostGIS

I have a table of around 800000 records with POINT geometry in PostgreSQL/PostGIS. When I directly open the table in QGIS, the attribute table opens fine and the fields are populated. But when I open ...
0
votes
1answer
100 views

Create a materialized view with buffer zone from point layer [closed]

I would like to create a process on PostGIS where users can create a point on a working layer ("working_point_layer") close to a reference point layer ("ref_point_layer"). As I can't set the ...
1
vote
0answers
98 views

ArcGIS feature layer built of SQL View not visible

I am building a custom web app using the ArcGIS JS 4.8 API with an ArcGIS Web service and I have run into an issue. The root cause that I am trying to fix is to do with features not being filtered ...
1
vote
2answers
436 views

Creating View using spatial queries in PostGIS?

I am trying to create a view from a selection. One layer contains indian states boundary as polygon and other world forest fire as points. CREATE VIEW myview AS SELECT * FROM ...
0
votes
1answer
114 views

How to update a buffer view with values from another table?

So basically there's a buffer view defined by: CREATE OR REPLACE VIEW niceview2 AS select 'test'::text AS route_type, st_setsrid(st_union(st_buffer(a.geom, 25::double precision)), 27700) AS geom ...
2
votes
0answers
249 views

Not able to pass the parameters to SQL view in GeoServer

I created a sqlview(villagefilter_view) in GeoServer and added one parameter %vilselected% select * from niphad_survey where village=%vilselected% Name: vilselected Default value: 'Ranwad' ...
1
vote
1answer
186 views

set map center to specific layer GeoExt 3.1.0

Using GeoExt 3.1.0, OpenLayers 4.4.1 and ExtJS 6.2.0. I'm trying to make my first GIS web app and I am stuck trying to get the map to load with one of my layers in the center. While researching I was ...
1
vote
1answer
6k views

creating a view of multiple tables using Postgresql

This might be the stupidest question for postgresql user. Please do understand that i just started to use postgresql. what i am trying to do is joining 3 tables using same key field (which is ...
5
votes
2answers
614 views

Create a view based on table with GeometryCollection column for use in QGIS

I have a table with a geometry collection (polygon and point). QGIS can not read the geometry collection, so I want to create a view for the polygon type and the point type. My SQL function for the ...
2
votes
1answer
362 views

Spatialite Spatial Views doesn't display in QGIS

I have views stored in a spatialite database accessed via QGIS. The views were created by another person on a different computer. The geometry column is well registered in the table ...
4
votes
1answer
317 views

Can not add features to layers created from PostgreSQL's Updateable Views in QGIS

I can not insert on an updateable view with QGIS, CREATE TABLE foo ( id serial PRIMARY KEY, mytext text, geom geometry(point) ); CREATE VIEW bar AS TABLE foo; When I map bar as a layer and try ...
2
votes
1answer
636 views

How do I load layers defined by PostGIS views in QGIS 2.18? [duplicate]

I have a layer that is defined by a complex SQL query. It works fine but I would like to move that complexity out of QGIS and into the data base so I can access it from elsewhere (GeoServer). I ...
2
votes
1answer
336 views

QGIS v2.18.9 layer visibility

When I add a new layer to a QGIS project it is often not visible in the viewing pane, although it is visible in the side Layers Panel. I would like to make the layer visible and have tried to use the ...
1
vote
1answer
334 views

Saving QGIS view extent in Shapefile or other exchange format?

I want to know how its possible to save the actual view of the map. It would be great to open it in QGIS or other GIS software the last saved view is showing when the file is opened. How can I load ...
1
vote
0answers
140 views

How to call a stored pgsql function from Geoserver?

I created a stored function in PostgreSQL : myfunction(a text, b integer). I want to create an SQL View in Geoserver using this query : Select * from myfunction('%nom%', %likes%). My problem is that ...
1
vote
1answer
41 views

Create many Layers and data views with arcpy

This code I've created works for 1 (one) active layer and for 1 (one) field. I need to implement this code for many layers and fields in a open .mxd file. I have 11 fields (years 2003 to 2015). I ...