trees
13 rows where qSpecies_id = 380
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18845 | 177801 | DPW Maintained 1 | Musa spp :: Banana 380 | 602 Somerset St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6010321.54075 | 2091581.41178 | 37.7236665715367 | -122.406441719624 | (37.7236665715367, -122.406441719624) | 10 | 3 | 7 | 309 | 28 | |||
| 27175 | 131691 | DPW Maintained 1 | Musa spp :: Banana 380 | 145 Jefferson St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008568.16914 | 2122427.24291 | 37.8082638269937 | -122.414684701334 | (37.8082638269937, -122.414684701334) | 3 | 1 | 10 | 308 | 23 | |||
| 34822 | 131690 | DPW Maintained 1 | Musa spp :: Banana 380 | 407 Vallejo St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 105 | 6011485.14109 | 2119034.37122 | 37.7991112871264 | -122.404350720332 | (37.7991112871264, -122.404350720332) | 3 | 1 | 10 | 308 | 23 | ||||
| 38726 | 131692 | DPW Maintained 1 | Musa spp :: Banana 380 | 1320 Montgomery St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6011481.2848 | 2119933.32339 | 37.8015793757372 | -122.404427374926 | (37.8015793757372, -122.404427374926) | 3 | 1 | 10 | 308 | 23 | |||
| 38993 | 177799 | DPW Maintained 1 | Musa spp :: Banana 380 | 116 Madison St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6005447.3066 | 2093160.52782 | 37.7277285951938 | -122.423403332722 | (37.7277285951938, -122.423403332722) | 9 | 7 | 6 | 28861 | 5 | ||||
| 49752 | 131693 | DPW Maintained 1 | Musa spp :: Banana 380 | 1320 Montgomery St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 6011479.18542 | 2119943.51141 | 37.8016072322366 | -122.404435357312 | (37.8016072322366, -122.404435357312) | 3 | 1 | 10 | 308 | 23 | |||
| 82620 | 177800 | DPW Maintained 1 | Musa spp :: Banana 380 | 155 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007996.15467 | 2093190.31958 | 37.7279539257093 | -122.414594002925 | (37.7279539257093, -122.414594002925) | 9 | 3 | 7 | 309 | 28 | |||
| 82841 | 177802 | DPW Maintained 1 | Musa spp :: Banana 380 | 602 Somerset St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6010323.59493 | 2091573.26395 | 37.7236443142053 | -122.406434044795 | (37.7236443142053, -122.406434044795) | 10 | 3 | 7 | 309 | 28 | |||
| 90270 | 177798 | DPW Maintained 1 | Musa spp :: Banana 380 | 242 Athens St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6004474.39052 | 2091852.30475 | 37.7240815439024 | -122.42667360043 | (37.7240815439024, -122.42667360043) | 9 | 7 | 6 | 28861 | 5 | ||||
| 112508 | 246455 | DPW Maintained 1 | Musa spp :: Banana 380 | 405 Duncan St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6003830.51573 | 2099804.43405 | 37.7458798656648 | -122.429466210292 | (37.7458798656648, -122.429466210292) | 2 | 7 | 5 | 63 | 22 | |||
| 119290 | 177797 | DPW Maintained 1 | Musa spp :: Banana 380 | 247 Mount Vernon Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5998689.65231 | 2089589.59566 | 37.7175399212214 | -122.446507764144 | (37.7175399212214, -122.446507764144) | 9 | 7 | 6 | 28861 | 25 | ||||
| 138287 | 256893 | DPW Maintained 1 | Musa spp :: Banana 380 | 533 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 6ft | 6002026 | 2090370 | 37.7198727401968 | -122.435031335274 | (37.7198727401968, -122.435031335274) | 9 | 7 | 6 | 28861 | 5 | ||||
| 149630 | 246452 | DPW Maintained 1 | Musa spp :: Banana 380 | 405 Duncan St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6003797.20861 | 2099802.06763 | 37.7458714821788 | -122.429581212917 | (37.7458714821788, -122.429581212917) | 2 | 7 | 5 | 63 | 22 |
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) );