Hey Bob, Is there any chance you can start a GitHub repo with an appropriate license and maybe some screenshots for this? It's hard to use dropbox as a collaboration platform...
Cheers, -Duck On Mon, Jan 8, 2018 at 1:39 PM, Basques, Bob (CI-StPaul) < [email protected]> wrote: > 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 > > > _______________________________________________ > mapserver-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/mapserver-users >
_______________________________________________ mapserver-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users
