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)

0
votes
0answers
8 views

How do I insert a Query Result into an existing Table?

I am attempting to create a map that displays the Service Area for Firestations within Toronto, In order to do this I need to identify the Length of all pathways. I tried using the calculate geometry ...
0
votes
0answers
35 views

Export geodatabase feature class to .dbf or .txt file

I have 40 super large (millions of records) geodatabase feature classes (areal data) and would like to export their attribute tables into .dbf or .txt files using model builder. I tried using "table ...
-1
votes
0answers
33 views

how to build a truely standalone mobile map app?

I am a newbie around here and here goes my first question...Is it possible to build a truely standalone mobile map app (working offline)? If so then how and with which set of tools? What geodata ...
0
votes
0answers
15 views

Connect MySQL spatial database with ArcGIS10 [duplicate]

I'd like to know if there is any way to connect a MySQL spatial database with ArcGIS10. I use to connect these databases using ODBC driver but it doesn't work for spatial connections.
1
vote
0answers
27 views

Add Rasters to a new GDB/Mosaic Dataset in ArcGIS ModelBuilder

I'm attempting to add rasters to a new mosaic dataset in a new file geodatabase, all in the same model. However, the Add Rasters To Mosaic Dataset tool does not recognize the NewMosaicDataset or the ...
1
vote
1answer
23 views

Where can I find global spatial data for net primary productivity (NPP)?

The title is more or less self-explanatory. I have looked and looked but have met various road blocks. Does anyone know of a reliable source for such data? Thanks!
0
votes
1answer
35 views

ArcCatalog Registering a Feature Class into Geodatabase: Getting an Error

This is a SQL Server GeoDatabase. I have created a couple of tables using SSMS; then imported data to them. Then, inside ArcMAP, I created Layers and pointed their data to these tables via SDE. So now ...
1
vote
1answer
38 views

non alignment of base layer and other vector layers

i'm sure you've encountered this problem repeatedly. i've tried all different methods. Enable on the fly crs transformation. go to settings and options to use crs data. go to properties and change ...
2
votes
1answer
83 views

Best practice for a group working on the same shapefile, with open source tools

We are a small (~5) group working on a single, shared shapefile. The current workflow is that each one of us does the editing on a designated attribute field, on his local copy, then exports the ...
1
vote
0answers
22 views

QGIS crashes when geodatabase file opened

I recently updated my version of QGIS to 2.6 Brighton and am no longer able to open geodatabase files, everytime I try the program quits. Is there a way to fix this or is this a bug with the new ...
1
vote
1answer
31 views

Coordinates from a SQL Server Inserts don't Show Results

I am trying to parse a JSON output file from an .Mxd file. All work fine and the following SQL Insert in SSMS using sample coordinates: delete from RoomData insert into RoomData ...
1
vote
0answers
67 views

5-star rating for mobile iOS app [closed]

Looking to create a mobile iOS app to collect consumer feedback on 10 separate locations using a 5-star rating system. There would be a total of 4 questions, each of which would require a separate ...
1
vote
0answers
32 views

Open source UML modeling software (GIS)

I am wondering is there any opensource UML to Postgresql Mysql tables conversion software which also includes the geospatial datatypes ? Note:I want conversion from UML to database. and NOT ...
0
votes
1answer
18 views

which spatial server goes better with raster images stored in DB Spatialite?

I would like to serve images from Spatialite as WMS services. As far as I know: Geoserver is compatible with vector features only -if you install the extension-, but not with spatialite BLOBs (in ...
0
votes
1answer
67 views

How to use iterators in ModelBuilder to create new feature?

I am attempting to use ModelBuilder to automate the process of plotting parcels of land that are related to mineral leases. The existing lease feature class contains information related to reference ...
1
vote
2answers
82 views

Order sql server spatial geometry distance by the nearest

I have a geometry column in a table, I want to get the N nearest neighbours; here is a specific example with the geography type DECLARE @PTO Geography = Geography::STPointFromText('POINT(-57.432546 ...
1
vote
1answer
25 views

Specific Feature Copying

I'm trying to write a script to copy multiple feature classes from two different databases into a single database, but I want to be able to specity what features I actually want. I know I need to use ...
2
votes
1answer
33 views

Database to get New York City frontages?

I'm looking for a database that gives the length of frontage of an address or gives the information necessary to calculate this for New York City (NYC) or for another large US city. So far I haven't ...
1
vote
0answers
62 views

Error using ST_Geometry Aggregate Function for Hive

I am using the ESRI framework that extends the Hive syntax to support spatial types and operations. In particular, I am trying to use an aggregated geometry function, announced in this blog post in ...
1
vote
2answers
55 views

Free solution for an intranet geodatabase for point data, connectable to QGIS / MapInfo

I have a plenty of point measurements - thousands of points with date/time, gps, measured values etc. I would like to make it possible to put all my particular datasets (can decide whether shp or ...
1
vote
0answers
26 views

Seeking database that identifies adjacent postal addresses and/or zoning of postal address?

I apologize for asking such a basic question, but can someone point to: a database that identifies adjacent postal addresses (for example, if I provide an address, the database provides address of ...
0
votes
0answers
63 views

How to select main cities in a country from planet OSM data

I am trying to create a map with my own style with the help of geoserver and planet OSM data,but trying to give style to the polygon at different zoom level ,need to highlight main in cities in ...
1
vote
1answer
81 views

How to find a point on linestring and in a range of 10 meter

i have a linestring which is show in diagram and i have a point which is some time on the linestring or out of linestring but in range which is red line and some time its is out of range so how can i ...
2
votes
3answers
62 views

Need to extract OSM data for my area from 2 neighbor countries

I need to prepare offline background data for my area of interest which is located around border between Czech Republic and Germany. I need to convert the OSM data to spatialite and then to use in ...
1
vote
0answers
159 views

Route tracking on google map php

i have to make a software which is track a vehicle on Google map using GPS. I have almost done this project but i am stuck at a point, the client require a system that track the bus in a route. I am ...
0
votes
0answers
31 views

Looking for succesful implementaion of PPDM in form of geodatabase

I am have difficulties in implementing spatial version of Professional Petroleum Data Management (PPDM) for our GIS database. Does anyone have a reference to a sucessful case of implementing PPDM in ...
2
votes
1answer
67 views

Determining date or time Feature Class was created in File Geodatabase?

I had a script running at the office over the last 5 days and tried to remote on unsuccessfully since the 3rd day. I got here and it appears there was a power outage. Is there a way to find out the ...
0
votes
0answers
20 views

How to use linear referencing in Informix DB with Spatial Blade?

Is there any simple solution to use linear referencing in Informix Database with Spatial Datablade?
1
vote
0answers
36 views

Migrate MS Access Data into Oracle DB

I was sent some old MS Access files that contained survey data and served as a "file geodatabase". I want to import these to my Oracle Database with it maintaining "geometric" sense and meaning. I ...
0
votes
2answers
66 views

SQL filter to show one layer only if another layer is missing

I have two oracle tables that represent buildings in my town. The first table represent buildings that are surveyed and measured accurately but doesn't cover all the parts of the town while the second ...
1
vote
0answers
39 views

DB manager not updating

I'm trying to learn how to use spatialite databases, so have made a few experimental ones. When I delete them, however, they still show up in QGIS's DB Manager. If I try to open them it comes up with ...
0
votes
1answer
39 views

Spatial query to make view

I've got two tables which I want to combine and enrich with each others data. I'm getting stuck on the join part, as this needs to be done via a spatial query. First the table structure: a table with ...
2
votes
2answers
52 views

QGIS Forms - How Do I Display a Read-Only Value?

Older versions of QGIS had an "Immutable" option for form fields to make it obvious that data was read-only. How do I display values in the current version and make it obvious that they are ...
0
votes
0answers
77 views

How to work with gdb from c#?

I have installed PostgreSql 9.3, PostGIS(last version) and Npgsql. I have geodatabase(tmp.gdb) how to make conection for this DB from c#? And how to connect this DB to PostgreSql? It possible to ...
2
votes
1answer
86 views

Databases supporting intersection of multipolygons and a set of points

Currently we use PostGIS to store thousands of MULTIPOLYGONs and we can then use ST_Intersects to return any that rows contain any point in an input collection of points. Are there any other open ...
0
votes
0answers
96 views

When to use DBMS instead of System Files for Spatial Data Storage?

I'm having trouble deciding when it is best to use a DBMS instead of System Files for storage of Spatial Data. Are there any specific guidelines and reasons for when one method is preferred over the ...
0
votes
2answers
153 views

How to update Geodatabase point file table from Excel data using FME

I have excel spreadsheet with data that I want to load into a GeoDatabase point table. The table already exists and I want to update the data not append. There is a unique ID to link the Excel data ...
5
votes
1answer
101 views

Spatial+Temporal database request for 4D intersection

Here is the function I need to implement. My application deals with mobile objects with variable position and range (think of radar range). As I can't test each minute if n mobiles detect each other ...
1
vote
3answers
2k views

postgresql export database with command or pgAdmin III

I want to export my postgresql db with pgadmin. I search all of its GUI, I also searched the web and I don't find some sueful information. I know how to import the db into postgresql: create a db with ...
1
vote
0answers
26 views

Adding feature to remote geodatabase takes a long time

I have a program that I must add some features to a feature class that is in a sql server remote database. But when I want to open connection and add them, it takes a long time, about one or two ...
3
votes
1answer
56 views

Problem in Backing up a database in PostgreSQL

I need to create a backup from my database (in PostgreSQL 9.3). I have used the pg_dump tool, gives me an error. I have also used pgAdmin III for backing up which also gives me the following error: ...
1
vote
1answer
45 views

Spatial queries to find co-occurrences of POIs

Given a POI database containing different types of points, e.g. hospital and pharmacy, how can I select the locations where a hospital and a pharmacy are closer than a certain threshold (e.g. 1000m)? ...
0
votes
0answers
149 views

Exporting feature class from gdb crashes ArcCatalog

I'm trying to export a polygon feature class from a file geodatabase created and managed using ArcCatalog. When I click "export" a dialog window pops up, then another that says script error, then ...
6
votes
2answers
197 views

How to replicate ArcGIS Intersect in PostGIS

I'm trying to replicate this ArcGIS process in PostGIS: http://blogs.esri.com/esri/arcgis/2012/11/13/spaghetti_and_meatballs/. This describes how to break buffered points down into polygons based on ...
1
vote
1answer
63 views

Implementing Wrapper of PostgreSQL?

How can I implement the Wrapper of PostgreSQL? I found this useful looking wrapper from a FOSS4G routing with pgRouting Workshop but I do not know how to implement it!
-1
votes
2answers
84 views

Adding an excel database to an existing shapefile [duplicate]

I have a spreadsheet with various feature data; I would like to add this data to an existing shapefile. I have a common column in both the shapefile and the excel data. I would like to be able to ...
2
votes
0answers
136 views

Import GML data in SQL Server Spatial

I have GML file with Application Schema whose data I need to import into SQL Server Spatial. I have been creted database structure with all thing that I need in database, and now I need to fill it ...
1
vote
1answer
152 views

GeographyFromText and ST_SetSRID+ST_MakePoint different results?

Why am I getting different results? SELECT ST_DISTANCE( ST_GeographyFromText('SRID=4326;POINT(13.401111 52.383343)'), --berlin ST_GeographyFromText('SRID=4326;POINT(9.997559 53.533778)') ...
0
votes
0answers
66 views

PostGIS Spatial query taking a very long time

I'm trying to return a count of crimes (points) that occur in each police grid (polygons), as well as the geometry data, but the query takes ~22 seconds. This seems oddly high and will be problematic ...
2
votes
1answer
184 views

How to create an SQL Persisted Computed Column which values are derived from spatial column

Our GDB is using the SQL native GEOMETRY data storage type (SQL 2012 Standard) and the spatial reference for this uses a unit of square feet. I want to create a (persisted) computed column which will ...