search

martinjc / UK-GeoJSON

GeoJSON versions of UK Boundary Data
Other
282 stars 108 forks source link

OSGB_Grid_1km #11

Closed mistatoms closed 7 years ago

mistatoms commented 7 years ago

I have been trying to convert the OSGB_1km grid into a json file which powerBI can read.

When uploading the following files... https://github.com/charlesroper/OSGB_Grids/blob/master/Shapefile/OSGB_Grid_1km.shp https://github.com/charlesroper/OSGB_Grids/blob/master/Shapefile/OSGB_Grid_1km.dbf https://github.com/charlesroper/OSGB_Grids/blob/master/Shapefile/OSGB_Grid_1km.prj

...to mapshaper it is all looking good... ms

...SHP and DBP combine nicely with PLAN_NO acting as key for shape attribute.

When exporting to GEOjson or TOPjson I don't manage to create a file which powerBI can process. When using a json file in powerBI from your website, everything works just perfectly well. What magic formula do you have to create json files which work in powerBI?

martinjc commented 7 years ago

I wish I could tell you - but not knowing what mapshaper does on export, it's hard to know what's different.

I can tell you that my process is pretty much the same (give or take) as Mike Bostock's in his "Let's make a map" post, although even that has now been superseded.

Hopefully the solution you seek is somewhere there...