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
0 votes
1 answer
64 views

Database standards for storing and analysing raster

Vector data stored in a database is covered by OGC's Simple Features and WKT. Databases indeed implement these standards. Some databases such as Oracle, PostGIS extend their support to rasters. Is ...
user avatar
1 vote
1 answer
79 views

Why I obtain different values calculating distance between two point in the space using this "Great-circle distance" formula and Google Earth tool?

I am not so into database and GIS and I have the following doubt about this function used on a MySql database to calculate the distance between 2 points. I am started from this tutorial where there ...
user avatar
1 vote
0 answers
68 views

Working with Canvec Data?

I'm trying to join some downloaded CANVEC data to associated style file, but I am unable to join on the code field. The field used to join the stylefile for ArcMap has been removed from the ...
user avatar
0 votes
1 answer
128 views

PostgreSQL table corrupt not display in QGIS

I have a problem with a PostgreSQL table. It is the result of a query that joins 77 tables with 4 columns (geom, inicio, fuente, temporada). I used ST_SRID and ST_Transform because I could not join ...
user avatar
0 votes
0 answers
15 views

connecting a database to a map [duplicate]

I have data about some monuments (date of construction, and other historical information), and I would like to build a sort of visual database to be put online, in which a series of markers should ...
user avatar
  • 1,434
3 votes
2 answers
1k views

PostGIS - query maximum distance between two polygons

In PostGIS, how can you calculate the maximum distance that one polygon is from the nearest point of another polygon? I have two tables of polygons, 'red' and 'blue'. They can be joined by field ...
user avatar
0 votes
0 answers
597 views

ST_Equals not matching with exact geometry

I followed many question posted on the same subject but unable to solve my problem. I have same kind of tables in 2 different database (tables with linestring geometry), I need to update id from one ...
user avatar
3 votes
2 answers
420 views

Why does rendering from a view take significantly longer than rendering from a table?

Using QGIS, rendering from a view takes significantly longer than rendering the same data from the source table. The view is just a select all from source table. The database is SQL Server 2012.
user avatar
  • 31
1 vote
2 answers
3k views

How to transfer table from localhost server to another server in PostgreSQL

I have a table with more than 1000000 rows (point,line,polygons) in localhost server and I want to transfer this table to another database in another server with PostgreSQL. What is the best and ...
user avatar
  • 111
5 votes
2 answers
1k views

Select point features using spatial query

I have two postgres tables, one polygon features and second point features, having same projection. What i want to do is to select only the points which contains in large polygon and does not contain ...
user avatar
1 vote
0 answers
33 views

Silverlight application and Geometry Data [closed]

I have a table in SQL server 2012 TABLE [Feature]( [GUID] [unique identifier] NOT NULL, [Geom] [geometry] NOT NULL) in this table record my feature. I need create an application with ...
user avatar
1 vote
2 answers
2k views

subtract polygons from other polygons with SQL

I have a MSSQL table that houses a bunch of polygons. I want to select a few ( with a WHERE clause ) and subtract another bunch from these first ones. Compare it with having all plot-outlines and ...
user avatar
  • 605
0 votes
1 answer
1k views

Creating Data Dictionary File (.ddf) from a Geodatabase

At my workplace we use Trimble GeoXT GPS devices or similar with CartoPac installed for GPS feature data collection. We have not used Trimble Pathfinder for several years. For a few projects, we ...
user avatar
0 votes
1 answer
802 views

How to link spatial and non spatial table in geoserver

I have a vector data published in GeoServer. I have other two non-spatial table which can be linked to the vector by a common field name. Now I would like to know how this can be done using GeoServer?...
user avatar
  • 2,846
3 votes
3 answers
869 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 '...
user avatar
1 vote
1 answer
6k 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 ...
user avatar
1 vote
0 answers
900 views

Slow SDE Feature Class Performance

I've been experiencing slower than usual performance (noticeably slow time to draw as well as query, compared to similar feature classes) with a specific feature class in my organizations enterprise ...
user avatar
0 votes
1 answer
129 views

Carto DB city border polygons issue?

I want to visualize some statistical data about my country and I'm using the CartoDB geocoder. I've city names and I want to see cities as polygons but CartoDB says it has no polygon data, it can only ...
user avatar
  • 307
0 votes
1 answer
398 views

SDO_GEOM.RELATE DETERMINE says 'EQUAL' but doesn't return TRUE in the where clause

The following query returns 'EQUAL' for the geometry-relation : select a.g3e_fid , b.g3e_fid , SDO_GEOM.RELATE( SDO_CS.MAKE_2D( a.g3e_geometry), 'DETERMINE', SDO_CS.MAKE_2D( b....
user avatar
  • 111
0 votes
1 answer
4k views

How find Nearest points using STBuffer and STContains in SQLServer using given point from point table?

This is the Query I am using now.. SELECT top 1 coloumname FROM tablename WHERE ROUND ((geometry::Point(74.8427116215336,12.852857058953,4326).STDistance(the_geom))*111.325,2) <2 ORDER BY ...
user avatar
  • 115
0 votes
1 answer
132 views

VB.net search for address in Geodatabase in ArcObjects

I am try to search for address in Geodatabase in ArcObjects using VB.NET I tray this sample but my database is large so when I use this sample in TextBox1_TextChanged it is slow ! How can I search ...
user avatar
  • 109
1 vote
0 answers
549 views

Getting H2GIS functions to work in Spherical Space?

I've been playing around with H2GIS (http://www.h2gis.org/) for a project at work and am struggling to get the H2 functions to operate in spherical space (lat/ lon), rather than cartesian space. The ...
user avatar
  • 11
5 votes
2 answers
2k views

How do partition tables improve query performance in PostGIS? [closed]

I have static road, country and state datasets in my PostGIS database. Road networks are partitioned by their containing country. Countries, States and other areas reside in their own table and are ...
user avatar
  • 249
0 votes
0 answers
308 views

Database modeling for big data (big set of points X big sets of possible values for each points)?

I'm building a PostgreSQL database with the intent to host modelisation results for different projects. Each project has a set of receptors points (~5000-10000 receptors) and have many results sets (...
user avatar
  • 465
2 votes
1 answer
5k views

Clustering of Spatial Data in R or Python [closed]

I am new to GIS. Problem Domain :- I have a stoppage data of different vehicle i.e. the point where vehicle stopped.There are some specific vehicle which stops at some particular point. So, I am ...
user avatar
0 votes
1 answer
976 views

Parse and load GPX into database? [closed]

Having a PostgreSQL database, with the following tables: CREATE EXTENSION postgis; DROP TABLE IF EXISTS trips CASCADE; DROP TABLE IF EXISTS locations CASCADE; CREATE TABLE IF NOT EXISTS trips ( ...
user avatar
3 votes
1 answer
633 views

How to split ESRI file geodatabase into two or three by region?

I have got a ESRI file geodatabase(10.3) with many feature-classes(Polygon, Polyline & point). I don't have enterprise ESRI license. I have to split the entire data into two unique parts to do ...
user avatar
1 vote
1 answer
355 views

How to determine if all polygons are contiguous by single point in SQL Server

I've been looking for some function that will consider geometries from a table. The selection would look something like this: SELECT geom FROM mytable WHERE geoid IN (1, 10, 15, 30, 2) How can I ...
user avatar
0 votes
1 answer
69 views

os module can't find time files were created, because "system can't find file specified"

I have ~200 layers in a Map Document, and I am trying to find the dates that these layers were created on (so I can export to database later). Some of these layers are housed in groups and sub-groups ...
user avatar
  • 343
3 votes
2 answers
366 views

ogr2ogr append 1 row to a File GDB feature class's data table

I export a polygon layer from Oracle to a FileGDB using ogr2ogr. I need to append one row to the data table, with '0' for numeric fields and 'No Elements' for the one string field. In ArcGIS, I run a ...
user avatar
  • 161
0 votes
1 answer
129 views

3d city database set up problem

I am trying to set up 3d city database and I have some problems. I hope you can help me. I receive an error as you can see attaching file. What is wrong? The error message is: '"\psql"' is not ...
user avatar
  • 599
2 votes
1 answer
337 views

How to update PostGIS column with distance from features in the same table

I have a table 'mytable' with columns 'Geometry', 'featurecode', 'height' and 'pkey'. There is a spatial index and im using PG9.4 For most of the table the height column is null. Only where ...
user avatar
  • 405
1 vote
1 answer
82 views

Is it safe to combine data for zipcodes across different demographic sets? [closed]

My team is working with demographics data across different data sources (some paid sources and some free data sources available online). Each of these data sources comes with a shapefile and some ...
user avatar
  • 147
1 vote
0 answers
18 views

GeoServer - Web application [duplicate]

for a science project at university I have the task to create a web application based on Geoserver. The data is already stored, I have to visualize it now on the web for different users. Each user can ...
user avatar
1 vote
0 answers
186 views

Spatial decision support tools for spatial planning, licensing, and permitting, alternative to FlexiCadastre? [closed]

I'm tasked to design and develop an information management system, i.e. GIS-based spatial decision support system to guide, inform, evaluate, and monitor regulatory processes in spatial planning, ...
user avatar
1 vote
1 answer
81 views

Load postgis database with PK from two fields in QGIS [closed]

I have a PostGIS database having a Primary Key from two fields id_cat and id_cdad. When I load this database in QGIS in my computer under Linux there are no problem. I unmark "Select ID" and I can ...
user avatar
2 votes
2 answers
2k views

How to get an area Latlong geometry directly from google map?

I am new to field of GIS. I need to know that do we have an option of getting latlong of a building that we see in google earth or any Point of Interest areas. Something like i create & drag ...
user avatar
  • 21
4 votes
1 answer
1k views

Mapping SQL tables in ArcGIS Desktop

I have several tables in SQL server. I am trying to visualize my data in ArcGIS. However, I have not been able to do so. I started off my making a database connection in Arc Catalog to my SQL. I did ...
user avatar
  • 43
2 votes
0 answers
48 views

Is there any P2P GIS or SDI?

Have you heard/read about a distributed SDI (Spatial Data Infrastructure) or GIS ? I'm thinking on a system that uses something similar to the torrent protocol for managing spatial data and also be ...
user avatar
  • 353
0 votes
1 answer
3k 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. ...
user avatar
  • 91
1 vote
1 answer
761 views

Mysql 5.5 spatial to Google Maps API

I've got a mysql table with points and polygons spatial geometries. I can see that MySQL 5.5 doesn't have the ST_AsGeoJSON() function to extract to GeoJSON. I'm looking for the simplest way to ...
user avatar
  • 464
0 votes
1 answer
62 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 ...
user avatar
  • 289
3 votes
1 answer
607 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?
user avatar
  • 192
2 votes
1 answer
228 views

Cloud based database solution [closed]

I'm looking for a cloud based database solution where I can store about 1 GB worth of tabular data and both myself and my client can access to perform SQL queries. I'm looking for this database to ...
user avatar
  • 479
2 votes
1 answer
2k views

Raster data QGIS and SpatiaLite?

I am a german student and study Geoinformatik. I have the task to store Raster data in SQLite. So use the turotial from the gaia page to Create a database and store a image (TIFF) named NaturalEarth. ...
user avatar
  • 23
1 vote
0 answers
254 views

how to fix projection in QGIS from earth data

After downloading and opening natural earth data in QGIS, the result shows like this I have tried uncheck simplify geometry but it doesn’t work. I think the problem is related with globe projections ...
user avatar
4 votes
1 answer
299 views

Clustering Technique?

I have the following 9 clusters (each colour represent the appropriate cluster): I am looking for a clustering algorithm (if any) that would achieve "realistic" results. The data represents ...
user avatar
1 vote
2 answers
602 views

Aegean Islands Spatial Dataset

I need a .csv file about the coordinates of all the Islands in Aegean Sea. Do you have any idea how I can find them?
user avatar
  • 55
3 votes
2 answers
859 views

PostGIS database design: For polygon data

I am designing a spatial database using PostGIS. My main aim of this spatial database is to organize Administrative (250 polygon layer) and postal layers (154 layers) in a database. These layers ...
user avatar
  • 1,906
1 vote
0 answers
137 views

GeoServer: Use oracle as raster store without spatial extension

Is it possible to store raster data (e.g. GeoTIFFs) in an oracle table and access it from geoserver without using the oracle spatial extension/GeoRaster? I would store the images as blobs, but I don't ...
user avatar
  • 269

1 2
3
4 5
10