trees
26 rows where Fire Prevention Districts = 9 and qSpecies_id = 160 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 138819 | 187495 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Walbridge St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | 6005184.36761 | 2086469.76682 | 37.7093423678344 | -122.423836763664 | (37.7093423678344, -122.423836763664) | 9 | 7 | 6 | 309 | 5 | ||||
| 161340 | 187497 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Walbridge St | 3 | Front Yard : Yard | Tree | Private 2 | 6 | 6005151.09396 | 2086478.68565 | 37.7093649785846 | -122.423952396694 | (37.7093649785846, -122.423952396694) | 9 | 7 | 6 | 309 | 5 | ||||
| 76464 | 187499 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Walbridge St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | 6005135.10052 | 2086491.02363 | 37.7093979531098 | -122.42400854948 | (37.7093979531098, -122.42400854948) | 9 | 7 | 6 | 309 | 5 | ||||
| 20896 | 187504 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Walbridge St | 10 | Front Yard : Yard | Tree | Private 2 | 9 | 6005101.69485 | 2086503.71935 | 37.7094309267755 | -122.424124907354 | (37.7094309267755, -122.424124907354) | 9 | 7 | 6 | 309 | 5 | ||||
| 168494 | 24290 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 386 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X17 | 6000963.19469 | 2086697.35612 | 37.7097280749492 | -122.438442083037 | (37.7097280749492, -122.438442083037) | 9 | 7 | 6 | 28861 | 5 | |||
| 7561 | 178088 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201 Chicago Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 3ft | 6003023.7628 | 2086943.78146 | 37.7105216991954 | -122.431337972882 | (37.7105216991954, -122.431337972882) | 9 | 7 | 6 | 28861 | 5 | |||
| 69989 | 178087 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 6003003.32466 | 2086943.97699 | 37.7105210777575 | -122.431408625424 | (37.7105210777575, -122.431408625424) | 9 | 7 | 6 | 28861 | 5 | |||
| 18679 | 264760 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1501 Sunnydale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007165 | 2087428 | 37.7120850908031 | -122.417059211527 | (37.7120850908031, -122.417059211527) | 9 | 7 | 8 | 309 | 39 | ||||
| 4101 | 261179 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 205 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009827 | 2087549 | 37.7125667222905 | -122.407867055005 | (37.7125667222905, -122.407867055005) | 9 | 7 | 8 | 309 | 39 | ||||
| 13403 | 261178 | Property Tree 8 | Phoenix canariensis :: Canary Island Date Palm 160 | 205 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009827 | 2087549 | 37.7125667222905 | -122.407867055005 | (37.7125667222905, -122.407867055005) | 9 | 7 | 8 | 309 | 39 | ||||
| 38982 | 60467 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 152 MAJESTIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1982 12:00:00 AM | Permit Number 20060 | 5996883 | 2089135 | 37.7161883486769 | -122.452719710267 | (37.7161883486769, -122.452719710267) | 9 | 8 | 6 | 28861 | 24 | |||
| 139354 | 92744 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 627 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52968 | 6009200 | 2091312 | 37.7228640173614 | -122.41029969524 | (37.7228640173614, -122.41029969524) | 9 | 3 | 7 | 309 | 28 | |||
| 55917 | 86731 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Pico Ave | Front Yard : Cutout | Tree | Private 2 | Permit Number 49705 | 5994102.9 | 2092171.9 | 37.7243672527805 | -122.462549157922 | (37.7243672527805, -122.462549157922) | 9 | 8 | 4 | 59 | 40 | |||||
| 82878 | 178086 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 364 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 43 | Width 3ft | 6001063.00753 | 2092653.59806 | 37.7260882551546 | -122.438523588412 | (37.7260882551546, -122.438523588412) | 9 | 7 | 6 | 28861 | 25 | |||
| 104220 | 109174 | Undocumented 4 | Phoenix canariensis :: Canary Island Date Palm 160 | 63 KEYSTONE WAY | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775282 | 5994095.9 | 2093146.9 | 37.7270439629203 | -122.462644049637 | (37.7270439629203, -122.462644049637) | 9 | 8 | 4 | 59 | 40 | |
| 20323 | 210923 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1540 Plymouth Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 41 | Width 3ft | 5995839.22139 | 2094293.33064 | 37.7302920326405 | -122.456700326779 | (37.7302920326405, -122.456700326779) | 9 | 7 | 4 | 28861 | 40 | |||
| 171088 | 210924 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1540 Plymouth Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 43 | Width 3ft | 5995827.11774 | 2094309.51389 | 37.7303357729732 | -122.456743340437 | (37.7303357729732, -122.456743340437) | 9 | 7 | 4 | 28861 | 40 | |||
| 86782 | 210912 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 443 Gennessee St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 5997433.76219 | 2094954.34243 | 37.7321984389023 | -122.451235463255 | (37.7321984389023, -122.451235463255) | 9 | 7 | 4 | 59 | 40 | ||||
| 54034 | 210911 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 443 Gennessee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 5997433.82925 | 2094957.55837 | 37.7322072729454 | -122.451235463261 | (37.7322072729454, -122.451235463261) | 9 | 7 | 4 | 59 | 40 | ||||
| 113407 | 210927 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 234 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | 6000492.41263 | 2094973.31916 | 37.732425199355 | -122.440662410937 | (37.732425199355, -122.440662410937) | 9 | 7 | 5 | 63 | 40 | ||||
| 68051 | 255454 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 218 Joost Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000622 | 2094989 | 37.7324756340381 | -122.440215522188 | (37.7324756340381, -122.440215522188) | 9 | 7 | 5 | 63 | 40 | ||||
| 184623 | 210928 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 617 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 37 | 5997342.33131 | 2095240.63361 | 37.7329792905421 | -122.451572201795 | (37.7329792905421, -122.451572201795) | 9 | 7 | 4 | 59 | 40 | ||||
| 184237 | 210926 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 39 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | Width 10ft | 5999833.49072 | 2095475.12852 | 37.7337655048678 | -122.44297647541 | (37.7337655048678, -122.44297647541) | 9 | 7 | 4 | 63 | 40 | |||
| 77645 | 210925 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 43 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 10ft | 5999799.64358 | 2095482.91454 | 37.7337849536105 | -122.443094053648 | (37.7337849536105, -122.443094053648) | 9 | 7 | 4 | 63 | 40 | |||
| 52518 | 13388 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 218 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5997667.52153 | 2098758.8322 | 37.7426580336411 | -122.45070150969 | (37.7426580336411, -122.45070150969) | 9 | 7 | 4 | 59 | 40 | |||
| 185249 | 87850 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 94 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50753 | 5997405.9 | 2099153.7 | 37.7437272652603 | -122.451634593656 | (37.7437272652603, -122.451634593656) | 9 | 7 | 4 | 59 | 40 |
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) );