trees
33 rows where Neighborhoods (old) = 29 and qSpecies_id = 63 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29047 | 194457 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2001 25th St | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 6012708.71911 | 2101842.22219 | 37.7519738634013 | -122.398909414543 | (37.7519738634013, -122.398909414543) | 10 | 3 | 8 | 28856 | 29 | ||||
| 132354 | 194460 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 6012680.82829 | 2101890.2153 | 37.7521040879384 | -122.399009233909 | (37.7521040879384, -122.399009233909) | 10 | 3 | 8 | 28856 | 29 | ||||
| 163675 | 194461 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6012563.25713 | 2101880.94422 | 37.7520720792617 | -122.399415164477 | (37.7520720792617, -122.399415164477) | 10 | 3 | 8 | 28856 | 29 | ||||
| 161957 | 194462 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 6012536.20636 | 2101883.40971 | 37.7520773412124 | -122.399508883748 | (37.7520773412124, -122.399508883748) | 10 | 3 | 8 | 28856 | 29 | ||||
| 172636 | 194463 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6012509.33056 | 2101878.68569 | 37.7520628720051 | -122.399601493222 | (37.7520628720051, -122.399601493222) | 10 | 3 | 8 | 28856 | 29 | ||||
| 79719 | 194464 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 6012478.49596 | 2101876.43729 | 37.7520549795584 | -122.399707966672 | (37.7520549795584, -122.399707966672) | 10 | 3 | 8 | 28856 | 29 | ||||
| 34697 | 194442 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x Carolina St | 51 | Median : Yard | Tree | DPW 1 | 24 | 6012500.2858 | 2102979.92319 | 37.7550861265451 | -122.399710087265 | (37.7550861265451, -122.399710087265) | 10 | 3 | 8 | 28856 | 29 | ||||
| 170052 | 194441 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x Carolina St | 39 | Median : Yard | Tree | DPW 1 | 18 | 6012501.46554 | 2103105.94469 | 37.7554322198433 | -122.399714855461 | (37.7554322198433, -122.399714855461) | 10 | 3 | 8 | 28856 | 29 | ||||
| 95523 | 194440 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x Carolina St | 33 | Median : Yard | Tree | DPW 1 | 6 | 6012485.2688 | 2103286.14111 | 37.7559260969364 | -122.399783521388 | (37.7559260969364, -122.399783521388) | 10 | 3 | 8 | 28856 | 29 | ||||
| 17195 | 194439 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x Carolina St | 32 | Median : Yard | Tree | DPW 1 | 12 | 6012481.17054 | 2103301.60211 | 37.7559683209947 | -122.3997987802 | (37.7559683209947, -122.3997987802) | 10 | 3 | 8 | 28856 | 29 | ||||
| 148743 | 194465 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | 6012451.33342 | 2101881.30035 | 37.7520668182527 | -122.399802240798 | (37.7520668182527, -122.399802240798) | 10 | 3 | 8 | 28856 | 29 | ||||
| 131381 | 194466 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 6012435.9357 | 2101881.1338 | 37.7520655025415 | -122.399855477046 | (37.7520655025415, -122.399855477046) | 10 | 3 | 8 | 28856 | 29 | ||||
| 105080 | 173727 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 958 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6012430 | 2103470 | 37.7564278519739 | -122.399987571177 | (37.7564278519739, -122.399987571177) | 10 | 3 | 8 | 28856 | 29 | |||
| 40232 | 194448 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 32 | Median : Yard | Tree | DPW 1 | 27 | 6012284.461 | 2102001.80848 | 37.7523884032163 | -122.400387777686 | (37.7523884032163, -122.400387777686) | 10 | 3 | 8 | 28856 | 29 | ||||
| 109147 | 194450 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 21 | Median : Yard | Tree | DPW 1 | 27 | 6012266.91736 | 2102141.9772 | 37.7527722977062 | -122.40045829173 | (37.7527722977062, -122.40045829173) | 10 | 3 | 8 | 28856 | 29 | ||||
| 10043 | 264733 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1367 De Haro St | Median : Cutout | Tree | DPW 1 | 3x3 | 6012260 | 2102130 | 37.7527390251575 | -122.400481372119 | (37.7527390251575, -122.400481372119) | 10 | 3 | 8 | 28856 | 29 | |||||
| 37115 | 194449 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 23 | Median : Yard | Tree | DPW 1 | 23 | 6012259.688 | 2102130.23115 | 37.7527396424455 | -122.400482467314 | (37.7527396424455, -122.400482467314) | 10 | 3 | 8 | 28856 | 29 | ||||
| 8023 | 121696 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012218 | 2102254 | 37.7530771598286 | -122.400635326689 | (37.7530771598286, -122.400635326689) | 10 | 3 | 8 | 28856 | 29 | ||||
| 140522 | 121695 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012218 | 2102254 | 37.7530771598286 | -122.400635326689 | (37.7530771598286, -122.400635326689) | 10 | 3 | 8 | 28856 | 29 | ||||
| 179258 | 121697 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012218 | 2102254 | 37.7530771598286 | -122.400635326689 | (37.7530771598286, -122.400635326689) | 10 | 3 | 8 | 28856 | 29 | ||||
| 133881 | 194454 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1301 Rhode Island St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6012013.85217 | 2102295.56099 | 37.753179889343 | -122.40134423455 | (37.753179889343, -122.40134423455) | 10 | 3 | 8 | 28856 | 29 | |||
| 120848 | 194447 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 680 De Haro St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6012074.20817 | 2105270.47212 | 37.761351707727 | -122.401344555627 | (37.761351707727, -122.401344555627) | 10 | 3 | 8 | 28856 | 29 | ||||
| 78908 | 194452 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2001 20th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6011998.43391 | 2104639.55141 | 37.7596151114626 | -122.401562284167 | (37.7596151114626, -122.401562284167) | 10 | 3 | 8 | 28856 | 29 | |||
| 43289 | 194453 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2250 26th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6011877.75436 | 2101392.1938 | 37.750691845665 | -122.401751398122 | (37.750691845665, -122.401751398122) | 10 | 3 | 8 | 28856 | 29 | ||||
| 37367 | 194451 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 930 Kansas St | 1 | Front Yard : Yard | Tree | Private 2 | 29 | 6011573.12502 | 2104017.28324 | 37.7578827599862 | -122.402989455212 | (37.7578827599862, -122.402989455212) | 10 | 3 | 8 | 28856 | 29 |
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) );