trees
40 rows where qLegalStatus_id = 4 and qSpecies_id = 76 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47310 | 255326 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 1003x Turk St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6005211 | 2112640 | 37.7812013451486 | -122.425606050794 | (37.7812013451486, -122.425606050794) | 7 | 9 | 11 | 28852 | 41 | ||||
65197 | 255327 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 1003x Turk St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6005211 | 2112640 | 37.7812013451486 | -122.425606050794 | (37.7812013451486, -122.425606050794) | 7 | 9 | 11 | 28852 | 41 | ||||
136152 | 255328 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 1003x Turk St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6005211 | 2112640 | 37.7812013451486 | -122.425606050794 | (37.7812013451486, -122.425606050794) | 7 | 9 | 11 | 28852 | 41 | ||||
476 | 102238 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 1104 York St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009987 | 2102770 | 37.7543693005663 | -122.408386989199 | (37.7543693005663, -122.408386989199) | 2 | 4 | 7 | 28859 | 19 | ||||
29342 | 102237 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 1104 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009987 | 2102770 | 37.7543693005663 | -122.408386989199 | (37.7543693005663, -122.408386989199) | 2 | 4 | 7 | 28859 | 19 | ||||
94627 | 102236 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 1104 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009987 | 2102770 | 37.7543693005663 | -122.408386989199 | (37.7543693005663, -122.408386989199) | 2 | 4 | 7 | 28859 | 19 | ||||
122488 | 102241 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 1104 York St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009987 | 2102770 | 37.7543693005663 | -122.408386989199 | (37.7543693005663, -122.408386989199) | 2 | 4 | 7 | 28859 | 19 | ||||
175648 | 102239 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 1104 York St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009987 | 2102770 | 37.7543693005663 | -122.408386989199 | (37.7543693005663, -122.408386989199) | 2 | 4 | 7 | 28859 | 19 | ||||
231 | 116978 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 111 BAY ST | 4 | Front Yard : Yard | Tree | Private 2 | 6010550 | 2121704 | 37.8063891294227 | -122.407774985143 | (37.8063891294227, -122.407774985143) | 3 | 1 | 10 | 308 | 23 | |||||
81381 | 111709 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 111 BAY ST | 2 | Front Yard : Yard | Tree | Private 2 | 6010550 | 2121704 | 37.8063891294227 | -122.407774985143 | (37.8063891294227, -122.407774985143) | 3 | 1 | 10 | 308 | 23 | |||||
22569 | 114108 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 2650 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2016 12:00:00 AM | 3 | 6x10 | Permit Number 776585 | 6010150.7 | 2104026.1 | 37.7578274361796 | -122.407909441758 | (37.7578274361796, -122.407909441758) | 2 | 4 | 7 | 28859 | 19 | |
172440 | 102242 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 2819 23RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009900.7 | 2102774.7 | 37.7543773725694 | -122.408685769544 | (37.7543773725694, -122.408685769544) | 2 | 4 | 7 | 28859 | 19 | ||||
26694 | 102243 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 2819X 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009900.7 | 2102774.7 | 37.7543773725694 | -122.408685769544 | (37.7543773725694, -122.408685769544) | 2 | 4 | 7 | 28859 | 19 | ||||
92752 | 102244 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 2819X 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009900.7 | 2102774.7 | 37.7543773725694 | -122.408685769544 | (37.7543773725694, -122.408685769544) | 2 | 4 | 7 | 28859 | 19 | ||||
172437 | 114814 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 425 MIRAMAR AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995324 | 2092533 | 37.725428993141 | -122.458354138636 | (37.725428993141, -122.458354138636) | 9 | 7 | 4 | 28861 | 40 | ||||
104801 | 99803 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 4288-4298 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6001333 | 2101754 | 37.75109118813 | -122.438241893494 | (37.75109118813, -122.438241893494) | 2 | 4 | 5 | 28862 | 22 | ||||
145320 | 99804 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 4288-4298 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6001333 | 2101754 | 37.75109118813 | -122.438241893494 | (37.75109118813, -122.438241893494) | 2 | 4 | 5 | 28862 | 22 | ||||
91617 | 228392 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 741 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6001282.56527 | 2101791.06389 | 37.7511900880551 | -122.438418956794 | (37.7511900880551, -122.438418956794) | 2 | 4 | 5 | 28862 | 22 | |||
122777 | 99801 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 741 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6001292.8 | 2101960.5 | 37.7516559011478 | -122.438395701912 | (37.7516559011478, -122.438395701912) | 2 | 4 | 5 | 28862 | 22 | ||||
168864 | 99802 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 741 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6001292.8 | 2101960.5 | 37.7516559011478 | -122.438395701912 | (37.7516559011478, -122.438395701912) | 2 | 4 | 5 | 28862 | 22 | ||||
185328 | 228391 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 741 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6001283.19215 | 2101774.69957 | 37.7511451912112 | -122.438415616682 | (37.7511451912112, -122.438415616682) | 2 | 4 | 5 | 28862 | 22 | |||
68076 | 115541 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 780 DOUGLASS ST | 1 | Sidewalk: Property side : Yard | Tree | Rec/Park 5 | 24 | 3x3 | 6001139 | 2101871 | 37.7514014062737 | -122.438921147793 | (37.7514014062737, -122.438921147793) | 2 | 4 | 5 | 28862 | 22 | |||
73983 | 115542 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 780 DOUGLASS ST | 2 | Sidewalk: Property side : Yard | Tree | Rec/Park 5 | 3x3 | 6001139 | 2101871 | 37.7514014062737 | -122.438921147793 | (37.7514014062737, -122.438921147793) | 2 | 4 | 5 | 28862 | 22 | ||||
105860 | 115545 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 780 DOUGLASS ST | 5 | Sidewalk: Property side : Yard | Tree | Rec/Park 5 | 3x3 | 6001139 | 2101871 | 37.7514014062737 | -122.438921147793 | (37.7514014062737, -122.438921147793) | 2 | 4 | 5 | 28862 | 22 | ||||
116358 | 115543 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 780 DOUGLASS ST | 3 | Sidewalk: Property side : Yard | Tree | Rec/Park 5 | 3x3 | 6001139 | 2101871 | 37.7514014062737 | -122.438921147793 | (37.7514014062737, -122.438921147793) | 2 | 4 | 5 | 28862 | 22 | ||||
126223 | 115546 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 780 DOUGLASS ST | 6 | Sidewalk: Property side : Yard | Tree | Rec/Park 5 | 3x3 | 6001139 | 2101871 | 37.7514014062737 | -122.438921147793 | (37.7514014062737, -122.438921147793) | 2 | 4 | 5 | 28862 | 22 | ||||
183770 | 115544 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 780 DOUGLASS ST | 4 | Sidewalk: Property side : Yard | Tree | Rec/Park 5 | 3x3 | 6001139 | 2101871 | 37.7514014062737 | -122.438921147793 | (37.7514014062737, -122.438921147793) | 2 | 4 | 5 | 28862 | 22 | ||||
191751 | 115547 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 780 DOUGLASS ST | 7 | Sidewalk: Property side : Yard | Tree | Rec/Park 5 | 3x3 | 6001139 | 2101871 | 37.7514014062737 | -122.438921147793 | (37.7514014062737, -122.438921147793) | 2 | 4 | 5 | 28862 | 22 | ||||
1232 | 264776 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
3022 | 264768 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
4382 | 264774 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
7713 | 264772 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
7972 | 264777 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
9425 | 264770 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
10663 | 264778 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
11719 | 264769 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
11739 | 264780 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
12931 | 264773 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
15616 | 264771 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
17999 | 264779 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 |
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) );