Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23746 | 23746 | 188514 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013990.927619999 | 2106981.7626099996 | 37.7661572890446 | -122.394835230264 | (37.7661572890446, -122.394835230264) | |||
| 88925 | 88925 | 50661 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.723760552916296 | -122.43875382021002 | (37.7237605529163, -122.43875382021) | ||||
| 75622 | 75622 | 203667 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 100 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999360.3584 | 2093511.22392 | 37.7283460957947 | -122.444471133337 | (37.7283460957947, -122.444471133337) | |||
| 8932 | 8932 | 19577 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY3 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
| 15903 | 15903 | 20055 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 176496 | 176496 | 75331 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994458.53323 | 2086786.7483599999 | 37.709601382461294 | -122.460929674682 | (37.7096013824613, -122.460929674682) | ||
| 25732 | 25732 | 220090 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Ord Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000882.83826 | 2105748.10477 | 37.7620324153945 | -122.44008496885401 | (37.7620324153945, -122.440084968854) | |||
| 156503 | 156503 | 174960 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 103 De Long St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 10ft | 5994409.5991400005 | 2086788.1181299998 | 37.709602327657706 | -122.461098897396 | (37.7096023276577, -122.461098897396) | |||
| 34990 | 34990 | 124760 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1055 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007817.3795 | 2119902.3991900003 | 37.8012890341312 | -122.417103992782 | (37.8012890341312, -122.417103992782) | |||
| 124870 | 124870 | 98708 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 105X Ord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6000883.6 | 2105740.8 | 37.7620124016568 | -122.440081810476 | (37.7620124016568, -122.440081810476) | |||||
| 24822 | 24822 | 250192 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011786.88966 | 2119947.0785 | 37.8016342173021 | -122.403370805543 | (37.8016342173021, -122.403370805543) | |||
| 114454 | 114454 | 108678 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 11 Otsego Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773206 | 6000980.19802 | 2092997.8380200001 | 37.727028748485395 | -122.43883451276501 | (37.7270287484854, -122.438834512765) |
| 168971 | 168971 | 220018 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1129 Douglass St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6001364.34858 | 2100418.37342 | 37.7474256590636 | -122.43803782498999 | (37.7474256590636, -122.43803782499) | |||
| 125085 | 125085 | 39221 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1143 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41443 | 6005801.05573922 | 2102320.92573379 | 37.752900946135604 | -122.422831161336 | (37.7529009461356, -122.422831161336) | ||
| 179662 | 179662 | 203222 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 120 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993081.79545 | 2099194.6713799997 | 37.7435911783029 | -122.466589164064 | (37.7435911783029, -122.466589164064) | |||
| 135969 | 135969 | 32347 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 37068 | 5985187.3443 | 2106976.3651 | 37.764498837803394 | -122.494459352499 | (37.7644988378034, -122.494459352499) | |
| 109830 | 109830 | 39623 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41021 | 5997705.33041065 | 2106460.2771729 | 37.7638064542355 | -122.451126043319 | (37.7638064542355, -122.451126043319) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | ||||
| 98495 | 98495 | 67124 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1616 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/1992 12:00:00 AM | 3x3 | Permit Number 50077 | 6009627.64848121 | 2100263.06396072 | 37.7474656808625 | -122.409452808897 | (37.7474656808625, -122.409452808897) | ||
| 183618 | 183618 | 220682 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1624 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009643.101369999 | 2100250.00573 | 37.7474306916674 | -122.40939845218 | (37.7474306916674, -122.40939845218) | |||
| 32463 | 32463 | 174965 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1645 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6006090.3331 | 2092391.29935 | 37.725652733270294 | -122.42112577893101 | (37.7256527332703, -122.421125778931) | |||
| 93386 | 93386 | 41149 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1653 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | Permit Number 41881 | 5997742.91613306 | 2108148.62427098 | 37.7684443776569 | -122.45111780839 | (37.7684443776569, -122.45111780839) | |||
| 84208 | 84208 | 38069 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1654X SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40258 | 6001625.0 | 2114095.0 | 37.7849931264589 | -122.43811606926701 | (37.7849931264589, -122.438116069267) | |||
| 154005 | 154005 | 248396 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1655 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997671.1383 | 2108143.749 | 37.768426881635605 | -122.45136572862499 | (37.7684268816356, -122.451365728625) | |||
| 75611 | 75611 | 182146 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1690 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5989681.6149 | 2103872.2722 | 37.756237834999 | -122.478688039412 | (37.756237834999, -122.478688039412) | |||
| 49170 | 49170 | 220036 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1711 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002636.29383 | 2100481.40221 | 37.747670974341396 | -122.43364403244 | (37.7476709743414, -122.43364403244) | |||
| 156262 | 156262 | 140103 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1720 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999438.9967 | 2110868.4473 | 37.776009281241 | -122.44544683133002 | (37.776009281241, -122.44544683133) | |||
| 7598 | 7598 | 103885 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999418.3529 | 2110865.7399 | 37.7760006689038 | -122.445518048679 | (37.7760006689038, -122.445518048679) | ||||
| 86900 | 86900 | 19282 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.43816511087601 | (37.786078645055, -122.438165110876) | |||
| 180473 | 180473 | 40818 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | 9 | Permit Number 41760 | 6001596.2583 | 2114468.8718 | 37.786018048063 | -122.438242299207 | (37.786018048063, -122.438242299207) | ||
| 20126 | 20126 | 22809 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 19 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3 | 3x3 | 5998930.058209999 | 2099793.7189700003 | 37.745571771416294 | -122.446410473673 | (37.7455717714163, -122.446410473673) | ||
| 54226 | 54226 | 137665 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1901 GOLDEN GATE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000382.7272 | 2111637.7254 | 37.778175352566 | -122.44223746490101 | (37.778175352566, -122.442237464901) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 129296 | 129296 | 117035 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 159913 | 159913 | 138338 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001931.2408 | 2114335.4048 | 37.7856706283151 | -122.437073793387 | (37.7856706283151, -122.437073793387) | |||
| 41760 | 41760 | 203657 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 226 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6000556.64604 | 2094979.3129099999 | 37.7324453144793 | -122.440440771241 | (37.7324453144793, -122.440440771241) | |||
| 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) | |||
| 164961 | 164961 | 138533 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2299 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001645.5525 | 2114240.3384 | 37.7853933573613 | -122.438055378776 | (37.7853933573613, -122.438055378776) | |||
| 35351 | 35351 | 42685 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2335 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 8 | Permit Number 42709 | 6006717.2254 | 2119230.45195 | 37.7993820864644 | -122.420863284838 | (37.7993820864644, -122.420863284838) | |
| 119240 | 119240 | 31447 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 237 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | Permit Number 35021 | 6002092.35921293 | 2104483.01837557 | 37.7586275781293 | -122.435811191936 | (37.7586275781293, -122.435811191936) | ||
| 149037 | 149037 | 70299 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 237 Theresa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 9 | 6001826.3531599995 | 2094025.88285 | 37.7298996296434 | -122.435982902906 | (37.7298996296434, -122.435982902906) | ||
| 162565 | 162565 | 203221 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2398 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5992664.0139 | 2099193.92326 | 37.7435650062179 | -122.468033683007 | (37.7435650062179, -122.468033683007) | |||
| 32938 | 32938 | 203645 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2450 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991098.28096 | 2098726.3101 | 37.7421905156936 | -122.473413447294 | (37.7421905156936, -122.473413447294) | |||
| 171409 | 171409 | 124759 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2534 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006240.40404 | 2119512.60207 | 37.800129911416704 | -122.42253331686199 | (37.8001299114167, -122.422533316862) | |||
| 65658 | 65658 | 183506 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2542 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5988021.6131 | 2097993.9577 | 37.7400010259161 | -122.483997786352 | (37.7400010259161, -122.483997786352) | |||
| 157543 | 157543 | 139098 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2600 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999639.9141 | 2113670.3506 | 37.7837140544374 | -122.44495327295601 | (37.7837140544374, -122.444953272956) | |||
| 5340 | 5340 | 30595 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 265 Walter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34562 | ||||||||
| 103259 | 103259 | 33256 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2669 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1996 12:00:00 AM | Permit Number 37434 | 5986956.33101058 | 2097199.71207947 | 37.7377581609646 | -122.48762271062598 | (37.7377581609646, -122.487622710626) | |||
| 168067 | 168067 | 38049 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2700 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2005 12:00:00 AM | 9 | Permit Number 47797 | 6000509.1373 | 2114490.0048 | 37.78601418351771 | -122.44200495026199 | (37.7860141835177, -122.442004950262) | |
| 69451 | 69451 | 38054 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2779 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/01/1999 12:00:00 AM | 7 | Permit Number 40250 | 6000242.4339 | 2114393.9483 | 37.7857352353713 | -122.442920768491 | (37.7857352353713, -122.442920768491) | |
| 77394 | 77394 | 36576 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2959 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39438 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | ||
| 144588 | 144588 | 36580 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2970 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39441 | 6009675.57743886 | 2101054.36494821 | 37.7496411039984 | -122.40934290688699 | (37.7496411039984, -122.409342906887) | ||
| 105079 | 105079 | 32333 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 301 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | 11 | 3x3 | Permit Number 36896 | 6006703.85221426 | 2098073.50067274 | 37.741289375858294 | -122.41940781702299 | (37.7412893758583, -122.419407817023) | |
| 111352 | 111352 | 43148 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 301 Gambier St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | Permit Number 42961 | 6006052.5972483 | 2092387.2151737 | 37.7256393916299 | -122.421255939073 | (37.7256393916299, -122.421255939073) | |||
| 122677 | 122677 | 50470 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3010X Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.798579545974704 | -122.446920252577 | (37.7985795459747, -122.446920252577) | ||
| 129666 | 129666 | 38525 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3031 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/1998 12:00:00 AM | 11 | Permit Number 40508 | 6001946.95136 | 2118602.5164799998 | 37.7973879072825 | -122.437325094293 | (37.7973879072825, -122.437325094293) | ||
| 128008 | 128008 | 23660 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 305 Virginia Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6006899.0385805 | 2098362.9679323 | 37.742095179874795 | -122.418753453583 | (37.7420951798748, -122.418753453583) | |||
| 77429 | 77429 | 23663 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 311 Virginia Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6006938.1768512 | 2098312.3803834 | 37.7419584813283 | -122.41861453896999 | (37.7419584813283, -122.41861453897) | |||
| 91582 | 91582 | 23671 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 317 Virginia Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 12 | 6006937.941544901 | 2098264.8464559 | 37.7418279505329 | -122.41861198258002 | (37.7418279505329, -122.41861198258) | |||
| 171522 | 171522 | 220055 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 32 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007497.36019 | 2099175.1634299997 | 37.7443589574154 | -122.416742166726 | (37.7443589574154, -122.416742166726) | |||
| 98067 | 98067 | 98339 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3434 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992637.0 | 2110058.2 | 37.77339390860929 | -122.468917542393 | (37.7733939086093, -122.468917542393) | ||||
| 113725 | 113725 | 33020 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3447 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37307 | 6006830.46712311 | 2101429.94248045 | 37.75051253872171 | -122.419208059366 | (37.7505125387217, -122.419208059366) | |||
| 167885 | 167885 | 220009 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3447 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006820.56616 | 2101433.2332200003 | 37.750521016743896 | -122.419242531131 | (37.7505210167439, -122.419242531131) | |||
| 133071 | 133071 | 203620 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 358 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994207.97815 | 2101247.70705 | 37.7492932209146 | -122.46284404261101 | (37.7492932209146, -122.462844042611) | |||
| 162378 | 162378 | 220679 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3607 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006165.33609 | 2104321.13003 | 37.758413591125205 | -122.421713467922 | (37.7584135911252, -122.421713467922) | |||
| 87712 | 87712 | 50320 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3615 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47024 | 6006189.66048824 | 2104317.6075576 | 37.7584052908739 | -122.421629093037 | (37.7584052908739, -122.421629093037) | |||
| 187340 | 187340 | 220676 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3681 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005782.66085 | 2104298.9799099998 | 37.7583311853523 | -122.423035356192 | (37.7583311853523, -122.423035356192) | |||
| 90165 | 90165 | 111781 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 399x EUGENIA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6006811.0 | 2098022.0 | 37.7411540008274 | -122.419033684979 | (37.7411540008274, -122.419033684979) | |||
| 111771 | 111771 | 49580 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 19917 | 19917 | 28134 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 400X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/2016 12:00:00 AM | 3 | 6x9 | 6006749.04287 | 2098002.24216 | 37.741096261078404 | -122.41924650972 | (37.7410962610784, -122.41924650972) | ||
| 52495 | 52495 | 220079 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4021 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003566.56829 | 2104171.42308 | 37.7578556427516 | -122.43069047448799 | (37.7578556427516, -122.430690474488) | |||
| 92933 | 92933 | 120549 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4098 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6002569.0 | 2102434.0 | 37.7530285274797 | -122.434016285558 | (37.7530285274797, -122.434016285558) | |||
| 54361 | 54361 | 203635 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 418 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5997950.41926 | 2094116.13567 | 37.7299264906077 | -122.44938890058201 | (37.7299264906077, -122.449388900582) | |||
| 173572 | 173572 | 245839 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 423 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005015.8911 | 2110507.8578 | 37.775335978986796 | -122.4261291969 | (37.7753359789868, -122.4261291969) | |||
| 109113 | 109113 | 99760 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4247 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Most likely planted/permitted with tree no. 1 on same day/permit. | 6002269.0 | 2101186.0 | 37.7495847859814 | -122.434964495609 | (37.7495847859814, -122.434964495609) | |||
| 53685 | 53685 | 220687 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004894.475319999 | 2110399.44382 | 37.775031437471704 | -122.426541481018 | (37.7750314374717, -122.426541481018) | |||
| 62900 | 62900 | 203646 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 45 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994072.18954 | 2100047.28757 | 37.745989350944 | -122.463226505408 | (37.745989350944, -122.463226505408) | |||
| 12958 | 12958 | 37815 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003965.721940001 | 2090553.1315400002 | 37.7204855291627 | -122.42833943800899 | (37.7204855291627, -122.428339438009) |
| 185398 | 185398 | 220685 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 452 Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6004772.24556 | 2110355.93232 | 37.774905054848396 | -122.426961200922 | (37.7749050548484, -122.426961200922) | |||
| 68064 | 68064 | 188520 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 495 Connecticut St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013272.40757 | 2104812.59187 | 37.7601612472551 | -122.397168349564 | (37.7601612472551, -122.397168349564) |
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");