Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Geojson coordinates error

I'm currently trying to load border coordinates for a map which I would ideally like to fill with a colour eventually however when I load the geojson script it only loads 4 of the 6 counties.

 

I have discovered that there is 4 errors on lines 50381 & 50382 of the County Antrim grouping and 164034 & 164035 County Down grouping.

 

 

I have tried to replace the values with null & 0 or even removing the 3rd coordinate column (not sure why there would be a 3rd coordinate column unless this is the error)

 

I have painstakinly tried to filter and comb through the data but I cannot resolve this error. Is there an easier way to dissect and get to the root of this issue so I can load the rest of the coordinates for the map borders?

 

I'm loading geojson script from OSNI Open Data - Largescale Boundaries - NI Outline - Datasets - Open Data NI into Power BI.

 

Files attached:

https://www.dropbox.com/s/de0ugpvoow9tyyc/OSNI_Open_Data_-_Largescale_Boundaries_-_County_Boundaries_%20%281%29.geojson?dl=0

 

https://www.dropbox.com/s/3xxm3yj09d1atr1/NI%20Boundaries%20geojson.pbix?dl=0

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

    The data for DOWN and ANTRIM is empty . Is it because there is no data and it cannot be loaded ? Does the loaded data source itself have data ?

    Best Regards

    Community Support Team _ Ailsa Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.