San Diego County Business Sites

Point locations of businesses and tract aggregations of counts of businesses by type.

sangis.org-business_sites-2

Resources | Packages | Documentation| Contacts| References| Data Dictionary

Resources

Documentation

This dataset is based on the SANGIS BUSINESS_SITES data file, which is compiled from the Assessors Business Property Account Master file. This file is different from the City of San Diego’s business list, in that it includes records for the whole county, it categorizes businesses differently ( not using NAICS codes ) and for some categories, it does not appear to be very accurate.

This package includes two additional files, which link counts of businesses by categories to tracts.

  • tract_counts_rows presents the counts of businesses as rows. There is one row for each combination of type of business and census tract.
  • tract_counts_columns presents the counts of businesses as columns. There is one row per tract, and one column for each type of business.

The row oriented file is easier to use in tools that have good support for filtering, such as Pandas and Tableau. The column oriented form is easier to use in tools where selecting a column is easier than filtering, such as QGIS.

Caveats

The upstream documentation warns:

Data should be used with caution as not all addresses and/or APN numbers are correct, and certain business sites do not have precise addresses so that locations are approximate. Certain business sites could not be located but remain in the dataset.

Contacts

Packages

Accessing Packages in Metapack

import metapack as mp
# ZIP Package
pkg = mp.open_package('http://library.metatab.org/sangis.org-business_sites-2.zip')
# CSV Package
pkg = mp.open_package('http://library.metatab.org/sangis.org-business_sites-2.csv') 

resource = pkg.resource('resource_name') # Get a resource
df = resource.dataframe() # Create a pandas Dataframe
gdf = resource.geoframe() # Create a GeoPandas GeoDataFrame

Data Dictionary

business_sites | tract_counts_rows | tract_counts_columns

business_sites

Column NameData TypeDescription
idinteger
apninteger
bcccodeinteger
ownnam1string
ownnam2string
ownnam3string
careofstring
strnumnumber
strfrastring
strdirstring
strnamstring
strtypstring
strsrmstring
citystring
statestring
contrystring
zipcd1integer
zipcd2integer
loccodstring
locnuminteger
locfrastring
locdirstring
locnamstring
loctypstring
locsrmstring
loccitstring
bustypestring
point_xnumber
point_ynumber
geometrystring

tract_counts_rows

Column NameData TypeDescription
geoidstring
bcccodeinteger
bustypestring
countinteger

tract_counts_columns

Column NameData TypeDescription
geoidstring
geometrystring
totalinteger
1_hour_film_processiinteger
1_way_paging_equipinteger
accountantinteger
advertisinginteger
aerospace_airframeinteger
airlines_non_fleetinteger
airport_xinteger
airport_operatorinteger
ambulanceinteger
amusement_centerinteger
antiqueinteger
apartmentsinteger
appliance_furnitureinteger
appliance_repair_serinteger
appliances_retailinteger
appliances_wholesaleinteger
architect_engineerinteger
art_dealersinteger
attorneyinteger
auctioneerinteger
auto_agencyinteger
auto_body_fenderinteger
auto_parkinginteger
auto_parts_retailinteger
auto_parts_wholesaleinteger
auto_rentalinteger
auto_repair_shopinteger
auto_tiresinteger
auto_wash_self_servinteger
auto_washerinteger
bail_bondsinteger
bakeryinteger
bakery_bakerinteger
bakery_confectionersinteger
ballroominteger
banksinteger
barinteger
barber_beauty_shop_sinteger
barber_shopinteger
beauty_barber_supplyinteger
beauty_shopinteger
beverage_beer_wineinteger
beverage_soft_drinkinteger
bicycle_storesinteger
billboardsinteger
billiard_bowl_cardinteger
bio_med_r_dinteger
bio_tech_industryinteger
blueprints_mapsinteger
boat_mfginteger
boat_repairinteger
boat_suppliersinteger
body_culture_massageinteger
book_storeinteger
bottled_water_companinteger
brake_alignmentinteger
brick_cementinteger
brick_products_retlinteger
brick_tile_mfginteger
building_supplies_geinteger
business_miscellaneointeger
business_schoolinteger
cafeinteger
cafe_fast_foodinteger
candy_storesinteger
canneriesinteger
cargo_containerinteger
carpet_draperiesinteger
carpet_rug_movableinteger
cars_usedinteger
catererinteger
cell_towerinteger
cement_manufacturerinteger
check_cashing_moneyinteger
chemicalsinteger
chemicals_fertilizerinteger
circuit_board_manufainteger
clothinginteger
clothing_mfginteger
clubs_social_serviinteger
cold_storageinteger
collectioninteger
comm_laund_dry_clninteger
commercialinteger
commercial_airlineinteger
commercial_storageinteger
computer_centerinteger
contrctr_rntal_constinteger
copy_shop_printerinteger
costume_jewelry_storinteger
credit_union_exemptinteger
credit_union_non_exinteger
dairy_product_storesinteger
dairy_wholesale_onlyinteger
danceinteger
data_centerinteger
delicatesseninteger
dental_laboratoryinteger
dentistinteger
department_storeinteger
dirt_sand_gravelinteger
doctor_osteopa_chirointeger
drug_storesinteger
drugs_wholesaleinteger
electricalinteger
electrical_supp_retinteger
electricity_generatiinteger
electronic_assemblyinteger
electronic_manufactuinteger
electronic_recordinginteger
electronicsinteger
employmentinteger
escrow_companyinteger
exempt_lessorinteger
exterminatorinteger
farm_equip_farminginteger
farm_heavy_equip_retinteger
farming_nurseriesinteger
feed_storeinteger
fish_poultry_marketinteger
fitness_centerinteger
floors_blinds_bldginteger
florist_shopinteger
florist_wholesaleinteger
food_brokersinteger
food_drink_cartinteger
foodsinteger
fractional_aircraftinteger
frosty_standinteger
frozen_food_lockerinteger
fuel_tank_farminteger
furnitureinteger
furniture_outdoorinteger
furniture_usedinteger
furniture_unfinishedinteger
gas_oil_plantsinteger
gas_recoveryinteger
general_buildinginteger
glass_paints_retailinteger
golf_cartsinteger
golf_courseinteger
grading_earth_movinginteger
grocery_storesinteger
hangars_portableinteger
hardware_retailinteger
hardware_electricalinteger
heating_air_conditiointeger
heavy_constructioninteger
heavy_farm_equipmentinteger
horse_571kinteger
horse_stablesinteger
hospitalinteger
hotel_furnishingsinteger
ice_vending_boxesinteger
illuminated_signsinteger
institutional_exemptinteger
insurance_brokerinteger
interior_decoratinginteger
janitorialinteger
jewelersinteger
jewelry_mfginteger
jewelry_storeinteger
kennelsinteger
laundryinteger
laundry_handinteger
leased_equip_true_leinteger
linen_sup_pick_up_stinteger
liquor_storeinteger
liquor_wholesale_disinteger
lithographerinteger
loan_mortgageinteger
locksmithinteger
lodgesinteger
low_income_housinginteger
lumber_building_suppinteger
lumber_retailinteger
machine_shopinteger
mailbox_centerinteger
mailing_shipping_serinteger
meat_departmentinteger
meat_wholesale_distinteger
medical_hospitalinteger
medical_laboratoryinteger
metal_gas_cylinderinteger
metal_heavy_mfginteger
metal_light_mfginteger
mfg_heavyinteger
mfg_lightinteger
milling_companiesinteger
misc_technical_labinteger
misc_amusementinteger
misc_brokerinteger
misc_contractorinteger
misc_food_storeinteger
misc_professionalinteger
misc_schoolinteger
miscellaneous_agencyinteger
miscellaneous_associnteger
mobile_home_parkinteger
mobile_home_salesinteger
mobile_homesinteger
model_homesinteger
mortuaryinteger
motel_furnishingsinteger
motorcycleinteger
mower_welding_sml_reinteger
musicinteger
music_recordingsinteger
nail_shopinteger
new_furnitureinteger
news_stand_cigar_stainteger
non_race_horsesinteger
nurseries_retailinteger
office_equipmentinteger
offsetinteger
optometristinteger
packing_housesinteger
paper_productsinteger
pawn_brokerinteger
pay_phone_privateinteger
pet_food_storesinteger
pet_storeinteger
pharmacyinteger
photo_finishinginteger
photo_wholesale_distinteger
plasteringinteger
plastics_mfginteger
plumbinginteger
plumbing_retailinteger
plumbing_wholesale_dinteger
pool_suppliesinteger
portable_toiletsinteger
pre_school_childcareinteger
printers_graphicsinteger
printshopsinteger
private_storage_retainteger
propane_tnks_hq_suppinteger
public_agencyinteger
public_storageinteger
publisher_news_magazinteger
publisher_officesinteger
radio_stationinteger
radio_tv_computersinteger
radio_tv_repairinteger
radiology_laboratoryinteger
real_estate_developeinteger
recycler_collectioninteger
religious_organizatiinteger
rental_linensinteger
rest_homeinteger
restaurantinteger
retail_warehouseinteger
roofinginteger
rug_cleanersinteger
scaffoldinginteger
see_312integer
see_501integer
see_528integer
self_serv_compositeinteger
serviceinteger
service_station_mktsinteger
shoe_repairinteger
signsinteger
silk_screeninginteger
smog_stationinteger
softwareinteger
special_eq_platesinteger
specialty_hard_goodsinteger
specialty_store_softinteger
stationeryinteger
stock_bond_brokerinteger
supermarketinteger
supplies_stationeryinteger
tailorinteger
television_rentalinteger
television_stationsinteger
theatreinteger
theme_parksinteger
ticket_travelinteger
tire_recappinginteger
tires_general_merchinteger
title_insurance_cointeger
trailer_camperinteger
trash_companyinteger
truck_terminalsinteger
tv_cable_companyinteger
tv_radio_wholesale_dinteger
tv_station_digitalinteger
typesettinginteger
unioninteger
upholsteryinteger
vendinginteger
vet_animal_hospinteger
veterinarianinteger
video_rentalsinteger
watch_repairinteger
water_co_wellsinteger
water_softener_cointeger
water_softener_servinteger
wineryinteger
wood_products_mfginteger
woodwork_repair_shopinteger
wreckersinteger

References

Urls used in the creation of this data package.

  • business_sites_source. Source URL for BUSINESS_SITES file. You must be logged into Sangis to download it.
  • metapack+http://library.metatab.org/sandiegodata.org-geography-2018-1.csv#tract_communities. San Diego tracts
  • metapack+http://library.metatab.org/sandiegodata.org-geography-2018-1.csv#tract_boundaries. Tracts linked to community names

Last Modified 2019-06-13T04:38:22