trees
1,011 rows where qLegalStatus_id = 2 sorted by DBH
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
180599 | 75872 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
180989 | 255698 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
181013 | 199436 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 189 Hubbell St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013326.10031 | 2107431.53826 | 37.767355284933 | -122.397166295486 | (37.767355284933, -122.397166295486) | 14 | 3 | 8 | 28856 | 20 | |
181014 | 253484 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
182084 | 203200 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 189 Hubbell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013014.64692 | 2107133.40427 | 37.7665193318293 | -122.398222657156 | (37.7665193318293, -122.398222657156) | 14 | 3 | 8 | 28856 | 20 | |
182124 | 166234 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 2986 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781629 | 6008392.95809 | 2103319.50363 | 37.7557887182862 | -122.413938481678 | (37.7557887182862, -122.413938481678) | 2 | 4 | 7 | 28859 | 19 | |
182348 | 173697 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007975.5805432 | 2110395.7628537 | 37.775195030009 | -122.415882976003 | (37.775195030009, -122.415882976003) | 8 | 2 | 9 | 28853 | 34 | |
182774 | 255792 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2018 12:00:00 AM | 3 | 3x3 | 6007843 | 2092137 | 37.7250531301082 | -122.415048939995 | (37.7250531301082, -122.415048939995) | 9 | 3 | 7 | 309 | 28 | ||
183437 | 116849 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 83 Panorama Dr | 1 | Front Yard : Yard | Tree | Private 2 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | 1 | 5 | 4 | 59 | 38 | |||
183675 | 122698 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.99272 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | 10 | 3 | 7 | 309 | 28 | ||
183741 | 255653 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 298X Coso Ave | 1 | Side Yard : Yard | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 10x10 | Permit Number 776462 | 6007785 | 2099424 | 37.7450583812321 | -122.415765181935 | (37.7450583812321, -122.415765181935) | 2 | 7 | 7 | 28859 | 2 | |
183902 | 253394 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.16338 | 2116767.09226 | 37.7930680031541 | -122.392879995147 | (37.7930680031541, -122.392879995147) | 12 | 2 | 9 | 28855 | 6 | |
184166 | 115674 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1433 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774098 | 5981190.2 | 2105303.4 | 37.7596706142775 | -122.508159957785 | (37.7596706142775, -122.508159957785) | 1 | 8 | 3 | 56 | 35 | ||
184280 | 63407 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2125 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770314 | 6000344.0086 | 2116075.34024 | 37.7903576909945 | -122.442690122255 | (37.7903576909945, -122.442690122255) | 13 | 6 | 1 | 29490 | 27 | |
184398 | 115346 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 398X HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 773314 | 6014854 | 2114630 | 37.7872055860551 | -122.392385006805 | (37.7872055860551, -122.392385006805) | 6 | 2 | 9 | 28855 | 6 | |
184734 | 115535 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007237.56945 | 2111260.60051 | 37.7775281488378 | -122.418497266559 | (37.7775281488378, -122.418497266559) | 7 | 9 | 9 | 28852 | 36 | ||
184867 | 112863 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2451 19TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2015 12:00:00 AM | 3 | 3x3 | 5990427 | 2098705 | 37.7420931085193 | -122.475732948104 | (37.7420931085193, -122.475732948104) | 1 | 8 | 3 | 29491 | 35 | ||
185440 | 115536 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
185470 | 198582 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013779.59756 | 2107146.17602 | 37.7665969792947 | -122.395577705173 | (37.7665969792947, -122.395577705173) | 14 | 3 | 8 | 28856 | 20 | |
185964 | 256684 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 9 | Back Yard : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
186212 | 253740 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
186409 | 115490 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 280 BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
186623 | 257921 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1490x Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779557 | 6005922 | 2118675 | 37.79781210117 | -122.423575535726 | (37.79781210117, -122.423575535726) | 13 | 9 | 10 | 28858 | 32 | |
186709 | 253104 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3000x Irving St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427 | 2106455 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | 1 | 8 | 3 | 56 | 35 | |
187618 | 253249 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
189573 | 198589 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013524.37895 | 2107133.46335 | 37.76654787361 | -122.396459576758 | (37.76654787361, -122.396459576758) | 14 | 3 | 8 | 28856 | 20 | |
190069 | 15235 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008256.52807 | 2110680.03106 | 37.7759913537931 | -122.414931236282 | (37.7759913537931, -122.414931236282) | 8 | 2 | 9 | 28853 | 34 | |
190292 | 116775 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1106 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008794.04431 | 2117993.28546 | 37.7961019747828 | -122.413589186808 | (37.7961019747828, -122.413589186808) | 5 | 1 | 10 | 308 | 21 | ||
190324 | 253494 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
190939 | 13063 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 590 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2017 12:00:00 AM | 3 | 2X2 | Permit Number 780933 | 6009554.3361 | 2120533.7978 | 37.803120257284 | -122.411137959105 | (37.803120257284, -122.411137959105) | 3 | 1 | 10 | 308 | 23 | |
191014 | 122700 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 2895 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.76794 | 37.7253343641976 | -122.402569107292 | (37.7253343641976, -122.402569107292) | 10 | 3 | 7 | 309 | 28 | ||
191366 | 254701 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015970.50894 | 2106056.61706 | 37.7637269088073 | -122.387923622314 | (37.7637269088073, -122.387923622314) | 14 | 3 | 8 | 28856 | 29 | ||
191974 | 108030 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 601 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2014 12:00:00 AM | 3 | 3x3 | 6002630.6 | 2098839.9 | 37.7431634703749 | -122.43354642925 | (37.7431634703749, -122.43354642925) | 2 | 7 | 5 | 63 | 7 | ||
193393 | 257908 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 199x Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | 3x3 | 6014800 | 2111540 | 37.778718149686 | -122.392355631341 | (37.778718149686, -122.392355631341) | 6 | 2 | 9 | 28856 | 20 | ||
193569 | 253745 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
193648 | 147591 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 777516 | 5990250.17652 | 2113053.797 | 37.7814808023322 | -122.477392789959 | (37.7814808023322, -122.477392789959) | 11 | 6 | 2 | 55 | 26 | |
194194 | 255691 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
194213 | 253623 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1331 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778744 | 5983976.42262 | 2106100.27997 | 37.7620224120695 | -122.498582815109 | (37.7620224120695, -122.498582815109) | 1 | 8 | 3 | 56 | 35 | |
37189 | 121502 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | 6 | 2 | 9 | 28855 | 6 | |||
66507 | 121501 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4 | 10x4 | 6014441.60375 | 2115047.86993 | 37.7883300516388 | -122.393841081021 | (37.7883300516388, -122.393841081021) | 6 | 2 | 9 | 28855 | 6 | |||
70059 | 118374 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x6 | 6014693.17098 | 2114681.80971 | 37.787338911495 | -122.392945071183 | (37.787338911495, -122.392945071183) | 6 | 2 | 9 | 28855 | 6 | |||
127597 | 103379 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 2712 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770136 | 6000520 | 2117210 | 37.7934832007909 | -122.44216269001 | (37.7934832007909, -122.44216269001) | 13 | 9 | 1 | 57 | 27 | |
35800 | 121504 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 10x4 | 6014396.4001 | 2115093.29031 | 37.7884522533286 | -122.394000660325 | (37.7884522533286, -122.394000660325) | 6 | 2 | 9 | 28855 | 6 | |||
40751 | 121505 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 10x4 | 6014377.50413 | 2115113.61118 | 37.7885069995398 | -122.394067461056 | (37.7885069995398, -122.394067461056) | 6 | 2 | 9 | 28855 | 6 | |||
103456 | 121525 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | |||
120636 | 121503 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 10x4 | 6014412.49464 | 2115075.87435 | 37.7884053276005 | -122.393943755694 | (37.7884053276005, -122.393943755694) | 6 | 2 | 9 | 28855 | 6 | |||
126738 | 247941 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 4 | Unaccepted Street : Yard | Tree | DPW 1 | 5 | Permit Number 775404 | 6010287.82636 | 2098909.7574 | 37.743786764646 | -122.407074570729 | (37.743786764646, -122.407074570729) | 2 | 7 | 7 | 28859 | 2 | |||
128791 | 247940 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 5 | Permit Number 775404 | 6010280.31746 | 2098909.28814 | 37.7437850559498 | -122.407100501782 | (37.7437850559498, -122.407100501782) | 2 | 7 | 7 | 28859 | 2 | |||
48798 | 109467 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | Permit Number 773752 | 6013285.76594 | 2109350.55221 | 37.7726222220803 | -122.397440404346 | (37.7726222220803, -122.397440404346) | 14 | 2 | 9 | 310 | 20 | ||
106809 | 29017 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 120 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2014 12:00:00 AM | 6 | 3x3 | Permit Number 770901 | 6008044.5664857 | 2110308.5131992 | 37.7749593412658 | -122.415638158484 | (37.7749593412658, -122.415638158484) | 8 | 2 | 9 | 28853 | 34 | |
160922 | 121508 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 300 Folsom St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6 | 3x3 | 6012258.9126 | 2112729.3972 | 37.7818425275943 | -122.401229897449 | (37.7818425275943, -122.401229897449) | 6 | 2 | 9 | 28856 | 34 | |||
84511 | 109468 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 4x4 | Permit Number 773752 | 6013267.70036 | 2109332.73182 | 37.7725722854256 | -122.397501645497 | (37.7725722854256, -122.397501645497) | 14 | 2 | 9 | 310 | 20 | ||
115539 | 109460 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 4x4 | Permit Number 773752 | 6013412.32492 | 2109471.0252 | 37.7729600595772 | -122.397011068921 | (37.7729600595772, -122.397011068921) | 14 | 2 | 9 | 310 | 20 | ||
4535 | 106245 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 566 De Haro St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | Permit Number 770844 | 6012026 | 2105714 | 37.7625668468002 | -122.401542461625 | (37.7625668468002, -122.401542461625) | 8 | 3 | 8 | 28856 | 29 | |||
7744 | 225194 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778605 | 6007219.63733 | 2103836.19178 | 37.7571414587344 | -122.418032839538 | (37.7571414587344, -122.418032839538) | 2 | 4 | 7 | 28859 | 19 | ||
16206 | 109465 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | Permit Number 773752 | 6013321.87847 | 2109385.26551 | 37.7727195476045 | -122.397317921189 | (37.7727195476045, -122.397317921189) | 14 | 2 | 9 | 310 | 20 | ||
136714 | 65940 | Planning Code 138.1 required 2 | Liquidambar styraciflua :: American Sweet Gum 37 | 620 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 8 | Permit Number 28961 | 6007431.46715 | 2113367.23378 | 37.7833233693217 | -122.417975883707 | (37.7833233693217, -122.417975883707) | 7 | 9 | 9 | 28858 | 36 | |
138593 | 56707 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1688 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Permit Number 782197 | 5983170.4061 | 2103643.307 | 37.7552289545408 | -122.501188731534 | (37.7552289545408, -122.501188731534) | 1 | 8 | 3 | 56 | 35 | |||
154592 | 109464 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | Permit Number 773752 | 6013338.99753 | 2109402.36294 | 37.7727674463814 | -122.39725990323 | (37.7727674463814, -122.39725990323) | 14 | 2 | 9 | 310 | 20 | ||
168906 | 109469 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | Permit Number 773752 | 6013484.3589 | 2109540.27035 | 37.7731542007368 | -122.3967667483 | (37.7731542007368, -122.3967667483) | 14 | 2 | 9 | 310 | 20 | ||
178528 | 121507 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 300 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012241.512 | 2112714.7441 | 37.7818013227969 | -122.401289065763 | (37.7818013227969, -122.401289065763) | 6 | 2 | 9 | 28856 | 34 | |||
181676 | 196592 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 43 Lafayette St | 4 | : | Tree | Private 2 | 8 | Width 3ft | Permit Number 772992 | 6007533.59843 | 2109642.31042 | 37.7731013709756 | -122.417358489209 | (37.7731013709756, -122.417358489209) | 8 | 2 | 9 | 28853 | 19 | ||
193110 | 109470 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | Permit Number 773752 | 6013467.61268 | 2109523.16527 | 37.7731063019529 | -122.396823476633 | (37.7731063019529, -122.396823476633) | 14 | 2 | 9 | 310 | 20 | ||
1462 | 225196 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007182.851 | 2103832.80652 | 37.7571300930895 | -122.418159821127 | (37.7571300930895, -122.418159821127) | 2 | 4 | 7 | 28859 | 19 | ||
1675 | 225195 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007206.11976 | 2103835.77909 | 37.7571395647689 | -122.418079559351 | (37.7571395647689, -122.418079559351) | 2 | 4 | 7 | 28859 | 19 | ||
9271 | 225190 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
11511 | 225198 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007149.23047 | 2103831.77129 | 37.7571253581517 | -122.418276020715 | (37.7571253581517, -122.418276020715) | 2 | 4 | 7 | 28859 | 19 | ||
11548 | 225197 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007163.79352 | 2103832.50742 | 37.7571281991351 | -122.418225708166 | (37.7571281991351, -122.418225708166) | 2 | 4 | 7 | 28859 | 19 | ||
152102 | 109458 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4x4 | Permit Number 773752 | 6013450.12112 | 2109506.07563 | 37.7730584040491 | -122.396882784219 | (37.7730584040491, -122.396882784219) | 14 | 2 | 9 | 310 | 20 | ||
162044 | 247938 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 29 Joy St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | 2 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );