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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 41668 | 41668 | 203664 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 123 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999403.203369999 | 2093610.5277599997 | 37.7286212055976 | -122.444330150233 | (37.7286212055976, -122.444330150233) | |||
| 42347 | 42347 | 203665 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 123 Detroit St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5999403.44951 | 2093584.38933 | 37.728549449599704 | -122.444327421686 | (37.7285494495997, -122.444327421686) | |||
| 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) | ||
| 5792 | 5792 | 10690 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1233 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001959.267000001 | 2110474.8139 | 37.7750720141838 | -122.43670038449801 | (37.7750720141838, -122.436700384498) | |||
| 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) | ||
| 136405 | 136405 | 203653 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 125 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6002114.00252 | 2095255.92738 | 37.733293387768995 | -122.435076406948 | (37.733293387769, -122.435076406948) | |||
| 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) | ||
| 371 | 371 | 8188 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1272 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/1997 12:00:00 AM | 10 | 3X4 | 6001679.2828 | 2111174.9406 | 37.7769784708042 | -122.437719062833 | (37.7769784708042, -122.437719062833) | ||
| 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) |
| 40646 | 40646 | 219991 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 13 Bronte St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6009385.52811 | 2097403.7869700002 | 37.739601163374 | -122.41008822049601 | (37.739601163374, -122.410088220496) | |||
| 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) | |
| 21207 | 21207 | 10209 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1301 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/17/1994 12:00:00 AM | 12 | 3X3PL | 6005849.39823 | 2101351.62015 | 37.7502421837319 | -122.4225951102 | (37.7502421837319, -122.4225951102) | ||
| 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) | |
| 51056 | 51056 | 203627 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 133 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5994260.237269999 | 2095673.9858 | 37.7339921852793 | -122.462259143365 | (37.7339921852793, -122.462259143365) | |||
| 64167 | 64167 | 203628 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 133 Maywood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5994258.53071 | 2095683.80268 | 37.734019041749 | -122.46226575516701 | (37.734019041749, -122.462265755167) | |||
| 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) | |
| 153405 | 153405 | 50382 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1330 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2003 12:00:00 AM | 4 | Permit Number 47040 | 6006491.715 | 2119759.4717 | 37.8008219271374 | -122.421681226333 | (37.8008219271374, -122.421681226333) | ||
| 181456 | 181456 | 50381 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1330 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2003 12:00:00 AM | 6 | 3x3 | Permit Number 47040 | 6006481.85746 | 2119759.67415 | 37.8008219271496 | -122.42171535199499 | (37.8008219271496, -122.421715351995) | |
| 33357 | 33357 | 220021 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001964.613530001 | 2100084.23013 | 37.7465422991033 | -122.435938247064 | (37.7465422991033, -122.435938247064) | |||
| 173012 | 173012 | 220020 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001963.20475 | 2100104.97494 | 37.7465991794258 | -122.435944602583 | (37.7465991794258, -122.435944602583) | |||
| 188982 | 188982 | 220022 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001965.3710900005 | 2100066.86744 | 37.746494668288996 | -122.435934385359 | (37.746494668289, -122.435934385359) | |||
| 48265 | 48265 | 220667 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1337 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007176.0273400005 | 2107716.44116 | 37.767793265562894 | -122.41845879174801 | (37.7677932655629, -122.418458791748) | |||
| 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) | |||
| 56688 | 56688 | 122010 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991362.52356 | 2110673.50037 | 37.775009640229605 | -122.473370979732 | (37.7750096402296, -122.473370979732) | |||
| 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) | ||
| 184019 | 184019 | 245165 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1364 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000037.7937 | 2109212.4329 | 37.7714964504984 | -122.443256472847 | (37.7714964504984, -122.443256472847) | |||
| 5055 | 5055 | 253765 | Significant Tree 6 | Acacia baileyana :: Bailey's Acacia 42 | 1366 Guerrero St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3X3 | 6005800.0848900005 | 2101007.6677599996 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | ||||
| 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) | ||
| 33978 | 33978 | 203629 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 138 Encline Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998295.84832 | 2098462.32087 | 37.7418798313816 | -122.448507597342 | (37.7418798313816, -122.448507597342) | |||
| 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) | |
| 98224 | 98224 | 40633 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1385 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1999 12:00:00 AM | Permit Number 41908 | 5999539.52102625 | 2107847.36223217 | 37.7677198855431 | -122.44488187524901 | (37.7677198855431, -122.444881875249) | |||
| 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) | ||
| 151268 | 151268 | 203651 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5993846.97887 | 2094818.6059299998 | 37.731619718855704 | -122.46362583408701 | (37.7316197188557, -122.463625834087) | |||
| 157925 | 157925 | 203650 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5993848.38247 | 2094813.0241599998 | 37.7316044735649 | -122.46362057664699 | (37.7316044735649, -122.463620576647) | |||
| 178200 | 178200 | 203649 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5993852.26622 | 2094804.8663700002 | 37.731582298063394 | -122.46360655802201 | (37.7315822980634, -122.463606558022) | |||
| 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) | ||
| 66468 | 66468 | 203632 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1400 Monterey Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5993831.29855 | 2094857.6984 | 37.7317261536347 | -122.463682879865 | (37.7317261536347, -122.463682879865) | |||
| 158134 | 158134 | 203631 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1400 Monterey Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 5993837.01835 | 2094842.09298 | 37.7316836345786 | -122.46366197331801 | (37.7316836345786, -122.463661973318) | |||
| 186555 | 186555 | 203630 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1400 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 5993843.17005 | 2094826.47883 | 37.731641116434496 | -122.46363957301 | (37.7316411164345, -122.46363957301) | |||
| 31523 | 31523 | 188515 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1401 25th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6014455.23285 | 2101981.54762 | 37.752453585184604 | -122.39287941707799 | (37.7524535851846, -122.392879417078) | ||||
| 69034 | 69034 | 220048 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1401 Rivoli St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5997746.6978 | 2105897.5577 | 37.7622637372081 | -122.450942387687 | (37.7622637372081, -122.450942387687) | |||
| 167945 | 167945 | 220049 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1401 Rivoli St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 5997764.73117 | 2105899.6107 | 37.7622704065882 | -122.450880165397 | (37.7622704065882, -122.450880165397) | |||
| 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) |
| 112276 | 112276 | 50450 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1418 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47096 | 5998923.01373461 | 2108365.57348999 | 37.7691075589972 | -122.44705158673901 | (37.7691075589972, -122.447051586739) | |||
| 145663 | 145663 | 50449 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1418 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47096 | 5998923.01373461 | 2108365.57348999 | 37.7691075589972 | -122.44705158673901 | (37.7691075589972, -122.447051586739) | |||
| 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) | ||
| 57888 | 57888 | 220056 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1424 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009277.433730001 | 2100868.30065 | 37.7491078976199 | -122.410706569176 | (37.7491078976199, -122.410706569176) | |||
| 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) | ||
| 135734 | 135734 | 219995 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1426 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007991.10477 | 2099694.15634 | 37.745811754609896 | -122.415071624753 | (37.7458117546099, -122.415071624753) | |||
| 24270 | 24270 | 188526 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1427x Innes Ave | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6016254.90623 | 2096663.3838099998 | 37.7379507994938 | -122.386285047323 | (37.7379507994938, -122.386285047323) | ||||
| 169840 | 169840 | 188527 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1427x Innes Ave | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016131.12478 | 2096760.51066 | 37.7382106379019 | -122.386719795784 | (37.7382106379019, -122.386719795784) | ||||
| 6724 | 6724 | 102771 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1438 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6006063.66154 | 2119354.00796 | 37.7996844799161 | -122.42313363592501 | (37.7996844799161, -122.423133635925) | |||
| 100490 | 100490 | 46891 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1442 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2002 12:00:00 AM | Permit Number 44947 | 5993067.98197095 | 2105653.75631803 | 37.7613253640923 | -122.46710643924999 | (37.7613253640923, -122.46710643925) | |||
| 48501 | 48501 | 188519 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1451 Rhode Island St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6012046.50101 | 2101636.39558 | 37.7513717861857 | -122.401185012303 | (37.7513717861857, -122.401185012303) | ||||
| 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) |
| 160608 | 160608 | 220073 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 147 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002697.135559999 | 2105044.08938 | 37.7602024793668 | -122.433759704173 | (37.7602024793668, -122.433759704173) | |||
| 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) | ||
| 165790 | 165790 | 55817 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1479 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50161 | 5982146.8936 | 2105055.9033 | 37.759047387316706 | -122.50483294742399 | (37.7590473873167, -122.504832947424) | |
| 45254 | 45254 | 220074 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 148 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002660.22221 | 2105037.36162 | 37.7601819118789 | -122.43388688897 | (37.7601819118789, -122.43388688897) | |||
| 43667 | 43667 | 203624 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5997319.6106 | 2099609.0427 | 37.7449725828299 | -122.45196580449199 | (37.7449725828299, -122.451965804492) | |||
| 59298 | 59298 | 203625 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997311.4729 | 2099621.76413 | 37.7450070466421 | -122.45199486067499 | (37.7450070466421, -122.451994860675) | |||
| 93809 | 93809 | 203623 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997330.81089 | 2099592.0734900003 | 37.744926631064 | -122.45192585212 | (37.744926631064, -122.45192585212) | |||
| 151042 | 151042 | 203622 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997339.998380001 | 2099579.33016 | 37.7448921672303 | -122.45189316446002 | (37.7448921672303, -122.45189316446) | |||
| 187109 | 187109 | 142298 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1501 GROVE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000546.8174 | 2110627.5355 | 37.775410978082 | -122.44159730622299 | (37.775410978082, -122.441597306223) | |||
| 23355 | 23355 | 76748 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1501X 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 7 | 3x12 | 5983093.5463 | 2104693.1195 | 37.7581069307926 | -122.501532189631 | (37.7581069307926, -122.501532189631) | |
| 93890 | 93890 | 98217 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1501X 42nd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
| 65413 | 65413 | 137613 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1502 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001914.7987 | 2111556.8609 | 37.778040516588604 | -122.436931690487 | (37.7780405165886, -122.436931690487) | |||
| 69465 | 69465 | 188516 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1506 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6014137.77003 | 2102020.8067900003 | 37.7525437439982 | -122.39398001279301 | (37.7525437439982, -122.393980012793) | |||
| 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) | ||
| 185230 | 185230 | 219990 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 151 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999384.54447 | 2107324.60583 | 37.766275682101 | -122.445380326357 | (37.766275682101, -122.445380326357) | |||
| 86247 | 86247 | 50653 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 151 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | Permit Number 47235 | 5996872.39579561 | 2087134.54464453 | 37.710694953358995 | -122.452612074363 | (37.710694953359, -122.452612074363) | |||
| 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) | |
| 65145 | 65145 | 124758 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1513 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006956.23003 | 2117363.82528 | 37.79427026621129 | -122.419903713582 | (37.7942702662113, -122.419903713582) | |||
| 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) | ||
| 184246 | 184246 | 51499 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1518 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | 1 | Permit Number 47812 | 5983133.1181 | 2104773.3328 | 37.758329497976 | -122.501401269082 | (37.758329497976, -122.501401269082) | ||
| 157511 | 157511 | 44744 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1520 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2001 12:00:00 AM | 6 | Permit Number 43862 | 6006848.33301 | 2117722.6808 | 37.7952495146165 | -122.420302532344 | (37.7952495146165, -122.420302532344) | ||
| 186993 | 186993 | 44745 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1520 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2001 12:00:00 AM | 8 | Permit Number 43862 | 6006829.6851 | 2117719.85237 | 37.7952406976494 | -122.42036685635401 | (37.7952406976494, -122.420366856354) | ||
| 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) |
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");