7,322 rows where qSpecies_id = 1 sorted by Longitude descending

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▲ Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
157079 119174 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 738 La Playa 1 Sidewalk: Curb side : Yard Tree DPW 1     7 Width 8ft   5980754.24139 2110680.27075 37.7744082353086 -122.510067160899 (37.7744082353086, -122.510067160899) 11 6 2 55 26
41118 119176 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 742 La Playa 1 Sidewalk: Curb side : Cutout Tree DPW 1     9 Width 8ft   5980756.08521 2110656.0073 37.7743417237871 -122.510058979927 (37.7743417237871, -122.510058979927) 11 6 2 55 26
8267 119175 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 742 La Playa 2 Sidewalk: Curb side : Cutout Tree DPW 1     7 Width 8ft   5980756.90149 2110662.55033 37.7743597371632 -122.510056642513 (37.7743597371632, -122.510056642513) 11 6 2 55 26
3579 119169 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 720 La Playa 1 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 3ft   5980759.87673 2110793.19365 37.7747186206505 -122.510056058609 (37.7747186206505, -122.510056058609) 11 6 2 55 26
136118 119178 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 756 La Playa 3 Sidewalk: Curb side : Cutout Tree DPW 1     9 Width 3ft   5980765.96509 2110596.91774 37.7741800640196 -122.510020413475 (37.7741800640196, -122.510020413475) 11 6 2 55 26
56411 119179 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 756 La Playa 2 Sidewalk: Curb side : Cutout Tree DPW 1     5 Width 3ft   5980765.91375 2110586.65735 37.7741518889865 -122.510019828655 (37.7741518889865, -122.510019828655) 11 6 2 55 26
95441 119180 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 756 La Playa 1 Sidewalk: Curb side : Cutout Tree DPW 1     9 Width 3ft   5980766.80768 2110581.0869 37.7741366468987 -122.510016322531 (37.7741366468987, -122.510016322531) 11 6 2 55 26
101951 50783 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 770 La Playa 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/07/2018 12:00:00 AM 14   Permit Number 47309 5980766.08534 2110461.55309 37.7738083996933 -122.510009939122 (37.7738083996933, -122.510009939122) 11 6 2 55 26
61314 119181 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 758 La Playa 1 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 3ft   5980769.04237 2110551.43207 37.7740553552846 -122.510006388961 (37.7740553552846, -122.510006388961) 11 6 2 55 26
53123 119182 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 770 La Playa 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/08/2018 08:55:00 AM 3 Width 3ft   5980768.60163 2110516.49212 37.7739593944882 -122.510005317294 (37.7739593944882, -122.510005317294) 11 6 2 55 26
56005 119183 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 770 La Playa 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/13/2018 08:27:00 AM 3 Width 3ft   5980769.13154 2110513.52409 37.7739512764073 -122.510003263739 (37.7739512764073, -122.510003263739) 11 6 2 55 26
115445 119185 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 780 La Playa 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 Width 4ft   5980776.33193 2110309.65746 37.7733919433929 -122.50996320874 (37.7733919433929, -122.50996320874) 11 6 2 55 26
138881 119184 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 780 La Playa 2 Sidewalk: Curb side : Cutout Tree DPW 1     10 Width 4ft   5980778.38631 2110329.2751 37.773445928821 -122.509957560132 (37.773445928821, -122.509957560132) 11 6 2 55 26
125559 120527 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1672 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2016 12:00:00 AM 3 3x3   5981030 2103685 37.7552175094175 -122.508593851446 (37.7552175094175, -122.508593851446) 1 8 3 56 35
159304 36090 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1726 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2008 12:00:00 AM   3x3 Permit Number 50757 5981042.98067926 2103306.534633 37.7541791163278 -122.508520867013 (37.7541791163278, -122.508520867013) 1 8 3 56 35
184166 115674 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1433 48th Ave   Sidewalk: Curb side : Cutout Tree Private 2   10/18/2016 12:00:00 AM 3 3x3 Permit Number 774098 5981190.2 2105303.4 37.7596706142775 -122.508159957785 (37.7596706142775, -122.508159957785) 1 8 3 56 35
165381 31940 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1322 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/2011 12:00:00 AM   3x3 Permit Number 767124 5981230.33279016 2106058.35423449 37.7617458665939 -122.508077193589 (37.7617458665939, -122.508077193589) 1 8 3 56 35
51281 187631 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4255x Judah St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 03/28/2017 11:56:00 AM 3 3x3   5981269 2105492 37.7601930989218 -122.507901429287 (37.7601930989218, -122.507901429287) 1 8 3 56 35
9722 253988 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 680 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3 3x3   5981392 2111100 37.7755982845187 -122.507892228296 (37.7755982845187, -122.507892228296) 11 6 2 55 26
52235 90921 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 5500 Anza St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2018 09:55:00 AM 3 3x3   5981544.5953 2111683.77471 37.7772101475974 -122.507407695808 (37.7772101475974, -122.507407695808) 11 6 2 55 26
20393 90920 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 5500 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2018 09:52:00 AM 3 3x3   5981566.35935 2111684.48442 37.7772133782314 -122.507332461007 (37.7772133782314, -122.507332461007) 11 6 2 55 26
188211 37090 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1241 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 5   Permit Number 39690 5981472.6931 2106630.1727 37.7633301936195 -122.507281405917 (37.7633301936195, -122.507281405917) 1 8 3 56 35
125542 81227 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1206 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2008 12:00:00 AM 3 3x3 Permit Number 50169 5981508.8658 2106840.309 37.7639092979165 -122.50717188863 (37.7639092979165, -122.50717188863) 1 8 3 56 35
12353 832 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1396 47th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2017 12:18:00 PM 3 3X3   5981551.7086 2105613.8347 37.7605442750604 -122.506932728621 (37.7605442750604, -122.506932728621) 1 8 3 56 35
178714 88105 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1509 47th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/01/2008 12:00:00 AM   3x3 Permit Number 51109 5981537.1 2104800.5 37.7583102301918 -122.506922920506 (37.7583102301918, -122.506922920506) 1 8 3 56 35
173318 83338 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1509 47th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2008 12:00:00 AM 1 3x3 Permit Number 50174 5981536.4923 2104752.0807 37.7581772488217 -122.506921430617 (37.7581772488217, -122.506921430617) 1 8 3 56 35
113378 53172 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2266# SANTIAGO 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM   3x3 Permit Number 50744 5981447.24626217 2099655.9464458 37.7441794455765 -122.506852079976 (37.7441794455765, -122.506852079976) 1 8 3 29491 35
10298 261226 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1582 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2019 12:00:00 AM 3 4x6   5981619 2104320 37.7569957368703 -122.506604043387 (37.7569957368703, -122.506604043387) 1 8 3 56 35
5201 261538 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 667 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3 Width 3ft   5981910 2111209 37.7759280729172 -122.506108454702 (37.7759280729172, -122.506108454702) 11 6 2 55 26
2949 261537 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 612 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3 Width 3ft   5981957 2111327 37.7762548329233 -122.505954622938 (37.7762548329233, -122.505954622938) 11 6 2 55 26
10302 261536 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 602 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3 Width 3ft   5981957 2111327 37.7762548329233 -122.505954622938 (37.7762548329233, -122.505954622938) 11 6 2 55 26
18992 261220 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2970 Sloat Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/2020 12:00:00 AM 3 4x6   5981657 2096559 37.7356884360348 -122.505897251941 (37.7356884360348, -122.505897251941) 1 8 3 29491 35
186858 92455 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2379 47th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/2009 12:00:00 AM   3x3 Permit Number 52845 5981718.2 2098908.8 37.7421439412615 -122.505859816895 (37.7421439412615, -122.505859816895) 1 8 3 29491 35
150776 46400 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2371 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/2011 12:00:00 AM 0 3x3 Permit Number 767122 5981730.59814192 2098955.65959072 37.7422733344517 -122.505820421933 (37.7422733344517, -122.505820421933) 1 8 3 29491 35
71409 67533 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2379 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/24/1992 12:00:00 AM 1   Permit Number 31071 5981738.9441 2098908.0285 37.7421430439036 -122.505788034349 (37.7421430439036, -122.505788034349) 1 8 3 29491 35
92043 92456 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2395 47th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/2009 12:00:00 AM   3x3 Permit Number 52846 5981742.1 2098798.2 37.7418416710163 -122.505768982243 (37.7418416710163, -122.505768982243) 1 8 3 29491 35
33820 68570 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 871 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM 7   Permit Number 32460 5981987.19537 2109819.09315 37.7721163387449 -122.505738359213 (37.7721163387449, -122.505738359213) 11 6 2 55 26
66351 84906 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4125 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2007 12:00:00 AM 1   Permit No. 49330 5982037.1515 2104863.4571 37.7585125281424 -122.505198218309 (37.7585125281424, -122.505198218309) 1 8 3 56 35
137674 37081 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1233 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 5   Permit Number 39682 5982089.3021 2106698.5454 37.7635542250983 -122.505153861082 (37.7635542250983, -122.505153861082) 1 8 3 56 35
46220 82983 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4109 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2010 12:00:00 AM 1 3x3 Permit Number 53508 5982104.069 2104866.8183 37.7585256942415 -122.504967040604 (37.7585256942415, -122.504967040604) 1 8 3 56 35
116651 92442 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1379 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/2009 12:00:00 AM 2 3x3 Permit Number 52833 5982122.5039 2105719.7315 37.7608686355716 -122.504966489709 (37.7608686355716, -122.504966489709) 1 8 3 56 35
97974 40209 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 546 44th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/29/2018 12:00:00 AM 3   Permit Number 41391 5982263.05386 2112038.67189 37.7782268854551 -122.504948666417 (37.7782268854551, -122.504948666417) 11 6 2 55 26
108692 52086 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 550 44th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/29/2018 12:00:00 AM 3   Permit Number 48283 5982264.87127 2112012.82882 37.7781560348973 -122.504940463882 (37.7781560348973, -122.504940463882) 11 6 2 55 26
7653 118738 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 664 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3 Width 4ft   5982292.77249 2111243.99533 37.7760466849131 -122.504786961569 (37.7760466849131, -122.504786961569) 11 6 2 55 26
181559 819 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1410 45th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/25/2008 12:00:00 AM 3 3X3   5982179.061767 2105489.8566905 37.7602407921924 -122.504753851013 (37.7602407921924, -122.504753851013) 1 8 3 56 35
43991 118444 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 5248 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2018 09:37:00 AM 3 Width 3ft   5982318.73314 2111710.8032 37.7773299298102 -122.504731754716 (37.7773299298102, -122.504731754716) 11 6 2 55 26
15029 69788 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1526 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2020 12:00:00 AM 3 4x6   5982204.5216 2104686.309 37.7580359763889 -122.504606262253 (37.7580359763889, -122.504606262253) 1 8 3 56 35
156502 254346 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 5214 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3     5982448 2111730 37.7773902420223 -122.504286008671 (37.7773902420223, -122.504286008671) 11 6 2 55 26
180151 82813 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2143 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 3 3x3 Permit Number 50735 5982301.7396 2100521.1161 37.7466052443518 -122.503961546355 (37.7466052443518, -122.503961546355) 1 8 3 29491 35
154851 81987 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 500 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2007 12:00:00 AM 3 3x3 Permit Number 50009 5982564.71804 2112307.54022 37.7789828620794 -122.503925036148 (37.7789828620794, -122.503925036148) 11 6 2 55 26
103691 81986 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 7849 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2007 12:00:00 AM 4 3x3 Permit Number 50009 5982597.59734 2112350.81407 37.7791036127035 -122.503814501155 (37.7791036127035, -122.503814501155) 11 6 2 55 26
174535 81985 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 7849 Geary Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2007 12:00:00 AM 4 3x3 Permit Number 50009 5982611.12998 2112350.31973 37.77910305109 -122.503767650406 (37.77910305109, -122.503767650406) 11 6 2 55 26
110675 81984 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 7849 Geary Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2007 12:00:00 AM 4 3x3 Permit Number 50009 5982627.56911 2112351.39821 37.7791069788511 -122.503710861606 (37.7791069788511, -122.503710861606) 11 6 2 55 26
14830 146918 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 787 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 12:53:00 PM 0 Width 3ft   5982587.71867 2110421.43363 37.7738055167411 -122.503705750643 (37.7738055167411, -122.503705750643) 11 6 2 55 26
129319 81983 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 7849 Geary Blvd 5 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2007 12:00:00 AM 3 3x3 Permit Number 50009 5982648.09579 2112351.28707 37.7791078805619 -122.503639844414 (37.7791078805619, -122.503639844414) 11 6 2 55 26
67874 83248 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2274 45th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/2011 12:00:00 AM 0 3x3 Permit Number 767120 5982380.00830006 2099635.57983168 37.7441784094816 -122.503625338719 (37.7441784094816, -122.503625338719) 1 8 3 29491 35
177010 83250 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2274 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/2011 12:00:00 AM 5 3x3 Permit Number 767120 5982380.00830006 2099635.57983168 37.7441784094816 -122.503625338719 (37.7441784094816, -122.503625338719) 1 8 3 29491 35
179592 184151 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1585 44th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 0ft   5982482.7335 2104338.124 37.7570963201307 -122.503618318652 (37.7570963201307, -122.503618318652) 1 8 3 56 35
1870 70434 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 855 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8 3x3   5982604.49779 2109922.26737 37.772435937677 -122.503610737191 (37.772435937677, -122.503610737191) 11 6 2 55 26
163729 81980 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 7849 Geary Blvd 6 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2007 12:00:00 AM 3 3x3 Permit Number 50009 5982658.1733 2112352.78806 37.779112594333 -122.503605093969 (37.779112594333, -122.503605093969) 11 6 2 55 26
86187 83781 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1659 44th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/23/2008 12:00:00 AM 0 3x3 Permit Number 50155 5982495.52405301 2103826.42890592 37.7556921018703 -122.503536193946 (37.7556921018703, -122.503536193946) 1 8 3 56 35
85484 90307 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4149X Balboa St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/24/2008 12:00:00 AM 3 3x3   5982661.59855 2110983.12426 37.7753520993274 -122.503491793953 (37.7753520993274, -122.503491793953) 11 6 2 55 26
187184 90306 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4149X Balboa St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3 3x3   5982680.92988 2110985.11147 37.7753586920926 -122.503425070684 (37.7753586920926, -122.503425070684) 11 6 2 55 26
142663 92443 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2638 45th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/2009 12:00:00 AM   3x3 Permit Number 52834 5982485.5 2097144.3 37.7373442414634 -122.503076173661 (37.7373442414634, -122.503076173661) 1 8 3 29491 35
133429 90971 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4101 Balboa St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3 3x3   5982789.9497 2110989.59501 37.7753774110222 -122.503048284011 (37.7753774110222, -122.503048284011) 11 6 2 55 26
14155 69005 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2087 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2019 12:00:00 AM 3 3x14 Permit Number 33006 5982594.36064133 2100924.19223319 37.7477291823956 -122.502979545621 (37.7477291823956, -122.502979545621) 1 8 3 29491 35
131426 24786 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 7795X Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   5982848.85318 2112367.91788 37.7791653451953 -122.502946585831 (37.7791653451953, -122.502946585831) 11 6 2 55 26
145111 24787 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 7795X Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   02/22/1996 12:00:00 AM 3 2X2   5982848.85318 2112367.91788 37.7791653451953 -122.502946585831 (37.7791653451953, -122.502946585831) 11 6 2 55 26
185568 24788 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 7795X Geary Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   5982848.85318 2112367.91788 37.7791653451953 -122.502946585831 (37.7791653451953, -122.502946585831) 11 6 2 55 26
119918 90970 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4101 Balboa St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3 3x3   5982828.46355 2110990.35632 37.775381765002 -122.502915114183 (37.775381765002, -122.502915114183) 11 6 2 55 26
100863 90969 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4101 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3 3x3   5982841.37806 2110990.2516 37.7753822364855 -122.502870432858 (37.7753822364855, -122.502870432858) 11 6 2 55 26
86303 90936 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4100X Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3 3x3   5982849.80185 2111047.09005 37.7755387934026 -122.50284550193 (37.7755387934026, -122.50284550193) 11 6 2 55 26
17396 92434 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1226 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/2009 12:00:00 AM 1 3x3 Permit Number 52824 5982777 2106752 37.7637414354066 -122.502779328398 (37.7637414354066, -122.502779328398) 1 8 3 56 35
16971 92435 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1234 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/2009 12:00:00 AM 2 3x3 Permit Number 52825 5982779 2106703 37.7636070129242 -122.502768783764 (37.7636070129242, -122.502768783764) 1 8 3 56 35
47763 117671 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 7751 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5982939.1996 2112495.32744 37.7795204841231 -122.502643478899 (37.7795204841231, -122.502643478899) 11 6 2 55 26
143291 89528 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 5000X Anza St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3 3x3   5983117.76595 2111739.64379 37.7774560892757 -122.501969820601 (37.7774560892757, -122.501969820601) 11 6 2 55 26
9014 261225 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2111 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2020 12:00:00 AM 3 4x6   5982897 2100735 37.7472274959484 -122.501919055433 (37.7472274959484, -122.501919055433) 1 8 3 29491 35
6095 261222 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1890 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2020 12:00:00 AM 3 5x5   5982931 2102276 37.751460650826 -122.501915490969 (37.751460650826, -122.501915490969) 1 8 3 56 35
82096 47429 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 414 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 5   Permit Number 45340 5983162.48082 2112997.63068 37.7809127803169 -122.50190824288 (37.7809127803169, -122.50190824288) 11 6 2 55 26
181142 89527 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 5000X Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2018 08:57:00 AM 3 3x3   5983139.244 2111738.98412 37.7774555397209 -122.50189547332 (37.7774555397209, -122.50189547332) 11 6 2 55 26
16002 261224 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2251 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2019 12:00:00 AM 3 4x6   5982929 2099807 37.7446813441512 -122.501739756381 (37.7446813441512, -122.501739756381) 1 8 3 29491 35
126805 185582 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2227 43rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5982934.0602 2099947.7625 37.7450681363797 -122.501732671769 (37.7450681363797, -122.501732671769) 1 8 3 29491 35
192878 183214 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2227 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5982941.6342 2099948.9314 37.7450717907388 -122.501706569109 (37.7450717907388, -122.501706569109) 1 8 3 29491 35
10080 73378 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 715 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5983190.43873 2110910.57285 37.775183970413 -122.501657073915 (37.775183970413, -122.501657073915) 11 6 2 55 26
6374 70234 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 715 41st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5983192.21244 2110893.91815 37.7751383456194 -122.501649705941 (37.7751383456194, -122.501649705941) 11 6 2 55 26
15432 144172 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 626 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 11:19:00 AM 0 Width 4ft   5983216.44703 2111516.83265 37.7768501112803 -122.501611967936 (37.7768501112803, -122.501611967936) 11 6 2 55 26
5339 146869 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 751 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 12:08:00 PM 3 Width 3ft   5983200.60356 2110688.67997 37.774575313945 -122.501605492811 (37.774575313945, -122.501605492811) 11 6 2 55 26
57909 117916 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 767 41st Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5983202.27685 2110567.72897 37.774243315823 -122.501590754882 (37.774243315823, -122.501590754882) 11 6 2 55 26
3393 144166 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 656 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 11:23:00 AM 0 Width 4ft   5983220.66267 2111338.89957 37.7763618063903 -122.50158421846 (37.7763618063903, -122.50158421846) 11 6 2 55 26
187419 69844 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 674 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/11/2007 12:00:00 AM 4 3x3 Permit Number 49993 5983224.84403 2111218.56534 37.7760316491492 -122.501560849975 (37.7760316491492, -122.501560849975) 11 6 2 55 26
9772 95689 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2415 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767440 5982968.9 2098671.4 37.7415656423265 -122.501517800216 (37.7415656423265, -122.501517800216) 1 8 3 29491 35
4733 70369 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1454 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5983117.2046 2105238.7271 37.7596064047755 -122.50149073173 (37.7596064047755, -122.50149073173) 1 8 3 56 35
170897 89526 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4944 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2018 08:50:00 AM 3 3x3   5983266.2628 2111742.46749 37.7774725646769 -122.501456338195 (37.7774725646769, -122.501456338195) 11 6 2 55 26
155763 92749 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2415 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/2009 12:00:00 AM 1 3x3 Permit Number 52978 5982987.8536 2098677.8731 37.741584528853 -122.50145274491 (37.741584528853, -122.50145274491) 1 8 3 29491 35
19581 144157 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 746 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 12:06:00 PM 0 Width 4ft   5983245.47376 2110712.04275 37.7746420966934 -122.501452009111 (37.7746420966934, -122.501452009111) 11 6 2 55 26
45265 52577 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1835 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/2011 12:00:00 AM 2 3x3 Permit Number 767117 5983162.3462 2102634.391 37.7524582800478 -122.501141985909 (37.7524582800478, -122.501141985909) 1 8 3 56 35
47174 89571 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4901X Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3 3x3   5983370.66219 2111693.23015 37.7773435040904 -122.5010915494 (37.7773435040904, -122.5010915494) 11 6 2 55 26
37901 251534 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1818 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2017 12:00:00 AM 3 3x3   5983226 2102732 37.7527300247516 -122.500929082058 (37.7527300247516, -122.500929082058) 1 8 3 56 35
81741 117811 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3900 Balboa St 7 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5983417.72133 2111068.00979 37.7756295936656 -122.500882510539 (37.7756295936656, -122.500882510539) 11 6 2 55 26
184511 117810 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3900 Balboa St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5983435.8932 2111067.84465 37.7756302071512 -122.500819638377 (37.7756302071512, -122.500819638377) 11 6 2 55 26

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);