trees
19 rows where qSpecies_id = 134
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 704 | 10945 | DPW Maintained 1 | Quercus coccinea :: Scarlet Oak 134 | 1400X Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6016738.0241541 | 2096692.24342 | 37.7380567715564 | -122.384616664641 | (37.7380567715564, -122.384616664641) | 10 | 3 | 8 | 58 | 1 | ||
| 35035 | 95795 | Permitted Site 7 | Quercus coccinea :: Scarlet Oak 134 | 330 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767538 | 6006154 | 2101094.4 | 37.7495530959347 | -122.421523510351 | (37.7495530959347, -122.421523510351) | 2 | 4 | 5 | 28859 | 19 | |
| 44765 | 10889 | Permitted Site 7 | Quercus coccinea :: Scarlet Oak 134 | 1270X Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
| 57647 | 34026 | Permitted Site 7 | Quercus coccinea :: Scarlet Oak 134 | 2730 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51549 | 6008501.61322181 | 2106845.55424255 | 37.7654765469809 | -122.413812123028 | (37.7654765469809, -122.413812123028) | 8 | 4 | 7 | 28853 | 19 | ||
| 62999 | 34028 | Permitted Site 7 | Quercus coccinea :: Scarlet Oak 134 | 2730 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51549 | 6008501.61322181 | 2106845.55424255 | 37.7654765469809 | -122.413812123028 | (37.7654765469809, -122.413812123028) | 8 | 4 | 7 | 28853 | 19 | ||
| 66406 | 95798 | Permitted Site 7 | Quercus coccinea :: Scarlet Oak 134 | 1106 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767540 | 6008629.6 | 2102091.1 | 37.7524290867487 | -122.413033242012 | (37.7524290867487, -122.413033242012) | 2 | 4 | 7 | 28859 | 19 | |
| 73899 | 29569 | DPW Maintained 1 | Quercus coccinea :: Scarlet Oak 134 | 1175X Hudson Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/2006 12:00:00 AM | 3 | 3x3 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | ||
| 80620 | 95796 | Permitted Site 7 | Quercus coccinea :: Scarlet Oak 134 | 330 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767538 | 6006154 | 2101094.4 | 37.7495530959347 | -122.421523510351 | (37.7495530959347, -122.421523510351) | 2 | 4 | 5 | 28859 | 19 | |
| 86866 | 10957 | DPW Maintained 1 | Quercus coccinea :: Scarlet Oak 134 | 1425X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6016592.1339091 | 2096738.5714059 | 37.7381759097054 | -122.385124311518 | (37.7381759097054, -122.385124311518) | 10 | 3 | 8 | 58 | 1 | ||
| 87266 | 10873 | DPW Maintained 1 | Quercus coccinea :: Scarlet Oak 134 | 1175X Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | ||
| 89060 | 94575 | Permitted Site 7 | Quercus coccinea :: Scarlet Oak 134 | 3889 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53753 | 6004405 | 2104227 | 37.7580557086801 | -122.427794786333 | (37.7580557086801, -122.427794786333) | 2 | 4 | 5 | 28862 | 3 |
| 90349 | 10796 | DPW Maintained 1 | Quercus coccinea :: Scarlet Oak 134 | 1139X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3x4 | 6017446.51401 | 2094936.46101 | 37.7332748977764 | -122.382044937386 | (37.7332748977764, -122.382044937386) | 10 | 3 | 8 | 58 | 1 | ||
| 122726 | 41305 | Permitted Site 7 | Quercus coccinea :: Scarlet Oak 134 | 1387 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/27/2004 12:00:00 AM | Permit Number 41977 | 6006476.01966821 | 2101521.23564445 | 37.7507432410359 | -122.420440247305 | (37.7507432410359, -122.420440247305) | 2 | 4 | 7 | 28859 | 19 | ||
| 124403 | 96166 | Permitted Site 7 | Quercus coccinea :: Scarlet Oak 134 | 166 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767797 | 6005546.8 | 2096117.3 | 37.7358528516077 | -122.423269476417 | (37.7358528516077, -122.423269476417) | 2 | 7 | 7 | 28859 | 2 | |
| 136107 | 26892 | DPW Maintained 1 | Quercus coccinea :: Scarlet Oak 134 | 1591 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6015737.7946966 | 2097374.5847744 | 37.7398749760386 | -122.388122590187 | (37.7398749760386, -122.388122590187) | 10 | 3 | 8 | 58 | 1 | ||
| 144788 | 67677 | Permitted Site 7 | Quercus coccinea :: Scarlet Oak 134 | 1511 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2006 12:00:00 AM | Permit Number 31281 | 6016146.7997149 | 2097069.00450631 | 37.7390585672526 | -122.386687105419 | (37.7390585672526, -122.386687105419) | 10 | 3 | 8 | 58 | 1 | ||
| 146559 | 10890 | Permitted Site 7 | Quercus coccinea :: Scarlet Oak 134 | 1270X Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
| 169868 | 96576 | DPW Maintained 1 | Quercus coccinea :: Scarlet Oak 134 | 401x Otsego Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | ||||
| 182603 | 10853 | DPW Maintained 1 | Quercus coccinea :: Scarlet Oak 134 | 1299X HUDSON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 |
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) );