trees
14 rows where qSpecies_id = 240
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2624 | 19842 | DPW Maintained 1 | Sequoiadendron giganteum :: Sierra Redwood 240 | 100 STAIRWAY25 | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
2684 | 19830 | DPW Maintained 1 | Sequoiadendron giganteum :: Sierra Redwood 240 | 100 STAIRWAY25 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60X | |||||||||||||
4617 | 19928 | DPW Maintained 1 | Sequoiadendron giganteum :: Sierra Redwood 240 | 100 STAIRWAY37 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
7956 | 20073 | DPW Maintained 1 | Sequoiadendron giganteum :: Sierra Redwood 240 | 100 STAIRWAY55 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 45X | |||||||||||||
8920 | 114053 | DPW Maintained 1 | Sequoiadendron giganteum :: Sierra Redwood 240 | 423 Vermont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x5 | 6011224.2875 | 2106354.81075 | 37.7642816018431 | -122.404360415893 | (37.7642816018431, -122.404360415893) | 8 | 3 | 8 | 28856 | 29 | |||
9873 | 19598 | DPW Maintained 1 | Sequoiadendron giganteum :: Sierra Redwood 240 | 100 STAIRWAY4 | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
16246 | 262100 | Landmark tree 11 | Sequoiadendron giganteum :: Sierra Redwood 240 | 3066 Market St | 1 | Back Yard : Yard | Tree | Private 2 | 6000145.77567 | 2105436.95685 | 37.7611360918542 | -122.442611833669 | (37.7611360918542, -122.442611833669) | 15 | 5 | 5 | 28862 | 3 | |||||
44517 | 251117 | Property Tree 8 | Sequoiadendron giganteum :: Sierra Redwood 240 | 2024 Castro St | 1 | Back Yard : Yard | Tree | Private 2 | 6002622 | 2099601 | 37.7452527853239 | -122.433630548541 | (37.7452527853239, -122.433630548541) | 2 | 7 | 5 | 63 | 22 | |||||
72456 | 136446 | DPW Maintained 1 | Sequoiadendron giganteum :: Sierra Redwood 240 | 3835 Scott St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 4ft | 6000566.22232 | 2121479.67269 | 37.8052092229784 | -122.442309414973 | (37.8052092229784, -122.442309414973) | 13 | 9 | 1 | 57 | 17 | |||
116973 | 240632 | DPW Maintained 1 | Sequoiadendron giganteum :: Sierra Redwood 240 | 200 Corbin Pl | 6 | Side Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6000056.02633 | 2105707.20258 | 37.7618730033536 | -122.442941644657 | (37.7618730033536, -122.442941644657) | 15 | 5 | 5 | 28862 | 3 | |||
124988 | 197591 | DPW Maintained 1 | Sequoiadendron giganteum :: Sierra Redwood 240 | 1 Jack Balestreri Way | 21 | Front Yard : Yard | Tree | Private 2 | 31 | 6012389.53926 | 2104790.48462 | 37.7600513564119 | -122.400220238489 | (37.7600513564119, -122.400220238489) | 10 | 3 | 8 | 28856 | 29 | ||||
161324 | 101031 | DPW Maintained 1 | Sequoiadendron giganteum :: Sierra Redwood 240 | 1010X Portola Dr | 5 | Front Yard : Yard | Tree | DPW 1 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||||
168402 | 249992 | DPW Maintained 1 | Sequoiadendron giganteum :: Sierra Redwood 240 | 228 Filbert St | 8 | Front Yard : Yard | Tree | Private 2 | 32 | Width 0ft | 6011574.68746 | 2120098.17712 | 37.8020372430841 | -122.404115766152 | (37.8020372430841, -122.404115766152) | 3 | 1 | 10 | 308 | 23 | |||
171323 | 253471 | Property Tree 8 | Sequoiadendron giganteum :: Sierra Redwood 240 | 17 Valletta Ct | 1 | Side Yard : Yard | Tree | Private 2 | 6x10 | 5999337 | 2096545 | 37.7366747995559 | -122.444769861358 | (37.7366747995559, -122.444769861358) | 9 | 7 | 4 | 63 | 40 |
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) );