[mapserver-users] Possible application questions

Sun Feb 26 20:54:38 PST 2017

Hello Steve

Thanks for your feedback so far.  It is slowly painting a picture for me.

Before we start the CRM DB, we need ot determine if a mapping software 
can with with the CRM DB.  You seem to say this.

We do not want to start the DB in a software, only have to export it 
once done, to a new DB software.  The Ma[pserver part wil be done once 
the DB part is done.  Why, the budget is ready for the DB part, but not 
yet for the mapserver part.

So, a simple scenario would be:

-My CRM database is populated with various data concerning projects that 
we want to map out in Map server, including longitude and latitude.  
This coudl include: year, budget, different project paramaters, etc...

-Mapserver is configured to be able to read the CRM DB.  There will be 
various fields that will be searchable by definable fields in Mapserver.

-Mapserver is able to peruse through the CRM DB and grab the data that 
it needs to display on the map, according to defined choices in our search.

-Mapserver displays the files that meet the given criteria.

This sound right?

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 Mapserver grab the names of these "linked" files?

Thanks!

Joseph

On 02/22/2017 09:32 AM, Steve.Toutant at inspq.qc.ca wrote:
> WMS and WFS are ogc standards to share maps over the web, intranet ...
> https://en.wikipedia.org/wiki/Web_Map_Service
>
> You will not export data from the database. Mapserver will be 
> connected to your mysql DB and render maps as a service.
> Those services can be viewed by gis softwares or web applications
> steve
>
>
>
>
> De : Joe Hogan <joehogan at gmx.com>
> A : Steve.Toutant at inspq.qc.ca
> Cc : mapserver-users at lists.osgeo.org
> Date : 2017-02-21 11:14
> Objet : Re: [mapserver-users] Possible application questions
> ------------------------------------------------------------------------
>
>
>
> Hello Steve,
>
> Thanks for the reassuring news.  We have found our possible solution.
>
> The CRM software has not yet been modified, but it will have the two 
> fields for the Longitude and Latitude.
>
> Other fields will be used as well, and we will have to add more for 
> those.
>
> When you say it has to provide wms/wfs services, what does that mean?  
> I found the 9nitials, but what does it mean?
>
> Is it a special format?  Like I need to export the data from the data 
> base into a certain format?
>
> Sorry for the newbie questions, but I am learning:)
>
> Thanks
>
> Joseph
>
>
> On 02/21/2017 08:48 AM, _Steve.Toutant at inspq.qc.ca_ 
> <mailto:Steve.Toutant at inspq.qc.ca>wrote:
>
> hi Joseph
> Yes mapserver can be used for your application by providing wms/wfs 
> services
> Here are some links that can help
> #connect to mysql_
> __http://mapserver.org/input/vector/mysql.html_
>
> #filters...Runtime substitution_
> __http://mapserver.org/cgi/runsub.html_
>
> Do you have latitude/longitude data in your database, or any other 
> georeference that can be used to render on a map?
> Steve
>
>
> -----"mapserver-users" _<mapserver-users-bounces at lists.osgeo.org>_ 
> <mailto:mapserver-users-bounces at lists.osgeo.org>a écrit : -----
> A : _mapserver-users at lists.osgeo.org_ 
> <mailto:mapserver-users at lists.osgeo.org>
> De : Joe Hogan
> Envoyé par : "mapserver-users"
> Date : 20/02/2017 11:12
> Objet : [mapserver-users] Possible application questions
>
> Hello,
>
> I am writing to ask if MapServer will work for our application.
>
> We are working on a project that will allow us to place on a map of our
> country various projects.  We want to be able to filter them based on
> various pieces 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 database?), or does it need to be exported before using in the
> mapping software?
> 3 - It it needs to be in its own exported format, how to I get it from
> MtSQL to the correct format?
>
>
> Thanks for any and all help.
>
> Joseph
>
> _______________________________________________
> mapserver-users mailing list_
> __mapserver-users at lists.osgeo.org_ 
> <mailto:mapserver-users at lists.osgeo.org>_
> __https://lists.osgeo.org/mailman/listinfo/mapserver-users_
>
> Si vous n'êtes pas le destinataire de ce message, veuillez le détruire 
> près avoir informé l'expéditeur de son erreur. Par ailleurs, il est 
> interdit de copier ou de modifier ce courriel sans l'autorisation de 
> l'auteur.
>
> L'Institut national de santé publique du Québec n'assume aucune 
> responsabilité à l'égard du contenu des messages personnels envoyés 
> par ses employés.
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20170226/50211876/attachment.html>