1 / 9

Restaurant Database

Restaurant Database. Food across California. Rebecca Flores GEOG 375. OBJECTIVE. Create a script to query out chosen counties in a geodatabase to then be exported to a KMZ file for easy viewing in Google earth. DATA COLLECTION. Counties and State (CA) from www.atlas.ca.gov

dragon
Download Presentation

Restaurant Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Restaurant Database Food across California Rebecca Flores GEOG 375

  2. OBJECTIVE • Create a script to query out chosen counties in a geodatabase to then be exported to a KMZ file for easy viewing in Google earth

  3. DATA COLLECTION • Counties and State (CA) from www.atlas.ca.gov • Excel spreadsheet for data collection of restaurant locations

  4. REQUIREMENTS • Plotted points • Accessible from Microsoft Access • Multiple attributes • Searchable by county

  5. DATABASE Personal Geodabase: • Restaurant Locations (points) • Counties • States

  6. PYTHON Set up of the script. This section contains basic information such as file names, and file locations.

  7. PYTHON In this next section, I am running creating a layer, running a query, copying those results, creating a new query, and then exporting my features to KMZ file

  8. PYTHON I included the except clause you provided to help me locate problems in my script, if any.

  9. FINAL RESULT An example of my final results in Google earth. You can see the Attributes which were in my original Restaurant feature class.

More Related