Kern County, California

From OpenStreetMap Wiki
Jump to: navigation, search
Kern County, Central Valley, California
latitude: 35.345, longitude: -119.1045
Browse map of Kern County 35°20′42″ N, 119°06′16″ W
Edit map
External links:
Use this template for your city

Kern County is a County in Central Valley, California at latitude 35°20′42″ North, longitude 119°06′16″ West.

The county contains a diverse set of land features. A majority of the county is used for farming or petroleum drilling. There are also major military bases in the county. Kern County contains parts of the Los Padres and Sequoia National Forests. The wide variety of features in the county provide a challenge for adding proper land use tags. A majority of features in the county were added through imports from both city and county data sets in 2010. Permission was obtained to use the data from both city and county GIS departments. The county is an example of what can be done through imports but it is also an example of some of the challenges we face when importing massive data sets. The county is one of the densest places in the world. This can be both a good thing and a bad thing. It is good because of the completeness that no amount of hand editing can accomplish. But a large amount of data also limits what can be downloaded at one time to edit at least with the current tools.

Imports

Here is a list of data that was imported in Kern County.

Buildings

The City of Bakersfield released a complete set of all the building footprints within the city. There are currently some newer residential areas that still need to be added.

Trees

The City of Bakersfield released a dataset of all the public trees within the city.

Parks

Parks and park features were added from the City of Bakersfield.

Landuse zones

Landuses were added both from the city and county zoning data. The city data is generally accurate. But the county landuse files tend to be more general. Often residential or farm were used for entire square areas rather than defining the actual area. Sometimes especially in rural areas, it appears that the projection used in the original creation of the data was off, causing it to not completely align with imagery. Sometimes the datasets tended to overlap around the exterior edges of Bakersfield and should be removed or combined if there are still any areas that exist.

Cleanup checklist

  • Check and remove duplicate buildings
  • Add religion type tag to churches
  • Remove or combine duplicate areas from city and county data
  • Reduce nodes in individual areas
  • Simplify features that expand over multiple areas
  • Align landuse areas based on imagery
  • Lowercase names of park features
  • Check NHD data doesn't overlap
  • Check NHD canals and ditches are tagged correctly
  • Fix TIGER data
  • Remove extra tags not needed like kern:Comb_Zn, kern:Zn_Cd1, acres, etc.
  • Remove tags that contain null values

Things to add

  • Add parking lots manually
  • Add new buildings not originally included in dataset both manually and through updated city data
  • Add names of oil feeds.
  • Add farmyard areas manually

Rules used

- Data were imported using the Java Shp-to-osm.jar script.Here is a list of the rules that were used in the imports

'''Kern County zones'''
outer,ID,,ID,-
outer,Name,,name,-
outer,Zn_Cd1,,kern:Zn_Cd1,-
outer,Comb_Zn,,kern:Comb_Zn,-
outer,Notes,,notes,-
outer,Dscrptn,,description,-
outer,Zn_Cd1,,source,http://www.co.kern.ca.us/gis/Files/CountyZoning.zip
outer,Zn_Cd1,,attribution,Kern_County_GIS
outer,Zn_Cd1,R-1,landuse,residential
outer,Zn_Cd1,R-2,landuse,residential
outer,Zn_Cd1,R-3,landuse,residential
outer,Zn_Cd1,E(1/2),landuse,residential
outer,Zn_Cd1,E(1/4),landuse,residential
outer,Zn_Cd1,E(1),landuse,residential
outer,Zn_Cd1,E(21/2),landuse,residential
outer,Zn_Cd1,E(2 1/2),landuse,residential
outer,Zn_Cd1,E(5),landuse,residential
outer,Zn_Cd1,E(10),landuse,residential
outer,Zn_Cd1,E(20),landuse,residential
outer,Zn_Cd1,MP,landuse,residential
outer,Zn_Cd1,MS,landuse,residential
outer,Zn_Cd1,MS(1/2),landuse,residential
outer,Zn_Cd1,MS(1/4),landuse,residential
outer,Zn_Cd1,MS(21/2),landuse,residential
outer,Zn_Cd1,MS(2 1/2),landuse,residential
outer,Zn_Cd1,PL,landuse,residential
outer,Zn_Cd1,M-1,landuse,industrial
outer,Zn_Cd1,M-2,landuse,industrial
outer,Zn_Cd1,M-3,landuse,industrial
outer,Zn_Cd1,GI,landuse,industrial
outer,Zn_Cd1,DI,landuse,industrial
outer,Zn_Cd1,CH,landuse,commercial
outer,Zn_Cd1,CO,landuse,commercial
outer,Zn_Cd1,C-1,landuse,commercial
outer,Zn_Cd1,C-2,landuse,commercial
outer,Zn_Cd1,C-3,landuse,commercial
outer,Zn_Cd1,A,landuse,farm
outer,Zn_Cd1,A-1,landuse,farm
outer,Zn_Cd1,A-2,landuse,farm
outer,Zn_Cd1,FPP,landuse,farm

'''park facilities'''
outer,STREET,,source,http://www.bakersfieldcity.us/gis/downloads/gis_spatial_data.htm
outer,STREET,,attribution,Bakersfield_GIS
outer,STREET,,addr:street,-
outer,FAC_TYPE,,facility_type,-
outer,FAC_TYPE,PARKING LOT,amenity,parking
outer,SURFACE,ASPHALT,surface,asphalt
outer,SURFACE,CEMENT,surface,cement
outer,SURFACE,DIRT,surface,dirt
outer,SURFACE,GRASS/TREES,landuse,grass
outer,SURFACE,GRASS/TREES,surface,grass/trees
outer,SURFACE,GRASS/PALMS,landuse,grass
outer,SURFACE,GRASS/PALMS,surface,grass/palms
outer,SURFACE,GRASS/BRUSHES,landuse,grass
outer,SURFACE,GRASS/BRUSHES,surface,grass/brushes
outer,SURFACE,BUSHES,surface,bushes
outer,SURFACE,BUSHES,landuse,scrub
outer,SURFACE,BUSHES,surface,bushes
outer,SURFACE,BUSHES/TREES,natural,scrub
outer,SURFACE,BUSHES/TREES,surface,bushes/trees
outer,SURFACE,ICEPLANT/TREES,natural,scrub
outer,SURFACE,ICEPLANT/TREES,surface,iceplant/trees
outer,SURFACE,TREES,natural,wood
outer,SURFACE,TREES,surface,trees
outer,SURFACE,RAISED PLANTER,leisure,garden
outer,SURFACE,RAISED PLANTER,surface,raised planter
outer,SURFACE,SAND,natural,sand
outer,SURFACE,SAND,surface,sand
outer,SURFACE,BUILDING,building,yes
outer,JURISDICTI,,owner,-
outer,COMMENT,,note,-
outer,FACILTY_N,,facility_name,-
outer,ACRES,,acres,-
outer,CATEGORY,,category,-
outer,TYPE,,park_type,-
outer,NAME,,facility_name,-
outer,TYPE,PATH,highway,path
outer,TYPE,SIDEWALK,highway,footway
outer,TYPE,BIKE TRAIL,highway,cycleway
outer,TYPE,GOLF WALKWAY,highway,footway
outer,TYPE,COVERED PICNIC AREA,tourism,picnic_site
outer,TYPE,PICNIC AREA,tourism,picnic_site
outer,TYPE,GET BUS,highway,bus_stop
outer,TYPE,ROAD,highway,service
outer,TYPE,FOUNTAIN,amenity,drinking_water
outer,TYPE,TRASH CAN,amenity,waste_basket
outer,TYPE,PLAYGROUND,leisure,playground
outer,TYPE,RESTROOM,amenity,toilets
outer,TYPE,PARK GATE,barrier,gate
outer,TYPE,GRASS AREA,landuse,grass
outer,NAME,MONUMENT SIGN,amenity,sign
outer,NAME,BASKETBALL COURT,sport,basketball
outer,NAME,EXERCISE AREA,sport,exercise_area
outer,NAME,VOLLEYBALL,sport,volleyball
outer,NAME,HORSESHOES,sport,horseshoes
outer,NAME,TENNIS COURT,sport,tennis
outer,NAME,SOFTBALL,leisure,pitch
outer,NAME,WEATHER STATION,amenity,weather_station
outer,NAME,POWER POLE,power,pole
outer,NAME,BENCH,amenity,bench
outer,NAME,BAR-B-QUE PIT,amenity,bbq

'''Parks'''
outer,PARK_ID,,source,http://www.bakersfieldcity.us/gis/downloads/gis_spatial_data.htm
outer,PARK_ID,,attribution,Bakersfield_GIS
outer,NAME,,name,-
outer,ACRES,,acres,-
outer,PARK_ID,,park_ID,-
outer,USER_FLAG,,addr:street,-
outer,AGENCY_ID,,owner,-
outer,TYPE,Park,leisure,park
outer,TYPE,CITY,leisure,park
outer,TYPE,Golf,leisure,golf_course
outer,TYPE,PRIVATE,leisure,golf_course
outer,TYPE,Recreation Fac,landuse,recreation_ground
outer,TYPE,Fair Grounds,landuse,recreation_ground
outer,LINK,,URL,-

'''Trees'''
outer,BOTANICAL_,,source,http://www.bakersfieldcity.us/gis/downloads/gis_spatial_data.htm
outer,BOTANICAL_,,attribution,Bakersfield_GIS

'''Buildings'''
outer,SOURCE_ID,,source,http://www.bakersfieldcity.us/gis/downloads/gis_spatial_data.htm
outer,SOURCE_ID,,attribution,Bakersfield_GIS
outer,COMMENT,,description,-
outer,COM_NAM_1,,description2,-
outer,COM_NAM_2,,description3,-
outer,COM_NAM_3,,description4,-
outer,FAC_TYPE_1,,bak:fac_type1,-
outer,FAC_TYPE_2,,bak:fac_type2,-
outer,FAC_TYPE_3,,bak:fac_type3,-
outer,OWNER_1,,owner,-
outer,COMMENT,,notes,-
outer,USER_FLAG,BUILDING,building,yes
outer,USER_FLAG,NULL,building,yes
outer,USER_FLAG,STRUCTURE,building,yes
outer,FAC_TYPE_2,PARKING STRUCTURE,building,yes
outer,FAC_TYPE_2,RACE TRACK CARS,building,yes
outer,FAC_TYPE_2,CEMETERY,amenity,cemetery
outer,FAC_TYPE_2,HOTEL,tourism,hotel
outer,FAC_TYPE_2,HOSPITAL,amenity,hospital
outer,COM_NAME_2,TRACK,leisure,track
outer,COM_NAME_2,FIELD,leisure,pitch
outer,COM_NAME_2,BANK,amenity,bank
outer,COM_NAME_2,POOL,sport,swimming
outer,FAC_TYPE_2,CHURCH,amenity,place_of_worship
outer,FAC_TYPE_2,GAS STATION,amenity,fuel
outer,FAC_TYPE_2,GROCERY STORE,shop,supermarket
outer,FAC_TYPE_2,RESTAURANT,amenity,restaurant
outer,FAC_TYPE_2,DEALERSHIP,shop,car
outer,FAC_TYPE_2,FIRE STATION,amenity,fire_station
outer,FAC_TYPE_2,PARKING STRUCTURE,amenity,parking
outer,FAC_TYPE_3,TANK,name,tank
outer,FAC_TYPE_3,PONDS,natural,water
outer,FAC_TYPE_3,BASEBALL FIELD,leisure,pitch
outer,FAC_TYPE_3,BASEBALL FIELD,sport,baseball
outer,FAC_TYPE_3,BICYCLE RACING,landuse,recreation_ground
outer,FAC_TYPE_3,PUBLIC PARKING,amenity,parking
outer,FAC_TYPE_3,PHARMACY,amenity,pharmacy
outer,FAC_TYPE_3,TENNIS COURT,sport,tennis
outer,USER_FLAG,STRUCTURE,FIXME,Is this a building?
outer,USER_FLAG,NON-BUILDING,FIXME,Is this marked correctly?
outer,COMMENT,REMOVED IN ?,building,
outer,COMMENT,TENNIS COURT,sport,tennis
outer,COM_NAM_1,KERN COUNTY COURTS BLDG,name,Kern County Court
outer,COM_NAM_1,HOME DEPOT,name,Home Depot
outer,COM_NAM_1,HOME DEPOT,shop,hardware
outer,COM_NAM_1,LOWES,shop,hardware
outer,COM_NAM_1,COUNTY ANIMAL CONTROL,name,County Animal Control
outer,COM_NAM_1,JOHN DEERE EQUIPMENT,name,John Deere Equipment
outer,COM_NAM_1,JOHN DEERE EQUIPMENT,shop,farm
outer,COM_NAM_1,RAINBOW CARWASH,amenity,car_wash
outer,COM_NAM_1,RAINBOW CARWASH,name,Rainbow Carwash
outer,COM_NAM_1,THE PIZZA MARKET,name,The Pizza Market
outer,COM_NAM_1,FOOD-4-LESS,name,Food-4-Less
outer,COM_NAM_1,HOME TOWN BUFFET,name,Home Town Buffet
outer,COM_NAM_1,CHEIF AUTO PARTS STORE,name,Chief Auto Parts
outer,COM_NAM_1,TACO BELL,name,Taco Bell
outer,COM_NAM_1,FAMILY FITNESS CENTER,name,Family Fitness Center
outer,COM_NAM_1,YOUNGS SUPERMARKET,name,Youngs Supermarket
outer,COM_NAM_1,AMPM,name,AMPM
outer,COM_NAM_1,WHITEWATER CARWASH AND LUBE SHOP,name,Whitewater Carwash and Lube
outer,COM_NAM_1,SHELL,name,Shell
outer,COM_NAM_1,LOWES,name,Lowes
outer,COM_NAM_1,BLACK ANGUS,name,Black Angus
outer,COM_NAM_1,24 HOUR FITNESS,name,24 Hour Fitness
outer,COM_NAM_1,JOHNS INCREDIBLE PIZZA,name,John's Incredible Pizza
outer,COM_NAM_1,WINSTON RACING,name,Winston Racing
outer,COM_NAM_1,ROCKIN RODEO,name,Rockin Rodeo
outer,COM_NAM_1,CHEVRON,name,Chevron
outer,COM_NAM_1,ALBERTSONS,name,Albertsons
outer,COM_NAM_1,WAREHOUSE MUSIC,name,Warehouse Music
outer,COM_NAM_1,MCDONALDS,name,McDonalds
outer,COM_NAM_1,COPELANDS SPORTS,name,Copelands Sports
outer,COM_NAM_1,COSTCO,name,Costco
outer,COM_NAM_1,WELLS FARGO,name,Wells Fargo
outer,COM_NAM_1,SAVE MART,name,Save Mart
outer,COM_NAM_1,BODY XCHANGE,name,Body XChange
outer,COM_NAM_1,JACK IN THE BOX,name,Jack In The Box
outer,COM_NAM_1,WENDYS,name,Wendys
outer,COM_NAM_1,MEXICALI,name,Mexicali
outer,COM_NAM_1,CHIPOLTE,name,Chipolte
outer,COM_NAM_1,BORDERS,shop,books
outer,COM_NAM_1,BORDERS,name,Borders
outer,COM_NAM_1,BARNES _NOBLE,shop,books
outer,COM_NAM_1,BARNES _NOBLE,name,Barns & Noble
outer,COM_NAM_1,BED,BATH, AND BEYOND,name,Bed, Bath, and Beyond
outer,COM_NAM_1,IN-N_OUT,name,In-N-Out
outer,COM_NAM_1,RALPHS,name,Ralphs
outer,COM_NAM_1,WASHINGTON MUTUAL,name,Chase
outer,COM_NAM_1,LONG JOHN SILVER'S,name,Long John Silver's
outer,COM_NAM_1,OUTBACK STEAKHOUSE,name,Outback Steakhouse
outer,COM_NAM_1,RITE AID,name,Rite Aid
outer,COM_NAM_1,OSH,name,OSH
outer,COM_NAM_1,SIZZLER,name,Sizzler
outer,COM_NAM_1,SATURN DEALERSHIP,name,Saturn
outer,COM_NAM_1,FOSTERS FREEZE,name,Fosters Freeze
outer,COM_NAM_1,KFC,name,KFC
outer,COM_NAM_1,DINER SMORSGASBORG,name,Diner Smorsgasborg
outer,COM_NAM_1,THRIFTYS DRUG STORE,name,Thriftys Drug Store
outer,COM_NAM_1,NEWBERRYS,name,Newberrys
outer,COM_NAM_1,MIM CAFE,name,Mimis Cafe
outer,COM_NAM_1,COMP USA,name,Comp USA
outer,COM_NAM_1,NAUGLES,name,Naugles
outer,COM_NAM_1,CARLS JR,name,Carls Jr.
outer,COM_NAM_1,MUSIC WAREHOUSE,name,Music Warehouse
outer,COM_NAM_1,WAL-MART,name,Wal-Mart
outer,COM_NAM_1,PAYLESS SHOES,name,Payless Shoes
outer,COM_NAM_1,VONS,name,Vons
outer,COM_NAM_1,BURGER KING,name,Burger King
outer,COM_NAM_1,TEXACO,name,Texaco
outer,COM_NAM_1,ME N EDS,name,Me N Eds
outer,COM_NAM_1,FARMERS BOY,name,Farmers Boy
outer,COM_NAM_1,UNION BANK OF CALIFORNIA,name,Union Bank of California
outer,COM_NAM_1,DOLLAR TREE,name,Dollar Tree
outer,COM_NAM_1,LONGS DRUGS,name,Longs Drugs
outer,COM_NAM_1,OFFICE DEPOT,name,Office Depot
outer,COM_NAM_1,POPEYES,name,Popeyes
outer,COM_NAM_1,ARBYS,name,Arbys
outer,COM_NAM_1,BUILDERS EMPORIUM,name,Builders Emporium
outer,COM_NAM_1,LUCKYS,name,Luckys
outer,COM_NAM_1,TRACTOR SUPPLY,name,Tractor Supply
outer,COM_NAM_1,SAVE MART,name,Save Mart
outer,COM_NAM_1,BANK OF AMERICA,name,Bank of America
outer,COM_NAM_1,STARBUCKS,name,Starbucks
outer,COM_NAM_1,SMART _FINAL,name,Smart & Final
outer,COM_NAM_1,JOSEPHS,name,Josephs
outer,COM_NAM_1,CORNER STORE,name,Corner Store
outer,COM_NAM_1,MONTGOMERY WORLD PLAZA,name,Montgomery World Plaza
outer,COM_NAM_1,WESTAMERICA BANK,name,West America Bank
outer,COM_NAM_1,BAKERSFIELD PUBLIC WORKS,name,Bakersfield Public Works
outer,COM_NAM_1,PADRE HOTEL,name,Padre Hotel
outer,COM_NAM_1,KRESS BUILDING,name,Kress Building
outer,COM_NAM_1,WINSTON TIRES,name,Winston Tires
outer,COM_NAM_1,CHILIS,name,Chilis
outer,COM_NAM_1,ABLE CENTER,name,Able Center

'''City zones'''
outer,ZONE,,bakersfield:zone,-
outer,ZONE,,reviewed,no
outer,DESCRIPTIO,,description,-
outer,MUNICIP_ID,,bakersfield:municipal_type,-
outer,ACRES,,acres,-
outer,Shape Id,,bakersfield:ID,-
outer,ZONE,R-1,landuse,residential
outer,ZONE,R-1-P,landuse,residential
outer,ZONE,R-1-SC,landuse,residential
outer,ZONE,R-1-CH,landuse,residential
outer,ZONE,R-1 10K,landuse,residential
outer,ZONE,R-1 8.5K,landuse,residential
outer,ZONE,R-1-FP-S,landuse,residential
outer,ZONE,R-1/P.U.D.,landuse,residential
outer,ZONE,R-1-FP-S-HD,landuse,residential
outer,ZONE,R-1-CH,landuse,residential
outer,ZONE,R-1-SC,landuse,residential
outer,ZONE,R-2,landuse,residential
outer,ZONE,R-2-MH,landuse,residential
outer,ZONE,R-2-P,landuse,residential
outer,ZONE,R-2-SC,landuse,residential
outer,ZONE,R-3,landuse,residential
outer,ZONE,R-3-CH,landuse,residential
outer,ZONE,R-3-P,landuse,residential
outer,ZONE,R-4,landuse,residential
outer,ZONE,E,landuse,residential
outer,ZONE,E(1/2),landuse,residential
outer,ZONE,E(1/4),landuse,residential
outer,ZONE,E(1),landuse,residential
outer,ZONE,E(21/2),landuse,residential
outer,ZONE,E(2 1/2),landuse,residential
outer,ZONE,E(5),landuse,residential
outer,ZONE,E(10),landuse,residential
outer,ZONE,E(20),landuse,residential
outer,ZONE,E-.5A,landuse,residential
outer,ZONE,E 10K,landuse,residential
outer,ZONE,MH,landuse,residential
outer,ZONE,MP,landuse,residential
outer,ZONE,MS,landuse,residential
outer,ZONE,MS(1/2),landuse,residential
outer,ZONE,MS(1/4),landuse,residential
outer,ZONE,MS(21/2),landuse,residential
outer,ZONE,MS(2 1/2),landuse,residential
outer,ZONE,PL,landuse,residential
outer,ZONE,R-H,landuse,residential
outer,ZONE,P.U.D,landuse,residential
outer,ZONE,R-S1A,landuse,residential
outer,ZONE,R-S-2.5A,landuse,residential
outer,ZONE,R-S-1A-CH,landuse,residential
outer,ZONE,R-S-5A,landuse,residential
outer,ZONE,R-S,landuse,residential
outer,ZONE,R-S-10A,landuse,residential
outer,ZONE,TT,landuse,residential
outer,ZONE,WM-R3,landuse,residential
outer,ZONE,WM-R1,landuse,residential
outer,ZONE,WM-R2,landuse,residential

outer,ZONE,M-1,landuse,industrial
outer,ZONE,M-2,landuse,industrial
outer,ZONE,M-3,landuse,industrial
outer,ZONE,GI,landuse,industrial
outer,ZONE,DI,landuse,industrial
outer,ZONE,M-1-FP-S,landuse,industrial
outer,ZONE,M-1-MH,landuse,industrial
outer,ZONE,C-B,landuse,commercial
outer,ZONE,CH,landuse,commercial
outer,ZONE,CO,landuse,commercial
outer,ZONE,C-1,landuse,commercial
outer,ZONE,C-1-P,landuse,commercial
outer,ZONE,C-2,landuse,commercial
outer,ZONE,C-2/P.C.D.,landuse,commercial
outer,ZONE,C-3,landuse,commercial
outer,ZONE,P.C.D.,landuse,commercial
outer,ZONE,C-C,landuse,commercial
outer,ZONE,C-O,landuse,commercial
outer,ZONE,CO,landuse,commercial
outer,ZONE,C-O/P.C.D.,landuse,commercial
outer,ZONE,C-C/P.C.D.-PE,landuse,commercial
outer,ZONE,WM-TC,landuse,commercial
outer,ZONE,A,landuse,farm
outer,ZONE,A-1,landuse,farm
outer,ZONE,A-2,landuse,farm
outer,ZONE,A-20A,landuse,farm
outer,ZONE,FPP,landuse,farm
outer,ZONE,A-FP-S,landuse,farm
outer,ZONE,A-20A-FP-S,landuse,farm
outer,ZONE,P,amenity,parking
outer,ZONE,RE,landuse,recreation_ground

Imports@ List Discussion

http://lists.openstreetmap.org/pipermail/imports/2012-August/001491.html