Re: [Talk-in] Railway station GPS co-ordinates

2016-06-12 Thread Sutripta 
Thanks a lot.
Will play around with it today.

Regards
Sutripta

On 6 June 2016 at 19:17, Shibu Narayanan <shibu.naraya...@oracle.com> wrote:

> Hi,
>
> My email with an attachment has not been approved because of the large
> size.
>
> I have uploaded it to this location
> https://raw.githubusercontent.com/tnshibu/osm_data_extract/master/data/india_railway_station_list.txt
>
> You can find the GPS co-ordinates of railways stations in India.  The
> “ref” refers to the Indian railway station code, I think.
>
> The data extracted is for nodes which have the tags with key=”railway” and
> value=”station”.
>
> The extracted data is pipe(‘|’) delimited.
>
> If anyone requires similar data for other tags, let me know, I will try to
> extract them and give you.
>
> Hope someone finds this useful.
>
>
>
> Sutripta,
>
> All data entered in OSM is ground validated I would assume.  Because it is
> entered individually by contributors, my assumption is that a person
> familiar with the place is the one who is entering the data to OSM.
>
>
>
>
>
>
> *Shibu Narayanan *Oracle Financial Services | Bangalore | India
> Office:0091-80-4918-1692 | Mobile:0091-99800-64282
>
>
>
> *From:* Sutripta [mailto:sutri...@gmail.com <sutri...@gmail.com>]
> *Sent:* Tuesday, May 17, 2016 11:23 AM
> *To:* OpenStreetMap in India
> *Subject:* Re: [Talk-in] Railway station GPS co-ordinates
>
>
>
> Hi,
>
> Thanks.
>
> How does one know if an object has been groundtruthed/ validated?
>
>
>
> Regards
>
> Sutripta
>
>
>
> On 16 May 2016 at 13:17, Shibu Narayanan <shibu.naraya...@oracle.com>
> wrote:
>
> The link suggested by Arun http://download.geofabrik.de/asia/india.html has
> a 10GB xml file which contains the required information.
>
> I will extract it as a csv and post the results here.
>
>
>
>
> *Shibu Narayanan *Oracle Financial Services | Bangalore | India
> Office:0091-80-4918-1692 | Mobile:0091-99800-64282
>
>
>
> *From:* Sutripta (Gmail) [mailto:sutri...@gmail.com]
> *Sent:* Monday, May 16, 2016 12:10 PM
> *To:* OpenStreetMap in India
> *Subject:* Re: [Talk-in] Railway station GPS co-ordinates
>
>
>
> Hi,
> Is the list of Railway Stations/ Junctions in India available as a CSV/
> Excel file? Maybe with a column saying 'Ground truthed/ validated'.
>
> Sometime back there was a XML file from IR, but as pointed out by Arun
> Ganesh, had a lot of errors.
>
> Regards
> Sutripta
>
> On 12-05-2016 22:19, Arun Ganesh wrote:
>
> Hey Shibu, you can extract it live from OSM using overpass:
> http://overpass-turbo.eu/s/gbk
>
>
>
> If you want a shapefile of a larger area, suggest you download the OSM
> extract from geofabrik http://download.geofabrik.de/asia/india.html
>
>
>
> The POI layer should have the railway stations.
>
>
>
> On Thu, May 12, 2016 at 9:59 PM, Shibu Narayanan <
> shibu.naraya...@oracle.com> wrote:
>
> Hi,
>
> How do I get the list of all railway stations in Karnataka(or any other
> state) and also its GPS co-ordinates?
>
>
>
>
> *Shibu Narayanan *Oracle Financial Services | Bangalore | India
> Office:0091-80-4918-1692 | Mobile:0091-99800-64282
>
>
>
>
> ___
> Talk-in mailing list
> Talk-in@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-in
>
>
>
>
>
> --
>
> Arun Ganesh
>
> @planemad
>
>
>
> ___
>
> Talk-in mailing list
>
> Talk-in@openstreetmap.org
>
> https://lists.openstreetmap.org/listinfo/talk-in
>
>
>
>
> ___
> Talk-in mailing list
> Talk-in@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-in
>
>
>
> ___
> Talk-in mailing list
> Talk-in@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-in
>
>
___
Talk-in mailing list
Talk-in@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in

Re: [Talk-in] Railway station GPS co-ordinates

2016-06-06 Thread Shibu Narayanan 
Hi,

My email with an attachment has not been approved because of the large size.

I have uploaded it to this location 
https://raw.githubusercontent.com/tnshibu/osm_data_extract/master/data/india_railway_station_list.txt

You can find the GPS co-ordinates of railways stations in India.  The “ref” 
refers to the Indian railway station code, I think.

The data extracted is for nodes which have the tags with key=”railway” and 
value=”station”.

The extracted data is pipe(‘|’) delimited.

If anyone requires similar data for other tags, let me know, I will try to 
extract them and give you.

Hope someone finds this useful.

 

Sutripta,

All data entered in OSM is ground validated I would assume.  Because it is 
entered individually by contributors, my assumption is that a person familiar 
with the place is the one who is entering the data to OSM.

 

 

Shibu Narayanan 
Oracle Financial Services | Bangalore | India
Office:0091-80-4918-1692 | Mobile:0091-99800-64282

 

From: Sutripta [mailto:sutri...@gmail.com] 
Sent: Tuesday, May 17, 2016 11:23 AM
To: OpenStreetMap in India
Subject: Re: [Talk-in] Railway station GPS co-ordinates

 

Hi, 

Thanks. 

How does one know if an object has been groundtruthed/ validated? 

 

Regards 

Sutripta 

 

On 16 May 2016 at 13:17, Shibu Narayanan mailto:shibu.naraya...@oracle.com; \nshibu.naraya...@oracle.com> wrote:

The link suggested by Arun http://download.geofabrik.de/asia/india.html has a 
10GB xml file which contains the required information.

I will extract it as a csv and post the results here.  

 

Shibu Narayanan 
Oracle Financial Services | Bangalore | India
Office:0091-80-4918-1692 | Mobile:0091-99800-64282

 

From: Sutripta (Gmail) [mailto:HYPERLINK "mailto:sutri...@gmail.com; 
\nsutri...@gmail.com] 
Sent: Monday, May 16, 2016 12:10 PM
To: OpenStreetMap in India
Subject: Re: [Talk-in] Railway station GPS co-ordinates

 

Hi, 
Is the list of Railway Stations/ Junctions in India available as a CSV/ Excel 
file? Maybe with a column saying 'Ground truthed/ validated'. 

Sometime back there was a XML file from IR, but as pointed out by Arun Ganesh, 
had a lot of errors. 

Regards 
Sutripta 

On 12-05-2016 22:19, Arun Ganesh wrote:

Hey Shibu, you can extract it live from OSM using overpass: 
http://overpass-turbo.eu/s/gbk 

 

If you want a shapefile of a larger area, suggest you download the OSM extract 
from geofabrik http://download.geofabrik.de/asia/india.html

 

The POI layer should have the railway stations.

 

On Thu, May 12, 2016 at 9:59 PM, Shibu Narayanan mailto:shibu.naraya...@oracle.com; \nshibu.naraya...@oracle.com> wrote:

Hi,

How do I get the list of all railway stations in Karnataka(or any other state) 
and also its GPS co-ordinates?

 

Shibu Narayanan 
Oracle Financial Services | Bangalore | India
Office:HYPERLINK "tel:0091-80-4918-1692" \n0091-80-4918-1692 | Mobile:HYPERLINK 
"tel:0091-99800-64282" \n0091-99800-64282

 


___
Talk-in mailing list
HYPERLINK "mailto:Talk-in@openstreetmap.org; \ntalk...@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in





 

-- 

Arun Ganesh

@planemad

 

___
Talk-in mailing list
HYPERLINK "mailto:Talk-in@openstreetmap.org; \ntalk...@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in

 


___
Talk-in mailing list
HYPERLINK "mailto:Talk-in@openstreetmap.org"Talk-in@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in

 
___
Talk-in mailing list
Talk-in@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in

Re: [Talk-in] Railway station GPS co-ordinates

2016-05-17 Thread Arun Ganesh 
On Tue, May 17, 2016 at 11:22 AM, Sutripta <sutri...@gmail.com> wrote:

> Hi,
> Thanks.
> How does one know if an object has been groundtruthed/ validated?
>

An interesting question. The only way to really find out is to ask the
contributor I guess.


>
> Regards
> Sutripta
>
> On 16 May 2016 at 13:17, Shibu Narayanan <shibu.naraya...@oracle.com>
> wrote:
>
>> The link suggested by Arun http://download.geofabrik.de/asia/india.html has
>> a 10GB xml file which contains the required information.
>>
>> I will extract it as a csv and post the results here.
>>
>>
>>
>>
>> *Shibu Narayanan *Oracle Financial Services | Bangalore | India
>> Office:0091-80-4918-1692 | Mobile:0091-99800-64282
>>
>>
>>
>> *From:* Sutripta (Gmail) [mailto:sutri...@gmail.com]
>> *Sent:* Monday, May 16, 2016 12:10 PM
>> *To:* OpenStreetMap in India
>> *Subject:* Re: [Talk-in] Railway station GPS co-ordinates
>>
>>
>>
>> Hi,
>> Is the list of Railway Stations/ Junctions in India available as a CSV/
>> Excel file? Maybe with a column saying 'Ground truthed/ validated'.
>>
>> Sometime back there was a XML file from IR, but as pointed out by Arun
>> Ganesh, had a lot of errors.
>>
>> Regards
>> Sutripta
>>
>> On 12-05-2016 22:19, Arun Ganesh wrote:
>>
>> Hey Shibu, you can extract it live from OSM using overpass:
>> http://overpass-turbo.eu/s/gbk
>>
>>
>>
>> If you want a shapefile of a larger area, suggest you download the OSM
>> extract from geofabrik http://download.geofabrik.de/asia/india.html
>>
>>
>>
>> The POI layer should have the railway stations.
>>
>>
>>
>> On Thu, May 12, 2016 at 9:59 PM, Shibu Narayanan <
>> shibu.naraya...@oracle.com> wrote:
>>
>> Hi,
>>
>> How do I get the list of all railway stations in Karnataka(or any other
>> state) and also its GPS co-ordinates?
>>
>>
>>
>>
>> *Shibu Narayanan *Oracle Financial Services | Bangalore | India
>> Office:0091-80-4918-1692 | Mobile:0091-99800-64282
>>
>>
>>
>>
>> ___
>> Talk-in mailing list
>> Talk-in@openstreetmap.org
>> https://lists.openstreetmap.org/listinfo/talk-in
>>
>>
>>
>>
>>
>> --
>>
>> Arun Ganesh
>>
>> @planemad
>>
>>
>>
>>
>> ___
>>
>> Talk-in mailing list
>>
>> Talk-in@openstreetmap.org
>>
>> https://lists.openstreetmap.org/listinfo/talk-in
>>
>>
>>
>> ___
>> Talk-in mailing list
>> Talk-in@openstreetmap.org
>> https://lists.openstreetmap.org/listinfo/talk-in
>>
>>
>
> ___
> Talk-in mailing list
> Talk-in@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-in
>
>


-- 
Arun Ganesh
@planemad
<http://j.mp/ArunGanesh>
___
Talk-in mailing list
Talk-in@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in

Re: [Talk-in] Railway station GPS co-ordinates

2016-05-16 Thread Sutripta 
Hi,
Thanks.
How does one know if an object has been groundtruthed/ validated?

Regards
Sutripta

On 16 May 2016 at 13:17, Shibu Narayanan <shibu.naraya...@oracle.com> wrote:

> The link suggested by Arun http://download.geofabrik.de/asia/india.html has
> a 10GB xml file which contains the required information.
>
> I will extract it as a csv and post the results here.
>
>
>
>
> *Shibu Narayanan *Oracle Financial Services | Bangalore | India
> Office:0091-80-4918-1692 | Mobile:0091-99800-64282
>
>
>
> *From:* Sutripta (Gmail) [mailto:sutri...@gmail.com]
> *Sent:* Monday, May 16, 2016 12:10 PM
> *To:* OpenStreetMap in India
> *Subject:* Re: [Talk-in] Railway station GPS co-ordinates
>
>
>
> Hi,
> Is the list of Railway Stations/ Junctions in India available as a CSV/
> Excel file? Maybe with a column saying 'Ground truthed/ validated'.
>
> Sometime back there was a XML file from IR, but as pointed out by Arun
> Ganesh, had a lot of errors.
>
> Regards
> Sutripta
>
> On 12-05-2016 22:19, Arun Ganesh wrote:
>
> Hey Shibu, you can extract it live from OSM using overpass:
> http://overpass-turbo.eu/s/gbk
>
>
>
> If you want a shapefile of a larger area, suggest you download the OSM
> extract from geofabrik http://download.geofabrik.de/asia/india.html
>
>
>
> The POI layer should have the railway stations.
>
>
>
> On Thu, May 12, 2016 at 9:59 PM, Shibu Narayanan <
> shibu.naraya...@oracle.com> wrote:
>
> Hi,
>
> How do I get the list of all railway stations in Karnataka(or any other
> state) and also its GPS co-ordinates?
>
>
>
>
> *Shibu Narayanan *Oracle Financial Services | Bangalore | India
> Office:0091-80-4918-1692 | Mobile:0091-99800-64282
>
>
>
>
> ___
> Talk-in mailing list
> Talk-in@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-in
>
>
>
>
>
> --
>
> Arun Ganesh
>
> @planemad
>
>
>
>
> ___
>
> Talk-in mailing list
>
> Talk-in@openstreetmap.org
>
> https://lists.openstreetmap.org/listinfo/talk-in
>
>
>
> ___
> Talk-in mailing list
> Talk-in@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-in
>
>
___
Talk-in mailing list
Talk-in@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in

Re: [Talk-in] Railway station GPS co-ordinates

2016-05-16 Thread Warin 

Hi,
a better way ?

with this query, you immediately have a CSV file as output.

Use thishttp://overpass-turbo.eu/s/gdp

or copy the query below tohttp://overpass-turbo.eu/



[out:csv (railway,station)][timeout:25];
// gather results
(
  // query part for: “railway=station”
  node["place"="town"]({{bbox}});
  way["place"="town"]({{bbox}});
  relation["place"="town"]({{bbox}});
);
// print results
out body;


;


out skel qt;

seehttp://wiki.openstreetmap.org/wiki/Overpass_API/Overpass_QL#Output_Format_.28out.29
for more options on the CSV output

You can make the timeout longer in case you want to cover a larger area.
 


On 5/16/2016 5:47 PM, Shibu Narayanan wrote:


The link suggested by Arun 
http://download.geofabrik.de/asia/india.html has a 10GB xml file which 
contains the required information.


I will extract it as a csv and post the results here.

*Shibu Narayanan
*Oracle Financial Services | Bangalore | India
Office:0091-80-4918-1692 | Mobile:0091-99800-64282

*From:*Sutripta (Gmail) [mailto:sutri...@gmail.com]
*Sent:* Monday, May 16, 2016 12:10 PM
*To:* OpenStreetMap in India
*Subject:* Re: [Talk-in] Railway station GPS co-ordinates

Hi,
Is the list of Railway Stations/ Junctions in India available as a 
CSV/ Excel file? Maybe with a column saying 'Ground truthed/ validated'.


Sometime back there was a XML file from IR, but as pointed out by Arun 
Ganesh, had a lot of errors.


Regards
Sutripta

On 12-05-2016 22:19, Arun Ganesh wrote:

Hey Shibu, you can extract it live from OSM using overpass:
http://overpass-turbo.eu/s/gbk

If you want a shapefile of a larger area, suggest you download the
OSM extract from geofabrik
http://download.geofabrik.de/asia/india.html

The POI layer should have the railway stations.

On Thu, May 12, 2016 at 9:59 PM, Shibu Narayanan
<shibu.naraya...@oracle.com <mailto:shibu.naraya...@oracle.com>>
wrote:

Hi,

How do I get the list of all railway stations in Karnataka(or any
other state) and also its GPS co-ordinates?

*Shibu Narayanan
*Oracle Financial Services | Bangalore | India
Office:0091-80-4918-1692  |
Mobile:0091-99800-64282 


___
Talk-in mailing list
Talk-in@openstreetmap.org <mailto:Talk-in@openstreetmap.org>
https://lists.openstreetmap.org/listinfo/talk-in



-- 


Arun Ganesh

@planemad




___

Talk-in mailing list

Talk-in@openstreetmap.org <mailto:Talk-in@openstreetmap.org>

https://lists.openstreetmap.org/listinfo/talk-in



___
Talk-in mailing list
Talk-in@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in



___
Talk-in mailing list
Talk-in@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in

Re: [Talk-in] Railway station GPS co-ordinates

2016-05-16 Thread Shibu Narayanan 
The link suggested by Arun http://download.geofabrik.de/asia/india.html has a 
10GB xml file which contains the required information.

I will extract it as a csv and post the results here.  

 

Shibu Narayanan 
Oracle Financial Services | Bangalore | India
Office:0091-80-4918-1692 | Mobile:0091-99800-64282

 

From: Sutripta (Gmail) [mailto:sutri...@gmail.com] 
Sent: Monday, May 16, 2016 12:10 PM
To: OpenStreetMap in India
Subject: Re: [Talk-in] Railway station GPS co-ordinates

 

Hi, 
Is the list of Railway Stations/ Junctions in India available as a CSV/ Excel 
file? Maybe with a column saying 'Ground truthed/ validated'. 

Sometime back there was a XML file from IR, but as pointed out by Arun Ganesh, 
had a lot of errors. 

Regards 
Sutripta 



On 12-05-2016 22:19, Arun Ganesh wrote:

Hey Shibu, you can extract it live from OSM using overpass: 
http://overpass-turbo.eu/s/gbk 

 

If you want a shapefile of a larger area, suggest you download the OSM extract 
from geofabrik http://download.geofabrik.de/asia/india.html

 

The POI layer should have the railway stations.

 

On Thu, May 12, 2016 at 9:59 PM, Shibu Narayanan mailto:shibu.naraya...@oracle.com; \nshibu.naraya...@oracle.com> wrote:

Hi,

How do I get the list of all railway stations in Karnataka(or any other state) 
and also its GPS co-ordinates?

 

Shibu Narayanan 
Oracle Financial Services | Bangalore | India
Office:HYPERLINK "tel:0091-80-4918-1692" \n0091-80-4918-1692 | Mobile:HYPERLINK 
"tel:0091-99800-64282" \n0091-99800-64282

 


___
Talk-in mailing list
HYPERLINK "mailto:Talk-in@openstreetmap.org"Talk-in@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in





 

-- 

Arun Ganesh

@planemad






___
Talk-in mailing list
HYPERLINK "mailto:Talk-in@openstreetmap.org"Talk-in@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in

 
___
Talk-in mailing list
Talk-in@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in

Re: [Talk-in] Railway station GPS co-ordinates

2016-05-16 Thread Sutripta (Gmail) 

Hi,
Is the list of Railway Stations/ Junctions in India available as a CSV/ 
Excel file? Maybe with a column saying 'Ground truthed/ validated'.


Sometime back there was a XML file from IR, but as pointed out by Arun 
Ganesh, had a lot of errors.


Regards
Sutripta


On 12-05-2016 22:19, Arun Ganesh wrote:
Hey Shibu, you can extract it live from OSM using overpass: 
http://overpass-turbo.eu/s/gbk


If you want a shapefile of a larger area, suggest you download the OSM 
extract from geofabrik http://download.geofabrik.de/asia/india.html


The POI layer should have the railway stations.

On Thu, May 12, 2016 at 9:59 PM, Shibu Narayanan 
> wrote:


Hi,

How do I get the list of all railway stations in Karnataka(or any
other state) and also its GPS co-ordinates?

*Shibu Narayanan
*Oracle Financial Services | Bangalore | India
Office:0091-80-4918-1692  |
Mobile:0091-99800-64282 


___
Talk-in mailing list
Talk-in@openstreetmap.org 
https://lists.openstreetmap.org/listinfo/talk-in




--
Arun Ganesh
@planemad


___
Talk-in mailing list
Talk-in@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in


___
Talk-in mailing list
Talk-in@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in

Re: [Talk-in] Railway station GPS co-ordinates

2016-05-12 Thread Arun Ganesh 
Hey Shibu, you can extract it live from OSM using overpass:
http://overpass-turbo.eu/s/gbk

If you want a shapefile of a larger area, suggest you download the OSM
extract from geofabrik http://download.geofabrik.de/asia/india.html

The POI layer should have the railway stations.

On Thu, May 12, 2016 at 9:59 PM, Shibu Narayanan  wrote:

> Hi,
>
> How do I get the list of all railway stations in Karnataka(or any other
> state) and also its GPS co-ordinates?
>
>
>
>
> *Shibu Narayanan *Oracle Financial Services | Bangalore | India
> Office:0091-80-4918-1692 | Mobile:0091-99800-64282
>
>
>
> ___
> Talk-in mailing list
> Talk-in@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-in
>
>


-- 
Arun Ganesh
@planemad

___
Talk-in mailing list
Talk-in@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-in