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
3answers
20 views

How to find which areas/regions a list of lat/lons are in?

The Australian Bureau of Statistics (ABS) issues Esri shapefiles or MapInfo files which have a code # for each geographical area at various 'resolutions' and I have a database with a column of ...
1
vote
1answer
34 views

What is a “value raster”?

I want to understand the concept of a "value raster" and if I can use it in neighbourhood statistics.
0
votes
1answer
43 views

GIS information on worldwide cases of wildfires?

I am developing some case studies on wildfire cases around the globe, some examples include California (2007), Australia (2009), Moscow (2010), Valparaiso in Chile (2014), and so on. I was wondering ...
0
votes
2answers
64 views

How to change different projections of feature classes in geodatabase to one projection in new geodatabase?

I want to create a script that iterates through feature classes with different projections in a geodatabase and exports them into a new geodatabase, all with the same projections. What I want is to ...
0
votes
0answers
50 views

Spatial Data Mining theme

I have question related to a study theme on Spatial Data Mining. Turns out that I have the data of Missouri rivers (lines), counties (multilines) with their crime rate and the factories that handle ...
0
votes
2answers
17 views

Importing and exporting KML into and from DashDB for Geospatial Analysis

I am a recent convert to IBM's DashDB, and I considering proposing to use it at my work. My case would greatly be bolstered if I could show good, easy integration for geospatial analytics data, namely ...
1
vote
1answer
22 views

ArcMap, Editor and Geodatabase API edit session question

Say a feature class from a File GDB is added to ArcMap and an editing session on it is in progress. What happens if an add-in launched from the same ArcMap session tries to start an edit session using ...
0
votes
1answer
30 views

Select and count street pattern features (morphology) using ArcGIS for Desktop?

I'd like to be able to select and count the number of cul-de-sacs, lollipops, dead ends, or other types of street structure in a hillside community.
0
votes
0answers
16 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
43 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 ...
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
42 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
25 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
37 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
39 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
84 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
23 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
79 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
38 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
20 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
73 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
110 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
36 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
71 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
56 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
28 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
69 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
91 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
172 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
36 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
73 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
42 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
70 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
40 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
42 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
55 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
93 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
89 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
97 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
166 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
27 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
58 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
165 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 ...