trees
19 rows where Neighborhoods (old) = 21 and qSpecies_id = 65
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1841 | 113206 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
23153 | 125554 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Dashiell Hammett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 1ft | 6010380.8435 | 2116036.16558 | 37.7908171708214 | -122.40796043625 | (37.7908171708214, -122.40796043625) | 5 | 1 | 10 | 28857 | 21 | |||
23331 | 125557 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Dashiell Hammett St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 1ft | 6010370.0822 | 2116109.39697 | 37.7910176441083 | -122.40800283658 | (37.7910176441083, -122.40800283658) | 5 | 1 | 10 | 28857 | 21 | |||
26119 | 125558 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 39 Dashiell Hammett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 1ft | 6010359.2219 | 2116035.15877 | 37.7908131958158 | -122.408035175278 | (37.7908131958158, -122.408035175278) | 5 | 1 | 10 | 28857 | 21 | |||
31564 | 113207 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
49622 | 113208 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
57700 | 113210 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
64277 | 37529 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007263.39142 | 2115650.05703 | 37.7895819825607 | -122.418719304647 | (37.7895819825607, -122.418719304647) | 13 | 9 | 10 | 28858 | 21 | |
70877 | 125553 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Dashiell Hammett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 6010381.65829 | 2116025.18682 | 37.7907870714036 | -122.407956842555 | (37.7907870714036, -122.407956842555) | 5 | 1 | 10 | 28857 | 21 | |||
71978 | 37528 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007265.87204 | 2115633.53426 | 37.789536754768 | -122.418709549719 | (37.789536754768, -122.418709549719) | 13 | 9 | 10 | 28858 | 21 | |
73407 | 113205 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
88447 | 113211 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
107607 | 37527 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 19 | Permit Number 39976 | 6007268.1881 | 2115618.13797 | 37.7894946107457 | -122.418700444082 | (37.7894946107457, -122.418700444082) | 13 | 9 | 10 | 28858 | 21 | |
112453 | 113209 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
117746 | 109922 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 20 Dashiell Hammett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010385.90065 | 2115990.02467 | 37.7906907621072 | -122.407939683476 | (37.7906907621072, -122.407939683476) | 5 | 1 | 10 | 28857 | 21 | |||
140770 | 125556 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Dashiell Hammett St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 1ft | 6010373.88988 | 2116082.2243 | 37.7909432476765 | -122.407987745034 | (37.7909432476765, -122.407987745034) | 5 | 1 | 10 | 28857 | 21 | |||
154146 | 40163 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 39201 Dashiell Hammett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Permit Number 41356 | 6010358.38502 | 2116055.23844 | 37.7908682829043 | -122.40803948753 | (37.7908682829043, -122.40803948753) | 5 | 1 | 10 | 28857 | 21 | |||
156364 | 125552 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Dashiell Hammett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 1ft | 6010384.14225 | 2116014.5877 | 37.7907581078366 | -122.407947500375 | (37.7907581078366, -122.407947500375) | 5 | 1 | 10 | 28857 | 21 | |||
182873 | 125555 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Dashiell Hammett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 6010375.3917 | 2116064.19944 | 37.7908938398292 | -122.40798127711 | (37.7908938398292, -122.40798127711) | 5 | 1 | 10 | 28857 | 21 |
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) );