Hello Mark,
I looked, and the CRM uses MySQL and not PostGres. I was thinking maybe
using PostGres for the CRM, which might facilitate things with GeoServer.
The database would have a lot fo changes in the beginning, as we build
up the DB with our initial entry fo data. It would grow ove rtime, but
it would be incremental over time, as we find new data to enter.
So, if I understand you correctly:
- I would install the CRM and populate it with the data I need.
(includign latitude and longitude, amonst others.
- I would then create a PostGres DB and synchronize my MySQL data with a
POstGres DB.
- Mapserver would read the data from PostGres to display what is needed
on the screen.
Those points that are displayed, are they clickable?
IF so (for my project they need to be clickable, or the people doing the
search will not be able to see details on the files that meet the
criteria), how to we determine what is displayed? If it is displayed,
we will want to display additional information that what query criteria.
Last question before I sign off.
Like I state, we are looking at CRM to do this system. It seems to be
much easier than building a new interface and database. The CRM is well
advanced, very flexible, modifiable and a great price that fits our
budget. By removing a few modules, it seems to suit the project well.
When we have a project in the CRM, there are hard data typed right into
the profile: name, year, budget, etc...
But, we also have data that is "linked" to the project, like: Companies
and individuals. This is different from the hard data. Hard data has
a field, and whether you enter something in the field or note, the full
or empty field is displayed. For the "linked" style, there is a
heading, but if there are no "linked" files, nothing is displayed. But,
if there are things to display, the page adjusts downward to accommodate
the entries.
Can we have Geoserver grab the names of these "linked" files?
Thanks!
Joseph
On 02/22/2017 06:52 PM, Mark Cupitt wrote:
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]
<mailto:[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]
<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
<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
