Geocoding France polygon does not include 'Corsica' - Githubissues

CartoDB / data-services

CARTO internal geocoder PostgreSQL extension

25 stars 11 forks source link

Geocoding France polygon does not include 'Corsica' #213

Closed ernesmb closed 8 years ago

ernesmb commented 8 years ago

When we use the geocoding functions to get the France polygon, it does not include the Corsica region nor any other non-continental regions of France.

Steps to reproduce

Use geocoding function to get France admin0 polygon: SELECT ST_Transform(cdb_geocode_admin0_polygon('FRA'), 3857) AS the_geom_webmercator
Or try to geocode a table containing France or FRA
Expected result

The returned polygon should include 'Corsica' and the other islands, as the world_borders_hd and world_borders datasets do: screen shot 2016-03-08 at 17 46 17

Current result

The returned polygon does not include 'Corsica' or any other peripheral french region screen shot 2016-03-08 at 17 45 26

rafatower commented 8 years ago

Totally debatable when it should include Corsica, La Réunion or any other overseas departments.

rafatower commented 8 years ago

FYI: it was already changed to exclude them

iriberri commented 8 years ago

Yes, this is on purpose.

iriberri commented 8 years ago

https://github.com/CartoDB/data-services/blob/master/geocoder/admin0/sql/subdivide_polygons.sql

ernesmb commented 8 years ago

I see, thanks for clarifying :)