trees
32 rows where Fire Prevention Districts = 1 and qSpecies_id = 160 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20887 | 210907 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1009 Kirkham St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 32 | Width 3ft | 5991740.69924 | 2105187.89339 | 37.7599695243799 | -122.471662958305 | (37.7599695243799, -122.471662958305) | 1 | 8 | 4 | 56 | 12 | |||
24405 | 210906 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1113 Kirkham St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 5991529.16752 | 2105177.12145 | 37.7599277068135 | -122.472393751863 | (37.7599277068135, -122.472393751863) | 1 | 8 | 4 | 56 | 12 | |||
137161 | 210913 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1800 18th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5990641.45059 | 2103071.06132 | 37.7540936050568 | -122.475310139971 | (37.7540936050568, -122.475310139971) | 1 | 8 | 4 | 56 | 12 | |||
137538 | 210903 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1939 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 2ft | 5991246.46009 | 2102193.40392 | 37.7517188372786 | -122.473153888536 | (37.7517188372786, -122.473153888536) | 1 | 8 | 4 | 29491 | 12 | |||
174513 | 210908 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1351 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5994231.83561 | 2106400.13756 | 37.7634418445856 | -122.463135347428 | (37.7634418445856, -122.463135347428) | 1 | 5 | 11 | 56 | 12 | |||
4941 | 186180 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984958.094 | 2103565.49 | 37.7551201057822 | -122.495000731871 | (37.7551201057822, -122.495000731871) | 1 | 8 | 3 | 56 | 35 | |||
77150 | 182268 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1466 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 0ft | 5985290.7143 | 2105238.2671 | 37.759732554956 | -122.493973725026 | (37.759732554956, -122.493973725026) | 1 | 8 | 3 | 56 | 35 | |||
81219 | 186008 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985026.892 | 2101640.0667 | 37.7498374500445 | -122.494620873169 | (37.7498374500445, -122.494620873169) | 1 | 8 | 3 | 29491 | 35 | |||
83503 | 182681 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2701 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5985882.7747 | 2103629.0901 | 37.7553488224274 | -122.491807644065 | (37.7553488224274, -122.491807644065) | 1 | 8 | 3 | 56 | 35 | |||
108889 | 182872 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1845 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 5987505.5699 | 2102718.6655 | 37.7529437568716 | -122.48612877159 | (37.7529437568716, -122.48612877159) | 1 | 8 | 3 | 56 | 35 | |||
110853 | 185382 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2615 34th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 0ft | 5985803.8248 | 2097379.5833 | 37.7381847526444 | -122.491620661903 | (37.7381847526444, -122.491620661903) | 1 | 8 | 3 | 29491 | 35 | |||
121785 | 185441 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985106.1344 | 2099492.3058 | 37.7439449206951 | -122.494188569919 | (37.7439449206951, -122.494188569919) | 1 | 8 | 3 | 29491 | 35 | |||
124312 | 182197 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1584 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 0ft | 5985008.2078 | 2104414.5267 | 37.7574542590905 | -122.494890024235 | (37.7574542590905, -122.494890024235) | 1 | 8 | 3 | 56 | 35 | |||
133231 | 182873 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1845 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5987506.6654 | 2102709.2443 | 37.7529179526447 | -122.486124291657 | (37.7529179526447, -122.486124291657) | 1 | 8 | 3 | 56 | 35 | |||
139512 | 182680 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2701 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5985854.1638 | 2103629.592 | 37.7553485282392 | -122.491906624733 | (37.7553485282392, -122.491906624733) | 1 | 8 | 3 | 56 | 35 | |||
145259 | 186006 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985010.9219 | 2101633.2915 | 37.7498179124605 | -122.494675598244 | (37.7498179124605, -122.494675598244) | 1 | 8 | 3 | 29491 | 35 | |||
147428 | 187316 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2200 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5985075.4607 | 2099608.8478 | 37.7442631184817 | -122.494303219592 | (37.7442631184817, -122.494303219592) | 1 | 8 | 3 | 29491 | 35 | |||
164985 | 186007 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985000.2752 | 2101640.5507 | 37.749837221065 | -122.49471294958 | (37.749837221065, -122.49471294958) | 1 | 8 | 3 | 29491 | 35 | |||
189394 | 186179 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984928.6664 | 2103564.4514 | 37.7551155313127 | -122.495102422977 | (37.7551155313127, -122.495102422977) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 |
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) );