write shp files from MS Access MS SQL

[Bart van den Eijnden]

Hi,

you could do this by setting up an ovf file for your database 
connection+table. Then with ogr2ogr you can create a shapefile from it.

Check the following:
-for ovf files (virtual spatial data): http://www.gdal.org/ogr/drv_vrt.html
-for ogr2ogr syntax: http://www.gdal.org/ogr/ogr2ogr.html

There is a php module for OGR, which might be useable for this 
(otherwise the next generation SWIG binding for OGR could also be useable):

-for PHP/ogr module: http://dl.maptools.org/dl/php_ogr/

Best regards,
Bart

william paul wrote:

> Hello:
>  
> It is possible to write shp files from a MS Access database or a MS 
> SQL database. I am working with both MS Access and MS SQL. I work on a 
> data entry form. Some fields are for geographic coordinates. When the 
> form is submitted I want to write shp file using the fields with the 
> coordinates from the database, so the features appear on the map in 
> real time
>  
> Does someone give me some examples or some links from where I can read 
> more?
>  
> Thank you
>  
> William
>
> ------------------------------------------------------------------------
> Yahoo! Music Unlimited - Access over 1 million songs. Try it free. 
> <http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yahoo.com/unlimited/> 




-- 
+------------------------+
| Bart van den Eijnden   |
| OSGIS, Open Source GIS |
| http://www.osgis.nl    |
+------------------------+