trees
15 rows where qSpecies_id = 161
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1013 | 143004 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 432 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010250.3341 | 2120628.0507 | 37.8034180593376 | -122.408736082419 | (37.8034180593376, -122.408736082419) | 3 | 1 | 10 | 308 | 23 | |||
11430 | 30462 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 440 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/1956 12:00:00 AM | 12 | Permit Number 118 | 6010811.9437 | 2119664.9419 | 37.800805038366 | -122.406724685857 | (37.800805038366, -122.406724685857) | 3 | 1 | 10 | 308 | 23 | ||
21679 | 246521 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 155 Laguna St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6005168.32493 | 2109423.36878 | 37.772366849681 | -122.425524694021 | (37.772366849681, -122.425524694021) | 7 | 9 | 5 | 28852 | 10 | |||
71790 | 246519 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 155 Laguna St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6005163.41705 | 2109460.79919 | 37.7724693472229 | -122.425544335225 | (37.7724693472229, -122.425544335225) | 7 | 9 | 5 | 28852 | 10 | |||
86575 | 209703 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 100X Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5994492.3466 | 2105343.52789 | 37.7605556719136 | -122.462157698016 | (37.7605556719136, -122.462157698016) | 1 | 5 | 11 | 56 | 12 | |||
87719 | 143036 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 502 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/2015 07:41:00 AM | 2 | Width 0ft | 6009910.3575 | 2120582.9753 | 37.8032752457109 | -122.409909406146 | (37.8032752457109, -122.409909406146) | 3 | 1 | 10 | 308 | 23 | ||
98085 | 246523 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 155 Laguna St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6005175.38758 | 2109381.26241 | 37.7722516348266 | -122.425497266487 | (37.7722516348266, -122.425497266487) | 7 | 9 | 5 | 28852 | 10 | |||
101275 | 246531 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 65 Laguna St | 1 | : | Tree | Private 2 | 1 | Width 7ft | 6005223.74715 | 2109045.02652 | 37.7713311445463 | -122.42530605535 | (37.7713311445463, -122.42530605535) | 7 | 9 | 5 | 28852 | 10 | |||
118864 | 254478 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 490 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/04/2015 08:35:00 AM | 3X3 | 6010007.9078 | 2120594.4895 | 37.8033123274611 | -122.409572641782 | (37.8033123274611, -122.409572641782) | 3 | 1 | 10 | 308 | 23 | |||
140993 | 246527 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 155 Laguna St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6005190.67054 | 2109265.21569 | 37.7719338620836 | -122.425436141365 | (37.7719338620836, -122.425436141365) | 7 | 9 | 5 | 28852 | 10 | |||
141216 | 246524 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 155 Laguna St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6005181.96969 | 2109337.81192 | 37.7721327021841 | -122.425471405595 | (37.7721327021841, -122.425471405595) | 7 | 9 | 5 | 28852 | 10 | |||
154096 | 246533 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 55 Laguna St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6005235.09001 | 2108976.11964 | 37.7711425836932 | -122.425261915701 | (37.7711425836932, -122.425261915701) | 7 | 9 | 5 | 28852 | 10 | |||
180797 | 246532 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 65 Laguna St | 2 | : | Tree | Private 2 | 1 | Width 6ft | 6005230.90915 | 2109011.02388 | 37.7712381861207 | -122.425278861635 | (37.7712381861207, -122.425278861635) | 7 | 9 | 5 | 28852 | 10 | |||
191778 | 143038 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 516 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/2015 07:48:00 AM | 19 | Width 0ft | 6009865.0083 | 2120574.7299 | 37.80325006424 | -122.41006575677 | (37.80325006424, -122.41006575677) | 3 | 1 | 10 | 308 | 23 | ||
194370 | 258049 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 576 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5x6 | Cross streets are also Jasper to Stockton; site is directly across from Via Ferlinghetti (alley) | 6010185.99879 | 2119580.18301 | 37.8005372695328 | -122.408884743211 | (37.8005372695328, -122.408884743211) | 3 | 1 | 10 | 308 | 23 |
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) );