trees
614 rows where qSpecies_id = 29 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2794 | 254529 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 421 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769845 | ||||||||||
4016 | 52794 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
5667 | 52792 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
11431 | 35742 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 39016 | ||||||||||||||
13707 | 35743 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 39016 | ||||||||||||||
13860 | 52793 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
171729 | 183281 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1267 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5981168.1745 | 2106457.5745 | 37.762838347579 | -122.508321804919 | (37.762838347579, -122.508321804919) | 1 | 8 | 3 | 56 | 35 | |||
26771 | 83492 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2040 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50186 | 5981220.21812771 | 2101179.004699 | 37.7483479647664 | -122.50775007916 | (37.7483479647664, -122.50775007916) | 1 | 8 | 3 | 29491 | 35 | ||
41119 | 184434 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3816 Quintara St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981590.8846 | 2100821.8038 | 37.7473890220179 | -122.506441860059 | (37.7473890220179, -122.506441860059) | 1 | 8 | 3 | 29491 | 35 | |||
120651 | 69026 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3826 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | Permit Number 33030 | 5981605.36463184 | 2100817.40426398 | 37.7473777946481 | -122.506391463775 | (37.7473777946481, -122.506391463775) | 1 | 8 | 3 | 29491 | 35 | ||
93551 | 52639 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1634 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2006 12:00:00 AM | 3 | Permit Number 48720 | 5981612.27437325 | 2103952.63979264 | 37.7559866741692 | -122.506600058306 | (37.7559866741692, -122.506600058306) | 1 | 8 | 3 | 56 | 35 | |
157507 | 184430 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3808 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5981643.6784 | 2100823.1575 | 37.747395847078 | -122.506259406281 | (37.747395847078, -122.506259406281) | 1 | 8 | 3 | 29491 | 35 | |||
95168 | 69021 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2095 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | Permit Number 33025 | 5981665.37116425 | 2100840.03174895 | 37.7474434561007 | -122.506185646516 | (37.7474434561007, -122.506185646516) | 1 | 8 | 3 | 29491 | 35 | ||
43394 | 92109 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 654 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52365 | 5981669.51861 | 2111284.19832 | 37.7761203861627 | -122.506945906937 | (37.7761203861627, -122.506945906937) | 11 | 6 | 2 | 55 | 26 | |
21474 | 183295 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1262 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981829.8203 | 2106490.9182 | 37.7629688694519 | -122.506035915679 | (37.7629688694519, -122.506035915679) | 1 | 8 | 3 | 56 | 35 | |||
24081 | 118563 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 8000 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5982185.81739 | 2112405.54556 | 37.7792296683273 | -122.505243048821 | (37.7792296683273, -122.505243048821) | 11 | 6 | 2 | 55 | 26 | |||
140926 | 184399 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2085 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5982287.3567 | 2100926.0377 | 37.7477162005877 | -122.504041267675 | (37.7477162005877, -122.504041267675) | 1 | 8 | 3 | 29491 | 35 | |||
69393 | 184400 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2087 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5982288.7103 | 2100911.824 | 37.747677253327 | -122.504035534429 | (37.747677253327, -122.504035534429) | 1 | 8 | 3 | 29491 | 35 | |||
141597 | 184401 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2089 45th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982289.7256 | 2100897.9487 | 37.7476392153239 | -122.504030996054 | (37.7476392153239, -122.504030996054) | 1 | 8 | 3 | 29491 | 35 | |||
123870 | 184402 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2091 45th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982290.4025 | 2100883.0582 | 37.7475983699641 | -122.504027552646 | (37.7475983699641, -122.504027552646) | 1 | 8 | 3 | 29491 | 35 | |||
48554 | 69006 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2111 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 3 | Permit Number 33007 | 5982290.62244002 | 2100729.28975496 | 37.7471761775601 | -122.504015404359 | (37.7471761775601, -122.504015404359) | 1 | 8 | 3 | 29491 | 35 | |
42922 | 69007 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2115 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 0 | Permit Number 33008 | 5982291.49205895 | 2100703.22551621 | 37.7471046635524 | -122.504010467091 | (37.7471046635524, -122.504010467091) | 1 | 8 | 3 | 29491 | 35 | |
127172 | 184437 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2115 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5982295.3096 | 2100678.1438 | 37.7470360206297 | -122.503995409104 | (37.7470360206297, -122.503995409104) | 1 | 8 | 3 | 29491 | 35 | |||
92149 | 87934 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3600 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309 | 2100840 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | 1 | 8 | 3 | 29491 | 35 | ||
100414 | 87936 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3600 Quintara St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309 | 2100840 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | 1 | 8 | 3 | 29491 | 35 | ||
187916 | 87935 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3600 Quintara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309 | 2100840 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | 1 | 8 | 3 | 29491 | 35 | ||
30102 | 184465 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2182 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5982354.8718 | 2100269.3302 | 37.7459170344363 | -122.503759179813 | (37.7459170344363, -122.503759179813) | 1 | 8 | 3 | 29491 | 35 | |||
85029 | 47745 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4201 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2002 12:00:00 AM | 5 | Permit Number 45527 | 5982377.51547 | 2113061.47559 | 37.7810419369254 | -122.50462850954 | (37.7810419369254, -122.50462850954) | 11 | 6 | 2 | 55 | 26 | |
134252 | 47746 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4201 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2002 12:00:00 AM | 6 | Permit Number 45527 | 5982405.06542 | 2113061.42324 | 37.7810434137217 | -122.504533198292 | (37.7810434137217, -122.504533198292) | 11 | 6 | 2 | 55 | 26 | |
167181 | 47743 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4201 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2002 12:00:00 AM | 6 | Permit Number 45527 | 5982418.5702 | 2113061.40286 | 37.7810441521097 | -122.50448647782 | (37.7810441521097, -122.50448647782) | 11 | 6 | 2 | 55 | 26 | |
192605 | 47744 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4201 Clement St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2002 12:00:00 AM | 5 | Permit Number 45527 | 5982434.29257 | 2113064.02501 | 37.7810522765206 | -122.504432281557 | (37.7810522765206, -122.504432281557) | 11 | 6 | 2 | 55 | 26 | |
69114 | 122462 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1351 42nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | 1 | 8 | 3 | 56 | 35 | ||||
70518 | 183218 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3150 Rivera St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5983331.3887 | 2100197.9386 | 37.7457783815563 | -122.500377295432 | (37.7457783815563, -122.500377295432) | 1 | 8 | 3 | 29491 | 35 | |||
162097 | 183217 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3150 Rivera St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5983341.801 | 2100199.14 | 37.7457822914528 | -122.500341380582 | (37.7457822914528, -122.500341380582) | 1 | 8 | 3 | 29491 | 35 | |||
86413 | 69147 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2474 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50209 | 5983357.92346724 | 2098305.86052221 | 37.7405848112735 | -122.500145694224 | (37.7405848112735, -122.500145694224) | 1 | 8 | 3 | 29491 | 35 | |
64703 | 183216 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3150 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983362.6255 | 2100199.941 | 37.7457857131054 | -122.500269432817 | (37.7457857131054, -122.500269432817) | 1 | 8 | 3 | 29491 | 35 | |||
23177 | 29219 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1902X 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
29332 | 40197 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4845 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983545.15866 | 2111697.12052 | 37.7773644306872 | -122.500488206744 | (37.7773644306872, -122.500488206744) | 11 | 6 | 2 | 55 | 26 | |
12126 | 184960 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1990 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983549.8392 | 2101614.3877 | 37.7496803803898 | -122.499726609203 | (37.7496803803898, -122.499726609203) | 1 | 8 | 3 | 29491 | 35 | |||
116165 | 40198 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4845 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1999 12:00:00 AM | 4 | Permit Number 41381 | 5983564.00887 | 2111698.10643 | 37.7773682442298 | -122.500423071675 | (37.7773682442298, -122.500423071675) | 11 | 6 | 2 | 55 | 26 | |
6569 | 82802 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 770 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52410 | 5983565.30013547 | 2110567.26400669 | 37.7742633542941 | -122.500334977362 | (37.7742633542941, -122.500334977362) | 11 | 6 | 2 | 55 | 26 | ||
124450 | 72276 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 770 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52410 | 5983565.30013547 | 2110567.26400669 | 37.7742633542941 | -122.500334977362 | (37.7742633542941, -122.500334977362) | 11 | 6 | 2 | 55 | 26 | ||
30433 | 40199 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4845 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983584.60152 | 2111699.05511 | 37.7773720577908 | -122.500351906273 | (37.7773720577908, -122.500351906273) | 11 | 6 | 2 | 55 | 26 | |
15733 | 64781 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3801 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | 4 | Permit Number 25773 | 5983728.64713 | 2111021.26009 | 37.7755194830569 | -122.499803502734 | (37.7755194830569, -122.499803502734) | 11 | 6 | 2 | 55 | 26 | |
72383 | 117792 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3801 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5983744.15991 | 2111021.91382 | 37.7755221883124 | -122.499749889479 | (37.7755221883124, -122.499749889479) | 11 | 6 | 2 | 55 | 26 | |||
178489 | 100234 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 701X 39th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5983811.49615 | 2110876.46915 | 37.7751267903243 | -122.499506209788 | (37.7751267903243, -122.499506209788) | 11 | 6 | 2 | 55 | 26 | |||
188763 | 100236 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 701X 39th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5983814.22353 | 2110811.15249 | 37.7749476096575 | -122.499491947241 | (37.7749476096575, -122.499491947241) | 11 | 6 | 2 | 55 | 26 | |||
66246 | 100238 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 701X 39th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5983814.58777 | 2110777.43528 | 37.7748550533025 | -122.499488194975 | (37.7748550533025, -122.499488194975) | 11 | 6 | 2 | 55 | 26 | |||
163298 | 117837 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 660x 39th Ave | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 6ft | 5983820.01458 | 2111273.23439 | 37.7762166927907 | -122.499506071449 | (37.7762166927907, -122.499506071449) | 11 | 6 | 2 | 55 | 26 | |||
123353 | 69045 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1490 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 5 | Permit Number 33052 | 5984059.2399452 | 2105030.87804217 | 37.7590909914126 | -122.498217402727 | (37.7590909914126, -122.498217402727) | 1 | 8 | 3 | 56 | 35 | |
83782 | 69150 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3826 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | 4 | Permit Number 33185 | 5984181.23627049 | 2098183.21295551 | 37.7402963417492 | -122.497289988005 | (37.7402963417492, -122.497289988005) | 1 | 8 | 3 | 29491 | 35 | |
145084 | 69041 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1481 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 2 | Permit Number 33048 | 5984315.00463023 | 2105104.8689211 | 37.7593091431589 | -122.497338322577 | (37.7593091431589, -122.497338322577) | 1 | 8 | 3 | 56 | 35 | |
160928 | 69032 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1306 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | Permit Number 33038 | 5984326.99960905 | 2106268.60698724 | 37.7625051443787 | -122.497382751027 | (37.7625051443787, -122.497382751027) | 1 | 8 | 3 | 56 | 35 | ||
39109 | 186232 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984802.7052 | 2103358.5602 | 37.7545428359635 | -122.495522842112 | (37.7545428359635, -122.495522842112) | 1 | 8 | 3 | 56 | 35 | |||
67379 | 186234 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984803.2409 | 2103355.3462 | 37.7545340425765 | -122.495520752512 | (37.7545340425765, -122.495520752512) | 1 | 8 | 3 | 56 | 35 | |||
76259 | 186237 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984808.8655 | 2103347.0431 | 37.7545115739121 | -122.495500689099 | (37.7545115739121, -122.495500689099) | 1 | 8 | 3 | 56 | 35 | |||
44625 | 186236 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984809.6691 | 2103350.7929 | 37.7545219168817 | -122.495498186629 | (37.7545219168817, -122.495498186629) | 1 | 8 | 3 | 56 | 35 | |||
136891 | 185413 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2300 Sunset Blvd | 29 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 5985092.6382 | 2099208.8841 | 37.7431659316065 | -122.494214350065 | (37.7431659316065, -122.494214350065) | 1 | 8 | 3 | 29491 | 35 | |||
128561 | 185411 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2300 Sunset Blvd | 26 | unknown : Yard | Tree | Private 2 | 10 | Width 0ft | 5985100.1361 | 2099184.3909 | 37.7430991186582 | -122.494186619786 | (37.7430991186582, -122.494186619786) | 1 | 8 | 3 | 29491 | 35 | |||
190642 | 117962 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4340 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5985111.43248 | 2111810.6865 | 37.7777680685843 | -122.495078411045 | (37.7777680685843, -122.495078411045) | 11 | 6 | 2 | 55 | 26 | |||
158750 | 43062 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 490 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 51464 | 5985348.18764 | 2112571.67351 | 37.7798713777573 | -122.494315512324 | (37.7798713777573, -122.494315512324) | 11 | 6 | 2 | 55 | 26 | |
28313 | 32595 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1383 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 2 | Permit Number 37063 | 5985531.94877095 | 2105814.83097448 | 37.7613297510328 | -122.493181901529 | (37.7613297510328, -122.493181901529) | 1 | 8 | 3 | 56 | 35 | |
16920 | 78303 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4200 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5985601.84615 | 2111830.05832 | 37.7778499560934 | -122.493383352985 | (37.7778499560934, -122.493383352985) | 11 | 6 | 2 | 55 | 26 | |||
2638 | 32596 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1474 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 2 | Permit Number 37064 | 5985605.53989408 | 2105188.12612078 | 37.7596132973579 | -122.492881221287 | (37.7596132973579, -122.492881221287) | 1 | 8 | 3 | 56 | 35 | |
25363 | 32597 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1478 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 2 | Permit Number 37065 | 5985606.43921528 | 2105161.9851204 | 37.759541574007 | -122.492876185531 | (37.759541574007, -122.492876185531) | 1 | 8 | 3 | 56 | 35 | |
31605 | 118182 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 615 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985646.49411 | 2111667.23632 | 37.7774055049593 | -122.493216904169 | (37.7774055049593, -122.493216904169) | 11 | 6 | 2 | 55 | 26 | |||
16441 | 32611 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2926 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 0 | Permit Number 37076 | 5985807.8579886 | 2105043.58172562 | 37.7592282476447 | -122.492170870983 | (37.7592282476447, -122.492170870983) | 1 | 8 | 3 | 56 | 35 | |
67236 | 33177 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3245 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 4 | 3.5x5 | Permit Number 37389 | 5985988.52360796 | 2098193.06286983 | 37.7404291431182 | -122.491041921171 | (37.7404291431182, -122.491041921171) | 1 | 8 | 3 | 29491 | 35 |
82746 | 32576 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1366 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 2 | Permit Number 37050 | 5986201.05883385 | 2105941.9596711 | 37.7617179230551 | -122.49087711798 | (37.7617179230551, -122.49087711798) | 1 | 8 | 3 | 56 | 35 | |
46450 | 69309 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1554 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1994 12:00:00 AM | 3 | Permit Number 33388 | 5986865.46516485 | 2104681.03924788 | 37.7582945739882 | -122.488486559119 | (37.7582945739882, -122.488486559119) | 1 | 8 | 3 | 56 | 35 | |
100773 | 42275 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1522 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | 4 | Permit Number 42512 | 5987167.45157267 | 2104900.21174724 | 37.7589139779601 | -122.48745827105 | (37.7589139779601, -122.48745827105) | 1 | 8 | 3 | 56 | 35 | ||
181412 | 42274 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1522 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 5 | Permit Number 42512 | 5987167.45157267 | 2104900.21174724 | 37.7589139779601 | -122.48745827105 | (37.7589139779601, -122.48745827105) | 1 | 8 | 3 | 56 | 35 | |
184309 | 30907 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2363 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 4 | Permit Number 37373 | 5987310.2980544 | 2099201.63941585 | 37.7432755629796 | -122.486545838163 | (37.7432755629796, -122.486545838163) | 1 | 8 | 3 | 29491 | 35 | |
17790 | 181349 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2254 29th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5987333.026 | 2099936.24 | 37.7452939056167 | -122.486521176816 | (37.7452939056167, -122.486521176816) | 1 | 8 | 3 | 29491 | 35 | |||
127551 | 181948 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1813 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5987556.2457 | 2098923.5959 | 37.7425264630708 | -122.485675024353 | (37.7425264630708, -122.485675024353) | 1 | 8 | 3 | 29491 | 35 | |||
167694 | 84809 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 648 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2007 12:00:00 AM | 3 | Permit No. 49264 | 5987557.75332 | 2111531.90689 | 37.7771455293989 | -122.486595377302 | (37.7771455293989, -122.486595377302) | 11 | 6 | 2 | 55 | 26 | ||
107202 | 88618 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1815 Taraval St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51591 | 5987609 | 2098941 | 37.7425773238376 | -122.485493894781 | (37.7425773238376, -122.485493894781) | 1 | 8 | 3 | 29491 | 35 | ||
113192 | 34531 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 635 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/1997 12:00:00 AM | 5 | Permit Number 38240 | 5988437.8449 | 2111647.649 | 37.7775145896121 | -122.483559386935 | (37.7775145896121, -122.483559386935) | 11 | 6 | 2 | 55 | 26 | ||
14387 | 181350 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2270 25th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5988575.9018 | 2099879.6972 | 37.7452110255779 | -122.48221942867 | (37.7452110255779, -122.48221942867) | 1 | 8 | 3 | 29491 | 35 | |||
19085 | 70121 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2220 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988662.20068 | 2110577.24438 | 37.7745886129839 | -122.482704814222 | (37.7745886129839, -122.482704814222) | 11 | 6 | 2 | 55 | 26 | |||
2004 | 73758 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2220 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988694.03882 | 2110577.4842 | 37.7745911237516 | -122.482594698718 | (37.7745911237516, -122.482594698718) | 11 | 6 | 2 | 55 | 26 | |||
176877 | 181332 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1458 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5988697.9248 | 2105396.3508 | 37.7603653792146 | -122.482201591019 | (37.7603653792146, -122.482201591019) | 1 | 8 | 3 | 56 | 35 | |||
107142 | 95925 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 467 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767622 | 5988731.71404 | 2112146.6899 | 37.7789019165926 | -122.482579385158 | (37.7789019165926, -122.482579385158) | 11 | 6 | 2 | 55 | 26 |
123129 | 181318 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1283 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5989233.022 | 2106632.6794 | 37.7637911125829 | -122.480441458463 | (37.7637911125829, -122.480441458463) | 1 | 8 | 3 | 56 | 35 | |||
109906 | 181319 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1283 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5989233.7879 | 2106609.7025 | 37.7637280687606 | -122.480437127511 | (37.7637280687606, -122.480437127511) | 1 | 8 | 3 | 56 | 35 | |||
4031 | 73753 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2019 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989295.11737 | 2111227.81825 | 37.7764117112404 | -122.480563089536 | (37.7764117112404, -122.480563089536) | 11 | 6 | 2 | 55 | 26 | |||
18662 | 72377 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2015 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5989328.1004 | 2111226.70664 | 37.776410575889 | -122.480448911859 | (37.776410575889, -122.480448911859) | 11 | 6 | 2 | 55 | 26 | |||
176245 | 42161 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2010 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42456 | 5989367.84309334 | 2111281.28093807 | 37.7765627312838 | -122.480315427669 | (37.7765627312838, -122.480315427669) | 11 | 6 | 2 | 55 | 26 | ||
131353 | 120769 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4500 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5989405.82896 | 2109925.10593 | 37.7728412569544 | -122.480084750137 | (37.7728412569544, -122.480084750137) | 11 | 6 | 2 | 55 | 26 | |||
15577 | 61446 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 167 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2020 12:00:00 AM | 3 | Permit Number 48286 | 5989582.2838 | 2114261.13607 | 37.7847570404878 | -122.479791723267 | (37.7847570404878, -122.479791723267) | 11 | 6 | 2 | 55 | 26 | |
799 | 72078 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 167 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2020 12:00:00 AM | 3 | 5989583.57132 | 2114255.42421 | 37.784741432124 | -122.479786850818 | (37.784741432124, -122.479786850818) | 11 | 6 | 2 | 55 | 26 | ||
127919 | 43234 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1442 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 0 | Permit Number 43021 | 5989629.54713999 | 2105535.31198119 | 37.7608010732857 | -122.478989743073 | (37.7608010732857, -122.478989743073) | 1 | 8 | 3 | 56 | 35 | |
104859 | 101262 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1948 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989728.00904 | 2106533.07201 | 37.7635463706673 | -122.478722183397 | (37.7635463706673, -122.478722183397) | 1 | 8 | 3 | 56 | 35 | ||||
158806 | 38870 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1551 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 2 | Permit Number 43029 | 5989746.74182688 | 2105808.42580632 | 37.7615577752966 | -122.478604396615 | (37.7615577752966, -122.478604396615) | 1 | 8 | 3 | 56 | 35 | |
162949 | 38871 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1551 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/1998 12:00:00 AM | 2 | Permit Number 40696 | 5989746.74182688 | 2105808.42580632 | 37.7615577752966 | -122.478604396615 | (37.7615577752966, -122.478604396615) | 1 | 8 | 3 | 56 | 35 | ||
40073 | 38845 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1333 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40675 | 5989863.06342131 | 2106288.82741716 | 37.7628835816678 | -122.478237218826 | (37.7628835816678, -122.478237218826) | 1 | 8 | 3 | 56 | 35 | ||
101287 | 43231 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1371 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 3 | Permit Number 43018 | 5989871.41437878 | 2106041.52738456 | 37.7622050471688 | -122.478190253838 | (37.7622050471688, -122.478190253838) | 1 | 8 | 3 | 56 | 35 | |
103689 | 43230 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1371 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 3 | Permit Number 43018 | 5989871.41437878 | 2106041.52738456 | 37.7622050471688 | -122.478190253838 | (37.7622050471688, -122.478190253838) | 1 | 8 | 3 | 56 | 35 | |
20373 | 122290 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990062.61204 | 2111318.02169 | 37.7767039596239 | -122.477914733898 | (37.7767039596239, -122.477914733898) | 11 | 6 | 2 | 55 | 26 | |||
52077 | 122289 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990067.41245 | 2111319.50308 | 37.7767083057233 | -122.477898236364 | (37.7767083057233, -122.477898236364) | 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) );