trees
20 rows where PlotSize = "", Supervisor Districts = 6 and qSpecies_id = 47 sorted by Location
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186347 | 207117 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 41 Ralston St | 9 | Back Yard : Yard | Tree | Private 2 | 19 | 5992170.67066 | 2088214.06867 | 37.7133885481037 | -122.468940655584 | (37.7133885481037, -122.468940655584) | 9 | 8 | 6 | 64 | 24 | ||||
| 177625 | 207115 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 47 Ralston St | 8 | Back Yard : Yard | Tree | Private 2 | 8 | 5992168.43399 | 2088239.25639 | 37.7134575782774 | -122.468950218099 | (37.7134575782774, -122.468950218099) | 9 | 8 | 6 | 64 | 24 | ||||
| 16464 | 207116 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 47 Ralston St | 9 | Back Yard : Yard | Tree | Private 2 | 8 | 5992178.8337 | 2088240.41516 | 37.7134613608383 | -122.468914357628 | (37.7134613608383, -122.468914357628) | 9 | 8 | 6 | 64 | 24 | ||||
| 19861 | 207114 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 53 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 23 | 5992175.21623 | 2088282.16276 | 37.7135757806697 | -122.468929896991 | (37.7135757806697, -122.468929896991) | 9 | 8 | 6 | 64 | 24 | ||||
| 131273 | 207113 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 53 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 5 | 5992170.39113 | 2088282.95309 | 37.7135776719473 | -122.468946631596 | (37.7135776719473, -122.468946631596) | 9 | 8 | 6 | 64 | 24 | ||||
| 174244 | 207112 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59 Ralston St | 4 | Back Yard : Yard | Tree | Private 2 | 12 | 5992171.74672 | 2088295.87352 | 37.7136132266511 | -122.468942885919 | (37.7136132266511, -122.468942885919) | 9 | 8 | 6 | 64 | 24 | ||||
| 142860 | 207111 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 11 | 5992171.5605 | 2088305.6585 | 37.713640083085 | -122.468944241206 | (37.713640083085, -122.468944241206) | 9 | 8 | 6 | 64 | 24 | ||||
| 63319 | 207110 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 7 | 5992170.63195 | 2088310.84387 | 37.7136542672107 | -122.468947827707 | (37.7136542672107, -122.468947827707) | 9 | 8 | 6 | 64 | 24 | ||||
| 64604 | 207109 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 14 | 5992170.77084 | 2088338.0326 | 37.7137289289241 | -122.468949325066 | (37.7137289289241, -122.468949325066) | 9 | 8 | 6 | 64 | 24 | ||||
| 187087 | 207108 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 89 Ralston St | 3 | Back Yard : Yard | Tree | Private 2 | 13 | 5992168.92954 | 2088415.82729 | 37.7139424279717 | -122.468961347182 | (37.7139424279717, -122.468961347182) | 9 | 8 | 6 | 64 | 24 | ||||
| 36093 | 207107 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 89 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 11 | 5992169.55859 | 2088419.40871 | 37.7139522980308 | -122.468959433443 | (37.7139522980308, -122.468959433443) | 9 | 8 | 6 | 64 | 24 | ||||
| 161455 | 40483 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 165 Margaret Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1999 12:00:00 AM | Permit Number 41562 | 5996732.70371963 | 2089259.1130924 | 37.7165205210888 | -122.453248158457 | (37.7165205210888, -122.453248158457) | 9 | 8 | 6 | 28861 | 24 | ||
| 54666 | 31185 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 720 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34883 | 5992147.8527206 | 2089880.99524616 | 37.7179642061069 | -122.469140766842 | (37.7179642061069, -122.469140766842) | 9 | 8 | 6 | 64 | 24 | ||
| 81378 | 50428 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47081 | 5996479.47890892 | 2089951.8399169 | 37.7184080697361 | -122.454173429085 | (37.7184080697361, -122.454173429085) | 9 | 8 | 6 | 28861 | 24 | ||
| 113634 | 47351 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 246 Monticello St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45277 | 5991716.56988019 | 2090163.16086716 | 37.7187140338834 | -122.470652049529 | (37.7187140338834, -122.470652049529) | 9 | 8 | 6 | 64 | 24 | ||
| 123096 | 45360 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 458 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46747 | 5993277.37926203 | 2090218.01876098 | 37.7189547935486 | -122.46526098645 | (37.7189547935486, -122.46526098645) | 9 | 8 | 6 | 64 | 24 | ||
| 137534 | 50423 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47076 | 5995600.08487961 | 2090390.5729412 | 37.7195622602365 | -122.457244829317 | (37.7195622602365, -122.457244829317) | 9 | 8 | 6 | 28861 | 24 | ||
| 109823 | 52980 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 531 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2006 12:00:00 AM | Permit Number 49067 | 5992711.66457877 | 2090721.03501475 | 37.7203033137371 | -122.467252978798 | (37.7203033137371, -122.467252978798) | 9 | 8 | 6 | 64 | 24 | ||
| 145902 | 31168 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 570 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34869 | 5993027.58275469 | 2090995.29108117 | 37.7210745862886 | -122.466180882741 | (37.7210745862886, -122.466180882741) | 9 | 8 | 6 | 64 | 24 | ||
| 67862 | 37850 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 211 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40141 | 6003943.02561838 | 2092441.0681197 | 37.7256681018117 | -122.428552395212 | (37.7256681018117, -122.428552395212) | 9 | 7 | 6 | 28861 | 5 |
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) );