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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141333 | 141333 | 113369 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 999x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x9 | 6009304.0 | 2096928.0 | 37.7382901856605 | -122.41033652541401 | (37.7382901856605, -122.410336525414) | |||
| 37323 | 37323 | 44456 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 95 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | 5 | Permit Number 43779 | 6002571.72829 | 2086874.98861 | 37.710307180311105 | -122.432895389109 | (37.7103071803111, -122.432895389109) | |
| 106055 | 106055 | 95590 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 95 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767380 | 6002599.7 | 2086870.1 | 37.7102953437444 | -122.432798364191 | (37.7102953437444, -122.432798364191) | |
| 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) | ||
| 188761 | 188761 | 220670 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 948 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009928.95694 | 2103687.06035 | 37.7568840925314 | -122.408652407882 | (37.7568840925314, -122.408652407882) | |||
| 47068 | 47068 | 220057 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007984.69118 | 2102236.05472 | 37.752790875909 | -122.41527371052099 | (37.752790875909, -122.415273710521) | |||
| 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) | |
| 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) | ||
| 113450 | 113450 | 64600 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 937 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1988 12:00:00 AM | Permit Number 25502 | 6006331.29758425 | 2104145.47167682 | 37.7579406313954 | -122.42112702568998 | (37.7579406313954, -122.42112702569) | ||
| 53649 | 53649 | 219989 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 936 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998793.85425 | 2106724.38466 | 37.7645938887298 | -122.447380197361 | (37.7645938887298, -122.447380197361) | |||
| 170961 | 170961 | 219988 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 936 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998797.49873 | 2106712.69483 | 37.7645619996538 | -122.447366750686 | (37.7645619996538, -122.447366750686) | |||
| 99215 | 99215 | 64665 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 933 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/1991 12:00:00 AM | Permit Number 25595 | 6006330.05327332 | 2104167.32767008 | 37.7580005727281 | -122.42113288094 | (37.7580005727281, -122.42113288094) | ||
| 63361 | 63361 | 220063 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 930 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003095.90411 | 2102839.48353 | 37.75417177772871 | -122.432223106309 | (37.7541717777287, -122.432223106309) | |||
| 112021 | 112021 | 82779 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 930 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50449 | 6003096.61110421 | 2102822.62624393 | 37.754125531706705 | -122.432219457549 | (37.7541255317067, -122.432219457549) | ||
| 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) | |
| 161597 | 161597 | 220697 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 897 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998695.14565 | 2106960.91022 | 37.7652376872994 | -122.447738631145 | (37.7652376872994, -122.447738631145) | |||
| 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) | |||
| 125571 | 125571 | 220042 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 890 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6000646.62015 | 2102597.34113 | 37.7533677370469 | -122.440675944861 | (37.7533677370469, -122.440675944861) | |||
| 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) | |||
| 185029 | 185029 | 220006 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 887 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007588.24314 | 2104555.6978700003 | 37.75913779629921 | -122.41680902861602 | (37.7591377962992, -122.416809028616) | |||
| 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) | ||
| 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) | |
| 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) | |||
| 103637 | 103637 | 66324 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 88 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1995 12:00:00 AM | Permit Number 29443 | 6000832.40008628 | 2095235.41670142 | 37.733164213776796 | -122.439505779041 | (37.7331642137768, -122.439505779041) | ||
| 91151 | 91151 | 37714 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 879 South Van Ness Ave | 2 | 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) | |
| 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) | |
| 114669 | 114669 | 53682 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 879 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | Permit Number 30735 | 5984157.5341821 | 2109855.55736393 | 37.7723439568609 | -122.49823378959 | (37.7723439568609, -122.49823378959) | ||
| 81874 | 81874 | 65160 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 878 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27140 | 6000731.49768107 | 2102608.84071127 | 37.7534041452721 | -122.440383246008 | (37.7534041452721, -122.440383246008) | ||
| 121196 | 121196 | 65158 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 873 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27138 | 6000770.17128477 | 2102558.89498752 | 37.7532692083278 | -122.440245923397 | (37.7532692083278, -122.440245923397) | ||
| 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) | |
| 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) | ||
| 42577 | 42577 | 139655 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 848 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000491.15 | 2111934.8144 | 37.7789972619427 | -122.441883720544 | (37.7789972619427, -122.441883720544) | |||
| 92979 | 92979 | 66117 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 840 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29176 | 6003830.73518673 | 2110784.28562667 | 37.77602792540829 | -122.430248650411 | (37.7760279254083, -122.430248650411) | ||
| 137659 | 137659 | 64510 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 838 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 12 | Permit Number 25391 | 6000497.2416 | 2111874.2369 | 37.778831278686496 | -122.441858298358 | (37.7788312786865, -122.441858298358) | |
| 149284 | 149284 | 64511 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 833 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 11 | Permit Number 25392 | 6000435.9873 | 2111865.4379 | 37.7788036283278 | -122.442069568781 | (37.7788036283278, -122.442069568781) | |
| 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) | ||
| 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) | ||
| 122894 | 122894 | 66111 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 830 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29166 | 6003876.46719342 | 2110790.67622638 | 37.776048062614 | -122.43009090735501 | (37.776048062614, -122.430090907355) | ||
| 94027 | 94027 | 64512 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 830 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | Permit Number 25393 | 6000501.90082075 | 2111793.8331913003 | 37.7786107760856 | -122.441836408094 | (37.7786107760856, -122.441836408094) | ||
| 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) | ||
| 106606 | 106606 | 66114 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 829 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29169 | 6003892.81016511 | 2110740.45474073 | 37.775911092379495 | -122.43003078932101 | (37.7759110923795, -122.430030789321) | ||
| 102450 | 102450 | 67937 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 82 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31650 | 6004338.16538286 | 2095684.17990183 | 37.734595316364796 | -122.427417358908 | (37.7345953163648, -122.427417358908) | ||
| 112524 | 112524 | 65155 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 819 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27134 | 6001092.45713826 | 2102576.67307125 | 37.7533363665416 | -122.439132669576 | (37.7533363665416, -122.439132669576) | ||
| 135076 | 135076 | 220039 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 819 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6001009.04844 | 2102577.7533400003 | 37.7533345862464 | -122.439421190941 | (37.7533345862464, -122.439421190941) | |||
| 88842 | 88842 | 66113 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 818 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29168 | 6003931.34560658 | 2110798.34494674 | 37.7760722269843 | -122.429901615557 | (37.7760722269843, -122.429901615557) | ||
| 60147 | 60147 | 220040 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 816 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6001002.40026 | 2102614.77247 | 37.7534358534934 | -122.439446835117 | (37.7534358534934, -122.439446835117) | |||
| 120080 | 120080 | 44452 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 81 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2003 12:00:00 AM | 3 | Permit Number 43778 | 6002608.3273599995 | 2086901.1112400002 | 37.710380983162395 | -122.43277076016399 | (37.7103809831624, -122.432770760164) | ||
| 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) | |
| 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) | ||
| 45041 | 45041 | 188518 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 805 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011322.68807 | 2104548.86682 | 37.75932838242 | -122.403892982475 | (37.75932838242, -122.403892982475) | |||
| 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) | |||
| 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) | ||
| 144563 | 144563 | 35559 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 801 Guerrero St | 2 | 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) | ||
| 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) | |||
| 171472 | 171472 | 219996 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 80 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007954.3059 | 2099409.5241799997 | 37.7450281501379 | -122.415178725923 | (37.7450281501379, -122.415178725923) | |||
| 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) | ||
| 77653 | 77653 | 109672 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 798x GRAFTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994496.0 | 2090624.0 | 37.72013972186421 | -122.461078132621 | (37.7201397218642, -122.461078132621) | ||||
| 97305 | 97305 | 109671 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 798x GRAFTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994496.0 | 2090624.0 | 37.72013972186421 | -122.461078132621 | (37.7201397218642, -122.461078132621) | ||||
| 103976 | 103976 | 98341 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 790X 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5992573.13535 | 2110349.8527 | 37.7741910183852 | -122.469159688197 | (37.7741910183852, -122.469159688197) | |||
| 125899 | 125899 | 98340 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 790X 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5992573.13535 | 2110349.8527 | 37.7741910183852 | -122.469159688197 | (37.7741910183852, -122.469159688197) | |||
| 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) | ||
| 37452 | 37452 | 140100 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 785 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999576.3959 | 2111131.7395 | 37.7767400570235 | -122.44499046488501 | (37.7767400570235, -122.444990464885) | |||
| 40035 | 40035 | 220081 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 780 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003049.24321 | 2103668.76893 | 37.756446152387795 | -122.432443698342 | (37.7564461523878, -122.432443698342) | |||
| 133605 | 133605 | 220082 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 780 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003052.51993 | 2103630.15774 | 37.7563403210743 | -122.43242960863701 | (37.7563403210743, -122.432429608637) | |||
| 185200 | 185200 | 220017 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 78 Berkeley Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001185.230140001 | 2097348.08527 | 37.7389851844145 | -122.438437264296 | (37.7389851844145, -122.438437264296) | |||
| 35471 | 35471 | 140101 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 771 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999584.517999999 | 2111094.1746 | 37.7766373769699 | -122.44495966716002 | (37.7766373769699, -122.44495966716) | |||
| 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) | ||
| 188143 | 188143 | 220086 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 77 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001721.7342 | 2105412.03314 | 37.761157366929204 | -122.43715949493601 | (37.7611573669292, -122.437159494936) | |||
| 101308 | 101308 | 43731 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 766 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43368 | 5994373.49554275 | 2089956.67715953 | 37.7183003625969 | -122.461453233071 | (37.7183003625969, -122.461453233071) | ||
| 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) | ||
| 142422 | 142422 | 70953 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 76 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2008 12:00:00 AM | 3x3 | Permit Number 50393 | 5992532.60289704 | 2098624.81220808 | 37.7419947820759 | -122.468446668857 | (37.7419947820759, -122.468446668857) | ||
| 173115 | 173115 | 203638 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 750 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994537.11563 | 2090599.0913099998 | 37.720073694513104 | -122.46093420637101 | (37.7200736945131, -122.460934206371) | |||
| 122870 | 122870 | 61325 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 750 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/1984 12:00:00 AM | Permit Number 21228 | 5999633.66350661 | 2111045.76132591 | 37.77650725122871 | -122.44478617828301 | (37.7765072512287, -122.444786178283) | ||
| 75193 | 75193 | 139501 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 750 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999619.0371 | 2111147.3069 | 37.7767852347068 | -122.444844076108 | (37.7767852347068, -122.444844076108) | |||
| 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) | ||
| 101981 | 101981 | 41993 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 75 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42333 | 5993572.90365136 | 2093435.37616672 | 37.7278059137082 | -122.46447296226299 | (37.7278059137082, -122.464472962263) | ||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||
| 95514 | 95514 | 63606 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 717 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1987 12:00:00 AM | Permit Number 24243 | 5999597.4131629 | 2110926.64814812 | 37.7761781281102 | -122.444903013727 | (37.7761781281102, -122.444903013727) | ||
| 139750 | 139750 | 39894 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 715 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1999 12:00:00 AM | Permit Number 41176 | 5999001.16721708 | 2108236.78492637 | 37.7687584031098 | -122.44677199136801 | (37.7687584031098, -122.446771991368) | |||
| 124589 | 124589 | 43381 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 706 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43129 | 6001854.12345529 | 2102032.01903245 | 37.7518841875031 | -122.43645969424101 | (37.7518841875031, -122.436459694241) | ||
| 126154 | 126154 | 43380 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 700 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43128 | 6001853.17321705 | 2102048.95584272 | 37.751930637944 | -122.43646419239201 | (37.751930637944, -122.436464192392) | ||
| 90373 | 90373 | 64794 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 700 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25792 | 6001971.04512503 | 2100046.68918075 | 37.7464395858784 | -122.435913321642 | (37.7464395858784, -122.435913321642) | ||
| 47237 | 47237 | 220016 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Quartz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998965.77386 | 2099787.09557 | 37.74555562500829 | -122.44628649854201 | (37.7455556250083, -122.446286498542) | |||
| 67963 | 67963 | 220015 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Quartz Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998973.5201 | 2099794.49518 | 37.745576384946 | -122.44626024553601 | (37.745576384946, -122.446260245536) | |||
| 149197 | 149197 | 203647 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Manor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5993596.72892 | 2093377.0999599998 | 37.7276472749004 | -122.46438636913099 | (37.7276472749004, -122.464386369131) | |||
| 126007 | 126007 | 66174 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 70 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | Permit Number 29247 | 6009314.15806324 | 2097044.09702117 | 37.738609532336504 | -122.41030959858699 | (37.7386095323365, -122.410309598587) | ||
| 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) | ||
| 96769 | 96769 | 36919 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 699 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39565 | 6001900.0 | 2102596.0 | 37.7534353511669 | -122.43634140628299 | (37.7534353511669, -122.436341406283) | ||
| 127101 | 127101 | 36920 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 699 Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39565 | 6001900.0 | 2102596.0 | 37.7534353511669 | -122.43634140628299 | (37.7534353511669, -122.436341406283) | ||
| 45390 | 45390 | 220087 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 69 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001718.50654 | 2105457.8427 | 37.7612829653482 | -122.437173938027 | (37.7612829653482, -122.437173938027) | |||
| 38287 | 38287 | 220026 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001902.38031 | 2102621.8344 | 37.753506421492 | -122.436335023459 | (37.753506421492, -122.436335023459) | |||
| 129705 | 129705 | 220028 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001938.58535 | 2102624.90259 | 37.7535169030985 | -122.436210038379 | (37.7535169030985, -122.436210038379) | |||
| 130349 | 130349 | 220027 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001922.66093 | 2102622.7782400004 | 37.7535101653675 | -122.43626495635701 | (37.7535101653675, -122.436264956357) | |||
| 123969 | 123969 | 38333 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 684 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | Permit Number 40387 | 6006701.38591008 | 2112874.96361955 | 37.7819305989802 | -122.420466726707 | (37.7819305989802, -122.420466726707) | |||
| 123373 | 123373 | 51248 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 684 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47625 | 6007471.15651424 | 2105682.67696043 | 37.7622256337552 | -122.417293833991 | (37.7622256337552, -122.417293833991) |
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");