search

kartoza / WBR-SEMP

0 stars 3 forks source link

create tables for value maps #20

Closed gubuntu closed 4 years ago

gubuntu commented 4 years ago

For each field that has a value map in the WBR Survey form in the QGIS project, create a table in the wbr.kartoza.com:gis.wbr_survey schema with the naming convention fieldname_valuemap

seabilwe commented 4 years ago

@gubuntu I checked everything in the tables and fixed the Boolean issue...those fields are not value maps anymore and I have removed the associated tables from the _wbr.kartoza.com:gis.wbrsurvey schema

gubuntu commented 4 years ago

what are the computer, radio and television tables?

Have a look at the survey_reporting_prep.sql to see how I'm using the lookup tables and valuemap tables to merge everything into a nice table, equivalent of doing the geopackage export with all lookups populated

seabilwe commented 4 years ago

Those are the value maps in the form, I had missed them on Friday when adding the tables.

Okay, I will go through it

gubuntu commented 4 years ago

they must have the same naming convention as the other tables.

seabilwe commented 4 years ago

I fixed that