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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 36170 | 36170 | 46162 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1596 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2006 12:00:00 AM | 3 | Permit Number 48875 | 6007711.98823 | 2109284.47434 | 37.7721288728888 | -122.416716059419 | (37.7721288728888, -122.416716059419) | |
| 36219 | 36219 | 52132 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 827 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | 4 | Permit Number 48314 | 6002447.9484 | 2111559.2112 | 37.7780772580819 | -122.435087505539 | (37.7780772580819, -122.435087505539) | |
| 36243 | 36243 | 67609 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2130 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1992 12:00:00 AM | 7 | Permit Number 31187 | 6012046.829390001 | 2102834.95519 | 37.7546627877763 | -122.401268093454 | (37.7546627877763, -122.401268093454) | |
| 36261 | 36261 | 83165 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1915 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2005 12:00:00 AM | 4 | 6015168.2313 | 2093359.9647 | 37.7288200702379 | -122.38981157458099 | (37.7288200702379, -122.389811574581) | ||
| 36465 | 36465 | 52668 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 948@ HAWES Ingerson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 5 | Permit Number 49081 | 6014451.5039 | 2089670.8082 | 37.7186506098234 | -122.39203148823499 | (37.7186506098234, -122.392031488235) | |
| 36574 | 36574 | 37398 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 8 | Permit Number 39880 | 5990859.5654 | 2113339.47173 | 37.7823005263293 | -122.475305482834 | (37.7823005263293, -122.475305482834) | |
| 36715 | 36715 | 62252 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 424 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | 7 | Permit Number 22378 | 6000908.74166 | 2092316.65472 | 37.7251543091988 | -122.439032737796 | (37.7251543091988, -122.439032737796) | |
| 36926 | 36926 | 41954 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1521 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 3 | Permit Number 42311 | 5993940.71445 | 2112070.81636 | 37.778995251039795 | -122.464554011648 | (37.7789952510398, -122.464554011648) | |
| 37305 | 37305 | 31761 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1007 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35247 | 5990066.9971 | 2099007.5245 | 37.7429028843685 | -122.47699981190901 | (37.7429028843685, -122.476999811909) | |
| 37623 | 37623 | 31595 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1319 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/13/2001 12:00:00 AM | 5 | Permit Number 35123 | 5989897.2831 | 2102411.6539 | 37.7522398844829 | -122.47783542323201 | (37.7522398844829, -122.477835423232) | |
| 37714 | 37714 | 65730 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 231 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 11 | Permit Number 28664 | 6000127.77488 | 2087528.84462 | 37.711963601099704 | -122.44138905958 | (37.7119636010997, -122.44138905958) | |
| 37903 | 37903 | 31762 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1007 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35247 | 5990024.3559 | 2099006.1709 | 37.7428966939048 | -122.477147152853 | (37.7428966939048, -122.477147152853) | |
| 38031 | 38031 | 45496 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3025 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 6 | Permit Number 44270 | 5989987.17329 | 2095091.0184 | 37.7321445344446 | -122.47698969851801 | (37.7321445344446, -122.476989698518) | |
| 38155 | 38155 | 37795 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 225 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 5 | Permit Number 40122 | 6009525.44285 | 2093324.3875 | 37.7284078477324 | -122.409316647141 | (37.7284078477324, -122.409316647141) | |
| 38361 | 38361 | 31438 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4228 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 10 | Permit Number 35013 | 6001016.80176 | 2102907.96599 | 37.75424171168989 | -122.439418046916 | (37.7542417116899, -122.439418046916) | |
| 38526 | 38526 | 62218 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 171 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | 12 | Permit Number 22342 | 6001349.04402 | 2093401.0073099998 | 37.728156737237605 | -122.437588280871 | (37.7281567372376, -122.437588280871) | |
| 38602 | 38602 | 42610 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1778 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42677 | 6004517.51154 | 2118442.44969 | 37.797094201301604 | -122.428418874228 | (37.7970942013016, -122.428418874228) | |
| 38781 | 38781 | 44730 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 3 | Permit Number 43848 | 5989567.2499 | 2101094.6235 | 37.7486045071607 | -122.47888039772499 | (37.7486045071607, -122.478880397725) | |
| 39128 | 39128 | 62246 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 442 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | 14 | Permit Number 22372 | 6000877.73644 | 2092244.25286 | 37.724953745993204 | -122.439134732604 | (37.7249537459932, -122.439134732604) | |
| 39434 | 39434 | 84383 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2101 Jerrold Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 4 | 6012616.61055 | 2098993.72766 | 37.7441473756935 | -122.39902802614701 | (37.7441473756935, -122.399028026147) | ||
| 39594 | 39594 | 53158 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1783@ NEWHALL Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 5 | Permit Number 49079 | 6014266.93493 | 2095316.80155 | 37.7341431239076 | -122.393064303289 | (37.7341431239076, -122.393064303289) | |
| 40411 | 40411 | 42617 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1790 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 8 | Permit Number 42679 | 6004487.31439 | 2118438.14954 | 37.7970806853794 | -122.42852305711901 | (37.7970806853794, -122.428523057119) | |
| 40461 | 40461 | 35361 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 969 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 4 | Permit Number 38823 | 6011919.411119999 | 2103909.48398 | 37.7576060979734 | -122.40178426833401 | (37.7576060979734, -122.401784268334) | |
| 40481 | 40481 | 83439 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2137 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 3 | 6012036.86262 | 2102317.86388 | 37.7532424120077 | -122.401266226469 | (37.7532424120077, -122.401266226469) | ||
| 40543 | 40543 | 72268 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 382 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 10 | 6002278.02989 | 2091405.67188 | 37.7227307711806 | -122.434234158593 | (37.7227307711806, -122.434234158593) | ||
| 40603 | 40603 | 52369 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1090 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48501 | 6006953.33636 | 2114687.7048400003 | 37.786922138678605 | -122.41972375385099 | (37.7869221386786, -122.419723753851) |
| 40810 | 40810 | 65701 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 212 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/1990 12:00:00 AM | 11 | Permit Number 28630 | 6000074.37942 | 2087593.2197 | 37.71213731866 | -122.44157822565201 | (37.71213731866, -122.441578225652) | |
| 40815 | 40815 | 94721 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 30 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53856 | 5997800.8659 | 2113535.8879 | 37.7832397250428 | -122.451305952337 | (37.7832397250428, -122.451305952337) |
| 40933 | 40933 | 51262 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 533 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 4 | Permit Number 47639 | 5991570.13024 | 2111802.6045 | 37.7781218716613 | -122.47273517464599 | (37.7781218716613, -122.472735174646) | |
| 41057 | 41057 | 92298 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1391 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52742 | 5989260.4458 | 2105879.8442 | 37.7617256246846 | -122.480291503566 | (37.7617256246846, -122.480291503566) |
| 41192 | 41192 | 71437 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 37 Moss St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 7 | 6010216.42289 | 2111356.07876 | 37.777957557144 | -122.408199106408 | (37.777957557144, -122.408199106408) | ||
| 41336 | 41336 | 72223 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2059 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 5 | 5986929.1752 | 2101253.2415 | 37.7488864888631 | -122.48801435981899 | (37.7488864888631, -122.488014359819) | ||
| 41626 | 41626 | 32797 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1768 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 7 | Permit Number 37160 | 5999343.0073 | 2110507.9142 | 37.7750138693543 | -122.445752948617 | (37.7750138693543, -122.445752948617) | |
| 41695 | 41695 | 95759 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 726 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767496 | 6001862.99487 | 2089729.239 | 37.7181040965161 | -122.435548971002 | (37.7181040965161, -122.435548971002) |
| 42018 | 42018 | 62474 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 78 Rudden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | 11 | Permit Number 22645 | 6000057.975190001 | 2092094.89493 | 37.7244969632416 | -122.441957831291 | (37.7244969632416, -122.441957831291) | |
| 42450 | 42450 | 95773 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 126 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767508 | 6004644.83085 | 2092643.2046400001 | 37.7262628153707 | -122.426140692752 | (37.7262628153707, -122.426140692752) |
| 42549 | 42549 | 72113 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3214 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1986 12:00:00 AM | 6 | 5997155.9186 | 2113032.4009 | 37.7818203327249 | -122.453500835003 | (37.7818203327249, -122.453500835003) | ||
| 42805 | 42805 | 44732 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 4 | Permit Number 43848 | 5989535.4536 | 2101093.9541 | 37.7486008227669 | -122.47899029874901 | (37.7486008227669, -122.478990298749) | |
| 43465 | 43465 | 75952 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6555 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1989 12:00:00 AM | 8 | 5986669.94788 | 2112490.9662200003 | 37.7797270399513 | -122.48973708317101 | (37.7797270399513, -122.489737083171) | ||
| 43466 | 43466 | 61653 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2015 12:00:00 AM | 1 | Permit Number 773687 | 5993009.87039 | 2114787.90553 | 37.7864019320171 | -122.467971834489 | (37.7864019320171, -122.467971834489) | |
| 43717 | 43717 | 68396 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 79 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 8 | Permit Number 32224 | 6002650.05866 | 2094394.34792 | 37.730958111031 | -122.433161575851 | (37.730958111031, -122.433161575851) | |
| 43718 | 43718 | 72882 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2610 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 5 | 5988659.6012 | 2097522.8498 | 37.7387446083711 | -122.48175741462799 | (37.7387446083711, -122.481757414628) | ||
| 44035 | 44035 | 78459 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2912 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 6 | 5990004.06273 | 2095836.28778 | 37.7341918338916 | -122.47698574601101 | (37.7341918338916, -122.476985746011) | ||
| 44819 | 44819 | 31282 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2566 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2015 12:00:00 AM | 2 | Permit Number 776171 | 5991125.05468 | 2097948.10611 | 37.7400553174119 | -122.47326412925 | (37.7400553174119, -122.47326412925) | |
| 45362 | 45362 | 31590 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1201 Ortega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 7 | Permit Number 35122 | 5990187.3877 | 2102420.0324 | 37.752279722243294 | -122.476832818906 | (37.7522797222433, -122.476832818906) | |
| 45590 | 45590 | 72004 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1923 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 6 | 5987214.1384 | 2102168.3069 | 37.7514156316864 | -122.487096166595 | (37.7514156316864, -122.487096166595) | ||
| 45728 | 45728 | 31591 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1201 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 7 | Permit Number 35122 | 5990136.5932 | 2102417.9378 | 37.7522710244136 | -122.47700831941499 | (37.7522710244136, -122.477008319415) | |
| 45737 | 45737 | 41183 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2246 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 9 | Permit Number 41901 | 5999456.41796 | 2120862.19039 | 37.803450468333295 | -122.44610557292101 | (37.8034504683333, -122.446105572921) | |
| 45740 | 45740 | 69311 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1574 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | 6 | Permit Number 33390 | 5986868.8891 | 2104543.7884 | 37.7579179205116 | -122.488464630716 | (37.7579179205116, -122.488464630716) | |
| 45948 | 45948 | 31821 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 195 07th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35284 | 6009820.27489 | 2111475.42861 | 37.778263073931704 | -122.409577954154 | (37.7782630739317, -122.409577954154) | |
| 46045 | 46045 | 67431 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 623 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30933 | 5989390.9839699995 | 2111085.0608099997 | 37.77602530991229 | -122.48022101287901 | (37.7760253099123, -122.480221012879) | |
| 46111 | 46111 | 38866 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2225 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 5 | Permit Number 40693 | 5987591.4161 | 2100131.0461 | 37.7458438500664 | -122.485642012437 | (37.7458438500664, -122.485642012437) | |
| 46263 | 46263 | 71785 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1100 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 8 | 6011579.56023 | 2119131.56016 | 37.7993834201653 | -122.404030839573 | (37.7993834201653, -122.404030839573) | ||
| 46719 | 46719 | 37192 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1695 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | 4 | Permit Number 39759 | 5986844.2604 | 2103759.2633 | 37.755762391781296 | -122.48849214772699 | (37.7557623917813, -122.488492147727) | |
| 46756 | 46756 | 32588 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1283 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 6 | 4.5x6.5 | Permit Number 37057 | 5985512.5122 | 2106502.2804 | 37.763216158758794 | -122.49329977168999 | (37.7632161587588, -122.49329977169) |
| 46796 | 46796 | 30754 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1520 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 7 | Permit Number 34635 | 6015179.7732 | 2093667.198 | 37.7296643113576 | -122.38979312406799 | (37.7296643113576, -122.389793124068) | |
| 47063 | 47063 | 52934 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 41 Rudden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48920 | 6000198.2283 | 2091989.23872 | 37.7242148468239 | -122.441465418297 | (37.7242148468239, -122.441465418297) |
| 47425 | 47425 | 52356 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 625 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 4 | Permit Number 48494 | 6007848.64495 | 2114584.12188 | 37.7866881189023 | -122.41661884179301 | (37.7866881189023, -122.416618841793) | |
| 47433 | 47433 | 67323 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 655 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 9 | Permit Number 30805 | 5993766.26481 | 2111040.62571 | 37.7761565661242 | -122.465082654926 | (37.7761565661242, -122.465082654926) | |
| 47647 | 47647 | 36191 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 622 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 6 | Permit Number 39258 | 5997190.9452 | 2113570.9992 | 37.7833011893143 | -122.453418558376 | (37.7833011893143, -122.453418558376) | |
| 47777 | 47777 | 51406 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1527 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | 6 | Permit Number 47731 | 5989602.3696 | 2104957.0693 | 37.759211796024 | -122.47904143970301 | (37.759211796024, -122.479041439703) | |
| 47959 | 47959 | 45494 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3017 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 5 | Permit Number 44269 | 5989985.693390001 | 2095129.1853099999 | 37.732249245209 | -122.47699760268299 | (37.732249245209, -122.476997602683) | |
| 48352 | 48352 | 95713 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 649 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767469 | 6004389.1114 | 2092283.11873 | 37.725259642297395 | -122.42699906688 | (37.7252596422974, -122.42699906688) |
| 48541 | 48541 | 64165 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 639 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1987 12:00:00 AM | 8 | 6x6 | Permit Number 24946 | 5992212.769859999 | 2111085.0802 | 37.7761889246553 | -122.47045980220899 | (37.7761889246553, -122.470459802209) |
| 48918 | 48918 | 80732 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1951 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/09/2002 12:00:00 AM | 5 | 6013374.43232 | 2096002.02585 | 37.735974988958795 | -122.39619799546699 | (37.7359749889588, -122.396197995467) | ||
| 49268 | 49268 | 71168 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2186 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 7 | 5988245.3089 | 2100453.2879 | 37.746766718916795 | -122.48340458939501 | (37.7467667189168, -122.483404589395) |
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");