trees
17 rows where PlotSize = "3x3" and qSpecies_id = 68 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1082 | 261856 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 937x Meade Ave | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6012763 | 2089349 | 37.7176730984513 | -122.397845439416 | (37.7176730984513, -122.397845439416) | 10 | 3 | 8 | 58 | 1 | ||||
| 82413 | 29657 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 299X Cashmere St | 1 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3x3 | 6016930.34883 | 2095863.99444 | 37.7357931999838 | -122.383894041377 | (37.7357931999838, -122.383894041377) | 10 | 3 | 8 | 58 | 1 | ||
| 83211 | 93959 | Permitted Site 7 | Prunus spp :: Cherry 68 | 419 Elizabeth St | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 53399 | 6003681 | 2102149 | 37.7523090296265 | -122.430150445418 | (37.7523090296265, -122.430150445418) | 2 | 4 | 5 | 28862 | 22 | ||||
| 121838 | 53181 | Permitted Site 7 | Prunus spp :: Cherry 68 | 2784 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/2006 12:00:00 AM | 3x3 | Permit Number 49099 | 6010077.71172244 | 2102830.43618978 | 37.7545403242811 | -122.408077545352 | (37.7545403242811, -122.408077545352) | 2 | 4 | 7 | 28859 | 19 | |
| 189473 | 121317 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1270 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6007670 | 2102262 | 37.7528444245459 | -122.416363810551 | (37.7528444245459, -122.416363810551) | 2 | 4 | 7 | 28859 | 19 | |||
| 188790 | 93987 | Permitted Site 7 | Prunus spp :: Cherry 68 | 200 Belgrave Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53411 | 5997460.5 | 2104904 | 37.759519290122 | -122.451860552802 | (37.759519290122, -122.451860552802) | 15 | 5 | 11 | 29492 | 12 | |||
| 8120 | 1497 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 325 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 5995534.5488977 | 2114067.6155393 | 37.7845696798314 | -122.45918496627 | (37.7845696798314, -122.45918496627) | 11 | 6 | 2 | 54 | 11 | |||
| 115596 | 39201 | Permitted Site 7 | Prunus spp :: Cherry 68 | 36 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1998 12:00:00 AM | 3x3 | Permit Number 40852 | 5996541.64157093 | 2114326.11365116 | 37.7853372927938 | -122.455719478601 | (37.7853372927938, -122.455719478601) | 11 | 6 | 1 | 54 | 31 | ||
| 168750 | 116071 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 4150X CLEMENT ST | 1 | Front Yard : Yard | Tree | DPW 1 | 8 | 3x3 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | |||
| 6901 | 80867 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 123 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50655 | 6003213.7924 | 2092811.2834 | 37.7266433347113 | -122.431099707385 | (37.7266433347113, -122.431099707385) | 9 | 7 | 6 | 28861 | 5 | |
| 25692 | 53523 | Permitted Site 7 | Prunus spp :: Cherry 68 | 221 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 4 | 3x3 | Permit Number 775251 | 5994812.01878897 | 2088373.36040249 | 37.7139781801866 | -122.459822827247 | (37.7139781801866, -122.459822827247) | 9 | 8 | 6 | 28861 | 24 | |
| 39858 | 84640 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1363 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52752 | 5988634.2057 | 2106032.7782 | 37.7621091296561 | -122.482468596885 | (37.7621091296561, -122.482468596885) | 1 | 8 | 3 | 56 | 35 |
| 142169 | 82056 | Permitted Site 7 | Prunus spp :: Cherry 68 | 447 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2011 12:00:00 AM | 3x3 | Permit Number 767285 | 5993745.17939928 | 2090171.13367763 | 37.7188530246919 | -122.463640596127 | (37.7188530246919, -122.463640596127) | 9 | 8 | 6 | 64 | 24 | ||
| 12237 | 88560 | Permitted Site 7 | Prunus spp :: Cherry 68 | 2901 Pierce St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51505 | 6001501 | 2118350 | 37.7966692015857 | -122.438850093229 | (37.7966692015857, -122.438850093229) | 13 | 9 | 1 | 57 | 17 | |||
| 24517 | 42766 | Permitted Site 7 | Prunus spp :: Cherry 68 | 415 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/2005 12:00:00 AM | 3x3 | Permit Number 48384 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.427511197042 | (37.7737647507648, -122.427511197042) | 7 | 9 | 11 | 28852 | 10 | |
| 110871 | 52194 | Permitted Site 7 | Prunus spp :: Cherry 68 | 415 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2005 12:00:00 AM | 3x3 | Permit Number 48384 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.427511197042 | (37.7737647507648, -122.427511197042) | 7 | 9 | 11 | 28852 | 10 | ||
| 175309 | 88559 | Permitted Site 7 | Prunus spp :: Cherry 68 | 2901 Pierce St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51505 | 6001501 | 2118350 | 37.7966692015857 | -122.438850093229 | (37.7966692015857, -122.438850093229) | 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) );