trees
49 rows where SiteOrder = 7 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 206 | 119799 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 4133 | 138411 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2445 PINE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002152.1984 | 2115012.2116 | 37.7875415238713 | -122.436357800436 | (37.7875415238713, -122.436357800436) | 13 | 6 | 11 | 29490 | 27 | |||
| 13324 | 119752 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 23988 | 198459 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014889.29769 | 2106275.30651 | 37.7642674249283 | -122.391678519967 | (37.7642674249283, -122.391678519967) | 14 | 3 | 9 | 310 | 29 | |||
| 26267 | 198618 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015853.85549 | 2108626.75005 | 37.770777472425 | -122.388506502268 | (37.770777472425, -122.388506502268) | 14 | 3 | 9 | 310 | 20 | ||||
| 27340 | 242558 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2355 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008208.12172 | 2104777.36989 | 37.7597813034931 | -122.414680872925 | (37.7597813034931, -122.414680872925) | 2 | 4 | 7 | 28859 | 19 | |||
| 29914 | 198681 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010294.84433 | 2111624.83118 | 37.7786998791448 | -122.407946774624 | (37.7786998791448, -122.407946774624) | 14 | 2 | 9 | 28853 | 34 | |||
| 31486 | 244396 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005626.4733 | 2110143.3671 | 37.7743696669954 | -122.423991123858 | (37.7743696669954, -122.423991123858) | 7 | 9 | 11 | 28852 | 10 | |||
| 34182 | 198607 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6016227.74089 | 2108648.22285 | 37.7708571442621 | -122.387214711603 | (37.7708571442621, -122.387214711603) | 14 | 3 | 9 | 310 | 20 | ||||
| 45367 | 119681 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 7 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
| 46034 | 109168 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 7 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
| 54691 | 198499 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1215 Michigan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016506.22051 | 2102490.10595 | 37.7539636880787 | -122.38582213748 | (37.7539636880787, -122.38582213748) | 10 | 3 | 8 | 28856 | 29 | |||
| 59194 | 198587 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013654.04555 | 2107139.63113 | 37.7665720240075 | -122.396011512024 | (37.7665720240075, -122.396011512024) | 14 | 3 | 8 | 28856 | 20 | |
| 62432 | 201912 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 7 | : | Tree | Private 2 | 3 | Width 3ft | 6013819.77778 | 2093207.08272 | 37.7283254167788 | -122.394462603388 | (37.7283254167788, -122.394462603388) | 10 | 3 | 8 | 58 | 1 | |||
| 66137 | 242503 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2618 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008245.42572 | 2102971.97718 | 37.7548262026792 | -122.414424108384 | (37.7548262026792, -122.414424108384) | 2 | 4 | 7 | 28859 | 19 | |||
| 66944 | 198633 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6015806.09479 | 2108744.28476 | 37.7710975501444 | -122.388679914958 | (37.7710975501444, -122.388679914958) | 14 | 3 | 9 | 310 | 20 | ||||
| 70024 | 246553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 7 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6005726.46493 | 2109532.06592 | 37.7726968262309 | -122.423601762727 | (37.7726968262309, -122.423601762727) | 7 | 9 | 11 | 28852 | 10 | |||
| 74565 | 198648 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6016263.67679 | 2108770.7838 | 37.77119565988 | -122.387098957165 | (37.77119565988, -122.387098957165) | 14 | 3 | 9 | 310 | 20 | ||||
| 74767 | 141782 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1441 Ellis St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003950.7038 | 2113181.9456 | 37.7826180995506 | -122.430004721615 | (37.7826180995506, -122.430004721615) | 7 | 9 | 11 | 29490 | 41 | |||
| 75473 | 244305 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005579.7947 | 2110490.7532 | 37.7753208695982 | -122.424177304818 | (37.7753208695982, -122.424177304818) | 7 | 9 | 11 | 28852 | 10 | |||
| 78440 | 17954 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2475 Pine St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002112.5991001 | 2115004.8317446 | 37.7875190105667 | -122.436494277471 | (37.7875190105667, -122.436494277471) | 13 | 6 | 11 | 29490 | 27 | |||
| 89346 | 198579 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6014752.73718 | 2114197.75689 | 37.7860131219458 | -122.392705107773 | (37.7860131219458, -122.392705107773) | 6 | 2 | 9 | 28855 | 6 | |||
| 91285 | 180538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Wayland St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010266.12531 | 2092269.81 | 37.7255536693496 | -122.406681772069 | (37.7255536693496, -122.406681772069) | 10 | 3 | 7 | 309 | 28 | |||
| 93167 | 91037 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010705.7086 | 2111246.6708 | 37.7776845332645 | -122.406498774175 | (37.7776845332645, -122.406498774175) | 14 | 2 | 9 | 28853 | 34 | ||
| 100227 | 244327 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005673.3426 | 2109802.5573 | 37.773436531636 | -122.423804755705 | (37.773436531636, -122.423804755705) | 7 | 9 | 11 | 28852 | 10 | |||
| 103899 | 246541 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 7 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005680.0153 | 2109440.15852 | 37.7724418486558 | -122.423755901126 | (37.7724418486558, -122.423755901126) | 7 | 9 | 11 | 28852 | 10 | |||
| 109613 | 198479 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015200.24285 | 2104674.66991 | 37.759889678091 | -122.390491189139 | (37.759889678091, -122.390491189139) | 10 | 3 | 8 | 28856 | 29 | |||
| 109695 | 198488 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6015206.153 | 2104497.93944 | 37.75940474205 | -122.390458399858 | (37.75940474205, -122.390458399858) | 10 | 3 | 8 | 28856 | 29 | |||
| 119811 | 16424 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016384.44159 | 2094872.70878 | 37.7330411346315 | -122.385712405803 | (37.7330411346315, -122.385712405803) | 10 | 3 | 8 | 58 | 1 | |||
| 122519 | 137017 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2700 Pacific Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6001093.24038 | 2116921.57925 | 37.79272392512 | -122.440158546893 | (37.79272392512, -122.440158546893) | 13 | 6 | 1 | 29490 | 27 | |||
| 124594 | 198569 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6014782.21142 | 2114125.62722 | 37.7858167073117 | -122.392598086644 | (37.7858167073117, -122.392598086644) | 6 | 2 | 9 | 28855 | 6 | |||
| 125359 | 17583 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6003749.15172 | 2090342.65671 | 37.7198953544779 | -122.429073052804 | (37.7198953544779, -122.429073052804) | 9 | 7 | 6 | 28861 | 5 | |||
| 127051 | 244478 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005577.5911 | 2110096.7762 | 37.7742389797832 | -122.424156902562 | (37.7742389797832, -122.424156902562) | 7 | 9 | 11 | 28852 | 10 | |||
| 131987 | 254722 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 900 16th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x4 | 6013911 | 2107143 | 37.7665955668607 | -122.39512298129 | (37.7665955668607, -122.39512298129) | 14 | 3 | 8 | 28856 | 20 | ||
| 132398 | 198439 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015495.11625 | 2106291.74793 | 37.7643461794683 | -122.389584295684 | (37.7643461794683, -122.389584295684) | 14 | 3 | 9 | 310 | 29 | |||
| 137883 | 31072 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34816 | 6005529.95864507 | 2107274.01239209 | 37.7664856587307 | -122.424120885174 | (37.7664856587307, -122.424120885174) | 8 | 4 | 5 | 28853 | 19 | ||
| 142693 | 244455 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005622.2998 | 2109777.2072 | 37.7733640447919 | -122.423979517231 | (37.7733640447919, -122.423979517231) | 7 | 9 | 11 | 28852 | 10 | |||
| 148133 | 242483 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2675 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008307.6947 | 2102932.59061 | 37.7547215539608 | -122.414205977849 | (37.7547215539608, -122.414205977849) | 2 | 4 | 7 | 28859 | 19 | |||
| 152559 | 97838 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 162776 | 141760 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003934.4308 | 2113424.6033 | 37.7832834553568 | -122.430078335144 | (37.7832834553568, -122.430078335144) | 7 | 9 | 11 | 29490 | 41 | |||
| 163066 | 108234 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131 RUSS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010302 | 2111707 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | 14 | 2 | 9 | 28853 | 34 | ||||
| 166035 | 244360 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005525.0257 | 2110428.4298 | 37.7751466521023 | -122.424362329876 | (37.7751466521023, -122.424362329876) | 7 | 9 | 11 | 28852 | 10 | |||
| 173780 | 119823 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 7 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 178017 | 16444 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | |||
| 178452 | 119834 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 180006 | 32993 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013060.48706 | 2113590.00605 | 37.7842502474912 | -122.398517212115 | (37.7842502474912, -122.398517212115) | 6 | 2 | 9 | 28853 | 6 | |
| 190843 | 119787 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 7 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 191242 | 200601 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6016439.2859 | 2094833.558 | 37.7329366690371 | -122.385520065311 | (37.7329366690371, -122.385520065311) | 10 | 3 | 8 | 58 | 1 | |||
| 192783 | 119714 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 7 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) |
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) );