trees
12 rows where qCaretaker_id = 1 and qSpecies_id = 39 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26357 | 91026 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 722 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6007490.257402 | 2105446.273959 | 37.7615776005454 | -122.417211018518 | (37.7615776005454, -122.417211018518) | 2 | 4 | 7 | 28859 | 19 | ||
28633 | 91022 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 140 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6007266.813002 | 2109001.353693 | 37.7713264423251 | -122.418235884317 | (37.7713264423251, -122.418235884317) | 8 | 2 | 9 | 28853 | 19 | ||
43599 | 91027 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 722 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6007490.257402 | 2105446.273959 | 37.7615776005454 | -122.417211018518 | (37.7615776005454, -122.417211018518) | 2 | 4 | 7 | 28859 | 19 | ||
66871 | 239150 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 100 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 4ft | 6005732.39027 | 2109686.64828 | 37.7731216065951 | -122.4235922587 | (37.7731216065951, -122.4235922587) | 7 | 9 | 11 | 28852 | 10 | |||
84045 | 22308 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 5033 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2000 12:00:00 AM | 3 | 3x3 | 6014806.84876 | 2094754.47288 | 37.7326290611665 | -122.391158343086 | (37.7326290611665, -122.391158343086) | 10 | 3 | 8 | 58 | 1 | ||
89986 | 173654 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 118 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010152 | 2112318 | 37.7805951592946 | -122.408489839314 | (37.7805951592946, -122.408489839314) | 14 | 2 | 9 | 28853 | 34 | ||||
103835 | 10244 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 99X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2000 12:00:00 AM | 6 | 3X3 | 6005773.33687 | 2109613.89968 | 37.7729241676403 | -122.42344544616 | (37.7729241676403, -122.42344544616) | 7 | 9 | 11 | 28852 | 10 | ||
134355 | 22306 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 5015 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6014803.86419 | 2094824.41992 | 37.7328209559263 | -122.39117354906 | (37.7328209559263, -122.39117354906) | 10 | 3 | 8 | 58 | 1 | |||
142837 | 91029 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 967 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 5 | 3x3 | 6007608.48742 | 2104034.949256 | 37.7577090789947 | -122.416702122814 | (37.7577090789947, -122.416702122814) | 2 | 4 | 7 | 28859 | 19 | ||
146320 | 91028 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 722 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6007490.257402 | 2105446.273959 | 37.7615776005454 | -122.417211018518 | (37.7615776005454, -122.417211018518) | 2 | 4 | 7 | 28859 | 19 | ||
156139 | 95060 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 5033 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6014806.53085 | 2094754.47288 | 37.7326290435242 | -122.391159442188 | (37.7326290435242, -122.391159442188) | 10 | 3 | 8 | 58 | 1 | |||
168668 | 22304 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 5012X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6014702.6472 | 2094891.22359 | 37.7329987676998 | -122.391528153423 | (37.7329987676998, -122.391528153423) | 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) );