[Talk-in] PMGSY rural connectivity open data

[Nikhil VJ]

Hi, I've imported the data to a PostGreSQL DB on my webserver - I think
it'll be useful to have it in that form to be able to do more with it.

I've shared the import script and steps in this repo if anyone wants to
load it into their own DB:
https://github.com/answerquest/import_geosadak

Some data inconsistencies found:
States having BLOCK_ID values in boundaries shapefile which does not have
matching Master data entry:
TamilNadu - 3
JammuAndKashmir - 3
These blocks do have road data etc but no entry in master data excel:
8108, 8105, 8106, 8063, 8034, 8041

States having BLOCK_ID=0 in their block boundary shapefile:
Punjab - 1
WestBengal - 3
I've imported these boundaries with randomly assigned block ids. We'll need
to match them to actual block id.

Limited offer: If someone wants to query my DB then pls contact me on
nikhil.js (at) gmail.com for credentials (limited capacity and bandwidth,
note).

--
Cheers,
Nikhil VJ
https://nikhilvj.co.in


On Sat, Feb 26, 2022 at 12:40 PM Arun Ganesh <arun.planemad at gmail.com>
wrote:

> Wiki page outlining the data and notes to plan an import
> https://wiki.openstreetmap.org/wiki/India/PMGSY_rural_connectivty_data_import
> _______________________________________________
> Talk-in mailing list
> Talk-in at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-in
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-in/attachments/20220303/b7b8cf1f/attachment.htm>