San Francisco Restaurants Database

The San Francisco Restaurants Database contains location data for restaurant and food establishments in the area. Also included is an identifier filed that indicates if a Symbol of Excellenc...

Ready for your workflow

Flexible data delivery

Delivered files
UTF-8 CSV, JSON, SQLite, schemas, samples, statistics, documentation, and tier-specific ZIP bundles.
Updates
Current release 1.0.2 dated February 4, 2011. Update eligibility follows the selected license.
Preview sample data
Choose your licensePurchase once. Download immediately.
Secure checkout
Usage RightsRead-only internal use.
$20.00
Master RightsBroadest usage rights and available updates.Current update offer$5.00For eligible earlier Master purchases
$80.00
Records
5,475
Version
1.0.2
Release date
Feb 4, 2011
Before you choose
Explore the samples

San Francisco Restaurants Database v.1.0.2

5,475 SF Restaurants

San Francisco Restaurants Database catalog icon San Francisco Restaurants Database Download
San Francisco Restaurants Database artwork
The San Francisco Restaurants Database contains location data for restaurant and food establishments in the area. Also included is an identifier filed that indicates if a Symbol of Excellence has been awarded from the last inspection.
5,475 SF Restaurants Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO
Restaurants Drink Recipes Bars and Pubs Recipes Restaurant Profiles Starbucks

License Database Purchase Options

PUBLICATION

Publication Rights

$40.00

Publish and build for clients

All Usage rights, plus customer-facing websites, apps, reports and client projects without bulk dataset handoff.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Publication License

Choose this package above

MASTER

Master Rights

$80.00

Client dataset handoff

All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.

Current Master update offer$5.00For an eligible earlier Master purchase. The fee is checked again when a new release is available.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Master License

Choose this package above

Table Schema Database Field Statistics

Release structure

San Francisco Restaurants Database

Review the published tables, record coverage, and field names included with release 1.0.2.

Database
#768
Version
1.0.2
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
FieldRecordsPercentTypeComment
id5,475100%int(11)Unique Identifier
e_address5,474100%varchar(100)Physical Address
e_city5,475100%varchar(50)Physical Address City
e_state5,475100%varchar(20)Physical Address State / Province
e_postal5,457100%varchar(7)Physical Address Postal Code
e_zip_full20%varchar(10)Zip +4 for US Physical Addresses
e_country5,475100%varchar(20)Physical Address Country
loc_county5,457100%varchar(40)Physical Address County
loc_area_code5,457100%varchar(3)Physical Address Area Code
loc_FIPS5,457100%varchar(5)Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html
loc_MSA00%varchar(5)Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html
loc_PMSA5,457100%varchar(5)Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm
loc_TZ5,457100%varchar(6)Location Time Zone
loc_DST5,475100%enum('Y','N','U')Daylight Savings Time (Yes, No, Unknown)
loc_LAT_centroid5,457100%varchar(15)Latitude (Centroid Based)
loc_LAT_poly5,39899%varchar(15)Latitude (Precision Polygon Based)
loc_LONG_centroid5,457100%varchar(15)Longitude (Centroid Based)
loc_LONG_poly5,39899%varchar(15)Longitude (Precision Polygon Based)
biz_name5,475100%varchar(150)Business Name
biz_info4,07774%textBusiness Information and Description
cat_primary5,475100%varchar(75)Business Primary Category
cat_sub5,475100%varchar(100)Business Secondary/Sub Category
biz_excellence5,475100%varchar(20)Symbol of Excellence Awarded
cencus_index5,44799%varchar(50)Census Index Identifier
SF Restaurants Records Information
Alameda County 6 SF Restaurants
Contra Costa County 3 SF Restaurants
Los Angeles County 1 SF Restaurants
Marin County 1 SF Restaurants
San Francisco County 5,426 SF Restaurants
San Mateo County 20 SF Restaurants
Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.
Discuss your data needs Explore the catalog

A clear path from download to project

Get more from your data

Understand the files, check the sample coverage, and choose the license that fits your use.

Database guides and examples Working with file formats Samples and record counts Licenses and permitted use Ask about this database

Oddity Support

How can we help?

Browse all Help topics

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details