Data source: data.sfgov.org
This data as json, CSV (advanced)
PlantType ✖
| 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 | |||||||||
| 107526 | 107526 | 120527 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1672 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/2016 12:00:00 AM | 3 | 3x3 | 5981030.0 | 2103685.0 | 37.7552175094175 | -122.508593851446 | (37.7552175094175, -122.508593851446) | ||
| 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) | ||
| 139016 | 139016 | 115674 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1433 48th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774098 | 5981190.2 | 2105303.4 | 37.7596706142775 | -122.508159957785 | (37.7596706142775, -122.508159957785) | ||
| 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) | |
| 679 | 679 | 187631 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4255x Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/28/2017 11:56:00 AM | 3 | 3x3 | 5981269.0 | 2105492.0 | 37.760193098921796 | -122.50790142928699 | (37.7601930989218, -122.507901429287) | |
| 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) |
| 139749 | 139749 | 819 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 5982179.061767 | 2105489.8566905 | 37.7602407921924 | -122.50475385101299 | (37.7602407921924, -122.504753851013) | ||
| 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) |
| 184288 | 184288 | 184151 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1585 44th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5982482.7335 | 2104338.124 | 37.7570963201307 | -122.503618318652 | (37.7570963201307, -122.503618318652) | |||
| 85446 | 85446 | 70434 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 855 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 8 | 3x3 | 5982604.49779 | 2109922.26737 | 37.772435937677 | -122.50361073719101 | (37.772435937677, -122.503610737191) | |
| 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) | |
| 104242 | 104242 | 24786 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7795X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 5982848.853180001 | 2112367.91788 | 37.779165345195295 | -122.502946585831 | (37.7791653451953, -122.502946585831) | |||
| 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) | ||
| 142325 | 142325 | 24788 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7795X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 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) |
| 178776 | 178776 | 117671 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7751 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5982939.1996 | 2112495.32744 | 37.779520484123104 | -122.502643478899 | (37.7795204841231, -122.502643478899) | |||
| 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) | |
| 1439 | 1439 | 185582 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2227 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982934.0602 | 2099947.7625 | 37.74506813637971 | -122.501732671769 | (37.7450681363797, -122.501732671769) | |||
| 30154 | 30154 | 183214 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2227 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982941.6342 | 2099948.9314 | 37.7450717907388 | -122.501706569109 | (37.7450717907388, -122.501706569109) | |||
| 26855 | 26855 | 73378 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 6 | 5983190.4387300005 | 2110910.57285 | 37.775183970412996 | -122.501657073915 | (37.775183970413, -122.501657073915) | ||
| 27399 | 27399 | 70234 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 5 | 5983192.21244 | 2110893.91815 | 37.775138345619396 | -122.501649705941 | (37.7751383456194, -122.501649705941) | ||
| 70331 | 70331 | 117916 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 767 41st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5983202.27685 | 2110567.72897 | 37.774243315823 | -122.50159075488199 | (37.774243315823, -122.501590754882) | |||
| 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) | |
| 157423 | 157423 | 70369 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1454 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5983117.2046 | 2105238.7271 | 37.759606404775504 | -122.50149073173 | (37.7596064047755, -122.50149073173) | ||
| 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) |
| 1436 | 1436 | 251534 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1818 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2017 12:00:00 AM | 3 | 3x3 | 5983226.0 | 2102732.0 | 37.7527300247516 | -122.500929082058 | (37.7527300247516, -122.500929082058) | ||
| 76305 | 76305 | 117811 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3900 Balboa St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5983417.72133 | 2111068.00979 | 37.7756295936656 | -122.500882510539 | (37.7756295936656, -122.500882510539) | |||
| 157054 | 157054 | 117810 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3900 Balboa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5983435.8932 | 2111067.84465 | 37.7756302071512 | -122.500819638377 | (37.7756302071512, -122.500819638377) | |||
| 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) | |
| 186825 | 186825 | 117864 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 798 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5983563.27661 | 2110414.76175 | 37.7738445083611 | -122.50033069971902 | (37.7738445083611, -122.500330699719) | |||
| 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) | |
| 123089 | 123089 | 89522 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4840X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983600.56416 | 2111754.2609599996 | 37.777524573978795 | -122.500300769655 | (37.7775245739788, -122.500300769655) | ||
| 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) |
| 142950 | 142950 | 89521 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4820 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983664.064230001 | 2111757.54508 | 37.7775373182225 | -122.50008134805701 | (37.7775373182225, -122.500081348057) | ||
| 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) |
| 97597 | 97597 | 89520 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4820 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983683.74695 | 2111758.73877 | 37.7775417509019 | -122.500013348293 | (37.7775417509019, -122.500013348293) | ||
| 107648 | 107648 | 89519 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4800X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983703.81735 | 2111759.11711 | 37.7775439675788 | -122.499943947143 | (37.7775439675788, -122.499943947143) | ||
| 110914 | 110914 | 89516 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4748 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983894.62294 | 2111764.32233 | 37.77756945530871 | -122.49928428189 | (37.7775694553087, -122.49928428189) | ||
| 120734 | 120734 | 89580 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4733 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983932.01872 | 2111712.46755 | 37.7774292709074 | -122.499151086884 | (37.7774292709074, -122.499151086884) | ||
| 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) | |
| 107373 | 107373 | 24802 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7421 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1998 12:00:00 AM | 3 | 3X3 | 5983963.262159999 | 2112367.75852 | 37.7792303425964 | -122.49909143689301 | (37.7792303425964, -122.499091436893) | ||
| 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) | |||
| 173866 | 173866 | 184499 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1883 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983787.5805 | 2102357.2236 | 37.751733949862 | -122.49895937936 | (37.751733949862, -122.49895937936) | |||
| 120361 | 120361 | 89581 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4701X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983989.2222 | 2111715.07963 | 37.77743979845 | -122.498953397347 | (37.77743979845, -122.498953397347) | ||
| 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) | |
| 138488 | 138488 | 89514 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4700X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984022.808019999 | 2111769.45407 | 37.7775910648921 | -122.49884123281099 | (37.7775910648921, -122.498841232811) | ||
| 104936 | 104936 | 89515 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4726 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984027.6428 | 2111762.466354 | 37.7775721622219 | -122.498823991577 | (37.7775721622219, -122.498823991577) | |
| 138717 | 138717 | 89583 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4701X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984031.59571 | 2111715.99081 | 37.7774447856814 | -122.498806883027 | (37.7774447856814, -122.498806883027) | ||
| 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) |
| 175668 | 175668 | 71632 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 623 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 8 | 5984096.438130001 | 2111562.96127 | 37.777028413768704 | -122.498571268398 | (37.7770284137687, -122.498571268398) | ||
| 135020 | 135020 | 73618 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 623 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 7 | 5984097.49569 | 2111586.76051 | 37.7770938216215 | -122.49856936845501 | (37.7770938216215, -122.498569368455) | ||
| 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) | |
| 129491 | 129491 | 89586 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4645 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984184.92842 | 2111721.99859 | 37.7774702734312 | -122.498276906644 | (37.7774702734312, -122.498276906644) | ||
| 107971 | 107971 | 89511 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4648X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984186.479180001 | 2111775.6446599998 | 37.777617660957105 | -122.49827550526301 | (37.7776176609571, -122.498275505263) | ||
| 87047 | 87047 | 89510 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4648X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984200.684219999 | 2111776.55204 | 37.7776209852867 | -122.498226433022 | (37.7776209852867, -122.498226433022) | ||
| 21242 | 21242 | 89587 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4645 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984204.9902099995 | 2111721.97383 | 37.777471381785105 | -122.49820750551599 | (37.7774713817851, -122.498207505516) | ||
| 90266 | 90266 | 89588 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4645 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984227.08627 | 2111722.30931 | 37.7774735984877 | -122.49813109389099 | (37.7774735984877, -122.498131093891) | ||
| 100750 | 100750 | 89509 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4632 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984241.49316 | 2111780.1203799997 | 37.7776331756753 | -122.49808552687 | (37.7776331756753, -122.49808552687) | ||
| 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) | ||
| 76350 | 76350 | 24722 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7328 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 24 | 5 | 5984267.75782 | 2112498.96385 | 37.7796084515897 | -122.49804776887501 | (37.7796084515897, -122.498047768875) | ||
| 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) |
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");