trees
30 rows where Supervisor Districts = 1 and qSpecies_id = 59 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15414 | 96980 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
59791 | 96983 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | Permit Number 25529 | 6003522.34271 | 2118089.29041 | 37.796068153086 | -122.431837171257 | (37.796068153086, -122.431837171257) | 13 | 9 | 1 | 57 | 17 | |||
74255 | 96979 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
91372 | 96982 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 41 | Permit Number 25529 | 6003530.13563 | 2118059.26209 | 37.7959861448054 | -122.431808061115 | (37.7959861448054, -122.431808061115) | 13 | 9 | 1 | 57 | 17 | |||
123430 | 96984 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
156312 | 104131 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 6003522.94878 | 2118100.93382 | 37.7961001572485 | -122.431835905912 | (37.7961001572485, -122.431835905912) | 13 | 9 | 1 | 57 | 17 | ||||
171267 | 96981 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
187717 | 96978 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
36058 | 6095 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2015 12:00:00 AM | 12 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | ||
129436 | 6094 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | |||
145827 | 6098 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | |||
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 | |||
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 | |||
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 | |||
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 | |||
14196 | 6096 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | |||
14173 | 140080 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6000726.8608 | 2112462.5832 | 37.7804598090154 | -122.441106178881 | (37.7804598090154, -122.441106178881) | 15 | 5 | 1 | 29490 | 41 | |||
126030 | 140081 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104 Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6000726.184 | 2112472.3974 | 37.7804867177527 | -122.441109224562 | (37.7804867177527, -122.441109224562) | 15 | 5 | 1 | 29490 | 41 | |||
152832 | 140079 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000729.2298 | 2112451.4153 | 37.7804292797496 | -122.441097181955 | (37.7804292797496, -122.441097181955) | 15 | 5 | 1 | 29490 | 41 | |||
154261 | 140083 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 6000722.7998 | 2112497.1022 | 37.7805543580623 | -122.441122705034 | (37.7805543580623, -122.441122705034) | 15 | 5 | 1 | 29490 | 41 | |||
1248 | 260958 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 5996359 | 2114633 | 37.786169437555 | -122.456373557771 | (37.786169437555, -122.456373557771) | 11 | 6 | 1 | 54 | 31 | ||||
17671 | 260957 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 5996359 | 2114633 | 37.786169437555 | -122.456373557771 | (37.786169437555, -122.456373557771) | 11 | 6 | 1 | 54 | 31 | ||||
63685 | 135663 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5996346.46825 | 2114626.15487 | 37.7861499232377 | -122.456416418905 | (37.7861499232377, -122.456416418905) | 11 | 6 | 1 | 54 | 31 | |||
138606 | 135664 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5996336.60886 | 2114624.27331 | 37.7861441909595 | -122.456450393471 | (37.7861441909595, -122.456450393471) | 11 | 6 | 1 | 54 | 31 | |||
154598 | 135665 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 5996326.40952 | 2114621.95963 | 37.7861372526689 | -122.456485512902 | (37.7861372526689, -122.456485512902) | 11 | 6 | 1 | 54 | 31 | |||
37565 | 125723 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | Width 4ft | 6003539.04242 | 2117994.60754 | 37.7958091249389 | -122.431772623315 | (37.7958091249389, -122.431772623315) | 13 | 9 | 1 | 57 | 17 | |||
47415 | 125722 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 43 | Width 4ft | 6003540.89789 | 2117978.17849 | 37.7957641201722 | -122.431765029446 | (37.7957641201722, -122.431765029446) | 13 | 9 | 1 | 57 | 17 | |||
49152 | 125724 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | Width 4ft | 6003536.06003 | 2118009.60299 | 37.7958501295278 | -122.431784014136 | (37.7958501295278, -122.431784014136) | 13 | 9 | 1 | 57 | 17 | |||
166467 | 125725 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | Width 4ft | 6003533.81623 | 2118024.94741 | 37.7958921341649 | -122.431792874238 | (37.7958921341649, -122.431792874238) | 13 | 9 | 1 | 57 | 17 | |||
78015 | 135666 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3001 Divisadero St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 42 | Width 9ft | 6000472.49775 | 2118651.89467 | 37.7974395562567 | -122.442430617479 | (37.7974395562567, -122.442430617479) | 13 | 9 | 1 | 57 | 17 |
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) );