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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 117 | 117 | 220007 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 929 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/12/2015 03:22:00 PM | 1 | Width 3ft | Permit Number 24134 | 6006336.25046 | 2104153.4311599997 | 37.7579627654961 | -122.421110461684 | (37.7579627654961, -122.421110461684) | |
| 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) | ||
| 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) | |
| 1434 | 1434 | 20063 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 1536 | 1536 | 251472 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Hiliritas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780012 | 6001589.0 | 2096875.0 | 37.7377091611847 | -122.437007355935 | (37.7377091611847, -122.437007355935) | |
| 1815 | 1815 | 71427 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1852 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2017 12:00:00 AM | 3 | 4x4 | 6009993.7542 | 2120480.0499 | 37.802997311571104 | -122.409613538987 | (37.8029973115711, -122.409613538987) | |
| 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) | ||
| 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) | ||
| 2637 | 2637 | 37816 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 4 | 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 | 6003955.6668300005 | 2090537.19552 | 37.720441203374 | -122.428373060073 | (37.720441203374, -122.428373060073) |
| 2638 | 2638 | 37832 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48867 | 6003860.1558 | 2090386.44981 | 37.7200218836872 | -122.42869247048 | (37.7200218836872, -122.42869247048) |
| 2661 | 2661 | 37833 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003832.66245 | 2090342.4611400003 | 37.719899544415604 | -122.428784371324 | (37.7198995444156, -122.428784371324) |
| 2852 | 2852 | 215287 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | Permit Number 780412 | 5992944.71929 | 2103190.50616 | 37.7545548052666 | -122.46735363008301 | (37.7545548052666, -122.467353630083) | ||
| 3060 | 3060 | 203634 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 432 Flood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 11 | Width 2ft | Permit Number 42544 | 5997859.0322900005 | 2094116.10367 | 37.7299211747225 | -122.449704832412 | (37.7299211747225, -122.449704832412) | |
| 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 | ||||||||
| 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) | ||
| 4165 | 4165 | 253615 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006221.0 | 2118816.0 | 37.7982161239914 | -122.422550935399 | (37.7982161239914, -122.422550935399) | ||
| 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) | ||||
| 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 | ||||||||
| 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) | |||
| 5920 | 5920 | 139500 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 748 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 5999620.0523 | 2111133.4316 | 37.776747194618395 | -122.44483956661199 | (37.7767471946184, -122.444839566612) | ||||
| 6724 | 6724 | 102771 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1438 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6006063.66154 | 2119354.00796 | 37.7996844799161 | -122.42313363592501 | (37.7996844799161, -122.423133635925) | |||
| 6851 | 6851 | 20056 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 7439 | 7439 | 19729 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY14 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 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) | ||||
| 7770 | 7770 | 20060 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
| 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) | ||
| 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) | ||
| 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 | ||||||||
| 8970 | 8970 | 10634 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 830 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003840.507 | 2110782.2115 | 37.7760227838468 | -122.43021469913201 | (37.7760227838468, -122.430214699132) | ||
| 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) | ||
| 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) |
| 10291 | 10291 | 19793 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY19 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 20ST | ||||||||
| 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) |
| 11185 | 11185 | 20057 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 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) | |||
| 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) | |
| 12807 | 12807 | 17229 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1880X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6000980.939130001 | 2091103.3398799999 | 37.7218269300432 | -122.438696258244 | (37.7218269300432, -122.438696258244) | |||
| 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) |
| 13900 | 13900 | 102846 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 29 Guy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 1x1 | 6014262.35987 | 2114356.78408 | 37.786422526635604 | -122.394412832193 | (37.7864225266356, -122.394412832193) | |||
| 15210 | 15210 | 20061 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
| 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 | ||||||||
| 15394 | 15394 | 20062 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 16172 | 16172 | 20064 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 16814 | 16814 | 105175 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1601X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 10 | 3x3 | 6015153.3918 | 2095715.6028 | 37.735287354242395 | -122.390027366589 | (37.7352873542424, -122.390027366589) | |||
| 16839 | 16839 | 20059 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
| 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) | ||
| 18568 | 18568 | 39703 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41088 | 5998596.64163755 | 2094795.02743762 | 37.7318275120035 | -122.44720368280001 | (37.7318275120035, -122.4472036828) | ||
| 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) | ||
| 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) | ||
| 19697 | 19697 | 85509 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 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) |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 21499 | 21499 | 24820 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 05/22/2008 12:00:00 AM | 12 | 3x3 | 6007910.58435 | 2094958.48618 | 37.732804121515606 | -122.415014921609 | (37.7328041215156, -122.415014921609) | ||
| 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) | ||
| 22043 | 22043 | 859 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6008091.178180001 | 2095049.40427 | 37.7330639095777 | -122.41439699202299 | (37.7330639095777, -122.414396992023) | |||
| 22329 | 22329 | 248977 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 748 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999650.0 | 2111146.0 | 37.7767834132689 | -122.444736872581 | (37.7767834132689, -122.444736872581) | ||||
| 23355 | 23355 | 76748 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1501X 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 7 | 3x12 | 5983093.5463 | 2104693.1195 | 37.7581069307926 | -122.501532189631 | (37.7581069307926, -122.501532189631) | |
| 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) | |||
| 24164 | 24164 | 54840 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 236 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | 6 | 3x3 | Permit Number 10695 | 5998822.5685 | 2109866.5256 | 37.77322305193879 | -122.447507074191 | (37.7732230519388, -122.447507074191) |
| 24187 | 24187 | 142264 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 575 LINDEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004642.0376 | 2110688.0426 | 37.775809585078896 | -122.427435282317 | (37.7758095850789, -122.427435282317) | |||
| 24270 | 24270 | 188526 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1427x Innes Ave | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6016254.90623 | 2096663.3838099998 | 37.7379507994938 | -122.386285047323 | (37.7379507994938, -122.386285047323) | ||||
| 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) | |||
| 25195 | 25195 | 203226 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1575 07th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5993976.59011 | 2104728.66377 | 37.7588377051234 | -122.463896818678 | (37.7588377051234, -122.463896818678) | |||
| 25432 | 25432 | 220094 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 436 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6003910.2005900005 | 2096060.2503799999 | 37.735603706528394 | -122.42892377971 | (37.7356037065284, -122.42892377971) | |||
| 25501 | 25501 | 141630 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1801 GROVE ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999025.3732 | 2110414.9246 | 37.774740403045996 | -122.446845016858 | (37.774740403046, -122.446845016858) | |||
| 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) | |||
| 26281 | 26281 | 220668 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 680 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007462.21417 | 2105696.0479 | 37.762261844143296 | -122.417325709834 | (37.7622618441433, -122.417325709834) | |||
| 26472 | 26472 | 220689 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 119 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004994.550369999 | 2099284.37518 | 37.744517739909 | -122.42540413451401 | (37.744517739909, -122.425404134514) | |||
| 26644 | 26644 | 48033 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 61 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2002 12:00:00 AM | Permit Number 45754 | 6001724.06677399 | 2105480.90222389 | 37.761346597247794 | -122.437156358638 | (37.7613465972478, -122.437156358638) | |||
| 26908 | 26908 | 219997 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 80 Stoneman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007927.7529 | 2099409.5439400002 | 37.7450267121064 | -122.41527054312 | (37.7450267121064, -122.41527054312) | |||
| 27343 | 27343 | 203223 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 25 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994463.96401 | 2093754.2883099997 | 37.7287328942013 | -122.461415680898 | (37.7287328942013, -122.461415680898) | |||
| 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) | |
| 27735 | 27735 | 38051 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2700 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 0 | Permit Number 40248 | 6000571.40891222 | 2114495.1875696997 | 37.786031962456896 | -122.44178988005899 | (37.7860319624569, -122.441789880059) | |
| 28541 | 28541 | 220690 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 330 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003721.786040001 | 2099258.64688 | 37.7443751038286 | -122.42980326002 | (37.7443751038286, -122.42980326002) | |||
| 29829 | 29829 | 115807 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 742 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5999623.0981 | 2111117.8642 | 37.7767046243395 | -122.444827911038 | (37.7767046243395, -122.444827911038) | |||
| 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) | |
| 30672 | 30672 | 220054 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 300 Virginia Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6006920.61613 | 2098340.82095 | 37.742035584087795 | -122.418677274846 | (37.7420355840878, -122.418677274846) | |||
| 30832 | 30832 | 203666 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 123 Detroit St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5999405.93855 | 2093561.74161 | 37.728487406244604 | -122.44431719010001 | (37.7284874062446, -122.4443171901) | |||
| 30888 | 30888 | 42696 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1751 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42713 | 6007796.58473 | 2118447.48214 | 37.7972930261196 | -122.417072803384 | (37.7972930261196, -122.417072803384) | |
| 31248 | 31248 | 220041 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 890 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6000667.40596 | 2102598.56375 | 37.7533722777334 | -122.440604151054 | (37.7533722777334, -122.440604151054) | |||
| 31368 | 31368 | 40190 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 600 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008992.69015 | 2093809.01989 | 37.729708681998 | -122.411192625738 | (37.729708681998, -122.411192625738) | ||
| 31523 | 31523 | 188515 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1401 25th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6014455.23285 | 2101981.54762 | 37.752453585184604 | -122.39287941707799 | (37.7524535851846, -122.392879417078) | ||||
| 31678 | 31678 | 137728 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1989 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999638.3271 | 2111189.9480000003 | 37.77690341710429 | -122.444780412241 | (37.7769034171043, -122.444780412241) | |||
| 31819 | 31819 | 220062 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 College Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6005376.5701 | 2095055.5296099999 | 37.7329278583224 | -122.423782556133 | (37.7329278583224, -122.423782556133) | |||
| 32234 | 32234 | 220023 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 89 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6001002.01011 | 2101166.3716 | 37.749458870636396 | -122.439344371761 | (37.7494588706364, -122.439344371761) | |||
| 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) | |||
| 32571 | 32571 | 69145 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2419 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | 6 | Permit Number 33179 | 5983608.7607 | 2098659.5816 | 37.741570751884 | -122.499304541285 | (37.741570751884, -122.499304541285) | |
| 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) | |||
| 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) | |
| 33112 | 33112 | 220001 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 88 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006158.19776 | 2097552.9133 | 37.7398292116563 | -122.4212575422 | (37.7398292116563, -122.4212575422) | |||
| 33288 | 33288 | 220075 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 311 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001146.06945 | 2104525.9934099996 | 37.758691778412704 | -122.43908696419201 | (37.7586917784127, -122.439086964192) | |||
| 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) | |||
| 33499 | 33499 | 174962 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 114 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000450.3974 | 2092235.26707 | 37.724904747337106 | -122.440611347459 | (37.7249047473371, -122.440611347459) | |||
| 33547 | 33547 | 137666 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1901 GOLDEN GATE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000398.0082 | 2111639.7629 | 37.7781818179135 | -122.442184748811 | (37.7781818179135, -122.442184748811) | |||
| 33826 | 33826 | 184961 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1990 41st Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5983548.8239 | 2101628.2630000003 | 37.7497184185455 | -122.4997311455 | (37.7497184185455, -122.4997311455) |
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");