Mercurial > dive4elements > river
comparison flys-backend/contrib/shpimporter/dgm.py @ 5546:5b50247d4d99
Use latin1 as encoding in the dgm importer to make it easier matching latin1
csv values
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Thu, 04 Apr 2013 10:23:17 +0200 |
| parents | f1009aa7dcd1 |
| children | 8d2c576b5a40 |
comparison
equal
deleted
inserted
replaced
| 5545:ed149d5d7fb7 | 5546:5b50247d4d99 |
|---|---|
| 1 # -*- coding: utf-8 -*- | 1 # -*- coding: latin-1 -*- |
| 2 | 2 |
| 3 import codecs | 3 import codecs |
| 4 import utils | 4 import utils |
| 5 import datetime | 5 import datetime |
| 6 | 6 |
| 12 | 12 |
| 13 | 13 |
| 14 # <dbfield> : (<csvfield>, conversion function) | 14 # <dbfield> : (<csvfield>, conversion function) |
| 15 DGM_MAP = { | 15 DGM_MAP = { |
| 16 "projection" : "Projektion", | 16 "projection" : "Projektion", |
| 17 "elevation_state" : latin("Höhenstatus"), | 17 "elevation_state" : latin("Höhenstatus"), |
| 18 "format" : "Format", | 18 "format" : "Format", |
| 19 "border_break" : ("Bruchkanten", | 19 "border_break" : ("Bruchkanten", |
| 20 lambda x: True if x.lower() == "Ja" else False), | 20 lambda x: True if x.lower() == "Ja" else False), |
| 21 "resolution" : (latin("Auflösung"), lambda x: x), | 21 "resolution" : (latin("Auflösung"), lambda x: x), |
| 22 # "description" : | 22 # "description" : |
| 23 "srid" : "SRID", | 23 "srid" : "SRID", |
| 24 "path" : ("Pfad_Bestand", lambda x: x), | 24 "path" : ("Pfad_Bestand", lambda x: x), |
| 25 } | 25 } |
| 26 | 26 |
| 109 | 109 |
| 110 river_id = utils.getRiverId(dbconn, river_name, oracle) | 110 river_id = utils.getRiverId(dbconn, river_name, oracle) |
| 111 for line in csvfile: | 111 for line in csvfile: |
| 112 fields = line.split(";") | 112 fields = line.split(";") |
| 113 if not fields: continue | 113 if not fields: continue |
| 114 if fields[namedict[latin("Gewässer")]] != \ | 114 if fields[namedict[latin("Gewässer")]] != \ |
| 115 unicode(utils.getUTF8(river_name),'UTF-8'): | 115 unicode(utils.getUTF8(river_name),'UTF-8'): |
| 116 continue | 116 continue |
| 117 else: | 117 else: |
| 118 values=[] | 118 values=[] |
| 119 for key, val in DGM_MAP.items(): | 119 for key, val in DGM_MAP.items(): |