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.
6
votes
4answers
2k views
List of language codes by country
Does anyone know of a list of countries with their associated official language codes? I haven't found anything by Googling yet.
What I'm looking for is something like this:
Country name/code ...
6
votes
1answer
234 views
Why can't I access a table in a personal geodatabase (.mdb) with arcpy after installing 64-bit geoprocessing?
I wrote and ran a simple script last year - it cycled through some line features, buffered them and then intersected with some other lines - it all worked fine.
I'm now trying to tweak the file to ...
6
votes
3answers
245 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.
...
6
votes
1answer
124 views
Standard for storing human metadata in spatial databases
Is there an existing, standard, universal approach (and hopefully existing tools that support managing it) for storing geospatial metadata in non-ESRI spatial databases alongside (and therefore able ...
6
votes
1answer
322 views
Metadata server and spatial server - a must?
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 ...
5
votes
4answers
592 views
Given long, lat, x and y, how do I find the projection?
I am using an app called farsite that outputs shapefiles that show how forest fires will grow. I am getting output in coordinates as X and Y values rather than (lon,lat) and am looking for a ...
5
votes
6answers
1k views
How to get “.GDB” Esri File Geodatabase in QGIS for MAC OSX 10.6?
I understand there are programs like OSGeo4W that allow windows users to work with File Geodatabases, but is there something similar for Mac OSX?
5
votes
3answers
1k views
How to export shape file to SpatiaLite
I have a shapefile with one layer. I can open it with QGis. Now I want to convert this shapefile or layer to Spatialite database. How can I do it? Is it possible to do with QGis?
5
votes
1answer
2k views
How to create a tables from existing tables (applying new schemas) in postgis DB?
I have a table that is geospatially enabled; that contain world borders. I want to break it down to different schemas (global, europe etc..) . My thought is to use use something that looks like this:
...
5
votes
2answers
372 views
Spatial metadata table in SQL Server 2008
I have a db and want to know if it contains any spatial tables. Is there a table in SQL Server that holds spatial metadata i.e. a list of all the spatial tables in the current db? Oracle has the ...
5
votes
2answers
324 views
Reduce Tracking Data Set
I'm building an application that uses data from GPS units on board vehicles and displays it on a map. A lat/long is recorded every .5 seconds and a session can be many hours... this can add up to be a ...
5
votes
5answers
862 views
What are convenient uml tools to create geodatabase models?
I used to model databases with Microsoft Office Visio, then export the model to xml and import geodatabase schema to GDB with ArcGIS tools.
Since Microsoft no longer support Visio export to xml, what ...
5
votes
2answers
245 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 ...
5
votes
2answers
2k 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 ...
5
votes
1answer
110 views
Looking for open-source solution to show map with massive objects(3x3 polygon) on a web site
I don't have much experiance in GIS systems.
I am developing a web site which need to show a map with 3m x 3m rectangles for a radius of about 400 meters.(about 58,000 polygons for one location)
I ...
5
votes
1answer
155 views
File Browsing Dialog for Tables in Spatial Databases
I am looking for a file browsing object that allows a user to navigate into the different types of geodatabases. For example, the ability to navigate into a Spatialite/PostGIS/ESRI File ...
5
votes
1answer
116 views
Grid Analysis from samples data
I'm trying to analyze set of samples into vector grids in order to generate average data in corresponding grid.I'm working with 50m separated grids but the size of grid may change over time.That's why ...
5
votes
1answer
524 views
Reset Object ID After Truncating Table In SQL Server
I am working on a program to export data from a view containing a geometry type in Sql Server 2008, to an ArcSDE table on another server which also stores data using the geometry type. The source ...
5
votes
1answer
655 views
How to create adjacency matrix of topology graph of arc map for shortest path?
I have created a topology graph of a polygon feature and I want to find the individual FIDS of the lines of the polygon. I want to construct an adjacency matrix to create the shortest path. How can I ...
4
votes
2answers
1k views
What are spatial and attribute indexes?
What is the difference between a spatial index and an attribute index.
What are their purposes?
4
votes
2answers
160 views
Which Geodatabase supports SQL and is easily portable?
I want to choose the geodatabase type, which could be:
permits direct sql queries.
easily portable, because the app would installed in one computer.
I know that the personal geodatabase is a good ...
4
votes
3answers
234 views
How to test whether two countries are adjacent?
I have an interesting question:
Is there a dataset by which I can use to test whether two countries are adjacent? For example, if inputs are Mexico and U.S., they are adjacent; if inputs are England ...
4
votes
1answer
161 views
SQL Server data modelling + spatial data = what book?
What recommended book can you provide about data modelling for geographical spatial data (geometry) in SQL server?
4
votes
1answer
302 views
Creating a table containing all filenames (and possibly metadata) in a File Geodatabase
I need to create a metadata-table for all files in a File Geodatabase or Spatial Database. It would be awesome if it were possible to automatically be updated with new filenames, and possibly even ...
4
votes
3answers
1k views
Delete a feature data set in SDE 10 programmatically
Is there a way to delete a feature data set and all of its feature classes programmatically either by using custom code or pre-existing command line tools?
There is a tool provided by SDE called ...
4
votes
2answers
99 views
How to determine lock on file geodatabase?
I'm trying to delete a file geodatabase through Windows Explorer but I get the error message:
The action can't be completed because the folder or file in it is open in another program. Close the ...
4
votes
2answers
145 views
PostGIS stored procedures
I am wondering if there are open source applications that make extensive uses of the special functions (the ST_* stored procedures) provided by PostGIS? I found many apps that support storing map data ...
4
votes
2answers
483 views
Is there a performance hit from using a Feature Dataset?
I vaguely remember being taught not to use a Feature Dataset to make things "look neat" in the database, and that the Feature Dataset should only be used when there was some sort of spatial ...
4
votes
1answer
48 views
Change the Default geodatabase in ArcGIS 10?
In a multi-user environment I have a need to be able to configure ArcGIS so that it uses an SDE connection as the default geodatabase instead of the Default.gdb in each users' profile. What is the ...
4
votes
3answers
731 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
4
votes
1answer
147 views
Geometry Operands - BBOX vs Within - What's the difference?
What is the difference between the "BBOX" and "Within" spatial operators.
Can anyone please shed some light?
4
votes
1answer
56 views
Distributed versioning of geospatial data
I'm getting started on the design of a new system that would reconcile, merge, and synchronize changes made across numerous geospatial databases of common ancestry, on an ongoing basis. These ...
4
votes
1answer
89 views
How to Reduce Decimal Precision of Image Value in ArcGIS?
I'd like to ask about the value on following image.
This is an interpolated precipitation layer using IDW method in Arcgis. On this layer, the values is like this:
This is a raster image. After ...
4
votes
1answer
142 views
Is it possible to run an arcpy execute SQL method without connecting to any database or server?
I want to simply process a layer by writing a tool script in a toolbox without having to connect any database, so I think I may have to set up a workspace environment in ArcMap, but I'm not sure if I ...
4
votes
2answers
160 views
Calculating the space a feature class will use in ArcSDE?
Is it possible to get a good estimate on how much space a feature class will take once loaded into ArcSDE from how big they are in a FGDB? I have some feature classes in a FGDB, where some are a few ...
4
votes
1answer
869 views
ArcSDE - Registering table with Geography spatial column fails with error -138 (SQL Server 2008)
I have a table of point features I am trying to register with ArcSDE (9.3.1 on SQL Server 2008) using the following command:
sdelayer -o register -l ThirdPartyWellsSurface,Shape -e np -C OBJECTID,SDE ...
4
votes
0answers
34 views
Spatial data visualization level of detail [migrated]
I have a 3D point cloud data set with different attributes that I visualize as points so far, and I want to have LOD based on distance from the set. I want to be able to have a generalized view from ...
3
votes
3answers
1k views
Writing a plugin for Qgis using python to access PostGIS and write geometries
Sorry about the strange title didn't really know how to word it.
I currently use MapInfo to do most of my GIS work however I have recently installed PostGIS 1.5 and am really liking it so far. A ...
3
votes
3answers
2k views
STDistance Unit in SQL Server 2008
I've got a SPROC in SQL Server 2008 where I'm trying to calculate the distance between a point and a polygon, and I'm getting unexpected results. I am passing a parameter (@Radius) in miles to the ...
3
votes
2answers
154 views
3
votes
3answers
631 views
Spatial Database Design (PostGIS) - Point data that doesn't always have spatial data
I am creating a spatial database using PostGIS.
I am storing the attributes and location of some species records that can be represented as points. The records are recorded from either:
a) static ...
3
votes
2answers
326 views
Visualize feature class with many relationship classes?
I have a feature class in a geodatabase that I want to review.
It has many relationship classes - possibly a hundred or more. If I load the feature class into ArcMap and identify one of the ...
3
votes
4answers
760 views
Creating a multiversioned view with ArcSDE and SQL Server 2008 R2
I am using the administration command sdetable -o create_mv_view to create a multiversioned view on a table in SQL Server 2008 R2.
Everything appears to be working correctly with one exception: The ...
3
votes
2answers
125 views
Several questions about using spatial data?
If you have spatial data for SQL server, can you use the spatial data (both geometry and geography) in another application for instance ESRI ArcGIS?
Is spatial data a standard that every GIS ...
3
votes
3answers
265 views
Do you know of any project that stores features in a NoSQL database like Cassandra?
I'm a Master's student and software developer and I want to make a new contrib development based on NoSQL databases like Cassandra. Does anyone know any people, University or Research Group who works ...
3
votes
1answer
303 views
Does MySQL only support bounding boxes calculations instead of the real polygon geometry?
Within our company we are deciding which DBMS we will use to store spatial data. IT wants MySQL with the Spatial extension because there is already knowledge about handling MySQL DB. We are doing ...
3
votes
2answers
496 views
How to read MapInfo .tab files in ArcPy?
I want to use arcpy (the ESRI install of python 2.65) to analyse tab files...can this be done directly or do I need to convert them to shp files...if so would it be possible to do something like
...
3
votes
2answers
66 views
Where can I find spatial data on polar fish populations?
Where can I find spatial data on polar fish populations? I am looking specifically for polar cod, but any fish will do at this point in my project. I also need arctic ocean salinity, temperature, and ...
3
votes
2answers
101 views
Is there any site which provide classified image download for soil,vegetation or water resources?
(its particularly for indian states,i need.....,but kindly quote if any other info you have)
the raster data may also work for me in above aspects.
3
votes
2answers
119 views
LRS schema error in Oracle SDO_NET when validating network
I have a problem with the Oracle Spatial Network package. I'm creating NODE, LINK and PATH based on LRS. When I try the call:
SELECT SDO_NET.VALIDATE_NETWORK('network_tracking') FROM DUAL
then I ...
