Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3545 | 3545 | 43015 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 7991 | 7991 | 38232 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 9590 | 9590 | 34067 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 12244 | 12244 | 45154 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1683 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2001 12:00:00 AM | Permit Number 44007 | ||||||||
| 125703 | 125703 | 69447 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 479 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | Permit Number 33557 | 5985917.32246977 | 2112668.61009419 | 37.7801708274431 | -122.492353790965 | (37.7801708274431, -122.492353790965) | ||
| 169492 | 169492 | 122086 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 459 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990589.9425800005 | 2112248.5519999997 | 37.7792895311955 | -122.47615854280599 | (37.7792895311955, -122.476158542806) | |||
| 186145 | 186145 | 81695 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 539 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52514 | 5990609.143069999 | 2111709.86868 | 37.7778115687685 | -122.476052767078 | (37.7778115687685, -122.476052767078) | |
| 83663 | 83663 | 60140 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1807 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19670 | 5991211.56683637 | 2103102.96288703 | 37.7542142276367 | -122.473340885597 | (37.7542142276367, -122.473340885597) | ||
| 117714 | 117714 | 60139 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1825 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19669 | 5991215.553912099 | 2102985.82371421 | 37.753892825076704 | -122.473318554461 | (37.7538928250767, -122.473318554461) | ||
| 113742 | 113742 | 35091 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 920 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 15 | 3x3 | Permit Number 42238 | 5992055.93239281 | 2105259.4330846 | 37.760184186645105 | -122.47057793992701 | (37.7601841866451, -122.470577939927) |
| 66025 | 66025 | 69088 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1474 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33098 | 5992145.68632685 | 2105413.48754834 | 37.7606123691548 | -122.47027874523701 | (37.7606123691548, -122.470278745237) | ||
| 116480 | 116480 | 94704 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 670 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53844 | 5992265.910069999 | 2110887.9473900003 | 37.7756507238334 | -122.470261618584 | (37.7756507238334, -122.470261618584) |
| 185667 | 185667 | 70154 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 339 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1993 12:00:00 AM | 9 | 5992446.53753 | 2113177.4125 | 37.7819474134806 | -122.469803511026 | (37.7819474134806, -122.469803511026) | ||
| 163455 | 163455 | 82278 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 245 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50610 | 5992733.47806 | 2113805.1753 | 37.783687659814795 | -122.46885653402398 | (37.7836876598148, -122.468856534024) | |
| 153095 | 153095 | 219000 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1775 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 3ft | 5992776.7043 | 2103406.16926 | 37.7551372592989 | -122.467950350926 | (37.7551372592989, -122.467950350926) | |||
| 31692 | 31692 | 219005 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1838 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5992852.04405 | 2102933.06242 | 37.7538425808737 | -122.467655401194 | (37.7538425808737, -122.467655401194) | |||
| 126970 | 126970 | 49877 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1331@ IRVING 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2003 12:00:00 AM | Permit Number 46643 | 5992989.81423972 | 2106408.90402865 | 37.763394289018294 | -122.467431700246 | (37.7633942890183, -122.467431700246) | |||
| 181764 | 181764 | 219002 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1333 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5992990.51198 | 2106402.84909 | 37.7633777040321 | -122.46742884668501 | (37.7633777040321, -122.467428846685) | |||
| 43658 | 43658 | 123212 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 462 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5993143.5323 | 2112325.5219 | 37.7796486158053 | -122.467330287378 | (37.7796486158053, -122.467330287378) | |||
| 26692 | 26692 | 219004 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1655 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5993378.4627 | 2104217.9895 | 37.7574010390349 | -122.46592829725 | (37.7574010390349, -122.46592829725) | |||
| 35910 | 35910 | 219003 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1461 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993948.08517 | 2105555.3752599997 | 37.7611059976579 | -122.464055414128 | (37.7611059976579, -122.464055414128) | |||
| 109039 | 109039 | 46907 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1461 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44964 | 5993949.00931755 | 2105566.46922701 | 37.7611365120681 | -122.464053023285 | (37.7611365120681, -122.464053023285) | ||
| 36158 | 36158 | 65448 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 72 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/1989 12:00:00 AM | 9 | Permit Number 28322 | 5994279.76671 | 2115099.7417900003 | 37.7873314010144 | -122.46360098807399 | (37.7873314010144, -122.463600988074) | ||
| 28449 | 28449 | 113387 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 185 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5994493.0 | 2100782.0 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | ||||
| 72606 | 72606 | 219001 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1225 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994518.05416 | 2107169.56941 | 37.7655709877426 | -122.46220122250799 | (37.7655709877426, -122.462201222508) | |||
| 19692 | 19692 | 65477 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 400 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1989 12:00:00 AM | Permit Number 28358 | 5994782.15079154 | 2091255.17859292 | 37.7218892499679 | -122.46013471597601 | (37.7218892499679, -122.460134715976) | ||
| 78037 | 78037 | 102652 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 203X Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.45920967451401 | (37.7139992025898, -122.459209674514) | |||||
| 9820 | 9820 | 46927 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 77679 | 77679 | 73660 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 157 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2013 12:00:00 AM | 15 | Permit Number 770522 | 5995314.794096599 | 2090940.29616255 | 37.72105528015361 | -122.45827073660101 | (37.7210552801536, -122.458270736601) | ||
| 30003 | 30003 | 219010 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 157 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995318.0566300005 | 2090927.8253099998 | 37.7210212256375 | -122.458258556898 | (37.7210212256375, -122.458258556898) | |||
| 47738 | 47738 | 219007 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 207 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995325.396369999 | 2091321.08064 | 37.7221014328296 | -122.45826163439501 | (37.7221014328296, -122.458261634395) | |||
| 185820 | 185820 | 219006 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 221 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995326.9231199995 | 2091423.0850799999 | 37.7223816004164 | -122.458263736089 | (37.7223816004164, -122.458263736089) | |||
| 43253 | 43253 | 219013 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995360.7073099995 | 2090920.7561700002 | 37.721004266213 | -122.458110615707 | (37.721004266213, -122.458110615707) | |||
| 172811 | 172811 | 219015 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 178 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995362.975 | 2091073.5801900001 | 37.7214240148917 | -122.458113831693 | (37.7214240148917, -122.458113831693) | |||
| 106266 | 106266 | 65468 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 55 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1989 12:00:00 AM | Permit Number 28348 | 5995598.18541989 | 2090265.07086982 | 37.7192175521634 | -122.457242320925 | (37.7192175521634, -122.457242320925) | ||
| 186176 | 186176 | 141447 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 196 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5996894.8261 | 2111600.0306 | 37.7778724506652 | -122.454300593509 | (37.7778724506652, -122.454300593509) | |||
| 128826 | 128826 | 41155 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 21 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | Permit Number 41884 | 5997452.09163541 | 2113544.02640038 | 37.7832420947214 | -122.452513152989 | (37.7832420947214, -122.452513152989) | |||
| 167039 | 167039 | 140156 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2155 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997581.2766 | 2109865.28 | 37.7731486172497 | -122.451800756951 | (37.7731486172497, -122.451800756951) | |||
| 103290 | 103290 | 62468 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 400 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2011 12:00:00 AM | Permit Number 767707 | 5997942.58905548 | 2109236.69156954 | 37.7714433619175 | -122.45050561148199 | (37.7714433619175, -122.450505611482) | |||
| 4219 | 4219 | 244047 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 400 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997955.5586 | 2109119.1735 | 37.771121429752895 | -122.450452276113 | (37.7711214297529, -122.450452276113) | |||
| 131682 | 131682 | 225928 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1106 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998173.76607 | 2106499.88804 | 37.763942024132206 | -122.44950872894199 | (37.7639420241322, -122.449508728942) | |||
| 129311 | 129311 | 94960 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 20 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998206.0 | 2108519.0 | 37.7694878371786 | -122.44954274107599 | (37.7694878371786, -122.449542741076) | ||||
| 56399 | 56399 | 219016 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 23 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998493.11217 | 2097521.42795 | 37.7393076426268 | -122.447757806504 | (37.7393076426268, -122.447757806504) | |||
| 107237 | 107237 | 65670 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 954 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28590 | 5998557.99448518 | 2095716.03586207 | 37.7343541747365 | -122.44740356075899 | (37.7343541747365, -122.447403560759) | ||
| 109428 | 109428 | 85304 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 417 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2007 12:00:00 AM | Permit Number 49590 | 5998857.0 | 2109314.0 | 37.7717079252645 | -122.44734819583599 | (37.7717079252645, -122.447348195836) | |||
| 71189 | 71189 | 107181 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1520 PAGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6x9 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.44624140323401 | (37.7711622584795, -122.446241403234) | |||
| 184487 | 184487 | 247270 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1520 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999196.9373 | 2109093.7955 | 37.7711227186713 | -122.446156493551 | (37.7711227186713, -122.446156493551) | |||
| 129531 | 129531 | 59939 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1778 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 1 | Permit Number 19412 | 5999341.88585809 | 2110158.12282899 | 37.7740533674999 | -122.44573166712699 | (37.7740533674999, -122.445731667127) | |
| 106631 | 106631 | 59938 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1774 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | Permit Number 19411 | 5999360.65261909 | 2110160.72458075 | 37.774061582719895 | -122.44566693704701 | (37.7740615827199, -122.445666937047) | ||
| 178195 | 178195 | 59936 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1757 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 14 | Permit Number 19409 | 5999437.2024 | 2110127.1563 | 37.773973782951295 | -122.44539972496 | (37.7739737829513, -122.44539972496) | |
| 56106 | 56106 | 59935 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1743 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 12 | Permit Number 19408 | 5999522.2814 | 2110138.642 | 37.774010176161106 | -122.445106249319 | (37.7740101761611, -122.445106249319) | |
| 141249 | 141249 | 59937 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1738 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 19410 | 5999529.55338039 | 2110184.14033447 | 37.7741355180618 | -122.44508436599199 | (37.7741355180618, -122.445084365992) | ||
| 65348 | 65348 | 142345 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1736 HAYES ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5999542.2107 | 2110186.9275 | 37.7741438933316 | -122.445040782661 | (37.7741438933316, -122.445040782661) | |||
| 46231 | 46231 | 59941 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1706 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 0 | Permit Number 19415 | 5999632.27517388 | 2110547.02087839 | 37.7751377580465 | -122.444755123369 | (37.7751377580465, -122.444755123369) | |
| 133410 | 133410 | 59942 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 625 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 13 | Permit Number 19416 | 5999638.7469 | 2110673.4971 | 37.775485398815796 | -122.444741829234 | (37.7754853988158, -122.444741829234) | |
| 28224 | 28224 | 48556 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 615 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/23/2002 12:00:00 AM | 3 | Permit Number 45872 | 5999645.29400405 | 2110579.50430317 | 37.7752276921804 | -122.444712423834 | (37.7752276921804, -122.444712423834) | |
| 70095 | 70095 | 59933 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 549 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 9 | Permit Number 19406 | 5999664.8686 | 2110448.6759 | 37.77486958773171 | -122.444635305779 | (37.7748695877317, -122.444635305779) | |
| 161894 | 161894 | 59931 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 521 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 12 | Permit Number 19403 | 5999683.6559 | 2110322.5324 | 37.7745243018378 | -122.444561248652 | (37.7745243018378, -122.444561248652) | |
| 160115 | 160115 | 59914 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 409 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1981 12:00:00 AM | 12 | Permit Number 19383 | 5999728.7839 | 2110019.0941 | 37.773693712339 | -122.444383331369 | (37.773693712339, -122.444383331369) | |
| 158310 | 158310 | 142337 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 500 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999743.369 | 2110239.8651 | 37.774300725553005 | -122.44434874808998 | (37.774300725553, -122.44434874809) | |||
| 154604 | 154604 | 116598 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 454 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x4 | 5999760.624 | 2110077.6149 | 37.7738562121972 | -122.444277398119 | (37.7738562121972, -122.444277398119) | |||
| 176344 | 176344 | 142206 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1693 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999789.089 | 2110173.0386 | 37.7741198453954 | -122.444185791724 | (37.7741198453954, -122.444185791724) | |||
| 117939 | 117939 | 67684 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 312 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1992 12:00:00 AM | 3.5x6 | Permit Number 31288 | 6000001.77226965 | 2094984.07917219 | 37.7324267912213 | -122.44235943700701 | (37.7324267912213, -122.442359437007) | ||
| 35324 | 35324 | 245162 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1308 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000247.8581 | 2109240.6853 | 37.7715860006418 | -122.44253187989901 | (37.7715860006418, -122.442531879899) | |||
| 10930 | 10930 | 109686 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 190 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772797 | 6000260.82873 | 2091434.8524 | 37.7226961949641 | -122.441209260793 | (37.7226961949641, -122.441209260793) |
| 79458 | 79458 | 45143 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1306 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43999 | 6000301.66695276 | 2109252.99284462 | 37.7716228610878 | -122.442346636259 | (37.7716228610878, -122.442346636259) | ||
| 83461 | 83461 | 32486 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 212 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36993 | 6000839.718784099 | 2106514.92813142 | 37.764135468546904 | -122.440289096409 | (37.7641354685469, -122.440289096409) | ||
| 77013 | 77013 | 56360 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2100 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | 30 | Permit Number 12506 | 6000958.47841613 | 2115569.02150374 | 37.7890024802988 | -122.440527774143 | (37.7890024802988, -122.440527774143) | |
| 27127 | 27127 | 225952 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 800 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001178.257669999 | 2102625.59939 | 37.753475588250396 | -122.438839459988 | (37.7534755882504, -122.438839459988) | |||
| 73383 | 73383 | 225950 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 646 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001193.5542 | 2102647.97152 | 37.7535378869843 | -122.438788164466 | (37.7535378869843, -122.438788164466) | |||
| 130418 | 130418 | 225976 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 348 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001460.81775 | 2103733.76138 | 37.7565344055496 | -122.437941677576 | (37.7565344055496, -122.437941677576) | |||
| 134760 | 134760 | 225975 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 4337 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001561.548219999 | 2104657.76141 | 37.7590772134726 | -122.437659488305 | (37.7590772134726, -122.437659488305) | |||
| 29018 | 29018 | 247759 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 75 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001668.74952 | 2108376.80716 | 37.7692948959648 | -122.437555068929 | (37.7692948959648, -122.437555068929) | |||
| 92783 | 92783 | 50169 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 89@ DUBOCE Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2003 12:00:00 AM | Permit Number 46880 | 6001684.35285968 | 2108342.8233287 | 37.7692024719005 | -122.437498663894 | (37.7692024719005, -122.437498663894) | |||
| 78703 | 78703 | 105804 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 117 ALPINE TER | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/10/2014 12:00:00 AM | 14 | 3x3 | Permit Number 772090 | 6001724.2 | 2108149.5 | 37.7686739192463 | -122.437346990121 | (37.7686739192463, -122.437346990121) | |
| 162647 | 162647 | 47473 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2713 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 3 | Permit Number 45374 | 6001758.37714 | 2115982.9514900004 | 37.790184540925395 | -122.43778989361601 | (37.7901845409254, -122.437789893616) | |
| 109049 | 109049 | 38842 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1273 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 40672 | 6001780.14804372 | 2110445.45784357 | 37.7749812288155 | -122.437317892677 | (37.7749812288155, -122.437317892677) | ||||
| 97711 | 97711 | 62524 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 342 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38698 | 6002273.08197673 | 2109652.09551148 | 37.7728308633198 | -122.43555596174299 | (37.7728308633198, -122.435555961743) | ||
| 121878 | 121878 | 67769 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3668 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1992 12:00:00 AM | Permit Number 31399 | 6002481.45062456 | 2106510.50272194 | 37.7642166536125 | -122.43461051210501 | (37.7642166536125, -122.434610512105) | ||
| 65167 | 65167 | 225973 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 478 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002948.31867 | 2105450.2559599997 | 37.761331964925 | -122.432919999069 | (37.761331964925, -122.432919999069) | |||
| 76670 | 76670 | 225926 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 448 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002953.29528 | 2099219.1530400002 | 37.7442231148112 | -122.43245771787 | (37.7442231148112, -122.43245771787) | |||
| 77438 | 77438 | 51908 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 490X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52601 | 6002971.47862471 | 2105361.83743697 | 37.7610905025589 | -122.43283358188299 | (37.7610905025589, -122.432833581883) |
| 69483 | 69483 | 32107 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 429 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 10 | Permit Number 35478 | 6002990.68319 | 2105750.27702 | 37.7621581531882 | -122.432794911471 | (37.7621581531882, -122.432794911471) | |
| 61608 | 61608 | 32108 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 431 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 11 | Permit Number 35479 | 6002991.887619999 | 2105721.63802 | 37.7620795857172 | -122.432788699839 | (37.7620795857172, -122.432788699839) | |
| 121204 | 121204 | 68770 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 616 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | Permit Number 32698 | 6002993.73826974 | 2104676.98539815 | 37.7592113259791 | -122.432707672319 | (37.7592113259791, -122.432707672319) | ||
| 81707 | 81707 | 35398 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 540 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38853 | 6003072.48314636 | 2098933.73753739 | 37.743446188104 | -122.43202521517 | (37.743446188104, -122.43202521517) | ||
| 89137 | 89137 | 95571 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 960 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767362 | 6003109.0 | 2102648.0 | 37.753646751876296 | -122.43216414381901 | (37.7536467518763, -122.432164143819) | |
| 158147 | 158147 | 247455 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 541 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003122.801 | 2110193.1484 | 37.7743646855214 | -122.432655343876 | (37.7743646855214, -122.432655343876) | |||
| 93765 | 93765 | 52137 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 541 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2005 12:00:00 AM | 4 | 3x3 | Permit Number 48316 | 6003127.26918681 | 2110108.47893411 | 37.774132457488896 | -122.432633838295 | (37.7741324574889, -122.432633838295) | |
| 83940 | 83940 | 32089 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3976 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | Permit Number 35462 | 6003168.80356063 | 2104788.27114216 | 37.7595268169135 | -122.43211015988899 | (37.7595268169135, -122.432110159889) | ||
| 70913 | 70913 | 32088 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3972 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 12 | Permit Number 35461 | 6003219.31552 | 2104788.31954 | 37.759529813480604 | -122.43193546805901 | (37.7595298134806, -122.431935468059) | |
| 31018 | 31018 | 244415 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 630 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003443.0612 | 2109684.1199 | 37.7729851758016 | -122.43151115772899 | (37.7729851758016, -122.431511157729) | |||
| 87942 | 87942 | 67933 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 114 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31646 | 6003490.581697099 | 2095075.42432118 | 37.73287583730961 | -122.43030432183001 | (37.7328758373096, -122.43030432183) | ||
| 101741 | 101741 | 95562 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 467 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767356 | 6003496.0 | 2099787.0 | 37.7458130504625 | -122.430621674841 | (37.7458130504625, -122.430621674841) | |
| 53261 | 53261 | 225947 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 114 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6003497.57041 | 2095097.9657299998 | 37.7329381267755 | -122.430281767707 | (37.7329381267755, -122.430281767707) | |||
| 185415 | 185415 | 246444 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 467 Duncan St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6003499.43256 | 2099785.6606799997 | 37.7458095674622 | -122.430609709989 | (37.7458095674622, -122.430609709989) | |||
| 151104 | 151104 | 225972 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 111 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003502.63381 | 2105046.7258599997 | 37.760255392804496 | -122.430974055914 | (37.7602553928045, -122.430974055914) | |||
| 163367 | 163367 | 225953 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 245 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003670.68661 | 2095891.30011 | 37.735126247484104 | -122.42973982455901 | (37.7351262474841, -122.429739824559) | |||
| 184026 | 184026 | 225978 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 737 Sanchez St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 6003705.65415 | 2103955.3434599997 | 37.757270218256394 | -122.430194042444 | (37.7572702182564, -122.430194042444) | |||
| 78504 | 78504 | 59406 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 31 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 770712 | 6003751.60013387 | 2095492.67978387 | 37.73403630788339 | -122.42943165971 | (37.7340363078834, -122.42943165971) |
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");