Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1582 | 1582 | 45051 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2243 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 3 | Permit Number 43936 | 5988218.295 | 2100043.5647 | 37.7456401553342 | -122.483467967859 | (37.7456401553342, -122.483467967859) | |
| 3986 | 3986 | 65721 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 275 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2017 04:32:00 PM | 3 | Permit Number 28655 | 6000475.14424 | 2087458.3820900002 | 37.711789909637794 | -122.44018340596399 | (37.7117899096378, -122.440183405964) | |
| 4496 | 4496 | 30326 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 946 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 11:13:00 AM | 3 | Permit Number 17 | 5995052.87017 | 2090222.4724 | 37.7190692525106 | -122.459124173264 | (37.7190692525106, -122.459124173264) | ||
| 4538 | 4538 | 253635 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 830 Oak St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | ||||
| 4844 | 4844 | 253688 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||||
| 4848 | 4848 | 31890 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | Permit Number 35322 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||
| 7190 | 7190 | 59699 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3188 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | Permit Number 773904 | 5999466.917230001 | 2116043.86882 | 37.7902212404654 | -122.44572252287901 | (37.7902212404654, -122.445722522879) | |
| 7391 | 7391 | 58164 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1472 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1992 12:00:00 AM | 8 | Permit Number 31200 | 6005960.50321 | 2119339.77329 | 37.7996395731743 | -122.423489589398 | (37.7996395731743, -122.423489589398) | |
| 7799 | 7799 | 36854 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 8770 | 8770 | 48424 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3034 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/03/2014 12:00:00 AM | 3 | Permit Number 772479 | 6001994.11068 | 2118598.66634 | 37.7973800166165 | -122.437161635315 | (37.7973800166165, -122.437161635315) | |
| 8830 | 8830 | 71801 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2170 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 8 | 5997504.5785 | 2109900.8998 | 37.77324202696929 | -122.452068634732 | (37.7732420269693, -122.452068634732) | ||
| 9099 | 9099 | 36836 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9350 | 9350 | 72948 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 510 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/1999 12:00:00 AM | 3 | 6004536.11910305 | 2110188.83574422 | 37.7744328940259 | -122.427766104146 | (37.7744328940259, -122.427766104146) | |||
| 9535 | 9535 | 36839 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9547 | 9547 | 68821 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 770629 | 5999450.20473491 | 2094083.18160524 | 37.7299216843992 | -122.44420161479799 | (37.7299216843992, -122.444201614798) | ||
| 10076 | 10076 | 142645 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2380 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008890.0639 | 2121379.5977 | 37.805405337199 | -122.41349655223 | (37.805405337199, -122.41349655223) | |||||
| 10248 | 10248 | 69823 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 490 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2017 12:00:00 AM | 3 | 5985346.30869 | 2112623.83377 | 37.7800144848575 | -122.49432585822201 | (37.7800144848575, -122.494325858222) | ||
| 10359 | 10359 | 26782 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6010979.6007 | 2087065.0465 | 37.711302344066 | -122.403849252944 | (37.711302344066, -122.403849252944) | ||||
| 10437 | 10437 | 115185 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999482.43288 | 2089277.31598 | 37.716727722789 | -122.443745071105 | (37.716727722789, -122.443745071105) | ||||
| 10689 | 10689 | 44737 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 220 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 10 | Permit Number 43854 | 5992028.1183 | 2086972.4785799999 | 37.7099712034746 | -122.469343044645 | (37.7099712034746, -122.469343044645) | |
| 10742 | 10742 | 115189 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999437.68927 | 2089235.07738 | 37.716609193035396 | -122.443896694081 | (37.7166091930354, -122.443896694081) | ||||
| 10943 | 10943 | 117432 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776914 | 6001483.3943300005 | 2089635.3140599998 | 37.717824632186705 | -122.436854363943 | (37.7178246321867, -122.436854363943) | ||
| 11166 | 11166 | 112236 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/04/2015 08:45:00 AM | 3 | 5999186.55259 | 2088995.9330400003 | 37.7159382286299 | -122.444747565144 | (37.7159382286299, -122.444747565144) | |||
| 11251 | 11251 | 115187 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999459.81391 | 2089256.7158599999 | 37.716669869389 | -122.443821774256 | (37.716669869389, -122.443821774256) | ||||
| 11297 | 11297 | 95009 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 151 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010165.2261 | 2087437.3639 | 37.712279121941 | -122.40669017224899 | (37.712279121941, -122.406690172249) | ||||
| 11513 | 11513 | 112244 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 07:23:00 AM | 3 | 5999075.356319999 | 2088897.5178 | 37.7156616565467 | -122.445124838863 | (37.7156616565467, -122.445124838863) | |||
| 12023 | 12023 | 95021 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 51 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010652.9596 | 2087185.8102 | 37.711615683002 | -122.404986710459 | (37.711615683002, -122.404986710459) | ||||
| 12208 | 12208 | 95022 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 45 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010735.1769 | 2087146.3726 | 37.7115119909256 | -122.404699769405 | (37.7115119909256, -122.404699769405) | ||||
| 12254 | 12254 | 112240 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 07:38:00 AM | 3 | 5999143.09775 | 2088953.6674799998 | 37.7158196970968 | -122.444894728405 | (37.7158196970968, -122.444894728405) | |||
| 12325 | 12325 | 26787 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 58 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1999 12:00:00 AM | 3 | 6010687.7182 | 2087215.2212 | 37.711698382632605 | -122.404868644189 | (37.7116983826326, -122.404868644189) | |||
| 12346 | 12346 | 46852 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 450 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2014 12:00:00 AM | 3 | Permit Number 773811 | 6003293.98042 | 2090989.1519900002 | 37.7216447112248 | -122.43069253035101 | (37.7216447112248, -122.430692530351) | |
| 12485 | 12485 | 94989 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 44 Leland Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010751.8878 | 2087184.0277 | 37.711616318234206 | -122.404644660956 | (37.7116163182342, -122.404644660956) | ||||
| 12498 | 12498 | 95030 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 11 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010891.1447 | 2087063.4869 | 37.7112931195577 | -122.404154871184 | (37.7112931195577, -122.404154871184) | ||||
| 12539 | 12539 | 95031 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010911.6433 | 2087052.7919 | 37.7112648985932 | -122.404083270279 | (37.7112648985932, -122.404083270279) | ||||
| 12735 | 12735 | 115192 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999381.87795 | 2089181.7631299999 | 37.7164596204897 | -122.44408577653499 | (37.7164596204897, -122.444085776535) | ||||
| 12942 | 12942 | 112238 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 08:30:00 AM | 3 | 5999164.96486 | 2088975.3114099998 | 37.715880374360204 | -122.444820700722 | (37.7158803743602, -122.444820700722) | |||
| 13110 | 13110 | 112242 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 07:31:00 AM | 3 | 5999099.9806 | 2088915.2496599997 | 37.7157117496696 | -122.445041000443 | (37.7157117496696, -122.445041000443) | |||
| 13235 | 13235 | 57548 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 150-152 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773714 | 6000424.90401 | 2091350.8079400002 | 37.722474772884 | -122.440636064423 | (37.722474772884, -122.440636064423) | ||
| 13906 | 13906 | 36837 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 15723 | 15723 | 36838 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 16572 | 16572 | 36840 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 16849 | 16849 | 22416 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5800 03rd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6013664.2375 | 2091773.8949 | 37.724381524856206 | -122.39489998248001 | (37.7243815248562, -122.39489998248) | ||||
| 17213 | 17213 | 16325 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 789X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/1990 12:00:00 AM | 3 | 5996845.45782 | 2094685.26477 | 37.7314259140577 | -122.453249933841 | (37.7314259140577, -122.453249933841) | |||
| 17550 | 17550 | 1369 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 34 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/1997 12:00:00 AM | 3 | 5999059.98844 | 2100047.12811 | 37.746274991794294 | -122.445979419622 | (37.7462749917943, -122.445979419622) | |||
| 18003 | 18003 | 26207 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 758 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/1997 12:00:00 AM | 6 | 6005594.7559 | 2098614.98254 | 37.742713632417605 | -122.42328116790199 | (37.7427136324176, -122.423281167902) | |||
| 18156 | 18156 | 49101 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | Permit Number 46246 | 6012933.18722113 | 2110757.22353588 | 37.7764649850887 | -122.398758756879 | (37.7764649850887, -122.398758756879) | |||
| 18382 | 18382 | 36313 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39291 | 5996172.05456486 | 2093809.43581436 | 37.7289824784834 | -122.455514723268 | (37.7289824784834, -122.455514723268) | ||
| 19020 | 19020 | 25 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 736 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/17/1995 12:00:00 AM | 0 | 6003903.525084401 | 2107767.6234363 | 37.7677490306877 | -122.429781635515 | (37.7677490306877, -122.429781635515) | |||
| 19027 | 19027 | 97174 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 37 | 26 Gilbert St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | |||||
| 19423 | 19423 | 32825 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4388 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37183 | 6000688.62823937 | 2102311.71658566 | 37.752585873246005 | -122.440510188354 | (37.752585873246, -122.440510188354) | ||
| 19614 | 19614 | 96252 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301X Lee Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |||
| 19673 | 19673 | 39412 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401Bldg #8 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | |||
| 19901 | 19901 | 21524 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2709X Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Tree was replanted 02/06/07 | 6002363.91789 | 2096241.5628900002 | 37.7360139044279 | -122.434282822689 | (37.7360139044279, -122.434282822689) | |||
| 20373 | 20373 | 101208 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 21233 | 21233 | 44035 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1147 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2000 12:00:00 AM | Permit Number 43570 | 6003860.00449326 | 2101604.35206058 | 37.75082369093 | -122.429492581147 | (37.75082369093, -122.429492581147) | |||
| 22283 | 22283 | 52604 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 900 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2006 12:00:00 AM | 2 | Permit Number 48695 | 6016071.1186 | 2089161.0324 | 37.7173406522544 | -122.38639756201799 | (37.7173406522544, -122.386397562018) | ||
| 23097 | 23097 | 24665 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4850 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 5991933.61016 | 2112783.76885 | 37.7808369148225 | -122.471549293385 | (37.7808369148225, -122.471549293385) | ||||
| 23348 | 23348 | 12189 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1463 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 6016268.9903 | 2095509.3837 | 37.7347829272824 | -122.38615592449699 | (37.7347829272824, -122.386155924497) | ||||
| 23667 | 23667 | 71626 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 546 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | 6010902.3539 | 2118984.9834 | 37.7989430963584 | -122.406363890018 | (37.7989430963584, -122.406363890018) | ||
| 23803 | 23803 | 66974 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 290 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1992 12:00:00 AM | 9 | Permit Number 30317 | 5996737.0249 | 2110855.143 | 37.7758181337994 | -122.45479264802 | (37.7758181337994, -122.45479264802) | |
| 23954 | 23954 | 30920 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 242 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 10 | Permit Number 34736 | 5995667.1416 | 2091560.8953099998 | 37.7227795387217 | -122.457097650843 | (37.7227795387217, -122.457097650843) | |
| 24150 | 24150 | 67029 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1742 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/1992 12:00:00 AM | 10 | Permit Number 30397 | 5984423.6443 | 2103304.9738 | 37.7543734989147 | -122.496829760136 | (37.7543734989147, -122.496829760136) | ||
| 24516 | 24516 | 180327 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 443 Capistrano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6000920.894780001 | 2092230.1433299999 | 37.7249174601452 | -122.43898452870899 | (37.7249174601452, -122.438984528709) | ||||
| 24897 | 24897 | 45532 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 91 Inverness Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 7 | Permit Number 44291 | 5988299.5289199995 | 2095312.45705 | 37.732654498611005 | -122.482840411668 | (37.732654498611, -122.482840411668) | |
| 25060 | 25060 | 85220 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 603 22nd Ave | 3 | : 4 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49541 | 5989076.71677 | 2111162.9995 | 37.776221041753296 | -122.48131384215401 | (37.7762210417533, -122.481313842154) | ||
| 25177 | 25177 | 68024 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1475 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1993 12:00:00 AM | 2 | Permit Number 31755 | 5987728.8685 | 2105251.5549 | 37.7599113960962 | -122.48554243735599 | (37.7599113960962, -122.485542437356) | ||
| 25197 | 25197 | 42152 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 622 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 5 | Permit Number 42447 | 5989745.16846 | 2111083.69562 | 37.7760421357171 | -122.47899570903401 | (37.7760421357171, -122.478995709034) | |
| 25302 | 25302 | 51685 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1750@ NORIEGA 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2005 12:00:00 AM | 2 | Permit Number 47965 | 5987220.4567 | 2103333.4424 | 37.7546151470482 | -122.487159883629 | (37.7546151470482, -122.487159883629) | ||
| 25307 | 25307 | 57525 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 500 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1976 12:00:00 AM | 9 | Permit Number 16384 | 6005330.9453 | 2111340.195 | 37.7776391759665 | -122.42509858661998 | (37.7776391759665, -122.42509858662) | ||
| 25492 | 25492 | 62153 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2022 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 10 | Permit Number 22267 | 5999519.37482 | 2121217.44002 | 37.804429482897795 | -122.44591327448 | (37.8044294828978, -122.44591327448) | |
| 26228 | 26228 | 30542 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011709.315719999 | 2086131.9776 | 37.7087810622767 | -122.401261631812 | (37.7087810622767, -122.401261631812) | ||
| 26338 | 26338 | 71539 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 277 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 1 | 6011318.23655 | 2111544.7017900003 | 37.7785371054488 | -122.40440080264999 | (37.7785371054488, -122.40440080265) | ||
| 26395 | 26395 | 30794 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 340 Ritch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1995 12:00:00 AM | 3 | Permit Number 34662 | 6014273.47529 | 2111688.76401 | 37.7790973704984 | -122.394187516963 | (37.7790973704984, -122.394187516963) | ||
| 26466 | 26466 | 66583 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 170 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 8 | Permit Number 29773 | 6004274.60458 | 2092554.4003299999 | 37.725998045968794 | -122.427414222707 | (37.7259980459688, -122.427414222707) | |
| 26855 | 26855 | 73378 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 6 | 5983190.4387300005 | 2110910.57285 | 37.775183970412996 | -122.501657073915 | (37.775183970413, -122.501657073915) | ||
| 27243 | 27243 | 136775 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600 Francisco St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5999017.84714 | 2119772.0428299997 | 37.8004321627783 | -122.447544740905 | (37.8004321627783, -122.447544740905) | ||||
| 27252 | 27252 | 49933 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2619@ VICENTE 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 5 | Permit Number 46693 | 5988614.8781 | 2097469.9952 | 37.7385968825528 | -122.48190817353998 | (37.7385968825528, -122.48190817354) | |
| 27399 | 27399 | 70234 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 5 | 5983192.21244 | 2110893.91815 | 37.775138345619396 | -122.501649705941 | (37.7751383456194, -122.501649705941) | ||
| 27424 | 27424 | 67404 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 614 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 8 | Permit Number 30903 | 5989745.14733 | 2111135.1502799997 | 37.776183414760794 | -122.47899954663 | (37.7761834147608, -122.47899954663) | |
| 27613 | 27613 | 36198 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1485 Armstrong Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | 4 | Permit Number 39261 | 6015078.9992 | 2091914.2806 | 37.7248455613423 | -122.39001910919599 | (37.7248455613423, -122.390019109196) | |
| 27864 | 27864 | 45493 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3017 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 5 | Permit Number 44269 | 5989985.33852 | 2095139.4383599998 | 37.7322773768865 | -122.476999578465 | (37.7322773768865, -122.476999578465) | |
| 27882 | 27882 | 67648 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1946 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 6 | Permit Number 31247 | 6013417.63825 | 2096018.4477 | 37.7360224839351 | -122.396049764692 | (37.7360224839351, -122.396049764692) | |
| 27895 | 27895 | 51292 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 178 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2004 12:00:00 AM | 4 | Permit Number 47664 | 6009747.70771 | 2088859.6181400002 | 37.7161609718402 | -122.408233494696 | (37.7161609718402, -122.408233494696) | ||
| 27917 | 27917 | 31593 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1201 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 4 | Permit Number 35122 | 5990086.846 | 2102416.3668 | 37.7522638247523 | -122.477180236453 | (37.7522638247523, -122.477180236453) | |
| 28065 | 28065 | 84526 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1607 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985279.5041 | 2104240.0581 | 37.756991093889496 | -122.49393892942699 | (37.7569910938895, -122.493938929427) | |||
| 28110 | 28110 | 33156 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2462 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2006 12:00:00 AM | 4 | Permit Number 48987 | 5986142.1502 | 2098483.4784 | 37.7412355210533 | -122.490532108902 | (37.7412355210533, -122.490532108902) | |
| 28284 | 28284 | 84384 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2101 Jerrold Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 4 | 6012605.75567 | 2099001.93015 | 37.7441692930905 | -122.399066135804 | (37.7441692930905, -122.399066135804) | ||
| 28349 | 28349 | 52940 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 Santa Ysabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 4 | Permit Number 48927 | 6001124.83549 | 2092944.78759 | 37.7268913119605 | -122.43833070542 | (37.7268913119605, -122.43833070542) | |
| 28391 | 28391 | 67649 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1939 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 9 | Permit Number 31248 | 6013431.94199 | 2095958.6193099997 | 37.7358590033865 | -122.395996119237 | (37.7358590033865, -122.395996119237) | |
| 28442 | 28442 | 31875 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2201 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38286 | 5999315.13927 | 2116465.82732 | 37.7913711603999 | -122.446278027822 | (37.7913711603999, -122.446278027822) | |
| 28448 | 28448 | 37169 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 151 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39743 | 6005565.93572779 | 2099898.57048032 | 37.746236446392295 | -122.423472053683 | (37.7462364463923, -122.423472053683) | ||
| 28817 | 28817 | 62170 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 77 Rudden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1985 12:00:00 AM | 10 | Permit Number 22286 | 6000043.62237 | 2092067.5306099998 | 37.724421009198295 | -122.442005483689 | (37.7244210091983, -122.442005483689) | |
| 29211 | 29211 | 31416 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4036 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 6 | Permit Number 35003 | 6001929.8185 | 2103551.20105 | 37.7560597982317 | -122.436306643531 | (37.7560597982317, -122.436306643531) | |
| 29412 | 29412 | 52502 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 143 Del Monte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 4 | Permit Number 48611 | 5999302.61821 | 2088650.1848099998 | 37.714995505320296 | -122.444321557211 | (37.7149955053203, -122.444321557211) | |
| 29558 | 29558 | 242300 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Digby St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6003110.46195 | 2097242.14325 | 37.738803614002 | -122.431773140441 | (37.738803614002, -122.431773140441) | ||||
| 30014 | 30014 | 65731 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 244 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 9 | Permit Number 28665 | 6000099.76339 | 2087506.9392900001 | 37.711901858158704 | -122.44148430406 | (37.7119018581587, -122.44148430406) | |
| 30050 | 30050 | 60051 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1435 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/1982 12:00:00 AM | 1 | Permit Number 53408 | 5988341.1998 | 2105537.0323 | 37.7607308969178 | -122.483445635266 | (37.7607308969178, -122.483445635266) | |
| 30087 | 30087 | 35143 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 924 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 9 | Permit Number 38673 | 6001802.403059999 | 2088613.28285 | 37.7150364874261 | -122.435678614599 | (37.7150364874261, -122.435678614599) | |
| 30093 | 30093 | 30664 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 3 | Permit Number 46640 | 6006594.41261 | 2109123.24947 | 37.7716232677391 | -122.420570406196 | (37.7716232677391, -122.420570406196) | |
| 30104 | 30104 | 40826 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 937 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | 5 | Permit Number 41763 | 6000919.4228 | 2111933.4607 | 37.7790179396422 | -122.44040205923599 | (37.7790179396422, -122.440402059236) |
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");