trees
17 rows where qSpecies_id = 211
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2018 | 106877 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 3200X Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2014 12:00:00 AM | 12 | 3x3 | Permit Number 772880 | 5999315.59969 | 2115694.92297 | 37.7892544863522 | -122.446220956829 | (37.7892544863522, -122.446220956829) | 13 | 6 | 1 | 29490 | 31 | |
| 9106 | 197474 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 1700x Quesada Ave | 47 | Median : Yard | Tree | DPW 1 | 9 | 6014305.55494 | 2095325.16284 | 37.7341682275767 | -122.392931365507 | (37.7341682275767, -122.392931365507) | 10 | 3 | 8 | 58 | 1 | ||||
| 52856 | 214150 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 19 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6000833.08786 | 2094320.24642 | 37.730651407126 | -122.439437822113 | (37.730651407126, -122.439437822113) | 9 | 7 | 4 | 63 | 40 | |||
| 53259 | 239562 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 737 Sanchez St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6003703.284 | 2103987.00302 | 37.7573570136436 | -122.430204497936 | (37.7573570136436, -122.430204497936) | 2 | 4 | 5 | 28862 | 3 | |||
| 72359 | 18984 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 2924 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000584.25503 | 2115541.8727 | 37.7889066204895 | -122.441820584857 | (37.7889066204895, -122.441820584857) | 13 | 6 | 1 | 29490 | 27 | |||
| 86318 | 110526 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 21311 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2015 12:00:00 AM | 2 | 4x4 | Permit Number 775214 | 6001840.45625 | 2115879.31101 | 37.7899046377311 | -122.437498481788 | (37.7899046377311, -122.437498481788) | 13 | 6 | 1 | 29490 | 27 | |
| 90842 | 239561 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 3637 22nd St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6004045.51841 | 2103028.99771 | 37.7547459354811 | -122.428952616494 | (37.7547459354811, -122.428952616494) | 2 | 4 | 5 | 28862 | 22 | |||
| 92352 | 214149 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 193 Del Sur Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5996242.3628 | 2098535.08925 | 37.7419620096322 | -122.455613098571 | (37.7419620096322, -122.455613098571) | 9 | 7 | 4 | 59 | 40 | |||
| 96220 | 32448 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 4302 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 7 | Permit Number 36967 | 6000728.25925 | 2105820.59303 | 37.7622226489821 | -122.440624795915 | (37.7622226489821, -122.440624795915) | 15 | 5 | 5 | 28862 | 3 | |
| 98044 | 214148 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 1200 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994560.23843 | 2107256.02071 | 37.7658107892659 | -122.46206158749 | (37.7658107892659, -122.46206158749) | 15 | 5 | 11 | 56 | 12 | |||
| 116506 | 30879 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 887 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | 9 | Permit Number 34712 | 6003127.60698 | 2103199.82394 | 37.7551629843999 | -122.43213920137 | (37.7551629843999, -122.43213920137) | 2 | 4 | 5 | 28862 | 22 | ||
| 120046 | 239560 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 960 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003105.56892 | 2102623.67498 | 37.7535797666026 | -122.432174272218 | (37.7535797666026, -122.432174272218) | 2 | 4 | 5 | 28862 | 22 | |||
| 151989 | 247637 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 360 Bradford St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6009458.82615 | 2096582.35495 | 37.7373497969565 | -122.409776819464 | (37.7373497969565, -122.409776819464) | 10 | 7 | 7 | 28859 | 2 | ||||
| 159698 | 63041 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 446 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/1986 12:00:00 AM | 6 | Permit Number 23511 | 5983797.44561 | 2112800.44683 | 37.7804086504058 | -122.4996970443 | (37.7804086504058, -122.4996970443) | 11 | 6 | 2 | 55 | 26 | ||
| 164152 | 239559 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 850 Castro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6002419.24951 | 2103265.93732 | 37.7553043290595 | -122.434593632903 | (37.7553043290595, -122.434593632903) | 2 | 4 | 5 | 28862 | 22 | |||
| 174159 | 136363 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 3258 Lyon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5999008.91731 | 2120036.67955 | 37.8011582735832 | -122.447594701857 | (37.8011582735832, -122.447594701857) | 13 | 9 | 1 | 57 | 17 | ||||
| 190590 | 106876 | DPW Maintained 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 211 | 3200X Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2014 12:00:00 AM | 21 | 3x3 | Permit Number 772880 | 5999360.60795 | 2115700.24146 | 37.7892716598179 | -122.446065616935 | (37.7892716598179, -122.446065616935) | 13 | 6 | 1 | 29490 | 31 |
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) );