trees

439 rows where qSpecies_id = 148

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

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)
50243 26639 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 6530X California St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/02/1998 12:00:00 AM 80 5   5987349.71414 2113973.97564 37.783838627391 -122.487494476151 (37.783838627391, -122.487494476151) 11 6 1 55 33
51107 91344 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 90 Gough St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   3x3 Permit Number 52043 6006233.7 2109956.2 37.7738900148236 -122.42187731202 (37.7738900148236, -122.42187731202) 7 9 11 28852 10
51452 2624 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1822 Bush St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/26/2018 12:00:00 AM 3 3X3 Permit Number 781445 6004615.6699 2115060.0567 37.7878125608959 -122.427838089219 (37.7878125608959, -122.427838089219) 13 9 11 28858 27
51845 116302 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1550 Scott St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6002138.3 2113859.7 37.7843762313587 -122.436323371803 (37.7843762313587, -122.436323371803) 13 6 11 29490 13
52938 28045 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
53109 91850 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 855 HARRISON ST 9 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2007 12:00:00 AM 7 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
53356 27992 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 29 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
53422 84564 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1100X Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 5 4x4 Permit Number 769743 6003799.76299969 2101850.31253229 37.7514956297527 -122.429718442511 (37.7514956297527, -122.429718442511) 2 4 5 28862 22
54544 27988 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 25 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
54616 13948 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1112X Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/1994 12:00:00 AM 12 4x4   6008868.4803223 2112239.1730786 37.7803067555436 -122.412924586563 (37.7803067555436, -122.412924586563) 7 2 9 28852 36
55209 28153 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
55898 111376 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 15 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
55995 28163 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 16 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
56014 8417 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1625X Geary Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1   06/16/1997 12:00:00 AM 6 3X3   6003997.4163 2113895.15466 37.7845790386871 -122.429894005852 (37.7845790386871, -122.429894005852) 13 9 11 29490 41
56128 116290 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
57943 95166 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1300X Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6001355.20441 2112906.07306 37.7817132894018 -122.438964239497 (37.7817132894018, -122.438964239497) 15 5 11 29490 41
57956 122512 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 721 Valencia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     7 3x6   6006289 2105371 37.7613032617497 -122.421360338097 (37.7613032617497, -122.421360338097) 2 4 7 28859 19
58214 102158 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 4300X 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6001255.1 2101750.3 37.751076597898 -122.438511014093 (37.751076597898, -122.438511014093) 2 4 5 28862 22
58562 27965 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
58660 13940 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1140X Market St 8 Sidewalk: Curb side : Cutout Tree DPW 1     45 4x4   6008690.2869843 2112068.9420038 37.7798293375501 -122.413528998881 (37.7798293375501, -122.413528998881) 7 2 9 28852 36
58720 109763 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 899 VALENCIA ST 2 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM   3x3 Permit Number 772584 6006382.7 2104441.4 37.7587560793788 -122.420970264824 (37.7587560793788, -122.420970264824) 2 4 7 28859 19
58809 14170 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1776X Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/11/2015 10:09:00 AM 3 4x4   6005777.896097 2109293.199395 37.7720438591777 -122.423406872271 (37.7720438591777, -122.423406872271) 7 2 11 28852 10
59418 27255 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 620X Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006737.40655 2112650.78896 37.7813170997428 -122.420326195624 (37.7813170997428, -122.420326195624) 7 9 9 28852 36
59971 116303 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1550 Scott St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6002138.3 2113859.7 37.7843762313587 -122.436323371803 (37.7843762313587, -122.436323371803) 13 6 11 29490 13
59981 27302 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 4327 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     45 3X3   5994140.41077 2114141.59782 37.7846925678068 -122.464013547575 (37.7846925678068, -122.464013547575) 11 6 2 54 11
60140 28161 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
60464 116304 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1550 Scott St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6002138.3 2113859.7 37.7843762313587 -122.436323371803 (37.7843762313587, -122.436323371803) 13 6 11 29490 13
61145 97531 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 90 07th St 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2011 12:00:00 AM 3 5x5 Permit Number 768281 6009381.233023 2111863.03951 37.7793027506323 -122.411124154099 (37.7793027506323, -122.411124154099) 8 2 9 28853 34
61352 27964 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
61354 24389 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 3641 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2004 12:00:00 AM 3 4X4   6005406.19827 2096949.60563 37.7381302401684 -122.423814755555 (37.7381302401684, -122.423814755555) 2 7 7 28859 2
62166 28334 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 3241 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/22/2005 12:00:00 AM 9 3X3   6006567.49057 2099355.80784 37.7448026219753 -122.419970283481 (37.7448026219753, -122.419970283481) 2 7 7 28859 2
63150 28050 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 6 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
64235 13870 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1000 Market St 9 Sidewalk: Curb side : Cutout Tree DPW 1   02/10/2007 12:00:00 AM 8 4x4   6009621.3575962 2112944.5572428 37.7822858053101 -122.410369845025 (37.7822858053101, -122.410369845025) 14 2 9 28852 36
64239 28155 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
65056 28016 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 13 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014245.12601 2117603.06501 37.7953351012525 -122.394699876607 (37.7953351012525, -122.394699876607) 4 2 10 28860 6
65902 28017 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 14 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014258.14701 2117577.02301 37.7952643199629 -122.394652996927 (37.7952643199629, -122.394652996927) 4 2 10 28860 6
66289 97530 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 90 07th St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2011 12:00:00 AM 3 5x5 Permit Number 768281 6009381.233023 2111863.03951 37.7793027506323 -122.411124154099 (37.7793027506323, -122.411124154099) 8 2 9 28853 34
66342 14084 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1411 Market St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/27/2015 12:00:00 AM 3 4X4 Permit Number 775519 6007340.8551319 2110667.3761307 37.7759051108463 -122.418097899429 (37.7759051108463, -122.418097899429) 8 2 9 28853 34
67495 3009 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2402 California St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/11/2012 12:00:00 AM 3 3x3   6002808.01196 2115517.13179 37.7889651474795 -122.434124927834 (37.7889651474795, -122.434124927834) 13 9 1 29490 27
67522 5221 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1009X Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2005 12:00:00 AM 5 3X3   6001407.0548 2111843.67263 37.7787991574032 -122.438708711528 (37.7787991574032, -122.438708711528) 15 5 11 29490 41
67552 27792 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X The Embarcadero 9 Median : Cutout Tree Port 6     12     6014015.4653372 2118064.3876984 37.7965890133894 -122.395526881953 (37.7965890133894, -122.395526881953) 3 1 10 28860 6
68393 117958 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 851X HARRISON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6012435 2111995 37.7798358648386 -122.400569108585 (37.7798358648386, -122.400569108585) 6 2 9 28856 34
68592 116702 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1450 Divisadero St 7 Sidewalk: Curb side : Cutout Tree Mayor Office of Housing 11       3X3   6001279.3901091 2113342.5749494 37.7829074983832 -122.439257816981 (37.7829074983832, -122.439257816981) 15 5 11 29490 41
68754 116286 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
68947 13857 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 991 Market St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/10/2007 12:00:00 AM 6 4X4   6009733.8299349 2112955.195175 37.7823213188284 -122.409981490315 (37.7823213188284, -122.409981490315) 14 2 9 28853 34
69024 28053 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 9 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
69445 28047 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 3 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
69655 122511 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 715 Valencia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     5 3x6   6006287 2105397 37.7613745389022 -122.421369101713 (37.7613745389022, -122.421369101713) 2 4 7 28859 19
70694 23003 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 740X Valencia St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/23/1994 12:00:00 AM 8 3X3   6006197 2105252 37.7609713282095 -122.421670075458 (37.7609713282095, -122.421670075458) 2 4 5 28859 19
71285 28167 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X King St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
71851 97533 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 90 07th St 5 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2011 12:00:00 AM 3 5x5 Permit Number 768281 6009381.233023 2111863.03951 37.7793027506323 -122.411124154099 (37.7793027506323, -122.411124154099) 8 2 9 28853 34
72171 5231 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1053 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/03/1999 12:00:00 AM 6 3X3   6001315.02339 2112044.91566 37.7793464837663 -122.439041510199 (37.7793464837663, -122.439041510199) 15 5 11 29490 41
72192 85433 - 12 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 360Y1 Valencia St   Sidewalk: Curb side : Cutout Tree DPW 1 Private 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646) 8 4 5 28853 19
72225 91784 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1098 HARRISON ST 6 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2007 12:00:00 AM 40 3x3   6010813 2110645 37.7760384868277 -122.40608521627 (37.7760384868277, -122.40608521627) 14 2 9 28853 34
72523 14128 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1621 Market St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/27/2017 09:15:00 AM 3 4X4   6006600.23891 2109952.28073 37.7738999176888 -122.420609113022 (37.7738999176888, -122.420609113022) 8 2 9 28853 19
73894 91794 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 700x Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2007 12:00:00 AM 3 3x3   6013352.664153 2112972.090127 37.7825698655965 -122.397463025411 (37.7825698655965, -122.397463025411) 6 2 9 28856 34
74286 91838 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1617 Harrison St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008750.352862 2108461.38548 37.7699272102311 -122.413066048552 (37.7699272102311, -122.413066048552) 8 2 9 28853 19
74683 13505 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 245 Market St 7 Sidewalk: Curb side : Cutout Tree DPW 1   10/28/2005 12:00:00 AM 6 4X4   6013642.6483486 2116679.2066582 37.7927648888925 -122.396719764541 (37.7927648888925, -122.396719764541) 12 2 9 28855 6
74959 15604 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 3333 Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2004 12:00:00 AM 3 4X4   6006368.01098 2098829.09498 37.7433451466609 -122.420622664534 (37.7433451466609, -122.420622664534) 2 7 7 28859 2
75312 28323 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 3100 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/10/2004 12:00:00 AM 11 4x4   6007076.90394 2100561.83623 37.7481427912413 -122.418294317161 (37.7481427912413, -122.418294317161) 2 4 7 28859 2
75983 91335 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 90 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   3x3 Permit Number 52043 6006233.7 2109956.2 37.7738900148236 -122.42187731202 (37.7738900148236, -122.42187731202) 7 9 11 28852 10
76168 27995 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 32 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
76312 91803 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2989 Harrison St   Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6009039.569733 2101067.518808 37.7496415669707 -122.411543181878 (37.7496415669707, -122.411543181878) 2 4 7 28859 19
76766 85437 - 12 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 360Y4 Valencia St   Sidewalk: Curb side : Cutout Tree DPW 1 Private 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646) 8 4 5 28853 19
77190 95181 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1301X Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6001253.46052 2112914.04483 37.781729388453 -122.439316796194 (37.781729388453, -122.439316796194) 15 5 11 29490 41
77788 8375 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1301X Geary Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005507.71189 2114109.8093 37.7852538400076 -122.424684163392 (37.7852538400076, -122.424684163392) 13 9 11 28858 41
77944 27674 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 350 McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6007460.0458899 2112313.2676776 37.780431041784 -122.417802279395 (37.780431041784, -122.417802279395) 7 9 9 28852 36
78850 23383 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1451X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/1999 12:00:00 AM 10 3X3   6006248.25114 2115440.18145 37.7889485091226 -122.42221667202 (37.7889485091226, -122.42221667202) 13 9 1 28858 41
79095 85444 - 12 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 360Y10 Valencia St   Sidewalk: Curb side : Cutout Tree DPW 1 Private 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646) 8 4 5 28853 19
79199 84561 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1095X Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769743 6003825.808508 2101903.8292833 37.7516440490083 -122.429632190427 (37.7516440490083, -122.429632190427) 2 4 5 28862 22
79601 28046 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
79663 28725 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1970 Sutter St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2013 12:00:00 AM 3 3x3   6003187.8589 2114511.853 37.7862264577302 -122.432738867912 (37.7862264577302, -122.432738867912) 13 9 11 29490 27
80899 13830 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 965 Market St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/10/2007 12:00:00 AM 3 4X4   6009908.9307448 2113122.0497873 37.7827892741888 -122.409387495448 (37.7827892741888, -122.409387495448) 14 2 9 28853 34
81270 22592 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 785X Franklin St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/14/2002 12:00:00 AM 3 4X4   6006155.3095005 2112777.9901286 37.7816335448796 -122.422349009875 (37.7816335448796, -122.422349009875) 7 9 11 28852 41
81477 86693 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1355 Market St 8 Sidewalk: Curb side : Cutout Tree DPW 1   09/19/2007 12:00:00 AM     Permit Number 49693 6007704.191622 2111021.854521 37.7768988673684 -122.416866141309 (37.7768988673684, -122.416866141309) 8 2 9 28853 34
81731 14123 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1615 Market St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/18/2014 02:16:00 PM 3 4X4   6006597.57832 2109978.9478798 37.7739729893435 -122.420620209869 (37.7739729893435, -122.420620209869) 8 2 9 28853 19
81937 16723 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1075 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/18/2012 12:00:00 AM 3 4X4   6006252.84558 2113856.064 37.7845991729485 -122.422088192257 (37.7845991729485, -122.422088192257) 7 9 11 28858 41
81977 15597 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 3281 MISSION ST 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/03/2013 12:00:00 AM 9 3X3   6006413.8 2099188.7 37.7443351215041 -122.420489857879 (37.7443351215041, -122.420489857879) 2 7 7 28859 2
82500 112842 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 604 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2015 12:00:00 AM     Permit Number 773221 5992274.9 2111288.5 37.7767510524606 -122.470259695975 (37.7767510524606, -122.470259695975) 11 6 2 54 11
82698 13471 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 101 Market St 10 Sidewalk: Curb side : Cutout Tree DPW 1   01/01/2005 12:00:00 AM 20 4X4   6013989.3283097 2117008.9290081 37.79368951828 -122.395543339024 (37.79368951828, -122.395543339024) 12 2 9 28855 6
83247 27970 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 7 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
83783 95165 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1100 Divisadero St 7 Sidewalk: Curb side : Cutout Tree DPW 1   08/19/2014 12:00:00 AM 3 3x3   6001410.7267 2112361.1413 37.7802202041401 -122.438733098992 (37.7802202041401, -122.438733098992) 15 5 11 29490 41
83891 116287 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
84052 13946 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1108 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/08/1999 12:00:00 AM 12 4x4   6008893.4024674 2112262.9816205 37.7803735270406 -122.412840052753 (37.7803735270406, -122.412840052753) 7 2 9 28852 36
86603 116285 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
87123 91336 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 90 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   3x3 Permit Number 52043 6006233.7 2109956.2 37.7738900148236 -122.42187731202 (37.7738900148236, -122.42187731202) 7 9 11 28852 10
87567 27983 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 20 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
87629 27679 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 350 McAllister St 6 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6007460.0458899 2112313.2676776 37.780431041784 -122.417802279395 (37.780431041784, -122.417802279395) 7 9 9 28852 36
87721 103745 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1999X Folsom St 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2007 12:00:00 AM 3 3x3   6008051.81901 2107091.22594 37.7661258341797 -122.415385257212 (37.7661258341797, -122.415385257212) 8 4 7 28853 19
88068 27805 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 350X The Embarcadero 4 Sidewalk: Curb side : Cutout Tree Port 6   11/15/2012 12:00:00 AM 12 4x4 Permit Number 769363 6013785.7946449 2118604.8635638 37.7980602547356 -122.396359500707 (37.7980602547356, -122.396359500707) 3 1 10 28860 6
88844 13503 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 245 Market St 5 Sidewalk: Curb side : Cutout Tree DPW 1   10/28/2005 12:00:00 AM 6 4X4   6013642.6483486 2116679.2066582 37.7927648888925 -122.396719764541 (37.7927648888925, -122.396719764541) 12 2 9 28855 6
89848 28013 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 10 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014214.74401 2117682.27501 37.7955509040886 -122.394810554146 (37.7955509040886, -122.394810554146) 4 2 10 28860 6
91070 91801 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 3071 Harrison St   Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6009060.650721 2100687.104692 37.7485982168729 -122.4114434106 (37.7485982168729, -122.4114434106) 2 4 7 28859 19
91931 13591 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 525 Market St 13 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2004 12:00:00 AM 8 4X4   6012787.5365724 2115865.9219292 37.7904841708264 -122.399621379879 (37.7904841708264, -122.399621379879) 12 2 9 28855 6
92897 121027 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1101X South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     14 3x3   6007689 2103175 37.7553523831166 -122.416362767289 (37.7553523831166, -122.416362767289) 2 4 7 28859 19
93141 23203 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 590 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1999 12:00:00 AM 8 3x3   6006785.52098 2112480.30357 37.7808516993941 -122.420147639969 (37.7808516993941, -122.420147639969) 7 9 9 28852 36
93294 13520 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 388 Market St 3 Sidewalk: Curb side : Cutout Tree DPW 1     30 4X4   6013190.8445953 2116364.9078359 37.7918767419323 -122.3982609742 (37.7918767419323, -122.3982609742) 4 2 10 28860 6
93430 91821 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2395x Harrison St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008850.144084 2104529.130727 37.7591357459563 -122.412442878611 (37.7591357459563, -122.412442878611) 2 4 7 28859 19
93447 27256 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 660X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006717.7455722 2112795.3484565 37.7817129170403 -122.420404476934 (37.7817129170403, -122.420404476934) 7 9 9 28852 36
93711 26877 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 275 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3 Permit Number 771536 6006101 2108089 37.7687556461675 -122.422203660432 (37.7687556461675, -122.422203660432) 8 4 7 28853 19

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