New answers tagged spatial-database
0
ST-Links SpatialKit is an ArcMap Extension for directly connecting to spatial databases with No ArcSDE, No ArcInfo, No ArcGIS Server.
According to their License, it costs $188 CAD, but they state "We will continue to issue free licenses for those users that can not afford the license fee. Free licenses have time limits. If you request a free license, ...
3
I wrote a plugin that gives ArcGIS access to 50+ vector formats (including PostGIS). It is still experimental, but you can try it out and tell me how it goes.
There are advantages of using this approach over the built-in functionality in ArcGIS (look at the FAQ), but again, it is still experimental.
Download and instructions here
1
GISquirrel does the job at a fraction of the cost of SDE. It supports arcgis connection to both MSSQL and PostGIS. Very simple to setup (able to import to postgres from shapefile/featureclass) and simple to maintain. For a small number of users who need multi-user edit capability, its just fine.
We use GISquirrel/Arcgis for our GIS 'power users' and QGIS ...
1
ArcGIS 10.1 SP1 can connect to PostGIS 2.0.0 databases natively, but the connection is read-only, and mostly functions as a cleaner front end to query layers (in fact, it just loads any layers as query layers). The database connection just allows you to view all the tables and layers in the database in catalog.
As an alternative, there is also ...
3
If you have ArcEditor or ArcInfo desktop level, you have the ability to use SQL Server Express. Even though only one user can edit at a time, the locking and unlocking may be better -- you might try this out first. There lot's of documentation on how to do it, and you don't have to be a dba -- though I like postgres. No offense QGIS folks ;)
Also, make sure ...
-1
Yes, it is fairly easy provided you have the necessary license level of Arc Server. I believe Arc Desktop Standard or Advanced will work these days.
EDIT: Although the post isn't specific, I should have assumed the poster does not have this license.
Setting up postgreSQL for ESRI:
...
4
Setting the Default GeoDatabase is super easy. Follow this link here to see the ESRI tutorial on this: Setting the default geodatabase. You can set this to an SDE connection as well if that is an issue. Create a base MXD with the SDE as the default GeoDatabase. Create a shortcut for it and instead of having your users open ArcMap with the normal ArcMap exe, ...
0
For PostGIS and SpatiaLite use ST_LineMerge (in Oracle Spatial it is something similar like ST_LineMerger). ST_LineMerge is different to a simple union operation in that it does not consider the order of the vertices (as stored in the database) but returns a linestring where the lines are joined topologically. This avoids unwanted jumping back and forth. ...
Top 50 recent answers are included
