trees
139 rows where SiteOrder = 2 and qSpecies_id = 65 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |
88120 | 38113 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1296 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 9 | Permit Number 40278 | 5987108.7979 | 2106493.9222 | 37.7632864483052 | -122.487778208637 | (37.7632864483052, -122.487778208637) | 1 | 8 | 3 | 56 | 35 | |
162088 | 109283 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1530 Sloat Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) | 1 | 8 | 3 | 64 | 35 |
179876 | 181650 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1265 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5986125.2828 | 2106621.5286 | 37.7635794036098 | -122.49118920801 | (37.7635794036098, -122.49118920801) | 1 | 8 | 3 | 56 | 35 | |||
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 | |
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | |
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 | ||
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 | |||
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 | ||
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 | ||
101240 | 44243 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4005 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | 12 | Permit Number 43678 | 5983313.0175 | 2106265.8208 | 37.7624380119611 | -122.500889481832 | (37.7624380119611, -122.500889481832) | 1 | 8 | 3 | 56 | 35 | ||
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 | ||
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 | ||
16950 | 261148 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3220x Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982825 | 2099474 | 37.7437609086011 | -122.502074725774 | (37.7437609086011, -122.502074725774) | 1 | 8 | 3 | 29491 | 35 | ||||
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 | ||
15715 | 70376 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1434 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 5982801.126 | 2105356.1278 | 37.7599101850833 | -122.502592561024 | (37.7599101850833, -122.502592561024) | 1 | 8 | 3 | 56 | 35 | |||
77208 | 37072 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1426 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 14 | Permit Number 39847 | 5982799.9219 | 2105403.4894 | 37.7600401558558 | -122.502600230953 | (37.7600401558558, -122.502600230953) | 1 | 8 | 3 | 56 | 35 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
41585 | 37085 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1487 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 13 | Permit Number 39685 | 5982149.7032 | 2104986.8677 | 37.7588580004754 | -122.504818115198 | (37.7588580004754, -122.504818115198) | 1 | 8 | 3 | 56 | 35 | ||
109884 | 183265 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1249 46th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5981784.0294 | 2106586.8909 | 37.7632296873576 | -122.506201404659 | (37.7632296873576, -122.506201404659) | 1 | 8 | 3 | 56 | 35 |
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) );