Error fix: Re: [Xastir] sample dbfawk files for 2007-FE census maps

Richard Polivka, N6NKO r.polivka at sbcglobal.net
Sun Apr 6 09:36:57 EDT 2008


I did an oops. On the H20 and H30 lines, I forgot the "; next" at the 
ends. I do not know if that will affect the parsing but is should be 
there anyway. I have also made some changes today to these and I will 
post them when I am finished.

Also, thanks to Tom Hayward and the others for providing the seeds to 
this project.

I will be sending the DVD's of the 2007FE files to Gerry Creager 
presently for him to install on his systems.

73 from 807,

Richard, N6NKO

Richard Polivka, N6NKO wrote:
> After spending a lot of time getting square eyeballs working on this, 
> in between pages from work, here appears to be a good starting point 
> for these files. I realize that there may be some tweaking necessary, 
> so try them out and post suggestions for changes.
>
> file: tgr2007arealm.dbfawk:
>
> # tgr2007arealm.dbfawk
> #
> # Copyright (C) 2003-2008  The Xastir Group
> #
> # Census.gov 2007-FE TigerMaps for AREALM
> # Richard Polivka, N6NKO - April, 2008
> #
> #
> # This dbfawk file is used to map arbitrary dbf data that accompanies
> # a shapefile into Xastir canoncical values of:
> #   key     - search key
> #   lanes   - width of feature (usually a road but applies to rivers, 
> etc. too)
> #   color   - color to draw the road
> #   name    - name of the road for labels
> #   filled  - whether a polygon is drawn filled or not
> #   fill_color - color to fill polygon with
> #   pattern - line pattern for road, river, etc. (0 - solid; 1 - dash; 
> 2 - double dash)
> #   display_level - highest zoom level at which to display the feature
> #   label_level - highest zoom level at which to display the label
> #   symbol  - 3 char 'TIO': table, ID, overlay
> # NOTE: This file format is modeled after awk but is nowhere near awk
> #  compatible.
> #
> # This file is used to map US Census Tiger/Line Shapefiles as 
> available at:
> # http://www.census.gov/cgi-bin/geo/shapefiles/national-files
> #
>
> # BEGIN is called once per dbf file which contains multiple records.
> BEGIN {
> # dbfinfo is the "signature" of the dbf file listing the column names 
> in order.
> # dbfinfo should match the dbf file that we say this dbfawk file goes 
> with.
> dbfinfo="STATEFP:COUNTYFP:COUNTYNS:ANSICODE:AREAID:FULLNAME:MTFCC";
> #dbffields is which of the above fields we actually want to look at.
> # No point reading dbffields that are not looked at further.
> dbffields="FULLNAME:MTFCC";
> }
>
> # BEGIN_RECORD is called once per dbf record which contains multiple 
> fields.
> # Use this rule to re-initialize variables between records.
> # use color 11 to highlight stuff that isn't properly mapped.
> BEGIN_RECORD {key=""; lanes=1; color=6; fill_color=11; name=""; 
> filled=0; pattern=0; display_level=8192; label_level=32; 
> label_color=8; font_size=0; symbol=""; fill_style=0 }
>
> /^FULLNAME=(.*)$/ {name="$1";next}
> # item locations
> /^MTFCC=C3/ {display_level=0; next}
> # water
> /^MTFCC=H20/ {filled=1; fill_style=2; fill_stipple=2; color=117; 
> fill_color=117; label_color=26; display_level=1024;}
> /^MTFCC=H30/ {filled=1; fill_style=2; fill_stipple=2; color=117; 
> fill_color=117; label_color=26; display_level=1024;}
> # buildings
> /^MTFCC=K/ {display_level=0; next}
> # PLCC
> /^MTFCC=L/ {display_level=0; next}
> # legal / statistical boundary
> /^MTFCC=P0001/ {display_level=0; next}
> # water shoreline
> /^MTFCC=P0002/ {display_level=1240; color=9; fill_color=9; next}
> # water intermittent shoreline
> /^MTFCC=P0003/ {display_level=1240; color=9; fill_color=9; next}
> # non-visible boundary
> /^MTFCC=P0004/ {display_level=0; next}
> # railroad
> /^MTFCC=R/ {lanes=1; color=8; pattern=1; display_level=128; next}
> # Limited access road
> /^MTFCC=S11/ {lanes=4; color=4; label_level=512; font_size=3; next}
> # secondary road
> /^MTFCC=S12/ {display_level=1024; lanes=3; color=8; label_level=256; 
> font_size=2; next}
> # local road
> /^MTFCC=S14/ {display_level=256; label_level=16; color=40; lanes=1; next}
> # 4WD off-road trail
> /^MTFCC=S15/ {lanes=2; color=40; display_level=64; font_size=1; next}
> # Freeway access / service drive
> /^MTFCC=S16/ {color=40; display_level=64; next}
> # walkway / stairway
> /^MTFCC=S17[12]/ {lanes=1; color=12; pattern=2; display_level=64; next}
> # alley / private road
> /^MTFCC=S17[34]/ {lanes=1; color=40; pattern=2; display_level=64; next}
> # bike / bridle path
> /^MTFCC=S18/ {lanes=1; color=40; pattern=2; display_level=64; next}
> # road median
> /^MTFCC=S20/ {lanes=1; color=40; pattern=2; display_level=64; next}
> # just a demo of the END_RECORD and END rules:
> #END_RECORD {name="$name ($key)";}
> #END {}
>
> ---------------------------------------------------------------------------------------------- 
>
>
> file: tgr2007areawater.dbfawk
>
> # tgr2007areawater.dbfawk
> #
> # Copyright (C) 2003-2008  The Xastir Group
> #
> # Census.gov 2007-FE TigerMaps for AREAWATER
> # Richard Polivka, N6NKO - April, 2008
> #
> #
> # This dbfawk file is used to map arbitrary dbf data that accompanies
> # a shapefile into Xastir canoncical values of:
> #   key     - search key
> #   lanes   - width of feature (usually a road but applies to rivers, 
> etc. too)
> #   color   - color to draw the road
> #   name    - name of the road for labels
> #   filled  - whether a polygon is drawn filled or not
> #   fill_color - color to fill polygon with
> #   pattern - line pattern for road, river, etc. (0 - solid; 1 - dash; 
> 2 - double dash)
> #   display_level - highest zoom level at which to display the feature
> #   label_level - highest zoom level at which to display the label
> #   symbol  - 3 char 'TIO': table, ID, overlay
> # NOTE: This file format is modeled after awk but is nowhere near awk
> #  compatible.
> #
> # This file is used to map US Census Tiger/Line Shapefiles as 
> available at:
> # http://www.census.gov/cgi-bin/geo/shapefiles/national-files
> #
>
> # BEGIN is called once per dbf file which contains multiple records.
> BEGIN {
> # dbfinfo is the "signature" of the dbf file listing the column names 
> in order.
> # dbfinfo should match the dbf file that we say this dbfawk file goes 
> with.
> dbfinfo="STATEFP:COUNTYFP:COUNTYNS:ANSICODE:HYDROID:FULLNAME:MTFCC";
> #dbffields is which of the above fields we actually want to look at.
> # No point reading dbffields that are not looked at further.
> dbffields="FULLNAME:MTFCC";
> }
>
> # BEGIN_RECORD is called once per dbf record which contains multiple 
> fields.
> # Use this rule to re-initialize variables between records.
> # use color 11 to highlight stuff that isn't properly mapped.
> BEGIN_RECORD {key=""; lanes=1; color=26; fill_color=26; name=""; 
> filled=0; pattern=0; display_level=8192; label_level=32; 
> label_color=26; font_size=0; symbol=""; fill_style=0 }
>
> /^FULLNAME=(.*)$/ {name="$1";next}
> # item locations
> /^MTFCC=C3/ {display_level=0; next}
> # water
> /^MTFCC=H20/ {filled=1; fill_style=2; fill_stipple=2; color=117; 
> fill_color=117; label_color=26; display_level=1024;}
> /^MTFCC=H30/ {filled=1; fill_style=2; fill_stipple=2; color=117; 
> fill_color=117; label_color=26; display_level=1024;}
> # buildings
> /^MTFCC=K/ {display_level=0; next}
> # PLCC
> /^MTFCC=L/ {display_level=0; next}
> # legal / statistical boundary
> /^MTFCC=P0001/ {display_level=0; next}
> # water shoreline
> /^MTFCC=P0002/ {display_level=1240; color=9; fill_color=9; next}
> # water intermittent shoreline
> /^MTFCC=P0003/ {display_level=1240; color=9; fill_color=9; next}
> # non-visible boundary
> /^MTFCC=P0004/ {display_level=0; next}
> # railroad
> /^MTFCC=R/ {lanes=1; color=8; pattern=1; display_level=128; next}
> # Limited access road
> /^MTFCC=S11/ {lanes=4; color=4; label_level=512; font_size=3; next}
> # secondary road
> /^MTFCC=S12/ {display_level=1024; lanes=3; color=8; label_level=256; 
> font_size=2; next}
> # local road
> /^MTFCC=S14/ {display_level=256; label_level=16; color=40; lanes=1; next}
> # 4WD off-road trail
> /^MTFCC=S15/ {lanes=2; color=40; display_level=64; font_size=1; next}
> # Freeway access / service drive
> /^MTFCC=S16/ {color=40; display_level=64; next}
> # walkway / stairway
> /^MTFCC=S17[12]/ {lanes=1; color=12; pattern=2; display_level=64; next}
> # alley / private road
> /^MTFCC=S17[34]/ {lanes=1; color=40; pattern=2; display_level=64; next}
> # bike / bridle path
> /^MTFCC=S18/ {lanes=1; color=40; pattern=2; display_level=64; next}
> # road median
> /^MTFCC=S20/ {lanes=1; color=40; pattern=2; display_level=64; next}
> # just a demo of the END_RECORD and END rules:
> #END_RECORD {name="$name ($key)";}
> #END {}
>
> -------------------------------------------------------------------------------------------------------- 
>
> file: tgr2007edge.dbfawk
>
> # tgr2007edge.dbfawk
> #
> # Copyright (C) 2003-2008  The Xastir Group
> #
> # Census.gov 2007-FE TigerMaps for EDGE
> # Richard Polivka, N6NKO - April, 2008
> #
> #
> # This dbfawk file is used to map arbitrary dbf data that accompanies
> # a shapefile into Xastir canoncical values of:
> #   key     - search key
> #   lanes   - width of feature (usually a road but applies to rivers, 
> etc. too)
> #   color   - color to draw the road
> #   name    - name of the road for labels
> #   filled  - whether a polygon is drawn filled or not
> #   fill_color - color to fill polygon with
> #   pattern - line pattern for road, river, etc. (0 - solid; 1 - dash; 
> 2 - double dash)
> #   display_level - highest zoom level at which to display the feature
> #   label_level - highest zoom level at which to display the label
> #   symbol  - 3 char 'TIO': table, ID, overlay
> # NOTE: This file format is modeled after awk but is nowhere near awk
> #  compatible.
> #
> # This file is used to map US Census Tiger/Line Shapefiles as 
> available at:
> # http://www.census.gov/cgi-bin/geo/shapefiles/national-files
> #
>
> # BEGIN is called once per dbf file which contains multiple records.
> BEGIN {
> # dbfinfo is the "signature" of the dbf file listing the column names 
> in order.
> # dbfinfo should match the dbf file that we say this dbfawk file goes 
> with.
> dbfinfo="STATEFP:COUNTYFP:COUNTYNS:TLID:TFIDL:TFIDR:MTFCC:FULLNAME:SMID:LFROMADD:LTOADD:RFROMADD:RTOADD:ZIPL:ZIPR:FEATCAT:HYDROFLG:RAILFLG:ROADFLG:OLFFLG:PASSFLG:DIVROAD:EXTTYP:TTYP:DECKEDROAD:ARTPATH"; 
>
> #dbffields is which of the above fields we actually want to look at.
> # No point reading dbffields that are not looked at further.
> dbffields="TLID:MTFCC:FULLNAME";
> }
>
> # BEGIN_RECORD is called once per dbf record which contains multiple 
> fields.
> # Use this rule to re-initialize variables between records.
> # use color 11 to highlight stuff that isn't properly mapped.
> BEGIN_RECORD {key=""; lanes=1; color=6; fill_color=11; name=""; 
> filled=0; pattern=0; display_level=8192; label_level=32; 
> label_color=8; font_size=0; symbol=""; fill_style=0 }
>
> /^FULLNAME=(.*)$/ {name="$1";next}
> # item locations
> /^MTFCC=C3/ {display_level=0; next}
> # water
> /^MTFCC=H20/ {filled=1; fill_style=2; fill_stipple=2; color=117; 
> fill_color=117; label_color=26; display_level=1024;}
> /^MTFCC=H30/ {filled=1; fill_style=2; fill_stipple=2; color=117; 
> fill_color=117; label_color=26; display_level=1024;}
> # buildings
> /^MTFCC=K/ {display_level=0; next}
> # PLCC
> /^MTFCC=L/ {display_level=0; next}
> # legal / statistical boundary
> /^MTFCC=P0001/ {display_level=0; next}
> # water shoreline
> /^MTFCC=P0002/ {display_level=1240; color=9; fill_color=9; next}
> # water intermittent shoreline
> /^MTFCC=P0003/ {display_level=1240; color=9; fill_color=9; next}
> # non-visible boundary
> /^MTFCC=P0004/ {display_level=0; next}
> # railroad
> /^MTFCC=R/ {lanes=1; color=8; pattern=1; display_level=128; next}
> # Limited access road
> /^MTFCC=S11/ {lanes=4; color=4; label_level=512; font_size=3; next}
> # secondary road
> /^MTFCC=S12/ {display_level=1024; lanes=3; color=8; label_level=256; 
> font_size=2; next}
> # local road
> /^MTFCC=S14/ {display_level=256; label_level=16; color=40; lanes=1; next}
> # 4WD off-road trail
> /^MTFCC=S15/ {lanes=2; color=40; display_level=64; font_size=1; next}
> # Freeway access / service drive
> /^MTFCC=S16/ {color=40; display_level=64; next}
> # walkway / stairway
> /^MTFCC=S17[12]/ {lanes=1; color=12; pattern=2; display_level=64; next}
> # alley / private road
> /^MTFCC=S17[34]/ {lanes=1; color=40; pattern=2; display_level=64; next}
> # bike / bridle path
> /^MTFCC=S18/ {lanes=1; color=40; pattern=2; display_level=64; next}
> # road median
> /^MTFCC=S20/ {lanes=1; color=40; pattern=2; display_level=64; next}
> # just a demo of the END_RECORD and END rules:
> #END_RECORD {name="$name ($key)";}
> #END {}
>
> ----------------------------------------------------------------------------------------------- 
>
>
> file: tgr2007pointlm.dbfawk
>
> # tgr2007pointlm.dbfawk
> #
> # Copyright (C) 2003-2008  The Xastir Group
> #
> # Census.gov 2007-FE TigerMaps for POINTLM
> # Richard Polivka, N6NKO - April, 2008
> #
> #
> # This dbfawk file is used to map arbitrary dbf data that accompanies
> # a shapefile into Xastir canoncical values of:
> #   key     - search key
> #   lanes   - width of feature (usually a road but applies to rivers, 
> etc. too)
> #   color   - color to draw the road
> #   name    - name of the road for labels
> #   filled  - whether a polygon is drawn filled or not
> #   fill_color - color to fill polygon with
> #   pattern - line pattern for road, river, etc. (0 - solid; 1 - dash; 
> 2 - double dash)
> #   display_level - highest zoom level at which to display the feature
> #   label_level - highest zoom level at which to display the label
> #   symbol  - 3 char 'TIO': table, ID, overlay
> # NOTE: This file format is modeled after awk but is nowhere near awk
> #  compatible.
> #
> # This file is used to map US Census Tiger/Line Shapefiles as 
> available at:
> # http://www.census.gov/cgi-bin/geo/shapefiles/national-files
> #
>
> # BEGIN is called once per dbf file which contains multiple records.
> BEGIN {
> # dbfinfo is the "signature" of the dbf file listing the column names 
> in order.
> # dbfinfo should match the dbf file that we say this dbfawk file goes 
> with.
> dbfinfo="STATEFP:COUNTYFP:COUNTYNS:POINTID:FULLNAME:MTFCC";
> #dbffields is which of the above fields we actually want to look at.
> # No point reading dbffields that are not looked at further.
> dbffields="FULLNAME:MTFCC";
> }
>
> # BEGIN_RECORD is called once per dbf record which contains multiple 
> fields.
> # Use this rule to re-initialize variables between records.
> # use color 11 to highlight stuff that isn't properly mapped.
> BEGIN_RECORD {key=""; lanes=1; color=6; fill_color=11; name=""; 
> filled=0; pattern=0; display_level=8192; label_level=32; 
> label_color=8; font_size=0; symbol=""; fill_style=0 }
>
> /^FULLNAME=(.*)$/ {name="$1";next}
> # item locations
> /^MTFCC=C3/ {display_level=0; next}
> # water
> /^MTFCC=H20/ {filled=1; fill_style=2; fill_stipple=2; color=117; 
> fill_color=117; label_color=26; display_level=1024;}
> /^MTFCC=H30/ {filled=1; fill_style=2; fill_stipple=2; color=117; 
> fill_color=117; label_color=26; display_level=1024;}
> # buildings
> /^MTFCC=K/ {pattern=0; fill_style=2; fill_stipple=2; fill_color=43; next}
> # PLCC
> /^MTFCC=L/ {display_level=0; next}
> # legal / statistical boundary
> /^MTFCC=P0001/ {display_level=0; next}
> # water shoreline
> /^MTFCC=P0002/ {display_level=1240; color=9; fill_color=9; next}
> # water intermittent shoreline
> /^MTFCC=P0003/ {display_level=1240; color=9; fill_color=9; next}
> # non-visible boundary
> /^MTFCC=P0004/ {display_level=0; next}
> # railroad
> /^MTFCC=R/ {lanes=1; color=8; pattern=1; display_level=128; next}
> # Limited access road
> /^MTFCC=S11/ {lanes=4; color=4; label_level=512; font_size=3; next}
> # secondary road
> /^MTFCC=S12/ {display_level=1024; lanes=3; color=8; label_level=256; 
> font_size=2; next}
> # local road
> /^MTFCC=S14/ {display_level=256; label_level=16; color=40; lanes=1; next}
> # 4WD off-road trail
> /^MTFCC=S15/ {lanes=2; color=40; display_level=64; font_size=1; next}
> # Freeway access / service drive
> /^MTFCC=S16/ {color=40; display_level=64; next}
> # walkway / stairway
> /^MTFCC=S17[12]/ {lanes=1; color=12; pattern=2; display_level=64; next}
> # alley / private road
> /^MTFCC=S17[34]/ {lanes=1; color=40; pattern=2; display_level=64; next}
> # bike / bridle path
> /^MTFCC=S18/ {lanes=1; color=40; pattern=2; display_level=64; next}
> # road median
> /^MTFCC=S20/ {lanes=1; color=40; pattern=2; display_level=64; next}
> # just a demo of the END_RECORD and END rules:
> #END_RECORD {name="$name ($key)";}
> #END {}
>
> ----------------------------------------------------------------------------------------------------------- 
>
>
> 73 from 807,
>
> Richard, N6NKO
>
> _______________________________________________
> Xastir mailing list
> Xastir at xastir.org
> http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
>



More information about the Xastir mailing list