Street_Tree_List

Data source: data.sfgov.org

505 rows where qSpecies = 27 sorted by SiteOrder descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
133379 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)
33929 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)
65599 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)
138075 138075 227702 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1201 San Jose Ave 44 Front Yard : Yard 7 Tree 1 Private 1     1     6004467.63219 2096063.7098700001 37.7356447417011 -122.426996770882 (37.7356447417011, -122.426996770882)
24627 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)
166542 166542 227701 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1201 San Jose Ave 36 Front Yard : Yard 7 Tree 1 Private 1     1     6004423.64254 2096032.0928 37.7355554408308 -122.427146608748 (37.7355554408308, -122.427146608748)
75923 75923 226602 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5200x Diamond Heights Blvd 35 Median : Yard 3 Tree 1 DPW 2     11     6001604.7772 2098884.15576 37.7432267298424 -122.437096613431 (37.7432267298424, -122.437096613431)
30605 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)
76312 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)
69603 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)
180537 180537 226627 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 310 Liberty St 25 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6004024.53424 2103933.71517 37.7572288881251 -122.42908968844401 (37.7572288881251, -122.429089688444)
186793 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)
25933 25933 207216 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 351 Judson Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 1ft   5997629.9182 2093521.5482700001 37.7282755556595 -122.450454058505 (37.7282755556595, -122.450454058505)
143370 143370 5001 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 18 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
67877 67877 207215 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 351 Judson Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5997615.0933300005 2093521.35715 37.7282741823893 -122.450505294682 (37.7282741823893, -122.450505294682)
49999 49999 207214 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 351 Judson Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5997600.50896 2093520.6605599998 37.7282714349614 -122.450555663017 (37.7282714349614, -122.450555663017)
72391 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)
80194 80194 4999 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 16 Median : Cutout 11 Tree 1 DPW 2     7 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
95563 95563 4998 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 15 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
158570 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)
169893 169893 207213 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 351 Judson Ave 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   5997585.68903 2093520.71926 37.728270747876394 -122.45060690011499 (37.7282707478764, -122.450606900115)
60108 60108 207212 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 351 Judson Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5997571.11535 2093520.52293 37.728269374612495 -122.450657267541 (37.7282693746125, -122.450657267541)
23659 23659 207211 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 351 Judson Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   5997557.05916 2093521.06587 37.7282700608095 -122.450705899268 (37.7282700608095, -122.450705899268)
25493 25493 207183 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5995337.35676 2098242.98475 37.7411079873364 -122.458721155571 (37.7411079873364, -122.458721155571)
39601 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)
110729 110729 4995 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 12 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
129805 129805 226626 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 310 Liberty St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   6004198.11867 2103939.92108 37.757255752658295 -122.42848980825899 (37.7572557526583, -122.428489808259)
97805 97805 4994 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 11 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
164704 164704 207182 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5995335.09015 2098246.93081 37.7411186919637 -122.458729278246 (37.7411186919637, -122.458729278246)
29724 29724 207328 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 400x Marietta Dr 10 Median : Cutout 11 Tree 1 DPW 2     5 Width 3ft   5999485.75789 2097034.69989 37.738027887567796 -122.444290723035 (37.7380278875678, -122.444290723035)
33843 33843 177016 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 81 Lamartine St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6002658.8277900005 2094369.8725599998 37.7308914046921 -122.433129511441 (37.7308914046921, -122.433129511441)
57399 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)
63970 63970 227703 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 200 Kingston St 10 Front Yard : Yard 7 Tree 1 Private 1     10 Width 8ft   6006269.2438199995 2098023.2428599996 37.7411268910989 -122.420906974789 (37.7411268910989, -122.420906974789)
99734 99734 4993 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 10 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
146496 146496 207181 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5995335.301969999 2098244.58715 37.7411122690279 -122.458728376224 (37.7411122690279, -122.458728376224)
161495 161495 226597 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1 Newburg St 10 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   6002589.21192 2100000.55478 37.746348008668 -122.433772476325 (37.746348008668, -122.433772476325)
94015 94015 4992 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 9 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
129828 129828 226614 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 322 Elsie St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006361.987980001 2097015.1421299998 37.738364099132795 -122.42051475707399 (37.7383640991328, -122.420514757074)
154080 154080 207315 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1570 07th Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5994029.69886 2104725.63145 37.7588324395785 -122.463712925326 (37.7588324395785, -122.463712925326)
174436 174436 207180 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5995332.94317 2098244.11673 37.7411108417945 -122.458736498001 (37.7411108417945, -122.458736498001)
174997 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)
182650 182650 207192 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 212 Hearst Ave 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     5999965.474330001 2094393.0504400001 37.730801895176896 -122.442442510114 (37.7308018951769, -122.442442510114)
26959 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)
57155 57155 207179 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5995334.19857 2098241.75122 37.741104418845794 -122.458731986098 (37.7411044188458, -122.458731986098)
57932 57932 226588 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 350 Treat Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008565.829469999 2106391.50298 37.7642334332393 -122.41355789668002 (37.7642334332393, -122.41355789668)
88236 88236 4991 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 8 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
152419 152419 207191 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 212 Hearst Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5999968.7786 2094392.65203 37.7308009895755 -122.442431058168 (37.7308009895755, -122.442431058168)
35498 35498 129498 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 855 Chestnut St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 6ft   6007778.02269 2120584.45961 37.803159586216395 -122.417288546245 (37.8031595862164, -122.417288546245)
47592 47592 207190 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 212 Hearst Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     5999972.7522599995 2094392.56954 37.7308009895699 -122.44241731471399 (37.7308009895699, -122.442417314714)
102463 102463 87366 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 3401 Taraval St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
130565 130565 207178 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5995329.77436 2098242.36362 37.7411058460538 -122.45874732764 (37.7411058460538, -122.45874732764)
172280 172280 207170 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 100 Vista Verde Ct 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 10ft   5999209.0212900005 2096067.6439599998 37.7353567886676 -122.44517802836799 (37.7353567886676, -122.445178028368)
173249 173249 117964 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 4545 Anza St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5984595.13139 2111732.58098 37.7775233740539 -122.496858681509 (37.7775233740539, -122.496858681509)
176378 176378 207194 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 312 Hearst Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5999314.16696 2094391.4042099998 37.73076022959339 -122.44469405728901 (37.7307602295934, -122.444694057289)
21729 21729 29577 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 400X Junipero Serra Blvd 6 Median : Cutout 11 Tree 1 DPW 2   04/01/2007 12:00:00 AM 3 3X3   5991369.68485 2094223.17677 37.7298417654626 -122.47214686011002 (37.7298417654626, -122.47214686011)
23484 23484 226621 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 2498 Harrison St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6008827.83459 2103955.23814 37.7575587153899 -122.412479469249 (37.7575587153899, -122.412479469249)
25168 25168 118098 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 3619 Balboa St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5984331.597680001 2111046.0676700003 37.7756229611607 -122.497719616092 (37.7756229611607, -122.497719616092)
71533 71533 117965 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 4545 Anza St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5984581.6879 2111733.75019 37.7775257966351 -122.496905272636 (37.7775257966351, -122.496905272636)
76247 76247 207177 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5995331.55155 2098239.9871900002 37.7410994231129 -122.458741010797 (37.7410994231129, -122.458741010797)
138958 138958 87365 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 3401 Taraval St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
149202 149202 207311 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5996623.9577 2093958.7514099998 37.729418384438894 -122.453963248219 (37.7294183844389, -122.453963248219)
149732 149732 191412 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1998 Revere Ave 6 Side Yard : Yard 17 Tree 1 Private 1     15     6013024.42365 2095944.26783 37.7357969159791 -122.39740407446001 (37.7357969159791, -122.39740407446)
151529 151529 118577 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 7900 Geary Blvd 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   5982502.68903 2112449.1000200002 37.7793678960656 -122.504150104536 (37.7793678960656, -122.504150104536)
162033 162033 129497 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 855 Chestnut St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 6ft   6007750.73846 2120580.85704 37.803148159410604 -122.417382708871 (37.8031481594106, -122.417382708871)
166521 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)
168553 168553 191409 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1201 20th St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 6ft   6014316.155809999 2104772.8809 37.760110260198495 -122.39355571261999 (37.7601102601985, -122.39355571262)
184811 184811 177015 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 81 Lamartine St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6002665.86181 2094349.24813 37.730835173699106 -122.433103720676 (37.7308351736991, -122.433103720676)
11989 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            
24966 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)
26310 26310 139038 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1501 BRODERICK ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6000648.2136 2113864.1729 37.7843037348812 -122.441478860369 (37.7843037348812, -122.441478860369)
27070 27070 118586 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 110 Point Lobos Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 4ft   5982415.39383 2112637.72046 37.779880658188794 -122.50446606808501 (37.7798806581888, -122.504466068085)
52824 52824 207200 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 580 Hearst Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997508.4902099995 2094418.65818 37.7307318559937 -122.45093849993401 (37.7307318559937, -122.450938499934)
56956 56956 207310 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5996630.650640001 2093957.49673 37.7294153231391 -122.453940019643 (37.7294153231391, -122.453940019643)
76282 76282 226604 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 495 Collingwood St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 2ft   6002163.6712 2103050.21539 37.7546974962127 -122.435462066843 (37.7546974962127, -122.435462066843)
89568 89568 87364 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 3401 Taraval St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
109500 109500 116713 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1400 Baker St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6000212.5605 2113848.1665 37.78423495653821 -122.44298491286699 (37.7842349565382, -122.442984912867)
117656 117656 117966 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 4545 Anza St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5984567.33243 2111733.70358 37.7775248274666 -122.496954928801 (37.7775248274666, -122.496954928801)
133963 133963 184221 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 3435 Kirkham St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5984145.6537 2104934.9816 37.7588327531435 -122.49791146613899 (37.7588327531435, -122.497911466139)
136022 136022 118580 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 7900 Geary Blvd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   5982502.32297 2112445.62468 37.7793583322752 -122.504151113367 (37.7793583322752, -122.504151113367)
147919 147919 226594 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 4301 26th St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 8ft   6001878.86211 2100572.13278 37.747877092657795 -122.43626967691799 (37.7478770926578, -122.436269676918)
151636 151636 207176 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5995327.39898 2098241.1137 37.741102277551896 -122.45875545032301 (37.7411022775519, -122.458755450323)
158363 158363 207189 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 212 Hearst Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5999987.6528199995 2094392.26023 37.7308009895722 -122.442365779062 (37.7308009895722, -122.442365779062)
163757 163757 183296 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1278 42nd Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5983073.0612 2106475.4841 37.7629995961897 -122.50173490129801 (37.7629995961897, -122.501734901298)
185686 185686 139032 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1535 Broderick St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6000626.6398 2114005.4469999997 37.784690408082 -122.441563639416 (37.784690408082, -122.441563639416)
61 61 226596 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1 Newburg St 4 Sidewalk: Property side : Pot 6 Tree 1 Private 1     4 Width 4ft   6002583.45295 2099992.19698 37.746324733318 -122.433791792881 (37.746324733318, -122.433791792881)
29485 29485 139037 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1501 BRODERICK ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6000646.8218 2113873.9159999997 37.7843304076342 -122.441484374883 (37.7843304076342, -122.441484374883)
33808 33808 207309 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5996632.84291 2093955.22047 37.72940919877011 -122.45393227647699 (37.7294091987701, -122.453932276477)
34662 34662 117967 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 4545 Anza St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5984550.3085 2111733.18458 37.7775224048599 -122.497013781042 (37.7775224048599, -122.497013781042)
42650 42650 207339 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 436 Joost Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   5999175.62485 2094995.5474599998 37.7324111582276 -122.445216436593 (37.7324111582276, -122.445216436593)
44643 44643 177014 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 81 Lamartine St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6002672.79218 2094323.6061200001 37.7307651596849 -122.433077929925 (37.7307651596849, -122.433077929925)
44944 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)
53679 53679 207188 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 212 Hearst Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     5999995.26886 2094392.10213 37.7308009895535 -122.442339437931 (37.7308009895535, -122.442339437931)
55280 55280 184220 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 3437 Kirkham St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5984130.1355 2104934.7045 37.758831082518896 -122.49796511397498 (37.7588310825189, -122.497965113975)
58147 58147 207303 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 59 Hazelwood Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5996585.5854400005 2094033.89672 37.7296225152507 -122.45410132920601 (37.7296225152507, -122.454101329206)
58753 58753 185611 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 2241 Quintara St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5986448.3245 2100932.1027 37.747976665787895 -122.489653506406 (37.7479766657879, -122.489653506406)
59479 59479 207337 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 114 Melrose Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 10ft   5999331.40158 2095537.8442099998 37.7339090681372 -122.44471684701901 (37.7339090681372, -122.444716847019)
62912 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)
63394 63394 119482 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 426 33rd Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5985642.69106 2113025.08426 37.781133543390204 -122.49333012331499 (37.7811335433902, -122.493330123315)
70570 70570 207314 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1570 07th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5994021.19813 2104903.51705 37.759320377550395 -122.46375523571999 (37.7593203775504, -122.46375523572)
73346 73346 226593 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 4301 26th St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6001851.9880099995 2100572.11343 37.7478755125637 -122.43636260477301 (37.7478755125637, -122.436362604773)

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 373.101ms · Data source: data.sfgov.org