BookmarkSubscribeRSS Feed
ptimusk
Obsidian | Level 7

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.

5 REPLIES 5
SASKiwi
PROC Star

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.

ptimusk
Obsidian | Level 7

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.

Darrell_sas
SAS Employee

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!

 

ptimusk
Obsidian | Level 7

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.

Darrell_sas
SAS Employee

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 2703 views
  • 0 likes
  • 3 in conversation