Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 27919 | 27919 | 207196 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 580 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997574.55439 | 2094416.3667 | 37.7307293459771 | -122.450709941708 | (37.7307293459771, -122.450709941708) | |||
| 28926 | 28926 | 207301 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 145 Hazelwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996452.48883 | 2094524.36789 | 37.7309615985977 | -122.454596874545 | (37.7309615985977, -122.454596874545) | |||
| 30391 | 30391 | 207358 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 171 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998941.871780001 | 2093762.1788299999 | 37.7290112721346 | -122.445935896945 | (37.7290112721346, -122.445935896945) | ||||
| 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) | |||
| 31691 | 31691 | 37790 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 310 Hamilton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 6 | Permit Number 40120 | 6009327.0324 | 2092792.3248 | 37.7269357978389 | -122.40996501967899 | (37.7269357978389, -122.409965019679) | |
| 31710 | 31710 | 207290 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 81 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993410.050430001 | 2093515.91328 | 37.7280176597738 | -122.465041791443 | (37.7280176597738, -122.465041791443) | |||
| 33118 | 33118 | 118541 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981337.423690001 | 2112399.66579 | 37.779163567264 | -122.50817750438699 | (37.779163567264, -122.508177504387) | ||||
| 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) | |||
| 35068 | 35068 | 207355 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 430 Edna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998789.17566 | 2094262.87598 | 37.730377348622106 | -122.446499784464 | (37.7303773486221, -122.446499784464) | ||||
| 36376 | 36376 | 37433 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1419 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1998 12:00:00 AM | 6 | Permit Number 39907 | 5991189.91551 | 2110613.34906 | 37.7748344845766 | -122.473963672883 | (37.7748344845766, -122.473963672883) | ||
| 38348 | 38348 | 119479 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985644.21808 | 2112952.33317 | 37.7809338791525 | -122.493319479205 | (37.7809338791525, -122.493319479205) | |||
| 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) | |||
| 40805 | 40805 | 122909 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2x 12th Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5992095.78801 | 2114872.2732700002 | 37.7865807540814 | -122.471140447624 | (37.7865807540814, -122.471140447624) | ||||
| 42942 | 42942 | 207270 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994256.24514 | 2105719.06013 | 37.7615731891695 | -122.463001505824 | (37.7615731891695, -122.463001505824) | |||
| 44325 | 44325 | 207349 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 618 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5997332.96655 | 2095282.6428599998 | 37.733094101592705 | -122.451607607218 | (37.7330941015927, -122.451607607218) | |||
| 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) | |
| 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) | ||
| 48932 | 48932 | 70374 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1494 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5983124.8306 | 2104978.8403 | 37.7588932768889 | -122.501445132559 | (37.7588932768889, -122.501445132559) | ||
| 49438 | 49438 | 226600 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1463 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6003321.08221 | 2099703.03715 | 37.7455725970047 | -122.431220523219 | (37.7455725970047, -122.431220523219) | |||
| 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) | |||
| 51466 | 51466 | 118540 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981337.117190001 | 2112394.76177 | 37.7791500842164 | -122.50817820058701 | (37.7791500842164, -122.508178200587) | ||||
| 52054 | 52054 | 226616 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005523.88104 | 2097105.4034 | 37.7385646686269 | -122.42341893953899 | (37.7385646686269, -122.423418939539) | |||
| 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) | |||
| 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) | |||
| 59140 | 59140 | 207326 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 43 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998477.362380001 | 2097389.2678 | 37.7389438623547 | -122.447802750104 | (37.7389438623547, -122.447802750104) | |||
| 59196 | 59196 | 78418 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2987 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 6 | 5988809.97189 | 2095328.5114400003 | 37.732728266388 | -122.481076880696 | (37.732728266388, -122.481076880696) | ||
| 59419 | 59419 | 207291 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 135 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993593.95913 | 2093848.0757900001 | 37.7289402994475 | -122.464430125662 | (37.7289402994475, -122.464430125662) | |||
| 59492 | 59492 | 31354 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2324 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 6 | Permit Number 34964 | 5992033.25034 | 2099586.3658 | 37.7446061063992 | -122.47024325973 | (37.7446061063992, -122.47024325973) | |
| 59995 | 59995 | 226605 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 276 Bemis St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6002989.382569999 | 2096277.75645 | 37.7361487649474 | -122.432122925433 | (37.7361487649474, -122.432122925433) | |||
| 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) | |||
| 62502 | 62502 | 46769 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 54 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 6 | Permit Number 44865 | 6002394.404709999 | 2093228.74941 | 37.7277431363295 | -122.43396212714599 | (37.7277431363295, -122.433962127146) | |
| 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) | |||
| 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) | |||
| 67977 | 67977 | 117858 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 600 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5983830.55841 | 2111665.32715 | 37.777293884605704 | -122.499498581311 | (37.7772938846057, -122.499498581311) | |||
| 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) | |||
| 70729 | 70729 | 177010 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002632.11132 | 2094355.1655700002 | 37.73084950708879 | -122.433220824095 | (37.7308495070888, -122.433220824095) | |||
| 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) | |||
| 73614 | 73614 | 40348 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/17/1999 12:00:00 AM | 6 | Permit Number 41478 | 5984070.03891 | 2112340.8801599997 | 37.779162805435 | -122.498720071631 | (37.779162805435, -122.498720071631) | |
| 75063 | 75063 | 123520 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2808 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5994672.01997 | 2110241.5879900004 | 37.774014807441795 | -122.461891472498 | (37.7740148074418, -122.461891472498) | |||
| 75893 | 75893 | 70393 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 63 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 6 | 6005472.78201 | 2093254.0606099998 | 37.7279868534853 | -122.42332190988998 | (37.7279868534853, -122.42332190989) | ||
| 76051 | 76051 | 207298 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 111 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996286.51947 | 2094316.70178 | 37.73038187671379 | -122.45515565391099 | (37.7303818767138, -122.455155653911) | |||
| 91369 | 91369 | 177012 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002642.0398 | 2094328.25695 | 37.730776185352504 | -122.433184577831 | (37.7307761853525, -122.433184577831) | |||
| 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) | |||
| 125304 | 125304 | 177013 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002644.59595 | 2094315.3545 | 37.7307409031583 | -122.433174819278 | (37.7307409031583, -122.433174819278) | |||
| 129591 | 129591 | 185132 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2675 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985816.5603 | 2097133.8948 | 37.7375109017116 | -122.491558549707 | (37.7375109017116, -122.491558549707) | |||
| 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) | |||
| 131611 | 131611 | 207292 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 965 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994659.45419 | 2093917.36528 | 37.729191913559205 | -122.460751677241 | (37.7291919135592, -122.460751677241) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 137148 | 137148 | 177027 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 127 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6004458.22384 | 2092761.54245 | 37.726577195866206 | -122.426794207588 | (37.7265771958662, -122.426794207588) | |||
| 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) | |||
| 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) | |||
| 147909 | 147909 | 226624 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 366 Eureka St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6001461.5255 | 2103604.00302 | 37.75617816071271 | -122.437929936033 | (37.7561781607127, -122.437929936033) | |||
| 148538 | 148538 | 42630 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2634 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42686 | 6004473.47116 | 2118249.9245 | 37.7965630841803 | -122.428557534402 | (37.7965630841803, -122.428557534402) | |
| 149892 | 149892 | 119481 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985644.19758 | 2112999.51907 | 37.781063436855604 | -122.493323027528 | (37.7810634368556, -122.493323027528) | |||
| 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) | ||||
| 152673 | 152673 | 226615 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 10 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005546.7514 | 2097096.0791900002 | 37.7385403572369 | -122.423339202051 | (37.7385403572369, -122.423339202051) | |||
| 154947 | 154947 | 207205 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 243 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997427.42425 | 2094320.33561 | 37.7304572443933 | -122.45121166810499 | (37.7304572443933, -122.451211668105) | |||
| 155540 | 155540 | 226607 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 205 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997675.15136 | 2106444.92247 | 37.7637625662095 | -122.45122931550699 | (37.7637625662095, -122.451229315507) | |||
| 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) | |||
| 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) | ||||
| 159331 | 159331 | 120006 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 658 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5986941.43179 | 2111450.92852 | 37.7768872385676 | -122.488721446125 | (37.7768872385676, -122.488721446125) | |||
| 159473 | 159473 | 78478 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2987 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 6 | 5988808.95801 | 2095345.9881400003 | 37.7327761939684 | -122.481081665112 | (37.7327761939684, -122.481081665112) | ||
| 165009 | 165009 | 117857 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 600 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5983829.36907 | 2111677.06691 | 37.777326048802294 | -122.499503563368 | (37.7773260488023, -122.499503563368) | |||
| 165558 | 165558 | 226619 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 220 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007856.36673 | 2100270.38915 | 37.747386388365705 | -122.415578321691 | (37.7473863883657, -122.415578321691) | |||
| 166261 | 166261 | 207306 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 40 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996625.80083 | 2093939.75542 | 37.7293663316726 | -122.453955505049 | (37.7293663316726, -122.453955505049) | |||
| 170099 | 170099 | 207167 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 520 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5996922.66578 | 2093634.6954 | 37.7285457263925 | -122.45290721030399 | (37.7285457263925, -122.452907210304) | |||
| 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) | |||
| 171196 | 171196 | 31366 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2475 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 6 | Permit Number 34971 | 5991057.56391 | 2098576.78296 | 37.7417775946723 | -122.473543328283 | (37.7417775946723, -122.473543328283) | |
| 171748 | 171748 | 207363 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 98 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999482.34141 | 2093540.9124 | 37.7284345728794 | -122.444051566321 | (37.7284345728794, -122.444051566321) | ||||
| 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) | |||
| 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) |
| 173392 | 173392 | 207197 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 580 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997566.05489 | 2094416.0866599998 | 37.730728090525 | -122.45073930547899 | (37.730728090525, -122.450739305479) | |||
| 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) | |||
| 176931 | 176931 | 119480 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985643.02597 | 2112973.39807 | 37.7809916475781 | -122.493325155639 | (37.7809916475781, -122.493325155639) | |||
| 176985 | 176985 | 34479 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 756 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 6 | 2x3 | Permit Number 38206 | 6009344.310190001 | 2119468.83873 | 37.800184363566 | -122.411789466237 | (37.800184363566, -122.411789466237) |
| 181523 | 181523 | 226601 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1518 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003286.59929 | 2099387.77612 | 37.7447050093281 | -122.431317259697 | (37.7447050093281, -122.431317259697) | |||
| 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) | |
| 184301 | 184301 | 207208 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Foerster St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998074.52147 | 2093832.4092700002 | 37.7291545431359 | -122.44893943651199 | (37.7291545431359, -122.448939436512) | |||
| 184400 | 184400 | 207325 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 530 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5997976.81268 | 2097718.94755 | 37.739820461255604 | -122.449557161036 | (37.7398204612556, -122.449557161036) | |||
| 185589 | 185589 | 207219 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 147 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999123.85922 | 2093459.79448 | 37.728191385403704 | -122.445285022505 | (37.7281913854037, -122.445285022505) | ||||
| 187515 | 187515 | 207357 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 219 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998605.9960199995 | 2093779.39497 | 37.7290393588582 | -122.44709827877199 | (37.7290393588582, -122.447098278772) | |||
| 188359 | 188359 | 226618 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007884.76815 | 2100264.95114 | 37.7473730532316 | -122.415479726319 | (37.7473730532316, -122.415479726319) | |||
| 188987 | 188987 | 207327 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 48 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998437.39477 | 2097397.71392 | 37.7389647688951 | -122.44794154698401 | (37.7389647688951, -122.447941546984) |
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");