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
vote
2answers
85 views

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

Good Day! 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 ...
1
vote
1answer
30 views

What is best way to reorganize osm into PostGIS database entity?

I'm just wondering how to reorganize the OSM given entity to more flexible and schematic purpose. The OSM gave 4 entities the planet_osm_line, planet_osm_point, planet_osm_polygon and ...
1
vote
1answer
119 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
4answers
48 views

Populate a field from another field with a conditional

I am working in SDE geodatabase where I have a feature class 'Mange_Waste' and "Q1", "Q2" are two fields. I wanted to use python script for populating "Q2" from "Q1" with a condition. Like, if the ...
1
vote
3answers
215 views

Merge Multipart Feature Line

I'd try to merge multipart feature line, but didn't work. would you please teach me how to merge multipart feature line? I work in version environmental and geometry network. Regards,
0
votes
0answers
12 views

Moving Vehicle through know digital data

I have a set of 3D digital map data for objects within an area. I want to drive a vehicle with known dimensions (3D points for extremities) through the area without hitting anything. I would have ...
0
votes
3answers
75 views

How to Build a graph from a map

I spent days looking in all questions here and trying tutorials. I need to build a graph for a region (It will be my input in simulation) I downloaded Postgresql and Postgis and osm2pgsql. Now i can ...
3
votes
1answer
216 views

Accessing data stored in related tables from a network dataset

According to ESRI's transit data model, this implementation, and several thesis papers, any non-spatial information (such as public transport schedules, employee info, trips etc) which is not stored ...
0
votes
1answer
622 views

How to find points inside each polygon in Mysql?

I have points table (with latitude and longitude columns) and polygons table with geometry stored in Mysql. I want to get points inside one polygon, for example in polygon which has column ...
22
votes
7answers
745 views

GIS Software Choice for a small university research centre

I need to choose a GIS system for a small university research centre. We are handling a broad range of data, (for example, numerical tidal analyses, weather data, poverty, isolated economic activity, ...
0
votes
0answers
42 views

How to improve performance using spatial indexing with STIntersects()

I am working on Spatial database. I need to check intersection of state geometry with geometry inside database. I am presently using the query as SELECT a.ID, a.OBJECTID, a.MSID, ...
3
votes
1answer
227 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 ...
3
votes
4answers
368 views

What Application for Vector and Cartesian Coordinate System

Goal: Visualize a picture in SQL server 2012 spatial data based on geometry Problem: In order to display a vector picture I need to retrieve X, Y coordinate (cartesian coordinate system) and ...
0
votes
1answer
24 views

Commercial Admin Levels

I'm looking to find commercially available admin boundaries (0 through lowest available) for the world that I can place into a user-friendly interface that allows the non-technical user (ie someone ...
0
votes
2answers
108 views

Error while creating spatial database connection

I'm using ArcGIS 10.0, and I've already created my database using "ArcSDE for PostgreSQL Post installation" .. My database is successfully created in PostgreSQL and now that I'm trying to create a ...
0
votes
1answer
28 views

how to see a base map created by map builder in database?

I am new in oracle, I tried to create a style, then different themes and then a base map. I saved all my work, but I can't see the base map in the database. Did I miss something? The interesting ...
3
votes
1answer
180 views

Problem PostGIS Spatial Query ST_Contains ST_Disjoint ST_Intersects

I'm working on a project with two different tables inside a database. One contains points in a column geometry(Point,4326) type and the second one has a column geometry(MultiPolygon,4326). Now I would ...
1
vote
1answer
65 views

Problem loading spatialite extension with sqlite3 Python connector

I am trying to load the Spaltialite extension using SQLite3 python module. I am getting the following error when I run my script. EOFError: [Errno 10054] An existing connection was forcibly closed ...
0
votes
3answers
59 views

ST_transform postgis

SQL within that zone is a point SELECT "public".zona.zts FROM "public".zona WHERE ST_Within ( ST_Transform ( ST_GeomFromText ( 'POINT(-30.033514 ...
9
votes
3answers
413 views

PostGIS (2.0?) - Native Versioning of the Datastore

I recently have been surprised to see there are not too many solutions at all discussing the best methods of versioning datastores which are made available for editing. I am looking for a robust, ...
0
votes
1answer
35 views

Integrate static database with spatial database

I have some questions about how to integrate static database with spatial databases. problematic: I have several static data bases on different platforms (Oracle, MySQL, SQL Server) I want to turn ...
0
votes
1answer
68 views

How to find within a geodatabase from the catalog window

I have a geodatabase containing hundreds of feature classes that I want to be able to search within so that I know which feature class to load. All the feature classes come from different data ...
3
votes
2answers
2k views

How to import ArcGIS 10.1 File geodatabase to MS SQL Server 2012?

I would like to import my File Geodatabase from ArcGIS 10.1 into MS SQL Server 2012. I have never done it before, so I expect to do the import the same way as import data from excel table. Problem ...
0
votes
1answer
28 views

managing postgresql database table using the pgadminIII sql tool

i have created a database using postgresql 9.1 and a table containing parcel information for a town council database on a windows 7 OS. i created the geometry column using the SELECT ...
0
votes
2answers
48 views

Appending fields from external tables to feature class?

I have some data in a relational database structure within a geodatabase i.e a feature class with several lookup tables. I need to flatten this data so that certain fields from the lookup tables are ...
0
votes
2answers
54 views

How to select the cross streets in postgis spatial table?

I've used ST_Intersects and ST_Crosses but between two different tables. I have a table of streets and intersections want to know them. For example select all streets that cross the Street A. Can ...
0
votes
1answer
77 views

What is the best way to manage geodata with open source software?

We are a small group of GIS users with different expertises embedded in an administrative infrastructure attempting to switch to a small and low cost open source infrastructure (open source GDI). ...
0
votes
0answers
33 views

Load Featureclass from ArcMap to a Database (sde) with Arcobjects

I have to develope an extension for ArcMap 10.2 that has to get spatial data from an Oracle Database, edit it and finally upload the changes. I create a scratch featureclass whit the data, I edit the ...
1
vote
2answers
96 views

Most optimal way to create a (spatial) database for big amounts of data?

I am using QGIS, and on my way to set up a huge spatial database (geographical), where most of the data is points without geometry), along with other types of data (like lines in DXF and areas in ...
0
votes
1answer
81 views

Import Shapefile on postgis doesn't show in QGIS

I'm currently working on a project about a database and some shapefiles. The database is built on PostGis with tables including some dots as geometry type columns. Once imported them on QGIS, I can ...
8
votes
4answers
3k views

Embedded spatial database for Java

Are there any embedded spatial databases for Java? I've come across H2 Spatial, but it was difficult to tell the status of that and if it can be used as an embedded spatial database. thanks, Jeff
0
votes
1answer
28 views

Can SpatiaLite Indexes be used from views?

I'm working with a large SpatiaLite database and trying to take advantage of some spatial indexes I have on my tables that I'm attempting to access through views. Essentially, I have a number of ...
1
vote
2answers
442 views

How to count number of feature classes in geodatabase using ArcPy?

I would like to count the number of feature classes in a geodatabase. Some of the classes are in feature datasets as well. I have tried get count management, but that returns the number of rows in ...
1
vote
1answer
28 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
0answers
25 views

Is it possible pull multiple documents out of a geodatabase?

I am working on a sliverlight application in which a municipality will be able to view multiple assets for a water treatment plant within a GIS. Within this application, the user will be able to pull ...
0
votes
0answers
13 views

project from mongodb to a map

Is there any way I can directly project my coordinates stored in mongoDB onto a map? Some sort of opensource tool like OpenJump or something, which would allow me to connect to mongoDB and extract ...
0
votes
0answers
58 views

How to create a many to one spatial join?

I have a polygon feature class of territories and a point feature class of trees. The points have many attributes, one of them is the tree species name. I need to get the list of all the tree species ...
1
vote
0answers
37 views

Using polygons with libspatialindex

I am investigating using some C/C++ libraries for point-in-polygon lookups and libspatialindex seems popular. I've written some code that seems to do what I want but I'm not entirely sure if what I ...
1
vote
0answers
55 views

Precision for an FGDB raster dataset?

I would like to know the precision for an ArcGIS raster stored within a file geodatabase (FGDBR format); I can't seem to find this information anywhere in their documentation (apologies if I have ...
2
votes
1answer
105 views

SpatialRefSys as foreign key

Using the working stuff reported here, I've written the following django model: from django.contrib.gis.models import SpatialRefSys class LandCover(models.Model): shp_name = ...
0
votes
4answers
2k views

Where can I find base data shapefiles for whole US?

I am looking for the base layers for whole U.S. - roads, hydrological lines etc with flexibilities of changing symbology and labels. TIGER is a good source but it is at county level. I am running on ...
6
votes
1answer
372 views

Metadata server and spatial server - a must? [closed]

I have been using ArcMap (only) for the past two years (read: newbie) in the oil and gas (upstream) industry. I currently have about 200 GB of files (shp, tif, grids, a few fgdb, all sitting in a ...
0
votes
1answer
71 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 ...
0
votes
1answer
102 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 ...
3
votes
2answers
63 views

Is transformation of spatial data lossy?

I have a shapefile that contains data of a country from the following Geographic Coordinate System ( GCS_North_American_1927 aka NAD27 ) contents from the shape file .prj: ...
17
votes
7answers
3k views

File Geodatabase Open API

Any ESRI boffins (insiders) know when this will be available? 2010, 2011? FINAL UPDATE now released 20th January 2011 - Can be downloaded here - ...
1
vote
2answers
178 views

Connect AutoCAD Map 3D 2014 with MySQL

I need to connect AutoCAD Map 3D 2014 with an Spatial MySQL database (version 5.5) but first I have to install "libmysql.dll" to connect as specified in the software user's manual. This file is ...
6
votes
3answers
472 views

Suggestions for an efficient way to store raster files for lab use?

I'm trying to create a repository for our raster files from various sources and Im exploring the possibilities on how to store them and deliver them in our local intranet. I have come across rasdaman ...
1
vote
0answers
13 views

ArcGIS 000210 error copy to feature class [duplicate]

I have a script tool that: Creates a feature dataset within a file geodatabase Performs a Select by Attributes on a cadastral layer Copies the selected polygons into the feature dataset. The copied ...
0
votes
0answers
44 views

Group Nearest neighbor query in SQL Server 2012 spatial database

I am looking for way to perform GNN query over road networks in SQL Server. Any pointers