Adding coords and areas to db
Posted by mholmes on 23 Nov 2017 in Activity log
I figured out how to use QGIS to generate a GeoJSON file with areas in it, and documented that in the protocol document; then I wrote some JS for nodejs to generate SQL update statements to add that data to the db. I created two new fields in the landscapes_dev (my testing db):
ALTER TABLE `props` ADD `prp_coords` VARCHAR( 256 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD `prp_area` DECIMAL( 8, 2 ) NULL ;
Took backups of the dbs, then merged the new data into it. There are 262/1079 Powell St lots without coords/area, and 56/1120 Maple Ridge.