Help : Custom Map Creation in Odisha State, India

[ShibasisN]

Dear Team-mate,

I am seeking assistance in resolving a challenge related to creating a custom map for Odisha State in India. The data I have includes information on States, Districts, and Blocks, along with their respective Latitude and Longitude coordinates.

My objective is to generate a map that outlines the borders of each District within Odisha State, with individual Blocks pinpointed within their respective Districts. I am currently exploring options to connect a data table containing District and Block information to another data table, allowing me to model and graphically represent this information on the map.

Your guidance in overcoming this issue would be greatly appreciated. Thank you for your help.

Best regards,

Shibasis

State	District	District_Latitude	District_Longitude	Block	Block_Latitude	Block_Longitude
ODISHA	Cuttack	20.47° N	85.88° E	Cuttack Sadar	20.52° N	85.79° E
ODISHA	Cuttack	20.47° N	85.88° E	Baranga	20.43° N	85.82° E
ODISHA	Cuttack	20.47° N	85.88° E	Kantapada	20.57° N	85.87° E
ODISHA	Cuttack	20.47° N	85.88° E	Niali	20.29° N	86.02° E
ODISHA	Cuttack	20.47° N	85.88° E	Tangi	20.23° N	85.69° E
ODISHA	Cuttack	20.47° N	85.88° E	Salipur	20.48° N	86.10° E
ODISHA	Cuttack	20.47° N	85.88° E	Nischintakoili	20.39° N	86.16° E
ODISHA	Cuttack	20.47° N	85.88° E	Mahanga	20.54° N	86.25° E
ODISHA	Cuttack	20.47° N	85.88° E	Athgarh	20.54° N	85.68° E
ODISHA	Cuttack	20.47° N	85.88° E	Tigiria	20.64° N	85.58° E
ODISHA	Cuttack	20.47° N	85.88° E	Baramba	20.62° N	85.49° E
ODISHA	Cuttack	20.47° N	85.88° E	Narasinghpur	20.28° N	85.22° E
ODISHA	Cuttack	20.47° N	85.88° E	Banki	20.38° N	85.52° E
ODISHA	Cuttack	20.47° N	85.88° E	Dampara	20.67° N	85.62° E
ODISHA	Jajpur	21.08° N	86.17° E	Jajpur	21.16° N	86.32° E
ODISHA	Jajpur	21.08° N	86.17° E	Binjharpur	20.84° N	86.38° E
ODISHA	Jajpur	21.08° N	86.17° E	Korei	20.98° N	86.28° E
ODISHA	Jajpur	21.08° N	86.17° E	Bari	21.05° N	86.40° E
ODISHA	Jajpur	21.08° N	86.17° E	Rasulpur	21.21° N	86.37° E
ODISHA	Jajpur	21.08° N	86.17° E	Dasarathpur	21.28° N	86.42° E
ODISHA	Jajpur	21.08° N	86.17° E	Sukinda	21.10° N	85.94° E
ODISHA	Jajpur	21.08° N	86.17° E	Dangadi	21.07° N	86.01° E
ODISHA	Jajpur	21.08° N	86.17° E	Dharmasala	20.92° N	86.18° E
ODISHA	Jajpur	21.08° N	86.17° E	Badachana	20.87° N	86.15° E
ODISHA	Jagatsinghpur	20.26° N	86.17° E	Jagatsinghpur	20.26° N	86.17° E
ODISHA	Jagatsinghpur	20.26° N	86.17° E	Raghunathpur	20.18° N	86.28° E
ODISHA	Jagatsinghpur	20.26° N	86.17° E	Biridi-F	20.15° N	86.13° E
ODISHA	Jagatsinghpur	20.26° N	86.17° E	Balikuda	20.06° N	86.36° E
ODISHA	Jagatsinghpur	20.26° N	86.17° E	Nuagaon	20.01° N	86.25° E
ODISHA	Jagatsinghpur	20.26° N	86.17° E	Tirtol	20.30° N	86.38° E
ODISHA	Jagatsinghpur	20.26° N	86.17° E	Kujang	20.17° N	86.41° E
ODISHA	Jagatsinghpur	20.26° N	86.17° E	Erasma	20.08° N	86.47° E

[ShibasisN]

Thank You friend for your support

[lbendlin]

To create shapes you need to have information on Lat/Lon pairs that form a closed polygon without overlapping lines. There are external tools available that allow you to create such maps in GeoJSON or TopoJSON format.  You can then use these JSON files as the basis of you Power BI map visuals.

[ShibasisN]

Thank you dear friend.

I am newbe- could you please create and share Json file ?

[lbendlin]

You have the necessary data?

[ShibasisN]

Yes Friend, I do have.
Please access the data from link below.
MAP Link 

[lbendlin]

That's just the localities - this will result in idividual dots.  What you need is something like

Indian Village Boundaries (Maps) (datameet.org)

and then MapShaper to tame it

Then you can use the topojson as a custom map

[lbendlin · Accepted solution]

Here's a cleaned up version of the map file

Note that you have lots of spelling differences in your data. These prevent the mapping of the grey areas.

Reamal vs Riamal