Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 105423 | 105423 | 41830 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1232 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/2001 12:00:00 AM | Permit Number 42216 | 5991454.19182704 | 2107029.2184828 | 37.765008732916705 | -122.472788101582 | (37.7650087329167, -122.472788101582) | ||
| 77854 | 77854 | 63851 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1233 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24548 | 6001965.88884277 | 2110471.51360831 | 37.775063328726 | -122.43667724183999 | (37.775063328726, -122.43667724184) | ||
| 113556 | 113556 | 45337 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1239 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 44167 | 6013665.22038022 | 2106606.66789645 | 37.7651092465016 | -122.39593550872 | (37.7651092465016, -122.39593550872) | ||
| 125120 | 125120 | 68814 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 125 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32757 | 6002131.57604717 | 2095277.55167817 | 37.7333537609923 | -122.435017196532 | (37.7333537609923, -122.435017196532) | ||
| 82846 | 82846 | 63850 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1259 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24547 | 6001845.15733033 | 2110454.5773622 | 37.7750099641834 | -122.437093665021 | (37.7750099641834, -122.437093665021) | ||
| 135271 | 135271 | 35351 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1274 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 11 | 5x5 | Permit Number 38813 | 6012220.8536 | 2102461.75759 | 37.7536477760478 | -122.400640051912 | (37.7536477760478, -122.400640051912) |
| 92747 | 92747 | 61034 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 130 Swiss Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2011 12:00:00 AM | 3x5 | Permit Number 768338 | 6001256.29714973 | 2096400.69751215 | 37.736387920753295 | -122.43812370070101 | (37.7363879207533, -122.438123700701) | |
| 102710 | 102710 | 43223 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1303 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/2004 12:00:00 AM | Permit Number 44301 | 6009289.62355935 | 2101563.81507978 | 37.7510183090213 | -122.410713527989 | (37.7510183090213, -122.410713527989) | ||
| 50358 | 50358 | 35258 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1304 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 11 | Permit Number 38744 | 6006066.5782 | 2120048.78389 | 37.8015923223752 | -122.42317295609199 | (37.8015923223752, -122.423172956092) | |
| 124022 | 124022 | 37952 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1308 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40191 | 6013419.73141926 | 2106176.98186548 | 37.763915762931106 | -122.396754475262 | (37.7639157629311, -122.396754475262) | ||
| 32980 | 32980 | 30799 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 131 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 8 | Permit Number 34665 | 6002107.114019999 | 2095231.84638 | 37.733226875715296 | -122.43509850062 | (37.7332268757153, -122.43509850062) | |
| 108180 | 108180 | 63547 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1316 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | Permit Number 24163 | 6001453.76739224 | 2111146.48373237 | 37.7768875100239 | -122.43849714915399 | (37.7768875100239, -122.438497149154) | ||
| 44871 | 44871 | 36124 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1324 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | 10 | Permit Number 39220 | 5988358.7841 | 2106301.1655 | 37.7628300220311 | -122.483440838848 | (37.7628300220311, -122.483440838848) | |
| 1362 | 1362 | 36186 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 133 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 8 | Permit Number 39255 | 5995881.41756 | 2113499.8369 | 37.783030646722004 | -122.45794382331002 | (37.783030646722, -122.45794382331) | |
| 145931 | 145931 | 49975 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1337@ 14th Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/2003 12:00:00 AM | Permit Number 46726 | 6007190.27597203 | 2107705.69793456 | 37.7677645693117 | -122.418408745471 | (37.7677645693117, -122.418408745471) | ||
| 38779 | 38779 | 68329 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 12 | Permit Number 32144 | 5991421.402000001 | 2110674.853 | 37.7750167634254 | -122.47316740712401 | (37.7750167634254, -122.473167407124) | |
| 55462 | 55462 | 113717 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5991400.52029 | 2110673.00421 | 37.775010478076794 | -122.47323950591299 | (37.7750104780768, -122.473239505913) | |||
| 154629 | 154629 | 113718 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | 5991385.6612 | 2110673.31757 | 37.7750104780928 | -122.473290929077 | (37.7750104780928, -122.473290929077) | |||
| 95424 | 95424 | 42113 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 136 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42412 | 5999169.44681663 | 2093518.27568943 | 37.7283545633122 | -122.445131627679 | (37.7283545633122, -122.445131627679) | ||
| 105527 | 105527 | 42114 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 136 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | Permit Number 42412 | 5999169.44681663 | 2093518.27568943 | 37.7283545633122 | -122.445131627679 | (37.7283545633122, -122.445131627679) | ||
| 96226 | 96226 | 32739 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 137 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37122 | 5995581.47746257 | 2088674.4560737 | 37.7148491391882 | -122.45718507236099 | (37.7148491391882, -122.457185072361) | ||
| 27440 | 27440 | 35252 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1385 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 7 | Permit Number 38738 | 6006246.10083 | 2119680.0646 | 37.8005900423666 | -122.42252550983801 | (37.8005900423666, -122.422525509838) | |
| 70350 | 70350 | 35250 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1385 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | Permit Number 38738 | 6006287.30636 | 2119683.41372 | 37.800601562682296 | -122.42238315976999 | (37.8006015626823, -122.42238315977) | |
| 79951 | 79951 | 32740 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 139 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37123 | 5995564.95354615 | 2088674.66529796 | 37.7148487646576 | -122.457242200681 | (37.7148487646576, -122.457242200681) | ||
| 103248 | 103248 | 43143 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 140 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | Permit Number 42956 | 6005786.06556581 | 2093081.91758291 | 37.7275318626033 | -122.42222665307399 | (37.7275318626033, -122.422226653074) | ||
| 19744 | 19744 | 66789 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1405 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1991 12:00:00 AM | 8 | 3x3 | Permit Number 30063 | 6006130.65101914 | 2119658.78326709 | 37.80052509557579 | -122.42292350049 | (37.8005250955758, -122.42292350049) |
| 107252 | 107252 | 52789 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1420@ 26th ST Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/2006 12:00:00 AM | Permit Number 48830 | 6009273.59871726 | 2100910.89270255 | 37.749224630920104 | -122.410722838262 | (37.7492246309201, -122.410722838262) | ||
| 143156 | 143156 | 37729 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1424 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40093 | 6009274.50535547 | 2100894.4740613997 | 37.74917959981 | -122.410718543725 | (37.74917959981, -122.410718543725) | ||
| 65053 | 65053 | 37086 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1426 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39686 | 5981873.63686209 | 2105374.96731705 | 37.7599073668224 | -122.505801636192 | (37.7599073668224, -122.505801636192) | |
| 86777 | 86777 | 38531 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1426 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1998 12:00:00 AM | Permit Number 40513 | 6007984.37872155 | 2099748.42101744 | 37.74596037533 | -122.415098722892 | (37.74596037533, -122.415098722892) | ||
| 117911 | 117911 | 69194 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1455 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33240 | 6009333.22604202 | 2100774.20133137 | 37.748852649751704 | -122.410506994166 | (37.7488526497517, -122.410506994166) | ||
| 105335 | 105335 | 40071 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1459 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41297 | 6015490.41779177 | 2093366.98866113 | 37.728857218184295 | -122.388698234625 | (37.7288572181843, -122.388698234625) | ||
| 95639 | 95639 | 69196 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1463 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33243 | 6009335.03931842 | 2100741.36404906 | 37.7487625875096 | -122.410498405401 | (37.7487625875096, -122.410498405401) | ||
| 10474 | 10474 | 34625 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1466 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38307 | 5988697.9248 | 2105373.4338 | 37.76030245534 | -122.482199912019 | (37.76030245534, -122.482199912019) |
| 173732 | 173732 | 34626 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1474 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 0 | Permit Number 38308 | 5988706.220433701 | 2105294.39494794 | 37.760085918568 | -122.48216543102 | (37.760085918568, -122.48216543102) | |
| 109135 | 109135 | 67746 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1479 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1992 12:00:00 AM | Permit Number 31365 | 5994572.72013397 | 2105470.39847949 | 37.7609086531136 | -122.461888924556 | (37.7609086531136, -122.461888924556) | ||
| 95504 | 95504 | 38702 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1508 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | Permit Number 40610 | 6001927.2408902 | 2111561.6017671 | 37.7780542409849 | -122.436888988053 | (37.7780542409849, -122.436888988053) | ||
| 151645 | 151645 | 38575 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1511 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40535 | 6015329.8173 | 2094876.8945 | 37.732994214171704 | -122.389358843431 | (37.7329942141717, -122.389358843431) | |
| 42992 | 42992 | 32891 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1515 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.760330583946796 | -122.462923499947 | (37.7603305839468, -122.462923499947) | ||
| 128285 | 128285 | 32890 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1515 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.760330583946796 | -122.462923499947 | (37.7603305839468, -122.462923499947) | ||
| 118307 | 118307 | 38576 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1515 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/2005 12:00:00 AM | Permit Number 40536 | 6015316.8681654995 | 2094894.06453978 | 37.7330406417059 | -122.38940481098601 | (37.7330406417059, -122.389404810986) | ||
| 30607 | 30607 | 38043 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1523 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 8 | Permit Number 40245 | 6000097.0958 | 2114311.3232 | 37.7855000811005 | -122.44341765838199 | (37.7855000811005, -122.443417658382) | |
| 156125 | 156125 | 38044 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1523 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 11 | Permit Number 40245 | 6000092.6356 | 2114341.0582 | 37.785581471348706 | -122.443435225951 | (37.7855814713487, -122.443435225951) | |
| 38263 | 38263 | 68132 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1526 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 0 | Permit Number 31884 | 6000696.86081651 | 2113890.04393367 | 37.7843775414062 | -122.44131241543998 | (37.7843775414062, -122.44131241544) | |
| 123798 | 123798 | 67185 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 154 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | 12 | Permit Number 30632 | 5998076.31886872 | 2105384.33640813 | 37.76087342528071 | -122.44976537124599 | (37.7608734252807, -122.449765371246) | |
| 110661 | 110661 | 30763 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1542 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34644 | 6014903.15895955 | 2093519.78776627 | 37.729244209154295 | -122.39073911946801 | (37.7292442091543, -122.390739119468) | ||
| 118633 | 118633 | 69308 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1550 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | Permit Number 33387 | 5986864.5682116 | 2104707.11140573 | 37.7583661086574 | -122.488491577304 | (37.7583661086574, -122.488491577304) | ||
| 94117 | 94117 | 67164 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1550 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30604 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | ||
| 98056 | 98056 | 111844 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1550 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | ||||
| 173679 | 173679 | 30757 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1553 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 11 | Permit Number 34638 | 6014989.6074 | 2093734.2507 | 37.729837877239795 | -122.390455236274 | (37.7298378772398, -122.390455236274) | |
| 98266 | 98266 | 30758 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1557 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34639 | 6014967.84012217 | 2093755.65118605 | 37.7298954311335 | -122.390531983655 | (37.7298954311335, -122.390531983655) | ||
| 145627 | 145627 | 38582 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1565 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40542 | 6015429.1390942 | 2094459.97574961 | 37.7318549452945 | -122.388986360684 | (37.7318549452945, -122.388986360684) | ||
| 138983 | 138983 | 30760 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1571 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34641 | 6014896.23757332 | 2093808.81402101 | 37.7300374330916 | -122.390783237924 | (37.7300374330916, -122.390783237924) | ||
| 97186 | 97186 | 30761 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1575 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34642 | 6014875.77973499 | 2093824.0033781002 | 37.7300780049156 | -122.39085502491999 | (37.7300780049156, -122.39085502492) | ||
| 100685 | 100685 | 61745 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 16 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21751 | 6005058.850293 | 2101091.32092731 | 37.7494828305195 | -122.42531035662901 | (37.7494828305195, -122.425310356629) | ||
| 79707 | 79707 | 46270 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 16 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/2002 12:00:00 AM | Permit Number 44554 | 6001971.15717323 | 2094954.12044598 | 37.732456582979495 | -122.435548678389 | (37.7324565829795, -122.435548678389) | ||
| 94512 | 94512 | 37474 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1642 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39945 | 5992805.4256232 | 2104283.42646812 | 37.7575476379464 | -122.467914829169 | (37.7575476379464, -122.467914829169) | ||
| 113622 | 113622 | 41148 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1653 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41881 | 5997742.91613306 | 2108148.62427098 | 37.7684443776569 | -122.45111780839 | (37.7684443776569, -122.45111780839) | ||
| 87658 | 87658 | 67603 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 168 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1992 12:00:00 AM | Permit Number 31174 | 6013416.46891349 | 2106299.39948246 | 37.7642517131045 | -122.39677434216001 | (37.7642517131045, -122.39677434216) | ||
| 122800 | 122800 | 37408 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1711 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39888 | 6002631.16896948 | 2100601.66569625 | 37.7480008987993 | -122.43367034777599 | (37.7480008987993, -122.433670347776) | ||
| 103358 | 103358 | 66155 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1741 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/1990 12:00:00 AM | Permit Number 29226 | 6013929.0546693 | 2095023.1611058 | 37.7333180723286 | -122.394211919223 | (37.7333180723286, -122.394211919223) | ||
| 30888 | 30888 | 42696 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1751 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42713 | 6007796.58473 | 2118447.48214 | 37.7972930261196 | -122.417072803384 | (37.7972930261196, -122.417072803384) | |
| 44833 | 44833 | 34144 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1754 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39666 | 6003955.69985192 | 2098004.27278913 | 37.740944124338895 | -122.428905023889 | (37.7409441243389, -122.428905023889) | ||
| 47055 | 47055 | 40817 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1999 12:00:00 AM | 10 | Permit Number 41760 | 6001600.476 | 2114446.9395 | 37.785958067470204 | -122.43822613537901 | (37.7859580674702, -122.438226135379) | |
| 88609 | 88609 | 67673 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1776 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31276 | 6014200.74997189 | 2095090.82766105 | 37.733518969015996 | -122.393277319642 | (37.733518969016, -122.393277319642) | ||
| 122776 | 122776 | 34009 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 18 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39435 | 6007439.60245605 | 2099473.00721902 | 37.7451735210906 | -122.416962980086 | (37.7451735210906, -122.416962980086) | ||
| 186671 | 186671 | 73754 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1815 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 6 | 6009969.6946 | 2120303.1237 | 37.8025101678048 | -122.40968430266199 | (37.8025101678048, -122.409684302662) | ||
| 1815 | 1815 | 71427 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1852 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2017 12:00:00 AM | 3 | 4x4 | 6009993.7542 | 2120480.0499 | 37.802997311571104 | -122.409613538987 | (37.8029973115711, -122.409613538987) | |
| 185639 | 185639 | 40169 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1901 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1999 12:00:00 AM | 0 | Permit Number 41362 | 6000480.4385885 | 2111652.95524414 | 37.7782227381789 | -122.44190053998399 | (37.7782227381789, -122.441900539984) | |
| 88327 | 88327 | 64256 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 191 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1988 12:00:00 AM | Permit Number 25057 | 6004710.43221145 | 2098679.48425343 | 37.7428407913605 | -122.426343498945 | (37.7428407913605, -122.426343498945) | ||
| 142784 | 142784 | 67651 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1919 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31250 | 6013521.72915428 | 2095881.08409425 | 37.7356511027367 | -122.39568025647101 | (37.7356511027367, -122.395680256471) | ||
| 150848 | 150848 | 42651 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1924 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 9 | Permit Number 42691 | 6004339.89147 | 2118073.8812599997 | 37.7960721541703 | -122.42900719184799 | (37.7960721541703, -122.429007191848) | |
| 64628 | 64628 | 71308 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1949 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1988 12:00:00 AM | 8 | 6000243.5 | 2111616.6716 | 37.7781096083019 | -122.44271758887699 | (37.7781096083019, -122.442717588877) | ||
| 87509 | 87509 | 66256 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 198 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29359 | 5996422.28373213 | 2098491.67117902 | 37.7418531174549 | -122.454987856884 | (37.7418531174549, -122.454987856884) | ||
| 112247 | 112247 | 66784 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 20 Culebra Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/1992 12:00:00 AM | Permit Number 30056 | 6006381.97640479 | 2120210.98917161 | 37.8020554906142 | -122.422093063103 | (37.8020554906142, -122.422093063103) | ||
| 85817 | 85817 | 45250 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 200 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44097 | 5996410.188004401 | 2098465.43898756 | 37.7417803963921 | -122.45502778464599 | (37.7417803963921, -122.455027784646) | ||
| 126861 | 126861 | 33356 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 200 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37493 | 5994058.57591139 | 2093537.34847989 | 37.7281138896418 | -122.46280139081699 | (37.7281138896418, -122.462801390817) | ||
| 74936 | 74936 | 42897 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2016 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 7 | Permit Number 42813 | 5986657.8903 | 2096958.6583 | 37.737078880033 | -122.488636837876 | (37.737078880033, -122.488636837876) | |
| 147832 | 147832 | 42896 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2016 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 6 | Permit Number 42813 | 5986675.0189 | 2096952.6028 | 37.737063252741706 | -122.488577172427 | (37.7370632527417, -122.488577172427) | |
| 44369 | 44369 | 42898 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2060 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/2002 12:00:00 AM | 7 | Permit Number 45580 | 5986523.9754 | 2097068.6969 | 37.737373201510295 | -122.489107923346 | (37.7373732015103, -122.489107923346) | |
| 81910 | 81910 | 42335 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 207 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | ||
| 91322 | 91322 | 42334 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 207 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | ||
| 99576 | 99576 | 68703 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2081 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | Permit Number 32615 | 6003689.8407303 | 2107120.9618086996 | 37.7659613518454 | -122.430474597791 | (37.7659613518454, -122.430474597791) | ||
| 100858 | 100858 | 67803 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 211 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2015 12:00:00 AM | Permit Number 776671 | 6003788.24539392 | 2100967.25400369 | 37.7490703054266 | -122.429695296026 | (37.7490703054266, -122.429695296026) | ||
| 87234 | 87234 | 61737 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 213 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/1993 12:00:00 AM | Permit Number 31452 | 6003775.93391522 | 2100966.602272 | 37.7490678187798 | -122.429737822747 | (37.7490678187798, -122.429737822747) | ||
| 98885 | 98885 | 38501 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2133 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1998 12:00:00 AM | Permit Number 40492 | 6006816.69957876 | 2118509.8967936 | 37.797409229816104 | -122.42046789447399 | (37.7974092298161, -122.420467894474) | ||
| 79886 | 79886 | 67804 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 215 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1994 12:00:00 AM | Permit Number 31453 | 6003763.62243652 | 2100965.95054031 | 37.7490653321175 | -122.429780349464 | (37.7490653321175, -122.429780349464) | ||
| 90037 | 90037 | 68758 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | Permit Number 32681 | 6004133.43114203 | 2105726.5811326997 | 37.762157835439 | -122.42884089299999 | (37.762157835439, -122.428840893) | ||
| 81412 | 81412 | 39503 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Jersey St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.42999018002399 | (37.7508086831914, -122.429990180024) | ||
| 101744 | 101744 | 39506 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Jersey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.42999018002399 | (37.7508086831914, -122.429990180024) | ||
| 122534 | 122534 | 39505 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.42999018002399 | (37.7508086831914, -122.429990180024) | ||
| 125881 | 125881 | 39507 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Jersey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.42999018002399 | (37.7508086831914, -122.429990180024) | ||
| 93949 | 93949 | 36079 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2170 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39193 | 6008724.90392173 | 2105792.20395445 | 37.7625968269406 | -122.412965325481 | (37.7625968269406, -122.412965325481) | ||
| 98941 | 98941 | 117044 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2297 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6001629.48989293 | 2114242.74964382 | 37.785399064529294 | -122.438111123258 | (37.7853990645293, -122.438111123258) | |||
| 48083 | 48083 | 43179 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2299 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42985 | 6001635.1083 | 2114240.3384 | 37.7853927633961 | -122.438091512505 | (37.7853927633961, -122.438091512505) |
| 75943 | 75943 | 44033 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 230 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/02/2000 12:00:00 AM | 9 | Permit Number 43569 | 5998819.8857 | 2109894.1205 | 37.7732986671632 | -122.447518341015 | (37.7732986671632, -122.447518341015) | |
| 55604 | 55604 | 35336 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2311 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/2005 12:00:00 AM | 1 | Permit Number 48271 | 6010839.4517 | 2105063.96093 | 37.7607157062843 | -122.40560053693501 | (37.7607157062843, -122.405600536935) | |
| 127401 | 127401 | 51076 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 232 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2006 12:00:00 AM | Permit Number 47538 | 6006664.07662334 | 2104758.9078781004 | 37.759643739107496 | -122.420019665049 | (37.7596437391075, -122.420019665049) | ||
| 56697 | 56697 | 35266 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2323 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | 3x3 | Permit Number 38750 | 6006292.04033 | 2118835.34945 | 37.798273260158 | -122.42230648984699 | (37.798273260158, -122.422306489847) |
| 110851 | 110851 | 35265 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006296.38753209 | 2118756.6266107 | 37.79805735235279 | -122.422285851072 | (37.7980573523528, -122.422285851072) |
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");