1,121 rows where qSpecies_id = 6 sorted by Supervisor Districts

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)
1967 259348 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450x Burrows St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
3117 260221 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
3183 260224 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 20 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
5614 259341 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 102 Bacon St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
5784 260220 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
8715 260222 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 15 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
11368 259340 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 102 Bacon St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
12542 262149 Private 9 Lagunaria patersonii :: Primrose Tree 6 4600 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2020 12:00:00 AM 3                        
15370 50774 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47304                    
16718 262177 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 620 Rutland St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/07/2019 12:00:00 AM 3                        
17639 260223 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 19 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
17693 259347 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450x Burrows St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
18773 255529 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1555 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2018 12:00:00 AM 3 3x3 Permit Number 782018                    
19156 259400 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1649 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/13/2018 12:00:00 AM 3                        
19327 262176 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 620 Rutland St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/07/2019 12:00:00 AM 3                        
2780 79224 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3562 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5997807.39537 2115154.90167 37.7876854832564 -122.451400172276 (37.7876854832564, -122.451400172276) 11 6 1 54 31
20629 51532 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3155 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2005 12:00:00 AM 2   Permit Number 47834 5999712.30266 2115373.43094 37.78839440084 -122.44482529806 (37.78839440084, -122.44482529806) 13 6 1 29490 27
21393 87031 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 50 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM 3 3x3 Permit Number 52524 5994278.21944 2115255.72364 37.7877595955023 -122.463617666169 (37.7877595955023, -122.463617666169) 11 6 1 54 11
21404 129375 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 454 Walnut St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5998637.858 2115126.26996 37.7876543864995 -122.448524881439 (37.7876543864995, -122.448524881439) 13 6 1 54 31
21599 129376 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2500 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6002240.59165 2116825.10443 37.7925242837291 -122.436181762774 (37.7925242837291, -122.436181762774) 13 9 1 29490 27
24170 41808 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Anzavista Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 3   Permit Number 42201 5999945.6987 2112165.7027 37.7796001259133 -122.443787242166 (37.7796001259133, -122.443787242166) 15 5 1 29490 16
27719 250553 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 El Camino Del Mar 1 : Tree Private 2     8 Width 4ft   5988175.48547 2115367.76095 37.7877136895948 -122.484739928202 (37.7877136895948, -122.484739928202) 11 6 1 55 33
29195 34680 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1904 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM 5 3x3 Permit Number 52535 6003705.30059 2119372.14104 37.7996008996227 -122.431295719127 (37.7996008996227, -122.431295719127) 13 9 1 57 17
29272 129388 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2507 Larkin St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006666.99925 2119949.93729 37.8013547799481 -122.421088199869 (37.8013547799481, -122.421088199869) 5 9 1 28858 32
31525 251509 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 51 Commonwealth Ave 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996476 2114178 37.7849268449454 -122.455935865939 (37.7849268449454, -122.455935865939) 11 6 1 54 31
41709 129378 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2500 Steiner St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6002236.43678 2116865.63553 37.7926353355998 -122.436199040575 (37.7926353355998, -122.436199040575) 13 9 1 29490 27
42678 87855 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2537 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2008 12:00:00 AM   3x3 Permit Number 50783 6006632 2119882 37.8011662683494 -122.421204486113 (37.8011662683494, -122.421204486113) 5 9 1 28858 32
43690 52885 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2500@ JACKSON Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2006 12:00:00 AM 7   Permit Number 48890 6002243.8338 2116804.81477 37.7924687577648 -122.436169092224 (37.7924687577648, -122.436169092224) 13 9 1 29490 27
44290 140758 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 42 TERRA VISTA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6000316.7782 2112875.0348 37.7815689287559 -122.442554464995 (37.7815689287559, -122.442554464995) 15 5 1 29490 16
51537 100491 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3978 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2013 12:00:00 AM 2 3x3 Permit Number 770312 5995766.62837 2114872.73446 37.7867936596919 -122.458440353598 (37.7867936596919, -122.458440353598) 11 6 1 54 31
52224 129373 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2133 Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6000002.55629 2120892.7221 37.8035654727314 -122.444217840184 (37.8035654727314, -122.444217840184) 13 9 1 57 17
53099 113489 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 40 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x10   5995526.6518 2115672.85646 37.7889767847188 -122.45932857543 (37.7889767847188, -122.45932857543) 11 6 1 54 31
57001 36152 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 51 Commonwealth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/1998 12:00:00 AM 4   Permit Number 39237 5996489.9045 2114249.7041 37.7851245233187 -122.455892946486 (37.7851245233187, -122.455892946486) 11 6 1 54 31
57139 83205 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3437 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2009 12:00:00 AM 6 3x3 Permit Number 52337 6002190.72031 2120034.66861 37.8013340766633 -122.436584154541 (37.8013340766633, -122.436584154541) 13 9 1 57 17
63396 129389 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2507 Larkin St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006655.24817 2120043.69212 37.8016115444852 -122.421135524881 (37.8016115444852, -122.421135524881) 5 9 1 28858 32
67418 255648 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2834 Polk St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2018 12:00:00 AM 3 3x3 Permit Number 779253 6006100.90264 2120497.78973 37.8028271147622 -122.423086110708 (37.8028271147622, -122.423086110708) 5 9 1 28858 32
72800 121883 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 50 18th Ave 5 Sidewalk: Curb side : Yard Tree Private 2     5 Width 5ft   5990230.48175 2114847.31405 37.786404156248 -122.477592056385 (37.786404156248, -122.477592056385) 11 6 1 55 33
74064 42693 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2500 Larkin St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2000 12:00:00 AM 3 3x3 Permit Number 42711 6006694.5506046 2119774.0082852 37.8008732765742 -122.420980361587 (37.8008732765742, -122.420980361587) 5 9 1 28858 32
76042 79199 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 409 Laurel St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/2015 12:00:00 AM 1   Permit Number 777130 5998120.56156 2115036.84682 37.7873792631851 -122.450308169597 (37.7873792631851, -122.450308169597) 11 6 1 54 31
76341 47469 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2907 Bush St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/14/2002 12:00:00 AM 4   Permit Number 45370 5999522.715 2114292.4911 37.7854156010234 -122.445403484856 (37.7854156010234, -122.445403484856) 15 6 1 29490 31
82053 121884 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 50 18th Ave 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 5ft   5990230.57834 2114834.81932 37.7863698548312 -122.477590808601 (37.7863698548312, -122.477590808601) 11 6 1 55 33
92442 129379 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1765 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6005697.11148 2117184.40611 37.793706610722 -122.424247645012 (37.793706610722, -122.424247645012) 13 9 1 28858 27
95229 250789 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 285 32nd Ave 1 : Tree Private 2     3 Width 3ft   5985873.63674 2113998.18517 37.7838189038641 -122.492602865457 (37.7838189038641, -122.492602865457) 11 6 1 55 33
95828 129377 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2500 Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6002239.2844 2116842.37021 37.7925716168296 -122.436187522037 (37.7925716168296, -122.436187522037) 13 9 1 29490 27
103037 251507 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 51 Commonwealth Ave 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996476 2114178 37.7849268449454 -122.455935865939 (37.7849268449454, -122.455935865939) 11 6 1 54 31
106437 250555 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 El Camino Del Mar 3 : Tree Private 2     5 Width 4ft   5988156.37986 2115366.75845 37.7877098242971 -122.484805955556 (37.7877098242971, -122.484805955556) 11 6 1 55 33
119325 129374 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 454 Walnut St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5998634.47077 2115144.95556 37.7877054985629 -122.448537946784 (37.7877054985629, -122.448537946784) 13 6 1 54 31
125716 119982 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 250 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5987459.3505 2114288.69945 37.7847091625278 -122.487138302864 (37.7847091625278, -122.487138302864) 11 6 1 55 26
126848 41809 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Anzavista Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 2   Permit Number 42201 5999967.3577 2112168.7485 37.7796097242619 -122.443712533479 (37.7796097242619, -122.443712533479) 15 5 1 29490 16
131156 251508 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 51 Commonwealth Ave 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996476 2114178 37.7849268449454 -122.455935865939 (37.7849268449454, -122.455935865939) 11 6 1 54 31
132614 251506 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 51 Commonwealth Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996476 2114178 37.7849268449454 -122.455935865939 (37.7849268449454, -122.455935865939) 11 6 1 54 31
132744 50185 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 139 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2007 12:00:00 AM 6 3x3 Permit Number 49870 5987999.15348 2115065.15007 37.7868725355783 -122.485327781661 (37.7868725355783, -122.485327781661) 11 6 1 55 33
135075 52442 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2310 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2005 12:00:00 AM 5   Permit Number 48553 6003588.30454 2116614.49532 37.7920224826905 -122.431503592933 (37.7920224826905, -122.431503592933) 13 9 1 29490 27
136198 255789 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2240 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003983 2116665 37.7921835181407 -122.430141547967 (37.7921835181407, -122.430141547967) 13 9 1 29490 27
142719 124805 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2798 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2018 12:00:00 AM 3 Width 5ft Permit Number 781937 5999607.72686 2118800.07594 37.7977970943207 -122.445433600384 (37.7977970943207, -122.445433600384) 13 9 1 57 17
146709 254547 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2908 Bush St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 02/26/2018 12:00:00 AM 3 3x3 Permit Number 781446 5999588.42992 2114352.40043 37.7855838475934 -122.445180440387 (37.7855838475934, -122.445180440387) 15 6 1 29490 31
156644 41807 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Anzavista Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 3   Permit Number 42201 5999913.2102 2112161.3032 37.7795861928813 -122.443899317319 (37.7795861928813, -122.443899317319) 15 5 1 29490 16
163097 129372 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2133 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5999985.51807 2120890.75849 37.8035591091338 -122.444276660352 (37.8035591091338, -122.444276660352) 13 9 1 57 17
166863 140780 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 5 Encanto Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6000014.7367 2112198.3604 37.7796937331341 -122.443550757384 (37.7796937331341, -122.443550757384) 15 5 1 29490 16
169832 65853 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3415 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2008 12:00:00 AM 5 3x3 Permit Number 51130 6000770.44597 2120073.90569 37.8013609996628 -122.441501736515 (37.8013609996628, -122.441501736515) 13 9 1 57 17
175521 41812 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Anzavista Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 3   Permit Number 42201 5999993.4162 2112171.4558 37.7796186440476 -122.44362258073 (37.7796186440476, -122.44362258073) 15 5 1 29490 16
179565 129387 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2507 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6006679.63776 2119843.90732 37.8010643609816 -122.421036932226 (37.8010643609816, -122.421036932226) 5 9 1 28858 32
183256 88394 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 139 25th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM 1 3x3 Permit Number 51373 5988000.05712 2115038.19323 37.7867985724398 -122.485322676521 (37.7867985724398, -122.485322676521) 11 6 1 55 33
183672 250554 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 El Camino Del Mar 2 : Tree Private 2     5 Width 4ft   5988163.80572 2115366.95271 37.7877107901693 -122.484780278081 (37.7877107901693, -122.484780278081) 11 6 1 55 33
188002 88645 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2500x Larkin St   Sidewalk: Curb side : Cutout Tree Private 2   08/05/2008 12:00:00 AM   3x3 Permit Number 51618 6006882.7 2119972.1 37.8014277902223 -122.420343352043 (37.8014277902223, -122.420343352043) 5 1 1 28858 32
4231 261663 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 1099x Broadway   Sidewalk: Curb side : Cutout Tree Private 2   10/28/2020 12:00:00 AM 3 3x3   6008393 2118190 37.7966195766837 -122.414990814528 (37.7966195766837, -122.414990814528) 5 1 10 308 21
4801 125249 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1077 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2020 12:00:00 AM 3 Width 3ft   6008457.69643 2118247.71377 37.7967816796858 -122.414771036277 (37.7967816796858, -122.414771036277) 5 1 10 308 21
6798 125247 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1085 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2020 12:00:00 AM 3 3x3 Permit Number 782055 6008420.1565 2118241.89629 37.796763597016 -122.414900521554 (37.796763597016, -122.414900521554) 5 1 10 308 21
42267 83686 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1250-1262 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM 7 3x3 Permit Number 52242 6009408.29288 2117660.17543 37.7952218082983 -122.411440210903 (37.7952218082983, -122.411440210903) 3 1 10 28857 4
49974 73594 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 780 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/12/2014 12:00:00 AM 3   Permit Number 772812 6008453.79298 2114896.74793 37.7875805296608 -122.414547298434 (37.7875805296608, -122.414547298434) 5 1 10 28858 21
74010 129386 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 929 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009490.7484 2116033.66261 37.7907604245028 -122.411039958651 (37.7907604245028, -122.411039958651) 5 1 10 28857 21
80490 83685 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1250-1262 Mason St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM 6 3x3 Permit Number 52242 6009407.14931 2117677.56911 37.7952695029448 -122.411445397284 (37.7952695029448, -122.411445397284) 3 1 10 28857 4
81222 83687 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1250-1262 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM 6 3x3 Permit Number 52242 6009414.65188 2117634.89994 37.7951527646548 -122.411416421158 (37.7951527646548, -122.411416421158) 3 1 10 28857 4
81750 129385 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 722 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6009662.68842 2115877.38276 37.7903409582254 -122.41043401253 (37.7903409582254, -122.41043401253) 5 1 10 28857 21
102379 84816 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 736 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/2009 12:00:00 AM 4 3x3 Permit Number 53031 6008319.93046 2115035.61847 37.7879543130824 -122.415020270782 (37.7879543130824, -122.415020270782) 5 1 10 28858 21
127633 52071 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 939 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2005 12:00:00 AM 7   Permit Number 48265 6009677.58908 2117754.14875 37.7954949369081 -122.410515038747 (37.7954949369081, -122.410515038747) 3 1 10 28857 4
131191 71549 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 780 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/18/2015 12:00:00 AM 3 3x3 Permit Number 772812 6008431.05429 2114892.38013 37.7875672592553 -122.414625660841 (37.7875672592553, -122.414625660841) 5 1 10 28858 21
142268 129380 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 730 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008321.92773 2115014.63424 37.7878968077251 -122.415011874722 (37.7878968077251, -122.415011874722) 5 1 10 28858 21
146089 52362 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1438ASHINGTON Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2005 12:00:00 AM 9   Permit Number 48498 6007994.93646 2117377.76116 37.7943669936906 -122.416310648633 (37.7943669936906, -122.416310648633) 5 1 10 28858 21
150091 129390 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 902 Vallejo St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 4ft   6009192.86484 2118752.75452 37.798209676283 -122.412262888224 (37.798209676283, -122.412262888224) 3 1 10 308 21
154237 60223 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1230 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM 8 3x3 Permit Number 52240 6009426.59197 2117542.6242 37.7949000677337 -122.411368584404 (37.7949000677337, -122.411368584404) 3 1 10 28857 4
158967 79726 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 780 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50955 6008416.19534554 2114892.53002417 37.7875668360064 -122.414677080613 (37.7875668360064, -122.414677080613) 5 1 10 28858 21
166093 88438 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1248 Mason St   Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM   3x3 Permit Number 52242 6009421 2117567 37.7949666840821 -122.411389656386 (37.7949666840821, -122.411389656386) 3 1 10 28857 4
194195 52070 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 939 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2005 12:00:00 AM 7   Permit Number 48265 6009656.25559 2117750.51311 37.7954837583147 -122.410588599703 (37.7954837583147, -122.410588599703) 3 1 10 28857 4
664 262379 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 925 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/2020 12:00:00 AM 3 3x3   5998032 2106999 37.7653043483693 -122.450035028723 (37.7653043483693, -122.450035028723) 15 5 11 29492 9
1972 64568 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1888 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2008 12:00:00 AM 4 3x3 Permit Number 51776 6000584.4368 2111720.243 37.7784134187795 -122.441545602938 (37.7784134187795, -122.441545602938) 15 5 11 29490 41
2314 227584 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 660 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6002549.44678 2108867.98451 37.7706935809695 -122.434543909369 (37.7706935809695, -122.434543909369) 15 5 11 29492 9
3613 227144 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 266 Rivoli St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5997515.89511 2105898.72706 37.7622537322474 -122.451740727559 (37.7622537322474, -122.451740727559) 15 5 11 29492 9
8734 227141 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 266 Rivoli St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5997670.57496 2105917.36363 37.7623137611024 -122.451207095032 (37.7623137611024, -122.451207095032) 15 5 11 29492 9
19677 39613 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 577 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42206 5996839.91957309 2107330.11638831 37.7661452244472 -122.454182049235 (37.7661452244472, -122.454182049235) 15 5 11 29492 12
20055 206989 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1304 11th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5992723.56277 2106565.73006 37.7638095171187 -122.468363979738 (37.7638095171187, -122.468363979738) 1 8 11 56 12
20394 48661 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1300 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/25/2005 12:00:00 AM     Permit Number 45949 5992726.08644889 2106595.37916826 37.7638910715093 -122.468357408335 (37.7638910715093, -122.468357408335) 1 8 11 56 12
24082 88257 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 436 Belvedere St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51241 5998536 2106665 37.76441609532 -122.448267765661 (37.76441609532, -122.448267765661) 15 5 11 29492 9
25262 227146 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 266 Rivoli St 11 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5997461.46496 2105891.36034 37.7622303876487 -122.451928448466 (37.7622303876487, -122.451928448466) 15 5 11 29492 9
28853 88712 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2008 12:00:00 AM   3x3 Permit Number 51654 6004166 2109783 37.7732976245409 -122.429017475211 (37.7732976245409, -122.429017475211) 7 9 11 29492 10
29694 248531 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 800 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5997658.268 2107761.8815 37.7673776340728 -122.451382700243 (37.7673776340728, -122.451382700243) 15 5 11 29492 9
29952 137671 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 756 LYON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6000049.6788 2111547.4906 37.7779086039439 -122.443383113797 (37.7779086039439, -122.443383113797) 15 5 11 29490 16
34441 227139 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 280 Grattan St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5997445.29759 2106455.57152 37.7637786424842 -122.452025073424 (37.7637786424842, -122.452025073424) 15 5 11 29492 9
35869 140696 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 162 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5997358.0622 2109907.9029 37.7732528619693 -122.452575957146 (37.7732528619693, -122.452575957146) 15 5 11 29492 16
37187 227140 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 266 Rivoli St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5997729.62744 2105927.06337 37.7623437750648 -122.451003555094 (37.7623437750648, -122.451003555094) 15 5 11 29492 9

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)
);