trees
502 rows where qSpecies_id = 157
This data as json, CSV (advanced)
| rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 955 | 207211 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 351 Judson Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5997557.05916 | 2093521.06587 | 37.7282700608095 | -122.450705899268 | (37.7282700608095, -122.450705899268) | 9 | 7 | 4 | 28861 | 40 | |||
| 1233 | 99298 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 50 Norton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 4 | 3x3 | Permit Number 768888 | 6001844.05326 | 2092273.64854 | 37.7250893979513 | -122.435796391592 | (37.7250893979513, -122.435796391592) | 9 | 7 | 6 | 28861 | 25 | |
| 1260 | 78418 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2987 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988809.97189 | 2095328.51144 | 37.732728266388 | -122.481076880696 | (37.732728266388, -122.481076880696) | 1 | 8 | 4 | 64 | 35 | |||
| 1680 | 38198 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 885 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 5 | Permit Number 40325 | 6011564.90625 | 2090771.94385 | 37.7215134173935 | -122.402086713936 | (37.7215134173935, -122.402086713936) | 10 | 3 | 7 | 309 | 28 | |
| 2125 | 70374 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1494 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5983124.8306 | 2104978.8403 | 37.7588932768889 | -122.501445132559 | (37.7588932768889, -122.501445132559) | 1 | 8 | 3 | 56 | 35 | |||
| 2759 | 207270 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994256.24514 | 2105719.06013 | 37.7615731891695 | -122.463001505824 | (37.7615731891695, -122.463001505824) | 1 | 5 | 11 | 56 | 12 | |||
| 2960 | 71589 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 177 Goethe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5994699.45406 | 2086647.11862 | 37.7092318519263 | -122.460086907391 | (37.7092318519263, -122.460086907391) | 9 | 8 | 6 | 28861 | 25 | |||
| 3142 | 207280 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 595 Darien Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993435.14458 | 2094919.26873 | 37.7318723753133 | -122.465056923443 | (37.7318723753133, -122.465056923443) | 9 | 8 | 4 | 59 | 40 | |||
| 3903 | 46769 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 54 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 6 | Permit Number 44865 | 6002394.40471 | 2093228.74941 | 37.7277431363295 | -122.433962127146 | (37.7277431363295, -122.433962127146) | 9 | 7 | 6 | 28861 | 25 | |
| 4339 | 37181 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2519 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | Permit Number 785239 | 6001865.38269 | 2116985.03667 | 37.7929420916518 | -122.437491453568 | (37.7929420916518, -122.437491453568) | 13 | 6 | 1 | 29490 | 27 | ||
| 4542 | 31195 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 260 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/1995 12:00:00 AM | 6 | Permit Number 34888 | 5992024.42182 | 2086737.21442 | 37.7093250109181 | -122.469338707216 | (37.7093250109181, -122.469338707216) | 9 | 8 | 4 | 64 | 24 | ||
| 5146 | 37433 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1419 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1998 12:00:00 AM | 6 | Permit Number 39907 | 5991189.91551 | 2110613.34906 | 37.7748344845766 | -122.473963672883 | (37.7748344845766, -122.473963672883) | 11 | 6 | 2 | 54 | 26 | ||
| 5374 | 182869 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1847 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5988126.7611 | 2102732.0567 | 37.753016709321 | -122.483981583047 | (37.753016709321, -122.483981583047) | 1 | 8 | 3 | 56 | 35 | |||
| 5698 | 207190 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 212 Hearst Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5999972.75226 | 2094392.56954 | 37.7308009895699 | -122.442417314714 | (37.7308009895699, -122.442417314714) | 9 | 7 | 4 | 63 | 40 | ||||
| 6313 | 72284 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 828 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5982951.02608 | 2110145.89741 | 37.7730703284814 | -122.502428636033 | (37.7730703284814, -122.502428636033) | 11 | 6 | 2 | 55 | 26 | |||
| 6887 | 129495 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1136 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 7ft | 6007480.35855 | 2119354.0245 | 37.7997643702969 | -122.418231335218 | (37.7997643702969, -122.418231335218) | 5 | 1 | 1 | 28858 | 32 | |||
| 7256 | 176998 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 87 Seneca Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6000227.51825 | 2089886.73479 | 37.7184435186304 | -122.441213386902 | (37.7184435186304, -122.441213386902) | 9 | 7 | 6 | 28861 | 25 | |||
| 7646 | 78478 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2987 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988808.95801 | 2095345.98814 | 37.7327761939684 | -122.481081665112 | (37.7327761939684, -122.481081665112) | 1 | 8 | 4 | 64 | 35 | |||
| 8069 | 207154 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 606 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990999.63988 | 2099781.66866 | 37.7450825456271 | -122.473831489033 | (37.7450825456271, -122.473831489033) | 1 | 8 | 4 | 29491 | 40 | |||
| 8925 | 118539 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 8250 Geary Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5981337.09939 | 2112389.25007 | 37.7791349496719 | -122.508177852958 | (37.7791349496719, -122.508177852958) | 11 | 6 | 2 | 55 | 26 | ||||
| 9002 | 207358 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 171 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5998941.87178 | 2093762.17883 | 37.7290112721346 | -122.445935896945 | (37.7290112721346, -122.445935896945) | 9 | 7 | 4 | 28861 | 40 | ||||
| 9253 | 62489 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 25 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1986 12:00:00 AM | 8 | Permit Number 22660 | 6000933.61072 | 2092903.74949 | 37.7267677523056 | -122.438988823884 | (37.7267677523056, -122.438988823884) | 9 | 7 | 6 | 28861 | 25 | |
| 10023 | 256755 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 212 Country Club Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 5984146.79424 | 2095075.85796 | 37.7317623621263 | -122.497179756321 | (37.7317623621263, -122.497179756321) | 1 | 8 | 4 | 64 | 35 | |||
| 10425 | 117858 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 600 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5983830.55841 | 2111665.32715 | 37.7772938846057 | -122.499498581311 | (37.7772938846057, -122.499498581311) | 11 | 6 | 2 | 55 | 26 | |||
| 10783 | 26837 | Permitted Site 7 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1100X Duncan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 2x2 | |||||||||||||
| 13108 | 207243 | Permitted Site 7 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 324 Lakeview Ave | 1 | : | Tree | Private 2 | 08/19/2015 12:00:00 AM | 1 | Width 3ft | Permit Number 776404 | 5996808.75565 | 2089668.45236 | 37.7176488300194 | -122.453014817795 | (37.7176488300194, -122.453014817795) | 9 | 8 | 6 | 28861 | 24 | |
| 14113 | 250337 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 21 25th Ave North | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5987995.71435 | 2115876.11718 | 37.7890990187437 | -122.485399212222 | (37.7890990187437, -122.485399212222) | 11 | 6 | 1 | 55 | 33 | |||
| 15468 | 70454 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2631 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5982726.9666 | 2097193.7529 | 37.7374942155975 | -122.502244984058 | (37.7374942155975, -122.502244984058) | 1 | 8 | 3 | 29491 | 35 | |||
| 16007 | 68284 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 665 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2012 12:00:00 AM | 2 | Permit Number 769020 | 6009000.66847 | 2092983.87364 | 37.727443453448 | -122.411106781849 | (37.727443453448, -122.411106781849) | 9 | 3 | 7 | 309 | 28 | |
| 16327 | 207171 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 240 Stillings Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5999241.01629 | 2095793.34102 | 37.7346054437908 | -122.445047696791 | (37.7346054437908, -122.445047696791) | 9 | 7 | 4 | 59 | 40 | |||
| 17444 | 70393 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 63 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6005472.78201 | 2093254.06061 | 37.7279868534853 | -122.42332190989 | (37.7279868534853, -122.42332190989) | 9 | 7 | 7 | 309 | 5 | |||
| 18538 | 120006 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 658 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5986941.43179 | 2111450.92852 | 37.7768872385676 | -122.488721446125 | (37.7768872385676, -122.488721446125) | 11 | 6 | 2 | 55 | 26 | |||
| 18956 | 207205 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 243 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5997427.42425 | 2094320.33561 | 37.7304572443933 | -122.451211668105 | (37.7304572443933, -122.451211668105) | 9 | 7 | 4 | 28861 | 40 | |||
| 19101 | 71605 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 178 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5994512.31694 | 2086511.3564 | 37.7088483153534 | -122.46072384594 | (37.7088483153534, -122.46072384594) | 9 | 8 | 6 | 28861 | 25 | |||
| 19277 | 207239 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1x Minerva St | 43 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 5996447.62341 | 2088998.17361 | 37.7157876983331 | -122.454214695052 | (37.7157876983331, -122.454214695052) | 9 | 8 | 6 | 28861 | 24 | |||
| 19916 | 207288 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 80 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993609.88258 | 2093413.56437 | 37.7277481554518 | -122.464343543436 | (37.7277481554518, -122.464343543436) | 9 | 8 | 4 | 59 | 40 | |||
| 20239 | 35146 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 936 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 8 | Permit Number 38676 | 6002023.61816 | 2088453.48276 | 37.7146102744102 | -122.434902580586 | (37.7146102744102, -122.434902580586) | 9 | 7 | 6 | 28861 | 5 | |
| 20421 | 226595 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 880 Douglass St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6001269.3073 | 2101283.04072 | 37.7497944238848 | -122.438428410468 | (37.7497944238848, -122.438428410468) | 2 | 4 | 5 | 28862 | 22 | |||
| 20636 | 185261 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2177 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986220.9115 | 2097517.551 | 37.7385879417998 | -122.490188749104 | (37.7385879417998, -122.490188749104) | 1 | 8 | 3 | 29491 | 35 | |||
| 20878 | 207354 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 236 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5996818.09015 | 2094943.97322 | 37.732134696764 | -122.453363219655 | (37.732134696764, -122.453363219655) | 9 | 7 | 4 | 59 | 40 | |||
| 21849 | 207259 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 531 Arch St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992719.90357 | 2090700.86967 | 37.720248420215 | -122.467223034109 | (37.720248420215, -122.467223034109) | 9 | 8 | 6 | 64 | 24 | |||
| 22184 | 177004 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 746 Olmstead St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009463.77429 | 2090581.80292 | 37.7208738312511 | -122.40933637377 | (37.7208738312511, -122.40933637377) | 9 | 3 | 7 | 309 | 28 | |||
| 22290 | 207208 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 101 Foerster St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5998074.52147 | 2093832.40927 | 37.7291545431359 | -122.448939436512 | (37.7291545431359, -122.448939436512) | 9 | 7 | 4 | 28861 | 40 | |||
| 22370 | 226631 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002644.82708 | 2096800.89378 | 37.7375656387439 | -122.433351563933 | (37.7375656387439, -122.433351563933) | 2 | 7 | 5 | 63 | 7 | |||
| 23705 | 50302 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 59 Inverness Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2004 12:00:00 AM | 4 | Permit Number 47012 | 5988294.3182 | 2095513.16989 | 37.7332053009864 | -122.482873130798 | (37.7332053009864, -122.482873130798) | 1 | 8 | 4 | 64 | 35 | |
| 25158 | 177011 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 78 Lamartine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002637.06105 | 2094341.00901 | 37.73081091718 | -122.433202700959 | (37.73081091718, -122.433202700959) | 9 | 7 | 5 | 28861 | 25 | |||
| 25723 | 40627 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1118 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | 7 | Permit Number 41628 | 6012181.11201 | 2103196.50544 | 37.755663016446 | -122.40082910469 | (37.755663016446, -122.40082910469) | 10 | 3 | 8 | 28856 | 29 | ||
| 26174 | 177007 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 216 Saint Charles Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992028.26989 | 2086999.54978 | 37.7100455432512 | -122.469344489883 | (37.7100455432512, -122.469344489883) | 9 | 8 | 4 | 64 | 24 | |||
| 26252 | 207306 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 40 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996625.80083 | 2093939.75542 | 37.7293663316726 | -122.453955505049 | (37.7293663316726, -122.453955505049) | 9 | 7 | 4 | 28861 | 40 | |||
| 27415 | 32742 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 27 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | 4 | 3x3 | Permit Number 37125 | 5996375.5789 | 2089291.73885 | 37.7165896282782 | -122.454484907162 | (37.7165896282782, -122.454484907162) | 9 | 8 | 6 | 28861 | 24 | |
| 27613 | 207320 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 20 Woodside Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995605.62076 | 2100279.71012 | 37.746715745033 | -122.457940956827 | (37.746715745033, -122.457940956827) | 1 | 5 | 4 | 59 | 40 | |||
| 27688 | 177012 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 78 Lamartine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002642.0398 | 2094328.25695 | 37.7307761853525 | -122.433184577831 | (37.7307761853525, -122.433184577831) | 9 | 7 | 5 | 28861 | 25 | |||
| 27889 | 34479 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 756 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 6 | 2x3 | Permit Number 38206 | 6009344.31019 | 2119468.83873 | 37.800184363566 | -122.411789466237 | (37.800184363566, -122.411789466237) | 3 | 1 | 10 | 308 | 4 |
| 28085 | 207357 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 219 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998605.99602 | 2093779.39497 | 37.7290393588582 | -122.447098278772 | (37.7290393588582, -122.447098278772) | 9 | 7 | 4 | 28861 | 40 | |||
| 28224 | 207319 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 20 Woodside Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995627.90301 | 2100275.99182 | 37.7467068156796 | -122.457863638513 | (37.7467068156796, -122.457863638513) | 1 | 5 | 4 | 59 | 40 | |||
| 28450 | 207212 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 351 Judson Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5997571.11535 | 2093520.52293 | 37.7282693746125 | -122.450657267541 | (37.7282693746125, -122.450657267541) | 9 | 7 | 4 | 28861 | 40 | |||
| 28676 | 27708 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 720 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X3 | 5992097.16127 | 2089870.17428 | 37.7179315651598 | -122.469315196233 | (37.7179315651598, -122.469315196233) | 9 | 8 | 6 | 64 | 24 | |||
| 29088 | 207167 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 520 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5996922.66578 | 2093634.6954 | 37.7285457263925 | -122.452907210304 | (37.7285457263925, -122.452907210304) | 9 | 7 | 4 | 28861 | 40 | |||
| 29191 | 207241 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1x Minerva St | 46 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 5996475.13618 | 2088997.31636 | 37.7157869221947 | -122.454119536886 | (37.7157869221947, -122.454119536886) | 9 | 8 | 6 | 28861 | 24 | |||
| 30029 | 207238 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1x Minerva St | 34 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 5996327.60089 | 2088999.83253 | 37.7157853699672 | -122.454629665632 | (37.7157853699672, -122.454629665632) | 9 | 8 | 6 | 28861 | 24 | |||
| 30034 | 207184 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 300 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5997470.84744 | 2094454.31526 | 37.7308276067915 | -122.451071206573 | (37.7308276067915, -122.451071206573) | 9 | 7 | 4 | 59 | 40 | |||
| 30087 | 207222 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 147 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5998739.60918 | 2093444.36182 | 37.728127069498 | -122.44661227435 | (37.728127069498, -122.44661227435) | 9 | 7 | 4 | 28861 | 40 | |||
| 30140 | 117857 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 600 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5983829.36907 | 2111677.06691 | 37.7773260488023 | -122.499503563368 | (37.7773260488023, -122.499503563368) | 11 | 6 | 2 | 55 | 26 | |||
| 30566 | 226616 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2 Appleton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005523.88104 | 2097105.4034 | 37.7385646686269 | -122.423418939539 | (37.7385646686269, -122.423418939539) | 2 | 7 | 7 | 28859 | 2 | |||
| 31030 | 207328 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 400x Marietta Dr | 10 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 5999485.75789 | 2097034.69989 | 37.7380278875678 | -122.444290723035 | (37.7380278875678, -122.444290723035) | 9 | 7 | 4 | 59 | 40 | |||
| 33099 | 207299 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 111 Valdez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996293.5704 | 2094296.85345 | 37.7303277824929 | -122.455129844261 | (37.7303277824929, -122.455129844261) | 9 | 7 | 4 | 28861 | 40 | |||
| 33341 | 207327 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 48 Gaviota Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5998437.39477 | 2097397.71392 | 37.7389647688951 | -122.447941546984 | (37.7389647688951, -122.447941546984) | 9 | 7 | 4 | 59 | 40 | |||
| 33343 | 207204 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 655 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5997746.28105 | 2094978.11771 | 37.7322816091084 | -122.450156733641 | (37.7322816091084, -122.450156733641) | 9 | 7 | 4 | 59 | 40 | |||
| 33602 | 177010 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 78 Lamartine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002632.11132 | 2094355.16557 | 37.7308495070888 | -122.433220824095 | (37.7308495070888, -122.433220824095) | 9 | 7 | 5 | 28861 | 25 | |||
| 33795 | 67405 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 774 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1992 12:00:00 AM | 9 | Permit Number 30904 | 5989782.793 | 2110097.20217 | 37.7733356814764 | -122.478793391379 | (37.7733356814764, -122.478793391379) | 11 | 6 | 2 | 55 | 26 | |
| 33828 | 207294 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1414 Plymouth Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5995890.40227 | 2093395.38912 | 37.7278294397631 | -122.456458481978 | (37.7278294397631, -122.456458481978) | 9 | 7 | 4 | 28861 | 40 | |||
| 33891 | 207215 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 351 Judson Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5997615.09333 | 2093521.35715 | 37.7282741823893 | -122.450505294682 | (37.7282741823893, -122.450505294682) | 9 | 7 | 4 | 28861 | 40 | |||
| 34210 | 207295 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 217 Colon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5996039.75572 | 2094297.69733 | 37.7303155346371 | -122.45600737215 | (37.7303155346371, -122.45600737215) | 9 | 7 | 4 | 28861 | 40 | |||
| 34253 | 185771 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1325 Ortega St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5989890.4756 | 2102411.1303 | 37.7522380517247 | -122.477858926104 | (37.7522380517247, -122.477858926104) | 1 | 8 | 3 | 29491 | 35 | |||
| 34764 | 207350 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 618 Mangels Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997300.95019 | 2095282.96772 | 37.7330931600175 | -122.451718319154 | (37.7330931600175, -122.451718319154) | 9 | 7 | 4 | 59 | 40 | |||
| 34788 | 207274 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 315 Dorantes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993100.15501 | 2099667.06703 | 37.7448893164068 | -122.466560010732 | (37.7448893164068, -122.466560010732) | 1 | 8 | 4 | 29491 | 40 | |||
| 35313 | 176989 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 184 Mount Vernon Ave | 9 | Side Yard : Yard | Tree | Private 2 | 14 | 5998947.7718 | 2089388.63608 | 37.7170028721745 | -122.445601123393 | (37.7170028721745, -122.445601123393) | 9 | 7 | 6 | 28861 | 25 | ||||
| 36050 | 227700 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 276 Bemis St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6002994.65302 | 2096282.17867 | 37.7361612061647 | -122.432105019051 | (37.7361612061647, -122.432105019051) | 2 | 7 | 5 | 63 | 7 | |||
| 36234 | 207142 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1419 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5991123.51551 | 2105737.38087 | 37.7614425437634 | -122.473837564856 | (37.7614425437634, -122.473837564856) | 1 | 8 | 4 | 56 | 12 | |||
| 36470 | 226579 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 110 Carmel St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 5998203.55994 | 2105386.43051 | 37.7608864542601 | -122.449325453422 | (37.7608864542601, -122.449325453422) | 15 | 5 | 11 | 29492 | 12 | |||
| 36896 | 226621 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2498 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008827.83459 | 2103955.23814 | 37.7575587153899 | -122.412479469249 | (37.7575587153899, -122.412479469249) | 2 | 4 | 7 | 28859 | 19 | |||
| 36940 | 226585 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 257 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007206.23744 | 2105617.20797 | 37.7620309629873 | -122.41820544912 | (37.7620309629873, -122.41820544912) | 8 | 4 | 7 | 28859 | 19 | |||
| 37026 | 207278 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 575 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994134.4568 | 2099399.45739 | 37.7442141593615 | -122.462964201952 | (37.7442141593615, -122.462964201952) | 1 | 8 | 4 | 59 | 40 | |||
| 37031 | 43847 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2828 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | 3 | Permit Number 43469 | 5985600.1899 | 2096127.6598 | 37.7347354008722 | -122.492232562099 | (37.7347354008722, -122.492232562099) | 1 | 8 | 3 | 29491 | 35 | |
| 37294 | 35127 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 775 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 5 | Permit Number 38661 | 6001730.34361 | 2089436.21425 | 37.71729198082 | -122.435986532578 | (37.71729198082, -122.435986532578) | 9 | 7 | 6 | 28861 | 5 | |
| 37309 | 43217 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 45 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 4 | Permit Number 43007 | 6007564.04162 | 2093733.91416 | 37.7294222326375 | -122.416126315492 | (37.7294222326375, -122.416126315492) | 9 | 3 | 7 | 309 | 28 | |
| 37671 | 207158 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 237 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992472.82504 | 2097675.82148 | 37.7393856408353 | -122.468584327098 | (37.7393856408353, -122.468584327098) | 1 | 8 | 4 | 59 | 40 | |||
| 38098 | 207321 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 20 Woodside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995570.24881 | 2100282.2016 | 37.746720553705 | -122.458063448969 | (37.746720553705, -122.458063448969) | 1 | 5 | 4 | 59 | 40 | |||
| 38178 | 207147 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1341 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5992375.35662 | 2106303.37048 | 37.7630690288235 | -122.469549207953 | (37.7630690288235, -122.469549207953) | 1 | 8 | 11 | 56 | 12 | |||
| 38311 | 226584 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 116 Franconia St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6010066.87681 | 2099747.40872 | 37.7460744052137 | -122.407897622203 | (37.7460744052137, -122.407897622203) | 2 | 7 | 7 | 28859 | 2 | ||||
| 38346 | 129492 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2536 Baker St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5999690.83284 | 2117600.09007 | 37.794506995647 | -122.445059718941 | (37.794506995647, -122.445059718941) | 13 | 9 | 1 | 57 | 27 | |||
| 38638 | 34814 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 485 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1998 12:00:00 AM | 5 | Permit Number 38705 | 5983755.24002 | 2112575.55408 | 37.7797886838057 | -122.499826423266 | (37.7797886838057, -122.499826423266) | 11 | 6 | 2 | 55 | 26 | |
| 38923 | 207195 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 574 Hearst Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997610.81771 | 2094416.06797 | 37.7307306014402 | -122.450584552831 | (37.7307306014402, -122.450584552831) | 9 | 7 | 4 | 59 | 40 | |||
| 39853 | 37792 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 310 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 5 | Permit Number 40120 | 6009317.62312 | 2092827.34387 | 37.727031425442 | -122.410000018602 | (37.727031425442, -122.410000018602) | 9 | 3 | 7 | 309 | 28 | |
| 39854 | 207249 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 581 Arch St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992725.89958 | 2091026.00542 | 37.7211415099655 | -122.467225936253 | (37.7211415099655, -122.467225936253) | 9 | 8 | 6 | 64 | 24 | |||
| 40351 | 1384 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2550X Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X2 | 6002245.07965 | 2096962.32948 | 37.7379862171661 | -122.43474521929 | (37.7379862171661, -122.43474521929) | 2 | 7 | 5 | 63 | 7 | |||
| 40574 | 177028 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 164 Baltimore Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6002357.56159 | 2086195.52892 | 37.7084293823926 | -122.433587065817 | (37.7084293823926, -122.433587065817) | 9 | 7 | 6 | 28861 | 5 | |||
| 40625 | 207300 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 145 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996448.99813 | 2094535.96368 | 37.7309932376391 | -122.454609779812 | (37.7309932376391, -122.454609779812) | 9 | 7 | 4 | 28861 | 40 | |||
| 40718 | 226629 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 54 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001984.40508 | 2105553.3896 | 37.761560425102 | -122.436261146841 | (37.761560425102, -122.436261146841) | 15 | 4 | 5 | 28862 | 3 | |||
| 40791 | 207283 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 84 Manor Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993642.59329 | 2093470.80397 | 37.7279072068291 | -122.464234616632 | (37.7279072068291, -122.464234616632) | 9 | 8 | 4 | 59 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );