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.
8
votes
6answers
197 views
Is there a way to connect to PostgreSQL in ArcCatalog without SDE? [duplicate]
Is there a way to connect to PostgreSQL in ArcCatalog without SDE? I came across this post from 2011 that suggested using zigGIS but I can’t find a working link to the program.
A little background: ...
0
votes
0answers
42 views
copying and pasting files - geodatabase
I have been sent a zipped folder containing files in a geodatabase format. To view them in ArcMap I've created a new file outside
ArcCatalog with the extension .gdb and copied the unzipped files into ...
3
votes
1answer
73 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 ...
3
votes
3answers
140 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 ...
4
votes
1answer
44 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 ...
2
votes
1answer
53 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 = ...
2
votes
1answer
26 views
Importing labels for check in/out from an SDE to file geodatabase
I am working on a large project where I am using the ArcMap 10 'distributed geodatabase' feature to check out a file geodatabase from our SDE file. I have tried several ways to avoid having to ...
18
votes
3answers
561 views
What are the differences between spatial databases?
What is the difference between Oracle Spatial, PostGIS, SQLServer2008, SpatiaLite, and MySQL in terms of their spatial support. Are there specific use cases where each shines. What might you want to ...
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 ...
1
vote
1answer
30 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,
2
votes
1answer
52 views
point of intersection issues
I have a table containing a set of points of intersections.
Most of the roads intersects whith just one road BUT i have some roads which intersects with two, therefore three different point of ...
4
votes
2answers
89 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 ...
3
votes
2answers
48 views
Merge two geodatabases with identical structure
I'm using an ArcGIS addon which stores all created data (shapes and tables) in a gdb. The addon is made for single user use but to safe time I want to split the work with someone else. After that I ...
0
votes
1answer
37 views
Schema for offline map editing and pass to production environment
I'm working with QuantumGIs and PostgreSQL/Postgis. So when I edit the layers, the changes are reflected on the DB.
The thing is I want to do some "offline" editing before committing the changes to ...
3
votes
2answers
178 views
Visualize Spatial Data in Reporting Service
Is it possible to visualize a piece of geographical map from SQL server Spatial data (geometry, not geography) in a report from reporting service? If yes, how should it be done in a course of action.
...
1
vote
0answers
27 views
Solve Mysql Spatial error
Converting shp2mysql will leads an null value in geom filed. how to rectify the the problem.
shp2mysql -s 32643 landuse landuse LIS >landuse.sql
4
votes
3answers
725 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
0
votes
1answer
160 views
How to import ArcGIS 10.1 File geodatabse to MS SQL Server 2012
Hello I´d like to import my File Geodatabase from ArcGIS 10.1 into MS SQL Server 2012.
I´ve never do it before, so I expect to do the import same way as import data from excel table.
Problem is ...
0
votes
1answer
40 views
Correlation and terrain databases [duplicate]
I would like to know what kind of computation I could perform on a terrain database.
I'm making terrain for VBS2 from raw data (shp files and DTM Elevation files) and then I'd like to be able to check ...
0
votes
1answer
111 views
Problem inserting new features to file geodatabase feature class using ArcObjects 10 SDK
I'm trying to add new feature to file GDB feature class and keep getting this error: Objects in this class cannot be updated outside an edit session. Feature class has attachments enabled (exists ...
1
vote
0answers
36 views
Determining the SRID of a dataset in PostGIS [duplicate]
Sometimes the dataset provides some information about its projection. For example, it can mention Horizontal_Datum_Name: North American Datum of 1983, Ellipsoid_Name: GRS1980, ...
0
votes
0answers
12 views
Units of Geometry & Geography data type [duplicate]
When you store data using the Geography data type (like in PostGIS), is it always in lon/lat in degree decimals?
For the Geometry data type, what are the units used in the coordinate pairs? Can it ...
2
votes
0answers
219 views
Which one is better ?SQL server 2012 or Oracle 11g
I want to learn a database server, SQL server 2012 or Oracle 11g . I surf in the internet to compare SQL server and Oracle for spatial data and found good websites such as gisboston.it was very ...
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:
...
4
votes
2answers
159 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 ...
6
votes
2answers
1k views
Spatially enabled Postgres database
I am trying to create a spatially enabled PostGIS database. I am following the PostGIS documentation, http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2648455.
In the short ...
2
votes
2answers
51 views
Spatialite as a DBMS-server with GeoDjango?
I would like to add a spatial component to my Django application. I turned out to GeoDjango immediatly. I am wondering now if spatialite could be used as DBMS-server for an application in Prod. Grosso ...
1
vote
3answers
78 views
Copying schema of Postgis or Spatialite DB to blank one
I want to copy a Postgis or Spatialite DB sctructure (features, tables) to a blank DB. In ArcGIS i can easily handle it by using XML Workspace Document. Fisrtly extact it from a Geodatabase and than ...
2
votes
1answer
67 views
Join feature classes from two ArcSDE geodatabases with same schema?
I am working with two ArcSDE geodatabases -- one for test, one for production. They both have the same schema. I recalculated an attribute in the test environment and wanted to push that to ...
1
vote
0answers
101 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
2answers
75 views
Can I incorporate an existing DBF file with coordinates for Tiff tiles into geodatabase like spatialite?
I have 285 Tiff files that make up the 1:10000 OS map of Norhtern Ireland. I am having problems running QGIS when I try to load all 285 tiff files in for base maps (I think the memory on computer is ...
6
votes
1answer
222 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 ...
2
votes
1answer
262 views
Error creating a spatial database. ERROR : could not load library “/usr/pgsql-9.1/lib/rtpostgis-2.0.so”
I am running PostgreSQL 9.1 with Postgis 2.0 on Fedora 15.
When trying to install the raster support,
psql -d mydb -f rtpostgis.sql -v ON_ERROR_STOP=1
I get the following error
...
0
votes
1answer
40 views
Is there any way to view maps in “perspective” with ArcGIS (ArcMap do not)?
I need to work with ArcGis by the amount of data that I use and the answers I need, but would like to see my maps in perspective and I can't find a way. Does anyone knows how to do it?
7
votes
3answers
2k views
Poor Performance when using Spatial Indexes in MySQL
Re-post of a question asked on Stack Overflow when it was suggested this would be a better forum.
I'm trying a little experiment at pushing a data set which is not geo-spatial but fits it quite well ...
-1
votes
3answers
150 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 ...
4
votes
2answers
159 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 ...
3
votes
1answer
120 views
Routing with multiple points
I am using postgreSQL, postGIS and pgrouting. Now I am really confused on how am I going to find the shortest path between multiple points.
I know how to find it between two points through dijkstra ...
2
votes
1answer
73 views
postgis values within XYZ viewport in openlayers
I got this XYZ server where I get my maptiles.
Now, when the user is at zoom level 1 ( closest). I want it to execute a command that gets the current viewport from the map and Queries my PostGIS ...
3
votes
2answers
123 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 ...
4
votes
1answer
299 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
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 ...
2
votes
0answers
155 views
Does anyone know of a 'best practice' Seabed Survey Data Model (SSDM)?
Many of the offshore oil/gas companies are adopting an initiative from Shell for delivery of spatial data. This is called an SSDM, which is really an ESRI file geodatabase with a standardised ...
16
votes
2answers
207 views
Is there a standard data model for storing traffic volumes, layout, lanes, timing and phasing information?
I am at a crossroads where I want to store more than a scenarios worth of project data from a Synchro study, but do not want to keep this data in a series of text files. The data output by Synchro is ...
7
votes
2answers
207 views
How to create something similar to GDB in QGIS?
I used to work with ArcGIS. There I had geodatabases in which I could store several shapefiles with defined layer styles.
Is there a way to do something similar with QGIS?
The background is: we are ...
7
votes
2answers
7k views
How to insert a point into postgis?
I have created one table in my Postgis. But I can not insert point. I do not know what's wrong with my query?
CREATE TABLE app (
p_id INTEGER PRIMARY KEY
);
SELECT ...
3
votes
1answer
138 views
How to Get the Three Nearest Points to an Object (different layer)?
I have two point shapefiles and I want for each point in the 1st shapefile to get the 3 closest (based on air distance) points from the 2nd shapefile.
If possible, it would be great to have each of ...
1
vote
2answers
98 views
mulitlinestring to linestring
I am using postgres with postgis and I have a set of points which I would like to interpolate with a set of lines.
Now my problem is that the set of lines are of type multilinestring.
Is there a ...
0
votes
0answers
59 views
What kind of unit of measurement for scale does SQL Server 2012 Spatial use?
What kind of unit of measurement for scale does SQL Server 2012 Spatial use?
0
votes
0answers
74 views
SqlGeography STArea for CW and CCW polygons
I'm using a SqlGeographyBuilder to make a simple polygon (with SRID of WGS84). When I add the vertices CW and call the STArea() method, The area would be very large. When I add the vertices CCW and ...
