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.
464
questions
0
votes
2
answers
581
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 ...
0
votes
1
answer
473
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 ...
0
votes
2
answers
829
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
1
answer
48
views
Save Layer Styles to a Database
I would like to save my layer styles to a database and the "only" option given is "As Default in Local Database". After some searching, I see the local database is named qgis....
0
votes
1
answer
368
views
Extract nearest values from NetCDF file in Python
I have a NetCDF database (link to file) obtained from Copernicus Climate Data of ~43k unevenly spaced values around the world. Instead of being indexed using (lat, lon) it uses a sequence of 'stations'...
1
vote
2
answers
556
views
Spatial query in PostgreSQL to find a route to a specific point?
I drew 2 shapefiles - point.shp and line.shp. Line.shp has some lines intersecting points in point.shp. I converted the shapefile to PostgreSQL, but how can I make a spatial query to select a line ...
8
votes
2
answers
7k
views
QGIS supported databases?
Does anyone know if there is some kind of documentation on which database types that you can connect to in QGIS? I would also like to know if:
Can I use the databases for read only or read & write....
9
votes
5
answers
538
views
Another Student in Need of Career Advice
I would like to apologize in advance for asking yet another "what should I do with my life" type of question.
I am currently a senior who is very close to finishing up my B.S. in Information ...
1
vote
0
answers
63
views
Connecting QGIS to SQL server -- not showing sde
I have problem with seeing/making connection to spatial data on SQL Server with QGIS while I can normally see it (on the same SQL Server) with ArcMap.
I should use the same user and password for both ...
7
votes
3
answers
9k
views
Adding PostgreSQL database to web map [closed]
I am interested in learning how to add a PostgreSQL database to a web map so I can do functions like select by attributes or locations. I am using Leaflet API to make the web map.
What are the ...
3
votes
2
answers
3k
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`.
...
1
vote
0
answers
320
views
Best way to work with large vector data files [closed]
I am about to start making 50+ maps for my next book project. The last 2 books were a struggle with the huge amount of Ontario, Canada vector data to make my basemaps.
These were large files from the ...
5
votes
4
answers
2k
views
Global solar radiation data
I need a solar radiation data in central Asia. Is there any global dataset of solar radiation?
If someone know about it, please send to me the link.
6
votes
3
answers
1k
views
Prevent export to shapefile from PostGIS table in QGIS
I have created a centralized database using PostgreSQL and created multiple users assigned with different roles i.e. SELECT, UPDATE, MODIFY and DELETE etc.
Example:
CREATE USER hasan WITH PASSWORD '...
0
votes
1
answer
56
views
tmap + labels colors don't match the data
I created the following map. However, the labels in the legend don't match the data. I don't understand what goes wrong. I expected the pal colors to be ordered with the labels. So would do the data.
...
0
votes
2
answers
376
views
Plot polygon's attribute on R
I have created a settlement plan on ArcGIS Pro, on which every polygon corresponds to a specific room in the settlement. All the polygons/rooms have some features (E.g. Fire Place, Bench etc.). I have ...
10
votes
1
answer
3k
views
Seeking tools for uploading GIS data to database
I would like a nice graphical tool that allows me to take standard GIS data such as shapefiles and KML files and upload them to a database such as PostGIS, MySQL or Oracle.
Are there any such tools?
12
votes
4
answers
8k
views
Embedded spatial database for Java?
Are there any embedded spatial databases for Java? I've come across H2 Spatial, but it was difficult to tell the status of that and if it can be used as an embedded spatial database.
13
votes
4
answers
4k
views
What is a good taxonomy or naming convention for files and folders containing GIS data? [closed]
My company has collected about 30 TBs of GIS data over the past 8 years, and I always find myself asking the following questions:
What type of data do we have for a given geographic area?
What are ...
0
votes
1
answer
68
views
returning id's from spatial query
I am doing a spatial query to see if water sensors exist or not in a database. If so I want to return the unique identifier # that exists on the ones in the database so I can match it to the ones ...
1
vote
1
answer
7k
views
Calculate centroid of a point cluster
Having this function that inserts locations in a database:
def insertLocation(cur, label, point):
print label
cur.execute("""
SELECT label, centroid, point_cluster
...
3
votes
2
answers
2k
views
Oracle spatial - check polygon vertices counter clockwise
I need to import a huge number of polygons from a third party (as a csv file- array of x,y's). I have to check whether the polygon vertices are in clockwise or counter clockwise, finally i have to ...
0
votes
0
answers
557
views
Spatial indexes with RTree for polygons
I am trying to understand about how R-tree works for polygon data. In other words, polygon is a list of vertices (points), however, I am wondering how spatial index can recognize the order of points ...
0
votes
0
answers
129
views
Maintaining Form Designs with one Geopackage to Multiple Different Projects
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 constructions can be approved. The ...
3
votes
2
answers
1k
views
How to use a list with spatial dataframes in a for loop? - R
I have three spatial dataframes (polygons), created via this tutorial. The three spatial dataframes must be exported as shapefiles via a for loop. I created a list polygons containing the three ...
2
votes
2
answers
3k
views
DatabaseError: Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY type
I am using Django 1.3, PostGIS 2.0 , Postgresql 9.0 and GeoDjango.
I had a database with a table for places. This table had latitude and longitude for places in the US. I enabled this database with ...
5
votes
1
answer
627
views
Adding Timestamp to attribute table in QGIS
I have the project where, in one part of it, I need to add the timestamp to uniform generated points along the line (road, in my project). There is a road and uniform distributed points on it, which ...
1
vote
2
answers
290
views
Create one PostGIS connection in QGIS with multiple databases from one host?
I have a number of spatial databases each containing multiple schemas on one server,
I want to use QGIS to examine layers,
Is it possible to create one PostGIS connection in QGIS and add all databases ...
0
votes
0
answers
65
views
Transferring/inheriting GIS database structure in PostGIS from old project to new one
I have been given an existing GIS database design for a solar power project, with its structure, relationships, geometry etc designed from another project and existing in PostGIS database. I am ...
1
vote
0
answers
541
views
QGIS is not displaying geometry features for MySQL table
I'm currently working in a MySQL database version 5.7. I've a polygon table that was created using the following way:
CREATE TABLE coords(
ref_geo CHAR(80) NOT NULL,
geom GEOMETRY NOT NULL
);
I ...
1
vote
0
answers
1k
views
Route tracking on Google map PHP
I have to make a software that tracks a vehicle on Google maps using GPS. I have almost done this project but am stuck at a point. The client requires a system that tracks the bus in a route. I am ...
7
votes
2
answers
2k
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:
...
4
votes
1
answer
68
views
Appending characters before the filename of all layers in a GeoPackage in QGIS?
I have a geopackage which contains around 30 files. I want to put a "mmbl_" before the actual file name for all the layers in the said geopackage. Is there a an SQL expression to automate ...
0
votes
0
answers
49
views
What geospatial table and indexing functions are suitable for a borehole database design for large volume of serialised constant increment data?
Pretty common use case I suspect, but want to make sure I optimise from the get go. PostGIS I'm suspecting is the weapon of choice, and one way I'll be interrogating data is QGIS. Large part of data ...
3
votes
1
answer
1k
views
How to open QGIS project without being asked for PostGIS credentials every time
Problem:
We have several layers stored in a PostgreSQL database with PostGIS extension (Stored on AWS RDS Instance). The connection has been working perfectly to date.
I get asked for login ...
0
votes
1
answer
161
views
How to run ESRI CreateEnterpriseGeodatabase python script
I am trying to run the Python script posted by ESRI for generating an enterprise geodatabase from PostgreSQL using the following command:
python create_enterprise_gdb.py --DBMS=POSTGRESQL -D ...
9
votes
4
answers
694
views
MS SQL Spatial as Central Datastore?
I've been working on opening up our spatial data from a proprietry system to one that can be read by more products (MapGuide, ESRI, gvSIG, Map3D etc....)
I've decided on using SQL Spatial as we have ...
1
vote
1
answer
193
views
GIS Database format functional differences [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 ...
0
votes
1
answer
4k
views
How to find Nearest point on line from a point cordinate in SQL server
I want to find out the nearest point on my road network which is a multiline string from a point with lat lon value.
The below code I have tried for finding buffer distance line from a point.
...
3
votes
1
answer
636
views
Algorithm to get the nearest line segment (link) to a point
What is the fastest algorithm to get the nearest line segment to a point (that is not on any line segment) in a GIS database?
10
votes
7
answers
3k
views
assign unique id to point features
The MassGIS parcel standard (http://www.mass.gov/mgis/ParstndrdVer1_5_1.pdf) utilizes a concatenation of the whole number portion of x- and y-coordinates to create a unique id (LOC_ID) for features. ...
2
votes
1
answer
335
views
Two persons working on same layer in QGIS [closed]
We are two people who need to edit on the same layer in QGIS. For example one of us will edit locally, the other one via a server connection.
0
votes
1
answer
77
views
I just imported some shapefiles to a PostGIS database, where can I find the files in my drive?
When I installed PostGIS, the default directory for all data is C:\Program Files\PostgreSQL\13\data but I can't find any folder that seems to be related to the database (named 'discover') that I made.
2
votes
0
answers
955
views
QGIS Set Master Password
I installed a fresh version of the QGIS LTR 3.10. I am working on creating a postgres server from a raspberry pi4 and connecting the database to my qgis. Through a tutorial I am walking through, they ...
0
votes
0
answers
242
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 ...
37
votes
2
answers
4k
views
Choosing coordinate system to store geography data for celestial coordinates
I am doing an astronomy project. I want to have the information about our images stored in a spatially enabled database. This, I would think, should be a very easy special case for GIS functions ...
0
votes
0
answers
265
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). ...
3
votes
1
answer
950
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 ...
21
votes
9
answers
36k
views
Choosing database for storing spatial data?
A couple of days ago I installed the demo of spatialware 4.9 from MapInfo into my SQL Server 2005 install and loaded all the larger dataset into it. I was quite impressed with the performance vs the ...
22
votes
3
answers
1k
views
(When) should I use a GIS-enabled database?
I am a long-time programmer, new to GIS. I am trying to get a feel for the database aspects of GIS and I understand that there are some databases which are specialized for GIS use. Basically I am ...