21 rows where Fire Prevention Districts = 13 and qSpecies_id = 65 sorted by PlotSize

View and edit SQL

SiteOrder

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)
16670 57208 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2238 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/26/2015 12:00:00 AM 3   Permit Number 775007 6000879.71894 2116143.1485 37.7905743988346 -122.440841472269 (37.7905743988346, -122.440841472269) 13 6 1 29490 27
39918 41209 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3241 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/1999 12:00:00 AM 48   Permit Number 41916 6000362.60573 2119451.91027 37.7996299225355 -122.442868349911 (37.7996299225355, -122.442868349911) 13 9 1 57 17
64277 37529 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1244 Larkin St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM 21   Permit Number 39976 6007263.39142 2115650.05703 37.7895819825607 -122.418719304647 (37.7895819825607, -122.418719304647) 13 9 10 28858 21
71978 37528 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1244 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM 21   Permit Number 39976 6007265.87204 2115633.53426 37.789536754768 -122.418709549719 (37.789536754768, -122.418709549719) 13 9 10 28858 21
79432 41233 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3725 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/2014 12:00:00 AM 3   Permit Number 773159 6002526.96331 2121423.4126 37.8051663037497 -122.435520011048 (37.8051663037497, -122.435520011048) 13 9 1 57 17
83313 68880 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3633 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2018 12:00:00 AM 3   Permit Number 32851 6000180.50707 2120770.20455 37.8032392229736 -122.443593228653 (37.8032392229736, -122.443593228653) 13 9 1 57 17
107607 37527 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1244 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM 19   Permit Number 39976 6007268.1881 2115618.13797 37.7894946107457 -122.418700444082 (37.7894946107457, -122.418700444082) 13 9 10 28858 21
169489 63578 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1359 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/30/1987 12:00:00 AM 17   Permit Number 24201 6006442.54317 2119356.06995 37.799711515327 -122.421822711261 (37.799711515327, -122.421822711261) 13 9 1 28858 32
110025 255477 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2669 Greenwich St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/25/2018 12:00:00 AM 3 3x3 Permit Number 780207 6000139.26098 2118831.12681 37.7979126806609 -122.443596582177 (37.7979126806609, -122.443596582177) 13 9 1 57 17
160053 107230 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1445 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005960.15833 2119639.59713 37.8004627936866 -122.423512110213 (37.8004627936866, -122.423512110213) 13 9 1 28858 32
91062 84740 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 143 Alhambra St 1 Front Yard : Cutout Tree Private 2   03/27/2007 12:00:00 AM 13 4x6 Permit Number 49254 6001588.49283 2120281.76365 37.8019782934262 -122.438685839601 (37.8019782934262, -122.438685839601) 13 9 1 57 17
33356 138630 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1702 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6000078.3648 2114795.7207 37.7868290426993 -122.443517270296 (37.7868290426993, -122.443517270296) 13 6 1 29490 27
125241 138631 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1704 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6000076.1375 2114809.8269 37.7868676476344 -122.443525989893 (37.7868676476344, -122.443525989893) 13 6 1 29490 27
141712 125540 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 47 Casa Way 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6001554.26648 2121557.3314 37.8054787165372 -122.438895742254 (37.8054787165372, -122.438895742254) 13 9 1 57 17
160833 125544 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1410 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002431.61204 2121624.28708 37.8057124359506 -122.435864366851 (37.8057124359506, -122.435864366851) 13 9 1 57 17
46734 125549 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1445 Greenwich St 7 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6006015.52243 2119649.2025 37.8004922923456 -122.423321211112 (37.8004922923456, -122.423321211112) 13 9 1 28858 32
81710 125550 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1445 Greenwich St 9 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6006031.52695 2119650.26621 37.8004961162623 -122.423265904597 (37.8004961162623, -122.423265904597) 13 9 1 28858 32
150779 125547 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1445 Greenwich St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6005968.56582 2119641.09275 37.8004673748183 -122.423483123267 (37.8004673748183, -122.423483123267) 13 9 1 28858 32
178287 125551 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1445 Greenwich St 11 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6006045.33094 2119651.17602 37.8004993933977 -122.423218201864 (37.8004993933977, -122.423218201864) 13 9 1 28858 32
193967 125548 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1445 Greenwich St 5 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6006007.30583 2119647.97872 37.8004884684307 -122.423349556855 (37.8004884684307, -122.423349556855) 13 9 1 28858 32
92331 125545 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3211 Sacramento St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   5999423.84524 2115333.31799 37.7882677951647 -122.445820424872 (37.7882677951647, -122.445820424872) 13 6 1 29490 31

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