Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, PlotSize
DBH ✖
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
59888 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
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");