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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||
| 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 | ||||||||
| 7799 | 7799 | 36854 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9099 | 9099 | 36836 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9535 | 9535 | 36839 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 13906 | 13906 | 36837 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 15723 | 15723 | 36838 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 16572 | 16572 | 36840 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 120110 | 120110 | 36090 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1726 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2008 12:00:00 AM | 3x3 | Permit Number 50757 | 5981042.98067926 | 2103306.5346330004 | 37.7541791163278 | -122.50852086701299 | (37.7541791163278, -122.508520867013) | ||
| 120745 | 120745 | 31940 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1322 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 3x3 | Permit Number 767124 | 5981230.33279016 | 2106058.35423449 | 37.7617458665939 | -122.508077193589 | (37.7617458665939, -122.508077193589) | |
| 74938 | 74938 | 37090 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1241 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 5 | Permit Number 39690 | 5981472.6931 | 2106630.1727 | 37.7633301936195 | -122.507281405917 | (37.7633301936195, -122.507281405917) | |
| 11654 | 11654 | 81227 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1206 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50169 | 5981508.8658 | 2106840.309 | 37.7639092979165 | -122.50717188863001 | (37.7639092979165, -122.50717188863) | |
| 138817 | 138817 | 88105 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1509 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51109 | 5981537.1 | 2104800.5 | 37.758310230191796 | -122.506922920506 | (37.7583102301918, -122.506922920506) | |||
| 70761 | 70761 | 83338 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1509 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50174 | 5981536.4923 | 2104752.0807 | 37.7581772488217 | -122.50692143061701 | (37.7581772488217, -122.506921430617) | |
| 102269 | 102269 | 53172 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2266# SANTIAGO 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50744 | 5981447.24626217 | 2099655.9464458 | 37.7441794455765 | -122.506852079976 | (37.7441794455765, -122.506852079976) | ||
| 143120 | 143120 | 92455 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2379 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52845 | 5981718.2 | 2098908.8 | 37.7421439412615 | -122.50585981689501 | (37.7421439412615, -122.505859816895) | |
| 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) |
| 175363 | 175363 | 67533 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2379 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/1992 12:00:00 AM | 1 | Permit Number 31071 | 5981738.9441 | 2098908.0285 | 37.7421430439036 | -122.50578803434901 | (37.7421430439036, -122.505788034349) | ||
| 95106 | 95106 | 92456 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2395 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52846 | 5981742.1 | 2098798.2 | 37.741841671016296 | -122.505768982243 | (37.7418416710163, -122.505768982243) | |
| 56395 | 56395 | 68570 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 871 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 7 | Permit Number 32460 | 5981987.19537 | 2109819.09315 | 37.7721163387449 | -122.50573835921301 | (37.7721163387449, -122.505738359213) | |
| 49527 | 49527 | 84906 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4125 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | 1 | Permit No. 49330 | 5982037.1515 | 2104863.4571 | 37.7585125281424 | -122.505198218309 | (37.7585125281424, -122.505198218309) | ||
| 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) | |
| 173542 | 173542 | 82983 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4109 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53508 | 5982104.069 | 2104866.8183 | 37.7585256942415 | -122.504967040604 | (37.7585256942415, -122.504967040604) | |
| 172604 | 172604 | 92442 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1379 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52833 | 5982122.5039 | 2105719.7315 | 37.760868635571605 | -122.50496648970899 | (37.7608686355716, -122.504966489709) |
| 155007 | 155007 | 82813 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2143 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50735 | 5982301.7396 | 2100521.1161 | 37.7466052443518 | -122.503961546355 | (37.7466052443518, -122.503961546355) | |
| 26727 | 26727 | 81987 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 500 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50009 | 5982564.71804 | 2112307.54022 | 37.778982862079395 | -122.50392503614799 | (37.7789828620794, -122.503925036148) | |
| 133621 | 133621 | 81986 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7849 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50009 | 5982597.59734 | 2112350.81407 | 37.7791036127035 | -122.50381450115499 | (37.7791036127035, -122.503814501155) | |
| 135039 | 135039 | 81985 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7849 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50009 | 5982611.129980001 | 2112350.31973 | 37.779103051090004 | -122.503767650406 | (37.77910305109, -122.503767650406) | |
| 180228 | 180228 | 81984 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7849 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50009 | 5982627.56911 | 2112351.39821 | 37.779106978851104 | -122.50371086160601 | (37.7791069788511, -122.503710861606) | |
| 176123 | 176123 | 81983 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7849 Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50009 | 5982648.09579 | 2112351.28707 | 37.7791078805619 | -122.50363984441401 | (37.7791078805619, -122.503639844414) | |
| 76271 | 76271 | 83250 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2274 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767120 | 5982380.00830006 | 2099635.57983168 | 37.7441784094816 | -122.503625338719 | (37.7441784094816, -122.503625338719) |
| 161725 | 161725 | 83248 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2274 45th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 0 | 3x3 | Permit Number 767120 | 5982380.00830006 | 2099635.57983168 | 37.7441784094816 | -122.503625338719 | (37.7441784094816, -122.503625338719) |
| 151259 | 151259 | 81980 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7849 Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50009 | 5982658.1733 | 2112352.7880599997 | 37.779112594333 | -122.503605093969 | (37.779112594333, -122.503605093969) | |
| 66156 | 66156 | 83781 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1659 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 0 | 3x3 | Permit Number 50155 | 5982495.52405301 | 2103826.42890592 | 37.755692101870295 | -122.503536193946 | (37.7556921018703, -122.503536193946) | |
| 116131 | 116131 | 92443 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2638 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52834 | 5982485.5 | 2097144.3 | 37.7373442414634 | -122.503076173661 | (37.7373442414634, -122.503076173661) | |
| 111170 | 111170 | 24787 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7795X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1996 12:00:00 AM | 3 | 2X2 | 5982848.853180001 | 2112367.91788 | 37.779165345195295 | -122.502946585831 | (37.7791653451953, -122.502946585831) | ||
| 75836 | 75836 | 92434 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1226 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52824 | 5982753.5838 | 2106746.8454 | 37.7637259061718 | -122.502859934877 | (37.7637259061718, -122.502859934877) |
| 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) |
| 168512 | 168512 | 47429 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 414 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45340 | 5983162.480819999 | 2112997.63068 | 37.780912780316896 | -122.50190824288 | (37.7809127803169, -122.50190824288) | |
| 179418 | 179418 | 69844 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 674 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49993 | 5983224.84403 | 2111218.56534 | 37.7760316491492 | -122.501560849975 | (37.7760316491492, -122.501560849975) | |
| 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) | |
| 182970 | 182970 | 92749 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2415 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52978 | 5982987.8536 | 2098677.8731 | 37.741584528853004 | -122.50145274491001 | (37.741584528853, -122.50145274491) |
| 135278 | 135278 | 52577 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1835 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767117 | 5983162.3462 | 2102634.391 | 37.7524582800478 | -122.501141985909 | (37.7524582800478, -122.501141985909) |
| 166207 | 166207 | 92463 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3504 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2008 12:00:00 AM | 2 | 3x3 | Permit Number 52850 | 5983354.8124 | 2104279.9828 | 37.756987914860396 | -122.500598085539 | (37.7569879148604, -122.500598085539) |
| 149327 | 149327 | 88117 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3502 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51118 | 5983368.2577 | 2104281.5107 | 37.7569928993429 | -122.500551700333 | (37.7569928993429, -122.500551700333) | |
| 154855 | 154855 | 79361 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3500 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51118 | 5983385.6754 | 2104281.2051 | 37.7569930827191 | -122.50049144171601 | (37.7569930827191, -122.500491441716) | |
| 83677 | 83677 | 92465 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3500 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 52850 | 5983435.0 | 2104281.0 | 37.7569954148981 | -122.500320846178 | (37.7569954148981, -122.500320846178) | |
| 50886 | 50886 | 92429 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1578 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52820 | 5983453.9 | 2104408.1 | 37.7573455051826 | -122.500264880207 | (37.7573455051826, -122.500264880207) |
| 151289 | 151289 | 92459 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3445 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52849 | 5983483.9499 | 2104230.4645 | 37.756859531675296 | -122.50014782582399 | (37.7568595316753, -122.500147825824) |
| 144253 | 144253 | 51524 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3131 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/13/2005 12:00:00 AM | 4 | Permit Number 47826 | 5983421.0943 | 2100138.6688 | 37.7456209081876 | -122.500062730705 | (37.7456209081876, -122.500062730705) | |
| 185924 | 185924 | 92461 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3445 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52849 | 5983517.9831 | 2104231.1385 | 37.756863379703205 | -122.500030178068 | (37.7568633797032, -122.500030178068) |
| 133958 | 133958 | 81522 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 870 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49966 | 5983894.59301 | 2109909.4631 | 37.77247654532321 | -122.499147296893 | (37.7724765453232, -122.499147296893) | |
| 99508 | 99508 | 88097 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1883 40th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51100 | 5983774.4 | 2102354.2 | 37.751724874757 | -122.49900473519399 | (37.751724874757, -122.499004735194) | |||
| 61549 | 61549 | 67247 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4726 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 4 | Permit Number 30711 | 5983993.6007199995 | 2111768.26164 | 37.7775860776766 | -122.49894218099399 | (37.7775860776766, -122.498942180994) | |
| 50989 | 50989 | 92422 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1251 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52816 | 5983956.6528 | 2106653.574 | 37.7635404418395 | -122.49869206504499 | (37.7635404418395, -122.498692065045) |
| 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) |
| 160220 | 160220 | 79742 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 655 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49962 | 5984104.63017 | 2111373.754 | 37.776509385703 | -122.49852895056601 | (37.776509385703, -122.498528950566) | |
| 53497 | 53497 | 65134 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 608 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 8 | Permit Number 27109 | 5984138.754 | 2111678.31461 | 37.777347622230295 | -122.49843340934099 | (37.7773476222303, -122.498433409341) | |
| 85753 | 85753 | 35230 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2559 40th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1998 12:00:00 AM | Permit Number 38723 | 5983945.81332692 | 2097751.53443122 | 37.7390972690525 | -122.49807210271999 | (37.7390972690525, -122.49807210272) | ||
| 129867 | 129867 | 47449 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4629 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 3 | Permit Number 45358 | 5984272.92923 | 2111724.35725 | 37.7774819093186 | -122.497972661623 | (37.7774819093186, -122.497972661623) | |
| 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) |
| 186193 | 186193 | 69033 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1363 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 4 | Permit Number 33039 | 5984290.4784 | 2105907.3828 | 37.7615111837365 | -122.497482392959 | (37.7615111837365, -122.497482392959) | |
| 97308 | 97308 | 24714 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7230 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1996 12:00:00 AM | 5 | 5 | 5984526.3163 | 2112508.7782400004 | 37.7796505549558 | -122.49715404202601 | (37.7796505549558, -122.497154042026) | ||
| 57328 | 57328 | 92420 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1727 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52813 | 5984376.6037 | 2103407.8540000003 | 37.7546532229769 | -122.49700002920099 | (37.7546532229769, -122.497000029201) |
| 24150 | 24150 | 67029 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1742 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/1992 12:00:00 AM | 10 | Permit Number 30397 | 5984423.6443 | 2103304.9738 | 37.7543734989147 | -122.496829760136 | (37.7543734989147, -122.496829760136) | ||
| 94073 | 94073 | 32182 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 187 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35515 | 5984242.60551895 | 2094230.34339508 | 37.7294464187928 | -122.496786144383 | (37.7294464187928, -122.496786144383) | ||
| 108576 | 108576 | 32181 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 187 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35515 | 5984242.60551895 | 2094230.34339508 | 37.7294464187928 | -122.496786144383 | (37.7294464187928, -122.496786144383) | ||
| 95816 | 95816 | 32179 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 183 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35514 | 5984280.14048735 | 2094205.11731478 | 37.7293793539098 | -122.49665452348101 | (37.7293793539098, -122.496654523481) | ||
| 109304 | 109304 | 32180 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 183 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35514 | 5984280.14048735 | 2094205.11731478 | 37.7293793539098 | -122.49665452348101 | (37.7293793539098, -122.496654523481) | ||
| 85883 | 85883 | 88089 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1870 38th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51092 | 5984476.8 | 2102440.2 | 37.752002183643704 | -122.49658212531601 | (37.7520021836437, -122.496582125316) | |||
| 143136 | 143136 | 35005 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3520 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | Permit Number 38580 | 5984685.84322445 | 2111111.85147168 | 37.7758243442421 | -122.496499067799 | (37.7758243442421, -122.496499067799) | |||
| 96616 | 96616 | 32176 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 171 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35513 | 5984396.34237134 | 2094161.85808413 | 37.7292673830802 | -122.496249618321 | (37.7292673830802, -122.496249618321) | ||
| 100638 | 100638 | 32178 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 171 Lakeshore Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35513 | 5984396.34237134 | 2094161.85808413 | 37.7292673830802 | -122.496249618321 | (37.7292673830802, -122.496249618321) | |||
| 139271 | 139271 | 32177 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 171 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35513 | 5984396.34237134 | 2094161.85808413 | 37.7292673830802 | -122.496249618321 | (37.7292673830802, -122.496249618321) | |||
| 11756 | 11756 | 66531 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3712 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51731 | 5984484.0259 | 2098196.2697 | 37.740349933336795 | -122.496244041207 | (37.7403499333368, -122.496244041207) | |
| 133210 | 133210 | 95645 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 827 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 3 | 3c3 | Permit Number 767416 | 5984764.15602 | 2110237.7385400003 | 37.7734288681466 | -122.49616366215 | (37.7734288681466, -122.49616366215) |
| 162892 | 162892 | 66529 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3702 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51730 | 5984508.7196 | 2098197.9611 | 37.7403560239279 | -122.49615878623001 | (37.7403560239279, -122.49615878623) | |
| 132472 | 132472 | 80827 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2550 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52815 | 5984612.7374 | 2097823.3277 | 37.7393334739729 | -122.495771511551 | (37.7393334739729, -122.495771511551) |
| 99190 | 99190 | 24693 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7027 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2001 12:00:00 AM | 3 | 3X3 | 5985174.118369999 | 2112443.2736299997 | 37.7795086405244 | -122.494908216235 | (37.7795086405244, -122.494908216235) | ||
| 147045 | 147045 | 54023 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 894 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1972 12:00:00 AM | 8 | Permit Number 9742 | 5985137.880030001 | 2109802.85979 | 37.7722566986547 | -122.494838846537 | (37.7722566986547, -122.494838846537) | ||
| 122944 | 122944 | 24694 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7015 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2005 12:00:00 AM | 3 | 3X3 | 5985229.89769 | 2112446.70725 | 37.7795213333023 | -122.49471550785299 | (37.7795213333023, -122.494715507853) | ||
| 150109 | 150109 | 60531 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4300 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1982 12:00:00 AM | 4 | Permit Number 20141 | 5985279.38997 | 2111816.9882900002 | 37.7777952027795 | -122.494497861319 | (37.7777952027795, -122.494497861319) | ||
| 27592 | 27592 | 32603 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1259 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52898 | 5985198.7047 | 2106634.6319999998 | 37.763561199335 | -122.494394868279 | (37.763561199335, -122.494394868279) | |
| 86685 | 86685 | 32600 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37067 | 5985231.92181857 | 2107024.54943344 | 37.764633747264 | -122.494308725231 | (37.764633747264, -122.494308725231) | ||
| 112970 | 112970 | 32601 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/2002 12:00:00 AM | Permit Number 37067 | 5985231.92181857 | 2107024.54943344 | 37.764633747264 | -122.494308725231 | (37.764633747264, -122.494308725231) | ||
| 117437 | 117437 | 32602 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200 35th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37067 | 5985231.92181857 | 2107024.54943344 | 37.764633747264 | -122.494308725231 | (37.764633747264, -122.494308725231) | ||
| 182474 | 182474 | 95520 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1214 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767312 | 5985232.1017 | 2106922.0105 | 37.7643522146303 | -122.49430054433998 | (37.7643522146303, -122.49430054434) |
| 83105 | 83105 | 24696 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6945 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1996 12:00:00 AM | 3 | 3X3 | 5985386.7749 | 2112452.6030099997 | 37.7795467024894 | -122.494173245228 | (37.7795467024894, -122.494173245228) | ||
| 116739 | 116739 | 24702 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6960X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/1997 12:00:00 AM | 6 | 3X3 | 5985448.699 | 2112539.82833 | 37.779789821514704 | -122.49396545647801 | (37.7797898215147, -122.493965456478) | ||
| 184797 | 184797 | 95523 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2944 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 23x3 | Permit Number 767315 | 5985332.6897 | 2105713.6699 | 37.7610403347331 | -122.493863589694 | (37.7610403347331, -122.493863589694) |
| 45308 | 45308 | 93192 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2750 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53198 | 5985395.3318 | 2103003.1574 | 37.7536016817207 | -122.49344722853701 | (37.7536016817207, -122.493447228537) | |
| 137583 | 137583 | 37223 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1275 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 8 | Permit Number 39787 | 5985506.0184 | 2106556.0011 | 37.763363280972 | -122.493326189315 | (37.763363280972, -122.493326189315) | |
| 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) |
| 122174 | 122174 | 114777 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1930 35TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x4 | 5985421.0 | 2102058.0 | 37.7510080399178 | -122.493288836187 | (37.7510080399178, -122.493288836187) | |||
| 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) | |
| 71401 | 71401 | 81903 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1328 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52696 | 5985568.5282 | 2106151.3811 | 37.762255963375104 | -122.49308018325 | (37.7622559633751, -122.49308018325) | |
| 153014 | 153014 | 92532 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1561 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52877 | 5985578.9968 | 2104595.7831 | 37.7579853351637 | -122.49292938719 | (37.7579853351637, -122.49292938719) | |
| 55083 | 55083 | 37226 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1506 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 7 | Permit Number 39790 | 5985611.0851 | 2104930.1177 | 37.7589052019747 | -122.492843039355 | (37.7589052019747, -122.492843039355) | |
| 152544 | 152544 | 92253 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1558 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52702 | 5985620.6386 | 2104618.8142 | 37.758051007326294 | -122.49278707056101 | (37.7580510073263, -122.492787070561) | |
| 187608 | 187608 | 92252 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1558 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52702 | 5985620.6386 | 2104602.1565 | 37.7580052698857 | -122.492785843667 | (37.7580052698857, -122.492785843667) |
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");