trees
47 rows where Supervisor Districts = 11, qLegalStatus_id = 4 and qSpecies_id = 53
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8565 | 105233 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1508 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5998474.1 | 2108297 | 37.7688936152058 | -122.448599407064 | (37.7688936152058, -122.448599407064) | 15 | 5 | 11 | 29492 | 9 | |||
| 20084 | 115908 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||
| 20310 | 112288 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 895x PAGE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002361 | 2109458 | 37.7723029182135 | -122.435237957834 | (37.7723029182135, -122.435237957834) | 15 | 5 | 11 | 29492 | 9 | ||||
| 27991 | 97561 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1251X 04th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5994791.4 | 2106981 | 37.7650689602603 | -122.461242116604 | (37.7650689602603, -122.461242116604) | 15 | 5 | 11 | 56 | 12 | ||||
| 28710 | 102826 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2001X Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
| 35050 | 115907 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||
| 35372 | 94058 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1401X 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5993648 | 2105942 | 37.7621502689837 | -122.465121353228 | (37.7621502689837, -122.465121353228) | 1 | 8 | 11 | 56 | 12 | |||
| 36005 | 111369 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 724 IRVING ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993485 | 2106687 | 37.7641864431876 | -122.465739233402 | (37.7641864431876, -122.465739233402) | 11 | 8 | 11 | 56 | 12 | ||||
| 38742 | 113004 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 43330 | 113005 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 49558 | 113001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 59389 | 102825 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2001X Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
| 60833 | 102647 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 221 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x9 | 6002283 | 2109227 | 37.7716642197307 | -122.435491238531 | (37.7716642197307, -122.435491238531) | 15 | 5 | 11 | 29492 | 9 | ||||
| 74559 | 115904 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||||
| 90763 | 113321 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 222 HERMANN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6004169 | 2108774 | 37.7705273263251 | -122.428935147688 | (37.7705273263251, -122.428935147688) | 7 | 9 | 11 | 29492 | 10 | |||
| 92694 | 112578 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 660x Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999086 | 2108401 | 37.7692141419233 | -122.446490377962 | (37.7692141419233, -122.446490377962) | 15 | 5 | 11 | 29492 | 9 | ||||
| 102388 | 113158 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1104 STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997339 | 2106686 | 37.764405251212 | -122.452409351598 | (37.764405251212, -122.452409351598) | 15 | 5 | 11 | 29492 | 9 | ||||
| 102782 | 109882 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1520 PAGE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.446241403234 | (37.7711622584795, -122.446241403234) | 15 | 5 | 11 | 29492 | 9 | ||||
| 105584 | 113009 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 106362 | 115905 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||||
| 107825 | 113010 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 111821 | 116112 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002265 | 2109203 | 37.7715972993524 | -122.435551784305 | (37.7715972993524, -122.435551784305) | 15 | 5 | 11 | 29492 | 9 | ||||
| 118914 | 113002 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 125686 | 121101 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 600x Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998712 | 2105642 | 37.7616172542124 | -122.447585388011 | (37.7616172542124, -122.447585388011) | 15 | 5 | 11 | 29492 | 12 | ||||
| 125851 | 253693 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 536 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005450 | 2111168 | 37.7771730951376 | -122.424674483112 | (37.7771730951376, -122.424674483112) | 7 | 9 | 11 | 28852 | 10 | ||||
| 128624 | 117343 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 372 HAYES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6006019 | 2111114 | 37.7770569433878 | -122.422702290381 | (37.7770569433878, -122.422702290381) | 7 | 9 | 11 | 28852 | 10 | ||||
| 133335 | 99718 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 430 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6005787 | 2111054 | 37.7768791059226 | -122.423500585068 | (37.7768791059226, -122.423500585068) | 7 | 9 | 11 | 28852 | 10 | |||
| 135459 | 106967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1225 02ND AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995419.1 | 2107212.6 | 37.7657409782079 | -122.459087842629 | (37.7657409782079, -122.459087842629) | 15 | 5 | 11 | 56 | 12 | ||||||
| 140272 | 93200 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 756 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x6 | 5998607 | 2107901 | 37.7678138979087 | -122.448111199872 | (37.7678138979087, -122.448111199872) | 15 | 5 | 11 | 29492 | 9 | ||||
| 141056 | 121371 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11x Seymour St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001614 | 2112138 | 37.7796190766925 | -122.438013896478 | (37.7796190766925, -122.438013896478) | 15 | 5 | 11 | 29490 | 41 | ||||
| 145447 | 110581 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 401x BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6001156 | 2110113 | 37.7740328816457 | -122.439453113359 | (37.7740328816457, -122.439453113359) | 15 | 5 | 11 | 29492 | 10 | ||||
| 147215 | 121369 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11x Seymour St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001614 | 2112138 | 37.7796190766925 | -122.438013896478 | (37.7796190766925, -122.438013896478) | 15 | 5 | 11 | 29490 | 41 | ||||
| 148808 | 102824 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2001X Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
| 151430 | 115906 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||
| 151645 | 116113 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002265 | 2109203 | 37.7715972993524 | -122.435551784305 | (37.7715972993524, -122.435551784305) | 15 | 5 | 11 | 29492 | 9 | ||||
| 153860 | 94059 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1401X 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5993648 | 2105942 | 37.7621502689837 | -122.465121353228 | (37.7621502689837, -122.465121353228) | 1 | 8 | 11 | 56 | 12 | |||
| 155645 | 110676 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1898 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001594 | 2114879 | 37.7871440264162 | -122.438279504546 | (37.7871440264162, -122.438279504546) | 13 | 6 | 11 | 29490 | 27 | ||||
| 162574 | 113000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 163074 | 110027 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1101X WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6003707 | 2112516 | 37.7807757743573 | -122.430800292528 | (37.7807757743573, -122.430800292528) | 15 | 9 | 11 | 29490 | 41 | ||||
| 170574 | 114952 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601X OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005348 | 2111368 | 37.7777164851071 | -122.42504156742 | (37.7777164851071, -122.42504156742) | 7 | 9 | 11 | 28852 | 10 | ||||
| 172169 | 117345 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 395 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006014 | 2111158 | 37.7771774746178 | -122.422722714586 | (37.7771774746178, -122.422722714586) | 7 | 9 | 11 | 28852 | 10 | ||||
| 173238 | 113007 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 173558 | 113006 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 176974 | 113008 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
| 177966 | 106938 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1607 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5997889 | 2108175 | 37.7685251613651 | -122.450614421545 | (37.7685251613651, -122.450614421545) | 15 | 5 | 11 | 29492 | 9 | ||||
| 180149 | 112971 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601x COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5997795 | 2108483 | 37.7693654697431 | -122.450961770246 | (37.7693654697431, -122.450961770246) | 15 | 5 | 11 | 29492 | 9 | |||
| 184217 | 113003 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 |
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) );