trees
13 rows where Zip Codes = 57 and qSpecies_id = 91 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
187275 | 136365 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2624 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6000330.31034 | 2118901.65056 | 37.7981172142989 | -122.442940566381 | (37.7981172142989, -122.442940566381) | 13 | 9 | 1 | 57 | 17 | |||
98928 | 136366 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2323 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001763.72183 | 2119055.52403 | 37.7986213292711 | -122.437991580064 | (37.7986213292711, -122.437991580064) | 13 | 9 | 1 | 57 | 17 | |||
46065 | 136368 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000986.41607 | 2118529.18744 | 37.797131913463 | -122.440643524276 | (37.797131913463, -122.440643524276) | 13 | 9 | 1 | 57 | 17 | |||
107727 | 136369 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6000984.79842 | 2118544.66291 | 37.7971743129098 | -122.440650232318 | (37.7971743129098, -122.440650232318) | 13 | 9 | 1 | 57 | 17 | |||
34897 | 136370 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000983.74683 | 2118556.26599 | 37.7972061120278 | -122.440654703763 | (37.7972061120278, -122.440654703763) | 13 | 9 | 1 | 57 | 17 | |||
136874 | 136371 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3518 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002669.28578 | 2120724.92735 | 37.8032565295236 | -122.434977502225 | (37.8032565295236, -122.434977502225) | 13 | 9 | 1 | 57 | 17 | |||
52524 | 136373 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2858 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999883.33678 | 2117451.31751 | 37.7941094908262 | -122.444382936819 | (37.7941094908262, -122.444382936819) | 13 | 9 | 1 | 57 | 27 | |||
61318 | 136374 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2858 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999876.11536 | 2117451.30478 | 37.7941090438496 | -122.444407922699 | (37.7941090438496, -122.444407922699) | 13 | 9 | 1 | 57 | 27 | |||
133494 | 136375 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2880 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5999802.94718 | 2117441.8408 | 37.7940788832989 | -122.44466041095 | (37.7940788832989, -122.44466041095) | 13 | 9 | 1 | 57 | 27 | |||
43385 | 136376 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2880 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 5999781.6675 | 2117438.62155 | 37.7940688297731 | -122.444733809114 | (37.7940688297731, -122.444733809114) | 13 | 9 | 1 | 57 | 27 | |||
31200 | 53044 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2006 12:00:00 AM | 11 | 3x3 | Permit Number 49022 | 6000981.43692 | 2118569.50402 | 37.797242328631 | -122.440663646636 | (37.797242328631, -122.440663646636) | 13 | 9 | 1 | 57 | 17 | |
148920 | 69361 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3518 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 8 | Permit Number 33455 | 6002672.47282 | 2120707.16348 | 37.8032079355658 | -122.4349652022 | (37.8032079355658, -122.4349652022) | 13 | 9 | 1 | 57 | 17 | |
132367 | 69363 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3524 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 12 | Permit Number 33457 | 6002667.84891 | 2120741.39075 | 37.8033016521051 | -122.434983652687 | (37.8033016521051, -122.434983652687) | 13 | 9 | 1 | 57 | 17 |
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) );