trees
22 rows where SiteOrder = 12 and qSpecies_id = 31
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 225 | 119839 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 6452 | 109163 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 12 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
| 7095 | 198444 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015385.26433 | 2106283.84094 | 37.7643183769187 | -122.389963693588 | (37.7643183769187, -122.389963693588) | 14 | 3 | 9 | 310 | 29 | |||
| 34450 | 119816 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 12 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 34723 | 242403 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008707.95248 | 2101269.88955 | 37.7501786250428 | -122.412704235035 | (37.7501786250428, -122.412704235035) | 2 | 4 | 7 | 28859 | 19 | |||
| 41710 | 244310 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005563.2696 | 2110605.957 | 37.7756362582127 | -122.424242664251 | (37.7756362582127, -122.424242664251) | 7 | 9 | 11 | 28852 | 10 | |||
| 50705 | 246545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 12 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6005664.26886 | 2109539.08097 | 37.7727125769595 | -122.423817404855 | (37.7727125769595, -122.423817404855) | 7 | 9 | 11 | 28852 | 10 | |||
| 56446 | 198623 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015749.91564 | 2108621.24573 | 37.7707565982691 | -122.38886565105 | (37.7707565982691, -122.38886565105) | 14 | 3 | 9 | 310 | 20 | ||||
| 59407 | 198638 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015910.55807 | 2108750.53892 | 37.7711205116333 | -122.388319006239 | (37.7711205116333, -122.388319006239) | 14 | 3 | 9 | 310 | 20 | ||||
| 65768 | 255467 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6016676.72369 | 2094975.37763 | 37.7333392118181 | -122.384709049297 | (37.7333392118181, -122.384709049297) | 10 | 3 | 8 | 58 | 1 | ||||
| 86911 | 244468 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005635.3174 | 2109670.3256 | 37.7730713086411 | -122.423926885709 | (37.7730713086411, -122.423926885709) | 7 | 9 | 11 | 28852 | 10 | |||
| 91488 | 100581 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
| 120368 | 97843 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6015209.91817 | 2104379.39414 | 37.7590794509666 | -122.390437094914 | (37.7590794509666, -122.390437094914) | 10 | 3 | 8 | 28856 | 29 | ||||
| 131688 | 198592 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013452.45897 | 2107129.35079 | 37.766532578853 | -122.396708048633 | (37.766532578853, -122.396708048633) | 14 | 3 | 8 | 28856 | 20 | |
| 134418 | 119719 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 12 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 137677 | 138394 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2445 PINE ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002278.9059 | 2115030.4127 | 37.7875986981409 | -122.435920721296 | (37.7875986981409, -122.435920721296) | 13 | 6 | 11 | 29490 | 27 | |||
| 141476 | 17588 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6003687.80932 | 2090380.02196 | 37.7199944786431 | -122.429287755146 | (37.7199944786431, -122.429287755146) | 9 | 7 | 6 | 28861 | 5 | |||
| 151443 | 244401 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005612.7252 | 2110260.2263 | 37.7746897578806 | -122.424046993197 | (37.7746897578806, -122.424046993197) | 7 | 9 | 11 | 28852 | 10 | |||
| 155817 | 16449 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
| 156133 | 100625 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
| 165603 | 119792 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 12 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 190598 | 119757 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) |
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) );