Welcome, Guest. Please login or register.

Login with username, password and session length
Forums Search:  


Author Topic: Best way to represent trail data in a database?  (Read 3486 times)

santoshamb

  • Newbie
  • *
  • Posts: 1
  • Karma: 0
    • View Profile
Best way to represent trail data in a database?
« on: September 25, 2008, 11:36:48 AM »
Hello,

I'm currently working on a project where I'm going to be collecting and querying data for hiking trails.  Eventually, I'd like to store all the trails in the US, and import trails from Gov sources like the USGS or the NPS. I'll be overlaying these trails onto a map using a mapping service, so really the only data I need to store will be latitude and longitude for points along the trail.  I currently have a simple table structure:

Trail
  Id
  Name
  Desc
  Ect...

Trailpoint
   Trailid
   Lat
   Lon
   Ect...

Where one trail as many trailpoints.  This works well if I'm accepting trails in GPX format, I can just pull out all the trackpoints and store them into the database.  Unfortunately, it seems that the vast majority of existing trail data is in shapefiles, (like the NPS for instance) and it's not easy to convert over to GPX so that I can import into my simple representation.

Which leads me to question, is my way the best way to represent trails?  Should I be using something more complex like PostGIS?  I'm currently using MySQL and my host doesn't support PostgreSQL so moving over would be difficult.

Thanks for all the help!

Ben

-Oz-

  • Map Maker!
  • Administrator
  • Expert Advisor
  • *****
  • Posts: 1579
  • Karma: 27
    • View Profile
    • GPSFileDepot
Re: Best way to represent trail data in a database?
« Reply #1 on: September 25, 2008, 06:32:52 PM »
postgis/postgresql is pretty easy but there are other options:

http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html <-- mysql5 spatial extensions.

I would advise against writing your own because there is the possibility for more errors.  But yes, yours would work for gpx files but all govt data is in at least shapefile.
Dan Blomberg
Administrator - GPSFileDepot
GPS Units: Garmin Dakota 20, Garmin GPSMap 60csx, Nuvi 255W, Nuvi 250W, ForeRunner 110, Fenix 2, Tactix Bravo, Foretrex 401
See/Download My Maps!