trees
45 rows where SiteOrder = 8 and qSpecies_id = 31
This data as json, CSV (advanced)
These facets timed out: SiteOrder
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3417 | 119788 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 8 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 14201 | 138412 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2445 PINE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002175.9998 | 2115015.7118 | 37.7875524868912 | -122.436275703068 | (37.7875524868912, -122.436275703068) | 13 | 6 | 11 | 29490 | 27 | |||
| 16748 | 96876 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2100X San Jose Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | 9 | 7 | 6 | 28861 | 25 | |||||
| 17081 | 17955 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2475 Pine St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002112.5991001 | 2115004.8317446 | 37.7875190105667 | -122.436494277471 | (37.7875190105667, -122.436494277471) | 13 | 6 | 11 | 29490 | 27 | |||
| 24722 | 244306 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6005576.9618 | 2110512.9441 | 37.7753816404734 | -122.42418868303 | (37.7753816404734, -122.42418868303) | 7 | 9 | 11 | 28852 | 10 | |||
| 28371 | 108235 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131 RUSS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010302 | 2111707 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | 14 | 2 | 9 | 28853 | 34 | ||||
| 29420 | 244397 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005625.7095 | 2110167.0444 | 37.7744346360097 | -122.423995450078 | (37.7744346360097, -122.423995450078) | 7 | 9 | 11 | 28852 | 10 | |||
| 31707 | 242484 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2675 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008307.71975 | 2102954.44615 | 37.7547815657263 | -122.414207437417 | (37.7547815657263, -122.414207437417) | 2 | 4 | 7 | 28859 | 19 | |||
| 31708 | 198480 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015199.5579 | 2104656.07032 | 37.7598385696177 | -122.390492258425 | (37.7598385696177, -122.390492258425) | 10 | 3 | 8 | 28856 | 29 | |||
| 33483 | 119753 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 40459 | 97839 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 40639 | 251525 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 173 Sanchez St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | 7 | 9 | 5 | 28862 | 3 | ||||
| 43824 | 246542 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 8 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 6005675.49099 | 2109463.50167 | 37.772505687922 | -122.42377321126 | (37.772505687922, -122.42377321126) | 7 | 9 | 11 | 28852 | 10 | |||
| 49492 | 17925 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2397X Pine St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002488.0197831 | 2115056.9941341 | 37.7876835609185 | -122.435199131446 | (37.7876835609185, -122.435199131446) | 13 | 9 | 11 | 29490 | 27 | |||
| 65142 | 136958 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2900 Divisadero St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000568.04629 | 2118355.71273 | 37.7966317645105 | -122.442078724458 | (37.7966317645105, -122.442078724458) | 13 | 9 | 1 | 57 | 17 | |||
| 72628 | 244361 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005527.8586 | 2110404.3503 | 37.7750806956038 | -122.424350817202 | (37.7750806956038, -122.424350817202) | 7 | 9 | 11 | 28852 | 10 | |||
| 77972 | 119824 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 8 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 79512 | 198570 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014790.57868 | 2114116.0189 | 37.7857907897446 | -122.392568465686 | (37.7857907897446, -122.392568465686) | 6 | 2 | 9 | 28855 | 6 | |||
| 84842 | 244328 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005669.917 | 2109835.444 | 37.7735266371926 | -122.423818944241 | (37.7735266371926, -122.423818944241) | 7 | 9 | 11 | 28852 | 10 | |||
| 87834 | 198619 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015825.0595 | 2108624.79715 | 37.770770514383 | -122.388605972695 | (37.770770514383, -122.388605972695) | 14 | 3 | 9 | 310 | 20 | ||||
| 95343 | 198500 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1215 Michigan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6016504.90448 | 2102523.10402 | 37.754054221042 | -122.385828988529 | (37.754054221042, -122.385828988529) | 10 | 3 | 8 | 28856 | 29 | |||
| 106875 | 198634 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015830.83594 | 2108747.07967 | 37.7711065955099 | -122.38859452884 | (37.7711065955099, -122.38859452884) | 14 | 3 | 9 | 310 | 20 | ||||
| 119302 | 16425 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016278.230833 | 2094877.189867 | 37.7330475611009 | -122.386079920066 | (37.7330475611009, -122.386079920066) | 10 | 3 | 8 | 58 | 1 | |||
| 122715 | 244283 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005579.1186 | 2110077.6816 | 37.7741866368779 | -122.424150260413 | (37.7741866368779, -122.424150260413) | 7 | 9 | 11 | 28852 | 10 | |||
| 123476 | 119800 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 124048 | 246554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 8 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 6005723.73891 | 2109547.7321 | 37.7727396879137 | -122.423612306376 | (37.7727396879137, -122.423612306376) | 7 | 9 | 11 | 28852 | 10 | |||
| 124440 | 7588 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3000X Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.413820936867 | (37.7492862752884, -122.413820936867) | 2 | 4 | 7 | 28859 | 19 | |||
| 127492 | 17584 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003740.32149 | 2090358.06458 | 37.7199371612464 | -122.429104673852 | (37.7199371612464, -122.429104673852) | 9 | 7 | 6 | 28861 | 5 | |||
| 128696 | 141783 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1439 Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003973.4218 | 2113184.0589 | 37.7826251887217 | -122.42992627789 | (37.7826251887217, -122.42992627789) | 7 | 9 | 11 | 29490 | 41 | |||
| 129352 | 198649 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6016285.57372 | 2108771.35591 | 37.7711984432851 | -122.387023254046 | (37.7711984432851, -122.387023254046) | 14 | 3 | 9 | 310 | 20 | ||||
| 143654 | 198580 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6014742.64135 | 2114209.62608 | 37.7860451513037 | -122.392740867522 | (37.7860451513037, -122.392740867522) | 6 | 2 | 9 | 28855 | 6 | |||
| 145343 | 198489 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015206.91645 | 2104475.31213 | 37.7593426546662 | -122.390454178415 | (37.7593426546662, -122.390454178415) | 10 | 3 | 8 | 28856 | 29 | |||
| 145347 | 244456 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005624.3552 | 2109760.7639 | 37.7733190115017 | -122.423971237778 | (37.7733190115017, -122.423971237778) | 7 | 9 | 11 | 28852 | 10 | |||
| 150836 | 119682 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 8 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
| 155428 | 198656 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6014014.86759 | 2107324.11249 | 37.7670986373305 | -122.394776403817 | (37.7670986373305, -122.394776403817) | 14 | 3 | 9 | 310 | 20 | |||
| 158337 | 198682 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010265.52536 | 2111657.00033 | 37.7787865665763 | -122.408050470058 | (37.7787865665763, -122.408050470058) | 14 | 2 | 9 | 28853 | 34 | |||
| 161548 | 109167 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 8 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
| 162006 | 254723 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 900 16th St | 8 | 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 | ||
| 166195 | 198588 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013599.81261 | 2107136.62549 | 37.766560753709 | -122.396198884879 | (37.766560753709, -122.396198884879) | 14 | 3 | 8 | 28856 | 20 | |
| 173101 | 201913 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 8 | : | Tree | Private 2 | 5 | Width 3ft | 6013833.24742 | 2093196.526 | 37.7282971789522 | -122.394415299033 | (37.7282971789522, -122.394415299033) | 10 | 3 | 8 | 58 | 1 | |||
| 182982 | 198440 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015476.91332 | 2106290.58138 | 37.7643419670439 | -122.389647173584 | (37.7643419670439, -122.389647173584) | 14 | 3 | 9 | 310 | 29 | |||
| 184946 | 141761 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003925.4266 | 2113468.4989 | 37.7834034717338 | -122.430112618538 | (37.7834034717338, -122.430112618538) | 7 | 9 | 11 | 29490 | 41 | |||
| 186554 | 198608 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6016209.64695 | 2108646.95211 | 37.7708526530593 | -122.387277210877 | (37.7708526530593, -122.387277210877) | 14 | 3 | 9 | 310 | 20 | ||||
| 190991 | 198460 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014862.84066 | 2106274.78772 | 37.7642645317963 | -122.391769991798 | (37.7642645317963, -122.391769991798) | 14 | 3 | 9 | 310 | 29 | |||
| 191729 | 16445 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 8 | 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 |
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) );