trees
139 rows where SiteOrder = 2 and qSpecies_id = 65 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
146877 | 203582 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Gennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5997457.41638 | 2093726.64675 | 37.7288288329774 | -122.451065185614 | (37.7288288329774, -122.451065185614) | 9 | 7 | 4 | 28861 | 40 | |||
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 | ||
156296 | 87374 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50353 | 5999085.2 | 2093741.7 | 37.7289632252792 | -122.445438930282 | (37.7289632252792, -122.445438930282) | 9 | 7 | 4 | 28861 | 40 | |||
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 | ||
157942 | 221798 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 430 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004116.67022 | 2110321.94704 | 37.7747746486742 | -122.429226550889 | (37.7747746486742, -122.429226550889) | 7 | 9 | 11 | 28852 | 10 | |||
159587 | 203566 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Colon Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5996063.41122 | 2094232.89601 | 37.7301389635391 | -122.455920909543 | (37.7301389635391, -122.455920909543) | 9 | 7 | 4 | 28861 | 40 | |||
159787 | 203555 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5994968.99544 | 2088379.28856 | 37.7140034838548 | -122.459280689461 | (37.7140034838548, -122.459280689461) | 9 | 8 | 6 | 28861 | 24 | |||
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 | ||
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 |
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 | ||
163162 | 141448 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 194 Beaumont Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5996892.1188 | 2111627.1044 | 37.7779466329687 | -122.454311915058 | (37.7779466329687, -122.454311915058) | 15 | 6 | 2 | 54 | 16 | |||
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 | |
167184 | 221846 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6004388.2708 | 2095606.1808 | 37.7343839821397 | -122.427238573395 | (37.7343839821397, -122.427238573395) | 2 | 7 | 5 | 28861 | 25 | |||
171813 | 35138 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 832 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 9 | Permit Number 38668 | 6001976.8462 | 2088896.96126 | 37.7158253124776 | -122.435095942923 | (37.7158253124776, -122.435095942923) | 9 | 7 | 6 | 28861 | 5 | |
172746 | 256165 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | ||||
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 | |||
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 | |
179502 | 221830 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2451 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6008241.38226 | 2104159.63616 | 37.7580870167112 | -122.414522128209 | (37.7580870167112, -122.414522128209) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |
184312 | 183416 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2685 22nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5989557.6977 | 2097079.8204 | 37.7375803497092 | -122.478619864368 | (37.7375803497092, -122.478619864368) | 1 | 8 | 3 | 29491 | 35 | |||
185738 | 139916 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1000 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004814.4523 | 2112350.3862 | 37.7803837224117 | -122.426957277261 | (37.7803837224117, -122.426957277261) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
186130 | 221808 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3720 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004922.45206 | 2102542.08461 | 37.753458583869 | -122.425885280803 | (37.753458583869, -122.425885280803) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
188048 | 175198 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 648 Peru Ave | 2 | Side Yard : Yard | Tree | Private 2 | 12 | 6005048.079 | 2092617.03467 | 37.7262137420546 | -122.424744822616 | (37.7262137420546, -122.424744822616) | 9 | 7 | 6 | 28861 | 5 | ||||
188123 | 248074 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 440 Holladay Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6010189.61639 | 2098448.43347 | 37.742514572897 | -122.407381643363 | (37.742514572897, -122.407381643363) | 10 | 7 | 7 | 28859 | 2 | |||
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 | ||
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 | |||
191257 | 221925 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 651 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003063.11799 | 2104395.60529 | 37.7584426581259 | -122.432447626582 | (37.7584426581259, -122.432447626582) | 2 | 4 | 5 | 28862 | 3 | |||
192627 | 221915 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 476 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003301.60957 | 2102160.71382 | 37.7523196977161 | -122.431463273608 | (37.7523196977161, -122.431463273608) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
194442 | 221796 | Prune Opt Out 3 | Agonis flexuosa :: Peppermint Willow 65 | 436 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | Permit Number 787981 | 6004110.94859 | 2110346.00561 | 37.7748403836965 | -122.429248059072 | (37.7748403836965, -122.429248059072) | 7 | 9 | 11 | 28852 | 10 |
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) );