trees
22 rows where Supervisor Districts = 10 and qSpecies_id = 65 sorted by qSpecies_id
This data as json, CSV (advanced)
These facets timed out: Supervisor Districts
| 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 | ||||
| 57235 | 125546 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1070 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6007858.97154 | 2118915.83985 | 37.798582528908 | -122.416890128576 | (37.798582528908, -122.416890128576) | 5 | 1 | 10 | 308 | 32 | |||
| 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 | |||
| 145545 | 249373 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 649 Jones St | 1 | : | Tree | Private 2 | 06/22/1998 12:00:00 AM | 21 | Width 4ft | Permit Number 39973 | 6008805.56783 | 2114728.16614 | 37.7871374013058 | -122.4133182966 | (37.7871374013058, -122.4133182966) | 5 | 1 | 10 | 28852 | 36 | |
| 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 | |||
| 156056 | 62982 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1391 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 20 | Permit Number 30047 | 6006920.35815 | 2118393.21581 | 37.7970946941148 | -122.420100923242 | (37.7970946941148, -122.420100923242) | 5 | 1 | 10 | 28858 | 32 | |
| 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) );