trees
33 rows where PlotSize = "" and qSpecies_id = 136
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1139 | 189986 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 2001 Revere Ave | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6012583.96536 | 2096233.71501 | 37.7365671439547 | -122.398947230147 | (37.7365671439547, -122.398947230147) | 10 | 3 | 8 | 58 | 1 | ||||
| 9812 | 225131 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 2 Mirabel Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6007282.16876 | 2099771.17309 | 37.7459833605478 | -122.417528488069 | (37.7459833605478, -122.417528488069) | 2 | 7 | 7 | 28859 | 2 | ||||
| 15551 | 189991 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 1427x Innes Ave | 18 | Median : Yard | Tree | DPW 1 | 20 | 6016204.83732 | 2096710.6252 | 37.7380777432808 | -122.386461454743 | (37.7380777432808, -122.386461454743) | 10 | 3 | 8 | 58 | 1 | ||||
| 17898 | 62498 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 35 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1986 12:00:00 AM | 1 | Permit Number 22670 | 6000912.98222 | 2092877.24517 | 37.7266938037715 | -122.439058237157 | (37.7266938037715, -122.439058237157) | 9 | 7 | 6 | 28861 | 25 | |
| 25794 | 53216 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 828 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1956 12:00:00 AM | 1 | Permit Number 41 | 6013034.72184 | 2103183.73982 | 37.7556755404181 | -122.397876136701 | (37.7556755404181, -122.397876136701) | 10 | 3 | 8 | 28856 | 29 | ||
| 31238 | 247887 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 360 Mayflower St | 2 | Side Yard : Yard | Tree | Private 2 | 3 | 6009991.26305 | 2098380.13852 | 37.7423159459174 | -122.408062678348 | (37.7423159459174, -122.408062678348) | 10 | 7 | 7 | 28859 | 2 | ||||
| 34202 | 189990 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 1427x Innes Ave | 16 | Median : Yard | Tree | DPW 1 | 17 | 6016227.39671 | 2096690.18473 | 37.7380228666701 | -122.386382030231 | (37.7380228666701, -122.386382030231) | 10 | 3 | 8 | 58 | 1 | ||||
| 34203 | 120900 | Undocumented 4 | Cercis occidentalis :: Western Redbud 136 | 250 States St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6000595 | 2106681 | 37.7645775245529 | -122.441147421326 | (37.7645775245529, -122.441147421326) | 15 | 5 | 5 | 28862 | 3 | ||||
| 42054 | 50640 | Permitted Site 7 | Cercis occidentalis :: Western Redbud 136 | 2700 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2003 12:00:00 AM | Permit Number 47227 | 6008685.113393 | 2106855.73545108 | 37.7655148056516 | -122.41317815543 | (37.7655148056516, -122.41317815543) | 8 | 4 | 7 | 28853 | 19 | ||
| 43048 | 98285 | Section 143 10 | Cercis occidentalis :: Western Redbud 136 | 300 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
| 54018 | 98287 | Section 143 10 | Cercis occidentalis :: Western Redbud 136 | 300 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
| 54581 | 98286 | Section 143 10 | Cercis occidentalis :: Western Redbud 136 | 300 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
| 59141 | 189979 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 2001 Revere Ave | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6012352.1202 | 2096398.07339 | 37.7370055157936 | -122.399760360254 | (37.7370055157936, -122.399760360254) | 10 | 3 | 8 | 58 | 1 | ||||
| 83972 | 225132 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 1201 San Jose Ave | 19 | Front Yard : Yard | Tree | Private 2 | 1 | 6004294.72641 | 2095912.63929 | 37.7352201573845 | -122.427583813236 | (37.7352201573845, -122.427583813236) | 2 | 7 | 5 | 28861 | 2 | ||||
| 95143 | 247889 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 360 Mayflower St | 4 | Side Yard : Yard | Tree | Private 2 | 4 | 6010002.07047 | 2098377.09452 | 37.7423081928588 | -122.408025094795 | (37.7423081928588, -122.408025094795) | 10 | 7 | 7 | 28859 | 2 | ||||
| 106783 | 31570 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 257 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 1 | Permit Number 35110 | 5996974.3553 | 2112656.5835 | 37.7807780278075 | -122.454101804264 | (37.7807780278075, -122.454101804264) | 11 | 6 | 2 | 54 | 16 | |
| 107249 | 122377 | Undocumented 4 | Cercis occidentalis :: Western Redbud 136 | 195x Ogden Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6007788 | 2096166 | 37.7361128018191 | -122.415524188543 | (37.7361128018191, -122.415524188543) | 2 | 7 | 7 | 28859 | 2 | |||||
| 113005 | 225133 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 1201 San Jose Ave | 27 | Front Yard : Yard | Tree | Private 2 | 1 | 6004362.40178 | 2095984.78807 | 37.7354220893496 | -122.427354972676 | (37.7354220893496, -122.427354972676) | 2 | 7 | 5 | 28861 | 2 | ||||
| 126499 | 225134 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 1201 San Jose Ave | 31 | Front Yard : Yard | Tree | Private 2 | 1 | 6004381.17131 | 2095999.66533 | 37.7354640004668 | -122.427291138793 | (37.7354640004668, -122.427291138793) | 2 | 7 | 5 | 28861 | 2 | ||||
| 128263 | 100322 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 1630 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2013 12:00:00 AM | 1 | Permit Number 770770 | 6006281.05167 | 2117644.72718 | 37.7950034915744 | -122.422259877984 | (37.7950034915744, -122.422259877984) | 13 | 9 | 10 | 28858 | 32 | ||
| 137917 | 65018 | Permitted Site 7 | Cercis occidentalis :: Western Redbud 136 | 1150 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2015 12:00:00 AM | 3 | Permit Number 774753 | 5997380.8966451 | 2106284.83958568 | 37.7633061668534 | -122.452235495348 | (37.7633061668534, -122.452235495348) | 15 | 5 | 11 | 29492 | 9 | ||
| 140816 | 189978 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 2001 Revere Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6012318.55478 | 2096424.98623 | 37.7370775415837 | -122.399878300962 | (37.7370775415837, -122.399878300962) | 10 | 3 | 8 | 58 | 1 | ||||
| 143547 | 100323 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 1630 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2013 12:00:00 AM | 2 | Permit Number 770770 | 6006270.05987 | 2117642.28458 | 37.7949961647956 | -122.422297737665 | (37.7949961647956, -122.422297737665) | 13 | 9 | 10 | 28858 | 32 | ||
| 157608 | 247888 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 360 Mayflower St | 3 | Side Yard : Yard | Tree | Private 2 | 2 | 6009996.89336 | 2098378.14108 | 37.7423107766219 | -122.408043069531 | (37.7423107766219, -122.408043069531) | 10 | 7 | 7 | 28859 | 2 | ||||
| 158905 | 37150 | Permitted Site 7 | Cercis occidentalis :: Western Redbud 136 | 114 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2015 12:00:00 AM | 3 | Permit Number 39730 | 6005776.47053016 | 2100252.57781759 | 37.7472203506201 | -122.422769203011 | (37.7472203506201, -122.422769203011) | 2 | 7 | 5 | 28859 | 22 | |
| 172311 | 100321 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 1630 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2013 12:00:00 AM | 2 | Permit Number 770770 | 6006322.03546 | 2117650.55613 | 37.7950218080653 | -122.422118482097 | (37.7950218080653, -122.422118482097) | 13 | 9 | 10 | 28858 | 32 | ||
| 172952 | 122376 | Undocumented 4 | Cercis occidentalis :: Western Redbud 136 | 195x Ogden Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6007788 | 2096166 | 37.7361128018191 | -122.415524188543 | (37.7361128018191, -122.415524188543) | 2 | 7 | 7 | 28859 | 2 | |||||
| 174704 | 189989 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 1427x Innes Ave | 7 | Median : Yard | Tree | DPW 1 | 4 | 6016321.76004 | 2096621.1016 | 37.7378384013117 | -122.386050952014 | (37.7378384013117, -122.386050952014) | 10 | 3 | 8 | 58 | 1 | ||||
| 183170 | 189980 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 2001 Revere Ave | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6012366.85539 | 2096386.45127 | 37.7369744253178 | -122.399708597978 | (37.7369744253178, -122.399708597978) | 10 | 3 | 8 | 58 | 1 | ||||
| 184408 | 92853 | Significant Tree 6 | Cercis occidentalis :: Western Redbud 136 | 3794 16th St | 2 | Front Yard : Yard | Tree | Private 2 | 12/14/2009 12:00:00 AM | Permit Number 53072 | 6001901 | 2106436 | 37.7639791186972 | -122.436612788339 | (37.7639791186972, -122.436612788339) | 15 | 5 | 5 | 28862 | 3 | |||
| 190761 | 49658 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 3630 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 1 | Permit Number 46510 | 6000258.18089 | 2120685.13581 | 37.8030100766084 | -122.443318322984 | (37.8030100766084, -122.443318322984) | 13 | 9 | 1 | 57 | 17 | ||
| 191110 | 45389 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 1630 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2013 12:00:00 AM | 1 | Permit Number 770770 | 6006335.45521 | 2117651.61484 | 37.7950254719105 | -122.422072122943 | (37.7950254719105, -122.422072122943) | 13 | 9 | 10 | 28858 | 32 | ||
| 193598 | 32394 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 215 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 3 | Permit Number 36935 | 6005700.60494 | 2096155.70406 | 37.7359669795973 | -122.422740439745 | (37.7359669795973, -122.422740439745) | 2 | 7 | 7 | 28859 | 2 |
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) );