trees
117 rows where Police Districts = 3 and qLegalStatus_id = 6 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22679 | 108026 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 862 Kansas St | Front Yard : Yard | Tree | Private 2 | Permit Number 774734 | 6011570 | 2104296 | 37.7586478799274 | -122.403019866682 | (37.7586478799274, -122.403019866682) | 10 | 3 | 8 | 28856 | 29 | |||||
12165 | 260922 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 866 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 774734 | 6011543 | 2104306 | 37.7586738299336 | -122.403113948893 | (37.7586738299336, -122.403113948893) | 10 | 3 | 8 | 28856 | 29 | |||
23612 | 253210 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 567 Mississippi St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/02/2019 12:00:00 AM | 3 | 3x3 | 6014163 | 2104519 | 37.7594046471392 | -122.394067636073 | (37.7594046471392, -122.394067636073) | 10 | 3 | 8 | 28856 | 29 | ||
135623 | 258062 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 567 Mississippi St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/02/2019 12:00:00 AM | 3 | 3x3 | 6014163 | 2104519 | 37.7594046471392 | -122.394067636073 | (37.7594046471392, -122.394067636073) | 10 | 3 | 8 | 28856 | 29 | ||
191992 | 94463 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 744 Carolina St | 1 | : | Tree | Private 2 | 06/10/2010 12:00:00 AM | Permit Number 53681 | 6012327.5 | 2104524.9 | 37.7593186601765 | -122.400416148756 | (37.7593186601765, -122.400416148756) | 10 | 3 | 8 | 28856 | 29 | |||
66713 | 107149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 612 WISCONSIN ST | 1 | Back Yard : Yard | Tree | Private 2 | 6012651.9 | 2104553.6 | 37.7594155491308 | -122.399296223309 | (37.7594155491308, -122.399296223309) | 10 | 3 | 8 | 28856 | 29 | |||||
95493 | 100209 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 701 Rhode Island St | 1 | Front Yard : Yard | Tree | Private 2 | 10 | Permit Number 769013 | 6011855.86556 | 2105057.10212 | 37.7607536567646 | -122.402084714731 | (37.7607536567646, -122.402084714731) | 10 | 3 | 8 | 28856 | 29 | |||
43892 | 99623 | Significant Tree 6 | Tree(s) :: 17 | 380 Connecticut St | 1 | Front Yard : Yard | Tree | Private 2 | 05/23/2012 12:00:00 AM | Permit Number 768850 | 6013171.4 | 2105301.7 | 37.7614986071193 | -122.397551993257 | (37.7614986071193, -122.397551993257) | 10 | 3 | 8 | 28856 | 29 | |||
38818 | 105964 | Significant Tree 6 | Tree(s) :: 17 | 360 MISSOURI ST | 1 | Front Yard : Yard | Tree | Private 2 | 6013401.8 | 2105413.2 | 37.7618175880082 | -122.396762946114 | (37.7618175880082, -122.396762946114) | 10 | 3 | 8 | 28856 | 29 | |||||
187289 | 115806 | Significant Tree 6 | Robinia pseudoacacia :: Black Locust 286 | 362 MISSOURI ST | 1 | Front Yard : Cutout | Tree | Private 2 | 12 | 3x3 | 6013446 | 2105415 | 37.7618249904211 | -122.39661020099 | (37.7618249904211, -122.39661020099) | 10 | 3 | 8 | 28856 | 29 | |||
177101 | 96784 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 615 Rhode Island St | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/19/2011 12:00:00 AM | Permit Number 767987 | 6011854.6 | 2105476.9 | 37.7619062576766 | -122.402118605761 | (37.7619062576766, -122.402118605761) | 10 | 3 | 8 | 28856 | 29 | ||||
81334 | 106255 | Significant Tree 6 | Tree(s) :: 17 | 1900X 18th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 770844 | 6012067 | 2105610 | 37.7622835736204 | -122.401393347502 | (37.7622835736204, -122.401393347502) | 8 | 3 | 8 | 28856 | 29 | ||||
67194 | 106251 | Significant Tree 6 | Tree(s) :: 17 | 580 De Haro St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 770844 | 6012025.9 | 2105717.4 | 37.7625761768628 | -122.401543046462 | (37.7625761768628, -122.401543046462) | 8 | 3 | 8 | 28856 | 29 | ||||
192621 | 106250 | Significant Tree 6 | Tree(s) :: 17 | 580 De Haro St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770844 | 6012025.9 | 2105717.4 | 37.7625761768628 | -122.401543046462 | (37.7625761768628, -122.401543046462) | 8 | 3 | 8 | 28856 | 29 | ||||
4313 | 105327 | Significant Tree 6 | Tree(s) :: 17 | 2051 03rd St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 771015 | 6015779.9 | 2106081.5 | 37.7637846705736 | -122.388584622631 | (37.7637846705736, -122.388584622631) | 14 | 3 | 8 | 28856 | 29 | ||||
7964 | 105328 | Significant Tree 6 | Tree(s) :: 17 | 2051 03rd St | 2 | Back Yard : Yard | Tree | Private 2 | Permit Number 771015 | 6015779.9 | 2106081.5 | 37.7637846705736 | -122.388584622631 | (37.7637846705736, -122.388584622631) | 14 | 3 | 8 | 28856 | 29 | ||||
41328 | 121446 | Significant Tree 6 | Tree(s) :: 17 | 500 Terry A Francois Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6016102 | 2110410 | 37.775687633053 | -122.387772601034 | (37.775687633053, -122.387772601034) | 14 | 3 | 9 | 310 | 20 |
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) );