trees

14 rows where Fire Prevention Districts = 11 and qSpecies_id = 2 sorted by qCareAssistant

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

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)
5494 261029 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 863 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2019 12:00:00 AM 3 4x6   5986308 2110038 37.7729707519219 -122.490808659035 (37.7729707519219, -122.490808659035) 11 6 2 55 26
10779 49299 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 640 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3   Permit Number 46308 5981979.10455 2111331.16831 37.7762675789736 -122.505878467652 (37.7762675789736, -122.505878467652) 11 6 2 55 26
12272 117721 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 471 40th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   01/25/2020 11:12:00 AM 3 Width 3ft   5983437.41308 2112653.95912 37.779985305245 -122.500931708584 (37.779985305245, -122.500931708584) 11 6 2 55 26
13828 144979 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 626 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2019 12:00:00 AM 3 Width 3ft   5990674.57486 2111094.54046 37.7761258404607 -122.47578147193 (37.7761258404607, -122.47578147193) 11 6 2 54 26
18500 144214 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 786 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/15/2020 12:25:00 PM 0 Width 4ft   5982943.75928 2110448.71022 37.7739013377013 -122.502476188525 (37.7739013377013, -122.502476188525) 11 6 2 55 26
25318 16583 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 810X Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2008 12:00:00 AM 2 3X3   5992991.92524 2114858.80829 37.7865955752076 -122.468039078982 (37.7865955752076, -122.468039078982) 11 6 1 54 11
56547 124911 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3234 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2017 12:00:00 AM 3 Width 4ft Permit Number 780160 5998736.95045 2116593.12953 37.7916876606053 -122.448287711302 (37.7916876606053, -122.448287711302) 11 6 1 54 30
63660 124910 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3234 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2017 12:00:00 AM 3 Width 4ft Permit Number 780160 5998760.11738 2116596.00833 37.7916968894517 -122.4482077616 (37.7916968894517, -122.4482077616) 11 6 1 54 30
78957 51994 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3858 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1977 12:00:00 AM     Permit Number 769135 5995734.40748516 2115851.40858603 37.78947898308 -122.458622703992 (37.78947898308, -122.458622703992) 11 6 1 54 31
79656 2 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 850X Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/25/2009 12:00:00 AM 3 3X3   5992872.52482 2114854.21479 37.7865760666822 -122.468451837381 (37.7865760666822, -122.468451837381) 11 6 1 54 11
62023 108507 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 796 19th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773790 5990094.5666 2109953.25495 37.772958540137 -122.477704410848 (37.772958540137, -122.477704410848) 11 6 2 55 26
163472 109142 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 342 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/2015 12:00:00 AM 3 3x3 Permit Number 773572 5986886.5 2113633.7 37.7828773022088 -122.489071978745 (37.7828773022088, -122.489071978745) 11 6 2 55 26
189245 52671 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1234@ LINCOLN 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53911 5993637.83557736 2107090.14039952 37.7653021756316 -122.465239907967 (37.7653021756316, -122.465239907967) 11 8 11 56 12
190320 72375 Private 9 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 4299X Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/1996 12:00:00 AM   3x3 Permit Number 773790 5990099.63678033 2109979.56687008 37.773031079694 -122.477688796337 (37.773031079694, -122.477688796337) 11 6 2 55 26

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