Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12540 | 12540 | 108677 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 11 Otsego Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | Permit Number 773206 | 6000966.57436 | 2092971.8241299998 | 37.7269565451936 | -122.438879746024 | (37.7269565451936, -122.438879746024) | |
| 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) |
| 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) | |||
| 101299 | 101299 | 39622 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 1 | 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) | ||
| 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) | ||
| 138921 | 138921 | 68908 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 67 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32883 | 6001725.7944262 | 2105449.29562811 | 37.7612599114424 | -122.43714812038 | (37.7612599114424, -122.43714812038) | ||
| 81631 | 81631 | 64135 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 674 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1992 12:00:00 AM | Permit Number 31501 | 6002183.05937143 | 2098884.5643421 | 37.7432607055203 | -122.43509709755399 | (37.7432607055203, -122.435097097554) | ||
| 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) | ||
| 109349 | 109349 | 39488 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3838 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40946 | 6004210.35746859 | 2101925.0566577 | 37.751724101234004 | -122.42830388310301 | (37.751724101234, -122.428303883103) | ||
| 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) | ||
| 93635 | 93635 | 35001 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 8028 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | Permit Number 38578 | 5982135.81465862 | 2112401.83483279 | 37.7792165374199 | -122.50541575084101 | (37.7792165374199, -122.505415750841) | |||
| 109990 | 109990 | 35000 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 8028 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | Permit Number 38578 | 5982135.81465862 | 2112401.83483279 | 37.7792165374199 | -122.50541575084101 | (37.7792165374199, -122.505415750841) | |||
| 95772 | 95772 | 67793 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4381 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31435 | 6001427.36985446 | 2101130.88060421 | 37.7493856180132 | -122.437870927363 | (37.7493856180132, -122.437870927363) | ||
| 141302 | 141302 | 67797 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4545 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31440 | 6000849.66169786 | 2101098.90444447 | 37.7492649509789 | -122.439866358772 | (37.7492649509789, -122.439866358772) | ||
| 144765 | 144765 | 67794 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4385 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31436 | 6001403.12898277 | 2101129.53886862 | 37.749380555446294 | -122.437954656615 | (37.7493805554463, -122.437954656615) | ||
| 146049 | 146049 | 67801 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 881 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31447 | 6000722.425257199 | 2102556.2611987 | 37.753259258073705 | -122.44041084963301 | (37.7532592580737, -122.440410849633) | ||
| 106159 | 106159 | 64173 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 30 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1987 12:00:00 AM | Permit Number 24955 | 5992735.52734942 | 2093091.96966529 | 37.7268146975842 | -122.467342804105 | (37.7268146975842, -122.467342804105) | ||
| 9300 | 9300 | 1913 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 8 Bell Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016615.0158522995 | 2095214.1533182 | 37.7339914292631 | -122.384939021898 | (37.7339914292631, -122.384939021898) | ||
| 99648 | 99648 | 67774 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 50 Potomac St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1992 12:00:00 AM | Permit Number 31407 | 6003128.8589186 | 2108744.804056 | 37.7703882320696 | -122.43253091541 | (37.7703882320696, -122.43253091541) | ||
| 100643 | 100643 | 61746 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3873 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21752 | 6004713.22212882 | 2100726.95185307 | 37.7484628246013 | -122.426479608106 | (37.7484628246013, -122.426479608106) | ||
| 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) | ||
| 107386 | 107386 | 61743 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3818 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21749 | 6005051.92893884 | 2100797.64178313 | 37.748676064316605 | -122.425313395129 | (37.7486760643166, -122.425313395129) | ||
| 115605 | 115605 | 62376 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3548 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | Permit Number 25477 | 6005956.95420215 | 2104942.96708739 | 37.7601092573287 | -122.422478330945 | (37.7601092573287, -122.422478330945) | ||
| 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) | ||
| 3793 | 3793 | 39226 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 770 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 9 | Permit Number 40869 | 5984798.64138 | 2110605.0729799997 | 37.774439483359 | -122.49607147975 | (37.774439483359, -122.49607147975) | ||
| 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) | ||
| 168792 | 168792 | 83538 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 243 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 5 | 6004140.213830001 | 2089715.70651 | 37.7181960153187 | -122.427676641269 | (37.7181960153187, -122.427676641269) | ||
| 94356 | 94356 | 33643 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 473 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37737 | 6005146.14820368 | 2110741.54826683 | 37.7759849973486 | -122.42569524360201 | (37.7759849973486, -122.425695243602) | |||
| 106204 | 106204 | 33633 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 282 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1996 12:00:00 AM | Permit Number 37729 | 6006046.09364695 | 2110919.64612747 | 37.7765248233176 | -122.422594750669 | (37.7765248233176, -122.422594750669) | ||
| 124435 | 124435 | 33658 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 575 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37746 | 6004659.15076187 | 2110673.58419475 | 37.7757708537128 | -122.427375053318 | (37.7757708537128, -122.427375053318) | |||
| 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) | ||
| 2515 | 2515 | 124752 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2478 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | 9 | Width 5ft | 6002956.6534 | 2115870.86114 | 37.7899448329366 | -122.433635939447 | (37.7899448329366, -122.433635939447) | ||
| 84909 | 84909 | 33582 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 157 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37690 | 6007165.20249785 | 2098095.43390853 | 37.741375573534896 | -122.41781418098302 | (37.7413755735349, -122.417814180983) | |||
| 113125 | 113125 | 33550 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 234 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37658 | 6007061.72353382 | 2097649.40994488 | 37.740145067036295 | -122.41814036231101 | (37.7401450670363, -122.418140362311) | |||
| 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) | |||
| 128685 | 128685 | 81348 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 561 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774387 | 6002774.12023878 | 2102081.98215915 | 37.7520736087499 | -122.433281789286 | (37.7520736087499, -122.433281789286) | |
| 145188 | 145188 | 39196 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 948 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40848 | 6009924.75641086 | 2103679.40260243 | 37.756862830813105 | -122.408666394738 | (37.7568628308131, -122.408666394738) | ||
| 125998 | 125998 | 33399 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 300 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37517 | 5992600.35501271 | 2094892.48894855 | 37.7317506732587 | -122.467940993296 | (37.7317506732587, -122.467940993296) | ||
| 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) | |||
| 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) | ||
| 96770 | 96770 | 39100 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3376 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40789 | 6006536.85037285 | 2102635.06060624 | 37.7538049769481 | -122.42030893490299 | (37.7538049769481, -122.420308934903) | ||
| 2164 | 2164 | 10688 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1221 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1991 12:00:00 AM | 6 | 3X3 | 6002001.6656 | 2110480.73 | 37.7750906677438 | -122.43655414222 | (37.7750906677438, -122.43655414222) | ||
| 100570 | 100570 | 66876 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 311 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30186 | 6001155.37730733 | 2104574.8455135 | 37.7588264440048 | -122.439058274593 | (37.7588264440048, -122.439058274593) | ||
| 119291 | 119291 | 66874 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 315 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30184 | 6001156.85774168 | 2104547.18862288 | 37.7587505891563 | -122.43905117245501 | (37.7587505891563, -122.439051172455) | ||
| 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) | ||
| 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) | ||
| 51120 | 51120 | 66858 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 103 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1991 12:00:00 AM | 9 | Permit Number 30164 | 5998644.5770000005 | 2110362.2819 | 37.774574098301294 | -122.448158471707 | (37.7745740983013, -122.448158471707) | ||
| 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) | ||
| 88063 | 88063 | 33257 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2669 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37434 | 5986956.33101058 | 2097199.71207947 | 37.7377581609646 | -122.48762271062598 | (37.7377581609646, -122.487622710626) | ||
| 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) | |||
| 117578 | 117578 | 67799 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4263 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/11/1995 12:00:00 AM | Permit Number 31443 | 6002203.13479099 | 2100589.02594752 | 37.7479418964289 | -122.435149566646 | (37.7479418964289, -122.435149566646) | ||
| 86515 | 86515 | 48833 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1019 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | Permit Number 46053 | 6002516.40077061 | 2102618.9246623 | 37.7535333013465 | -122.43421140278099 | (37.7535333013465, -122.434211402781) | |||
| 40232 | 40232 | 50534 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1853 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | 9 | Permit Number 47173 | 6004174.32371 | 2118346.10209 | 37.7968102295769 | -122.42959951321899 | (37.7968102295769, -122.429599513219) | ||
| 103621 | 103621 | 33192 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 53 Idora Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37399 | 5996322.19797653 | 2099597.08028102 | 37.7448825563847 | -122.455413791656 | (37.7448825563847, -122.455413791656) | ||
| 118826 | 118826 | 33189 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 76 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37397 | 5996015.45875929 | 2099706.92373099 | 37.7451665539633 | -122.456482373988 | (37.7451665539633, -122.456482373988) | ||
| 123758 | 123758 | 33190 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 76 Hernandez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37397 | 5996015.45875929 | 2099706.92373099 | 37.7451665539633 | -122.456482373988 | (37.7451665539633, -122.456482373988) | ||
| 89262 | 89262 | 33122 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2363 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37356 | 6001608.80596075 | 2119029.55221322 | 37.798541206544705 | -122.438525775033 | (37.7985412065447, -122.438525775033) | ||
| 102879 | 102879 | 33133 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3016 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37363 | 6001491.05795368 | 2118756.44455004 | 37.7977846260596 | -122.438913636839 | (37.7977846260596, -122.438913636839) | ||
| 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) | |||
| 139872 | 139872 | 33019 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3447 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37307 | 6006830.46712311 | 2101429.94248045 | 37.75051253872171 | -122.419208059366 | (37.7505125387217, -122.419208059366) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 51454 | 51454 | 44091 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 807 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2000 12:00:00 AM | 6 | Permit Number 43606 | 6011323.913930001 | 2104520.92035 | 37.759251716121796 | -122.40388677626001 | (37.7592517161218, -122.40388677626) | ||
| 153681 | 153681 | 44451 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 81 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 10 | Permit Number 48336 | 6002602.78622 | 2086898.2858 | 37.710372910849706 | -122.43278970978001 | (37.7103729108497, -122.43278970978) | |
| 148872 | 148872 | 31585 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1894 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49864 | 5988492.0785 | 2102440.4028 | 37.7522371668693 | -122.482696889121 | (37.7522371668693, -122.482696889121) | |
| 61126 | 61126 | 50520 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 85 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 5 | Permit Number 47158 | 5996681.6204 | 2112482.6347 | 37.7802836203489 | -122.455101936973 | (37.7802836203489, -122.455101936973) | |
| 121163 | 121163 | 48817 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 61 Everson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46044 | 6003284.291752299 | 2097109.16717497 | 37.7384483443847 | -122.431162629878 | (37.7384483443847, -122.431162629878) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 144457 | 144457 | 61341 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 434 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1985 12:00:00 AM | Permit Number 22558 | 6004883.03697194 | 2110411.47227967 | 37.775063818048295 | -122.426581905478 | (37.7750638180483, -122.426581905478) | ||
| 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) | |
| 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) | ||
| 101869 | 101869 | 66237 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 422 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29335 | 5995558.06563814 | 2090587.62307484 | 37.72010089980329 | -122.45740432201 | (37.7201008998033, -122.45740432201) | ||
| 108082 | 108082 | 39702 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 628 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/2004 12:00:00 AM | Permit Number 41087 | 5998596.38137062 | 2094778.55233682 | 37.731782260395 | -122.447203397318 | (37.731782260395, -122.447203397318) | ||
| 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) | |
| 64061 | 64061 | 32346 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | ||
| 78102 | 78102 | 32344 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | ||
| 107835 | 107835 | 32345 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | ||
| 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) | |
| 154995 | 154995 | 32348 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 9 | Permit Number 37068 | 5985188.5725 | 2106987.4184 | 37.764529258945 | -122.49445591941799 | (37.764529258945, -122.494455919418) | |
| 44083 | 44083 | 32557 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3822 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 770192 | 6002956.41958884 | 2103022.59282687 | 37.7546666427143 | -122.43271855723499 | (37.7546666427143, -122.432718557235) | |||
| 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) | ||
| 48557 | 48557 | 50472 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3010X Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.798579545974704 | -122.446920252577 | (37.7985795459747, -122.446920252577) | |
| 112271 | 112271 | 50471 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3010X Lyon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.798579545974704 | -122.446920252577 | (37.7985795459747, -122.446920252577) | |
| 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) | |||
| 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) | ||
| 143634 | 143634 | 50469 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3010X Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.798579545974704 | -122.446920252577 | (37.7985795459747, -122.446920252577) | |
| 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) | |||
| 113328 | 113328 | 51453 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 427 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | Permit Number 47771 | 6004926.82550892 | 2110358.25622266 | 37.774920175138895 | -122.42642664134199 | (37.7749201751389, -122.426426641342) | |||
| 20390 | 20390 | 66640 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2620 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32335 | 6010387.14006944 | 2103433.53881978 | 37.756213630012496 | -122.407049963033 | (37.7562136300125, -122.407049963033) | ||
| 104133 | 104133 | 64176 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 7 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2000 12:00:00 AM | Permit Number 24959 | 5992913.91992547 | 2093156.51419592 | 37.727002217924706 | -122.466730800624 | (37.7270022179247, -122.466730800624) | ||
| 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) | |
| 150176 | 150176 | 38055 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2779 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1999 12:00:00 AM | 5 | Permit Number 40250 | 6000228.6146 | 2114392.8852 | 37.78573152849079 | -122.442968502827 | (37.7857315284908, -122.442968502827) | |
| 56967 | 56967 | 92754 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 880 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52983 | 6005536.79298 | 2091854.05704 | 37.724146362548204 | -122.423001157676 | (37.7241463625482, -122.423001157676) |
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");