All Questions
Tagged with sql-server postgresql
23 questions
0
votes
0
answers
107
views
Using UNION ALL with view table
I have table in multiple schemas, the table in all schemas have the same columns number and type so i'm trying to combine all table data into view table using UNION ALL as shown
CREATE VIEW "...
0
votes
0
answers
67
views
Moving tables with spatial data from SQL Server to PostGIS
I need to move tables with spatial data from SQL Server running on a server to PostGIS on another server daily.
My current method is using geopandas to read the tables then writing the tables to ...
- 23
1
vote
0
answers
51
views
QGIS - Connect to DB using Task Manager (problem)
As I have a lot of layers, I am writing a plugin that will import layers through TaskManager. Script imports layers successfully into the project with some minor problems. When layers are loaded I can ...
- 11
1
vote
0
answers
76
views
Setup a QGIS model to run on an Ubuntu server automatically
I made a QGIS model tool that pulls a copy of two datasets from a MSSQL db and runs several sets of geoprocessing tasks and outputs a single resulting dataset to a pgSQL db.
This process runs ...
- 138
6
votes
2
answers
2k
views
Speed difference MS SQL Server 2019 to PostgreSQL/PostGIS 12 for spatial data
I imported a shapefile with 3000 polygons in UTM 25832 into both databases MS SQL Server 2019 and PostgreSQL/PostGIS. Then I calculated a buffer of 1000 meters around these geometries and transferred ...
- 631
1
vote
0
answers
364
views
ArcGIS Pro PostgreSQL SSH connection string
I am involved in a project where a SQL Server-base application is being retired and replaced with a PostgreSQL/PostGIS-based tool under development. There is a large amount of cross-checking to be ...
- 11
1
vote
2
answers
674
views
How to convert an insert SQL query to a PostGIS layer?
I have hundreds of rows from a SQL Server query which I would like to convert to a PostGIS layer in PostgreSQL
Example of the query:
INSERT INTO `qv` (`id`,`qv`,`st_astext(t.Shape)`,`center_shape`,`...
- 1,189
1
vote
1
answer
2k
views
Data Migration: PostgreSQL (PostGIS) to SQL Server 12
I'm migrating data from a PostgreSQL database (with PostGIS), which contains geospatial data to SQL Server '12 and having some import errors. I'm assuming these errors are due to the geospatial data ...
- 155
2
votes
1
answer
1k
views
PostgreSQL Foreign Data Wrapper (MSSQL)
I'm trying to do some slow migration from a MS SQL Server 2008 R2 to a PostgreSQL 9.5 + PostGIS.
I created a FDW in PostgreSQL to access my MSSQL data and I imported most of my tables, but a few ...
- 101
0
votes
1
answer
521
views
Can updates be made to "ogr_fdw" foreign tables in PostgreSQL?
I am accessing a Microsoft SQL Server table (w/ SQL Server a geometry column) via an ogr_fdw foreign table. SELECT statements work great, including the PostGIS functions that I've tried.
Are UPDATES (...
- 14.7k
0
votes
1
answer
90
views
How Update one table row with combare with the other polygon table using their geom in SQL Server
a-> points
b -> Polygon
i want to update city trow in table a with compare b of geom in SQL server
this is the PostgreSQL Query
update a set city=b.name from b where st_contains(b.the_geom, a....
- 115
2
votes
0
answers
449
views
How to create MBtiles from geoserver [closed]
How to generate mbtiles in geoserver? using openlayers for displaying geoserver layer
for example calling wms layer like this
new OpenLayers.Layer.WMS("Kanpur", "http://localhost:8080/...
- 115
1
vote
0
answers
84
views
GeoWebCache Speed SQL Server Store
How to increase GeoWebCache speed, Am using geoserver 2.7.2 for tile cache and data store creating from a SQL Server database it will take 1 day and above to complete cache and it terminated several ...
- 115
2
votes
0
answers
60
views
Need help deciding on a database and datatype [closed]
I realize that these questions should probably be directed to a DBA but I feel like you might have some experience in managing the same kind of data.
We have an existing system where we are storing ...
- 21
1
vote
1
answer
156
views
Access SQL database in postgres for routing
i am trying to access sql database in pgadminIII. Using postgres_fdw I am trying to connect. But I am struck in the middle..Following are the steps I followed
CREATE EXTENSION postgres_fdw;
CREATE ...
- 405