Tag Info

New answers tagged


I'm not sure I understand your question, but GeoServer has a SQL Server Plugin: http://docs.geoserver.org/stable/en/user/data/database/sqlserver.html if that is what you are after. It comes with PostgreSQL database support natively.


You can use Foreign Data Wrappers, as of Postgres 9.2 (I think), from within Postgres to register a connection to another data source, either a Postgres server on another machine, or a completely separate data source. CREATE EXTENSION postgres_fdw; CREATE SERVER foreign_spatial_lite FOREIGN DATA WRAPPER postgres_fdw OPTIONS (dbname 'some_dbname', ...


You can only connected to one (and only one) database in the DB Manager to run the SQL window. So this is not possibly. Either your way of cloning the data, or making the join inside QGIS in the Properties > Joins tab of one of the layers.


Well, in that kind of tasks I always prefer to export to dxf the shape file and use AutoCad to divide the lines, that software have a lot of tools you can use and for me is more simple; after that, I import the DWG file to SHAPE... but it always depends on the data base, If the database is big maybe is better to look for another way to do it!!!


I would say yes, for reasons other than performance. In my experience using a File geodatabase (if you're not talking about an enterprise DB) makes things a little easier to handle in Arc. Shapefiles have some limitations that you could run in to later. geodatabases might help you keep things organized and contained. Exporting from a FileGDB with Arc is ...


Im not sure if you have to a FDOtoolbox solution or if that is just your preference, because another good option for this sort of work is ogr2ogr. Once it is installed you can just run something like this from the command line. ogr2ogr -overwrite -f "PostgreSQL" PG:"host=myhost user=myuser dbname=mydb password=mypass" my_file.shp I hope that helps, Rowan


No, it's not possible to recycle the database, as both tools do very different tasks and therefore they create very specific datastructures to run nice and smooth. Please import another time your DB dump for mapnik, as explained here: www.switch2osm.org

Top 50 recent answers are included