Hi Joe, just to build a little on Simone's answer, a lot would depend on
how dynamic your data was .. if it changed slowly over time, exporting it
to another format might work .. you could use a script to csv or kml, etc
on a daily basis.
There would be a number of ways to approach it .. This of course assumes
you actually have the coordinates in the MySql database ..
Personally, to achieve the filtering you want, I would do it in Postgres,
add a Postgres database to the server, then use a synchronising script on
the server run on a cron .. check the sql database for changes then update
the postgres database.
Regards
Mark Cupitt
"Never give up .. its the end if you do .. find a way .. dig deep .."
"If we change the world, let it bear the mark of our intelligence"
On Tue, Feb 21, 2017 at 12:06 AM, Joe Hogan <[email protected]> wrote:
> Hello,
>
> I am writing to ask if GeoServer will work for our application.
>
> We are working on a project that willllow us to place on a map of our
> country various projects. WE want to be able to filter them based on
> various piecs of information, including, for example:
>
> year of project
> population
> project budget
> etc...
>
> We are compiling the data in a CRM(MySQL database), and want to use the
> data from the CRM to feed the mapping software.
>
> 1 - can I map the type fo information that I need?
> 2 - can we use the data directly from the CRM database if we tell the
> mapping software what data to use(so t can be read on the fly, live from
> the databe?), or does it need to be exported before using inthe mapping
> software?
> 3 - It it needs to be in its own exported format, how to I get it from
> MtSQL tothe correct format?
>
>
> Thanks for any and all help.
>
> Joseph
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
