trees
26 rows where Neighborhoods (old) = 40 and qSpecies_id = 160
This data as json, CSV (advanced)
These facets timed out: Neighborhoods (old)
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12082 | 210917 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 Kingston St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 4ft | 5994023.92221 | 2099259.09244 | 37.7438223849926 | -122.463336219994 | (37.7438223849926, -122.463336219994) | 1 | 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 | |||
| 21377 | 210922 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 Kingston St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | Width 4ft | 5994038.37723 | 2099205.21989 | 37.7436752972852 | -122.463282329909 | (37.7436752972852, -122.463282329909) | 1 | 8 | 4 | 59 | 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 | |||
| 53288 | 210910 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 151 Garcia Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5994660.64772 | 2099277.20114 | 37.743908769387 | -122.461135900907 | (37.743908769387, -122.461135900907) | 1 | 8 | 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 | ||||
| 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 | |||||
| 67446 | 210916 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 587 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | Width 4ft | 5994027.5569 | 2099288.55437 | 37.7439034894442 | -122.46332578967 | (37.7439034894442, -122.46332578967) | 1 | 8 | 4 | 59 | 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 | ||||
| 70812 | 210921 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 Kingston St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 4ft | 5994023.0507 | 2099217.557 | 37.7437082889086 | -122.463336220006 | (37.7437082889086, -122.463336220006) | 1 | 8 | 4 | 59 | 40 | |||
| 75567 | 210920 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 Kingston St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 4ft | 5994018.26687 | 2099229.17211 | 37.7437399054734 | -122.463353603909 | (37.7437399054734, -122.463353603909) | 1 | 8 | 4 | 59 | 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 | |||
| 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 | ||||
| 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 | |
| 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 | ||||
| 114206 | 210918 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 Kingston St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 4ft | 5994017.59782 | 2099245.20708 | 37.7437838949233 | -122.463357080672 | (37.7437838949233, -122.463357080672) | 1 | 8 | 4 | 59 | 40 | |||
| 114949 | 210919 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 Kingston St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 4ft | 5994015.85922 | 2099234.22929 | 37.7437536525071 | -122.463362295833 | (37.7437536525071, -122.463362295833) | 1 | 8 | 4 | 59 | 40 | |||
| 120657 | 210909 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 151 Garcia Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994659.02084 | 2099296.69557 | 37.7439622025921 | -122.461142939006 | (37.7439622025921, -122.461142939006) | 1 | 8 | 4 | 59 | 40 | |||
| 124175 | 210915 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 587 Dewey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | Width 4ft | 5994038.34106 | 2099299.34237 | 37.7439337318666 | -122.463289283487 | (37.7439337318666, -122.463289283487) | 1 | 8 | 4 | 59 | 40 | |||
| 125654 | 210914 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 317 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5993048.09757 | 2099658.5212 | 37.7448628475372 | -122.466739393103 | (37.7448628475372, -122.466739393103) | 1 | 8 | 4 | 29491 | 40 | |||
| 162934 | 218157 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1396 Portola Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 44 | 5993196.82548 | 2097677.09951 | 37.7394309459859 | -122.46608116671 | (37.7394309459859, -122.46608116671) | 1 | 8 | 4 | 59 | 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 | |||
| 174356 | 218156 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1396 Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 5993216.16649 | 2097685.94396 | 37.7394563464375 | -122.466014937058 | (37.7394563464375, -122.466014937058) | 1 | 8 | 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 | |||
| 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 | ||||
| 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) );