[Geomoose-users] Highlight Parcel and runtime substitution

[Colas, Scott]

Hi Dan,
I switched over to query.php and its working properly also im using Geomoose 2.9.3 . I am not using a shp file like the parcles.map demo. So my question is  How do I limit what my layer only to what my service is searching for .

For example)

Here my DATA input for my layer. It loads everything from the table.
LAYER
      INCLUDE "../../connection.map"
    DATA "geometry3857 FROM [ASSETS].[ProjectWorkAreas] USING SRID=3857"
    PROCESSING "NATIVE_FILTER=([Proposed] = 0)"
       LABELITEM "ProjectNumber"
       NAME "LocalProjectPolygons"
       TYPE POLYGON

       CLASS
              NAME "05 Construction"
              TEXT "[ProjectNumber]"
              LABEL
                     MAXSCALEDENOM 28000
                     FONT "vera_sans"
                     SIZE 10
                     ALIGN CENTER
                     COLOR 255 0 0
                     OUTLINECOLOR 255 255 255
                     OUTLINEWIDTH 8
                     POSITION AUTO
                     TYPE TRUETYPE
              END # LABEL

Because it loads everything My layer class applies to everything . How can I get my class to only apply to whatever my service is querying for?

Thank you for your help
-Scott

From: Dan Little [mailto:theduckylittle at gmail.com]
Sent: Wednesday, November 28, 2018 3:21 PM
To: Colas, Scott
Cc: GeoMOOSE Users List
Subject: Re: [Geomoose-users] Highlight Parcel and runtime substitution

Hi Scott,

This sounds like you're trying to do a special version of GeoMoose's search. I think if you look at the parcels mapfile and the way query.php is configured for search you'll be able to make some small changes to your mapfile, configure a new service that users query.php, and doing everything you want!

Cheers.

On Wed, Nov 28, 2018 at 2:19 PM Colas, Scott <Scott.Colas at ct.gov<mailto:Scott.Colas at ct.gov>> wrote:
Thanks Dan,
After tweaking the parameters in query.php will my parameter be available in my map file so I can filter on the parameter?

-Scott

From: Dan Little [mailto:theduckylittle at gmail.com<mailto:theduckylittle at gmail.com>]
Sent: Wednesday, November 28, 2018 10:47 AM
To: Colas, Scott
Cc: GeoMOOSE Users List
Subject: Re: [Geomoose-users] Highlight Parcel and runtime substitution

Hi Scott,

Is this a GeoMoose 2.9-based application? Looks like it if you're using "GeoMOOSE...".

Check out query.php and the various services that use it.  You should be able to either make your own derivative version of the service, or tweak the query.php input parameters to get the result you want using you mapbook.

Cheers.


On Wed, Nov 28, 2018 at 8:19 AM Colas, Scott <Scott.Colas at ct.gov<mailto:Scott.Colas at ct.gov>> wrote:
Hello All,
I have  a service that does a search for a project. My goal is to zoom to this project and highlight. I can zoom to this project using GeoMOOSE.zoomToPointsList, but I cannot highlight the area.
In my map file I am using filterItem and filter.
How do I send my variable from a service to a map file so I can filter on this variable?

  LAYER
      INCLUDE "../../db_connection"
    DATA "geometry3857 FROM [ASSETS].[ProjectWorkAreas] USING UNIQUE AreaID USING SRID=3857"
    PROCESSING "NATIVE_FILTER=([IsProposed] = 0)"
       LABELITEM "ProjectNumber"
       CLASSITEM "PROJ_CURRENT_PHASE"
       NAME "LocalhProjectPolygons"
       TYPE POLYGON
       VALIDATION
        "PROJECTNUM" "[0-9]+"
       END

FILTERITEM "ProjectNumber"
       FILTER "%PROJECTNUM%"

       CLASS
              NAME "05 Construction"
              EXPRESSION "05_Construction"
              TEXT "%PROJECTNUM%"
              LABEL
                     MAXSCALEDENOM 28000
                     FONT "vera_sans"
                     SIZE 10
                     ALIGN CENTER
                     COLOR 255 0 0

Thank you,
-Scott
_______________________________________________
Geomoose-users mailing list
Geomoose-users at lists.osgeo.org<mailto:Geomoose-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/geomoose-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20181130/944a9c29/attachment-0001.html>