Data source: data.sfgov.org
This data as json, CSV (advanced)
| 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) | |
| 4555 | 4555 | 253633 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1907 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 777409 | ||||||
| 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) | ||
| 5473 | 5473 | 52359 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 645 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48496 | 6007837.48852 | 2114654.59381 | 37.786880990198 | -122.41666243464199 | (37.786880990198, -122.416662434642) |
| 5644 | 5644 | 81955 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 611 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769820 | 6007855.44707 | 2114525.76185 | 37.7865282590267 | -122.416591172348 | (37.7865282590267, -122.416591172348) |
| 6899 | 6899 | 52360 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 645 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48496 | 6007841.58942 | 2114643.58565 | 37.78685099511571 | -122.416647466318 | (37.7868509951157, -122.416647466318) |
| 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) | |
| 7270 | 7270 | 98268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | ||||||||
| 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) | |
| 7906 | 7906 | 42669 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1374 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 6 | 3x5 | Permit Number 46576 | 6007041.18345 | 2118110.17737 | 37.7963243483505 | -122.419662744764 | (37.7963243483505, -122.419662744764) |
| 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) | ||
| 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) | ||
| 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) | ||
| 10635 | 10635 | 37208 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1890 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 6 | 3X3 | Permit Number 39774 | 5986318.0892 | 2102397.4434 | 37.751992489797004 | -122.49021162161101 | (37.751992489797, -122.490211621611) |
| 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) | |
| 10923 | 10923 | 108952 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2912 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769302 | 5990002.93775 | 2095864.20098 | 37.7342684111434 | -122.47699167433399 | (37.7342684111434, -122.476991674334) |
| 11913 | 11913 | 108546 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 174 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773708 | 6002822.5324 | 2094312.8770599999 | 37.7307441928912 | -122.432559488737 | (37.7307441928912, -122.432559488737) |
| 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) | |
| 12441 | 12441 | 109572 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Brazil Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774876 | 6003097.99881 | 2091486.06514 | 37.72299801913329 | -122.431405440927 | (37.7229980191333, -122.431405440927) |
| 12665 | 12665 | 109570 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774876 | 6003082.6952599995 | 2091494.46608 | 37.7230202188994 | -122.431458941588 | (37.7230202188994, -122.431458941588) |
| 12843 | 12843 | 109569 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774876 | 6003067.9512 | 2091505.3817099999 | 37.7230493551309 | -122.431510687674 | (37.7230493551309, -122.431510687674) |
| 15555 | 15555 | 59677 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1700 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 10 | 3x3 | Permit Number 19103 | 6014064.15131 | 2093105.02491 | 37.728058768695995 | -122.393610646816 | (37.728058768696, -122.393610646816) |
| 16315 | 16315 | 51391 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 75 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 4 | 3x3 | Permit Number 47719 | 6007725.4963 | 2109499.14955 | 37.7727190799574 | -122.41668454444901 | (37.7727190799574, -122.416684544449) |
| 16667 | 16667 | 67335 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 673 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 6x4 | Permit Number 773101 | 6011565.01957 | 2105259.70071 | 37.7612937095442 | -122.403104877802 | (37.7612937095442, -122.403104877802) |
| 17668 | 17668 | 31387 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1314 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 12 | 3x3 | Permit Number 34980 | 5991923.9598 | 2098448.87942 | 37.741476540316796 | -122.470538331775 | (37.7414765403168, -122.470538331775) |
| 18370 | 18370 | 38265 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 711 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | 6 | 3x3 | Permit Number 40366 | 6015782.17100529 | 2103924.24418542 | 37.7578614341223 | -122.38842618690599 | (37.7578614341223, -122.388426186906) |
| 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) | ||
| 19128 | 19128 | 95689 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2415 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767440 | 5982968.9 | 2098671.4 | 37.7415656423265 | -122.501517800216 | (37.7415656423265, -122.501517800216) | |
| 19354 | 19354 | 95439 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1874 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767301 | 5986339.2 | 2102491.9 | 37.7522530747906 | -122.490145565656 | (37.7522530747906, -122.490145565656) | |
| 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) | ||
| 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) | ||
| 23757 | 23757 | 92367 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1938 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52780 | 5986020.4821 | 2102025.9665 | 37.7509551305239 | -122.491213439138 | (37.7509551305239, -122.491213439138) |
| 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) | |
| 23917 | 23917 | 83757 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1838 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767115 | 5984137.1702 | 2102639.4673 | 37.7525294126592 | -122.497771308698 | (37.7525294126592, -122.497771308698) |
| 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) | |
| 24098 | 24098 | 92296 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1387 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52741 | 5989259.6068 | 2105918.0206 | 37.761830398003795 | -122.480297199633 | (37.7618303980038, -122.480297199633) |
| 24532 | 24532 | 46400 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2371 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 0 | 3x3 | Permit Number 767122 | 5981730.59814192 | 2098955.65959072 | 37.7422733344517 | -122.50582042193301 | (37.7422733344517, -122.505820421933) |
| 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) | |
| 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) | |
| 25342 | 25342 | 94702 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 646 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53842 | 5992259.75626 | 2111021.3028599997 | 37.77601652603929 | -122.470292619455 | (37.7760165260393, -122.470292619455) |
| 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) | |
| 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) | ||
| 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) | |
| 26757 | 26757 | 92423 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1251 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52816 | 5983956.38 | 2106631.2052 | 37.7634790074381 | -122.49869135601999 | (37.7634790074381, -122.49869135602) |
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 30268 | 30268 | 47254 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 19 Redondo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 5 | Permit Number 45196 | 6014382.2946 | 2089525.8428 | 37.7182487206536 | -122.39226058533801 | (37.7182487206536, -122.392260585338) | |
| 30338 | 30338 | 75645 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1154 Kearny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | 6011131.8005 | 2118945.02958 | 37.7988462254172 | -122.405567109137 | (37.7988462254172, -122.405567109137) | ||
| 30799 | 30799 | 68531 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 688 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 7 | Permit Number 32412 | 5994747.00925 | 2110859.17308 | 37.7757148491404 | -122.46167686049601 | (37.7757148491404, -122.461676860496) | |
| 30961 | 30961 | 37243 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2550 Ortega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 6 | Permit Number 39799 | 5986045.6172 | 2102335.9799 | 37.751807811537496 | -122.491149333316 | (37.7518078115375, -122.491149333316) | |
| 30985 | 30985 | 41101 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 27 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/1999 12:00:00 AM | 4 | Permit Number 41848 | 5998679.9396 | 2110577.3922 | 37.7751667574303 | -122.448051637465 | (37.7751667574303, -122.448051637465) | |
| 31144 | 31144 | 41113 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 117 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | 7 | Permit Number 41861 | 5997766.8523 | 2110158.7794 | 37.7739651176251 | -122.451179999872 | (37.7739651176251, -122.451179999872) | |
| 31429 | 31429 | 30660 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 81 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 4 | Permit Number 47724 | 6007698.39694 | 2109510.52201 | 37.772748781854794 | -122.41677909020201 | (37.7727487818548, -122.416779090202) | |
| 31543 | 31543 | 62226 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 170 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | 10 | Permit Number 22351 | 6001298.15833 | 2093408.31097 | 37.728173898095704 | -122.43776471708 | (37.7281738980957, -122.43776471708) | |
| 31747 | 31747 | 45111 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1927 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 4 | Permit Number 43973 | 5987149.5284 | 2100275.4971 | 37.7462147168105 | -122.48718058553999 | (37.7462147168105, -122.48718058554) | |
| 31910 | 31910 | 42251 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 75 Oak Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 7 | Permit Number 42496 | 6012070.36675 | 2111065.24488 | 37.7772626294064 | -122.401765172144 | (37.7772626294064, -122.401765172144) | |
| 32068 | 32068 | 72263 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 350 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 8 | 6002374.01007 | 2091556.78865 | 37.723151151179295 | -122.43391317255899 | (37.7231511511793, -122.433913172559) | ||
| 32257 | 32257 | 32590 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1327 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 7 | Permit Number 37059 | 5985524.6289 | 2106166.4414 | 37.7622947472384 | -122.49323312173901 | (37.7622947472384, -122.493233121739) | |
| 32335 | 32335 | 62148 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2040 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 11 | Permit Number 22262 | 5999472.96679 | 2121211.62683 | 37.804410871434705 | -122.446073454522 | (37.8044108714347, -122.446073454522) | |
| 32534 | 32534 | 62231 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 362 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | 7 | Permit Number 22357 | 6001072.9164 | 2092674.16767 | 37.7261452982613 | -122.438490807229 | (37.7261452982613, -122.438490807229) | |
| 33289 | 33289 | 67293 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 287 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1992 12:00:00 AM | 8 | Permit Number 30769 | 6004586.78061 | 2091465.21823 | 37.723025042856705 | -122.426257538952 | (37.7230250428567, -122.426257538952) | |
| 33420 | 33420 | 61144 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 115 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | 8 | Permit Number 20998 | 5997762.4582 | 2110187.0666 | 37.7740425353843 | -122.451197240135 | (37.7740425353843, -122.451197240135) | |
| 33551 | 33551 | 68970 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3420 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 5 | Permit Number 32960 | 5999798.8127 | 2120325.39323 | 37.8019961143897 | -122.444882095654 | (37.8019961143897, -122.444882095654) | |
| 33608 | 33608 | 37640 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2422 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 5 | Permit Number 40057 | 5991129.352419999 | 2112029.6981200003 | 37.7787198830409 | -122.474276544451 | (37.7787198830409, -122.474276544451) | |
| 34169 | 34169 | 37643 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2432 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40058 | 5991099.349909999 | 2112026.42751 | 37.7787091646762 | -122.47438009503401 | (37.7787091646762, -122.474380095034) | |
| 34224 | 34224 | 76155 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 5 | 6009557.4611 | 2110236.6613 | 37.774846979750706 | -122.41039963593501 | (37.7748469797507, -122.410399635935) | ||
| 34439 | 34439 | 84394 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2101 Jerrold Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 4 | 6012485.34131 | 2099091.8442 | 37.7444094669397 | -122.399488816268 | (37.7444094669397, -122.399488816268) | ||
| 34619 | 34619 | 37081 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1233 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 5 | Permit Number 39682 | 5982089.3021 | 2106698.5454 | 37.7635542250983 | -122.50515386108201 | (37.7635542250983, -122.505153861082) | |
| 34766 | 34766 | 72249 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 327 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 7 | 6002262.973180001 | 2091806.41787 | 37.723830275124705 | -122.434314843048 | (37.7238302751247, -122.434314843048) | ||
| 35047 | 35047 | 84137 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 316 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2006 12:00:00 AM | 4 | 6011309.96937 | 2088940.1025 | 37.7164693214661 | -122.402839197385 | (37.7164693214661, -122.402839197385) | ||
| 35335 | 35335 | 84389 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2101 Jerrold Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 4 | 6012558.72681 | 2099037.9723900002 | 37.7442656365553 | -122.39923128191299 | (37.7442656365553, -122.399231281913) | ||
| 35516 | 35516 | 50179 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 780 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | 4 | Permit Number 46886 | 5991981.16155 | 2110138.9251099997 | 37.7735776447762 | -122.471192041478 | (37.7735776447762, -122.471192041478) | |
| 35655 | 35655 | 44346 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 638 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | 2 | Permit Number 45447 | 6009274.88701 | 2111392.39152 | 37.7780044981441 | -122.41145879088499 | (37.7780044981441, -122.411458790885) | |
| 35998 | 35998 | 66575 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 36 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 12 | Permit Number 29765 | 6003597.59205 | 2093717.28667 | 37.7291527579901 | -122.42983752060499 | (37.7291527579901, -122.429837520605) | |
| 36087 | 36087 | 41774 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1346 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 10 | Permit Number 42189 | 6007525.74917 | 2115810.14377 | 37.790036309280794 | -122.417822924306 | (37.7900363092808, -122.417822924306) | |
| 36112 | 36112 | 92435 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1234 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52825 | 5982757.3475 | 2106713.6 | 37.7636348449871 | -122.50284445643801 | (37.7636348449871, -122.502844456438) |
| 36132 | 36132 | 31601 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1722 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 7 | Permit Number 35127 | 5988641.3833 | 2102425.9273 | 37.7522061064192 | -122.48217951547701 | (37.7522061064192, -122.482179515477) |
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");