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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18171 | 18171 | 1377 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 65 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1998 12:00:00 AM | 3 | 1X1 | 5998937.99517 | 2100006.33795 | 37.746156024995706 | -122.44639832203 | (37.7461560249957, -122.44639832203) | ||
| 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) | ||
| 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) | ||
| 8838 | 8838 | 10631 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 829 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1990 12:00:00 AM | 18 | 3X3 | 6003873.4823 | 2110738.4269 | 37.7759044297862 | -122.430097504694 | (37.7759044297862, -122.430097504694) | ||
| 8578 | 8578 | 10632 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 830 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003878.786 | 2110787.057 | 37.7760382564385 | -122.43008262774599 | (37.7760382564385, -122.430082627746) | ||
| 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) | ||
| 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) | |||
| 12141 | 12141 | 17224 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1880X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6001029.5778 | 2091188.70927 | 37.72206410195621 | -122.43853424087601 | (37.7220641019562, -122.438534240876) | |||
| 100029 | 100029 | 19281 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.43816511087601 | (37.786078645055, -122.438165110876) | |||
| 3716 | 3716 | 20054 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 21718 | 21718 | 22808 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 19 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1991 12:00:00 AM | 3 | 2X2 | 5998906.136630001 | 2099819.83871 | 37.745642123584105 | -122.446495069307 | (37.7456421235841, -122.446495069307) | ||
| 19047 | 19047 | 23032 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 937 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2003 12:00:00 AM | 8 | 3X3 | 6006338.92475 | 2104110.62405 | 37.757845377874204 | -122.42109817336599 | (37.7578453778742, -122.421098173366) | ||
| 111638 | 111638 | 23659 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 305 Virginia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6006899.0385805 | 2098362.9679323 | 37.742095179874795 | -122.418753453583 | (37.7420951798748, -122.418753453583) | |||
| 112941 | 112941 | 23666 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 313 Virginia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6006939.3181056 | 2098298.0428385 | 37.7419191778851 | -122.41860957638501 | (37.7419191778851, -122.418609576385) | |||
| 19290 | 19290 | 24816 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1996 12:00:00 AM | 12 | 2x3 | 6008197.49032 | 2095113.0796700001 | 37.733244720069706 | -122.414033944713 | (37.7332447200697, -122.414033944713) | ||
| 110460 | 110460 | 25177 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 3076 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 30 | 3X3 | 6000054.6842234 | 2105404.3700399 | 37.7610414235505 | -122.442924538729 | (37.7610414235505, -122.442924538729) | ||
| 15615 | 15615 | 30591 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 253 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34560 | ||||||||
| 15314 | 15314 | 30594 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 265 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34562 | ||||||||
| 173679 | 173679 | 30757 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1553 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 11 | Permit Number 34638 | 6014989.6074 | 2093734.2507 | 37.729837877239795 | -122.390455236274 | (37.7298378772398, -122.390455236274) | |
| 98266 | 98266 | 30758 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1557 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34639 | 6014967.84012217 | 2093755.65118605 | 37.7298954311335 | -122.390531983655 | (37.7298954311335, -122.390531983655) | ||
| 138983 | 138983 | 30760 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1571 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34641 | 6014896.23757332 | 2093808.81402101 | 37.7300374330916 | -122.390783237924 | (37.7300374330916, -122.390783237924) | ||
| 97186 | 97186 | 30761 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1575 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34642 | 6014875.77973499 | 2093824.0033781002 | 37.7300780049156 | -122.39085502491999 | (37.7300780049156, -122.39085502492) | ||
| 110661 | 110661 | 30763 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1542 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34644 | 6014903.15895955 | 2093519.78776627 | 37.729244209154295 | -122.39073911946801 | (37.7292442091543, -122.390739119468) | ||
| 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) | |
| 84092 | 84092 | 30931 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 407 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34744 | 5995614.80249177 | 2091194.83311768 | 37.7217714131354 | -122.457252106382 | (37.7217714131354, -122.457252106382) | ||
| 113751 | 113751 | 31059 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 301 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 11 | 3x3 | Permit Number 34810 | 6001654.06728241 | 2086489.02532865 | 37.7091953182451 | -122.43603940951598 | (37.7091953182451, -122.436039409516) |
| 155339 | 155339 | 31136 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 371 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34851 | 5998968.1475599995 | 2094360.3261099998 | 37.730655144717105 | -122.445888061981 | (37.7306551447171, -122.445888061981) | |
| 89405 | 89405 | 31180 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 344 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34878 | 5993129.55455829 | 2089868.58886975 | 37.717986817508 | -122.465746580217 | (37.717986817508, -122.465746580217) | ||
| 180377 | 180377 | 31436 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4336 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 12 | Permit Number 35011 | 6000994.34179 | 2103320.5787299997 | 37.7553733681958 | -122.439525295576 | (37.7553733681958, -122.439525295576) | |
| 55919 | 55919 | 31468 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 523 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 9 | Permit Number 35034 | 6002955.92893 | 2102097.8639599998 | 37.752127528763204 | -122.432654202633 | (37.7521275287632, -122.432654202633) | |
| 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) | |
| 103431 | 103431 | 32273 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | Permit Number 36859 | 5998193.43438826 | 2108958.37890696 | 37.7706935405733 | -122.449617870473 | (37.7706935405733, -122.449617870473) | |||
| 79057 | 79057 | 32274 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 623 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39911 | 6007825.97257693 | 2096019.31993336 | 37.7357121847697 | -122.415382520688 | (37.7357121847697, -122.415382520688) | ||
| 182704 | 182704 | 32332 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 301 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | 12 | Permit Number 36896 | 6006735.75103 | 2098040.81049 | 37.741201412511295 | -122.419295203505 | (37.7412014125113, -122.419295203505) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 122776 | 122776 | 34009 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 18 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39435 | 6007439.60245605 | 2099473.00721902 | 37.7451735210906 | -122.416962980086 | (37.7451735210906, -122.416962980086) | ||
| 44833 | 44833 | 34144 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1754 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39666 | 6003955.69985192 | 2098004.27278913 | 37.740944124338895 | -122.428905023889 | (37.7409441243389, -122.428905023889) | ||
| 95313 | 95313 | 34169 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3738 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39486 | 6005390.32082668 | 2104325.33751818 | 37.758381409843295 | -122.424394116765 | (37.7583814098433, -122.424394116765) | ||
| 154249 | 154249 | 34233 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1690 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1997 12:00:00 AM | 8 | Permit Number 38046 | 5989683.0382 | 2103856.1412 | 37.7561936262155 | -122.47868193754299 | (37.7561936262155, -122.478681937543) | ||
| 168115 | 168115 | 34234 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 475 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1997 12:00:00 AM | 9 | Permit Number 38047 | 6009059.1086 | 2121116.8197 | 37.8046933049163 | -122.41289295806801 | (37.8046933049163, -122.412892958068) | ||
| 91732 | 91732 | 34299 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2460 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38087 | 6009686.14840404 | 2103014.07472331 | 37.7550226229561 | -122.409444639751 | (37.7550226229561, -122.409444639751) | ||
| 106596 | 106596 | 34441 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 75 Swiss Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38185 | 6001277.80934276 | 2096614.82991295 | 37.7369771019142 | -122.43806465824899 | (37.7369771019142, -122.438064658249) | ||
| 89217 | 89217 | 34443 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38187 | 6004317.14831895 | 2097838.60614012 | 37.740509693537504 | -122.427643467723 | (37.7405096935375, -122.427643467723) | ||
| 10474 | 10474 | 34625 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1466 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38307 | 5988697.9248 | 2105373.4338 | 37.76030245534 | -122.482199912019 | (37.76030245534, -122.482199912019) |
| 173732 | 173732 | 34626 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1474 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 0 | Permit Number 38308 | 5988706.220433701 | 2105294.39494794 | 37.760085918568 | -122.48216543102 | (37.760085918568, -122.48216543102) | |
| 102349 | 102349 | 34758 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38402 | 6007966.74070994 | 2102458.08144685 | 37.7533995021275 | -122.415351503246 | (37.7533995021275, -122.415351503246) | |
| 139926 | 139926 | 34898 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 267 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1997 12:00:00 AM | Permit Number 38503 | 6001403.8262241 | 2096433.01440588 | 37.736485044647495 | -122.43761594552299 | (37.7364850446475, -122.437615945523) | |||
| 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) | |||
| 47279 | 47279 | 35103 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 786 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38645 | 6001885.65115289 | 2089265.94057695 | 37.7168332689419 | -122.43543753433399 | (37.7168332689419, -122.435437534334) | ||
| 104807 | 104807 | 35134 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 849 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38664 | 6001545.25839951 | 2089134.40240899 | 37.716452756426 | -122.43660469328 | (37.716452756426, -122.43660469328) | ||
| 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) | |
| 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) | |
| 110851 | 110851 | 35265 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006296.38753209 | 2118756.6266107 | 37.79805735235279 | -122.422285851072 | (37.7980573523528, -122.422285851072) | |
| 56697 | 56697 | 35266 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2323 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | 3x3 | Permit Number 38750 | 6006292.04033 | 2118835.34945 | 37.798273260158 | -122.42230648984699 | (37.798273260158, -122.422306489847) |
| 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) | |
| 81838 | 81838 | 35367 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 619 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | Permit Number 38827 | 6011631.49743277 | 2091601.49478662 | 37.723794911059606 | -122.401914809778 | (37.7237949110596, -122.401914809778) | ||
| 144903 | 144903 | 35368 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 627 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | Permit Number 38828 | 6011631.82829511 | 2091600.41039567 | 37.72379195201 | -122.401913589843 | (37.72379195201, -122.401913589843) | ||
| 85499 | 85499 | 35558 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 801 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38931 | 6005679.14966284 | 2104317.39620731 | 37.7583759105796 | -122.423394653078 | (37.7583759105796, -122.423394653078) | ||
| 102320 | 102320 | 35681 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4521 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2000 12:00:00 AM | Permit Number 41986 | 6000920.86314017 | 2101102.84545022 | 37.749279824800794 | -122.43962042595899 | (37.7492798248008, -122.439620425959) | |||
| 93949 | 93949 | 36079 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2170 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39193 | 6008724.90392173 | 2105792.20395445 | 37.7625968269406 | -122.412965325481 | (37.7625968269406, -122.412965325481) | ||
| 44871 | 44871 | 36124 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1324 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | 10 | Permit Number 39220 | 5988358.7841 | 2106301.1655 | 37.7628300220311 | -122.483440838848 | (37.7628300220311, -122.483440838848) | |
| 1362 | 1362 | 36186 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 133 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 8 | Permit Number 39255 | 5995881.41756 | 2113499.8369 | 37.783030646722004 | -122.45794382331002 | (37.783030646722, -122.45794382331) | |
| 124549 | 124549 | 36508 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 584 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/29/2003 12:00:00 AM | Permit Number 39385 | 6007790.43718065 | 2096197.35426509 | 37.736199030760105 | -122.41551798135401 | (37.7361990307601, -122.415517981354) | ||
| 97900 | 97900 | 36509 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 734 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39386 | 6007727.24180812 | 2095500.96385803 | 37.7342833425639 | -122.41568718150499 | (37.7342833425639, -122.415687181505) | ||
| 92505 | 92505 | 36515 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 263 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39393 | 6006742.46472301 | 2095809.17822197 | 37.735074223818 | -122.41911373442801 | (37.735074223818, -122.419113734428) | ||
| 94212 | 94212 | 36529 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3653 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39401 | 6008503.02776352 | 2097873.6031148 | 37.7408416720866 | -122.413172749536 | (37.7408416720866, -122.413172749536) | ||
| 141051 | 141051 | 36724 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 63 Rondel Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39508 | 6006392.72419267 | 2106420.79209113 | 37.7641915920141 | -122.421076141152 | (37.7641915920141, -122.421076141152) | ||
| 117079 | 117079 | 36725 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 67 Rondel Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39509 | 6006393.67991205 | 2106403.54296873 | 37.764144283858 | -122.42107161074499 | (37.764144283858, -122.421071610745) | ||
| 145514 | 145514 | 36912 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 462 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39558 | 6001795.24469861 | 2103152.27063521 | 37.7549567840787 | -122.436743488368 | (37.7549567840787, -122.436743488368) | ||
| 122125 | 122125 | 36922 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 560 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39566 | 6001824.70318971 | 2102569.45422628 | 37.753358184191704 | -122.436599898251 | (37.7533581841917, -122.436599898251) | ||
| 99531 | 99531 | 37020 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1061 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39632 | 6008655.69574399 | 2102373.47059511 | 37.7532058777371 | -122.412962961361 | (37.7532058777371, -122.412962961361) | ||
| 77700 | 77700 | 37051 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 364 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39656 | 6003583.41460965 | 2098669.49042288 | 37.7427495797017 | -122.43023969551201 | (37.7427495797017, -122.430239695512) | ||
| 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) | |
| 86248 | 86248 | 37317 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 576 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39832 | 6002608.13051852 | 2103294.09534049 | 37.7553923649469 | -122.433942439191 | (37.7553923649469, -122.433942439191) | ||
| 122800 | 122800 | 37408 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1711 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39888 | 6002631.16896948 | 2100601.66569625 | 37.7480008987993 | -122.43367034777599 | (37.7480008987993, -122.433670347776) | ||
| 94512 | 94512 | 37474 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1642 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39945 | 5992805.4256232 | 2104283.42646812 | 37.7575476379464 | -122.467914829169 | (37.7575476379464, -122.467914829169) | ||
| 111164 | 111164 | 37693 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 566 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | Permit Number 40079 | 6007847.07548842 | 2104633.16942482 | 37.7593650704509 | -122.415919346196 | (37.7593650704509, -122.415919346196) | ||
| 112305 | 112305 | 37713 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 879 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | 3x3 | Permit Number 40084 | 6007585.89861945 | 2104551.15151716 | 37.7591251811896 | -122.416816815015 | (37.7591251811896, -122.416816815015) | |
| 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) | ||
| 111062 | 111062 | 37754 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1138 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40101 | 6008628.86236582 | 2101910.8796111 | 37.7519342006623 | -122.413023051242 | (37.7519342006623, -122.413023051242) | ||
| 10290 | 10290 | 37814 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003977.37565 | 2090552.2455 | 37.720483755714 | -122.428299091747 | (37.720483755714, -122.428299091747) |
| 110887 | 110887 | 37852 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 639 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40143 | 6003947.74961722 | 2091786.98448726 | 37.723872400431496 | -122.428489463759 | (37.7238724004315, -122.428489463759) | ||
| 90974 | 90974 | 37857 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 50 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.42496422599702 | (37.7235254489092, -122.424964225997) |
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");