Now that I have a RELAX NG Compact schema of GPX, it’s time to figure out how to get my data in to PostGIS. so I can do geospatial queries. I installed PostGIS on my Ubuntu box with these instructions. If I recall correctly, the latest version didn’t work but the previous release did.
GPX makes a great GPS data interchange format, particularly because you can convert just about anything to GPX with GPSBabel. I’m not aware of anything that can convert straight from GPX to PostGIS, but it is a relatively straightforward two-part process.
The first order of business is converting our GPX file to an ESRI Shapefile. This is easiest done by using gpx2shp, a utility written in C that is also available in Ubuntu. Once gpx2shp is installed, run it on your GPX file: gpx2shp filename.gpx.
Once we have a shape file, we can use a utility included with PostGIS to import the shapefile in to postgres. The program is called shp2pgsql, and can be used as such: shp2pgsql -a shapefile.shp tablename. I tend to prefer the -a option which appends data to the table (as long as it’s the same basic type of the existing data). shp2pgsql generates SQL that you can then pipe in to psql as such: shp2pgsql -a shapefile.shp tablename | psql databasename.
Once the data is in Postgres (don’t forget to spatially-enable your database, you can query it in ways that I’m still figuring out. A basic query like this will return a list of lat/lon pairs that corresponds to my GPS track: select asText(the_geom) from tablename;. I’m llooking forward to wrapping my head around enough jargon to do bounding box selects, finding things nearby a specific point, etc.
The examples in the PostGIS documentation seem pretty good, I just haven’t figured out how to apply it to the data I have. I feel like mastering GIS jargon is one of the biggest hurdles to understanding PostGIS better. Well, that and a masters degree in GIS wouldn’t hurt.
Comments
51 responses to “From GPX to PostGIS”
Matt,
Real soon now, I hope to whack on better GIS support in Ellington. I recently read the PostGIS docs and OpenGIS for SQL standard.
I was left with a similar impression on needing further study, but I may be about 150 pages ahead of you on the query language.
If you feel stuck, maybe I can help. 🙂
This page appears to recieve a large ammount of visitors. How do you promote it? It offers a nice individual twist on things. I guess having something real or substantial to talk about is the most important thing.
Well, like they say, If a tree falls in the forest, does it make a sound?
Thank you for the great post! I would never have found this myself!
very good \o/
I like this web site its a master peace ! .
family home surround audio devices are the most effective way to get the complete advantage by your audio players
very good \o/
This post was very well written, and it also contains a lot of useful facts. I appreciated your distinguished manner of writing this post. Thanks, you have made it easy for me to understand. The ear is a self cleaning body part.
I was looking for crucial information on this subject. The information was important as I am about to launch my own portal. Thanks for providing a missing link in my business. These are called chemical miscarriages, and they account for around seventy five percent of all miscarriages.
great thanks \o/
I just desired to comment your blog in addition to claim which i genuinely enjoyed reading your blog submit right here. It had been really useful and i likewise reddit how you publish! Stay the best along with Soon we will be time for study much more down the road…
Thanks so much for your intelligent website;this is the stuff that keeps me on track through out these day. I’ve been looking around for this site after asked to visit them from a colleague and was thrilled when I found it after searching for awhile. Being a avid blogger, I’m glad to see others taking initivative and contributing to the community. I would like to comment to show my appreciation for your website as it is very enticing, and many writers do not get appreciation they deserve. I am sure I’ll visit again and will send some of my friends.
WordPress Video…
Many thanks for yet another first-rate article. I am always seeking for super WordPress helpful hints to recommend to my own readers. Thank you for making this article. It’s exactly what I was searching for. Truly terrific post….
Well I sincerely liked reading it. This tip procured by you is very constructive for correct planning.
WONDERFUL Post.thanks for share..more wait .. …
This is my first time i go post. I collected so many interesting things in your site especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work.Regards
I likewise conceive thence , perfectly indited post! .
The subsequent time I learn a blog, I hope that it doesnt disappoint me as much as this one. I mean, I do know it was my choice to learn, however I actually thought youd have one thing fascinating to say. All I hear is a bunch of whining about something that you may fix should you werent too busy looking for attention.
Oh my goodness! an incredible article dude. Thank you However I am experiencing challenge with ur rss . Don’t know why Unable to subscribe to it. Is there anyone getting identical rss downside? Anybody who is aware of kindly respond. Thnkx
If you believe the science it just might be. This is clinically proven, not just a claim.
I discovered your blog website on google and verify a few of your early posts. Continue to maintain up the superb operate. I simply further up your RSS feed to my MSN Information Reader. Seeking forward to reading more from you afterward!…
WONDERFUL Post.thanks for share..more wait .. …
porno izle
keep up the great work on the blog. Do like it! :p Could maybe use some more updates more often, but i’m sure you have got more or better things to do like we all do. =)
I truly appreciate your production. It seems like a lot of your points are precisely inline with mine. I was going to include you to my friendfeed, but I cant locate the URL of your feed, can you direct me in the correct directon or email me?
What is occurring around all these to the world is really very bad. Related to the problems of that ranking with Egypt tend to be fixed before long. They need to find for any pacific way to the condition and get religious beliefs which the armed service doesn´t please take a violent motion against the protests. It´s obvious the people really want your leader away, nevertheless maybe the issues will be deeper compared to merely taking out the chief executive in a country.
vyvoz stroitelnogo musora spb…
vyvoz musora…
I in no way realised this earlier than, but you possess a relatively high quality level indeed
I in no way realised this just before, but you possess a exceptionally satisfactory point certainly
Terrific to be stumbling as much as your web site once more, it has been virtually a year for me. Anyway, this is the editorial that i’ve been looking for so long. I can use this document to end my assignment in the school, and it has similar matter like your write-up. Thank you, incredible share.
A powerful share, I just given this onto a colleague who was doing a bit of evaluation on this. And he in fact bought me breakfast as a result of I found it for him.. smile. So let me reword that: Thnx for the treat! But yeah Thnkx for spending the time to discuss this, I feel strongly about it and love reading extra on this topic. If potential, as you change into experience, would you thoughts updating your weblog with more details? It is extremely helpful for me. Massive thumb up for this blog put up!
i have checked this site a few times now and i have to tell you that i find it quite great actually. it’ll be nice to read more in the future! =)
Hello, where do you find such rather good info, I`ll post your web page in my Twitter account
Very well mentioned, mostly, but don’t you really feel as if the issue is considerably more complex than that?
You completed several fine points there. I did a search on the matter and found most folks will consent with your blog.
You made a number of fine points there. I did a search on the subject and found most people will consent with your blog.
i’ve checked this blog a few times now and i have to tell you that i find it quite exeptional actually. continue doing what you’re doing! :p
discount tory burch shoes…
Tory Burch flip flop online sale.For the younger working expat women,look at these tory burch Shoes.these tory burch flip flop are definitely fun,yet the glossy design and round-toe stay these lovely.These tory burch shoes with multiple.New arrivel Tor…
vlOQE5 shsxluaqkjpj, [url=http://htuntdonevmt.com/]htuntdonevmt[/url], [link=http://ijjfmssltwkz.com/]ijjfmssltwkz[/link], http://bflidxqrrucy.com/
actually like the post that you posted actually. it just is not that easy to discover good posts to read (you know really READ and not just going through it like some uniterested and flesh eating zombie before moving on), so cheers mate for not wasting my time! 😉
keep up the good work on the blog. Do like it! :p Could maybe use some more updates more often, but i’m sure you have got better or other things to do like we all have to do unfortunately. :p
Very efficiently written information. It is going to be helpful to anybody who usess it, together with myself. Sustain the nice work – for certain i will check out extra posts.
Its like you read my mind! You appear to understand so much about this, like you wrote the e book in it or something. I believe that you simply can do with some % to drive the message house a bit, however instead of that, that is wonderful blog. An excellent read. I will definitely be back.
I’d come to engage with you here. Which is not something I typically do! I enjoy reading a post that will make people think. Also, thanks for allowing me to comment!
WONDERFUL Post.thanks for share..extra wait .. …
http://www.wap54g.net/upgrading-the-wap54g/ Upgrading the WAP54G
This is definitely a topic thats close to me so Im happy that you wrote about it. Im also happy that you did the subject some justice. Not only do you know a great deal about it, you know how to present in a way that people will want to read more. Im so happy to know someone like you exists on the web.
I conceive you have observed some very interesting points , thankyou for the post.
http://www.wap54g.net/linksys-wap54g-default-ip/ wap54g default ip