trees
14 rows where qSpecies_id = 174
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1146 | 6579 | DPW Maintained 1 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 1337 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/24/1998 12:00:00 AM | 3 | 3X3 | 6017048.7081546 | 2097427.5062586 | 37.7400928320588 | -122.383593638958 | (37.7400928320588, -122.383593638958) | 10 | 3 | 8 | 58 | 1 | ||
| 14313 | 261295 | Planning Code 138.1 required 2 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 185 Stonecrest Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/20/2019 12:00:00 AM | 3 | 3x10 | Permit Number 782878 | 5990774.03183 | 2093262.32002 | 37.727169005397 | -122.474135998689 | (37.727169005397, -122.474135998689) | 9 | 8 | 4 | 64 | 40 | |
| 15648 | 260854 | DPW Maintained 1 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 543 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985630.75782 | 2112196.1258 | 37.7788567636192 | -122.493310315227 | (37.7788567636192, -122.493310315227) | 11 | 6 | 2 | 55 | 26 | |||
| 63711 | 82023 | Permitted Site 7 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 455 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2004 12:00:00 AM | Permit Number 50002 | 5982191.84204192 | 2112715.55923715 | 37.780081229053 | -122.505245190233 | (37.780081229053, -122.505245190233) | 11 | 6 | 2 | 55 | 26 | |||
| 68098 | 28536 | Permitted Site 7 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 99 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017489.5110714 | 2095183.8764266 | 37.7339566260964 | -122.381913486724 | (37.7339566260964, -122.381913486724) | 10 | 3 | 8 | 58 | 1 | ||
| 75964 | 6445 | DPW Maintained 1 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 1100X Evans Ave | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/1999 12:00:00 AM | 6 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | ||
| 78769 | 81900 | Permitted Site 7 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 452 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2007 12:00:00 AM | 3x3 | Permit Number 50001 | 5982243.02634358 | 2112739.79928276 | 37.7801507966855 | -122.505069920477 | (37.7801507966855, -122.505069920477) | 11 | 6 | 2 | 55 | 26 | ||
| 85298 | 6593 | Permitted Site 7 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 1375 Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6016853.0670442 | 2097574.0145522 | 37.7404842987312 | -122.384280293448 | (37.7404842987312, -122.384280293448) | 10 | 3 | 8 | 58 | 1 | |||
| 107497 | 6576 | DPW Maintained 1 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 1335 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2004 12:00:00 AM | 3 | 3X3 | 6017058.8977957 | 2097419.8756183 | 37.7400724430592 | -122.383557875901 | (37.7400724430592, -122.383557875901) | 10 | 3 | 8 | 58 | 1 | ||
| 119675 | 27242 | Permitted Site 7 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 1879 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6013552.5455 | 2096525.20884 | 37.7374214500322 | -122.395618827118 | (37.7374214500322, -122.395618827118) | 10 | 3 | 8 | 58 | 1 | |||
| 140921 | 1395 | Permitted Site 7 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 38 Ardath Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 3 | 3X4 | 6017361.4660923 | 2095431.3874092 | 37.734629170302 | -122.382373396386 | (37.734629170302, -122.382373396386) | 10 | 3 | 8 | 58 | 1 | ||
| 143469 | 1411 | DPW Maintained 1 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 86 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/05/2007 12:00:00 AM | 3 | 3X4 | 6017484.2138277 | 2095260.4301389 | 37.7341665349061 | -122.381937124216 | (37.7341665349061, -122.381937124216) | 10 | 3 | 8 | 58 | 1 | ||
| 172770 | 1394 | Permitted Site 7 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 38 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017361.4660923 | 2095431.3874092 | 37.734629170302 | -122.382373396386 | (37.734629170302, -122.382373396386) | 10 | 3 | 8 | 58 | 1 | ||
| 189641 | 1410 | DPW Maintained 1 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 79 Ardath Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017424.8922659 | 2095259.7862555 | 37.7341614907893 | -122.382142174898 | (37.7341614907893, -122.382142174898) | 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) );