Map issue - location name

[markc]

This might be something low on the list as the userbase would be small but I have run into an issue with the map visual.

In Louisiana, we don't have "Counties", we call them "Parishes". (The nomenclature goes back to the Louisiana Purchase.) I developed a report using the filled map visual. In my query I brought over my FIPS data where the column is called "county_name". Everything works great. However when I added an alias to it so that the column would be shown as "Parish Name" the map went blank like it didn't know where the locations were.

Works:

select county_code
from data

Doesn't Work:

select county_code 'Parish Name'
from data

When I removed the alias, the map refreshed and brought back the shaded areas.

Like I said, this might be a trivial fix but it would mean the world to those of us creating a reports in Louisiana.

Thanks

 Mark

[Sean]

I have no problem mapping all Parishes with the built-in Regular and Filled Map and ArcGIS too

The Column itself is called Parish and as you can see in the Legend the rows in the Parish Column say Parish too not County

EDIT: Well with some small modifications even the Shape Map works

remove the word "Parish" from all rows in the column - column can still be called Parish though

replace all "Saint" with "St." and "La Salle" with "LaSalle" no space and there it is

[markc]

I am curious as to what is in the table or the JSON file you used. Does it have the coordinates or anything else in it? Or is it strictly the parish names?

I tried using the parish name minus the ' Parish' part and it still failed to associate correctly.

Thanks.

[Sean]

Here's the link for the file I used in the above

https://github.com/deldersveld/topojson/blob/master/countries/us-states/LA-22-louisiana-parishes.jso...