Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, 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) |
JSON shape: default, array, newline-delimited
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");