I would like to know how to get copy a specific columns from the database and add that column in a shapefile attribute table? I am open to other better ideas.
Asked
Active
Viewed 58 times
0
-
According to your diagram, there is nothing to join on, which makes the task several orders of magnitude more difficult. – Vince Jan 15 '19 at 15:49
-
Yes, By creating a common column will help in joining them ? – roshualine Jan 15 '19 at 16:08
-
Only if it contains data that permits the join. – Vince Jan 16 '19 at 03:45
-
I would solve your problem as follows: 1) if you have a file on your left, this means that it has a geom field and I would convert it to SRID 4326, i.e. transformed the coordinate systems into a common SC; 2) I would do the same in the database, i.e. created a geom field ... 3) link two tables along a common geom field + field id...Remember you should know the original SC ... – Cyril Mikhalchenko Jan 16 '19 at 06:24
-
Thank you @Cyril I follow the suggested method and revert back. – roshualine Jan 17 '19 at 12:39
-
Can you create an * .shp file based on a table from your database, taking into account the geometry field? – Cyril Mikhalchenko Jan 17 '19 at 16:53
-
Yes probably convert it into a .shp and perform something like join attribute by location – roshualine Jan 18 '19 at 10:53
-
Created geometry for both table and did a 'sjoin' using python geopandas and it worked. Thanks. (https://gis.stackexchange.com/a/208574/130884) – roshualine Jan 30 '19 at 08:05