def     clear_publicmapping_db():
        db = dbapi2.connect (database="publicmapping", user="publicmapping", password=PUBLICMAPPINGPASS)
        cur = db.cursor()
        redtable=["redistricting_characteristic","redistricting_computedcharacteristic","redistricting_computeddistrictscore","redistricting_computedplanscore","redistricting_contiguityoverride","redistricting_district","redistricting_geolevel","redistricting_geounit","redistricting_legislativebody","redistricting_legislativedefault","redistricting_legislativelevel","redistricting_plan","redistricting_profile","redistricting_scoreargument","redistricting_scoredisplay","redistricting_scorefunction","redistricting_scorepanel","redistricting_scorepanel_displays","redistricting_scorepanel_score_functions","redistricting_subject","redistricting_target","redistricting_validationcriteria"]
        for i in redtable:
                cur.execute("truncate table %s CASCADE" % i)
        db.commit()
        db.close()

### Drop DB
dataset/ETHPy150Open PublicMapping/DistrictBuilder/docs/loadcensus/configureCensus.py/clear_publicmapping_db/original