trees
139 rows where SiteOrder = 2 and qSpecies_id = 65 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | ||
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 | |
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 | ||
4556 | 35737 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 351 Hale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | 11 | Permit Number 39011 | 6008822.29863 | 2094308.62612 | 37.7310709363673 | -122.411816979173 | (37.7310709363673, -122.411816979173) | 9 | 3 | 7 | 309 | 28 | |
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 | ||
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 | ||
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 | ||
106863 | 91463 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52106 | 6008009.62404 | 2119930.75783 | 37.8013777126716 | -122.416440749956 | (37.8013777126716, -122.416440749956) | 5 | 1 | 1 | 308 | 32 | |
185739 | 106345 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2428 14th Ave | 2 | Median : Cutout | Tree | Private 2 | 04/18/2014 12:00:00 AM | 3x3 | 5992079 | 2098890.7 | 37.7426986307713 | -122.470034423922 | (37.7426986307713, -122.470034423922) | 1 | 8 | 4 | 29491 | 40 | |||
91379 | 47054 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45042 | 5994940.24503133 | 2097052.6739603 | 37.7378168558175 | -122.460008006142 | (37.7378168558175, -122.460008006142) | 9 | 7 | 4 | 59 | 40 | |||
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 | |
35685 | 99537 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3720 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2012 12:00:00 AM | 3x3 | Permit Number 768635 | 6004924.7 | 2102557.1 | 37.7534999396673 | -122.425878575683 | (37.7534999396673, -122.425878575683) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
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 | |
71978 | 37528 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007265.87204 | 2115633.53426 | 37.789536754768 | -122.418709549719 | (37.789536754768, -122.418709549719) | 13 | 9 | 10 | 28858 | 21 | |
111705 | 74111 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 500X Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1994 12:00:00 AM | 15 | 3x3 | 6003976.59234436 | 2092494.78352221 | 37.7258174919201 | -122.428440184616 | (37.7258174919201, -122.428440184616) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |
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 | |
46915 | 38203 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 691 Goettingen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 14 | Permit Number 40328 | 6010707.71448 | 2091513.67595 | 37.7235021790704 | -122.405102009451 | (37.7235021790704, -122.405102009451) | 10 | 3 | 7 | 309 | 28 | |
182539 | 38225 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1099 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | 13 | Permit Number 40351 | 6014263.22127 | 2102058.4146 | 37.7526539784223 | -122.39354880945 | (37.7526539784223, -122.39354880945) | 10 | 3 | 8 | 28856 | 29 | ||
7501 | 262401 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1X Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/21/2020 12:00:00 AM | 3 | 3x3 | 6004556 | 2094831 | 37.732264993682 | -122.426603497453 | (37.732264993682, -122.426603497453) | 2 | 7 | 7 | 28861 | 2 | ||
13377 | 160452 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001241.76743 | 2090358.86031 | 37.719797591855 | -122.437741350891 | (37.719797591855, -122.437741350891) | 9 | 7 | 6 | 28861 | 5 | ||
6932 | 112764 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997123.4 | 2089342.1 | 37.7167707693614 | -122.45190370908 | (37.7167707693614, -122.45190370908) | 9 | 8 | 6 | 28861 | 24 | ||
19773 | 113547 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2017 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011715.20847 | 2105100.54779 | 37.7608650971692 | -122.40257424272 | (37.7608650971692, -122.40257424272) | 10 | 3 | 8 | 28856 | 29 | ||
19536 | 160455 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001161.40103 | 2090408.94535 | 37.719930544037 | -122.438022734371 | (37.719930544037, -122.438022734371) | 9 | 7 | 6 | 28861 | 5 | ||
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 |
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 | |
175566 | 53159 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1747@ 3RD ST Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | 13 | Permit Number 49080 | 6014484.90518 | 2095154.52732 | 37.7337096578753 | -122.392299359741 | (37.7337096578753, -122.392299359741) | 10 | 3 | 8 | 58 | 1 |
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) );