trees
3,267 rows where qSpecies_id = 67 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119379 | 188857 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1022 Minna St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6007556.32266 | 2109725.24267 | 37.7733303617494 | -122.417285761027 | (37.7733303617494, -122.417285761027) | 8 | 2 | 9 | 28853 | 19 | |||
| 120204 | 188982 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1795 Silver Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6011420.41619 | 2095369.36572 | 37.7341289182 | -122.402909366101 | (37.7341289182, -122.402909366101) | 10 | 3 | 8 | 58 | 1 | |||
| 120436 | 188992 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Topeka Ave | 2 | : | Tree | Private 2 | 13 | Width 3ft | 6012717.62552 | 2095118.35856 | 37.7335120543411 | -122.398406869804 | (37.7335120543411, -122.398406869804) | 10 | 3 | 8 | 58 | 1 | |||
| 123318 | 204379 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 704 Garfield St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992181.68848 | 2090518.81006 | 37.7197174451861 | -122.469070205624 | (37.7197174451861, -122.469070205624) | 9 | 8 | 6 | 64 | 24 | |||
| 124354 | 247254 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 6000018.05631 | 2108518.06338 | 37.7695887611508 | -122.443274864147 | (37.7695887611508, -122.443274864147) | 15 | 5 | 11 | 29492 | 9 | |||
| 127644 | 222231 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 153 Marview Way | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5998275.0358 | 2103258.75453 | 37.7550484746194 | -122.448924983517 | (37.7550484746194, -122.448924983517) | 1 | 5 | 4 | 63 | 38 | |||
| 128843 | 188959 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1712 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 1ft | 6014904.41664 | 2096665.80836 | 37.7378826129007 | -122.390954562096 | (37.7378826129007, -122.390954562096) | 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 | |||
| 130397 | 189014 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1712 La Salle Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6014907.9841 | 2096659.95705 | 37.7378667443547 | -122.390941818707 | (37.7378667443547, -122.390941818707) | 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 | |||
| 130830 | 188892 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1058 Rhode Island St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6011884.21322 | 2103471.07947 | 37.7564003714916 | -122.401875180806 | (37.7564003714916, -122.401875180806) | 10 | 3 | 8 | 28856 | 29 | |||
| 131022 | 204391 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Junipero Serra Blvd | 97 | : | Tree | Private 2 | 4 | Width 0ft | 5991142.05412 | 2090528.37768 | 37.7196835902046 | -122.472664513466 | (37.7196835902046, -122.472664513466) | 9 | 8 | 4 | 64 | 40 | |||
| 131785 | 250060 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 Sutter St | 6 | : | Tree | Private 2 | 2 | Width 1ft | 6006175.05227 | 2114929.06733 | 37.7875409873764 | -122.422433599133 | (37.7875409873764, -122.422433599133) | 13 | 9 | 1 | 28858 | 41 | |||
| 132952 | 188890 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 998 Rhode Island St | 2 | : | Tree | Private 2 | 16 | Width 3ft | 6011864.92725 | 2103833.36661 | 37.7573940557998 | -122.401967346013 | (37.7573940557998, -122.401967346013) | 10 | 3 | 8 | 28856 | 29 | |||
| 135072 | 175640 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 28 De Long St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5995084.70237 | 2086816.61805 | 37.7097194085931 | -122.458767700893 | (37.7097194085931, -122.458767700893) | 9 | 8 | 6 | 28861 | 25 | |||
| 135575 | 250781 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 267 32nd Ave | 2 | : | Tree | Private 2 | 10 | Width 3ft | 5985871.01478 | 2114139.87947 | 37.7842078021793 | -122.492622375346 | (37.7842078021793, -122.492622375346) | 11 | 6 | 1 | 55 | 33 | |||
| 136339 | 246515 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 73 Waller St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6005379.43616 | 2109216.97454 | 37.7718120669155 | -122.424779754098 | (37.7718120669155, -122.424779754098) | 7 | 9 | 5 | 28852 | 10 | |||
| 136783 | 189011 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1727 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014856.73876 | 2096625.96923 | 37.7377705771381 | -122.391116625339 | (37.7377705771381, -122.391116625339) | 10 | 3 | 8 | 58 | 1 | |||
| 137319 | 188954 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1715 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014917.05879 | 2096584.25216 | 37.7376593777724 | -122.390905153366 | (37.7376593777724, -122.390905153366) | 10 | 3 | 8 | 58 | 1 | |||
| 139327 | 188976 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Thomas Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012701.46766 | 2095447.24575 | 37.734414210138 | -122.398485802392 | (37.734414210138, -122.398485802392) | 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 | |||
| 140025 | 220768 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 46 Elgin Park | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6005807.87841 | 2108828.68491 | 37.7707701060921 | -122.423270135033 | (37.7707701060921, -122.423270135033) | 8 | 2 | 5 | 28853 | 19 | |||
| 142709 | 205659 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1598 10th Ave | 7 | : | Tree | Private 2 | 3 | Width 2ft | 5993106.7424 | 2104692.3682 | 37.7586878807581 | -122.466902491455 | (37.7586878807581, -122.466902491455) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 144907 | 204375 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 550 Head St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5993517.97256 | 2089521.38757 | 37.7170558835987 | -122.464378804934 | (37.7170558835987, -122.464378804934) | 9 | 8 | 6 | 64 | 24 | |||
| 145095 | 188978 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Thomas Ave | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6012675.73904 | 2095460.82203 | 37.7344500544215 | -122.398575707611 | (37.7344500544215, -122.398575707611) | 10 | 3 | 8 | 58 | 1 | |||
| 146040 | 205663 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1598 10th Ave | 14 | : | Tree | Private 2 | 6 | Width 2ft | 5993106.16956 | 2104714.55034 | 37.758748754071 | -122.466906085168 | (37.758748754071, -122.466906085168) | 1 | 8 | 4 | 56 | 12 | |||
| 146161 | 220772 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 Webster St | 5 | : | Tree | Private 2 | 1 | Width 3ft | 6004138.15825 | 2109840.73616 | 37.7734545779006 | -122.429117901094 | (37.7734545779006, -122.429117901094) | 7 | 9 | 11 | 29492 | 10 | |||
| 146417 | 188854 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Heron St | 2 | : | Tree | Private 2 | 9 | Width 2ft | 6010001.1667 | 2110025.48762 | 37.7742920095037 | -122.408849856745 | (37.7742920095037, -122.408849856745) | 8 | 2 | 9 | 28853 | 34 | |||
| 146531 | 188991 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Topeka Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6012694.22698 | 2095131.74113 | 37.7335474966104 | -122.398488704497 | (37.7335474966104, -122.398488704497) | 10 | 3 | 8 | 58 | 1 | |||
| 146724 | 189012 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1723 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014880.56648 | 2096608.52309 | 37.7377239958591 | -122.391033021681 | (37.7377239958591, -122.391033021681) | 10 | 3 | 8 | 58 | 1 | |||
| 147542 | 246737 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 139 Ripley St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6008835.51496 | 2099113.48937 | 37.7442647875829 | -122.412110733722 | (37.7442647875829, -122.412110733722) | 2 | 7 | 7 | 28859 | 2 | |||
| 148480 | 220769 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 46 Elgin Park | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6005807.61785 | 2108816.0076 | 37.7707352825335 | -122.423270135003 | (37.7707352825335, -122.423270135003) | 8 | 2 | 5 | 28853 | 19 | |||
| 148549 | 188896 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 851 Wisconsin St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012778.37681 | 2103525.2873 | 37.7565990757928 | -122.398786633697 | (37.7565990757928, -122.398786633697) | 10 | 3 | 8 | 28856 | 29 | |||
| 149580 | 188939 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2225 Jerrold Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012171.90247 | 2099321.56683 | 37.7450227605042 | -122.400588763562 | (37.7450227605042, -122.400588763562) | 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 | |||
| 153857 | 250775 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 254 32nd Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5985910.66114 | 2114192.07133 | 37.7843534240234 | -122.492489059847 | (37.7843534240234, -122.492489059847) | 11 | 6 | 1 | 55 | 33 | |||
| 155104 | 188888 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 777 Rhode Island St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6011870.30759 | 2104770.99459 | 37.7599688750844 | -122.402014652148 | (37.7599688750844, -122.402014652148) | 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 | |||
| 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 | |||
| 157746 | 125802 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3711 Fillmore St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6002006.97076 | 2121237.2158 | 37.8046255099126 | -122.437306164453 | (37.8046255099126, -122.437306164453) | 13 | 9 | 1 | 57 | 17 | |||
| 158305 | 247753 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 44 Alpine Ter | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6001606.77879 | 2108574.48461 | 37.7698341456641 | -122.437783582143 | (37.7698341456641, -122.437783582143) | 15 | 5 | 5 | 29492 | 9 | |||
| 160565 | 220775 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2800 Mariposa St | 6 | : | Tree | Private 2 | 18 | Width 3ft | 6009066.85397 | 2105930.68426 | 37.7629962511977 | -122.411792424993 | (37.7629962511977, -122.411792424993) | 8 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 161750 | 202070 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1216 Jamestown Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6012852.30909 | 2090513.27274 | 37.7208749311243 | -122.39761834962 | (37.7208749311243, -122.39761834962) | 10 | 3 | 8 | 58 | 1 | |||
| 163676 | 246468 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 250 Duncan St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6004863.38148 | 2099908.92414 | 37.7462251963307 | -122.425902138566 | (37.7462251963307, -122.425902138566) | 2 | 7 | 5 | 63 | 22 | |||
| 163842 | 247052 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 515 Valley St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6002551.0292 | 2099143.14982 | 37.7439916086206 | -122.433843234102 | (37.7439916086206, -122.433843234102) | 2 | 7 | 5 | 63 | 22 | |||
| 164300 | 247014 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Valley St | 5 | : | Tree | Private 2 | 10 | Width 3ft | 6002586.52325 | 2099180.42423 | 37.7440959695517 | -122.433723167391 | (37.7440959695517, -122.433723167391) | 2 | 7 | 5 | 63 | 22 | |||
| 169447 | 247695 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Central Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5999979.23334 | 2108546.51702 | 37.7696646738092 | -122.443411195087 | (37.7696646738092, -122.443411195087) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 170806 | 188850 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1112 Harrison St | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6010617.59281 | 2110376.13956 | 37.7752893270638 | -122.406742232588 | (37.7752893270638, -122.406742232588) | 8 | 2 | 9 | 28853 | 34 | |||
| 170861 | 205661 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1598 10th Ave | 10 | : | Tree | Private 2 | 8 | Width 2ft | 5993106.85173 | 2104704.63335 | 37.7587215639736 | -122.46690300499 | (37.7587215639736, -122.46690300499) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 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 | |||
| 174475 | 188891 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 998 Rhode Island St | 3 | : | Tree | Private 2 | 11 | Width 3ft | 6011866.50484 | 2103811.61512 | 37.7573344190536 | -122.401960361001 | (37.7573344190536, -122.401960361001) | 10 | 3 | 8 | 28856 | 29 | |||
| 175046 | 189016 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1708 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014940.47928 | 2096636.31619 | 37.7378036344353 | -122.390827814378 | (37.7378036344353, -122.390827814378) | 10 | 3 | 8 | 58 | 1 | |||
| 175688 | 188906 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1551 19th St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6012997.53562 | 2105173.44723 | 37.7611367706578 | -122.398144324398 | (37.7611367706578, -122.398144324398) | 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 | |||
| 176196 | 250788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 281 32nd Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5985872.14911 | 2114023.45685 | 37.7838882056181 | -122.492609873852 | (37.7838882056181, -122.492609873852) | 11 | 6 | 1 | 55 | 33 | |||
| 177519 | 188853 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 385 08th St | 2 | : | Tree | Private 2 | 17 | Width 3ft | 6009987.41661 | 2109987.90496 | 37.7741880460757 | -122.408894768882 | (37.7741880460757, -122.408894768882) | 8 | 2 | 9 | 28853 | 34 | |||
| 181104 | 189019 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1706 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014964.37337 | 2096622.15224 | 37.7377660688555 | -122.390744210693 | (37.7377660688555, -122.390744210693) | 10 | 3 | 8 | 58 | 1 | |||
| 182727 | 247694 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Central Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5999980.3823 | 2108534.68823 | 37.769632260448 | -122.443406371107 | (37.769632260448, -122.443406371107) | 15 | 5 | 11 | 29492 | 9 | |||
| 182966 | 250784 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 266 32nd Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5985911.86598 | 2114116.23526 | 37.7841452705246 | -122.492479304885 | (37.7841452705246, -122.492479304885) | 11 | 6 | 1 | 55 | 33 | |||
| 184574 | 205869 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 118 Lakeview Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5997252.76199 | 2089357.29362 | 37.7168198961062 | -122.451457665965 | (37.7168198961062, -122.451457665965) | 9 | 8 | 6 | 28861 | 24 | |||
| 189301 | 204392 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Junipero Serra Blvd | 111 | : | Tree | Private 2 | 2 | Width 0ft | 5991121.6593 | 2090321.76947 | 37.7191151143447 | -122.47271995398 | (37.7191151143447, -122.47271995398) | 9 | 8 | 4 | 64 | 40 | |||
| 189335 | 188973 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1901 Quint St | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6012398.63958 | 2095214.62665 | 37.7337586115567 | -122.399516458721 | (37.7337586115567, -122.399516458721) | 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 | |||
| 189453 | 125801 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3711 Fillmore St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6002004.76332 | 2121253.22913 | 37.804669352783 | -122.437314950825 | (37.804669352783, -122.437314950825) | 13 | 9 | 1 | 57 | 17 | |||
| 191993 | 188889 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 812 Rhode Island St | 2 | : | Tree | Private 2 | 3 | Width 6ft | 6011824.00346 | 2104560.8876 | 37.7593893834298 | -122.402160024888 | (37.7593893834298, -122.402160024888) | 10 | 3 | 8 | 28856 | 29 | |||
| 193132 | 250790 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 284 32nd Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5985915.81821 | 2114007.58209 | 37.7838471713633 | -122.492457627621 | (37.7838471713633, -122.492457627621) | 11 | 6 | 1 | 55 | 33 | |||
| 54919 | 204381 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 47 Ralston St | 4 | Back Yard : Yard | Tree | Private 2 | 5 | 5992175.93878 | 2088248.61457 | 37.7134837071825 | -122.468924959729 | (37.7134837071825, -122.468924959729) | 9 | 8 | 6 | 64 | 24 | ||||
| 67707 | 204382 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 41 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 4 | 5992173.48186 | 2088232.60675 | 37.7134396116198 | -122.46893228742 | (37.7134396116198, -122.46893228742) | 9 | 8 | 6 | 64 | 24 | ||||
| 125163 | 204383 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 41 Ralston St | 5 | Back Yard : Yard | Tree | Private 2 | 6 | 5992172.93339 | 2088222.97511 | 37.7134131337717 | -122.468933482617 | (37.7134131337717, -122.468933482617) | 9 | 8 | 6 | 64 | 24 | ||||
| 18558 | 220932 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 56 Mirabel Ave | 1 | Front Yard : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 785183 | 6007687.03242 | 2099968.45973 | 37.7465478380206 | -122.416142489803 | (37.7465478380206, -122.416142489803) | 2 | 7 | 7 | 28859 | 2 | ||
| 7617 | 246440 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 485 Duncan St | 2 | Front Yard : Yard | Tree | Private 2 | 12 | 6003368.11948 | 2099777.56573 | 37.745779900623 | -122.431063194026 | (37.745779900623, -122.431063194026) | 2 | 7 | 5 | 63 | 22 | ||||
| 10711 | 247134 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 27th St | 4 | Front Yard : Yard | Tree | Private 2 | 6 | 6003187.16367 | 2100094.09523 | 37.7466387612688 | -122.431711508093 | (37.7466387612688, -122.431711508093) | 2 | 7 | 5 | 63 | 22 | ||||
| 12868 | 111864 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Allston Way | 1 | Front Yard : Yard | Tree | Private 2 | 06/26/2015 12:00:00 AM | 3 | Permit Number 775591 | 5994228.4 | 2098418 | 37.7415247340782 | -122.462568190827 | (37.7415247340782, -122.462568190827) | 1 | 8 | 4 | 59 | 40 | ||
| 25371 | 250208 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 212 Union St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011783.4083 | 2119794.63457 | 37.8012154488822 | -122.403372122131 | (37.8012154488822, -122.403372122131) | 3 | 1 | 10 | 308 | 23 | |||
| 30362 | 217834 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Cranleigh Dr | 25 | Front Yard : Yard | Tree | Private 2 | 15 | 5991396.17639 | 2095791.92324 | 37.7341506817918 | -122.472169581465 | (37.7341506817918, -122.472169581465) | 1 | 8 | 4 | 64 | 40 | ||||
| 50381 | 188946 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 398 Quint St | 3 | Front Yard : Yard | Tree | Private 2 | 9 | 6015180.72711 | 2099016.74699 | 37.7443531342865 | -122.390163407814 | (37.7443531342865, -122.390163407814) | 10 | 3 | 8 | 58 | 1 | ||||
| 68497 | 99961 | Property Tree 8 | Callistemon citrinus :: Lemon Bottlebrush 67 | 537 Valley St | 1 | Front Yard : Yard | Tree | Private 2 | 07/25/2012 12:00:00 AM | Permit Number 768880 | 6002459 | 2099152 | 37.7440106863694 | -122.434162082356 | (37.7440106863694, -122.434162082356) | 2 | 7 | 5 | 63 | 22 | |||
| 104010 | 104913 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 67 | 608 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 120711 | 125863 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Francisco St | 11 | Front Yard : Yard | Tree | Private 2 | 4 | 6010483.33133 | 2121337.12789 | 37.8053780572129 | -122.407979816633 | (37.8053780572129, -122.407979816633) | 3 | 1 | 10 | 308 | 23 | ||||
| 132834 | 220805 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 San Jose Ave | 4 | Front Yard : Yard | Tree | Private 2 | 5 | Width 8ft | 6003673.53965 | 2095753.0634 | 37.7347468423996 | -122.429720104197 | (37.7347468423996, -122.429720104197) | 2 | 7 | 5 | 63 | 7 | |||
| 142883 | 250210 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 212 Union St | 6 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011753.31095 | 2119788.98637 | 37.8011982592529 | -122.403475875111 | (37.8011982592529, -122.403475875111) | 3 | 1 | 10 | 308 | 23 | |||
| 151046 | 204571 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 406 Baden St | 2 | Front Yard : Yard | Tree | Private 2 | 2 | 6000766.76898 | 2095333.10408 | 37.7334287051602 | -122.439739684052 | (37.7334287051602, -122.439739684052) | 9 | 7 | 5 | 63 | 40 | ||||
| 157206 | 188944 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 398 Quint St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6015253.92457 | 2099115.96743 | 37.7446296326645 | -122.389917233688 | (37.7446296326645, -122.389917233688) | 10 | 3 | 8 | 58 | 1 | ||||
| 166369 | 220806 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 San Jose Ave | 5 | Front Yard : Yard | Tree | Private 2 | 8 | Width 6ft | 6003687.50559 | 2095763.31168 | 37.7347757726743 | -122.429672549851 | (37.7347757726743, -122.429672549851) | 2 | 7 | 5 | 63 | 7 | |||
| 170129 | 188945 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 398 Quint St | 2 | Front Yard : Yard | Tree | Private 2 | 10 | 6015211.76442 | 2099058.69599 | 37.744470038975 | -122.390059016307 | (37.744470038975, -122.390059016307) | 10 | 3 | 8 | 58 | 1 | ||||
| 184 | 204541 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 4 | Median : Cutout | Tree | DPW 1 | 16 | Width 3ft | 5999538.51913 | 2097033.8732 | 37.7380286277303 | -122.444108242518 | (37.7380286277303, -122.444108242518) | 9 | 7 | 4 | 59 | 40 | |||
| 439 | 8729 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
| 2387 | 204545 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 73 | Median : Cutout | Tree | DPW 1 | 15 | Width 3ft | 5999723.14356 | 2097244.03838 | 37.7386162222515 | -122.44348499884 | (37.7386162222515, -122.44348499884) | 9 | 7 | 4 | 59 | 40 | |||
| 4183 | 204530 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 28 | Median : Cutout | Tree | DPW 1 | 9 | Width 3ft | 5999185.819 | 2097019.37186 | 37.7379686834 | -122.445326654823 | (37.7379686834, -122.445326654823) | 9 | 7 | 4 | 59 | 40 | |||
| 7780 | 8836 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
| 10012 | 175625 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 22 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6009376.03196 | 2090018.08104 | 37.7193210519043 | -122.409599906627 | (37.7193210519043, -122.409599906627) | 9 | 3 | 8 | 309 | 18 | |||
| 11996 | 204552 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 60 | Median : Cutout | Tree | DPW 1 | 11 | Width 5ft | 5999641.44525 | 2097441.40723 | 37.7391534907361 | -122.443781647414 | (37.7391534907361, -122.443781647414) | 9 | 7 | 4 | 59 | 40 | |||
| 13088 | 8817 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3800 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5995279.8386756 | 2112876.8357526 | 37.7812854712581 | -122.459979879431 | (37.7812854712581, -122.459979879431) | 11 | 6 | 2 | 54 | 11 | |||
| 16202 | 8839 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
| 16774 | 8683 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
| 17168 | 8947 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4800 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 |
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) );