Street_Tree_List

Data source: data.sfgov.org

505 rows where qSpecies = 27 sorted by Latitude

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude ▼ Longitude Location
11989 26837 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 1100X Duncan St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 2x2            
59888 177028 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 164 Baltimore Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6002357.56159 2086195.5289200002 37.7084293823926 -122.433587065817 (37.7084293823926, -122.433587065817)
131950 71605 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 178 Wilson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 7     5994512.31694 2086511.3564 37.7088483153534 -122.46072384594 (37.7088483153534, -122.46072384594)
30981 71589 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 177 Goethe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 8     5994699.454059999 2086647.11862 37.7092318519263 -122.460086907391 (37.7092318519263, -122.460086907391)
48088 31195 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 260 Saint Charles Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/22/1995 12:00:00 AM 6   Permit Number 34888 5992024.42182 2086737.21442 37.7093250109181 -122.469338707216 (37.7093250109181, -122.469338707216)
123975 57938 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 7 Byron Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/18/2010 12:00:00 AM 4   Permit Number 53686 5999410.13624 2086691.6630000002 37.7096239797406 -122.443809305177 (37.7096239797406, -122.443809305177)
157438 177007 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 216 Saint Charles Ave 1 : 4 Tree 1 Private 1     5 Width 3ft   5992028.26989 2086999.54978 37.710045543251205 -122.469344489883 (37.7100455432512, -122.469344489883)
177917 177001 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 154 Gillette Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6013011.29164 2086676.67622 37.7103492505861 -122.396799956671 (37.7103492505861, -122.396799956671)
44944 176990 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5998584.85135 2087137.0809 37.7107998882796 -122.446693649496 (37.7107998882796, -122.446693649496)
166521 176991 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5998612.37791 2087142.9006400001 37.710817440355704 -122.446598930212 (37.7108174403557, -122.446598930212)
26959 176992 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998628.254290001 2087146.50399 37.7108282412039 -122.446544317082 (37.7108282412039, -122.446544317082)
57399 176993 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998644.90157 2087151.5668400002 37.7108430935156 -122.44648714447099 (37.7108430935156, -122.446487144471)
39601 176994 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998658.093780001 2087156.70124 37.7108579449184 -122.446441918457 (37.7108579449184, -122.446441918457)
158570 176995 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998691.25418 2087172.2379400001 37.7109024991335 -122.44632842581301 (37.7109024991335, -122.446328425813)
72391 176996 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5998705.41323 2087176.369 37.7109146507487 -122.44627978598999 (37.7109146507487, -122.44627978599)
135933 176997 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 131 Farragut Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 6ft   5997268.75573 2087384.8014900002 37.7114048037631 -122.451260209013 (37.7114048037631, -122.451260209013)
60597 35146 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 936 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/1998 12:00:00 AM 8   Permit Number 38676 6002023.61816 2088453.4827599998 37.714610274410205 -122.434902580586 (37.7146102744102, -122.434902580586)
137436 177005 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 362 Arleta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6009172.07817 2088408.58756 37.714890285531794 -122.410191328669 (37.7148902855318, -122.410191328669)
40455 177006 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 271 Teddy Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009831.15293 2088401.27476 37.7149071271443 -122.40791276406 (37.7149071271443, -122.40791276406)
31001 176999 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 906 Edinburgh St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 6ft   6001595.86635 2088796.01268 37.7155264893371 -122.436405562669 (37.7155264893371, -122.436405562669)
162804 207261 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 274 Arch St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5992740.415519999 2089036.58294 37.715679875902296 -122.467031197028 (37.7156798759023, -122.467031197028)
69603 207236 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 25 Median : Cutout 11 Tree 1 DPW 2     3 Width 0ft   5996258.071 2089000.15441 37.7157822655196 -122.45487001484301 (37.7157822655196, -122.454870014843)
76312 207237 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 33 Median : Cutout 11 Tree 1 DPW 2     15 Width 0ft   5996320.92755 2088998.85833 37.715782312278 -122.454652661299 (37.715782312278, -122.454652661299)
30605 207238 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 34 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   5996327.60089 2088999.83253 37.7157853699672 -122.454629665632 (37.7157853699672, -122.454629665632)
33929 207241 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 46 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   5996475.13618 2088997.3163599998 37.7157869221947 -122.45411953688601 (37.7157869221947, -122.454119536886)
24627 207239 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 43 Median : Cutout 11 Tree 1 DPW 2     13 Width 0ft   5996447.62341 2088998.17361 37.7157876983331 -122.45421469505199 (37.7157876983331, -122.454214695052)
65599 207240 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 44 Median : Cutout 11 Tree 1 DPW 2     14 Width 0ft   5996458.70543 2088998.7901400002 37.7157900266684 -122.45417643520001 (37.7157900266684, -122.4541764352)
133379 207242 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 53 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   5996583.3083 2088999.01444 37.7157977869175 -122.453745768776 (37.7157977869175, -122.453745768776)
37229 207260 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 282 Arch St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 10ft   5992744.11171 2089090.22365 37.7158273737034 -122.46702231894 (37.7158273737034, -122.46702231894)
59513 207233 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 422 Orizaba Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5994045.888719999 2089197.1437900001 37.7161960040241 -122.462530559657 (37.7161960040241, -122.462530559657)
150333 207234 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 422 Orizaba Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 10ft   5994046.18721 2089200.86778 37.716206246401896 -122.462529797908 (37.7162062464019, -122.462529797908)
46658 207264 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 319 Victoria St 1 : 4 Tree 1 Private 1     5 Width 3ft   5993222.99582 2089325.40947 37.716500767187 -122.465384161548 (37.716500767187, -122.465384161548)
58505 32742 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 27 Montana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/29/1996 12:00:00 AM 4 3x3 Permit Number 37125 5996375.5789 2089291.73885 37.7165896282782 -122.454484907162 (37.7165896282782, -122.454484907162)
187631 207235 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 44 Montana St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     5996222.23222 2089333.72162 37.716696107125394 -122.455017978523 (37.7166961071254, -122.455017978523)
183734 35133 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 805 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/1998 12:00:00 AM 6   Permit Number 38663 6001614.17085 2089254.80742 37.7167872776758 -122.43637511074101 (37.7167872776758, -122.436375110741)
63132 207265 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 542 Head St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   5993523.314809999 2089466.4912400001 37.7169054593937 -122.464356356062 (37.7169054593937, -122.464356356062)
178613 176988 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 184 Mount Vernon Ave 4 Side Yard : Yard 17 Tree 1 Private 1     12     5998975.21291 2089361.52774 37.7169300054919 -122.445504324886 (37.7169300054919, -122.445504324886)
174997 176989 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 184 Mount Vernon Ave 9 Side Yard : Yard 17 Tree 1 Private 1     14     5998947.7718 2089388.6360799999 37.717002872174504 -122.445601123393 (37.7170028721745, -122.445601123393)
48941 177000 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 759 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6002010.1952 2089376.96729 37.717145196164395 -122.435014983257 (37.7171451961644, -122.435014983257)
158840 35127 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 775 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/1998 12:00:00 AM 5   Permit Number 38661 6001730.34361 2089436.21425 37.71729198082 -122.43598653257799 (37.71729198082, -122.435986532578)
54071 207232 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 226 Thrift St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 6ft   5994766.53745 2089660.64097 37.7175101320775 -122.46007322780301 (37.7175101320775, -122.460073227803)
47768 35124 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/1998 12:00:00 AM 6   Permit Number 38659 6001796.31519 2089542.9326900002 37.717588753495 -122.43576613121701 (37.717588753495, -122.435766131217)
36484 207243 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 324 Lakeview Ave 1 : 4 Tree 1 Private 1     1 Width 3ft   5996808.75565 2089668.4523599998 37.7176488300194 -122.453014817795 (37.7176488300194, -122.453014817795)
100854 19333 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 325 Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   5993178.445205901 2089816.9668961002 37.7178478960527 -122.46557383978 (37.7178478960527, -122.46557383978)
156794 207268 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 321 Shields St 1 : 4 Tree 1 Private 1     4 Width 3ft   5993118.56975 2089825.8623400002 37.7178688671261 -122.46578144695299 (37.7178688671261, -122.465781446953)
171574 177017 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 345 Mount Vernon Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 2ft   5998458.65026 2089723.00143 37.7178930256111 -122.447315825681 (37.7178930256111, -122.447315825681)
158423 207267 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 800 Shields St 1 : 4 Tree 1 Private 1     4 Width 3ft   5991908.73686 2089873.18907 37.71792895264 -122.469966710089 (37.71792895264, -122.469966710089)
17282 27708 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 720 Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 2X3   5992097.16127 2089870.17428 37.717931565159795 -122.46931519623301 (37.7179315651598, -122.469315196233)
2094 252881 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 3536 Jennings St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 3ft   6013049.3063900005 2089480.54762 37.718050242412296 -122.39686501810199 (37.7180502424123, -122.396865018102)
154328 35122 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 723 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/1998 12:00:00 AM 7   Permit Number 38657 6001912.16427 2089726.3543900002 37.7180989685677 -122.435378807601 (37.7180989685677, -122.435378807601)
69001 176998 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 87 Seneca Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 1ft   6000227.51825 2089886.7347900001 37.7184435186304 -122.441213386902 (37.7184435186304, -122.441213386902)
131761 207244 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 246 Monticello St 1 : 4 Tree 1 Private 1     4 Width 3ft   5991705.04474 2090167.4544799998 37.7187251566245 -122.47069219949199 (37.7187251566245, -122.470692199492)
186557 207266 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 450 Bright St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   5993794.13591 2090181.7036599999 37.7188848681307 -122.463472140835 (37.7188848681307, -122.463472140835)
185209 207231 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 250 Faxon Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   5994770.3606900005 2090247.29491 37.7191211640843 -122.46010248996099 (37.7191211640843, -122.460102489961)
1779 251684 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 62 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5996557.0 2090306.0 37.719384955305294 -122.453931035382 (37.7193849553053, -122.453931035382)
1773 251685 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 66 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5996558.0 2090330.0 37.719450911009005 -122.453929311088 (37.719450911009, -122.453929311088)
130905 108372 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 575 Paris St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   1 3x3   6001633.30512 2090300.73335 37.7196602437916 -122.436383787393 (37.7196602437916, -122.436383787393)
51445 207262 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 510 Ramsell St 2 : 4 Tree 1 Private 1     4 Width 3ft   5993010.6580300005 2090589.3329599998 37.7199589473287 -122.466209899286 (37.7199589473287, -122.466209899286)
176364 207259 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 531 Arch St 1 : 4 Tree 1 Private 1     5 Width 3ft   5992719.90357 2090700.8696700002 37.720248420215 -122.467223034109 (37.720248420215, -122.467223034109)
186952 207258 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 532 Arch St 1 : 4 Tree 1 Private 1     7 Width 3ft   5992753.93277 2090721.89417 37.7203081126976 -122.46710693523998 (37.7203081126976, -122.46710693524)
137162 207228 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1018 Capitol Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5995061.38916 2090705.2918200002 37.720395449464796 -122.459129669002 (37.7203954494648, -122.459129669002)
62400 207257 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 545 Arch St 2 : 4 Tree 1 Private 1     8 Width 3ft   5992721.30272 2090787.38196 37.7204860426843 -122.467224484748 (37.7204860426843, -122.467224484748)
134488 207256 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 545 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992721.58386 2090800.7544 37.720522776379596 -122.467224484746 (37.7205227763796, -122.467224484746)
39672 207255 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 551 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992722.91506 2090824.1387 37.72058706082171 -122.467221582632 (37.7205870608217, -122.467221582632)
137140 207254 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 559 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992720.910730001 2090888.5643799999 37.720763842354 -122.467233192875 (37.720763842354, -122.467233192875)
171030 207253 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 556 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992754.265459999 2090897.47883 37.7207902446595 -122.46711854461 (37.7207902446595, -122.46711854461)
174314 207252 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 560 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992752.3271699995 2090925.11248 37.7208660080514 -122.467127252727 (37.7208660080514, -122.467127252727)
24966 177004 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 746 Olmstead St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6009463.77429 2090581.8029200002 37.720873831251104 -122.40933637376999 (37.7208738312511, -122.40933637377)
62912 177003 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 746 Olmstead St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6009476.70201 2090586.0760400002 37.720886288652004 -122.409291987754 (37.720886288652, -122.409291987754)
138093 207251 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 567 Arch St 1 : 4 Tree 1 Private 1     2 Width 3ft   5992723.294480001 2090942.0276900001 37.720910777190795 -122.46722883836 (37.7209107771908, -122.46722883836)
48128 207250 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 571 Arch St 1 : 4 Tree 1 Private 1     5 Width 3ft   5992722.93824 2090965.0292099998 37.7209739131985 -122.467231741345 (37.7209739131985, -122.467231741345)
178299 207249 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 581 Arch St 1 : 4 Tree 1 Private 1     7 Width 3ft   5992725.89958 2091026.00542 37.7211415099655 -122.467225936253 (37.7211415099655, -122.467225936253)
24738 207248 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 574 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992756.55156 2091026.1972 37.7211438059241 -122.46711999608401 (37.7211438059241, -122.467119996084)
166192 207245 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 495 Ralston St 3 : 4 Tree 1 Private 1     4 Width 3ft   5992206.61176 2091125.8340200002 37.7213856246322 -122.469028209083 (37.7213856246322, -122.469028209083)
136134 207263 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 582 Ramsell St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 10ft   5993025.1293 2091125.2182900002 37.7214311932731 -122.46619880075899 (37.7214311932731, -122.466198800759)
187054 207246 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 495 Ralston St 2 : 4 Tree 1 Private 1     4 Width 3ft   5992206.82998 2091154.32928 37.7214638782474 -122.469029527495 (37.7214638782474, -122.469029527495)
59008 38198 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 885 Girard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/05/2000 12:00:00 AM 5   Permit Number 40325 6011564.90625 2090771.94385 37.721513417393496 -122.402086713936 (37.7215134173935, -122.402086713936)
156004 207247 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 495 Ralston St 1 : 4 Tree 1 Private 1     4 Width 3ft   5992207.674790001 2091176.35111 37.721524393612 -122.46902820910299 (37.721524393612, -122.469028209103)
37320 207230 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 437 Holloway Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5995450.98225 2091203.60917 37.7217860999295 -122.457819021351 (37.7217860999295, -122.457819021351)
56436 207226 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 224 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5995369.52282 2091446.6873400002 37.722448854419795 -122.45811818710399 (37.7224488544198, -122.458118187104)
155074 207225 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 272 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996551.89898 2091549.3096 37.7227984982343 -122.454038414459 (37.7227984982343, -122.454038414459)
1524 251544 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 863X Ocean Ave   Side Yard : Yard 17 Tree 1 Private 1       3x3   5997430.0 2091537.0 37.722815009603295 -122.451002133856 (37.7228150096033, -122.451002133856)
186793 177018 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 401 Ocean Ave 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 8ft   5999065.383280001 2091517.8288599998 37.722855860592105 -122.44534760363399 (37.7228558605921, -122.445347603634)
67090 177002 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 721 Goettingen St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 4ft   6010761.087830001 2091324.0286400001 37.7229844303778 -122.404904160394 (37.7229844303778, -122.404904160394)
162797 207229 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1162 Capitol Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 1ft   5995089.6840699995 2091648.0085099998 37.7229855509323 -122.459100089412 (37.7229855509323, -122.459100089412)
172685 95711 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 277 Athens St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 6 3x3 Permit Number 767467 6004408.66119 2091673.84489 37.7235878160995 -122.426888112994 (37.7235878160995, -122.426888112994)
60961 43315 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 259 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/13/2000 12:00:00 AM 4   Permit Number 43078 6004448.9414 2091752.36291 37.72380568677679 -122.426754460261 (37.7238056867768, -122.426754460261)
158267 207227 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 314 Ashton Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 2ft   5994211.43434 2092004.54355 37.7239139822334 -122.46216184121799 (37.7239139822334, -122.462161841218)
70286 42982 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 469 Princeton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2000 12:00:00 AM 7   Permit Number 42866 6008125.46012 2091747.89633 37.724000603132 -122.414044988394 (37.724000603132, -122.414044988394)
161710 43171 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 369 Madison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 8   Permit Number 42980 6005855.02005 2091989.32837 37.7245357402195 -122.42191069731501 (37.7245357402195, -122.421910697315)
188791 177020 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 235 Vienna St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6004327.3137300005 2092022.6110200002 37.724540851055 -122.42719414780599 (37.724540851055, -122.427194147806)
133337 177023 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1628 Burrows St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6006643.54009 2092125.7831400002 37.7249548539585 -122.419194556805 (37.7249548539585, -122.419194556805)
172270 177022 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1628 Burrows St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6006681.726369999 2092138.2756599998 37.724991306183796 -122.419063436538 (37.7249913061838, -122.419063436538)
133267 99298 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 50 Norton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/01/2012 12:00:00 AM 4 3x3 Permit Number 768888 6001844.0532599995 2092273.6485400002 37.7250893979513 -122.435796391592 (37.7250893979513, -122.435796391592)
68271 177021 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1538 Burrows St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 4ft   6006775.37088 2092172.2563099999 37.72508988269 -122.41874212587 (37.72508988269, -122.41874212587)
43818 68271 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 432 Holyoke St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2014 12:00:00 AM 8   Permit Number 771022 6009763.0481199995 2092384.22175 37.7258396600504 -122.408428941659 (37.7258396600504, -122.408428941659)
132193 207162 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 509 Miramar Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5995343.73993 2092740.9516 37.7260011126479 -122.45830094463699 (37.7260011126479, -122.458300944637)
131833 207161 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 509 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5995344.03835 2092755.21065 37.726040281721296 -122.45830094463498 (37.7260402817213, -122.458300944635)
154723 43162 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 221 Madison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 5   Permit Number 42972 6005660.57006 2092632.04042 37.726289518943 -122.42262853710301 (37.726289518943, -122.422628537103)
168579 43185 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 62 Valmar Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 7   Permit Number 42987 6005330.72095 2092724.62519 37.7265251215375 -122.42377539032101 (37.7265251215375, -122.423775390321)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 367.148ms · Data source: data.sfgov.org