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

How to take only relevant rows from database, based on common codes

I have a current .shp file that is missing some data and the data i have in a different database, a .csv file. How can i get ONLY the relevant rows from the .csv file added to the current .shp file's ...
0
votes
3answers
7 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
48 views

Strategies for managing (and ultimately merging) duplicate business locations in a spatial database

I am working on a project right now that involves using multiple (very large) "location directories" to identify with the highest possible inclusiveness, a diverse set of business locations. These ...
0
votes
2answers
61 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
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
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
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 ...
2
votes
2answers
277 views

Using Qt Designer to Create a Form in QGIS that can search for a specific point in a layer

I would like to ask if you can create a form in Qt Designer to create a form that can search for a point on the map using data that the user will provide such as the Name. I am currently creating a ...
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
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 ...
2
votes
1answer
199 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 ...
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.
3
votes
2answers
2k views

How to convert 6 digit latitude & 7 digit longitude to degrees

Sorry, but I'm a bit new to the whole GIS world, and though I am making great headway drawing polygons and such in Bing Maps, I am currently stuck. In our SQL spatial data, I came across MULTIPOLYGON ...
10
votes
3answers
2k views

Future of spatial databases?

It may be a bit off-topic. I am eager to know the industry specific importance of Spatial Databases. Is Spatial Database a very important part of any GIS system? Or will we use other technologies to ...
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
62 views

How to calculate sums for all fields in a table? [duplicate]

Possible Duplicate: are there any methods can choose all field and make the SUM for each fields or I must do it one by one? Are there any methods that can calculate the summary statistic ...
6
votes
1answer
1k views

Setting geometry types importing to PostGIS with OGR

I'm using ogr2ogr to import data into a PostGIS database. Each dataset I need to import has (theoretically) the same exact data structure, but it appears that they are not the same geometry types. ...
0
votes
0answers
42 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
vote
1answer
195 views

How to link 2 different images in eCognition

I'd like to link 2 different images in eCognition to find the same pixels on both images. The images have same projection (geog lat/long). How can I do this? Thank you so much
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.
7
votes
3answers
6k views

How to export multiple featureclasses to shapefiles?

I have plenty features in a geodatabase. I need to save/export them into shapefiles, because my mate works with Manifold, which is not able to read geodatabases. Any Ideas? Click on every single layer ...
16
votes
7answers
16k views

Is a Country/State/City Database available?

I asked this question Stack Overflow but I was informed that I would get a better to this question here because it's not related to programming. I am creating a directory which uses locations to ...
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
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!
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
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
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
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 ...
0
votes
1answer
113 views

Refresh Map after Invoke URL

I am making a map on Auto Desk Infrastructure Map Guide Studio. Now I created a small ASP.NET website and hosted in local machine, Now on click of different buttons in flexible layout toolbar, I ...
1
vote
0answers
78 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 ...
18
votes
3answers
6k views

What is difference between ArcSDE and spatially enabled databases?

When would you want to use ArcSDE (available as ArcGIS Server Basic license level) versus a spatially enabled database? What are the trade-offs on either side? What are the benefits on either ...
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 ...
5
votes
2answers
662 views

FME - How to write all attributes when multiple source files have the same name?

I am using FME to write all the MapInfo TAB files in a directory and it's subdirectories to a File Geodatabase. I'm using dynamic readers and dynamic writers as I don't know the geometry or schema of ...
0
votes
0answers
901 views

How to represent clustering of geographical points on map in STATA?

I've plotted a map on STATA using user-written program spmap and have also obtained the grid for my space using spgrid program. Now I want to see where most of my data points are clustered on map. Is ...
7
votes
4answers
2k views

Insert points into SQL Server?

I am collecting X and Y values from a web service (Twitter) via a python script. In the long run, this will run over a period of months and I intend on stopping at around the 6 million point mark. ...
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 ...
3
votes
3answers
1k views

Global solar radiation data

I need a solar radiation data in central Asia. Is there any global dataset of solar radiation. If someone know about it, please send to me the link. thanks a lot
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 ...
2
votes
2answers
172 views

Detecting patterns in vehicle GPS data [closed]

I need to analyze data uploaded from vehicle GPS devices to detect travel patterns and then attempt to learn about the normal travel patterns for that vehicle so that predictions can be made about ...
0
votes
1answer
75 views

Spatial database data representation vs. spatial programistic libraries representation [closed]

Can anyone tell me what is the difference between spatial database data representation and spatial programistic libraries representation? It is not clear to me. I have tried to google it and I can ...
1
vote
2answers
170 views

spatial database vs spatial datastructure?

I am building an automated system that has to process several hundred spatial queries in the form of a polygon every day. The queries have to return both spatial and nonspatial data from different ...
0
votes
1answer
265 views

Getting fail to store Polygon Shape Object in Geometry Datatype with hibernate spatial API

Tried to store Polygon shape in database with HibernateSpatial API. I have followed this tutorial to store values. I am using Mysql as my database server. So Made some couple of changes for my ...
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)? ...