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
23 views

Most representative spatial queries [on hold]

I would like to do few tests of different spatial databases and compare response times for different types of queries. There are some studies available but they often do not present the selection of ...
0
votes
1answer
21 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 ...
-3
votes
0answers
13 views

“Peer authentication failed for user ”postgres" Error When installing cartoDB [closed]

I am trying to install cartoDB locally following these installation steps http://cartodb.readthedocs.org/en/latest/install.html. However, after editing /etc/postgresql/9.3/main/pg_hba.conf to look ...
1
vote
0answers
20 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
0answers
14 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
39 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
50 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
33 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
22 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
33 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
14 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
55 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
28 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
31 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
107 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 ...
3
votes
1answer
76 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
40 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
45 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
0answers
89 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
64 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
63 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
83 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 ...
1
vote
1answer
87 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
38 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
14 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
182 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
54 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
69 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
110 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
37 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
56 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
100 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
34 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
20 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
52 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
367 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 ...
0
votes
2answers
113 views

Getting Started Using Leaflet Draw to CrowdSource Shapes on a Map

I want to crowdsource shapes on a map for an organization I'm working with. It seems like Leaflet Draw something along the lines of the Mapping Neighborhoods projects. As someone with some experience ...
0
votes
1answer
264 views

Install Postgresql / Postgis with SFCGAL

I need to access ST_StraightSkeleton() function. At the moment i have a Postgresql instalation PostgreSQL 9.3.4 compiled by Visual C++ build 1600, 64-bit installed via EDB with Postgis 2.1.7 on a ...
0
votes
0answers
16 views

How to convert File Geodatabase to Personal Geodatabase [duplicate]

I have a file geodatabase (gdb) and I want to convert it to personal geodatabase. I am using ArcMap 10.2. Does esri support this conversion? Any easy steps? what I would like to achieve is to access ...
2
votes
2answers
56 views

Any free Tools to display more than 5000 geography objects in SQL Server?

SQL Server 2008 and up allow you to create a spatial index. If you select records that include a geography or geometry object, a spatial data tab appears that can display up to 5000 points or lines or ...
2
votes
1answer
60 views

Can qgis cooperate with phpmyadmin?

Can this two cooperate together? I am asking this, because I have database in myadmin with column for long. and lat. informations. Is there a way to connect qgis with myadmin? Or what type of ...
0
votes
1answer
49 views

Distributed Geodatabase ExportDataChangeMessage

How to perform ExportDataChangeMessage. I am not getting where to get in_replica. My code is: Geoprocessor GP = new Geoprocessor(); GP.SetEnvironmentValue("workspace", outputpath1); ...
1
vote
0answers
23 views

How to show neighboring polygons and polygon in which point exists

We have a table which has polygon related data stored. For finding if a point (long,lat) is within that polygon I am using following query in mysql SET @vasantKunjSectorC = 'polygon((77.161266 ...
1
vote
0answers
36 views

Partial extents for ArcGIS android geodatabase creation

I know how to create and download a geodatabase copy of a FeatureServer from arcgis rest services. I also know how to pass LayerQuery to the geodatabase task to filter layer objects and features. ...
1
vote
0answers
51 views

Difference between adding spatial layer from MSSQL through “browser” and “add MSSQL table”

So I am trying to pinpoint the difference of adding layers from MSSQL Database that contains spatial layers like geography and geometry. I have noticed that when adding from the browser it retains it ...
1
vote
0answers
95 views

Issues creating ArcSDE sde_logfile for certain users (username begins with a numeral)

I am having issues when editing an sde feature class from certain users. The way my database is set up is that the authentication roles are updating constantly by comparing the current authentication ...
0
votes
0answers
44 views

Importing feature class into feature dataset of different coordinate system

So currently I'm creating a geodata base and I'm arranging alot of the data into feature datasets. I have been using the feature class to geodatabase tool to import the data directly into the feature ...
7
votes
1answer
201 views

How do I optimise performance on a local QGIS + PostGIS installation?

I'm learning how to manage a local PostGIS (ver 2.1) database, with spatial indexing enabled on the shapefiles that I've imported (using the PostGIS Shapefile Import/Export Manager). I have imported a ...