trees
17 rows where Fire Prevention Districts = 7, PlantType = "Tree" and qSpecies_id = 48
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98 | 261380 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 298x Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008523 | 2113477 | 37.7836861327236 | -122.414207368753 | (37.7836861327236, -122.414207368753) | 7 | 10 | 9 | 28852 | 36 | ||||
842 | 261260 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 431 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6004908 | 2110310 | 37.7747866111117 | -122.426488326031 | (37.7747866111117, -122.426488326031) | 7 | 9 | 11 | 28852 | 10 | ||||
5012 | 261384 | Undocumented 4 | Potential Site :: Potential Site 48 | 246 Leavenworth St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008558 | 2113314 | 37.7832405398106 | -122.41407474629 | (37.7832405398106, -122.41407474629) | 7 | 10 | 9 | 28852 | 36 | |||||
11948 | 264853 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 840 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 6006827.36035 | 2113629.74006 | 37.7840101293977 | -122.42008449353 | (37.7840101293977, -122.42008449353) | 7 | 9 | 9 | 28858 | 36 | |||
16085 | 261385 | Undocumented 4 | Potential Site :: Potential Site 48 | 238 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008591 | 2113342 | 37.7833192745132 | -122.413962560517 | (37.7833192745132, -122.413962560517) | 7 | 10 | 9 | 28852 | 36 | ||||
18588 | 261261 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 425 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6004928 | 2110351 | 37.7749003177122 | -122.426422061759 | (37.7749003177122, -122.426422061759) | 7 | 9 | 11 | 28852 | 10 | ||||
19185 | 264854 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 840 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 6006827.36035 | 2113629.74006 | 37.7840101293977 | -122.42008449353 | (37.7840101293977, -122.42008449353) | 7 | 9 | 9 | 28858 | 36 | |||
19625 | 261379 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 420 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008383 | 2113512 | 37.7837743694769 | -122.414694194891 | (37.7837743694769, -122.414694194891) | 7 | 10 | 9 | 28858 | 36 | ||||
23952 | 169219 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 840 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 0 | 3x3 | 6006827.36035 | 2113629.74006 | 37.7840101293977 | -122.42008449353 | (37.7840101293977, -122.42008449353) | 7 | 9 | 9 | 28858 | 36 | ||
30535 | 255733 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 840 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 6006827.36035 | 2113629.74006 | 37.7840101293977 | -122.42008449353 | (37.7840101293977, -122.42008449353) | 7 | 9 | 9 | 28858 | 36 | |||
39960 | 258413 | Permitted Site 7 | Potential Site :: Potential Site 48 | 119 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004727 | 2108913 | 37.7709405550078 | -122.427014922048 | (37.7709405550078, -122.427014922048) | 7 | 9 | 11 | 28852 | 10 | ||||
64729 | 139829 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 925 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005130.3176 | 2112304.2753 | 37.7802749685253 | -122.425861267784 | (37.7802749685253, -122.425861267784) | 7 | 9 | 11 | 28852 | 41 | |||
125158 | 169170 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 750 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 0 | 3x3 | 6006877.96422 | 2113290.02776 | 37.7830802133315 | -122.419885308057 | (37.7830802133315, -122.419885308057) | 7 | 9 | 9 | 28858 | 36 | ||
157133 | 169168 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 701 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 0 | 3x3 | 6007051.56678 | 2113380.55802 | 37.7833385660552 | -122.419291136796 | (37.7833385660552, -122.419291136796) | 7 | 9 | 9 | 28858 | 36 | ||
160069 | 169218 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 824 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 0 | 3x3 | 6006905.30546 | 2113639.62991 | 37.7840416758297 | -122.419815533287 | (37.7840416758297, -122.419815533287) | 7 | 9 | 9 | 28858 | 36 | ||
160755 | 169217 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 800 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 0 | 3x3 | 6006932.37231 | 2113646.73425 | 37.7840627073778 | -122.419722395865 | (37.7840627073778, -122.419722395865) | 7 | 9 | 9 | 28858 | 36 | ||
186594 | 169214 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 724 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 0 | Width 4ft | 6007369.54432 | 2113705.88387 | 37.7842497348906 | -122.418214130293 | (37.7842497348906, -122.418214130293) | 7 | 9 | 9 | 28858 | 36 |
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) );