[Xastir] slimming down dbf files

Mike Fenske mike_fenske at telus.net
Sun Oct 8 10:31:46 EDT 2006


Hi Kyle. Not sure if you have split up your NRN shapefile yet, but I have a small perl script that I used here. It uses Tom Russo's "split_shape_by_bbox" program (available from Tom's website) and the resulting files are named as the national topographic series (92G, etc). If you are interested, I could send it to you.

Here is a list of the DBF fields that I kept:
NATRDCLASS, RTNUMBER1, RTENAME1EN, RTENAME2EN, NBRLANES, PAVSTATUS, STRUCTTYPE, STRUNAMEEN

Hope this helps,

Mike Fenske
VE7MKF
At 01:30 PM 06/10/06 -0700, Kyle Kienapfel wrote:
>Content-Disposition: inline
>
>I checked and the Geobase.ca NRN uses the ROADSEGID to associate which
>shape with what dbf entry. If theres no connection, xastir colors the
>roads seemingly randomly (due to misassociation of the dbf entries).
>So I'm down to 46.7mb for BC, but this is even before a dbfawk file is
>created, so depending it could get smaller.
>My next steps are to track down the quadtree splitting program and redo that.
>Also need to use a little bit of dbfawk maybe to make things nice.
>
>Searching for the quad splitting program is eluding me. Anyone
>remember where it is or who made it?
>
>
>This is whats left
>dbfinfo="NATRDCLASS:RTNUMBER1:RTNUMBER2:RTNUMBER3:RTNUMBER4:RTENAME1EN:RTENAME2E
>N:EXITNBR:NBRLANES:PAVSTATUS:STRUCTID:STRUCTTYPE:STRUNAMEEN:ROADSEGID";





More information about the Xastir mailing list