Add Polygons From ArcMap to MySQL DB:
 View MySQL Structure Info / without pgon field

• From ESRI Data States, Select a State pgon and Export to kml
• Open Kml with G Earth and Save As to hard drive
• Navigate to folder and rename filename.kmz to filename.zip
• Extract to same folder , and open doc.kml with notepad/wordpad
   
• Open phpMyAdmin
  
  
  • 1) Select Database
  • 2) Select Table
  • 3) Select Structure
  • 4) Add a field
  • 5) Click Go
  • 6 ,7) name = pgon , type = TEXT > Save Button
     
• From opened doc.kml , copy string of coords between <coordinates> </coordinates>
   
  • Go back to phpMyAdmin:
     
    • 8) Select Browse
    • 9) Edit  Record that Polygon Cords belong to
      
      
      
       
    • 10 , 11) Paste string of coords into Value Box , Click Go Button
      
      
      
     
     
• View Script Example - How pgon coords are called
  
  Formal Script Information & Additional Links
  • Using PHP and MySQL to create KML - Tutorial by Mano Marks 
  • Getting Started With Spatial Mysql  (Polygons - Lines - Points)
  • Adding Custom Data  (Balloon Windows)

An introduction to setting up a Apache WebServer, using phpMyAdmin, connecting to a MS_Access or MySql database
  to display attributes in GEarth and Gmaps, GEarth API,  etc

SetUp a Home WebServer

Using PHP and MySQL to Create KML

Set your Apache Server for ArcMap Geodatabase

Zip File Contents and  Explination of Scripts (includes GEarth API)

Create MySQL DB from Exported Data of the ArcMap GeoDatabase

Add Polygons From ArcMap to MySQL DB

Put Your Server On-Line, Tool Tips, Other

Index Page    |    Home Page