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
0answers
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 ...
3
votes
2answers
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 ...
0
votes
0answers
525 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 ...
3
votes
2answers
387 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.
1
vote
2answers
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 ...
5
votes
2answers
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 ...
1
vote
0answers
32 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 ...
1
vote
2answers
1k 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 ...
0
votes
1answer
763 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 ...
0
votes
1answer
629 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?...
3
votes
3answers
753 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
1answer
122 views

Which is the simple spatial database for GIS which can is easy to learn? [closed]

I am looking for GIS DB, to work with 800 millions of GIS data. I want to make my work more simple easy by doing it in spatial DB. I want to work with Geography and not on Geometry. Please suggest ...
1
vote
1answer
5k 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 ...
1
vote
0answers
778 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 ...
0
votes
1answer
118 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 ...
0
votes
1answer
372 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....
0
votes
1answer
3k 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 ...
0
votes
1answer
119 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 ...
1
vote
0answers
446 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 ...
5
votes
2answers
1k 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 ...
0
votes
0answers
299 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 (...
2
votes
1answer
4k 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 ...
0
votes
1answer
818 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 ( ...
3
votes
1answer
530 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 ...
1
vote
1answer
243 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 ...
0
votes
1answer
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 ...
2
votes
2answers
272 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 ...
0
votes
1answer
109 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 ...
2
votes
1answer
298 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 ...
1
vote
1answer
75 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 ...
1
vote
0answers
17 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 ...
1
vote
0answers
182 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, ...
1
vote
1answer
74 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 ...
2
votes
2answers
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 ...
4
votes
1answer
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 ...
2
votes
0answers
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 ...
0
votes
1answer
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. ...
1
vote
1answer
699 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 ...
0
votes
0answers
39 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 ...
2
votes
1answer
528 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?
2
votes
1answer
209 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 ...
2
votes
1answer
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. ...
1
vote
0answers
217 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 ...
4
votes
1answer
287 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 ...
1
vote
2answers
463 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?
3
votes
2answers
774 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 ...
1
vote
0answers
123 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 ...
1
vote
1answer
150 views

Updating polygon attribute based on mode value from cluster of points using PostGIS?

I'm updating a PostGIS table of polygons denoting property boundaries with some values that form part of a code for sites scattered across the properties. Neither dataset is 100% accurate so I can't ...
4
votes
1answer
2k views

How to convert a complex project of shapefiles to a SpatiaLite database?

We have a QGIS project made of ~10 shapefile layers. The layers are saved on a shared server, and the project is used on different computers. Recently polygons and polylines have been been ...
1
vote
1answer
43 views

Standardized format for contributing street closure data to navigation apps

I am wanting to put together an application that will digest georeferenced road closure data. I am wondering if any such format currently exists for notifying google maps or other navigation ...

1 2
3
4 5
10