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.

  • 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 3: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 6:24
  • Thank you @Cyril I follow the suggested method and revert back. – roshualine Jan 17 '19 at 12:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.