trees
47 rows where PlotSize = "" and qSpecies_id = 86
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50876 | 39476 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1425 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 14 | Permit Number 40937 | 6002367.56738 | 2121559.91338 | 37.8055320445375 | -122.436081393069 | (37.8055320445375, -122.436081393069) | 13 | 9 | 1 | 57 | 17 | ||
57951 | 179814 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 522 Sunnydale Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | 6010066.66697 | 2086413.12079 | 37.7094612429124 | -122.406958677794 | (37.7094612429124, -122.406958677794) | 9 | 7 | 8 | 309 | 39 | ||||
61991 | 136635 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3600 Baker St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5999192.08373 | 2121248.84261 | 37.804497012091 | -122.447048150554 | (37.804497012091, -122.447048150554) | 13 | 9 | 1 | 57 | 17 | ||||
70182 | 179871 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Athens St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6005395.25697 | 2093256.97645 | 37.7279904840704 | -122.423590123686 | (37.7279904840704, -122.423590123686) | 9 | 7 | 6 | 28861 | 5 | ||||
71235 | 98244 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 901 Bay St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6006420.63185 | 2121080.7781 | 37.8044458892203 | -122.422021121489 | (37.8044458892203, -122.422021121489) | 5 | 1 | 1 | 28858 | 32 | ||||
72527 | 120265 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 100 24th Ave | 3 | Side Yard : Yard | Tree | Private 2 | 20 | 5988361.48129 | 2115164.47421 | 37.7871663527314 | -122.484081512932 | (37.7871663527314, -122.484081512932) | 11 | 6 | 1 | 55 | 33 | ||||
75958 | 136705 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1120 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 14 | 6007496.45618 | 2119889.74411 | 37.8012362277192 | -122.418213633845 | (37.8012362277192, -122.418213633845) | 5 | 1 | 1 | 28858 | 32 | ||||
80852 | 54662 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 353 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 18 | Permit Number 10486 | 6012290.80379 | 2086856.89359 | 37.7108039630942 | -122.39930277173 | (37.7108039630942, -122.39930277173) | 10 | 3 | 8 | 309 | 1 | ||
94393 | 68663 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 142 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 10 | Permit Number 32570 | 5993373.867 | 2114549.20899 | 37.7857675498482 | -122.466695151518 | (37.7857675498482, -122.466695151518) | 11 | 6 | 2 | 54 | 11 | |
98485 | 104833 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 901 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6006442.50157 | 2121083.02679 | 37.8044532969577 | -122.421945599118 | (37.8044532969577, -122.421945599118) | 5 | 1 | 1 | 28858 | 32 | ||||
106864 | 103625 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/04/2013 12:00:00 AM | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | |||
112263 | 97298 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 1051 Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | 9 | 7 | 4 | 59 | 40 | |||||
118052 | 52756 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 176@ GEARY Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2006 12:00:00 AM | 7 | Permit Number 48800 | 5995950.25747 | 2113100.83881 | 37.7819390591214 | -122.457676787394 | (37.7819390591214, -122.457676787394) | 11 | 6 | 1 | 54 | 31 | ||
125099 | 215304 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 681 Joost Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 5997552.24164 | 2094964.50066 | 37.7322331140486 | -122.450826587399 | (37.7322331140486, -122.450826587399) | 9 | 7 | 4 | 59 | 40 | ||||
126756 | 179845 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 85 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6000550.17873 | 2092849.30944 | 37.7265964485477 | -122.44031043159 | (37.7265964485477, -122.44031043159) | 9 | 7 | 6 | 28861 | 25 | ||||
145353 | 179859 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 71 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6004926.25969 | 2092979.13729 | 37.7272011149393 | -122.425191700232 | (37.7272011149393, -122.425191700232) | 9 | 7 | 6 | 28861 | 5 | ||||
148964 | 241064 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1801 Castro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6002651.6707 | 2100291.95945 | 37.7471516815152 | -122.433577323454 | (37.7471516815152, -122.433577323454) | 2 | 7 | 5 | 63 | 22 | ||||
150071 | 67960 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 819 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 12 | Permit Number 31680 | 5987243.89988 | 2110346.29905 | 37.7738718832899 | -122.487593962509 | (37.7738718832899, -122.487593962509) | 11 | 6 | 2 | 55 | 26 | |
151400 | 97300 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 1051 Portola Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | 9 | 7 | 4 | 59 | 40 | |||||
156304 | 241066 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1801 Castro St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6002659.6635 | 2100292.45655 | 37.7471534999337 | -122.43354972054 | (37.7471534999337, -122.43354972054) | 2 | 7 | 5 | 63 | 22 | ||||
157108 | 114608 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 2398X 15TH AVE | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6 | 5991654 | 2099150 | 37.7433860243849 | -122.471522828523 | (37.7433860243849, -122.471522828523) | 1 | 8 | 4 | 29491 | 40 | ||||
159259 | 104674 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 3649-3651 17TH ST | 1 | Front Yard : Yard | Tree | Private 2 | 20 | Permit Number 770917 | 6004555.5 | 2105964.3 | 37.7628344347284 | -122.427398052716 | (37.7628344347284, -122.427398052716) | 8 | 4 | 5 | 28862 | 3 | |||
161074 | 41928 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 524 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 9 | Permit Number 42287 | 5994708.51972 | 2111929.51477 | 37.7786515066402 | -122.461887634901 | (37.7786515066402, -122.461887634901) | 11 | 6 | 2 | 54 | 11 | |
169423 | 41927 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 524 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 6 | Permit Number 42287 | 5994711.05634 | 2111911.6847 | 37.7786026960614 | -122.46187756658 | (37.7786026960614, -122.46187756658) | 11 | 6 | 2 | 54 | 11 | |
173768 | 136712 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 84 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6008291.17542 | 2119130.0368 | 37.7991949618221 | -122.415409734769 | (37.7991949618221, -122.415409734769) | 5 | 1 | 10 | 308 | 32 | ||||
175671 | 67619 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1101 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | 11 | Permit Number 31202 | 6007683.17057 | 2118835.54867 | 37.7983521792584 | -122.417492763389 | (37.7983521792584, -122.417492763389) | 5 | 1 | 10 | 28858 | 32 |
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) );