search

alan-turing-institute / solar-panel-detection

Solar Panel Detection (Turing Climate Action Call)
23 stars 6 forks source link

Include an OSM table derived from the PBF/XML directly in addition to Dan S csv #6

Open edwardchalstrey1 opened 4 years ago

edwardchalstrey1 commented 4 years ago

Use this? https://wiki.openstreetmap.org/wiki/Osm2pgsql#Mac_OS_X

edwardchalstrey1 commented 4 years ago

I have tried to use the tables generated from osm2pgsql to get things like the “name” and “description” which will be useful for matching to some of the REPD site names. This seems to be very difficult and it probably makes more sense to work out how to get these things as their own columns via configuring osm2pgsql properly, or using the XML file instead of the PBF. Perhaps since Dan’s python script generates the CSV using the XML, we can modify it to include extra columns by working out how to run the script and then making edits.