Hi Donny,<br><br>You can certainly put your points data in a single table in mysql<br><br>Step 1: you have to add a column of int auto_increment type and name it GID<br>Step 2: Add a column of type geometry<br>Step 3: lets say that you have two columns containing latitude and longitude in degree decimals. you have to populate the geometry column by concatenating the lat and long values and generate a point using the pointfromtext function in mysql.<br>
<br>heres how you do it:<br>ALTER TABLE mypointstable ADD GID int(11) PRIMARY KEY AUTO_INCREMENT NOT NULL; <br>ALTER TABLE mypointstable ADD GEOMETRY GEOMETRY NOT NULL;<br>UPDATE mypointstable SET GEOMETRY = PointFromText(CONCAT('POINT(',mypointstable .longitude,' ',mypointstable .latitude,')4326')); <br>
/*========4326 is the EPSG code for WGS84 datum*/<br>/*========Add a spatial index to geometry field */<br>ALTER TABLE mypointstable ADD SPATIAL INDEX ( 'GEOMETRY' ) ;<br><br>Step 4: Use the mypointstable and define it accordingly in map file to view it in ms4w. <br>
also take a look at the url below<br><a href="http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?MySQL">http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?MySQL</a><br><br>Hope this helps<br>-- <br>Dr. Anand Akmanchi<br>Lecturer in Geoinformatics<br>
Department of Geography<br>University of Pune<br>========================================<br>"Man's mind, once stretched by a new idea, never regains its original dimensions." - Oliver Wendell Holmes<br>========================================<br>
<br> <br><br><div class="gmail_quote">On Tue, Jun 3, 2008 at 12:58 AM, donny wicaks <<a href="mailto:donnywicaks@yahoo.com">donnywicaks@yahoo.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
hello, my name is donny wicaksono, from indonesia<br><br>i'm developing a web-gis, i use windows as operating system, i use ms4w 2.2.6 with apache 2.2.4, php 5.2.4 and chameleon 2.4. <br>for database, i use mysql 2.6.0<br>
<br>i have difficulties, and i really hope that i can get any help from any of you in this mailing list.<br><br>this is what i have already done:<br>1. when you extract chameleon to your ms4w, so you have the samples of applications of chameleon. <br>
including the data (shapefiles, images), chameleon.map file, *.html for templates *.phtml, and chameleon.php.<br><br>2. i have data : a shapefile of a region (for the base map), and tabular data of points with coordinates in degree-minutes-seconds and other relevant data.<br>
<br>3. first, i convert the coordinates of the points into decimal-degree/longitude-lattitude manually by using ms-excel.<br><br>4. then by using arcview, i convert the points that are already in decimal-degree/longitude-latitude, into
shapefile (shp)<br><br>5. then i modify the already existed chameleon.map. i eliminate all unnecessary layers and i add my own layers : my_base_map.shp, and several points.shp<br>then i save chameleon.map as another name.<br>
<br>6. then i modify the already existed, for example: sample_enhanced.html and sanmple_enhanced.phtml and save them as other name.<br><br>7. for php file i use the already existed chameleon.php<br>and i also have made the httpd_*.conf for it<br>
<br>8. and the web-gis is working fine! all the layers can be displayed on and off, all the navigation tools are working fine: zoom in, out, recenter, pan and so is the query/identify button.<br><br><br><br>my difficulties are:<br>
1. you can read my description above that i convert points data with coordinates into a shapefile and then put it in *.map file. <br>then i realize that if i want to add some more points, then i will keep repeating the same procedures. <br>
i mean, i will have to make a new shapefile
for every points that are added and then add the new shapefile (points.shp) to the *.map<br>and the points are not supposed to become one layer, but a group of points become one layer, another group of layer become one layer, and so on. so i have five layers of points.<br>
<br>2. then it is related to the query process. when i convert the points in, let's say "points.shp", the database of the shapefile will be stored in "points.dbf".<br>when i hit the query button / identify feature button in chameleon, the query result will display every data in "points.dbf".<br>
the data in "points.dbf" are only coordinates data and points_id<br>while i have already develop the data in mysql in appropriate database management systems<br><br><br><br>my questions are:<br>1. is there any way to make layers, that can be displayed on the web-gis (the map), from the points by using their coordinates data in decimal-degrees/longitude-latitude that are stored in mysql?<br>
so i don't have to
convert it first into shapefile (*.shp)<br><br>if that can be done, what kind of modification i should do? <br>if you know the coding for that, please write it also.<br><br>what kind of code should i write in *.map file, *.php file, *.html file and *.phtml file in order to make the application works?<br>
<br>2. what code should i write to link the map with mysql database?<br>where should i write that code? in *.map file, *.php file, *.html file and *.phtml file or in other file? maybe in querywidget.php? if so, what is the code?<br>
<br>if this can be done, i'm sure that the query will become more dynamic. you will help me a lot!!<br><br>i think it's all my question. i'm sorry if my post is too long, it's just because i want to explain competely about what i've done and what are my obstacles.<br>
<br>i will appreciate any help and response from any of you<br>i thank you before..<br><br>regards,<br><font color="#888888">donny<br><p>
</p></font><br>_______________________________________________<br>
Chameleon mailing list<br>
<a href="mailto:Chameleon@lists.maptools.org">Chameleon@lists.maptools.org</a><br>
<a href="http://lists.maptools.org/mailman/listinfo/chameleon" target="_blank">http://lists.maptools.org/mailman/listinfo/chameleon</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Dr. Anand Akmanchi<br>Lecturer in Geoinformatics<br>Department of Geography<br>University of Pune<br>========================================<br>"Man's mind, once stretched by a new idea, never regains its original dimensions." - Oliver Wendell Holmes<br>
========================================