Skip to main content

Questions tagged [sql-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
2 votes
0 answers
53 views

Calculating risk factors for waste management system using SQL database

I am working on a waste management system where I need to prioritize actions based on risk factors associated with different types of waste, including industrial and sewage waste. The system utilizes ...
user240504's user avatar
0 votes
1 answer
105 views

Register a view in ArcGIS returns error 999999

I have created a view in an enterprise geodatabase (SQL Server) using arcpy.management.CreateDatabaseView. It shows correctly in ArcMap, and now I want to register it properly. I have done this many ...
Berend's user avatar
  • 4,737
2 votes
0 answers
61 views

PostgreSQL 'UNION ALL' statement in a view does not load in QGIS

I have two datasets, sharing the same attributes (but being distinct from each other), each in their PostGIS table. The tables are huge (both geometrical and containing ~1 billion features) and have ...
Laurens's user avatar
  • 71
1 vote
1 answer
170 views

QGIS can not read float from SQL view [closed]

Geometry points from the SQL view view_monitoring with columns from table table_campaign, table_instrument etc. are shown in a QGIS-project. It works fine as long as no column of type float is ...
stonebe's user avatar
  • 447
0 votes
1 answer
35 views

ArcGIS Desktop with Database Connections: Can not display coordinates from a view if aliases are used

The view Locations_View created in Microsoft SQL Server Management Studio is accessible in an ArcGIS Desktop project by Database Connections. Its numerical fields PT_XCOOR and PT_YCOOR are usable in ...
stonebe's user avatar
  • 447
1 vote
1 answer
121 views

Geoserver java.IOExceptionInvalid value for parameter (possible utf-8 issue)

i m trying to query a view using parameters in Greek SELECT [OBJECTID] ,[Shape] ,[SubStore] ,[StoreCode] ,[subStore] FROM [****].[dbo].[GSRV_POLYGONS] where [StoreCode]>='%StoreCodemin%' ...
sotokan80's user avatar
1 vote
2 answers
534 views

Create view and display in QGIS of a spatial table in geopackage or SpatiaLite

I need to create 4 views of a spatial table in a geopackage or SpatiaLite (no preference at the moment). I tried with geopackage, but the view is displayed as a datatable and not displayed as a layer ...
ThiPa's user avatar
  • 649
1 vote
2 answers
121 views

Optimizing PostGIS view including counts with attribute join

I try to create a PostGIS view in which I want the number of features having an attribute date < 3 years from current date, and the total number of features, to be able to display a pie chart in ...
Jérémie's user avatar
  • 103
1 vote
0 answers
211 views

How to get the geometry and SRID in SQL View GeoServer REST API? [closed]

I am trying the create the GeoServer SQL View using GeoServer REST API. Here is my XML configuration file, layer_xml = """<featureType> <name>{0}</name> ...
Tek Kshetri's user avatar
0 votes
0 answers
100 views

Creating Multiple Feature Classes as Views on Standalone Table in ArcGIS Pro .NET SDK

I'm developing an ArcGIS Pro 2.9 plugin using the .NET SDK. I have a set of data that contains fields describing points and ellipses to display on the map. I would like to create two FeatureClass ...
Steve's user avatar
  • 101
0 votes
0 answers
316 views

GeoServer and PostgreSQL materialized views

I use PostgreSQL10+ PostGIS + pgbouncer and GeoServer 2.18 Linux Ubuntu.The PostgreSQL store is the "traditional" one, not JNDI. The database has materialized views which data I successfuly ...
krav's user avatar
  • 41
-4 votes
1 answer
375 views

How to select geometry column to use in Create Database View tool in ArcGIS Pro?

I have a geodatabase locally and when I try to do simple query using Create Database View like: SELECT Name, sum(Area) as Areaa, Shape FROM houses GROUP BY Name, Shape,Area it returns that the ...
TurnGISon's user avatar
2 votes
2 answers
879 views

Displaying SQL Server View (not table) on QGIS 3.18

I have an SQL Server database connected to QGIS 3.18. I am able to add tables including geography data type to the map without a problem. However, I want to be able to add a 'View' (Orn_View_spatial) ...
acasaly's user avatar
  • 83
7 votes
1 answer
690 views

Create a parametrized SQL view based layer using geo.Geoserver Python API

I created "by hand" (using GeoServer HTML configuration interface) a layer based on the following SQL view: SELECT p1.suid, p1.id, p1.geometry, p1.classname, p2.date, COALESCE(p2.percentage, ...
Mauro Assis's user avatar
2 votes
2 answers
198 views

View has no records when viewed in ArcCatalog

I have created a database view in an Oracle-backed Enterprise Geodatabase. I can see data in both of them when I view them using SQL Developer. However, when I look at the view in ArcCatalog (version ...
Fezter's user avatar
  • 21.9k
0 votes
1 answer
527 views

Does QGIS perform better when using a materialized view or a standard view from PostGIS [closed]

My PostGIS views in QGIS are significantly slower then other standard PostGIS tables and I have struggled to enhance their performance any good amount. If using materialized views in QGIS would I ...
AWGIS's user avatar
  • 3,230
0 votes
0 answers
66 views

Wrong vector selected mouse-clicking on computed layer

[qGIS 3.10.14] Only on computed layer such as virtual or spatialite view: When simply clicking in canvas (or using any other gui/spatial selection method) to select particular feature(s), what gets ...
feldmrob's user avatar
0 votes
0 answers
477 views

pgAdmin 4: create view without defining schema

I have a database containing the official cadastral surveying of hundreds of counties. For every county I have created a new schema named state_zipcode_countyname. As all my db entries have the same ...
cymed's user avatar
  • 155
2 votes
1 answer
627 views

Widget Expand is not functioning correctly

I have placed 2 widgets (baseMapGallery, LayerList) inside a small map in a rather large popup. To keep it from crowding out the view, I am trying to use an Expand to launch it from a small icon ...
gwydion93's user avatar
  • 1,903
2 votes
0 answers
56 views

Having trouble viewing DEM in 3D view

I am trying to view my DEM of terrain for a project in the 3D viewfinder, but having some difficulty. I can see it as flat terrain, but when I turn on DEM for the interpolation it disappears in the ...
Nick 's user avatar
  • 21
0 votes
0 answers
176 views

Materialized view breaks when registered with the GDB

EGDB: Oracle 18c/10.7.1 External system: Oracle 12c I have created a non-spatial materialized view in an EGDB that syncs data from an external system (on a 5 second schedule; via a dblink). It is ...
User1974's user avatar
  • 1,132
3 votes
0 answers
274 views

Tables and view not visible in QGIS 3.10.2

Using QGIS 3.10.2 I created a geopackage DB with 2 geographic layers and some tables, later on I edited the same geopackage with the DB Browser for SQLite 3.12 and created a View, add another table ...
nanunga's user avatar
  • 533
0 votes
2 answers
71 views

Sync changes from view to feature class (using a GP tool; without fully replacing the data)

I have an ST_GEOMETRY view with 50,000 rows (in an Oracle 18c/10.7.1 geodatabase). The view references a WORKORDER table in an external system (via a dblink/Oracle 12c). Problem: The view is too slow ...
User1974's user avatar
  • 1,132
0 votes
0 answers
711 views

Creating database view in ArcMap

I have the following issue when using the Create Database View tool in ArcMap. My query runs fine in Microsoft SSMS and Visual Code (with mssql extension) against the enterprise geodatabase. But for ...
Beniamin Stoica-Fuchs's user avatar
0 votes
1 answer
124 views

Update table view Error in QGIS

When trying to make changes to a PostgreSQL view I get the following errors. Can someone advise how to get this working? I'm not familiar with triggers.
Chris Jenner's user avatar
0 votes
1 answer
75 views

Shader is not working correctly / set(material.[]) is buggy

Concider this first Example: My CGA File: const dryWallCol = "Walltexture1/Drywall4.png" Lot --> primitiveCube(20,20,20) ...
AMNOFFICIAL's user avatar
0 votes
1 answer
461 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 ...
Mahmoud Abdelrazek's user avatar
0 votes
0 answers
130 views

Geometry loss/mix up of 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 ...
Matthias's user avatar
1 vote
0 answers
74 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 ...
Lindsy Hales Bentley's user avatar
0 votes
2 answers
89 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 ...
Steve's user avatar
  • 773
1 vote
2 answers
292 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 ...
JasonBK's user avatar
  • 610
1 vote
0 answers
41 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 ...
Yvanou's user avatar
  • 81
0 votes
1 answer
592 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 ...
Javier Aguilar's user avatar
0 votes
1 answer
1k 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, ...
avstjohn's user avatar
3 votes
1 answer
786 views

Creating a table view using SQL? [closed]

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'...
Mark1994's user avatar
3 votes
0 answers
106 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 ...
User1974's user avatar
  • 1,132
0 votes
1 answer
67 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 rownum_, ...
User1974's user avatar
  • 1,132
0 votes
1 answer
677 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 ...
User1974's user avatar
  • 1,132
1 vote
2 answers
2k 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 ...
jamlego's user avatar
  • 73
2 votes
1 answer
1k 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 ...
Exp's user avatar
  • 33
1 vote
1 answer
2k 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 ...
Jared Holmberg's user avatar
4 votes
2 answers
2k 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?
Denilson's user avatar
  • 695
2 votes
3 answers
13k 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 ...
jpinilla's user avatar
  • 3,230
0 votes
1 answer
263 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", ...
Purple Samosa's user avatar
2 votes
0 answers
143 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 ...
tinlyx's user avatar
  • 11.1k
2 votes
1 answer
568 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. ...
Diego Gonzalez's user avatar
1 vote
1 answer
751 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’. ...
Rudy Stricklan's user avatar
2 votes
1 answer
74 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 ...
User1974's user avatar
  • 1,132
2 votes
1 answer
1k 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 ...
Trisha's user avatar
  • 125
1 vote
0 answers
88 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 ...
Emanuel Murillo's user avatar