I am in need of around 10000 and odd Indian latitude and longitude values for my openlayers project. I have to load them in a postgis db. so a sql file or atleast text file would be better than a link.
This is a nice problem for OGR's python interface. This is my attempt, using world.shp. Here's my code snippet:
And here's how the result looks like:
Not the most efficient way of dealing with this, but nice to learn :)
You can generate 10000 random points within a polygon of India. There has been some recent work to do this:
Update I've added a set-returning function to the PostGIS User's wiki, where I've used this question as an example. See that page for details. Although PostGIS also uses a prepared geometry, it isn't as fast as Shapely. My best speed for 10k points is 3023 ms (compared with 1125 ms for Shapely for same problem).