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>donny<br><p>