trees
17 rows where SiteOrder = 8 and qSpecies_id = 93
This data as json, CSV (advanced)
These facets timed out: SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16930 | 113596 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6013590.96742 | 2118268.55465 | 37.7971259869262 | -122.397010071555 | (37.7971259869262, -122.397010071555) | 3 | 1 | 10 | 28860 | 6 | |||
20754 | 197513 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | 6009803.31754 | 2109510.05508 | 37.7728656676608 | -122.409497871353 | (37.7728656676608, -122.409497871353) | 14 | 2 | 9 | 28853 | 34 | ||||
28780 | 118224 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5984451.82255 | 2111562.02768 | 37.7770466856492 | -122.497341833187 | (37.7770466856492, -122.497341833187) | 11 | 6 | 2 | 55 | 26 | |||
39890 | 197532 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Missouri St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6013605.01625 | 2103874.96409 | 37.757605236407 | -122.395952299753 | (37.757605236407, -122.395952299753) | 10 | 3 | 8 | 28856 | 29 | ||||
51848 | 136423 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6013540.78751 | 2118131.64516 | 37.7967472725126 | -122.397174102497 | (37.7967472725126, -122.397174102497) | 3 | 1 | 10 | 28860 | 6 | |||
64168 | 197567 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6011782.82118 | 2107497.01248 | 37.7674490266805 | -122.402508917767 | (37.7674490266805, -122.402508917767) | 8 | 2 | 8 | 28853 | 20 | |||
101602 | 141908 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004604.7205 | 2111934.4347 | 37.7792297609062 | -122.427653193772 | (37.7792297609062, -122.427653193772) | 7 | 9 | 11 | 29490 | 41 | |||
106354 | 200678 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015671.6762 | 2095312.1874 | 37.7342083880601 | -122.388207305661 | (37.7342083880601, -122.388207305661) | 10 | 3 | 8 | 58 | 1 | |||
110464 | 197550 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6011736.46068 | 2107238.9435 | 37.7667378392138 | -122.402651123063 | (37.7667378392138, -122.402651123063) | 8 | 2 | 8 | 28853 | 20 | |||
112939 | 138405 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002023.3908 | 2114940.8074 | 37.7873381465407 | -122.436798334797 | (37.7873381465407, -122.436798334797) | 13 | 6 | 11 | 29490 | 27 | |||
114432 | 109303 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 RHODE ISLAND ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011759.4 | 2107238.5 | 37.7667379021668 | -122.402571748171 | (37.7667379021668, -122.402571748171) | 8 | 2 | 8 | 28853 | 20 | ||||
123423 | 111033 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | 8 | 2 | 8 | 28853 | 20 | ||||
136691 | 34507 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 18 Lansing St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | 6 | 2 | 9 | 28855 | 6 | |||
139426 | 141933 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004066.711 | 2111861.7308 | 37.7789996869773 | -122.429509204364 | (37.7789996869773, -122.429509204364) | 7 | 9 | 11 | 29490 | 41 | |||
144248 | 30958 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
158148 | 239733 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2002 Castro St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002632.00291 | 2099712.58639 | 37.745559743 | -122.433603933486 | (37.745559743, -122.433603933486) | 2 | 7 | 5 | 63 | 22 | |||
175086 | 9540 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004321.7721316 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | 7 | 9 | 11 | 29490 | 41 |
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) );