[mapserver-users] TIGER data Mapfile update.

[Basques, Bob (CI-StPaul)]

Tp whom it may concern . . .

I’ve recently been optimzing some MapServer layer MapFiles in our system for TIGER based centerline data to take advantage of the newer capabilities of MapServer.  The MapFile I’ve been working on recently  was just over 10 years old!!  Anyway, lot’s of new stuff for optimizing the Mapfile and I wanted to pass the results by the list to see if there is anything I may have missed.

For long time list users, you may remember my post in the past about setting up a “googlish” type layer style for MapServer way back when.  This is my refactoring of that MapFile to the new look and feel of the Google style(s).

This mapfile has mutiple CLASSes with many STYLE settings per CLASS.  So it ens up a bit complicated.

I’ve also switch all data sourcing over from SHP file to Postgres/PostGIS as well as consolidating the all the DATA connection calls into a single call.  While the old file ran very fast, this one comes back almost instantly now, even for very large images.

Here are a couple of fragments of the MAPFILE that I’ve currently set up, and just looking for thoughts on improving it even more.

Sample output is here:

https://www.dropbox.com/s/epdzrod6yvg7143/centerlines_stpaul_public.2.map?dl=0

 and the fragment below is for the Interstate roads, darker yellow color and Hwy Shields..

Thanks

bobb

. . . .
LAYER

#DEBUG 5

    NAME 'street centerlines'
    TYPE LINE
STATUS DEFAULT

CONNECTIONTYPE POSTGIS

INCLUDE "../../../../conf/spatial_db/connection_compass.inc"

DATA "wkb_geometry from (select
objectid,
-- cmmsparent,
-- cmmsid,
-- l_f_add,
-- r_f_add,
-- l_t_add,
-- r_t_add,
streetall,
-- f_xstreet,
-- t_xstreet,
-- msa_route,
-- ownership,
-- maintained,
-- stp_class,
-- rowclass,
-- speed_lim,
-- length_ft,
-- base,
-- surface,
-- parking_mi,
-- lane_mi,
-- oneway,
-- cmmschgreq,
-- streetname,
-- type,
-- sufdir,
hwy_numb,
f_class,
-- cencty_l,
-- cenmun_l,
-- censt_r,
-- cencty_r,
-- cenmun_r,
-- gnis_l,
-- gnis_r,
-- fips5_l,
-- fips5_r,
-- zip5_l,
-- zip5_r,
-- alt_nam1,
-- alt_nam2,
-- created_user,
-- created_date,
-- last_edited_user,
-- last_edited_date,
wkb_geometry
      from stpgis.stpaul_streetcenterline) as subquery using unique objectid using srid=200068"

    CLASSITEM 'f_class'
    LABELITEM ‘streetall'

. . . .

—————————————-


#######
# A10
#######

    CLASS
      #NAME 'US Interstate'  ## Using Interstate Shield Symbol Instead
      EXPRESSION 'A10' # interstates
      LABEL
        TYPE TRUETYPE
        FONT bluehigh
        SIZE 10
        COLOR 254 254 254
        MINDISTANCE 100
        MINFEATURESIZE 50
        OFFSET 0 0
        PARTIALS FALSE
TEXT '[hwy_numb]'   ## be careful here with the call, you need to quote the bracketed token !!
## Also, this is a multiple LABELITEM.
        STYLE
          SYMBOL 'interstate1_wide_back'
          SIZE 18
          COLOR 254 254 254 ## WHITE banner border
        END
        STYLE
          SYMBOL 'interstate1_wide_back'
          SIZE 16
          COLOR 255 0 0 ## RED banner
        END
        STYLE
          SYMBOL 'interstate1_wide_front'
          SIZE 18
          COLOR 254 254 254 ## WHITE shield border
        END
        STYLE
          SYMBOL 'interstate1_wide_front'
          SIZE 16
          COLOR 56 120 199 ## BLUE(ish) shield color
        END
      END


      STYLE
        OUTLINEWIDTH 1
        OUTLINECOLOR 175 175 175
        WIDTH 9
        COLOR 249 222 77
      MAXSCALEDENOM 20000
      END

      STYLE
      MINSCALEDENOM 20000
        OUTLINEWIDTH 1
        OUTLINECOLOR 175 175 175
        WIDTH 6
        COLOR 249 222 77
      MAXSCALEDENOM 25000
      END

      STYLE
      MINSCALEDENOM 25000
        OUTLINEWIDTH 1
        OUTLINECOLOR 175 175 175
        WIDTH 2
        COLOR 249 222 77
      END

    END
    TEMPLATE 'TEMPLATES/stpaul_record.html'
  TOLERANCE 15
  TOLERANCEUNITS pixels

  END ##end Layer




You miss 100 percent of the shots you never take.
—Wayne Gretzky

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20180108/7acdfea8/attachment.htm>