trees
26 rows where SiteOrder = 10 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 406 | 119837 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 4702 | 198610 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6016166.07078 | 2108644.55968 | 37.7708436706185 | -122.387427776296 | (37.7708436706185, -122.387427776296) | 14 | 3 | 9 | 310 | 20 | ||||
| 5011 | 119790 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 10 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 26836 | 198657 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6013998.08453 | 2107337.5024 | 37.7671344699085 | -122.394835392165 | (37.7671344699085, -122.394835392165) | 14 | 3 | 9 | 310 | 20 | |||
| 27032 | 119717 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 10 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 32719 | 242505 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2618 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6008253.889 | 2102895.90395 | 37.7546177982782 | -122.414389457507 | (37.7546177982782, -122.414389457507) | 2 | 4 | 7 | 28859 | 19 | |||
| 37035 | 198590 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013501.44813 | 2107135.10099 | 37.766551094089 | -122.396539005766 | (37.766551094089, -122.396539005766) | 14 | 3 | 8 | 28856 | 20 | |
| 44552 | 198462 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014805.14744 | 2106272.79418 | 37.7642558551341 | -122.391969398478 | (37.7642558551341, -122.391969398478) | 14 | 3 | 9 | 310 | 29 | |||
| 47528 | 198442 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015430.62355 | 2106285.94365 | 37.7643266659781 | -122.389806954341 | (37.7643266659781, -122.389806954341) | 14 | 3 | 9 | 310 | 29 | |||
| 57589 | 119826 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 10 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 59722 | 17586 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003709.25966 | 2090367.07531 | 37.7199601443381 | -122.429212686015 | (37.7199601443381, -122.429212686015) | 9 | 7 | 6 | 28861 | 5 | |||
| 67332 | 108237 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131 RUSS ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010302 | 2111707 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | 14 | 2 | 9 | 28853 | 34 | ||||
| 76811 | 244287 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005585.9927 | 2110033.382 | 37.7740653890161 | -122.424123330561 | (37.7740653890161, -122.424123330561) | 7 | 9 | 11 | 28852 | 10 | |||
| 89789 | 244330 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005665.121 | 2109878.6077 | 37.7736448835433 | -122.423838604142 | (37.7736448835433, -122.423838604142) | 7 | 9 | 11 | 28852 | 10 | |||
| 110263 | 119755 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 106x Octavia St Frontage West | 10 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 112920 | 244466 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005631.2066 | 2109707.3231 | 37.7731726627699 | -122.423943736898 | (37.7731726627699, -122.423943736898) | 7 | 9 | 11 | 28852 | 10 | |||
| 126195 | 244399 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005618.8355 | 2110208.2889 | 37.7745474953334 | -122.424022162207 | (37.7745474953334, -122.424022162207) | 7 | 9 | 11 | 28852 | 10 | |||
| 132431 | 97841 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6015209.75012 | 2104419.2004 | 37.7591887410927 | -122.390440457463 | (37.7591887410927, -122.390440457463) | 10 | 3 | 8 | 28856 | 29 | ||||
| 145214 | 198651 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6016332.95432 | 2108773.69506 | 37.7712074895574 | -122.386859524348 | (37.7712074895574, -122.386859524348) | 14 | 3 | 9 | 310 | 20 | ||||
| 151036 | 16447 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
| 160445 | 198636 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015870.56468 | 2108748.55843 | 37.771112857499 | -122.38845720776 | (37.771112857499, -122.38845720776) | 14 | 3 | 9 | 310 | 20 | ||||
| 164111 | 244308 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005570.3518 | 2110556.8538 | 37.7755018326332 | -122.424214672145 | (37.7755018326332, -122.424214672145) | 7 | 9 | 11 | 28852 | 10 | |||
| 166377 | 17927 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2397X Pine St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3X3 | 6002488.0197831 | 2115056.9941341 | 37.7876835609185 | -122.435199131446 | (37.7876835609185, -122.435199131446) | 13 | 9 | 11 | 29490 | 27 | |||
| 167868 | 244363 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005533.5243 | 2110362.3292 | 37.7749656357807 | -122.424328228908 | (37.7749656357807, -122.424328228908) | 7 | 9 | 11 | 28852 | 10 | |||
| 180993 | 198621 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015788.57088 | 2108619.95844 | 37.7707552061109 | -122.388731850804 | (37.7707552061109, -122.388731850804) | 14 | 3 | 9 | 310 | 20 | ||||
| 182645 | 198572 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6014810.33886 | 2114095.2184 | 37.7857347736954 | -122.392498644996 | (37.7857347736954, -122.392498644996) | 6 | 2 | 9 | 28855 | 6 |
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) );