trees
43 rows where Supervisor Districts = 7 and qSpecies_id = 2 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101456 | 88442 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1148 Treat Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51406 | 6008612.9 | 2101850.1 | 37.7517664174328 | -122.413073954345 | (37.7517664174328, -122.413073954345) | 2 | 4 | 7 | 28859 | 19 | |||
103120 | 87853 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 599 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50764 | 6007684 | 2096571 | 37.7372189966792 | -122.415912430403 | (37.7372189966792, -122.415912430403) | 2 | 7 | 7 | 28859 | 2 | ||
132768 | 95660 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 431 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767422 | 6010656.7 | 2092697.9 | 37.7267509601998 | -122.40536171554 | (37.7267509601998, -122.40536171554) | 10 | 3 | 7 | 309 | 28 | |
151915 | 63015 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 75 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/16/2014 12:00:00 AM | Permit Number 772837 | 6007421.64921795 | 2097871.12423845 | 37.7407740975251 | -122.416911586715 | (37.7407740975251, -122.416911586715) | 2 | 7 | 7 | 28859 | 2 | ||
162176 | 34756 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 930 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | Permit Number 767406 | 6007964.37275398 | 2102502.67346206 | 37.7535218086 | -122.415362848727 | (37.7535218086, -122.415362848727) | 2 | 4 | 7 | 28859 | 19 | ||
19302 | 18446 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1036 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010478.12987 | 2103164.08177 | 37.7554788523745 | -122.406716298816 | (37.7554788523745, -122.406716298816) | 10 | 4 | 7 | 28859 | 19 | |||
3345 | 258176 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 255 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010040.21914 | 2094084.80619 | 37.7305246249549 | -122.4075906244 | (37.7305246249549, -122.4075906244) | 10 | 3 | 7 | 309 | 28 | ||
3624 | 151146 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2900 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2020 12:00:00 AM | 3 | Width 4ft | 6008882.69002 | 2105920.7172 | 37.7629585507151 | -122.412428682741 | (37.7629585507151, -122.412428682741) | 8 | 4 | 7 | 28859 | 19 | ||
5015 | 224353 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3030 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 11:50:00 AM | 3 | Width 4ft | 6006632.75905 | 2106740.09726 | 37.7650818572521 | -122.420268591949 | (37.7650818572521, -122.420268591949) | 8 | 4 | 7 | 28853 | 19 | ||
7155 | 258178 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 255 Silliman St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010040.21914 | 2094084.80619 | 37.7305246249549 | -122.4075906244 | (37.7305246249549, -122.4075906244) | 10 | 3 | 7 | 309 | 28 | ||
8189 | 151145 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2900 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2020 12:00:00 AM | 3 | Width 4ft | 6008902.66747 | 2105921.7543 | 37.762962519431 | -122.412359660679 | (37.762962519431, -122.412359660679) | 8 | 4 | 7 | 28859 | 19 | ||
10603 | 18421 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 934 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2013 12:00:00 AM | 3 | 3x3 | 6010449.27067 | 2103789.58404 | 37.7571947273755 | -122.40686018586 | (37.7571947273755, -122.40686018586) | 10 | 4 | 7 | 28859 | 19 | ||
11859 | 262397 | Undocumented 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 498 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 3x3 | 6008907 | 2105964 | 37.7630787595522 | -122.412347662048 | (37.7630787595522, -122.412347662048) | 8 | 4 | 7 | 28859 | 19 | ||
14858 | 171814 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 100 Dartmouth St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6008473.26376 | 2093533.30473 | 37.7289224829841 | -122.412968858728 | (37.7289224829841, -122.412968858728) | 9 | 3 | 7 | 309 | 28 | ||
16462 | 91091 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3417X 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736 | 2105525 | 37.7617513016467 | -122.419825278263 | (37.7617513016467, -122.419825278263) | 2 | 4 | 7 | 28859 | 19 | |
19452 | 258177 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 255 Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010040.21914 | 2094084.80619 | 37.7305246249549 | -122.4075906244 | (37.7305246249549, -122.4075906244) | 10 | 3 | 7 | 309 | 28 | ||
21865 | 91095 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3417X 18th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736 | 2105525 | 37.7617513016467 | -122.419825278263 | (37.7617513016467, -122.419825278263) | 2 | 4 | 7 | 28859 | 19 | |
39903 | 18422 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 940 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2016 06:57:00 AM | 3 | 3x3 | 6010451.25485 | 2103753.05423 | 37.7570945357026 | -122.406850749261 | (37.7570945357026, -122.406850749261) | 10 | 4 | 7 | 28859 | 19 | ||
41743 | 18420 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 924 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010442.48956 | 2103839.41038 | 37.7573311599314 | -122.406887149344 | (37.7573311599314, -122.406887149344) | 10 | 4 | 7 | 28859 | 19 | ||
64762 | 13340 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 230 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2007 12:00:00 AM | 3 | 3X24 | 6011187.2509688 | 2090638.9738565 | 37.721127222942 | -122.403382822785 | (37.721127222942, -122.403382822785) | 10 | 3 | 7 | 309 | 28 | ||
66728 | 18391 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 874 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 4x4 | 6010420.6643105 | 2104143.6455038 | 37.7581653002339 | -122.406984073056 | (37.7581653002339, -122.406984073056) | 10 | 4 | 7 | 28859 | 19 | ||
71427 | 2390 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2642X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6009749.5258463 | 2101948.1671123 | 37.7520994293613 | -122.409150251369 | (37.7520994293613, -122.409150251369) | 2 | 4 | 7 | 28859 | 19 | ||
73558 | 91094 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3417X 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736 | 2105525 | 37.7617513016467 | -122.419825278263 | (37.7617513016467, -122.419825278263) | 2 | 4 | 7 | 28859 | 19 | |
98913 | 434 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 890X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010425.4291782 | 2104052.7086425 | 37.7579158746071 | -122.406961184613 | (37.7579158746071, -122.406961184613) | 10 | 4 | 7 | 28859 | 19 | ||
99446 | 86637 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2679 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009805.531856 | 2101750.09748 | 37.7515587115691 | -122.408942599671 | (37.7515587115691, -122.408942599671) | 2 | 4 | 7 | 28859 | 19 | ||
125882 | 9308 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 240X Mansell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2007 12:00:00 AM | 3 | 3X100 | 6011154.1519898 | 2090628.8663314 | 37.7210976210121 | -122.403496526224 | (37.7210976210121, -122.403496526224) | 10 | 3 | 7 | 309 | 28 | ||
138954 | 108977 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2970 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773794 | 6008402.2 | 2103930 | 37.7574655215329 | -122.413949705223 | (37.7574655215329, -122.413949705223) | 2 | 4 | 7 | 28859 | 19 |
144023 | 100465 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1140 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010498.9 | 2102571.5 | 37.7538529165301 | -122.40660271212 | (37.7538529165301, -122.40660271212) | 10 | 4 | 7 | 28859 | 19 | |||
146375 | 91093 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3417X 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736 | 2105525 | 37.7617513016467 | -122.419825278263 | (37.7617513016467, -122.419825278263) | 2 | 4 | 7 | 28859 | 19 | |
171372 | 30135 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 220X Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2007 12:00:00 AM | 3 | 3X30 | 6011221.783784 | 2090644.291322 | 37.7211437523189 | -122.403263826082 | (37.7211437523189, -122.403263826082) | 10 | 3 | 7 | 309 | 28 | ||
173603 | 9306 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 240X Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2007 12:00:00 AM | 3 | 3X100 | 6011154.1519898 | 2090628.8663314 | 37.7210976210121 | -122.403496526224 | (37.7210976210121, -122.403496526224) | 10 | 3 | 7 | 309 | 28 | ||
178576 | 91090 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3417X 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736 | 2105525 | 37.7617513016467 | -122.419825278263 | (37.7617513016467, -122.419825278263) | 2 | 4 | 7 | 28859 | 19 | |
180008 | 2389 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2642X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6009749.5258463 | 2101948.1671123 | 37.7520994293613 | -122.409150251369 | (37.7520994293613, -122.409150251369) | 2 | 4 | 7 | 28859 | 19 | ||
181972 | 18423 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 952 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2013 12:00:00 AM | 3 | 3x3 | 6010455.30853 | 2103703.28348 | 37.7569581031602 | -122.406833222372 | (37.7569581031602, -122.406833222372) | 10 | 4 | 7 | 28859 | 19 | ||
182836 | 91089 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3417X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736 | 2105525 | 37.7617513016467 | -122.419825278263 | (37.7617513016467, -122.419825278263) | 2 | 4 | 7 | 28859 | 19 | |
183063 | 18480 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1298 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2017 01:20:00 PM | 3 | 3x3 | 6010561.39126 | 2101710.28558 | 37.7514917080909 | -122.406325925618 | (37.7514917080909, -122.406325925618) | 10 | 4 | 7 | 28859 | 19 | ||
189781 | 91092 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3417X 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736 | 2105525 | 37.7617513016467 | -122.419825278263 | (37.7617513016467, -122.419825278263) | 2 | 4 | 7 | 28859 | 19 | |
101791 | 230380 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1450 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010406.10881 | 2100942.79845 | 37.7493756698697 | -122.406808829185 | (37.7493756698697, -122.406808829185) | 2 | 4 | 7 | 28859 | 19 | |||
69419 | 86595 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2154 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 6 | 3x3 | 6009566 | 2104744 | 37.7597658751742 | -122.409982265203 | (37.7597658751742, -122.409982265203) | 2 | 4 | 7 | 28859 | 19 | ||
159084 | 230389 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 51 13th St | 4 | : | Tree | Private 2 | 6 | Width 3ft | 6008142.81587 | 2108281.73826 | 37.7693998171644 | -122.415154794967 | (37.7693998171644, -122.415154794967) | 8 | 4 | 7 | 28853 | 19 | |||
88872 | 230387 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 51 13th St | 2 | : | Tree | Private 2 | 7 | Width 4ft | 6008108.07186 | 2108284.25114 | 37.7694047643365 | -122.415275151222 | (37.7694047643365, -122.415275151222) | 8 | 4 | 7 | 28853 | 19 | |||
99872 | 230388 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 51 13th St | 3 | : | Tree | Private 2 | 8 | Width 4ft | 6008125.59993 | 2108283.70929 | 37.7694042616334 | -122.41521448386 | (37.7694042616334, -122.41521448386) | 8 | 4 | 7 | 28853 | 19 | |||
37543 | 230386 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 51 13th St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6008087.40778 | 2108285.62264 | 37.769407368778 | -122.415346724678 | (37.769407368778, -122.415346724678) | 8 | 4 | 7 | 28853 | 19 |
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) );