trees
3,267 rows where qSpecies_id = 67 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52823 | 188962 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1738 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014828.18654 | 2096725.40837 | 37.7380420321219 | -122.39122229388 | (37.7380420321219, -122.39122229388) | 10 | 3 | 8 | 58 | 1 | |||
| 65908 | 189009 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1738 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014827.845 | 2096719.03701 | 37.7380245187208 | -122.391223029525 | (37.7380245187208, -122.391223029525) | 10 | 3 | 8 | 58 | 1 | |||
| 66469 | 189008 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1735 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014822.13481 | 2096654.03054 | 37.7378457073978 | -122.391238229874 | (37.7378457073978, -122.391238229874) | 10 | 3 | 8 | 58 | 1 | |||
| 39679 | 188951 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1735 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014820.98612 | 2096656.00943 | 37.7378510772752 | -122.391242339775 | (37.7378510772752, -122.391242339775) | 10 | 3 | 8 | 58 | 1 | |||
| 113436 | 199833 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1601 Wallace Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6014729.9394 | 2092880.6426 | 37.7274796328345 | -122.391293298814 | (37.7274796328345, -122.391293298814) | 10 | 3 | 8 | 58 | 1 | |||
| 130473 | 189007 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1739 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014800.47126 | 2096669.79143 | 37.7378877812889 | -122.39131423337 | (37.7378877812889, -122.39131423337) | 10 | 3 | 8 | 58 | 1 | |||
| 67730 | 189006 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1742 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014800.84328 | 2096742.56697 | 37.73808762863 | -122.391318032994 | (37.73808762863, -122.391318032994) | 10 | 3 | 8 | 58 | 1 | |||
| 157731 | 188950 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1739 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014798.53304 | 2096673.37347 | 37.7378975092664 | -122.391321185129 | (37.7378975092664, -122.391321185129) | 10 | 3 | 8 | 58 | 1 | |||
| 37109 | 188963 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1742 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014798.75794 | 2096747.77521 | 37.7381018136532 | -122.39132560709 | (37.7381018136532, -122.39132560709) | 10 | 3 | 8 | 58 | 1 | |||
| 44455 | 99400 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2201X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768917 | 6014717 | 2092863 | 37.7274304716685 | -122.391336797962 | (37.7274304716685, -122.391336797962) | 10 | 3 | 8 | 58 | 1 | |
| 63918 | 189005 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1746 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014786.72658 | 2096751.06079 | 37.7381101674427 | -122.391367435462 | (37.7381101674427, -122.391367435462) | 10 | 3 | 8 | 58 | 1 | |||
| 25457 | 189004 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1743 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014780.96102 | 2096683.31962 | 37.7379238441057 | -122.391382635804 | (37.7379238441057, -122.391382635804) | 10 | 3 | 8 | 58 | 1 | |||
| 139453 | 188964 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1746 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014781.8509 | 2096758.64006 | 37.7381307079579 | -122.391384822955 | (37.7381307079579, -122.391384822955) | 10 | 3 | 8 | 58 | 1 | |||
| 88171 | 188949 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1743 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014778.43205 | 2096687.06655 | 37.7379339920459 | -122.391391641629 | (37.7379339920459, -122.391391641629) | 10 | 3 | 8 | 58 | 1 | |||
| 134018 | 199831 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1611 Wallace Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014689.1314 | 2092911.7053 | 37.7275626599151 | -122.391436544053 | (37.7275626599151, -122.391436544053) | 10 | 3 | 8 | 58 | 1 | |||
| 61231 | 200761 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1600 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6014709.9165 | 2094018.3408 | 37.7306024118465 | -122.391442020299 | (37.7306024118465, -122.391442020299) | 10 | 3 | 8 | 58 | 1 | |||
| 91252 | 189003 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1747 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014760.40732 | 2096699.60508 | 37.7379674198647 | -122.391454838795 | (37.7379674198647, -122.391454838795) | 10 | 3 | 8 | 58 | 1 | |||
| 28379 | 188948 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1747 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014759.80068 | 2096701.45444 | 37.7379724641572 | -122.391457065516 | (37.7379724641572, -122.391457065516) | 10 | 3 | 8 | 58 | 1 | |||
| 156554 | 199840 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2299 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014663.7903 | 2092751.8046 | 37.7271221981368 | -122.391512974974 | (37.7271221981368, -122.391512974974) | 10 | 3 | 8 | 58 | 1 | |||
| 189360 | 189001 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1754 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014744.02673 | 2096786.40007 | 37.7382048318912 | -122.391517541304 | (37.7382048318912, -122.391517541304) | 10 | 3 | 8 | 58 | 1 | |||
| 93976 | 188965 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1754 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014743.47747 | 2096789.17091 | 37.7382124095618 | -122.391519634049 | (37.7382124095618, -122.391519634049) | 10 | 3 | 8 | 58 | 1 | |||
| 189200 | 200760 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1608 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6014687.6777 | 2094034.6929 | 37.7306460770704 | -122.391520046563 | (37.7306460770704, -122.391520046563) | 10 | 3 | 8 | 58 | 1 | |||
| 161159 | 189002 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1751 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014734.97611 | 2096719.27261 | 37.7380200113206 | -122.391544142355 | (37.7380200113206, -122.391544142355) | 10 | 3 | 8 | 58 | 1 | |||
| 115216 | 188947 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1751 La Salle Ave | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6014734.22474 | 2096720.3313 | 37.7380228765606 | -122.391546814229 | (37.7380228765606, -122.391546814229) | 10 | 3 | 8 | 58 | 1 | |||
| 178315 | 199841 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2299 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6014644.1635 | 2092727.4403 | 37.7270542092526 | -122.391579122463 | (37.7270542092526, -122.391579122463) | 10 | 3 | 8 | 58 | 1 | |||
| 172819 | 189000 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1758 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014726.1313 | 2096798.25376 | 37.7382363863881 | -122.391580243831 | (37.7382363863881, -122.391580243831) | 10 | 3 | 8 | 58 | 1 | |||
| 115173 | 188966 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1758 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014724.06467 | 2096802.26386 | 37.7382472825865 | -122.391587669559 | (37.7382472825865, -122.391587669559) | 10 | 3 | 8 | 58 | 1 | |||
| 69465 | 188999 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1762 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014713.69596 | 2096808.35553 | 37.7382634335195 | -122.391623945508 | (37.7382634335195, -122.391623945508) | 10 | 3 | 8 | 58 | 1 | |||
| 144464 | 188967 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1762 La Salle Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6014711.29129 | 2096810.32377 | 37.7382687044232 | -122.391632397311 | (37.7382687044232, -122.391632397311) | 10 | 3 | 8 | 58 | 1 | |||
| 186829 | 199839 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2299 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6014608 | 2092714 | 37.7270152974991 | -122.39170320083 | (37.7270152974991, -122.39170320083) | 10 | 3 | 8 | 58 | 1 | |||
| 150498 | 188998 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1763 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014675.4243 | 2096763.70844 | 37.7381387173342 | -122.391753150211 | (37.7381387173342, -122.391753150211) | 10 | 3 | 8 | 58 | 1 | |||
| 74342 | 188971 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1763 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014673.94986 | 2096765.72011 | 37.7381441591176 | -122.391758388748 | (37.7381441591176, -122.391758388748) | 10 | 3 | 8 | 58 | 1 | |||
| 154372 | 199842 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1600 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6014590.4616 | 2092707.6658 | 37.7269969314771 | -122.391763388572 | (37.7269969314771, -122.391763388572) | 10 | 3 | 8 | 58 | 1 | |||
| 79104 | 188968 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1770 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014669.82562 | 2096841.0987 | 37.7383509042781 | -122.391777917528 | (37.7383509042781, -122.391777917528) | 10 | 3 | 8 | 58 | 1 | |||
| 19471 | 188996 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1770 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014669.28207 | 2096840.44612 | 37.7383490822538 | -122.391779751256 | (37.7383490822538, -122.391779751256) | 10 | 3 | 8 | 58 | 1 | |||
| 129384 | 188997 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1767 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014660.79146 | 2096773.85465 | 37.7381657644348 | -122.391804452922 | (37.7381657644348, -122.391804452922) | 10 | 3 | 8 | 58 | 1 | |||
| 89129 | 188970 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1767 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014660.08395 | 2096773.80214 | 37.7381655809769 | -122.391806895488 | (37.7381655809769, -122.391806895488) | 10 | 3 | 8 | 58 | 1 | |||
| 42814 | 199837 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1610 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014558.1807 | 2092735.0741 | 37.7270703971337 | -122.391876899677 | (37.7270703971337, -122.391876899677) | 10 | 3 | 8 | 58 | 1 | |||
| 170078 | 188995 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1778 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014630.30597 | 2096869.69067 | 37.7384272180298 | -122.391916557016 | (37.7384272180298, -122.391916557016) | 10 | 3 | 8 | 58 | 1 | |||
| 93354 | 188969 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1778 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014628.04346 | 2096874.23861 | 37.7384395801299 | -122.391924697674 | (37.7384395801299, -122.391924697674) | 10 | 3 | 8 | 58 | 1 | |||
| 124139 | 199836 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1614 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014539.2994 | 2092746.6465 | 37.7271011243984 | -122.39194298147 | (37.7271011243984, -122.39194298147) | 10 | 3 | 8 | 58 | 1 | |||
| 56699 | 199835 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1618 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6014514.9365 | 2092765.5277 | 37.7271516157866 | -122.392028524189 | (37.7271516157866, -122.392028524189) | 10 | 3 | 8 | 58 | 1 | |||
| 32014 | 199834 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1622 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6014497.2734 | 2092780.1455 | 37.7271907726593 | -122.39209060766 | (37.7271907726593, -122.39209060766) | 10 | 3 | 8 | 58 | 1 | |||
| 29278 | 188994 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1791 La Salle Ave | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6014563.36259 | 2096847.51308 | 37.7383626062416 | -122.392146465983 | (37.7383626062416, -122.392146465983) | 10 | 3 | 8 | 58 | 1 | |||
| 97228 | 199832 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1626 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014478.3921 | 2092792.327 | 37.7272231722699 | -122.392156732228 | (37.7272231722699, -122.392156732228) | 10 | 3 | 8 | 58 | 1 | |||
| 3736 | 38554 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1791 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40521 | 6014548.21389 | 2096859.31136 | 37.7383941607708 | -122.392199668106 | (37.7383941607708, -122.392199668106) | 10 | 3 | 8 | 58 | 1 | |
| 56439 | 199830 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1634 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014434.5388 | 2092823.9988 | 37.7273077016708 | -122.392310548197 | (37.7273077016708, -122.392310548197) | 10 | 3 | 8 | 58 | 1 | |||
| 60912 | 89040 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 87196 | 89041 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 128724 | 89039 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 146725 | 89038 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 152630 | 89037 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 76028 | 199829 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1650 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6014353.5321 | 2092886.1242 | 37.7274737870264 | -122.392594934236 | (37.7274737870264, -122.392594934236) | 10 | 3 | 8 | 58 | 1 | |||
| 104014 | 199828 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1654 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6014338.3053 | 2092896.4785 | 37.7275013721939 | -122.392648297782 | (37.7275013721939, -122.392648297782) | 10 | 3 | 8 | 58 | 1 | |||
| 52861 | 44282 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1588 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2001 12:00:00 AM | Permit Number 43704 | 6014189.45600011 | 2095460.4720274 | 37.7345333093335 | -122.393342225003 | (37.7345333093335, -122.393342225003) | 10 | 3 | 8 | 58 | 1 | |||
| 21349 | 200220 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1151 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014047.4712 | 2090254.411 | 37.7202306272165 | -122.393468896776 | (37.7202306272165, -122.393468896776) | 10 | 3 | 8 | 58 | 1 | |||
| 100688 | 122718 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 472 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6014329.5757 | 2104932.99379 | 37.760550641114 | -122.393520505067 | (37.760550641114, -122.393520505067) | 10 | 3 | 8 | 28856 | 29 | |||
| 176776 | 116121 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1649x Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 2x2 | 6014089.22572 | 2095251.14899 | 37.7339529820313 | -122.393674111091 | (37.7339529820313, -122.393674111091) | 10 | 3 | 8 | 58 | 1 | |||
| 45861 | 202030 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1327 Fitzgerald Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6013974.71046 | 2090993.7917 | 37.7222567763217 | -122.393772134473 | (37.7222567763217, -122.393772134473) | 10 | 3 | 8 | 58 | 1 | |||
| 131166 | 54149 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 34 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 22 | Permit Number 9884 | 6013977.76426 | 2095493.9516 | 37.7346134738323 | -122.394076462386 | (37.7346134738323, -122.394076462386) | 10 | 3 | 8 | 58 | 1 | ||
| 9504 | 74038 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 25th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014092.75077 | 2101968.09189 | 37.7523964980076 | -122.394132008099 | (37.7523964980076, -122.394132008099) | 10 | 3 | 8 | 28856 | 1 | |||
| 28748 | 188256 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013789.26124 | 2089763.61893 | 37.7188686596462 | -122.394327104323 | (37.7188686596462, -122.394327104323) | 10 | 3 | 8 | 58 | 1 | ||||
| 121206 | 54562 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 602 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | 12 | Permit Number 10357 | 6014081.86268 | 2104331.94861 | 37.7588865346901 | -122.394335154162 | (37.7588865346901, -122.394335154162) | 10 | 3 | 8 | 28856 | 29 | ||
| 143096 | 188255 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6013785.15628 | 2089757.61987 | 37.718851959233 | -122.394340873848 | (37.718851959233, -122.394340873848) | 10 | 3 | 8 | 58 | 1 | ||||
| 13274 | 188254 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013780.02718 | 2089753.49239 | 37.7188403408752 | -122.39435831441 | (37.7188403408752, -122.39435831441) | 10 | 3 | 8 | 58 | 1 | ||||
| 100463 | 188253 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6013773.56946 | 2089775.5723 | 37.7189006089484 | -122.394382181502 | (37.7189006089484, -122.394382181502) | 10 | 3 | 8 | 58 | 1 | ||||
| 62000 | 188252 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6013770.43233 | 2089778.01595 | 37.7189071443355 | -122.394393196412 | (37.7189071443355, -122.394393196412) | 10 | 3 | 8 | 58 | 1 | ||||
| 47417 | 188251 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6013763.34518 | 2089782.1261 | 37.7189180360183 | -122.394417981716 | (37.7189180360183, -122.394417981716) | 10 | 3 | 8 | 58 | 1 | ||||
| 54574 | 54441 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 516 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/1972 12:00:00 AM | 12 | Permit Number 10218 | 6014063.35386 | 2104670.62124 | 37.7598154273534 | -122.394422880319 | (37.7598154273534, -122.394422880319) | 10 | 3 | 8 | 28856 | 29 | ||
| 44986 | 54440 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 512 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/1972 12:00:00 AM | 25 | Permit Number 10217 | 6014062.04664 | 2104690.51395 | 37.7598699757444 | -122.394428794276 | (37.7598699757444, -122.394428794276) | 10 | 3 | 8 | 28856 | 29 | ||
| 185550 | 188250 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6013748.16101 | 2089779.78907 | 37.7189107748964 | -122.394470304261 | (37.7189107748964, -122.394470304261) | 10 | 3 | 8 | 58 | 1 | ||||
| 87723 | 188909 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 Mississippi St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 6014064.59876 | 2105675.24732 | 37.7625739808237 | -122.394488921123 | (37.7625739808237, -122.394488921123) | 10 | 3 | 8 | 28856 | 29 | |||
| 175699 | 188910 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 320 Mississippi St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014009.96663 | 2105613.02581 | 37.7624000969141 | -122.394673517794 | (37.7624000969141, -122.394673517794) | 10 | 3 | 8 | 28856 | 29 | |||
| 193688 | 200144 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1351 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6013679.8971 | 2090868.8737 | 37.7218973889739 | -122.394782497653 | (37.7218973889739, -122.394782497653) | 10 | 3 | 8 | 58 | 1 | |||
| 125991 | 66267 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 948 Key Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1990 12:00:00 AM | 4 | Permit Number 29374 | 6013650.54179 | 2089569.78312 | 37.7183287129789 | -122.394793038594 | (37.7183287129789, -122.394793038594) | 10 | 3 | 8 | 58 | 1 | ||
| 24776 | 188249 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 950 Key Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013627.87026 | 2089584.47389 | 37.718367790327 | -122.394872433433 | (37.718367790327, -122.394872433433) | 10 | 3 | 8 | 58 | 1 | |||
| 23515 | 188900 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1336 20th St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6013884.30991 | 2104803.71969 | 37.7601709320582 | -122.395051432701 | (37.7601709320582, -122.395051432701) | 10 | 3 | 8 | 28856 | 29 | |||
| 105729 | 102246 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 337 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x6 | 6013795.01675 | 2105505.95048 | 37.7620941385477 | -122.395409453676 | (37.7620941385477, -122.395409453676) | 10 | 3 | 8 | 28856 | 29 | |||
| 52173 | 188864 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1301 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6013678.34538 | 2105678.35713 | 37.7625610395872 | -122.395825059197 | (37.7625610395872, -122.395825059197) | 14 | 3 | 8 | 28856 | 29 | |||
| 153062 | 54453 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1305 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1976 12:00:00 AM | 9 | Permit Number 16511 | 6013657.09709 | 2105679.36016 | 37.7625626116008 | -122.39589862014 | (37.7625626116008, -122.39589862014) | 14 | 3 | 8 | 28856 | 29 | ||
| 127329 | 107039 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1315 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 4x4 | 6013638.38831 | 2105678.022 | 37.7625578964607 | -122.39596323371 | (37.7625578964607, -122.39596323371) | 14 | 3 | 8 | 28856 | 29 | |||
| 22795 | 55186 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 352 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1972 12:00:00 AM | 13 | Permit Number 11096 | 6013396.91313 | 2094278.12637 | 37.7312427671323 | -122.395999500683 | (37.7312427671323, -122.395999500683) | 10 | 3 | 8 | 58 | 1 | ||
| 193874 | 57620 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1315 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1976 12:00:00 AM | 7 | Permit Number 16513 | 6013619.85223 | 2105678.11132 | 37.7625571104404 | -122.396027350002 | (37.7625571104404, -122.396027350002) | 14 | 3 | 8 | 28856 | 29 | ||
| 153304 | 57621 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1319 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1976 12:00:00 AM | 6 | Permit Number 16514 | 6013585.69477 | 2105673.14999 | 37.7625415872419 | -122.396145141378 | (37.7625415872419, -122.396145141378) | 14 | 3 | 8 | 28856 | 29 | ||
| 74588 | 67715 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 472 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 8 | 3x3 | Permit Number 31328 | 6013692.95356 | 2112582.14451 | 37.7815181053298 | -122.396258423594 | (37.7815181053298, -122.396258423594) | 6 | 2 | 9 | 28856 | 34 |
| 7441 | 101155 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400X 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6013491.9 | 2105242.3 | 37.7613533485104 | -122.396439344349 | (37.7613533485104, -122.396439344349) | 10 | 3 | 8 | 28856 | 29 | |||
| 37971 | 101154 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400X 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x5 | 6013491.9 | 2105242.3 | 37.7613533485104 | -122.396439344349 | (37.7613533485104, -122.396439344349) | 10 | 3 | 8 | 28856 | 29 | |||
| 72789 | 101152 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400X 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6013491.9 | 2105242.3 | 37.7613533485104 | -122.396439344349 | (37.7613533485104, -122.396439344349) | 10 | 3 | 8 | 28856 | 29 | |||
| 114642 | 101153 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400X 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6013491.9 | 2105242.3 | 37.7613533485104 | -122.396439344349 | (37.7613533485104, -122.396439344349) | 10 | 3 | 8 | 28856 | 29 | |||
| 110405 | 188904 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 450 Missouri St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6013484.89022 | 2104980.58732 | 37.7606343527251 | -122.396445243359 | (37.7606343527251, -122.396445243359) | 10 | 3 | 8 | 28856 | 29 | |||
| 127558 | 58381 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 555 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1979 12:00:00 AM | 9 | Permit Number 17513 | 6013292.95044 | 2104474.20019 | 37.7592332413492 | -122.397073573599 | (37.7592332413492, -122.397073573599) | 10 | 3 | 8 | 28856 | 29 | ||
| 54750 | 81857 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 550 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49819 | 6013442.18813 | 2112205.75243 | 37.780470662242 | -122.397099557694 | (37.780470662242, -122.397099557694) | 6 | 2 | 9 | 28856 | 34 | |
| 74635 | 54765 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 179 Nueva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 9 | Permit Number 10614 | 6012917.58994 | 2087110.3835 | 37.7115349095784 | -122.397154203219 | (37.7115349095784, -122.397154203219) | 10 | 3 | 8 | 309 | 1 | ||
| 30996 | 27121 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2335 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2002 12:00:00 AM | 12 | 2x2 | 6013101.69827 | 2096426.31583 | 37.7371248216631 | -122.397170694996 | (37.7371248216631, -122.397170694996) | 10 | 3 | 8 | 58 | 1 | ||
| 183165 | 175609 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 166 Nueva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012906.3252 | 2087198.97417 | 37.7117775349824 | -122.397199345568 | (37.7117775349824, -122.397199345568) | 10 | 3 | 8 | 309 | 1 | |||
| 66194 | 188905 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 390 19th St | 4 | : | Tree | Private 2 | 13 | Width 3ft | 6013268.70779 | 2105235.79503 | 37.7613230643314 | -122.397210821847 | (37.7613230643314, -122.397210821847) | 10 | 3 | 8 | 28856 | 29 | |||
| 102231 | 47679 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 327 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 6 | Permit Number 45466 | 6013233.56276 | 2105528.81136 | 37.762125666091 | -122.397352923703 | (37.762125666091, -122.397352923703) | 10 | 3 | 8 | 28856 | 29 | |
| 155826 | 202069 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1208 Jamestown Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6012889.60074 | 2090482.04244 | 37.7207912554832 | -122.397487253644 | (37.7207912554832, -122.397487253644) | 10 | 3 | 8 | 58 | 1 | |||
| 173289 | 188908 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 221 Connecticut St | 1 | : | Tree | Private 2 | 16 | Width 2ft | 6013203.04937 | 2106019.22102 | 37.763470523976 | -122.397492853728 | (37.763470523976, -122.397492853728) | 14 | 3 | 8 | 28856 | 29 | |||
| 125387 | 102252 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 374 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x6 | 6013186.08579 | 2105322.73493 | 37.7615571821298 | -122.397502676109 | (37.7615571821298, -122.397502676109) | 10 | 3 | 8 | 28856 | 29 |
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) );