trees
221 rows where qSpecies_id = 153
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 179881 | 42255 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 449 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42499 | 6011032.58907867 | 2112142.29283942 | 37.7801619842664 | -122.405431068184 | (37.7801619842664, -122.405431068184) | 14 | 2 | 9 | 28853 | 34 | ||
| 180116 | 125952 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 2294 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001994.86126 | 2118787.45338 | 37.7978984191288 | -122.437172562074 | (37.7978984191288, -122.437172562074) | 13 | 9 | 1 | 57 | 17 | |||
| 182239 | 1547 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 501 Arguello Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5995572.64433 | 2112729.15384 | 37.7808968119003 | -122.458956226418 | (37.7808968119003, -122.458956226418) | 11 | 6 | 2 | 54 | 11 | |||
| 182600 | 38809 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 202 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1998 12:00:00 AM | Permit Number 40646 | 6014649.4963121 | 2111590.96099347 | 37.7788497186051 | -122.392879852588 | (37.7788497186051, -122.392879852588) | 6 | 2 | 9 | 28856 | 34 | ||
| 182616 | 52299 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 46221st ST. Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2005 12:00:00 AM | Permit Number 48460 | 6001157.72665298 | 2103563.59755974 | 37.7560499364738 | -122.438977677821 | (37.7560499364738, -122.438977677821) | 2 | 4 | 5 | 28862 | 38 | ||
| 182640 | 41705 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 70 Natick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42154 | 6003051.73866425 | 2095477.41967872 | 37.7339547580058 | -122.431850206764 | (37.7339547580058, -122.431850206764) | 2 | 7 | 5 | 63 | 7 | ||
| 182659 | 28505 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 270 06th St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6010824.2979387 | 2111653.7211901 | 37.7788088323978 | -122.406117215604 | (37.7788088323978, -122.406117215604) | 14 | 2 | 9 | 28853 | 34 | |||
| 182973 | 32637 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 778 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37083 | 6011766.14443501 | 2109713.24584796 | 37.7735333687871 | -122.402722477064 | (37.7735333687871, -122.402722477064) | 14 | 2 | 9 | 28853 | 34 | ||
| 183195 | 50085 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 169 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46817 | 5992373.11163098 | 2098031.46456186 | 37.7403563861764 | -122.468954963559 | (37.7403563861764, -122.468954963559) | 1 | 8 | 4 | 59 | 40 | ||
| 183417 | 46864 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 96 Athens St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44930 | 6004995.61677719 | 2092705.22653245 | 37.726452934298 | -122.424932453632 | (37.726452934298, -122.424932453632) | 9 | 7 | 6 | 28861 | 5 | ||
| 183706 | 59249 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 948 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1980 12:00:00 AM | 10 | Permit Number 18581 | 6007857.82328 | 2120305.56138 | 37.80239829122 | -122.416992620734 | (37.80239829122, -122.416992620734) | 5 | 1 | 1 | 308 | 32 | ||
| 185514 | 34617 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3299 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38300 | 5999016.0246967 | 2115927.38259794 | 37.7898756461349 | -122.44727418368 | (37.7898756461349, -122.44727418368) | 13 | 6 | 1 | 29490 | 31 | ||
| 187222 | 115857 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 187258 | 222864 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1057 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008644.3268 | 2102383.5696 | 37.7532329691398 | -122.413002991602 | (37.7532329691398, -122.413002991602) | 2 | 4 | 7 | 28859 | 19 | |||
| 189272 | 173806 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 950 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007805.70004 | 2120292.05671 | 37.8023582786402 | -122.417172035787 | (37.8023582786402, -122.417172035787) | 5 | 1 | 1 | 308 | 32 | ||||
| 189808 | 106235 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 785 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6011771.38268 | 2109636.80705 | 37.7733237777988 | -122.402698980481 | (37.7733237777988, -122.402698980481) | 14 | 2 | 9 | 28853 | 34 | ||||
| 190723 | 175837 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 101 Rhine St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994356.88277 | 2086531.76861 | 37.7088954182656 | -122.461262522762 | (37.7088954182656, -122.461262522762) | 9 | 8 | 6 | 28861 | 25 | |||
| 191773 | 175838 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 101 Rhine St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994346.0156 | 2086520.62322 | 37.7088641902123 | -122.461299273568 | (37.7088641902123, -122.461299273568) | 9 | 8 | 6 | 28861 | 25 | |||
| 192421 | 46860 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 96 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | 7 | Permit Number 44930 | 6005007.55179 | 2092712.98729 | 37.7264749177759 | -122.424891746668 | (37.7264749177759, -122.424891746668) | 9 | 7 | 6 | 28861 | 5 | ||
| 192537 | 222873 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 4354 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000914.51326 | 2103313.56277 | 37.7553495604475 | -122.439800863126 | (37.7553495604475, -122.439800863126) | 2 | 4 | 5 | 28862 | 38 | |||
| 193714 | 247476 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 856 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002462.8226 | 2109547.3008 | 37.7725538978004 | -122.434892132162 | (37.7725538978004, -122.434892132162) | 15 | 5 | 11 | 29492 | 9 |
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) );