trees
27 rows where qSiteInfo = "Side Yard : Yard" and qSpecies_id = 59 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11694 | 263618 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 1 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
13002 | 260949 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 460x Davis Ct | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6013239 | 2118152 | 37.7967863568579 | -122.398219792292 | (37.7967863568579, -122.398219792292) | 3 | 1 | 10 | 28860 | 6 | ||||
35297 | 248111 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 1 | Side Yard : Yard | Tree | Private 2 | 24 | 6010383.71107 | 2099443.85944 | 37.7452586580609 | -122.406780656096 | (37.7452586580609, -122.406780656096) | 2 | 7 | 7 | 28859 | 2 | ||||
80814 | 248172 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 218 Esmeralda Ave | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6007302.01446 | 2098729.32454 | 37.7431237943252 | -122.417386043537 | (37.7431237943252, -122.417386043537) | 2 | 7 | 7 | 28859 | 2 | ||||
142556 | 256880 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2701 Alemany Blvd | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5997600 | 2087902 | 37.7128438731446 | -122.450152604107 | (37.7128438731446, -122.450152604107) | 9 | 7 | 6 | 28861 | 25 | ||||
151245 | 255455 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 31x Garlington Ct | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6016454 | 2094669 | 37.7324856396877 | -122.385457730704 | (37.7324856396877, -122.385457730704) | 10 | 3 | 8 | 58 | 1 | ||||
183244 | 195979 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Phelps St | 1 | Side Yard : Yard | Tree | Private 2 | 30 | Width 9ft | 6014704.25324 | 2097268.53042 | 37.7395264548697 | -122.39168875964 | (37.7395264548697, -122.39168875964) | 10 | 3 | 8 | 58 | 1 | |||
146085 | 248120 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 10 | Side Yard : Yard | Tree | Private 2 | 12 | 6010373.21137 | 2099395.33781 | 37.745124840742 | -122.406813543437 | (37.745124840742, -122.406813543437) | 2 | 7 | 7 | 28859 | 2 | ||||
4419 | 260950 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 460x Davis Ct | 2 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6013239 | 2118152 | 37.7967863568579 | -122.398219792292 | (37.7967863568579, -122.398219792292) | 3 | 1 | 10 | 28860 | 6 | ||||
10225 | 263619 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 2 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
20810 | 248173 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 218 Esmeralda Ave | 2 | Side Yard : Yard | Tree | Private 2 | 6 | 6007303.95131 | 2098726.55555 | 37.743116300271 | -122.417379150221 | (37.743116300271, -122.417379150221) | 2 | 7 | 7 | 28859 | 2 | ||||
74182 | 195980 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Phelps St | 2 | Side Yard : Yard | Tree | Private 2 | 24 | 6014694.29284 | 2097256.88186 | 37.7394939174204 | -122.391722384404 | (37.7394939174204, -122.391722384404) | 10 | 3 | 8 | 58 | 1 | ||||
189964 | 195993 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2101 Newcomb Ave | 2 | Side Yard : Yard | Tree | Private 2 | 23 | Width 3ft | 6012429.27896 | 2097757.0265 | 37.7407412159349 | -122.399588970171 | (37.7407412159349, -122.399588970171) | 10 | 3 | 8 | 58 | 1 | |||
1376 | 263620 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 3 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
32210 | 195994 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2101 Newcomb Ave | 3 | Side Yard : Yard | Tree | Private 2 | 20 | Width 3ft | 6012438.11131 | 2097750.05558 | 37.7407225675882 | -122.39955794175 | (37.7407225675882, -122.39955794175) | 10 | 3 | 8 | 58 | 1 | |||
35274 | 249899 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1497 Montgomery St | 3 | Side Yard : Yard | Tree | Private 2 | 17 | Width 0ft | 6011381.09793 | 2120471.14228 | 37.8030504957345 | -122.404811954701 | (37.8030504957345, -122.404811954701) | 3 | 1 | 10 | 28860 | 6 | |||
40536 | 248113 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 3 | Side Yard : Yard | Tree | Private 2 | 17 | 6010385.30327 | 2099441.28079 | 37.7452516667373 | -122.406774968811 | (37.7452516667373, -122.406774968811) | 2 | 7 | 7 | 28859 | 2 | ||||
10567 | 263621 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 4 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
89186 | 248114 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 4 | Side Yard : Yard | Tree | Private 2 | 15 | 6010381.0463 | 2099434.05906 | 37.7452315992509 | -122.406789179902 | (37.7452315992509, -122.406789179902) | 2 | 7 | 7 | 28859 | 2 | ||||
93753 | 195995 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2101 Newcomb Ave | 4 | Side Yard : Yard | Tree | Private 2 | 23 | Width 3ft | 6012483.54441 | 2097715.89022 | 37.7406312890986 | -122.399398452383 | (37.7406312890986, -122.399398452383) | 10 | 3 | 8 | 58 | 1 | |||
80514 | 248115 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 5 | Side Yard : Yard | Tree | Private 2 | 7 | 6010382.66989 | 2099427.30215 | 37.7452131370921 | -122.406783089664 | (37.7452131370921, -122.406783089664) | 2 | 7 | 7 | 28859 | 2 | ||||
115902 | 195996 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2101 Newcomb Ave | 5 | Side Yard : Yard | Tree | Private 2 | 14 | Width 3ft | 6012499.27572 | 2097703.95349 | 37.7405993901482 | -122.399343221431 | (37.7405993901482, -122.399343221431) | 10 | 3 | 8 | 58 | 1 | |||
150059 | 249897 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1497 Montgomery St | 5 | Side Yard : Yard | Tree | Private 2 | 20 | Width 0ft | 6011384.61876 | 2120458.08201 | 37.8030148322229 | -122.404798850701 | (37.8030148322229, -122.404798850701) | 3 | 1 | 10 | 28860 | 6 | |||
104444 | 248116 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 6 | Side Yard : Yard | Tree | Private 2 | 9 | 6010379.57479 | 2099419.47211 | 37.745191464328 | -122.406793240314 | (37.745191464328, -122.406793240314) | 2 | 7 | 7 | 28859 | 2 | ||||
37570 | 248117 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 7 | Side Yard : Yard | Tree | Private 2 | 6 | 6010378.29952 | 2099414.5285 | 37.7451778188963 | -122.406797301657 | (37.7451778188963, -122.406797301657) | 2 | 7 | 7 | 28859 | 2 | ||||
172175 | 248118 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 8 | Side Yard : Yard | Tree | Private 2 | 6 | 6010376.97092 | 2099406.95495 | 37.7451569492381 | -122.40680136209 | (37.7451569492381, -122.40680136209) | 2 | 7 | 7 | 28859 | 2 | ||||
87689 | 248119 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 9 | Side Yard : Yard | Tree | Private 2 | 18 | 6010375.35501 | 2099399.67941 | 37.7451368817742 | -122.406806436993 | (37.7451368817742, -122.406806436993) | 2 | 7 | 7 | 28859 | 2 |
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) );