What data is available?
GEO data is expensive to create, so has been created by governments. In the past governments charged for this data. In 1980 the USGS was charging $300 (usd) per county for Oklahoma GEO data. (I complained to my congressman.) Today, a quick Internet search turns up lots of free GIS data.
I was hoping to find a neat collection of basic GEO data. It would be nice if there was one place you could get world political borders (Polygons), postal codes (Polygons) and points of interest like hospitals and airports. What you can find is lots of lists, often collections of odd data created for a virility of complex political purpose. For example, The Global Change Master Directory is a large list of data sources on earth and climate change, but you will not find the data here.
Remember, as you dig for data there are two types Vector (text) and Raster (pictures). Most sites don’t distinguish between them or combine them for you making them less useful your your own uses.
If you find good sources of GEO data PLEASE share them with me so I can share them with everyone else.
Here is a short list of the sites I found and used to create my test data in my series of posts.
- www.cloudmade.com – has shape files for the entire world with administrative, natural, coastline, water and points of interest. The data some from Open Street Maps and is available under the Creative Commons Attribution-ShareAlike 2.0 license.
- data.geocomm.com -
- gisdata.blogspot.com – Public domain GIS data and Free GIS data repositories and clearinghouses.
- collinssoftware.com – http://www.collinssoftware.com/freegis_by_region.htm
- census.gov/geo/www/tiger – http://www.census.gov/geo/www/tiger/index.html
- http://www.hostip.info/dl/index.html
I live in the state of Oklahoma. Because I know it well, I’m using it for my examples. My search for Oklahoma GIS data turned up these sources. This should give you some idea of the data you might find in your searching. I found county borders (polygons), a list of hospitals (points), city borders (polygons), points of interest (points) and zip codes (polygons). Each of these came as shape files so the process was simple to get the data into MySQL.
- libremap.org/data/state/oklahoma/ – View the entire list of USGS Oklahoma Digital Raster Graphic Maps
- geo.ou.edu – County Boundary, Municipal Boundaries, Voting Precincts, School Districts, State House Districts, State Senate Districts
- tin.er.usgs.gov/geology/state/ – Oklahoma geologic map data
- okmaps.onenet.net – 25 digital-map data sets, known as the Digital Atlas of Oklahoma
Adding these to my ‘geo’ database was simple. I ran each .shp file through the ogr2ogr program.
wget http://www.okladot.state.ok.us/hqdiv/p-r-div/maps/shp-files/munibnd.zip unzip munibnd.zip ogr2ogr -f "MySQL" MySQL:"geo,user=root,host=localhost,password=" -nln oklahoma_cities -lco engine=MYISAM munibnd.shp
Tweet
LinkedIn
Grennan.com
Twitter
Open Street Map — http://en.wikipedia.org/wiki/OpenStreetMap
yahoo also has a project call Where on Earth (WOEID) — http://developer.yahoo.com/geo/geoplanet/guide/concepts.html
I don’t know if they have polygons for each ID, however I’d suspect they must to define the area.
Link | September 7th, 2010 at 2:08 pm
Mark,
I hope there are more in this GIS series.
Are you using the GIS preview release ?
http://forge.mysql.com/wiki/GIS_Functions
John Powell has a nice presentation regarding GIS in MySQL
http://www.mysqlconf.com/mysql2009/public/schedule/detail/6863
More here.. http://assets.en.oreilly.com/1/event/36/Where%20It_s%20At_%20GeoSpatial%20MySQL%20-%20Part%202%20Presentation.odp
–
Tom
Link | September 9th, 2010 at 12:41 am
Yes, I have a LOT more on GIS to come. Do you have any subject on MySQL and GIS you would like to see?
I am not currently using the most current “GIS” release yet. It is on my list to review.
I have read John Powell’s presentation from 2009. It is very good. I was at the conference this year and GIS was not well represented.
Link | September 9th, 2010 at 12:19 pm
Where are you seeking such datum?
1) there are only two manufacturers of GIS datum to date that cover Europe and the Americas, Navtec and Tele Atlas, North America and Tele Atlas, Inc.
2) Tele Atlas, N.A. generated their datum from USGS Tiger data.
TIGER data is free. The original designer of Google maps, a kid programmer who won an award from Google, designed a GIS data meshing = mashup, program, but he started with what he could obtain, TIGER data.
I have not tried this but
http://www.gisc.berkeley.edu/gisc/data/links.html
Also, note that SHAPE FILE is the industry standard for the extension on GIS map datum.
You might just call ESRI about your inquiry too.
Link | September 9th, 2010 at 12:26 pm
CloudMade – http://downloads.cloudmade.com/ is global and has the data divided up into continents and countries under that.
* Africa
* Antarctica
* Asia
* Europe – http://downloads.cloudmade.com/europe#downloads_breadcrumbs
* North America
* Oceania
* South America
What kind of data are you looking for?
Link | September 9th, 2010 at 1:22 pm
I love your post, thank you for sharing.
Link | September 20th, 2010 at 12:31 am
For me, the Sedu Tourmaline Revolution styling iron performed like a professional grade iron, so I’m perfectly pleased with it “,-
Link | October 28th, 2010 at 5:08 am
Great writing!! I will need some time to think about this site!!
Link | December 1st, 2010 at 6:14 am
There are some interesting points in this article however I don’t know if I see all of them center to heart. There’s some validity but I will take maintain an opinion until I look into it further. Good article , thanks and we would like more! Added to FeedBurner as well.
Link | August 8th, 2011 at 4:54 pm