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.

learn more… | top users | synonyms (1)

-1
votes
0answers
35 views

Describing table/database, or relationship in English? From the Identity process with ArcGIS [on hold]

I did a spatial analysis such as Identity process in ArcGIS. I want know how it be described in English for its output in table/database, or its relationship. Which is showed in figure as below.
1
vote
0answers
14 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
19 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
10 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
17 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
0answers
10 views

I'm trying to direct connect a Pictometry (EFS 2.7) install to a ArcGIS 10.3 SQL server geodatabase

I'm trying to point my Pictometry (EFS 2.7) install to a an ArcGIS 10.3 SQL server geodatabase, it previously worked connecting to an older arcsde service. Do I need to upgrade anything?
0
votes
1answer
31 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
45 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 ...
3
votes
2answers
57 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
20 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 (...
0
votes
1answer
97 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
106 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
77 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
21 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
26 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 ...
1
vote
1answer
36 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
24 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 ...
0
votes
0answers
55 views

How can I add the PostGIS extension?

I'm experiencing difficulties when trying to add the PostGIS extension to PostgreSQL. I wasn't able to add the extension during the installation because of an error. Now I'm trying to add the ...
2
votes
1answer
58 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
40 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 shape file and some ...
0
votes
0answers
24 views

Can I used a share drive as a PostgreSQL server?

I am currently using my C drive to practice and I have a shared drive with my co-workers where we store shapefiles. I wanted to start another server in our shared area to have us all connect the files ...
0
votes
1answer
38 views

How to create SpatialPixelsDataFrame from Latitude and Longitude data?

I have a data frame that contains latitude and longitude data with density point. I want to do kriging but my main problem is that I can not create SpatialPixelsDataFrame from my data. My data is ...
1
vote
0answers
15 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 ...
4
votes
0answers
68 views

Can I clip a geodatabase vector layer in QGIS?

I have a Vector layer loaded from a .gdb (geodatabase directory). I'm seeing my contour lines fine. I've drawn a polygon on top of the area I want to crop on a new layer. I select Geoprocessing ...
1
vote
0answers
33 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
33 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
190 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
103 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 ...
0
votes
0answers
63 views

Automatically picking up OBJECTID in ArcMap from Create View in SQL Server

I have a plain SQL table stored in an SDE database on SQL Server 2008 as below. CREATE TABLE [dbo].[AAA_TEST]( [ID] [int] NOT NULL, [LON] [decimal](9, 6) NOT NULL, [LAT] [decimal](9, 6) ...
2
votes
0answers
27 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
64 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
116 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 ...
1
vote
0answers
85 views

Add and edit Oracle Spatial Layer in QGIS

When I connect oracle layer are not enabled me all editing options. I can create and delete but not update. It is an issue of users? permissions or privileges? metadata? All works OK in ...
0
votes
0answers
24 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
68 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?
1
vote
1answer
97 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
107 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
46 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 ...
0
votes
0answers
15 views

UNique ID Field for Oracle versioned GDB

We had a successful trigger through ArcFM, but we have abandoned their datamodel/product. We have a successful trigger when new features are added in a versioned edit session, BUT it does not work for ...
4
votes
1answer
192 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 ...
0
votes
0answers
68 views

Problem with stretched value and classified value in ARCGIS desktop? They are different than each other

I want to classify the value of an image into 3 groups. when I check properties of a raster image, stretched value is different than classified value. Here I have uploaded the images as follow. I ...
1
vote
2answers
83 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
132 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
41 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
58 views

PostGIS/QGIS: Update polygon attribute based on the mode value from a cluster of points

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 ...
1
vote
1answer
148 views

How to convert a complex project of shape files to a spatialite database?

We have a QGIS project made of ~10 shape file layers. The layers are saved on a shared server, and the project is used on different computers. Recently polygons and polylines have been been ...
0
votes
0answers
41 views

Google static map path from MS SQL spatial data

I am trying to generate Google static maps on the fly that include a path based on data I have in a MS SQL Server geometry column. I currently use the encoded path algorithm to reduce the length of my ...
0
votes
1answer
22 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
vote
1answer
58 views

Can't import multiple features or rasters into file geodatabase

I am trying to use the import multiple features into geodatabase option in ArcCatalog (ArcGIS 10.1). Or, similarly, I try to use the import raster option, which screen layout is similar to the ...
1
vote
3answers
509 views

How do I find points that are NOT within a list of polygons using MS SQL?

I have a table of points, and and a table of polygons. I have managed to build queries (MS SQL) to get the containing polygon for a given point, as well as listing all the points within a specified ...