topic Re: Open Street Maps how do I import an OSM file? in Graphics Programming

Open Street Maps how do I import an OSM file?

ptimusk — Wed, 04 Jan 2017 18:28:26 GMT

I have been reading that Open Street Map OSM files are XML files. I can parse these out into SAS datasets importing as text files and then formatting the latitude and longitude readings, if I get the file converted to GEOJSON first.

I would like to find a way to import large 50 GB OSM files. I just need the building data. Here is something talking about an XML schema for OSM format https://wiki.openstreetmap.org/wiki/OSM_XML.

I am reading on the community here that SAS may have used Open Street Maps in the past. I wonder if someone here knows how to import an OSM file and say subset it for only building nodes. Is there some quick XML syntax I could use with The new PROC JSON Parser or another XML procedure.

I have spend a few days trying different things I have results I can use for GEOJSON files but now want to work from the OSM files.

I have SAS 9.2, SAS9.3 SAS 9.4 M4 and JMP and SASEG 7.1 to use.

Thanks in advance.

Re: Open Street Maps how do I import an OSM file?

SASKiwi — Wed, 04 Jan 2017 19:50:59 GMT

Did you know that SAS Visual Analytics uses Open Street Maps? You could layer your GEOJSN data directly onto a SAS VA map without any programming required.

Re: Open Street Maps how do I import an OSM file?

ptimusk — Wed, 04 Jan 2017 20:16:59 GMT

I will see if I can get that SAS VA software installed for this project. Mapping is only one aspect of this. I also need to build a database.

Re: Open Street Maps how do I import an OSM file?

Darrell_sas — Wed, 04 Jan 2017 20:39:13 GMT

We also use OSM in Proc GMAP. See the paper:

http://support.sas.com/rnd/papers/#2013

Google-like Maps in SAS

There is a paper and the examples there. We just use the rendered image of the map. So, we return an image to SAS and VA.

The Planet File from OSM is huge!

Re: Open Street Maps how do I import an OSM file?

ptimusk — Thu, 05 Jan 2017 20:28:53 GMT

To clarify I am not using this data for a map or visual display at this time. I want to extract only the buildings' footprints ( a polygon) into a database. I want a SAS dataset with the buildings/nodes OSMID value (name of building too and type) and the value of the latitude and longitude points of the footprint's way points.

Re: Open Street Maps how do I import an OSM file?

Darrell_sas — Wed, 11 Jan 2017 16:28:37 GMT

It seems you want to read the Planet File.

As I said, it is huge. I believe that it is between 50 and 60 GB compressed and over 700 GB uncompressed.

I haven't tried to read the individual components from it or do what you want to do.

The Planet File is at: https://planet.openstreetmap.org/

And information in: http://wiki.openstreetmap.org/wiki/Planet.osm

Good luck. Tell us about your experience reading it.