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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30143 | 30143 | 36755 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1735 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39521 | 6011153.23525132 | 2095168.62195256 | 37.733562795365 | -122.403818978685 | (37.733562795365, -122.403818978685) | |||
| 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) | ||
| 30629 | 30629 | 44719 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1996 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2001 12:00:00 AM | 4 | Permit Number 43840 | 5989755.3727 | 2101809.9749 | 37.7505795958207 | -122.47828217651698 | (37.7505795958207, -122.478282176517) | ||
| 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) | |
| 31081 | 31081 | 31782 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35254 | 5989426.762 | 2097686.0113 | 37.739237190033705 | -122.47911689568501 | (37.7392371900337, -122.479116895685) | ||
| 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) | |
| 31593 | 31593 | 31217 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2302 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | 8 | Permit Number 34907 | 6002330.81724 | 2116170.96096 | 37.7907333000386 | -122.435822755238 | (37.7907333000386, -122.435822755238) | ||
| 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) | ||
| 32239 | 32239 | 68739 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1993 12:00:00 AM | 8 | Permit Number 32659 | 5997216.23373 | 2086785.97531 | 37.709757556936495 | -122.45139857511101 | (37.7097575569365, -122.451398575111) | ||
| 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) | |
| 33756 | 33756 | 44524 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 7 | Permit Number 43824 | 6019592.367330001 | 2094224.8297299999 | 37.73143917097 | -122.37457675743799 | (37.73143917097, -122.374576757438) | ||
| 33980 | 33980 | 41458 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2238 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | 5 | Permit Number 42045 | 6000808.8252 | 2113487.124 | 37.7832776042171 | -122.440896144552 | (37.7832776042171, -122.440896144552) | ||
| 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) | |
| 34632 | 34632 | 50701 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3001 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2004 12:00:00 AM | 7 | Permit Number 47264 | 5999727.05237 | 2116685.95347 | 37.7919990850303 | -122.44486865258101 | (37.7919990850303, -122.444868652581) | ||
| 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) | |
| 35520 | 35520 | 59616 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1011 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2011 12:00:00 AM | 2 | Permit Number 767194 | 6015550.11535 | 2104384.66837 | 37.7591127987462 | -122.389260889583 | (37.7591127987462, -122.389260889583) | ||
| 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) | |
| 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) | ||
| 36286 | 36286 | 85364 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1419 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2007 12:00:00 AM | 3 | Permit Number 49640 | 5985856.1332 | 2105557.8198 | 37.7606430250034 | -122.492041776178 | (37.7606430250034, -122.492041776178) | ||
| 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) | |
| 36706 | 36706 | 112246 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 5999047.56745 | 2088876.5109400002 | 37.715602390323 | -122.44521938006399 | (37.715602390323, -122.445219380064) | ||||
| 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) | |
| 36791 | 36791 | 30549 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 6 | Permit Number 34540 | 6011714.66567 | 2086401.56807 | 37.709521602706 | -122.4012620734 | (37.709521602706, -122.4012620734) | ||
| 36908 | 36908 | 51997 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 632 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2005 12:00:00 AM | 3 | Permit Number 48215 | 6007184.50143 | 2091591.36481 | 37.723517906401 | -122.41728665587401 | (37.723517906401, -122.417286655874) | ||
| 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) | |
| 37266 | 37266 | 52340 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 19 Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2005 12:00:00 AM | 4 | Permit Number 48486 | 6013965.88426 | 2114678.55584 | 37.7872895522129 | -122.39546112153201 | (37.7872895522129, -122.395461121532) | ||
| 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) | |
| 37584 | 37584 | 67257 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2398 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1992 12:00:00 AM | 4 | Permit Number 30722 | 5988295.5281 | 2099032.3985 | 37.7428682546948 | -122.483126808247 | (37.7428682546948, -122.483126808247) | ||
| 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) | |
| 37639 | 37639 | 41452 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2238 Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | 4 | Permit Number 42045 | 6000783.6399 | 2113482.3268 | 37.7832629979219 | -122.44098293116501 | (37.7832629979219, -122.440982931165) | ||
| 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) | |
| 38324 | 38324 | 52595 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1609@ 3RD ST Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2006 12:00:00 AM | 4 | Permit Number 48688 | 6015012.1029 | 2094417.3315 | 37.7317147273887 | -122.39042517523 | (37.7317147273887, -122.39042517523) | ||
| 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) | |
| 38575 | 38575 | 31216 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2302 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | 8 | Permit Number 34907 | 6002328.19974 | 2116193.32144 | 37.7907945474797 | -122.435833412206 | (37.7907945474797, -122.435833412206) | ||
| 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) | |
| 39019 | 39019 | 46159 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1596 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2006 12:00:00 AM | 3 | Permit Number 48875 | 6007667.62571 | 2109222.921 | 37.7719573667581 | -122.416865151707 | (37.7719573667581, -122.416865151707) | ||
| 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) | |
| 39859 | 39859 | 51949 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1403 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2005 12:00:00 AM | 2 | Permit Number 48173 | 5999695.6561 | 2113712.4863 | 37.7838329293103 | -122.44476345708 | (37.7838329293103, -122.44476345708) | ||
| 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) | ||
| 40680 | 40680 | 41077 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 465 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1999 12:00:00 AM | 4 | Permit Number 41835 | 6009599.89061 | 2108767.8166799997 | 37.7708162529988 | -122.410149139686 | (37.7708162529988, -122.410149139686) | ||
| 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) | |
| 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) | |
| 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) | ||
| 41222 | 41222 | 52084 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2672 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2005 12:00:00 AM | 5 | Permit Number 48282 | 6000173.86506 | 2118533.24935 | 37.7970967616558 | -122.44345543451901 | (37.7970967616558, -122.443455434519) | ||
| 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) | |
| 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) | |
| 42073 | 42073 | 51844 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 138 Cyril Magnin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 3 | Permit Number 48071 | 6010139.87184 | 2114143.25233 | 37.785606190409396 | -122.40866059710899 | (37.7856061904094, -122.408660597109) | ||
| 42326 | 42326 | 179980 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 14 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998613.38234 | 2086668.65922 | 37.7095153380418 | -122.446561361025 | (37.7095153380418, -122.446561361025) | ||||
| 42483 | 42483 | 97165 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 262 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6010119.55903 | 2111062.91718 | 37.777147179847105 | -122.408513509413 | (37.7771471798471, -122.408513509413) | ||||
| 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) | |
| 42887 | 42887 | 54465 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2028 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2010 12:00:00 AM | 4 | Permit Number 53960 | 6000443.592119999 | 2115689.82893 | 37.7893048537697 | -122.44231788388399 | (37.7893048537697, -122.442317883884) | ||
| 42988 | 42988 | 32159 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600 Linden St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246004 | 37.77585078754 | -122.42788259011999 | (37.77585078754, -122.42788259012) | |||
| 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) | ||
| 43778 | 43778 | 124094 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 Funston Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5991885.08534 | 2111292.1960400003 | 37.7767386560308 | -122.47160843754999 | (37.7767386560308, -122.47160843755) | ||||
| 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) | ||
| 44708 | 44708 | 32197 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 359 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1995 12:00:00 AM | 14 | Permit Number 35523 | 6002811.67417 | 2101505.61429 | 37.750493169246 | -122.433110745292 | (37.750493169246, -122.433110745292) | ||
| 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) | |
| 44914 | 44914 | 67271 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1580 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/1992 12:00:00 AM | 3 | Permit Number 30744 | 5988342.3996 | 2099014.9698 | 37.7428231275345 | -122.482963464559 | (37.7428231275345, -122.482963464559) | ||
| 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) |
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");