Create MySQL DB for Data Exported from the ArcMap GeoDatabase

• 1) Open phpMyAdmin , Create a DB ARCMAP

  • Review at top of page for how to create DataBase with phpMyAdmin
     

• 2) Create a Table States: Click for Field Structure

  • How to create Table using phpMyAdmin
     

• 3) Populate Table & Review Records (SQL Insert  in above .txt file)

  • Review at top of page for how to populate DataBase with phpMyAdmin

Animation, 3d .dae cubes, points, pgons with ms_access or  mysql database
(cube height = State Population 1990 / 10)
 

Example NetLink's
To create a NetLink: Open GEarth > Add Menu > Network Link > paste a url below in the "Link" box > OK
Replace "jpwade.mooo.com" with "localhost"

• http://jpwade.mooo.com/test/odbc_states_3d.php3 (ms_access)
• http://jpwade.mooo.com/test/dae.php3 (ms_access)
• http://jpwade.mooo.com/test/odbc_states_pts_3d.php (ms_access)
• http://jpwade.mooo.com/test/odbc_capital_pts_3d.php (ms_access)
  • Point = State Capital , TimeSpan =  StateHood , Height = State Population 1990
     
• http://jpwade.mooo.com/test/mysql_states_3d.php (mysql)
• http://jpwade.mooo.com/test/mysql_states_pts.php (mysql)
• http://jpwade.mooo.com/test/mysql_states_pts_3d.php (mysql)
• http://jpwade.mooo.com/test/mysql_pgon.php (mysql with polygons)
   
• View Examples of Scripts
• MySQL Structure Info for the above NetLinks
   

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