Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3736 | 3736 | 223410 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 898 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1993 12:00:00 AM | 9 | Width 4ft | Permit Number 32344 | 6010171.02881 | 2104045.21453 | 37.7578810584907 | -122.407840483778 | (37.7578810584907, -122.407840483778) | |
| 29538 | 29538 | 33172 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2311 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37388 | 5986066.5372792 | 2098877.4979138 | 37.742312976384504 | -122.490822533573 | (37.7423129763845, -122.490822533573) | |
| 30916 | 30916 | 223570 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 404 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007482.0536400005 | 2095699.0870700001 | 37.7348135594986 | -122.41654890782301 | (37.7348135594986, -122.416548907823) | |||
| 35885 | 35885 | 223665 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3821 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002927.695719999 | 2103554.21162 | 37.7561247121999 | -122.432855868402 | (37.7561247121999, -122.432855868402) | |||
| 36133 | 36133 | 223495 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007975.84228 | 2103064.94118 | 37.75506631266121 | -122.41536298621901 | (37.7550663126612, -122.415362986219) | |||
| 38241 | 38241 | 207574 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 447 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5992827.2239 | 2104547.6082099997 | 37.7582742708466 | -122.46785865694599 | (37.7582742708466, -122.467858656946) | |||
| 39807 | 39807 | 246473 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 300 Duncan St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004475.07524 | 2099887.00412 | 37.7461430567683 | -122.427243293056 | (37.7461430567683, -122.427243293056) | |||
| 46974 | 46974 | 223623 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 457 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006809.22741 | 2101132.82627 | 37.7496955290349 | -122.419260433921 | (37.7496955290349, -122.419260433921) | |||
| 47616 | 47616 | 64550 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1407 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 9 | Permit Number 25433 | 6015557.9064 | 2094994.5115 | 37.7333298097375 | -122.388578480063 | (37.7333298097375, -122.388578480063) | |
| 47846 | 47846 | 207531 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1325 18th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5990492.61494 | 2106135.1233599996 | 37.76249807624271 | -122.476048615548 | (37.7624980762427, -122.476048615548) | |||
| 48194 | 48194 | 72330 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2761 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 9 | 5995926.57923 | 2110675.1717 | 37.775277458656795 | -122.457583143432 | (37.7752774586568, -122.457583143432) | ||
| 51114 | 51114 | 32504 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 399 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 9 | Permit Number 37008 | 6007356.06097 | 2095755.1769700001 | 37.734960483524496 | -122.416988482053 | (37.7349604835245, -122.416988482053) | |
| 53543 | 53543 | 189266 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 550 Bay Shore Blvd | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6010210.57589 | 2097161.88665 | 37.7389831663466 | -122.407218500042 | (37.7389831663466, -122.407218500042) | |||
| 54012 | 54012 | 31710 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 619 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35210 | 5996583.34698 | 2107294.12432 | 37.7660316834511 | -122.45506687733999 | (37.7660316834511, -122.45506687734) | |
| 54595 | 54595 | 207678 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3137 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990981.20237 | 2100859.62837 | 37.7480412755876 | -122.473973874217 | (37.7480412755876, -122.473973874217) | |||
| 56834 | 56834 | 223564 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 130 Nevada St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6009029.83515 | 2097858.62477 | 37.7408301058168 | -122.41135018155899 | (37.7408301058168, -122.411350181559) | |||
| 56916 | 56916 | 246579 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 140 Laguna St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6005220.7586 | 2109411.73941 | 37.772337880726 | -122.425342493187 | (37.772337880726, -122.425342493187) | |||
| 58552 | 58552 | 123028 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 738 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5991970.4168 | 2110394.80661 | 37.7742796046287 | -122.47124785557699 | (37.7742796046287, -122.471247855577) | |||
| 64162 | 64162 | 207652 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1249 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5992353.95742 | 2106910.47377 | 37.7647347369382 | -122.469667419325 | (37.7647347369382, -122.469667419325) | |||
| 64501 | 64501 | 191079 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1559 Howard St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6007858.27887 | 2109378.1367200003 | 37.7723942745191 | -122.416216661379 | (37.7723942745191, -122.416216661379) | |||
| 66576 | 66576 | 68236 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1515 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 9 | Permit Number 32031 | 5990787.04658 | 2113362.94185 | 37.7823607651124 | -122.47555807743099 | (37.7823607651124, -122.475558077431) | |
| 67754 | 67754 | 207547 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1329 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993917.02159 | 2106451.10735 | 37.7635636541512 | -122.464227879808 | (37.7635636541512, -122.464227879808) | |||
| 68217 | 68217 | 223478 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 147 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006034.337859999 | 2095867.87013 | 37.7351954754822 | -122.42156615354999 | (37.7351954754822, -122.42156615355) | |||
| 71745 | 71745 | 74989 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1660 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 9 | 6009226.90425 | 2118994.74178 | 37.798876023557 | -122.41216221273199 | (37.798876023557, -122.412162212732) | ||
| 74059 | 74059 | 31015 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1200 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34784 | 6001104.8718 | 2087440.4366099997 | 37.7117764674692 | -122.438005613962 | (37.7117764674692, -122.438005613962) | ||
| 77053 | 77053 | 217739 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 695 Frederick St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5996222.62463 | 2107246.57774 | 37.76588043186471 | -122.45631109749901 | (37.7658804318647, -122.456311097499) | |||
| 90891 | 90891 | 102695 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 384 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6000881.0 | 2096712.0 | 37.7372213335044 | -122.439443565515 | (37.7372213335044, -122.439443565515) | |||
| 104438 | 104438 | 223472 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 905 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5999167.22172 | 2107046.81544 | 37.7655005312494 | -122.446112018354 | (37.7655005312494, -122.446112018354) | |||
| 122524 | 122524 | 63432 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 127 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/1987 12:00:00 AM | 9 | Permit Number 24018 | 6005906.17265772 | 2095879.01582361 | 37.7352188514571 | -122.42201005945499 | (37.7352188514571, -122.422010059455) | ||
| 122961 | 122961 | 31688 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 816 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35192 | 5998677.08875 | 2107434.65955 | 37.766537451377204 | -122.44783519493099 | (37.7665374513772, -122.447835194931) | |
| 130662 | 130662 | 61989 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3245 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1985 12:00:00 AM | 9 | Permit Number 22056 | 6004135.50024 | 2120335.1617400004 | 37.802269475902 | -122.42987580203699 | (37.802269475902, -122.429875802037) | |
| 130731 | 130731 | 207610 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 51 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997347.38565 | 2089696.67863 | 37.7177571866363 | -122.451155061159 | (37.7177571866363, -122.451155061159) | |||
| 132624 | 132624 | 61779 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2227 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1985 12:00:00 AM | 9 | Permit Number 21800 | 6011831.44367 | 2102306.0377599997 | 37.753198477451896 | -122.401975779864 | (37.7531984774519, -122.401975779864) | |
| 133990 | 133990 | 223409 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 898 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6010169.99414 | 2104057.76493 | 37.757915461148706 | -122.40784494709801 | (37.7579154611487, -122.407844947098) | |||
| 136287 | 136287 | 126515 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3616 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997525.9275 | 2115116.25328 | 37.78756324380671 | -122.452371201775 | (37.7875632438067, -122.452371201775) | |||
| 138051 | 138051 | 223483 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 562 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008521.06241 | 2096162.7197200002 | 37.7361449725004 | -122.412989453223 | (37.7361449725004, -122.412989453223) | |||
| 139340 | 139340 | 49495 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2X ORDWAY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2003 12:00:00 AM | 9 | 3x3 | Permit Number 46411 | 6011821.0 | 2090323.0 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | |
| 146348 | 146348 | 223547 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 577 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5996845.23673 | 2107329.23539 | 37.7661431103528 | -122.454163594697 | (37.7661431103528, -122.454163594697) | |||
| 146970 | 146970 | 223481 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 412 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007869.12634 | 2096919.9723900002 | 37.7381876044595 | -122.415297058717 | (37.7381876044595, -122.415297058717) | |||
| 147935 | 147935 | 223616 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 408 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006796.55753 | 2101381.3101 | 37.75037709553 | -122.41932187201799 | (37.75037709553, -122.419321872018) | |||
| 152451 | 152451 | 64965 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1695 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | 9 | Permit Number 26000 | 6004890.47461 | 2119142.0833400004 | 37.7990363142334 | -122.42717819021999 | (37.7990363142334, -122.42717819022) | |
| 153146 | 153146 | 126547 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2007 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008156.84893 | 2119375.98217 | 37.799862715653894 | -122.41589197732999 | (37.7998627156539, -122.41589197733) | |||
| 154143 | 154143 | 66887 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1324 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1991 12:00:00 AM | 9 | Permit Number 30200 | 6013938.0874 | 2104806.5934 | 37.760181812970096 | -122.394865641745 | (37.7601818129701, -122.394865641745) | ||
| 154469 | 154469 | 207651 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1243 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5992350.996590001 | 2106967.18215 | 37.7648902719794 | -122.46968178868099 | (37.7648902719794, -122.469681788681) | |||
| 155148 | 155148 | 114648 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2200 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6001582.4120000005 | 2113946.0192 | 37.784581641139205 | -122.438252733323 | (37.7845816411392, -122.438252733323) | |||
| 157957 | 157957 | 246573 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6005236.998 | 2109273.038 | 37.771957957636 | -122.42527644787701 | (37.771957957636, -122.425276447877) | |||
| 158064 | 158064 | 223408 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 898 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6010170.12734 | 2104071.29966 | 37.7579526319374 | -122.40784544082399 | (37.7579526319374, -122.407845440824) | |||
| 159510 | 159510 | 31680 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 55 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35186 | 5998329.535540001 | 2107192.5767200002 | 37.7658528820189 | -122.44901987368999 | (37.7658528820189, -122.44901987369) | |
| 160467 | 160467 | 61780 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2127 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1985 12:00:00 AM | 9 | Permit Number 21802 | 6012087.28443 | 2102320.53166 | 37.75325255009079 | -122.40109204397498 | (37.7532525500908, -122.401092043975) | |
| 161639 | 161639 | 72265 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 358 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 9 | 6002353.80444 | 2091524.3629400001 | 37.7230609707806 | -122.43398070266599 | (37.7230609707806, -122.433980702666) | ||
| 162390 | 162390 | 126526 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3101 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004207.10509 | 2119826.7769 | 37.8008776374509 | -122.429591735885 | (37.8008776374509, -122.429591735885) | |||
| 166319 | 166319 | 64966 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1690 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | 9 | Permit Number 26001 | 6004915.29698 | 2119193.66495 | 37.799179347809996 | -122.42709597241199 | (37.79917934781, -122.427095972412) | |
| 167327 | 167327 | 223582 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 57 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008286.43047 | 2100056.77298 | 37.7468240108166 | -122.414076076165 | (37.7468240108166, -122.414076076165) | |||
| 167801 | 167801 | 68421 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2207 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1993 12:00:00 AM | 9 | Permit Number 32265 | 6011906.60073 | 2102309.43328 | 37.753211995154096 | -122.401716108723 | (37.7532119951541, -122.401716108723) | ||
| 167863 | 167863 | 223458 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 557 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998600.4522 | 2105970.1234 | 37.762511823291895 | -122.44799481022 | (37.7625118232919, -122.44799481022) | |||
| 168927 | 168927 | 207571 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1563 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5993664.12129 | 2104858.25974 | 37.759175530032294 | -122.464986884242 | (37.7591755300323, -122.464986884242) | |||
| 172629 | 172629 | 223443 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 400 Day St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003241.07095 | 2098648.16117 | 37.742671617906 | -122.431421899403 | (37.742671617906, -122.431421899403) | |||
| 172751 | 172751 | 224097 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1414 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6002522.9823199995 | 2101416.25277 | 37.7502314233618 | -122.434102675005 | (37.7502314233618, -122.434102675005) | |||
| 173425 | 173425 | 126521 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 250 Alhambra St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6000953.24503 | 2120036.11736 | 37.8012676554495 | -122.44086645991301 | (37.8012676554495, -122.440866459913) | |||
| 174560 | 174560 | 176260 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 282 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004334.87033 | 2091639.7615 | 37.723490058001 | -122.42714076854601 | (37.723490058001, -122.427140768546) | |||
| 175182 | 175182 | 120820 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 20th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5989571.70093 | 2114608.1795799998 | 37.785709309470796 | -122.47985374027 | (37.7857093094708, -122.47985374027) | |||
| 177353 | 177353 | 68223 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1330 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 9 | Permit Number 32016 | 5991325.89713 | 2113444.25067 | 37.7826152391743 | -122.473699843984 | (37.7826152391743, -122.473699843984) | |
| 177570 | 177570 | 99646 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1795 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | Permit Number 768958 | 5985627.2622 | 2103048.7649 | 37.7537404715173 | -122.492648532329 | (37.7537404715173, -122.492648532329) | ||
| 178506 | 178506 | 246472 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 300 Duncan St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004489.61116 | 2099886.70473 | 37.7461430567511 | -122.42719300834999 | (37.7461430567511, -122.42719300835) | |||
| 180123 | 180123 | 223533 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 53 Newburg St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 10ft | 6002432.22452 | 2099844.0691299997 | 37.7459094263876 | -122.43430413393601 | (37.7459094263876, -122.434304133936) | |||
| 183787 | 183787 | 191666 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Brannan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6013244.57038 | 2111045.61556 | 37.777274188396795 | -122.397701819284 | (37.7772741883968, -122.397701819284) | |||
| 183925 | 183925 | 191091 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 150 Wisconsin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012554.29768 | 2106630.7365599996 | 37.765113465742395 | -122.399779633617 | (37.7651134657424, -122.399779633617) | |||
| 186789 | 186789 | 176247 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011833.809309999 | 2090345.7505400002 | 37.720358182462704 | -122.401127251532 | (37.7203581824627, -122.401127251532) | |||
| 188373 | 188373 | 32498 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 676 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 9 | Permit Number 37003 | 6007391.76195 | 2095838.15833 | 37.73519034034379 | -122.41687092807301 | (37.7351903403438, -122.416870928073) | |
| 188750 | 188750 | 31037 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 722 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34796 | 6002553.27762 | 2087290.2882 | 37.7114464558494 | -122.43298880977899 | (37.7114464558494, -122.432988809779) |
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");