trees

274 rows where Supervisor Districts = 9 and qLegalStatus_id = 2 sorted by PermitNotes

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
642 260182 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 66x McCoppin St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 3x3   6006141 2109130 37.7716162396968 -122.422139269172 (37.7716162396968, -122.422139269172) 8 2 9 28853 19
1080 169338 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1029 Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2019 12:00:00 AM 3 Width 4ft   6006781.41851 2114264.09095 37.7857493130165 -122.420288474132 (37.7857493130165, -122.420288474132) 13 9 9 28858 36
3797 260871 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
5118 169123 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 210 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2019 12:00:00 AM 3 Width 4ft   6009469.52117 2113800.26568 37.7846268637924 -122.410955591431 (37.7846268637924, -122.410955591431) 14 10 9 28852 36
5835 118375 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 4x6   6014712.48727 2114662.02755 37.7872856671566 -122.392876855803 (37.7872856671566, -122.392876855803) 6 2 9 28855 6
6762 260431 Planning Code 138.1 required 2 Tree(s) :: 17 181 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/2019 12:00:00 AM 3 3x3   6013986 2115554 37.7896944377585 -122.395452879395 (37.7896944377585, -122.395452879395) 12 2 9 28855 6
8102 260181 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 66x McCoppin St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 3x3   6006141 2109130 37.7716162396968 -122.422139269172 (37.7716162396968, -122.422139269172) 8 2 9 28853 19
8436 260432 Planning Code 138.1 required 2 Tree(s) :: 17 181 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/27/2019 12:00:00 AM 3 3x3   6013986 2115554 37.7896944377585 -122.395452879395 (37.7896944377585, -122.395452879395) 12 2 9 28855 6
9750 169122 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 210 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2019 12:00:00 AM 3 Width 4ft   6009478.56357 2113738.5186 37.7844578281201 -122.410919945006 (37.7844578281201, -122.410919945006) 14 10 9 28852 36
11471 260869 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
11745 260192 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1699 Market St 5 Sidewalk: Property side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 4X4   6006124.91889 2109483.72494 37.7725865765291 -122.422220029928 (37.7725865765291, -122.422220029928) 8 2 9 28853 19
13730 260870 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
14403 260183 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 66x McCoppin St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 3x3   6006141 2109130 37.7716162396968 -122.422139269172 (37.7716162396968, -122.422139269172) 8 2 9 28853 19
15918 255699 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 9 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
16066 260290 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1029 Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2019 12:00:00 AM 3 Width 4ft   6006781.41851 2114264.09095 37.7857493130165 -122.420288474132 (37.7857493130165, -122.420288474132) 13 9 9 28858 36
17700 260555 Planning Code 138.1 required 2 Tree(s) :: 17 502 07th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/23/2019 12:00:00 AM 3 3x3   6011196 2109910 37.7740417608934 -122.404708555539 (37.7740417608934, -122.404708555539) 14 2 9 28853 34
18138 260191 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1699 Market St 4 Sidewalk: Property side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 4X4   6006124.91889 2109483.72494 37.7725865765291 -122.422220029928 (37.7725865765291, -122.422220029928) 8 2 9 28853 19
18437 260868 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
20157 121528 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 4 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
21732 121544 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 5 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
25972 121523 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 280 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
30239 121540 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 1 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
32270 118379 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
34491 187942 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 3 Sidewalk: Curb side : Yard Tree Private 2     3     6015080.74918 2115307.92538 37.7890796023783 -122.391647913344 (37.7890796023783, -122.391647913344) 6 2 9 28855 6
34716 255695 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 5 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
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
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
40138 121526 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 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
42633 118377 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 4 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
43149 121513 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
46657 121543 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 4 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
47024 120519 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 520 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010156 2108818 37.7709851997146 -122.408229076629 (37.7709851997146, -122.408229076629) 8 2 9 28853 34
47139 257910 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 3 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
48226 121547 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 8 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
52894 121531 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 7 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
55960 121539 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 6 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
62167 121518 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 13 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
63982 121515 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
64723 118378 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
64870 255402 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 150 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
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
71462 187943 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 4 Sidewalk: Curb side : Yard Tree Private 2     3     6015093.73077 2115293.30797 37.7890401869059 -122.391601975949 (37.7890401869059, -122.391601975949) 6 2 9 28855 6
72419 255414 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 10 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
73578 187945 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 6 Sidewalk: Curb side : Yard Tree Private 2     3     6015129.76051 2115255.3706 37.7889380194338 -122.391474663423 (37.7889380194338, -122.391474663423) 6 2 9 28855 6
73712 121545 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 6 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
75283 118380 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
78499 255416 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 99x Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6007395 2111066 37.7770026839515 -122.417938862064 (37.7770026839515, -122.417938862064) 7 9 9 28852 36
80342 121514 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 9 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
80358 121522 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 280 Beale St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
81393 121521 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 16 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
87472 255403 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 150 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
90566 120518 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 520 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010156 2108818 37.7709851997146 -122.408229076629 (37.7709851997146, -122.408229076629) 8 2 9 28853 34
94254 121506 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 300 Folsom St 1 Sidewalk: Property side : Cutout Tree Private 2     11 3x3   6012227.3168 2112699.1751 37.7817577819585 -122.401337080379 (37.7817577819585, -122.401337080379) 6 2 9 28856 34
98874 255694 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 4 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
100470 121527 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
101009 121510 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
102091 121512 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 7 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
103030 121533 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 9 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 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
105773 255696 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 6 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
106371 121516 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 11 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
107276 121511 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
108346 255693 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 3 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
108535 255409 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
109022 255406 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
109444 255700 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 510 Townsend St 10 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
110801 187940 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 1 Sidewalk: Curb side : Yard Tree Private 2     3     6015048.62855 2115342.19505 37.7891719160015 -122.391761444649 (37.7891719160015, -122.391761444649) 6 2 9 28855 6
117838 121542 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 3 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 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
121157 257909 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 2 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
122606 187947 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 8 Sidewalk: Curb side : Yard Tree Private 2     3     6015161.72984 2115222.99296 37.7888508922136 -122.391361788631 (37.7888508922136, -122.391361788631) 6 2 9 28855 6
124352 255410 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 6 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
126056 255417 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 99x Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6007395 2111066 37.7770026839515 -122.417938862064 (37.7770026839515, -122.417938862064) 7 9 9 28852 36
129348 251179 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 1043 Minna St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6007668 2109797 37.7735336727503 -122.41690453761 (37.7735336727503, -122.41690453761) 8 2 9 28853 19
130074 255415 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 11 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
132870 118376 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
133882 187944 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 5 Sidewalk: Curb side : Yard Tree Private 2     3     6015109.7038 2115276.55289 37.7889950679055 -122.391545539018 (37.7889950679055, -122.391545539018) 6 2 9 28855 6
134827 255697 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 7 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
138609 251178 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 1043 Minna St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6007668 2109797 37.7735336727503 -122.41690453761 (37.7735336727503, -122.41690453761) 8 2 9 28853 19
139116 255407 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
139844 121546 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 7 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
149074 255412 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 8 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
149325 187946 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 7 Sidewalk: Curb side : Yard Tree Private 2     3     6015145.56326 2115239.56325 37.7888954931699 -122.391418882079 (37.7888954931699, -122.391418882079) 6 2 9 28855 6
149769 121517 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
152599 121532 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 8 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
160771 187941 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 2 Sidewalk: Curb side : Yard Tree Private 2     3     6015065.49236 2115322.58848 37.7891190169896 -122.391701726057 (37.7891190169896, -122.391701726057) 6 2 9 28855 6
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
161626 255692 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 2 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
164769 255405 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
165740 255404 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 150 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
167550 255408 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
168121 121519 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
170258 121530 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 6 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
171370 121537 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
177060 116640 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 270 Brannan St 2 Sidewalk: Property side : Cutout Tree Private 2     1 4x4   6015158 2112983 37.7827001752808 -122.391218053322 (37.7827001752808, -122.391218053322) 6 2 9 28856 6
178102 255413 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
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
179705 255411 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 7 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);