trees
40 rows where Fire Prevention Districts = 11, SiteOrder = 2 and qSpecies_id = 65 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30504 | 37659 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 486 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51139 | 5991909.24916 | 2112157.7974 | 37.7791167592266 | -122.471587940686 | (37.7791167592266, -122.471587940686) | 11 | 6 | 2 | 54 | 11 | |
88133 | 94732 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3965 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53863 | 5995732.51221 | 2115478.09158 | 37.7884538465346 | -122.458602225523 | (37.7884538465346, -122.458602225523) | 11 | 6 | 1 | 54 | 31 |
98080 | 124074 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 701 Funston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 5991915.64045 | 2110472.33987 | 37.7744893213305 | -122.471442985847 | (37.7744893213305, -122.471442985847) | 11 | 6 | 2 | 54 | 11 | ||||
137740 | 124329 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 122 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995931.07902 | 2113567.14983 | 37.7832183231598 | -122.457776888478 | (37.7832183231598, -122.457776888478) | 11 | 6 | 1 | 54 | 31 | |||
145252 | 123201 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1310 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5993108.25102 | 2112027.19449 | 37.7788274527304 | -122.467430639975 | (37.7788274527304, -122.467430639975) | 11 | 6 | 2 | 54 | 11 | |||
172907 | 112365 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 501x 09TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993143 | 2111731 | 37.7780161887977 | -122.467288887933 | (37.7780161887977, -122.467288887933) | 11 | 6 | 2 | 54 | 11 | ||||
181359 | 107593 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1801 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x6 | 5993030.37815 | 2112040.04561 | 37.7788582423825 | -122.467700965505 | (37.7788582423825, -122.467700965505) | 11 | 6 | 2 | 54 | 11 | |||
183389 | 36189 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Parker Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 11 | Permit Number 39257 | 5996904.302 | 2113169.9694 | 37.7821836328514 | -122.454381246555 | (37.7821836328514, -122.454381246555) | 11 | 6 | 1 | 54 | 31 | |
190842 | 123821 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1851 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992885.6569 | 2112034.46491 | 37.7788345620747 | -122.468201203152 | (37.7788345620747, -122.468201203152) | 11 | 6 | 2 | 54 | 11 | |||
652 | 144195 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 630 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:17:00 PM | 0 | Width 4ft | 5982905.71974 | 2111464.01201 | 37.7766868258595 | -122.502682939079 | (37.7766868258595, -122.502682939079) | 11 | 6 | 2 | 55 | 26 | ||
1318 | 90667 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3650 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984240.02152 | 2110418.12044 | 37.7738934300459 | -122.497990013473 | (37.7738934300459, -122.497990013473) | 11 | 6 | 2 | 55 | 26 | ||
8034 | 90792 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3601 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984394.0288 | 2110367.66462 | 37.7737639208306 | -122.497453559374 | (37.7737639208306, -122.497453559374) | 11 | 6 | 2 | 55 | 26 | ||
8671 | 90671 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3730 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984065.245536 | 2110402.073206 | 37.7738391205751 | -122.498593397317 | (37.7738391205751, -122.498593397317) | 11 | 6 | 2 | 55 | 26 | |
9419 | 70579 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 212 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 5989642.97264 | 2113940.99798 | 37.7838815566968 | -122.479558331084 | (37.7838815566968, -122.479558331084) | 11 | 6 | 2 | 55 | 26 | |||
12461 | 70586 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1829 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 3x3 | 5989790.05617 | 2113327.40851 | 37.7822053543666 | -122.479004586193 | (37.7822053543666, -122.479004586193) | 11 | 6 | 2 | 55 | 26 | ||
16271 | 70637 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 366 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 5989681.33486 | 2112881.66682 | 37.7809751580333 | -122.479348089371 | (37.7809751580333, -122.479348089371) | 11 | 6 | 2 | 55 | 26 | |||
39448 | 90756 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4125 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982844.302046 | 2110317.735204 | 37.7735358737042 | -122.50281052448 | (37.7735358737042, -122.50281052448) | 11 | 6 | 2 | 55 | 26 | |
46187 | 90758 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4101X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982824.98876 | 2110312.0957 | 37.7735192542053 | -122.502876913329 | (37.7735192542053, -122.502876913329) | 11 | 6 | 2 | 55 | 26 | ||
49734 | 117948 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3851 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5983620.50726 | 2110339.60464 | 37.7736415077236 | -122.500127175628 | (37.7736415077236, -122.500127175628) | 11 | 6 | 2 | 55 | 26 | |||
56274 | 104694 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2132 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770783 | 5988835.56911 | 2113350.38756 | 37.7822129738615 | -122.482308328405 | (37.7822129738615, -122.482308328405) | 11 | 6 | 2 | 55 | 26 | |
61128 | 90810 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3399X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985103.163321 | 2110399.715943 | 37.773893463342 | -122.495002950661 | (37.773893463342, -122.495002950661) | 11 | 6 | 2 | 55 | 26 | |
63136 | 90687 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4000X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983157.80014 | 2110378.60264 | 37.7737214173 | -122.501730610018 | (37.7737214173, -122.501730610018) | 11 | 6 | 2 | 55 | 26 | ||
80338 | 90681 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3900 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983466.89 | 2110390.06853 | 37.7737710498312 | -122.500662284982 | (37.7737710498312, -122.500662284982) | 11 | 6 | 2 | 55 | 26 | ||
82214 | 90807 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3403 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985004.00767 | 2110390.48128 | 37.7738623024511 | -122.495345260104 | (37.7738623024511, -122.495345260104) | 11 | 6 | 2 | 55 | 26 | ||
82855 | 90696 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4100X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982853.2509 | 2110366.2864 | 37.7736697071224 | -122.502783164224 | (37.7736697071224, -122.502783164224) | 11 | 6 | 2 | 55 | 26 | ||
87812 | 90803 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3443 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984882.76444 | 2110385.13502 | 37.7738405235179 | -122.495764259508 | (37.7738405235179, -122.495764259508) | 11 | 6 | 2 | 55 | 26 | ||
98816 | 90672 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3750x CABRILLO ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984009 | 2110380 | 37.7737752151611 | -122.498786325695 | (37.7737752151611, -122.498786325695) | 11 | 6 | 2 | 55 | 26 | |
111117 | 120170 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2115 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5988998.98639 | 2111212.7958 | 37.7763532490624 | -122.481586377549 | (37.7763532490624, -122.481586377549) | 11 | 6 | 2 | 55 | 26 | |||
128844 | 90765 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3951X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5983319.52344 | 2110329.35517 | 37.7735956959806 | -122.501167549589 | (37.7735956959806, -122.501167549589) | 11 | 6 | 2 | 55 | 26 | ||
147117 | 90786 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3651 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984230.45275 | 2110360.76329 | 37.7737353827795 | -122.498018876374 | (37.7737353827795, -122.498018876374) | 11 | 6 | 2 | 55 | 26 | ||
152736 | 90752 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4139 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982690.65097 | 2110306.82408 | 37.7734968836846 | -122.503341209358 | (37.7734968836846, -122.503341209358) | 11 | 6 | 2 | 55 | 26 | ||
157925 | 90777 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3801X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5983752.43476 | 2110343.62278 | 37.7736602824619 | -122.499671122498 | (37.7736602824619, -122.499671122498) | 11 | 6 | 2 | 55 | 26 | ||
159956 | 90694 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4046 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983004.67089 | 2110371.95797 | 37.7736941772479 | -122.50225980754 | (37.7736941772479, -122.50225980754) | 11 | 6 | 2 | 55 | 26 | ||
162103 | 90750 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4243 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982406.47027 | 2110295.07338 | 37.7734479099147 | -122.504323344648 | (37.7734479099147, -122.504323344648) | 11 | 6 | 2 | 55 | 26 | ||
166111 | 90659 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3500X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984771.763559 | 2110427.714833 | 37.7739509343258 | -122.496151365888 | (37.7739509343258, -122.496151365888) | 11 | 6 | 2 | 55 | 26 | |
173406 | 122030 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 791 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5990356.68598 | 2110010.07931 | 37.7731297724256 | -122.476801870398 | (37.7731297724256, -122.476801870398) | 11 | 6 | 2 | 55 | 26 | |||
180739 | 90771 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3899X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5983556.085422 | 2110343.567935 | 37.7736486085903 | -122.500350310129 | (37.7736486085903, -122.500350310129) | 11 | 6 | 2 | 55 | 26 | ||
187610 | 90795 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3549 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984543.28157 | 2110372.68453 | 37.7737864510326 | -122.49693764881 | (37.7737864510326, -122.49693764881) | 11 | 6 | 2 | 55 | 26 | ||
188401 | 90801 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3501 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984688.13003 | 2110377.25228 | 37.7738074794593 | -122.496436939549 | (37.7738074794593, -122.496436939549) | 11 | 6 | 2 | 55 | 26 | ||
194047 | 90783 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3701X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984061.67765 | 2110354.79455 | 37.7737090977378 | -122.498602245888 | (37.7737090977378, -122.498602245888) | 11 | 6 | 2 | 55 | 26 |
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) );