trees
1,121 rows where qSpecies_id = 6 sorted by Supervisor Districts
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );