trees
119 rows where SiteOrder = 4 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
163797 | 198485 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015200.26669 | 2104562.53753 | 37.7595817879946 | -122.3904832715 | (37.7595817879946, -122.3904832715) | 10 | 3 | 8 | 28856 | 29 | |||
164216 | 98273 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.408584359698 | (37.7562208239384, -122.408584359698) | 2 | 4 | 7 | 28859 | 19 | |
170637 | 141787 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1461 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003867.7567 | 2113170.8508 | 37.7825829380566 | -122.430290891107 | (37.7825829380566, -122.430290891107) | 7 | 9 | 11 | 29490 | 41 | |||
172477 | 198615 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015921.38849 | 2108631.46904 | 37.7707941719296 | -122.388273231625 | (37.7707941719296, -122.388273231625) | 14 | 3 | 9 | 310 | 20 | ||||
173965 | 137008 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2110 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6000406.08095 | 2115938.23713 | 37.7899847799168 | -122.44246550939 | (37.7899847799168, -122.44246550939) | 13 | 6 | 1 | 29490 | 27 | |||
174939 | 198566 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6014751.35168 | 2114157.00483 | 37.785901149169 | -122.392707049386 | (37.785901149169, -122.392707049386) | 6 | 2 | 9 | 28855 | 6 | |||
176701 | 11878 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1501X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | 9 | 8 | 4 | 64 | 24 | |||
177447 | 31075 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 7 | Permit Number 34816 | 6005979.98097 | 2107292.47987 | 37.7665617645507 | -122.422565649286 | (37.7665617645507, -122.422565649286) | 8 | 4 | 5 | 28853 | 19 | |
178759 | 198685 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009031.35533 | 2110985.92555 | 37.7768747760941 | -122.412272520887 | (37.7768747760941, -122.412272520887) | 8 | 2 | 9 | 28853 | 34 | |||
180678 | 119831 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
181698 | 198507 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 701 Rhode Island St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6011858.82974 | 2105091.40426 | 37.7608480082603 | -122.402076874465 | (37.7608480082603, -122.402076874465) | 10 | 3 | 8 | 28856 | 29 | |||
184046 | 46506 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 165 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.412275670972 | (37.7768559207247, -122.412275670972) | 8 | 2 | 9 | 28853 | 34 | |||
187128 | 23644 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 197 Virginia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2005 12:00:00 AM | 8 | 3X3 | 6006643.75963 | 2098486.48829 | 37.7424199625796 | -122.41964489142 | (37.7424199625796, -122.41964489142) | 2 | 7 | 7 | 28859 | 2 | ||
188233 | 109165 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 4 | Median : Cutout | Tree | DPW 1 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | ||||
188402 | 180550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002268.14618 | 2091228.59703 | 37.7222440023296 | -122.434255671279 | (37.7222440023296, -122.434255671279) | 9 | 7 | 6 | 28861 | 5 | |||
189071 | 97835 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
189386 | 137009 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3099 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999994.90207 | 2116065.86366 | 37.7903117635268 | -122.443897321805 | (37.7903117635268, -122.443897321805) | 13 | 6 | 1 | 29490 | 27 | |||
189918 | 31036 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300 Bennington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2015 12:00:00 AM | 2 | Permit Number 771782 | 6007053.24421 | 2096706.03657 | 37.7375542956049 | -122.418102817609 | (37.7375542956049, -122.418102817609) | 2 | 7 | 7 | 28859 | 2 | ||
190593 | 244374 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005614.0781 | 2109847.0914 | 37.7735554657504 | -122.424012927889 | (37.7735554657504, -122.424012927889) | 7 | 9 | 11 | 28852 | 10 |
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) );