[Geomoose-users] Highlight Parcel and runtime substitution

[Dan Little]

I might need some more clarity on what you mean. The query.php script
should limit the results to what you're searching. If you want to have
a "pre-configured" search filter then you'd need to use a sub-query in
your DATA statement.  Otherwise, check to make sure your metadata
variables are all set similarly to the parcels example.

I no longer have a running copy of GeoMoose 2.9 on my local system so
it takes me a bit longer to check on some of these references.
On Fri, Nov 30, 2018 at 1:14 PM Colas, Scott <Scott.Colas at ct.gov> wrote:
>
> 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> 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]
> 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> 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
> https://lists.osgeo.org/mailman/listinfo/geomoose-users