trees

1,732 rows where qLegalStatus_id = 6 sorted by Longitude

✎ View and edit SQL

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)
177101 96784 Significant Tree 6 Acer palmatum :: Japanese Maple 216 615 Rhode Island St   Sidewalk: Property side : Cutout Tree Private 2   07/19/2011 12:00:00 AM     Permit Number 767987 6011854.6 2105476.9 37.7619062576766 -122.402118605761 (37.7619062576766, -122.402118605761) 10 3 8 28856 29
9862 114526 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 TIOGA AVE 2 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
59395 114525 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 TIOGA AVE 1 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
67051 113134 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 50 03rd St 2 Front Yard : Yard Tree Private 2   09/09/2015 12:00:00 AM   10x10 Permit Number 775860 6011822.9 2114512.2 37.7867133521926 -122.402863731968 (37.7867133521926, -122.402863731968) 12 2 9 28853 6
184663 113133 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 50 03rd St 1 Front Yard : Yard Tree Private 2   09/09/2015 12:00:00 AM   10x10 Permit Number 775860 6011822.9 2114512.2 37.7867133521926 -122.402863731968 (37.7867133521926, -122.402863731968) 12 2 9 28853 6
39513 98455 Significant Tree 6 Washingtonia filifera :: California Fan Palm 176 2200 22nd St 1 Front Yard : Yard Tree Private 2           6011565.2 2103754.7 37.7571613219705 -122.402998394603 (37.7571613219705, -122.402998394603) 10 3 8 28856 29
22679 108026 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 862 Kansas St   Front Yard : Yard Tree Private 2         Permit Number 774734 6011570 2104296 37.7586478799274 -122.403019866682 (37.7586478799274, -122.403019866682) 10 3 8 28856 29
12165 260922 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 866 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 774734 6011543 2104306 37.7586738299336 -122.403113948893 (37.7586738299336, -122.403113948893) 10 3 8 28856 29
105286 108275 Significant Tree 6 Arecastrum romanzoffianum :: Queen Palm 135 1800x ALAMEDA ST 5 Front Yard : Cutout Tree Private 2     15     6011533 2107928 37.7686184708296 -122.403403344125 (37.7686184708296, -122.403403344125) 8 2 8 28853 20
101661 257928 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 101 Lombard St 12 Sidewalk: Property side : Yard Tree Private 2       Width 6ft   6011760.21977 2120791.0173 37.8039499778675 -122.403522505873 (37.8039499778675, -122.403522505873) 3 1 10 28860 6
104435 106173 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 267 Green St 1 Front Yard : Yard Tree Private 2         Permit Number 771881 6011670.8 2119368.7 37.8000396459541 -122.403731811098 (37.8000396459541, -122.403731811098) 3 1 10 308 23
9674 97174 Significant Tree 6 Tristaniopsis laurina :: Swamp Myrtle 1 26 Gilbert St   Sidewalk: Property side : Cutout Tree Private 2 FUF         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458) 14 2 9 28853 34
162331 97175 Significant Tree 6 Tristaniopsis laurina :: Swamp Myrtle 1 26 Gilbert St   Sidewalk: Property side : Cutout Tree Private 2 FUF         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458) 14 2 9 28853 34
18002 261423 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 2400x 23rd St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011254 2102764 37.7544236960072 -122.404004933004 (37.7544236960072, -122.404004933004) 10 4 8 28859 19
194330 265002 Significant Tree 6 :: Tree 573 1445 San Bruno Ave 1 Sidewalk: Property side : Yard Tree Private 2       5x5   6011217 2101257 37.7502837374969 -122.404026841996 (37.7502837374969, -122.404026841996) 10 4 8 28859 19
97189 114476 Significant Tree 6 Pittosporum spp :: Pittosporum spp 170 299x UNION ST 1 Sidewalk: Curb side : Yard Tree Private 2   12/29/2015 12:00:00 AM       6011527 2119680 37.8008863659875 -122.40425133897 (37.8008863659875, -122.40425133897) 3 1 10 308 23
1467 259815 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 9 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
3205 259817 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 11 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
3287 259814 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 8 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
6413 259813 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 7 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
6612 259812 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 6 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
7698 259819 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 13 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
9200 259821 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 15 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
12030 259810 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
13096 259808 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
13203 259818 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 12 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
13753 259809 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
14819 259822 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 16 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
14961 259823 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 17 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
16309 259807 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
16536 259816 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 10 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
18661 259820 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 14 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
18707 259811 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 5 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
37577 100056 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 401X Tehama St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.7809848079497 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
153818 100055 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 401X Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.7809848079497 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
188934 100054 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 401X Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.7809848079497 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
85934 88453 Significant Tree 6 Myoporum laetum :: Myoporum 62 2801 Oakdale Ave 2 Front Yard : Cutout Tree Private 2       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1
96193 88456 Significant Tree 6 Tree(s) :: 17 2801 Oakdale Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2008 12:00:00 AM     Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1
118020 88454 Significant Tree 6 Myoporum laetum :: Myoporum 62 2801 Oakdale Ave 3 Front Yard : Cutout Tree Private 2       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1
138601 88455 Significant Tree 6 Myoporum laetum :: Myoporum 62 2801 Oakdale Ave 4 Front Yard : Cutout Tree Private 2       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1
148080 88457 Significant Tree 6 Tree(s) :: 17 2801 Oakdale Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2008 12:00:00 AM     Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1
84037 107611 Significant Tree 6 Pinus radiata :: Monterey Pine 15 470x Broadway 1 Back Yard : Yard Tree Private 2         Permit Number 774041 6011286.02608 2118707.45024 37.7982025127238 -122.40501669829 (37.7982025127238, -122.40501669829) 3 1 10 308 23
111290 106058 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 301 FILBERT ST 1 Front Yard : Yard Tree Private 2     10     6011273 2120044 37.8018716248897 -122.405155936594 (37.8018716248897, -122.405155936594) 3 1 10 308 23
2008 106059 Significant Tree 6 Salix spp :: Willow 203 339 FILBERT ST 1 Front Yard : Yard Tree Private 2     6     6011263.6 2119947.8 37.801606957686 -122.405181687156 (37.801606957686, -122.405181687156) 3 1 10 308 23
191007 96222 Significant Tree 6 Tree(s) :: 17 176 Holladay Ave 1 Sidewalk: Property side : Cutout Tree Private 2   05/18/2011 12:00:00 AM 18 3x3 Permit Number 767739 6010842.9 2100101.6 37.7470903528282 -122.405239158587 (37.7470903528282, -122.405239158587) 2 7 7 28859 2
145228 173889 Significant Tree 6 Gleditsia triacanthos :: Honey Locust 182 190 Holladay Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779949 6010824 2099939 37.7466428319545 -122.405293064953 (37.7466428319545, -122.405293064953) 2 7 7 28859 2
34754 101438 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 3 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
106637 101435 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 1 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
127351 101436 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 2 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
155139 101440 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 5 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
161031 101439 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 4 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
168346 251480 Significant Tree 6 Pinus radiata :: Monterey Pine 15 51 Peralta Ave 1 Front Yard : Yard Tree Private 2       3x3   6010641 2100362 37.7477940646116 -122.405955656592 (37.7477940646116, -122.405955656592) 2 7 7 28859 2
8163 82435 Significant Tree 6 Pinus radiata :: Monterey Pine 15 51 Peralta Ave 1 Front Yard : Yard Tree Private 2   04/02/2005 12:00:00 AM 20     6010636.52703341 2100363.58782589 37.7477981742678 -122.405971235802 (37.7477981742678, -122.405971235802) 2 7 7 28859 2
9889 116075 Significant Tree 6 Tree(s) :: 17 88 MONTCALM ST 1 Front Yard : Yard Tree Private 2           6010492 2099980 37.7467368416425 -122.406443980671 (37.7467368416425, -122.406443980671) 2 7 7 28859 2
3313 262482 Significant Tree 6 Tree(s) :: 17 45 Delta St 1 Front Yard : Yard Tree Private 2       3x3   6010254 2089941 37.7191585615903 -122.406559656354 (37.7191585615903, -122.406559656354) 10 7 8 309 39
48619 253373 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 78 Peralta Ave 1 Front Yard : Yard Tree Private 2       3x3   6010457 2100357 37.7477700431666 -122.406591570174 (37.7477700431666, -122.406591570174) 2 7 7 28859 2
14736 92056 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1001 Potrero Ave   Sidewalk: Property side : Yard Tree Private 2   06/16/2009 12:00:00 AM     Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
45541 92053 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1001 Potrero Ave   Sidewalk: Property side : Cutout Tree Private 2         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
161427 92055 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1001 Potrero Ave   Sidewalk: Property side : Yard Tree Private 2         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
175545 92054 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1001 Potrero Ave   Sidewalk: Property side : Cutout Tree Private 2         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
1871 261422 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1110x Vermont St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
2313 260963 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1100x Vermont St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
4089 260964 Significant Tree 6 Fraxinus spp :: Ash Spp 121 1100x Vermont St 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
4630 261689 Significant Tree 6 Fraxinus spp :: Ash Spp 121 1100x Vermont St 10 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
6430 260967 Significant Tree 6 Fraxinus spp :: Ash Spp 121 1100x Vermont St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
8787 260968 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 2400x 23rd St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
9066 260960 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1001 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
9216 261431 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1110x Vermont St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
10119 261688 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1100x Vermont St 9 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
13844 260966 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 7 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
14462 261432 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 8 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
16010 260965 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 6 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
129885 111357 Significant Tree 6 Pinus radiata :: Monterey Pine 15 600x MANSELL ST 1 Front Yard : Cutout Tree DPW 1     48 3x3   6010142 2090267 37.7200474236955 -122.406969764511 (37.7200474236955, -122.406969764511) 10 3 8 309 28
6334 104866 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Holladay Ave 1 Front Yard : Yard Tree Private 2           6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
52276 104869 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 411 Holladay Ave 4 Front Yard : Yard Tree Private 2         Permit Number 770735 6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
84450 104867 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 411 Holladay Ave 2 Front Yard : Yard Tree Private 2         Permit Number 770735 6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
123534 104868 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Holladay Ave 3 Front Yard : Yard Tree Private 2           6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
181750 6099 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 500X 08th St 1 Sidewalk: Property side : Cutout Tree Private 2     18 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
51708 173779 Significant Tree 6 Ficus macrophylla :: Morton Bay Fig 322 99X Cleveland St 2 Side Yard : Yard Tree Private 2       3x6   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
77590 173780 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 99X Cleveland St 3 Side Yard : Yard Tree Private 2       3x6   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
145519 173778 Significant Tree 6 Tree(s) :: 17 99X Cleveland St 1 Side Yard : Cutout Tree Private 2       3x3   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
93652 115295 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 500X 08TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010511 2109243 37.7721720235673 -122.407031076357 (37.7721720235673, -122.407031076357) 14 2 9 28853 34
172650 255483 Significant Tree 6 Persea americana :: Avocado 34 1295 Hampshire St 1 Front Yard : Yard Tree Private 2       Width 3ft   6010340.83328 2101731.71507 37.7515382084299 -122.407090155993 (37.7515382084299, -122.407090155993) 10 4 7 28859 19
158154 258096 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 941 Mission St 4 Sidewalk: Property side : Yard Tree Private 2   05/13/2019 12:00:00 AM 3 3x3   6010493.2294 2112796.27211 37.7819274857178 -122.407343084927 (37.7819274857178, -122.407343084927) 14 2 9 28853 34
156992 253621 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 200x Montcalm St 1 Back Yard : Yard Tree Private 2       3x3   6010036 2099760 37.7461072494139 -122.408005278478 (37.7461072494139, -122.408005278478) 2 7 7 28859 2
44600 107186 Significant Tree 6 Pinus radiata :: Monterey Pine 15 945 Sacramento St 2 Front Yard : Yard Tree Private 2         Permit Number 773422 6010352.63458 2116759.0624 37.7928004918921 -122.408109042355 (37.7928004918921, -122.408109042355) 3 1 10 28857 4
150077 107187 Significant Tree 6 Pinus radiata :: Monterey Pine 15 945 Sacramento St 3 Front Yard : Yard Tree Private 2         Permit Number 773422 6010352.63458 2116759.0624 37.7928004918921 -122.408109042355 (37.7928004918921, -122.408109042355) 3 1 10 28857 4
191590 107016 Significant Tree 6 Tree(s) :: 17 945 SACRAMENTO ST 1 Front Yard : Yard Tree Private 2   01/24/2015 12:00:00 AM     Permit Number 773422 6010352.6 2116759.1 37.7928005931964 -122.408109164657 (37.7928005931964, -122.408109164657) 3 1 10 28857 4
51717 115446 Significant Tree 6 Tree(s) :: 17 546 FRANCONIA ST 2 Back Yard : Yard Tree Private 2   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777844 6009931 2098208 37.7418399166086 -122.408258912238 (37.7418399166086, -122.408258912238) 10 7 7 28859 2
74590 115445 Significant Tree 6 Tree(s) :: 17 546 FRANCONIA ST 1 Back Yard : Yard Tree Private 2   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777844 6009931 2098208 37.7418399166086 -122.408258912238 (37.7418399166086, -122.408258912238) 10 7 7 28859 2
142994 112559 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1735x GRANT AVE 1 Back Yard : Yard Tree Private 2           6010373 2120454 37.8029470287696 -122.408299306743 (37.8029470287696, -122.408299306743) 3 1 10 308 23
66441 109838 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 200x MONTCALM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6009924 2099647 37.7457907048197 -122.408384592716 (37.7457907048197, -122.408384592716) 2 7 7 28859 2
100702 109040 Significant Tree 6 Juniperus chinensis :: Juniper 113 654 Precita Ave   Front Yard : Yard Tree Private 2     30     6009911.5 2100416.7 37.7479034320272 -122.408482100152 (37.7479034320272, -122.408482100152) 2 7 7 28859 2
167754 107159 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1000 ESMERALDA AVE   Front Yard : Yard Tree Private 2           6009839 2098688 37.7431527400861 -122.408610872619 (37.7431527400861, -122.408610872619) 10 7 7 28859 2
67165 258067 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 833 York St 1 Sidewalk: Property side : Cutout Tree Private 2       2x3 Permit Number 782335 6009933.30187 2104364.32189 37.758743943813 -122.408685158341 (37.758743943813, -122.408685158341) 2 4 7 28859 19
17902 113640 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 545X Minna St 1 Sidewalk: Property side : Cutout Tree Private 2           6010081.18772 2112137.85468 37.7800965567953 -122.408722101319 (37.7800965567953, -122.408722101319) 14 2 9 28853 34
174218 113641 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 545X Minna St 2 Sidewalk: Property side : Cutout Tree Private 2           6010081.18772 2112137.85468 37.7800965567953 -122.408722101319 (37.7800965567953, -122.408722101319) 14 2 9 28853 34
10947 94850 Significant Tree 6 Tree(s) :: 17 1107 Bowdoin St 1 Front Yard : Yard Tree Private 2   11/17/2010 12:00:00 AM     Permit Number 53929 6009593 2091048 37.7221611506882 -122.408922553301 (37.7221611506882, -122.408922553301) 10 3 7 309 28
107957 94851 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1107 Bowdoin St 2 Front Yard : Yard Tree Private 2   11/17/2010 12:00:00 AM 12   Permit Number 774691 6009593 2091048 37.7221611506882 -122.408922553301 (37.7221611506882, -122.408922553301) 10 3 7 309 28
63157 116234 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 450 PERALTA AVE 1 Front Yard : Yard Tree Private 2       3x3   6009750 2099218 37.744603019334 -122.408955999129 (37.744603019334, -122.408955999129) 2 7 7 28859 2

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