search

pnoll1 / osmand_map_creation

OSM data + open address data compiled for use in OSMAnd
GNU General Public License v3.0
79 stars 2 forks source link

Geometry has Z dimension but column does not #88

Closed pnoll1 closed 8 months ago

pnoll1 commented 8 months ago

Describe the bug Program errors out with 

psycopg.errors.InvalidParameterValue: Geometry has Z dimension but column does not

To Reproduce Steps to reproduce the behavior, Mention an exact address if possible:

  1. Use OA global data from 3/16
  2. processing.py with batches = ['--normal us:ak us:hi us:mt us:ut us:nv us:az us:nm us:wy us:wa us:or us:id us:co']
  3. console will error out with above error from postgis

Expected behavior No errors.

Additional context Need to find offending file. Does the file have z coordinates? If so, why? Improve error handling and/or logging in merge_oa.

pnoll1 commented 8 months ago

us/wa/wakiakum-addresses-county.geojson has z data that is mostly, if not all zeros.


{"type": "Feature", "properties": {"hash": "2a7175361ea6f935", "number": "34", "street": "BARR ROAD", "unit": "", "city": "ROSBURG", "district": "", "region": "", "postcode": "98643", "id": ""}, "geometry": {"type": "Point", "coordinates": [-123.6361676, 46.32554, 0.0]}}
pnoll1 commented 8 months ago

fixed in 0b30b4bd8b7aef567e9a0b69199f713a18102998