trees
28 rows where SiteOrder = 3 and qSpecies_id = 63 sorted by PlantDate
This data as json, CSV (advanced)
qSiteInfo ✖
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12407 | 115154 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 245x ARLINGTON ST | 3 | Median : Yard | Tree | DPW 1 | 3x3 | 6004671 | 2096632 | 37.7372166357496 | -122.426334098447 | (37.7372166357496, -122.426334098447) | 2 | 7 | 5 | 63 | 7 | ||||
| 15787 | 12969 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 99X Lippard Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X4 | 6001957.7757889 | 2095598.483465 | 37.7342250957668 | -122.435641023763 | (37.7342250957668, -122.435641023763) | 2 | 7 | 5 | 63 | 7 | |||
| 22744 | 132175 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100 Chestnut St | 3 | Front Yard : Yard | Tree | Private 2 | 49 | 6006452.3729 | 2120433.08861 | 37.8026692893229 | -122.421865242911 | (37.8026692893229, -122.421865242911) | 5 | 9 | 1 | 28858 | 32 | ||||
| 27135 | 194470 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 84 Whitney Young Cir | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6016764.11928 | 2095038.85548 | 37.7335183423928 | -122.384411315236 | (37.7335183423928, -122.384411315236) | 10 | 3 | 8 | 58 | 1 | ||||
| 38128 | 201734 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015517.44938 | 2087731.03371 | 37.71338348853 | -122.388211611887 | (37.71338348853, -122.388211611887) | 10 | 3 | 8 | 58 | 1 | |||
| 38402 | 194467 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1901 Quint St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6012416.6749 | 2095223.97206 | 37.7337852773717 | -122.399454760738 | (37.7337852773717, -122.399454760738) | 10 | 3 | 8 | 58 | 1 | |||
| 39844 | 185075 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2801 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985040.8539 | 2096108.9226 | 37.7346512389504 | -122.494164969235 | (37.7346512389504, -122.494164969235) | 1 | 8 | 3 | 29491 | 35 | |||
| 41307 | 184977 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2701 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984998.3534 | 2096742.4516 | 37.7363882534207 | -122.494358589298 | (37.7363882534207, -122.494358589298) | 1 | 8 | 3 | 29491 | 35 | |||
| 67798 | 211064 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 300x Miramar Ave | 3 | Median : Yard | Tree | DPW 1 | 35 | 5995363.79151 | 2092232.49572 | 37.7246061670234 | -122.458194844436 | (37.7246061670234, -122.458194844436) | 9 | 7 | 4 | 28861 | 40 | ||||
| 115540 | 23580 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 3100X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 24 | 9 | 6005507.77084 | 2121129.71298 | 37.8045287248816 | -122.425183644115 | (37.8045287248816, -122.425183644115) | 5 | 1 | 1 | 28858 | 32 | |||
| 118486 | 100845 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1 Estero Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
| 138520 | 22454 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 6155X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 40M | 6013523.9988031 | 2091160.9249677 | 37.722690633869 | -122.395341851189 | (37.722690633869, -122.395341851189) | 10 | 3 | 8 | 58 | 1 | |||
| 142542 | 201755 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6015777.13838 | 2087239.45412 | 37.7120480906272 | -122.38727975865 | (37.7120480906272, -122.38727975865) | 10 | 3 | 8 | 58 | 1 | |||
| 142912 | 99486 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 700X Miramar Ave | 3 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | 9 | 7 | 4 | 28861 | 40 | |||
| 144133 | 201751 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 491 Jamestown Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 8ft | 6015871.64119 | 2086992.23012 | 37.7113744939227 | -122.386935895675 | (37.7113744939227, -122.386935895675) | 10 | 3 | 8 | 58 | 1 | |||
| 144960 | 16370 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1400X Montgomery St | 3 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | 3 | 1 | 10 | 308 | 23 | |||
| 145613 | 211069 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 3 | Median : Yard | Tree | DPW 1 | 29 | 5995377.19569 | 2093059.06381 | 37.7268764947539 | -122.458208304568 | (37.7268764947539, -122.458208304568) | 9 | 7 | 4 | 28861 | 40 | ||||
| 146172 | 132180 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1302 Columbus Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 6007242.78631 | 2121872.67886 | 37.8066665815484 | -122.419232186229 | (37.8066665815484, -122.419232186229) | 5 | 1 | 1 | 28858 | 32 | ||||
| 148910 | 110143 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1130X PORTOLA DR | 3 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 3x3 | 5994964 | 2098019 | 37.7404715144277 | -122.459995857341 | (37.7404715144277, -122.459995857341) | 1 | 8 | 4 | 59 | 40 | ||||
| 162189 | 184737 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1301 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984694.2473 | 2106265.1087 | 37.7625170568543 | -122.496112336517 | (37.7625170568543, -122.496112336517) | 1 | 8 | 3 | 56 | 35 | |||
| 163088 | 12974 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 84 Lippard Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001901.0890899 | 2095580.5218873 | 37.7341725574726 | -122.435835722721 | (37.7341725574726, -122.435835722721) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | ||||
| 176886 | 117253 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 3 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
| 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 | ||||
| 179563 | 211058 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 447 Lawton St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 3ft | 5992805.57319 | 2104540.3462 | 37.7582530810297 | -122.467933005722 | (37.7582530810297, -122.467933005722) | 1 | 8 | 4 | 56 | 12 | |||
| 188497 | 99458 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 550X Miramar Ave | 3 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995413 | 2092983.7 | 37.7266716211667 | -122.458079078858 | (37.7266716211667, -122.458079078858) | 9 | 7 | 4 | 28861 | 40 | |||
| 192071 | 132173 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 91 Mayfair Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 6ft | 5997717.35609 | 2114490.42899 | 37.7858558611085 | -122.45166373929 | (37.7858558611085, -122.45166373929) | 15 | 6 | 1 | 54 | 31 | |||
| 97489 | 38524 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 3031 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/1998 12:00:00 AM | 4 | Permit Number 40508 | 6001948.5977 | 2118592.4425 | 37.7973603403586 | -122.437318675826 | (37.7973603403586, -122.437318675826) | 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) );