Yes, that helps a lot! Are there any tools that I could use to graphically see the data that would match a set of criteria? Without doing the ogr2ogr thing, then loading the map in Xastir? -- William McKeehan KI4HDU http://mckeehan.homeip.net
On Sun, May 3, 2009 5:12 pm, Tom Russo wrote: > On Sun, May 03, 2009 at 03:24:42PM -0400, we recorded a bogon-computron > collision of the <[email protected]> flavor, containing: >> I'm not knowledgeable enough about shape files to be able to figure out what >> the "where" clause should be. >> >> What I would like to do is pull parts of the shape files into their own >> file, >> so I would have a file (probably still keeping it broken down by >> state/county) >> for Limited Access Roads, another for secondary roads, etc.; basically, the >> same breakdown that is done in the dbfawk files. Having each bit of >> information in a separate file would let me set the max zoom level for each >> file and thus prevent Xastir from reading data that I have no intention of >> displaying at the particular zoom level that I am at. >> >> So that's my end goal. >> >> With that in mind, can someone recommend tools that would help me understand >> how to build appropriate where clauses to break these files out? > > K. I just did this for Santa Fe County, NM, file "tl_2008_35049_edges.shp": > > Limited access roads: > ogr2ogr -where "MTFCC like 'S11%'" SantaFeLTDAroads.shp > tl_2008_35049_edges.shp > > Secondary roads: > ogr2ogr -where "MTFCC like 'S12%'" SantaFeSecondaryRoads.shp > tl_2008_35049_edges.shp > > Lather, rinse, repeat for other patterns in the DBFAWK file. > > "MTFCC='S11'" didn't work, because it turns out that the actual MTFCC values > *start* with S11, but have suffixes. So -where "MTFCC like 'S11%'" matches > any record with MTFCC that starts with S11. > > That should get you on the path. HTH. > > -- > Tom Russo KM5VY SAR502 DM64ux http://www.swcp.com/~russo/ > Tijeras, NM QRPL#1592 K2#398 SOC#236 http://kevan.org/brain.cgi?DDTNM > In some cultures what I do would be considered normal. > -- Ineffective daily affirmation > > _______________________________________________ > Xastir mailing list > [email protected] > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir > > _______________________________________________ Xastir mailing list [email protected] http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
