trees
26 rows where Fire Prevention Districts = 11 and qSpecies_id = 177 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
57341 | 105009 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 11 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2013 12:00:00 AM | 7 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.7857897179877 | -122.455998396638 | (37.7857897179877, -122.455998396638) | 11 | 6 | 1 | 54 | 31 | ||
25056 | 105010 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 11 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.7857897179877 | -122.455998396638 | (37.7857897179877, -122.455998396638) | 11 | 6 | 1 | 54 | 31 | ||
13429 | 105011 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 11 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.7857897179877 | -122.455998396638 | (37.7857897179877, -122.455998396638) | 11 | 6 | 1 | 54 | 31 | ||
160746 | 105053 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 501X 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2013 12:00:00 AM | 3x3 | Permit Number 770390 | 5987510.95423 | 2112219.64233 | 37.7790311285688 | -122.48680778308 | (37.7790311285688, -122.48680778308) | 11 | 6 | 2 | 55 | 26 | ||
185404 | 107849 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1300x ANZA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5994625 | 2112199 | 37.7793866324847 | -122.462196108999 | (37.7793866324847, -122.462196108999) | 11 | 6 | 2 | 54 | 11 | |||
178780 | 112777 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1899X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774327 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | 11 | 6 | 2 | 54 | 11 | |||
109870 | 112779 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1899X Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774327 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | 11 | 6 | 2 | 54 | 11 | |||
100244 | 115008 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 743 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | Permit Number 774445 | 5985969.5 | 2110831.9 | 37.7751307960032 | -122.492038018346 | (37.7751307960032, -122.492038018346) | 11 | 6 | 2 | 55 | 26 | |||
177143 | 140885 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 112 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/04/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781739 | 5996566.0494 | 2113683.186 | 37.7835733852629 | -122.455588548359 | (37.7835733852629, -122.455588548359) | 11 | 6 | 1 | 54 | 31 | |
124246 | 1444 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 151X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2009 12:00:00 AM | 3 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | 11 | 6 | 1 | 54 | 11 | ||
17835 | 146870 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 747 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:07:00 PM | 0 | Width 3ft | 5983198.23429 | 2110712.37785 | 37.7746402422966 | -122.501615441996 | (37.7746402422966, -122.501615441996) | 11 | 6 | 2 | 55 | 26 | ||
35798 | 210473 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 855 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2016 12:00:00 AM | 14 | Width 3ft | Permit Number 41828 | 5993066.85825 | 2107284.57434 | 37.765803096459 | -122.467228905809 | (37.765803096459, -122.467228905809) | 11 | 8 | 11 | 56 | 12 | |
76277 | 24659 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3299X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772930 | 5997061.39714 | 2112911.45264 | 37.7814828219847 | -122.453819096525 | (37.7814828219847, -122.453819096525) | 11 | 6 | 2 | 54 | 16 | |
178223 | 256896 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 470 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780643 | 5985651.17942 | 2112710.44444 | 37.7802701294342 | -122.493277571063 | (37.7802701294342, -122.493277571063) | 11 | 6 | 2 | 55 | 26 | |
104430 | 53808 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 200X Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2014 12:00:00 AM | 3x3 | Permit Number 772930 | 5997126.8655565 | 2112925.05365722 | 37.7815239200353 | -122.453593590958 | (37.7815239200353, -122.453593590958) | 11 | 6 | 2 | 54 | 16 | ||
45539 | 683 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2340X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53450 | 5988222.7193 | 2114685.44657 | 37.7858429996456 | -122.484526443804 | (37.7858429996456, -122.484526443804) | 11 | 6 | 1 | 55 | 33 | |
68114 | 8974 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5045 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5991343.5266 | 2112609.97523 | 37.7803255698787 | -122.473577979119 | (37.7803255698787, -122.473577979119) | 11 | 6 | 2 | 54 | 26 | ||
159293 | 9031 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5351 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5990365.52035 | 2112599.40799 | 37.7802398682569 | -122.476960548186 | (37.7802398682569, -122.476960548186) | 11 | 6 | 2 | 55 | 26 | ||
13736 | 90469 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 578 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988158.072517 | 2112047.558198 | 37.778596339842 | -122.484556541536 | (37.778596339842, -122.484556541536) | 11 | 6 | 2 | 55 | 26 | |
153634 | 90471 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 534 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5988147.641992 | 2112343.937312 | 37.7794095060794 | -122.484614370085 | (37.7794095060794, -122.484614370085) | 11 | 6 | 2 | 55 | 26 | |
99264 | 90510 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 555 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988112.407888 | 2112207.812683 | 37.7790336942222 | -122.484726269831 | (37.7790336942222, -122.484726269831) | 11 | 6 | 2 | 55 | 26 | |
110398 | 90511 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 569 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988115.726692 | 2112113.510215 | 37.7787749594642 | -122.484707869401 | (37.7787749594642, -122.484707869401) | 11 | 6 | 2 | 55 | 26 | |
72719 | 90526 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 705 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988149.756261 | 2111164.589328 | 37.7761714707406 | -122.484520528522 | (37.7761714707406, -122.484520528522) | 11 | 6 | 2 | 55 | 26 | |
131941 | 9116 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5757 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/2015 12:00:00 AM | 3 | 3x3 | 5989143.6236 | 2112579.8502 | 37.7801152084298 | -122.481186169595 | (37.7801152084298, -122.481186169595) | 11 | 6 | 2 | 55 | 26 | ||
170987 | 9125 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5827 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2017 11:55:00 AM | 3 | 3X3 | 5988965.7697498 | 2112572.6420628 | 37.7800850757133 | -122.481800911494 | (37.7800850757133, -122.481800911494) | 11 | 6 | 2 | 55 | 26 | ||
62962 | 97446 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 200X Parker Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2014 12:00:00 AM | 3x3 | Permit Number 772930 | 5997060.8 | 2112843.2 | 37.7812953839865 | -122.453816232036 | (37.7812953839865, -122.453816232036) | 11 | 6 | 2 | 54 | 16 |
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) );