trees
15 rows where SiteOrder = 9 and qSpecies_id = 93
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16461 | 183905 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5989441.4873 | 2100495.8044 | 37.7469530039163 | -122.479271477973 | (37.7469530039163, -122.479271477973) | 1 | 8 | 3 | 29491 | 35 | |||
50434 | 136424 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6013541.7115 | 2118113.66267 | 37.7966979482953 | -122.397169643672 | (37.7966979482953, -122.397169643672) | 3 | 1 | 10 | 28860 | 6 | |||
55264 | 136396 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3651 Baker St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 5999117.86509 | 2121345.13243 | 37.8047571571746 | -122.447311924407 | (37.8047571571746, -122.447311924407) | 13 | 9 | 1 | 57 | 17 | |||
63152 | 92261 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4545 Anza St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52708 | 5984639.1399 | 2111735.34775 | 37.7775335493935 | -122.496706647933 | (37.7775335493935, -122.496706647933) | 11 | 6 | 2 | 55 | 26 | |
75592 | 118225 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5984452.24227 | 2111581.69085 | 37.7771006996432 | -122.497341833206 | (37.7771006996432, -122.497341833206) | 11 | 6 | 2 | 55 | 26 | |||
80553 | 107848 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 407 09th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6009766.34192 | 2109306.87193 | 37.7723057020722 | -122.409611431441 | (37.7723057020722, -122.409611431441) | 14 | 2 | 9 | 28853 | 34 | |||
98154 | 111034 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 9 | 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 | ||||
105208 | 197514 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | 6009780.84318 | 2109499.43172 | 37.7728352390743 | -122.409574863193 | (37.7728352390743, -122.409574863193) | 14 | 2 | 9 | 28853 | 34 | ||||
126705 | 197568 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6011770.36838 | 2107496.45307 | 37.7674467954558 | -122.402551951223 | (37.7674467954558, -122.402551951223) | 8 | 2 | 8 | 28853 | 20 | |||
143778 | 200679 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6015689.2638 | 2095313.8362 | 37.7342138898064 | -122.388146614226 | (37.7342138898064, -122.388146614226) | 10 | 3 | 8 | 58 | 1 | |||
155471 | 113597 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6013588.4505 | 2118285.15352 | 37.7971714233818 | -122.397019945211 | (37.7971714233818, -122.397019945211) | 3 | 1 | 10 | 28860 | 6 | |||
159680 | 138406 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002021.2907 | 2114957.6084 | 37.7873841584288 | -122.436806803858 | (37.7873841584288, -122.436806803858) | 13 | 6 | 11 | 29490 | 27 | |||
159824 | 30944 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 9 | 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 | ||
161010 | 141934 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004016.7876 | 2111854.945 | 37.7789782281051 | -122.429681425362 | (37.7789782281051, -122.429681425362) | 7 | 9 | 11 | 29490 | 41 | |||
190254 | 136392 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3395 Sacramento St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5998815.16498 | 2115250.29133 | 37.7880050528274 | -122.447920368844 | (37.7880050528274, -122.447920368844) | 13 | 6 | 1 | 54 | 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) );