3,709 rows where qSpecies_id = 9 sorted by Zip Codes

View and edit SQL

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)
1005 39481 Permitted Site 7 Olea europaea :: Olive Tree 9 0 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM     Permit Number 40941                    
2927 35280 Permitted Site 7 Olea europaea :: Olive Tree 9   1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
4304 17630 DPW Maintained 1 Olea europaea :: Olive Tree 9 150 Phelps St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 10M                      
6966 35281 Permitted Site 7 Olea europaea :: Olive Tree 9   5 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
10720 39483 Permitted Site 7 Olea europaea :: Olive Tree 9 0 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM     Permit Number 40941                    
13401 35284 Permitted Site 7 Olea europaea :: Olive Tree 9   3 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
14355 35285 Permitted Site 7 Olea europaea :: Olive Tree 9   4 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
15594 19769 DPW Maintained 1 Olea europaea :: Olive Tree 9 100 STAIRWAY16 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 30ST                      
16339 39482 Permitted Site 7 Olea europaea :: Olive Tree 9 0 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM     Permit Number 40941                    
17767 35283 Permitted Site 7 Olea europaea :: Olive Tree 9   2 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
17923 19768 DPW Maintained 1 Olea europaea :: Olive Tree 9 100 STAIRWAY16 7 Sidewalk: Curb side : Cutout Tree DPW 1     6 30ST                      
18560 19875 DPW Maintained 1 Olea europaea :: Olive Tree 9 100 STAIRWAY33 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
3891 232910 DPW Maintained 1 Olea europaea :: Olive Tree 9 229 Haight St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004811.55535 2109480.0616 37.7725023496476 -122.426762832059 (37.7725023496476, -122.426762832059) 7 9 5 28852 10
4258 232897 DPW Maintained 1 Olea europaea :: Olive Tree 9 188 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004783.23018 2109050.50758 37.7713212969648 -122.426830214663 (37.7713212969648, -122.426830214663) 7 9 5 28852 10
4903 88595 Permitted Site 7 Olea europaea :: Olive Tree 9 399 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM   3x3 Permit Number 52536 6004228 2109402 37.7722550008378 -122.428775842479 (37.7722550008378, -122.428775842479) 7 9 11 28852 10
5721 246522 DPW Maintained 1 Olea europaea :: Olive Tree 9 155 Laguna St 5 Sidewalk: Curb side : Yard Tree Private 2     13 Width 6ft   6005173.73012 2109399.79549 37.7723024285329 -122.425504318986 (37.7723024285329, -122.425504318986) 7 9 5 28852 10
9805 246529 DPW Maintained 1 Olea europaea :: Olive Tree 9 95 Laguna St 2 : Tree Private 2     10 Width 4ft   6005210.23202 2109136.89842 37.77158263905 -122.425359343752 (37.77158263905, -122.425359343752) 7 9 5 28852 10
11761 10268 DPW Maintained 1 Olea europaea :: Olive Tree 9 215X Haight St 5 Sidewalk: Curb side : Cutout Tree DPW 1     2     6005053.18335 2109512.97249 37.7726063733294 -122.425929359246 (37.7726063733294, -122.425929359246) 7 9 5 28852 10
22169 232905 DPW Maintained 1 Olea europaea :: Olive Tree 9 190 Buchanan St 8 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004732.02467 2109415.61036 37.7723208853186 -122.427033345413 (37.7723208853186, -122.427033345413) 7 9 5 28852 10
23635 131926 DPW Maintained 1 Olea europaea :: Olive Tree 9 811 Turk St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6006096.41704 2112784.17992 37.7816472182901 -122.422553190084 (37.7816472182901, -122.422553190084) 7 9 11 28852 41
25642 103578 Permitted Site 7 Olea europaea :: Olive Tree 9 101X Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005198.60314 2109385.58511 37.772264815602 -122.425417269432 (37.772264815602, -122.425417269432) 7 9 5 28852 10
25812 42775 Permitted Site 7 Olea europaea :: Olive Tree 9 595 Hayes St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42746 6005021.69046201 2110898.204752 37.7764081042584 -122.426136930931 (37.7764081042584, -122.426136930931) 7 9 11 28852 10
26421 246525 DPW Maintained 1 Olea europaea :: Olive Tree 9 155 Laguna St 8 Sidewalk: Curb side : Yard Tree Private 2     12 Width 6ft   6005186.06731 2109316.74693 37.7720750943316 -122.425455732201 (37.7720750943316, -122.425455732201) 7 9 5 28852 10
27107 131933 DPW Maintained 1 Olea europaea :: Olive Tree 9 67 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008167.61892 2112668.53563 37.7814463160347 -122.415379603003 (37.7814463160347, -122.415379603003) 7 10 9 28852 36
30260 114430 Significant Tree 6 Olea europaea :: Olive Tree 9 455 EDDY ST 2 Sidewalk: Curb side : Pot Tree Private 2       3x3   6008254 2113439 37.7835666804498 -122.415135318852 (37.7835666804498, -122.415135318852) 7 10 9 28852 36
32165 103580 Permitted Site 7 Olea europaea :: Olive Tree 9 55X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
32298 232914 DPW Maintained 1 Olea europaea :: Olive Tree 9 229 Haight St 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004909.91403 2109494.03243 37.7725462707313 -122.426423594296 (37.7725462707313, -122.426423594296) 7 9 5 28852 10
33522 140025 DPW Maintained 1 Olea europaea :: Olive Tree 9 619 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6005803.6906 2111825.1954 37.7789975628417 -122.423497687453 (37.7789975628417, -122.423497687453) 7 9 11 28852 41
36989 9731 DPW Maintained 1 Olea europaea :: Olive Tree 9 641 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1     2 4x4   6005777.9079 2111995.4394 37.7794635560295 -122.423598987459 (37.7794635560295, -122.423598987459) 7 9 11 28852 41
38591 103581 Permitted Site 7 Olea europaea :: Olive Tree 9 55X Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
38691 9732 DPW Maintained 1 Olea europaea :: Olive Tree 9 645 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/14/2011 12:00:00 AM 3 4x4   6005775.5462 2112013.5463 37.7795131398465 -122.423608445305 (37.7795131398465, -122.423608445305) 7 9 11 28852 41
40141 34838 Permitted Site 7 Olea europaea :: Olive Tree 9 94 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/1997 12:00:00 AM     Permit Number 38463 6004273.91738669 2109284.40431145 37.7719347104397 -122.428608626151 (37.7719347104397, -122.428608626151) 7 9 11 28852 10
40305 114742 Undocumented 4 Olea europaea :: Olive Tree 9 188 BUCHANAN ST 5 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6004735 2109327 37.7720777510232 -122.427016741179 (37.7720777510232, -122.427016741179) 7 9 5 28852 10
40829 42773 Permitted Site 7 Olea europaea :: Olive Tree 9 595 Hayes St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42746 6005021.69046201 2110898.204752 37.7764081042584 -122.426136930931 (37.7764081042584, -122.426136930931) 7 9 11 28852 10
41602 114741 Undocumented 4 Olea europaea :: Olive Tree 9 188 BUCHANAN ST 4 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6004735 2109327 37.7720777510232 -122.427016741179 (37.7720777510232, -122.427016741179) 7 9 5 28852 10
43500 103583 Permitted Site 7 Olea europaea :: Olive Tree 9 55X Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
44605 246528 DPW Maintained 1 Olea europaea :: Olive Tree 9 95 Laguna St 1 : Tree Private 2     13 Width 7ft   6005204.62433 2109172.65839 37.7716805104709 -122.425381286315 (37.7716805104709, -122.425381286315) 7 9 5 28852 10
47658 232900 DPW Maintained 1 Olea europaea :: Olive Tree 9 190 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004744.51087 2109324.00731 37.7720700716203 -122.426983629118 (37.7720700716203, -122.426983629118) 7 9 5 28852 10
48372 9726 DPW Maintained 1 Olea europaea :: Olive Tree 9 621 Gough St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6005799.3606 2111864.1645 37.7791043180853 -122.423515437911 (37.7791043180853, -122.423515437911) 7 9 11 28852 41
49276 245866 DPW Maintained 1 Olea europaea :: Olive Tree 9 227 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005127.6304 2109748.3565 37.773256887823 -122.425688595356 (37.773256887823, -122.425688595356) 7 9 11 28852 10
54913 131928 DPW Maintained 1 Olea europaea :: Olive Tree 9 57 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008190.28209 2112514.30533 37.7810241104069 -122.41529027784 (37.7810241104069, -122.41529027784) 7 10 9 28852 36
55613 114746 Undocumented 4 Olea europaea :: Olive Tree 9 188 BUCHANAN ST 9 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6004735 2109327 37.7720777510232 -122.427016741179 (37.7720777510232, -122.427016741179) 7 9 5 28852 10
56389 232898 DPW Maintained 1 Olea europaea :: Olive Tree 9 190 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004751.04399 2109279.15685 37.771947292552 -122.426957835644 (37.771947292552, -122.426957835644) 7 9 5 28852 10
58407 232909 DPW Maintained 1 Olea europaea :: Olive Tree 9 229 Haight St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004792.08371 2109478.77871 37.7724977262242 -122.426830095058 (37.7724977262242, -122.426830095058) 7 9 5 28852 10
59953 232901 DPW Maintained 1 Olea europaea :: Olive Tree 9 190 Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004740.99603 2109348.33209 37.7721366628156 -122.426997520024 (37.7721366628156, -122.426997520024) 7 9 5 28852 10
62468 232903 DPW Maintained 1 Olea europaea :: Olive Tree 9 190 Buchanan St 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004735.97961 2109381.85311 37.7722284197429 -122.427017260159 (37.7722284197429, -122.427017260159) 7 9 5 28852 10
64751 10267 DPW Maintained 1 Olea europaea :: Olive Tree 9 229X Haight St 10 Sidewalk: Curb side : Cutout Tree Private 2     24 4x5   6004928.57518 2109497.01592 37.7725555175436 -122.4263592559 (37.7725555175436, -122.4263592559) 7 9 5 28852 10
66898 9727 DPW Maintained 1 Olea europaea :: Olive Tree 9 621 Gough St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6005801.3288 2111846.4513 37.779055793051 -122.423507369454 (37.779055793051, -122.423507369454) 7 9 11 28852 41
68843 232916 DPW Maintained 1 Olea europaea :: Olive Tree 9 213 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6005073.54336 2109516.34199 37.7726167757681 -122.425859171679 (37.7726167757681, -122.425859171679) 7 9 5 28852 10
69588 10276 DPW Maintained 1 Olea europaea :: Olive Tree 9 215X Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   6004948.05546 2109498.71961 37.7725612966014 -122.426291992897 (37.7725612966014, -122.426291992897) 7 9 5 28852 10
69849 131927 DPW Maintained 1 Olea europaea :: Olive Tree 9 57 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008192.35863 2112492.08012 37.7809632020188 -122.415281520245 (37.7809632020188, -122.415281520245) 7 10 9 28852 36
75801 232436 DPW Maintained 1 Olea europaea :: Olive Tree 9 98 Laussat St 2 : Tree Private 2     7 Width 3ft   6004291.45992 2109275.43151 37.7719110660771 -122.428547305538 (37.7719110660771, -122.428547305538) 7 9 11 28852 10
75859 114743 Undocumented 4 Olea europaea :: Olive Tree 9 188 BUCHANAN ST 6 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6004735 2109327 37.7720777510232 -122.427016741179 (37.7720777510232, -122.427016741179) 7 9 5 28852 10
78736 232907 DPW Maintained 1 Olea europaea :: Olive Tree 9 229 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004758.59906 2109474.41705 37.7724838568662 -122.426945611154 (37.7724838568662, -122.426945611154) 7 9 5 28852 10
79388 232908 DPW Maintained 1 Olea europaea :: Olive Tree 9 229 Haight St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004775.12144 2109476.18153 37.7724896359272 -122.426888584266 (37.7724896359272, -122.426888584266) 7 9 5 28852 10
80665 31344 Permitted Site 7 Olea europaea :: Olive Tree 9 254 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39121 6006126.25781902 2111278.60753762 37.7775149666293 -122.422342949952 (37.7775149666293, -122.422342949952) 7 9 11 28852 10
82365 103579 Permitted Site 7 Olea europaea :: Olive Tree 9 101X Laguna St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005198.60314 2109385.58511 37.772264815602 -122.425417269432 (37.772264815602, -122.425417269432) 7 9 5 28852 10
86508 34839 Permitted Site 7 Olea europaea :: Olive Tree 9 94 Laussat St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/29/1997 12:00:00 AM     Permit Number 38463 6004273.91738669 2109284.40431145 37.7719347104397 -122.428608626151 (37.7719347104397, -122.428608626151) 7 9 11 28852 10
86925 114745 Undocumented 4 Olea europaea :: Olive Tree 9 188 BUCHANAN ST 8 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6004735 2109327 37.7720777510232 -122.427016741179 (37.7720777510232, -122.427016741179) 7 9 5 28852 10
91693 246530 DPW Maintained 1 Olea europaea :: Olive Tree 9 95 Laguna St 3 : Tree Private 2     13 Width 7ft   6005220.62037 2109069.23024 37.7713974254703 -122.425318593679 (37.7713974254703, -122.425318593679) 7 9 5 28852 10
93582 245837 DPW Maintained 1 Olea europaea :: Olive Tree 9 451 Fell St 6 Sidewalk: Curb side : Cutout Tree Private 2   06/24/1995 12:00:00 AM 3 Width 0ft   6005362.4532 2110596.2894 37.7755983722601 -122.424936650191 (37.7755983722601, -122.424936650191) 7 9 11 28852 10
93669 232913 DPW Maintained 1 Olea europaea :: Olive Tree 9 229 Haight St 7 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004866.27117 2109489.03769 37.7725300892179 -122.426574203751 (37.7725300892179, -122.426574203751) 7 9 5 28852 10
96437 6921 DPW Maintained 1 Olea europaea :: Olive Tree 9 425 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/09/2010 12:00:00 AM 3 3X3   6005385.421 2110602.3829 37.7756164008395 -122.424857632506 (37.7756164008395, -122.424857632506) 7 9 11 28852 10
97365 131930 DPW Maintained 1 Olea europaea :: Olive Tree 9 57 Hyde St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6008182.65899 2112562.35593 37.7811556173851 -122.41532005259 (37.7811556173851, -122.41532005259) 7 10 9 28852 36
99005 232918 DPW Maintained 1 Olea europaea :: Olive Tree 9 213 Haight St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6005112.96946 2109521.84472 37.7726341129051 -122.425723184286 (37.7726341129051, -122.425723184286) 7 9 5 28852 10
99027 114744 Undocumented 4 Olea europaea :: Olive Tree 9 188 BUCHANAN ST 7 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6004735 2109327 37.7720777510232 -122.427016741179 (37.7720777510232, -122.427016741179) 7 9 5 28852 10
100306 258518 DPW Maintained 1 Olea europaea :: Olive Tree 9 50 Hermann St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
103550 232915 DPW Maintained 1 Olea europaea :: Olive Tree 9 215 Haight St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6005030.31421 2109510.9176 37.7725994386426 -122.426008319741 (37.7725994386426, -122.426008319741) 7 9 5 28852 10
104105 246518 DPW Maintained 1 Olea europaea :: Olive Tree 9 155 Laguna St 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 7ft   6005162.55314 2109484.17323 37.7725334778669 -122.425548987397 (37.7725334778669, -122.425548987397) 7 9 5 28852 10
107094 9725 DPW Maintained 1 Olea europaea :: Olive Tree 9 621 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6005796.9989 2111889.3567 37.779173356417 -122.42352539952 (37.779173356417, -122.42352539952) 7 9 11 28852 41
112119 103587 Permitted Site 7 Olea europaea :: Olive Tree 9 55X Laguna St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
115164 42776 Permitted Site 7 Olea europaea :: Olive Tree 9 595 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/03/2001 12:00:00 AM     Permit Number 42746 6005021.69046201 2110898.204752 37.7764081042584 -122.426136930931 (37.7764081042584, -122.426136930931) 7 9 11 28852 10
115230 103577 Permitted Site 7 Olea europaea :: Olive Tree 9 101X Laguna St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005198.60314 2109385.58511 37.772264815602 -122.425417269432 (37.772264815602, -122.425417269432) 7 9 5 28852 10
116069 232917 DPW Maintained 1 Olea europaea :: Olive Tree 9 213 Haight St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6005093.48055 2109519.72022 37.7726271782419 -122.425790447293 (37.7726271782419, -122.425790447293) 7 9 5 28852 10
117169 42771 Permitted Site 7 Olea europaea :: Olive Tree 9 595 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42746 6005021.69046201 2110898.204752 37.7764081042584 -122.426136930931 (37.7764081042584, -122.426136930931) 7 9 11 28852 10
117399 139985 DPW Maintained 1 Olea europaea :: Olive Tree 9 635 GOUGH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6005789.3231 2111954.5021 37.7793517965316 -122.42355658612 (37.7793517965316, -122.42355658612) 7 9 11 28852 41
118437 96380 DPW Maintained 1 Olea europaea :: Olive Tree 9 553 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6005168.9792 2111274.178 37.7774487586726 -122.425654182863 (37.7774487586726, -122.425654182863) 7 9 11 28852 10
118629 9724 DPW Maintained 1 Olea europaea :: Olive Tree 9 605X Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1     8 4x4   6005802.58314 2111825.66599 37.7789987924589 -122.423501552072 (37.7789987924589, -122.423501552072) 7 9 11 28852 41
123392 131931 DPW Maintained 1 Olea europaea :: Olive Tree 9 67 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008173.40343 2112629.59757 37.7813397265891 -122.415356833968 (37.7813397265891, -122.415356833968) 7 10 9 28852 36
128220 22588 DPW Maintained 1 Olea europaea :: Olive Tree 9 801 Turk St 4 Sidewalk: Curb side : Cutout Tree DPW 1   12/11/1990 12:00:00 AM 12 4x4   6006166.11327 2112793.0062544 37.7816753849136 -122.422312701127 (37.7816753849136, -122.422312701127) 7 9 11 28852 41
130649 232899 DPW Maintained 1 Olea europaea :: Olive Tree 9 190 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004747.90641 2109304.15251 37.7720157471575 -122.426970469322 (37.7720157471575, -122.426970469322) 7 9 5 28852 10
132496 42770 Permitted Site 7 Olea europaea :: Olive Tree 9 595 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42746 6005021.69046201 2110898.204752 37.7764081042584 -122.426136930931 (37.7764081042584, -122.426136930931) 7 9 11 28852 10
133367 42772 Permitted Site 7 Olea europaea :: Olive Tree 9 595 Hayes St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42746 6005021.69046201 2110898.204752 37.7764081042584 -122.426136930931 (37.7764081042584, -122.426136930931) 7 9 11 28852 10
133585 88022 Permitted Site 7 Olea europaea :: Olive Tree 9 198 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51047 6008282.3 2112522.3 37.7810512330082 -122.41497250722 (37.7810512330082, -122.41497250722) 7 10 9 28852 36
134479 232906 DPW Maintained 1 Olea europaea :: Olive Tree 9 190 Buchanan St 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004730.20675 2109429.96028 37.7723601839173 -122.427040656018 (37.7723601839173, -122.427040656018) 7 9 5 28852 10
136925 103576 Permitted Site 7 Olea europaea :: Olive Tree 9 101X Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005198.60314 2109385.58511 37.772264815602 -122.425417269432 (37.772264815602, -122.425417269432) 7 9 5 28852 10
138939 88021 Permitted Site 7 Olea europaea :: Olive Tree 9 198 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51047 6008282.3 2112522.3 37.7810512330082 -122.41497250722 (37.7810512330082, -122.41497250722) 7 10 9 28852 36
140075 131934 DPW Maintained 1 Olea europaea :: Olive Tree 9 67 Hyde St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008167.55656 2112690.21522 37.7815058394753 -122.415381353982 (37.7815058394753, -122.415381353982) 7 10 9 28852 36
140784 103575 Permitted Site 7 Olea europaea :: Olive Tree 9 101X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005198.60314 2109385.58511 37.772264815602 -122.425417269432 (37.772264815602, -122.425417269432) 7 9 5 28852 10
146315 232904 DPW Maintained 1 Olea europaea :: Olive Tree 9 190 Buchanan St 7 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004735.06721 2109399.13084 37.7722758086024 -122.427021647038 (37.7722758086024, -122.427021647038) 7 9 5 28852 10
150536 88023 Permitted Site 7 Olea europaea :: Olive Tree 9 198 McAllister St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51047 6008282.3 2112522.3 37.7810512330082 -122.41497250722 (37.7810512330082, -122.41497250722) 7 10 9 28852 36
152077 114739 Undocumented 4 Olea europaea :: Olive Tree 9 188 BUCHANAN ST 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6004735 2109327 37.7720777510232 -122.427016741179 (37.7720777510232, -122.427016741179) 7 9 5 28852 10
157691 131929 DPW Maintained 1 Olea europaea :: Olive Tree 9 57 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008185.16924 2112536.59269 37.781085018795 -122.415309543996 (37.781085018795, -122.415309543996) 7 10 9 28852 36
159269 42774 Permitted Site 7 Olea europaea :: Olive Tree 9 595 Hayes St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42746 6005021.69046201 2110898.204752 37.7764081042584 -122.426136930931 (37.7764081042584, -122.426136930931) 7 9 11 28852 10
165363 10278 DPW Maintained 1 Olea europaea :: Olive Tree 9 215X Haight St 3 Sidewalk: Curb side : Cutout Tree DPW 1   08/12/1996 12:00:00 AM 6 6X6   6005000.61509 2109505.63565 37.7725832571536 -122.426110676071 (37.7725832571536, -122.426110676071) 7 9 5 28852 10
166388 114740 Undocumented 4 Olea europaea :: Olive Tree 9 188 BUCHANAN ST 3 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6004735 2109327 37.7720777510232 -122.427016741179 (37.7720777510232, -122.427016741179) 7 9 5 28852 10
167357 232912 DPW Maintained 1 Olea europaea :: Olive Tree 9 229 Haight St 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004848.4378 2109485.19544 37.7725185311402 -122.426635617559 (37.7725185311402, -122.426635617559) 7 9 5 28852 10
168149 232911 DPW Maintained 1 Olea europaea :: Olive Tree 9 229 Haight St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004830.21653 2109483.04502 37.7725115964545 -122.426698493634 (37.7725115964545, -122.426698493634) 7 9 5 28852 10
168479 88702 Permitted Site 7 Olea europaea :: Olive Tree 9 225 Laguna St   Sidewalk: Curb side : Cutout Tree Private 2   08/07/2008 12:00:00 AM   3x3 Permit Number 51652 6005143 2109639 37.7729574898546 -122.425627645138 (37.7729574898546, -122.425627645138) 7 9 11 28852 10
169863 9728 DPW Maintained 1 Olea europaea :: Olive Tree 9 629 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6005789.7168 2111936.3952 37.7793021016267 -122.423553936469 (37.7793021016267, -122.423553936469) 7 9 11 28852 41

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