Questions tagged [spatial-database]

Spatial database is a database that is optimized to store and query data that is related to objects in space, including points, lines and polygons.

Filter by
Sorted by
Tagged with
-1
votes
0answers
9 views

Oracle Spatial and Graph deployment architectures [closed]

I'd like to understand the deployment architectures that Oracle Spatial and Graph. I know that the Oracle Exadata Database Machine is deployed in a shared-disk architecture. I'd like to know the ...
0
votes
0answers
26 views

Spatial indexing of GeoTIFF images (Java Library)

I have a requirement to spatially index each pixel of GeoTIFF images and store them in a scalable database. I intend to perform this in the following manner. Divide each GeoTIFF into smaller tile ...
1
vote
1answer
76 views

GIS Database format selection (SpatiaLite, GeoPackage, PostGIS) - QGIS users [closed]

We are a small team (10 p) working on spatial planning. We are using QGIS as a main tool. We have a lot of open source data, we daily use on multiple projects, and therefore some files are duplicated ...
-1
votes
1answer
80 views

How can I insert a satellite image with multiple bands into PostGIS?

I am trying to insert a satellite image (e.g. a Sentinel Image) into PostGIS. What is the best structure to save the different bands? I know that you can use somehow use 'ST_AddBand' or 'ST_Band', but ...
0
votes
0answers
17 views

How to display BLOB value image at specific point with maptips

I am trying to display a photo loaded as a BLOB value inside a SQLite database using maptips. I have searched all over the forums, but no question seems to quite answer my problem. Basically, I have ...
0
votes
0answers
107 views

Connecting to Cloud SQL database in Colab runtime

I am very new to GCS and Cloud SQL, so forgive me if I am not asking this question well. A colleague and I have been working on a machine learning workflow that generates polygons from some ...
0
votes
0answers
31 views

Convert raster into array within a PostGIS database

I need to convert a raster (e.g. GeoTIFF format) into an array (it can be any kind of array e.g. numpy array). So far I managed to do that in a python script (as they describe it at this page https://...
0
votes
0answers
20 views

Maintaining Form Designs with one Geopackage to Multiple Different Projects

Long time reader, first time poster. I work for an Archaeological consulting company in Australia and one of the major parts of our job is to go out and survey for aboriginal heritage sites before ...
0
votes
0answers
41 views

Sharing QGIS Project that connects to local postGIS database

I am looking to share a QGIS project with a few others outside my network. The QGIS project is using layers from a postGIS database I created locally. I am wondering what the best way is to go about ...
2
votes
1answer
27 views

Converting points with an associated circumference to a raster overlay

I have a data frame in r with x and y coordinates and each point has a circumference (tree_crown) around it. I'm wanting to build a raster file that each cell would have a value equal to the percent ...
2
votes
1answer
65 views

Creating one-to-one relationships in QGIS

Can I create one-to-one relationship using project relations in QGIS? I am trying to create a spatial database in QGIS. I want to link my attribute data to my spatial data (shapefile). I have already ...
0
votes
0answers
51 views

Linking or joining data in MS Acess to shapefiles in QGIS

I am creating a spatial database for five buildings for a project that I am working on. I have spatial data in the form of a shapefile and attribute data in Microsoft Access(with a table and queries). ...
0
votes
0answers
42 views

Connecting to an SQLite database selected from a combobox

I selected a database from a combobox. And I want to connect to it so that I can create tables in it using PyQt. I think I should use the currentIndex, but I can't figure out how to do it. I saw that ...
0
votes
1answer
98 views

Problem with clob data type when running ogr2ogr command

Using ogr2ogr, I transferred data from the oracle database to the postgres database. However, the table "table" contains attributes that have a "clob" as a data type, which were not created. Is there ...
0
votes
1answer
140 views

Import OS Mastermap to PostgreSQL database

I have ordnance survey master map a coverage for the whole of the UK. These are currently received on a disk every 3 months and arrive in .gz format. Does anyone have any recommendations on how to ...
1
vote
1answer
72 views

Two persons working on same layer in QGIS

We are two people who need to work on the same layer in QGIS. For example one of us will work locally, the other one via a server connection. What do we need to keep in mind when it comes to data ...
2
votes
1answer
39 views

Create a new connection in QGIS 3.4.3 DB Manager

I am trying to establish a new database connection from QGIS 3.4.3 to Postgres/PostGIS. I have two connections established but I can't find any options to establish another connection. I cannot recall ...
0
votes
0answers
7 views

Can't initialize topology in Autodesk Industry Model 2017

Im facing difficulty trying to initiate my Industry model topology, i always get the error of cannot write _tisl with sql loader, i tried to clean the lines but no luck, i dont know what to do im ...
1
vote
1answer
48 views

Exracting data fromSpatialPolygonDataFrame conditionally in R?

For some research I am working on, I have a dataframe called charters of charter schools in New Jersey. Simplified it looks like this: school.name school.id district.id lat ...
1
vote
1answer
37 views

Store and observe changes of polygons through time?

What approach should be used to have the ability to store and observe changes of polygons? For example if you have an area where many parcels of land have changed owners and dimensions (larger/...
-2
votes
1answer
72 views

Local coordinates in NoSql database

Is there any nosql database which supports the below 1) Should support local coordinates (spatial data which holds the coordinatesof door, Infra, etc.) 2)Integration with Geoserver.
1
vote
1answer
29 views

Find every possible user to user travel time duration using pgr_dijkstra or pgr_kDijkstra

I have this below GetNearest function that will get every user's nearest node from ways (imported using osm2pgrouting). CREATE or REPLACE FUNCTION GetNearest(NUMERIC, NUMERIC) RETURNS BIGINT AS ...
2
votes
1answer
31 views

Find gaps in spatial database based on attributes and fill those caps with new features with existing attributes

I have a big line shapefile data (over 2 millions features) showing animal movements. Simplified example: ID    Year    st_time     end_time&...
1
vote
2answers
1k views

Visualize geographic spatial data from SQL Server directly in PowerBI

Is it possible to directly query geographic spatial data form SQL Server in PowerBI like its possible with Tableau? https://cloudblogs.microsoft.com/sqlserver/2018/05/14/visualize-geographic-spatial-...
0
votes
1answer
149 views

password authentication failed for user “ASUS”

I'm creating table in PostgreSQL using these commands: shp2pgsql -s 32632 watershed.shp watershed > watershed.sql psql -f watershed.sql cambridge psql -f watershed.sql cambridge But I had ...
2
votes
0answers
782 views

DBeaver spatial output window: Is it possible to sync/filter spatial query to map bounds?

While upgrading PostGRES/PostGIS from 9.x to 11.x, I have discovered DBeaver and so far I am pleased. Apparently it has some spatial integration, including the ability to visualize spatial data ...
2
votes
0answers
318 views

Can relation reference in QGIS and QField be used to fill stochastic matrices?

I am a novice GIS user and am just seeing the potential for relations in my work. A problem I've come across and would like a solution to it. I have two stochastic matrices (risk matrices) that ...
0
votes
1answer
58 views

SQL layer wont ORDER BY in CARTO VL

I have a dataset that shows the borehole yield for fractured aquifers in South Africa. Using the "yield_ls" column, my CARTO VL legend looks like this (notice how the 4th item should be the first). ...
0
votes
2answers
117 views

Clarification on Oracle sdo_gtype

I need some clarification on oracle sdo_gtype 4402. I understand that sdo_gtype is codded as DLTT. D: Dimension L : linear reference T T: TT identifies the geometry type. It's clear to me that first 4 ...
4
votes
1answer
247 views

Accessing PostGIS data in QGIS?

I've created a two new PostgreSQL users; one that is supposed to have read-only privileges and another one that should have most privileges (admin-user). When I connect/log in to the new users in QGIS ...
1
vote
0answers
736 views

GeoDjango application using SpatiaLite database

I want to create a simple GeoDjango app with SpatiaLite database but I have this error at migrate: django.core.exceptions.ImproperlyConfigured: Unable to load the SpatiaLite library extensio`. ...
0
votes
1answer
63 views

Extracting and transposing a single record in db manager

This seems like a simple operation so apologies if I've missed an existing answer. What I need to do is extract single record (a client) from a database of clients (in Spatialite) and present the ...
1
vote
0answers
221 views

What's the most size-efficient spatial database [closed]

I'm configuring a tile server on Apache Mesos. From all the tutorials I've read, I gathered that PostgreSQL and PostGIS is widely used for this purpose. I learned that MongoDb and MySQL Server also ...
1
vote
2answers
388 views

PostgreSQL - only allow points to be added to the table (no polygons or lines)

I want to know if there is a way to only allow certain Geometry types to be added to a table in PostgreSQL. I have a tool that currently allows points, lines and polygons but would like to restrict ...
2
votes
2answers
2k views

Using SqlGeometry.MakeValid to get a counter-clockwise polygon in SQL Server

The data I've loaded from a shapefile into a geometry column in SQL Server (using NetTopologySuite) is not producing valid GeoJSON when I export it because it doesn't follow the right-hand rule. I ...
4
votes
0answers
2k views

When does WKT orientation matter for polygon and multipolygon in geography spatial (left/right hand rule, counter-clockwise, clockwise)

I've decide to use sql server on Azure for my gis database. I'll be dealing with spatial Geography not Geometry. While inserting some country boundaries using the spatial data in SQL Server, some ...
2
votes
1answer
212 views

How to extract values from multiple rasters and polygons for given coordinates

I have roughly 30 predictor variables in raster and two polygon shapefiles format that I am trying to extract values from for a given response variable coordinates. I have already done the following:...
0
votes
2answers
341 views

Copying raster to SQLite using GDAL?

I want to copy a raster file into SQLite database. Previously, I did the same with vector data like this: def store_vector_output(self, file_name, identifier): from osgeo import ogr drv = ogr....
1
vote
1answer
487 views

Nearest point on line from a point in PostGIS and its attribute value

Consider the following image; I have points (shown in blue circles) stored in my database with their geometry and an attribute value. Additionally, I have another table with User Points (yellow ...
13
votes
1answer
277 views

Is the ST_ prefix appropriate for functions not included in SQL/MM Part 3?

I was reading a thread on the geospatial extension for Presto in this Github issue, where a function, line_locate_point, was introduced. It was based off PostGIS's ST_LineLocatePoint function, which ...
0
votes
2answers
95 views

Add column to show intersection with another layer

I have a table containing a list of properties. I have a successful query to return only those that intersect another layer. However i want to return all the properties now and instead return a new ...
0
votes
1answer
972 views

MySQL GPS distance calculation is failing

MySQL 5.6 here. I'm storing GPS coordinates as MySQL Point types in my DB and am trying to build a query that takes a single GPS coordinate (consisting of latitude and longitude components) and ...
1
vote
1answer
551 views

Export spatial data from SQL Server to ESRI shapefile using OSGeo

i did a join between 2 tables departements2 which has all department with their id and geometry with BM_REGIONFR with id of department and region ( i have 5 region in each region many departement ) ...
1
vote
0answers
86 views

Layer length statistics in print composer QGIS

In a QGIS composer, I would like to add a text label with the calculation of % of length of the total layer with a specific feature value. My layer is composed of roads lines and I would like to ...
3
votes
1answer
876 views

Saving styles for all layers using PyQGIS - SLD, QML, databases

I wrote a script (for QGIS 3) that saves styles for all visible vector layers in QML and SLD files: import processing self=qgis.utils layers = self.iface.mapCanvas().layers() for layer in layers: ...
0
votes
1answer
53 views

At what point is the R-tree created?

Whats going on: I am working with postGIS and spatial datas. I am having trouble to fully understand the R-tree algorithm. Example query: In which town is point P located? My understanding so far ...
1
vote
0answers
190 views

How to Unregister Replicas that have an invalid data-set information using ARCGIS REST APIs Version(10.2.1)

I am writing an application which will UnRegister replicas that are currently available. I managed to unregester new replicas which have the latest Server Url address stored in the DATASET_INFO field, ...
2
votes
1answer
403 views

Optimize intersection of polygons

I need to get the intersection of two polygons and both sides use the same dataset (titlenumberpolygon - UK National polygons). PostGIS is used in the analysis. First a spatial index was created ...
1
vote
2answers
148 views

Styles embedded in Spatialite database are lost while copying database

I have created a Spatialite database with several layers. I have customised the style for each layer and have saved the style as the default style in the database. All works fine when I connect to ...
2
votes
1answer
284 views

Merging multilane road into one lane

I have a road network file (openstreetmap exported file) that has various types of edges (freeway, highway, primary, residential, service, ...). Some of these edges have multiple lanes (parallel), so ...

1
2 3 4 5
10