trees
3,267 rows where qSpecies_id = 67 sorted by Neighborhoods (old)
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) ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65903 | 5810 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 38 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6016194.1627128 | 2096297.6107937 | 37.7369430983129 | -122.386469573077 | (37.7369430983129, -122.386469573077) | 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 | |||
| 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 | |||
| 67920 | 188974 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1901 Quint St | 4 | : | Tree | Private 2 | 10 | Width 3ft | 6012413.00879 | 2095230.70151 | 37.7338035506988 | -122.39946790794 | (37.7338035506988, -122.39946790794) | 10 | 3 | 8 | 58 | 1 | |||
| 68352 | 199948 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1310 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6016458.2646 | 2093067.2473 | 37.7280877803005 | -122.385331411366 | (37.7280877803005, -122.385331411366) | 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 | |||
| 69658 | 5800 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Dukes Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X4 | 6016181.28411 | 2096289.16741 | 37.7369192015603 | -122.386513511992 | (37.7369192015603, -122.386513511992) | 10 | 3 | 8 | 58 | 1 | |||
| 70232 | 53729 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 12 | Permit Number 9408 | 6012570.8653 | 2095236.57105 | 37.7338284646029 | -122.398922559042 | (37.7338284646029, -122.398922559042) | 10 | 3 | 8 | 58 | 1 | ||
| 71005 | 54475 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 80 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1972 12:00:00 AM | 10 | Permit Number 10267 | 6012323.1841 | 2095334.08476 | 37.7340824124798 | -122.399785717559 | (37.7340824124798, -122.399785717559) | 10 | 3 | 8 | 58 | 1 | ||
| 71044 | 199926 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1258 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016753.5197 | 2092848.5602 | 37.7275036386073 | -122.384295470701 | (37.7275036386073, -122.384295470701) | 10 | 3 | 8 | 58 | 1 | |||
| 71105 | 38624 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1351 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 8 | Permit Number 40562 | 6016224.1538 | 2093165.8493 | 37.7283455672948 | -122.386147618696 | (37.7283455672948, -122.386147618696) | 10 | 3 | 8 | 58 | 1 | |
| 71405 | 1879 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45X Lillian St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/12/2003 12:00:00 AM | 12 | 3X4 | 6017774.309035 | 2094355.975399 | 37.7316990960952 | -122.380871307769 | (37.7316990960952, -122.380871307769) | 10 | 3 | 8 | 58 | 1 | ||
| 74011 | 188262 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1322 Hudson Ave | 47 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017323.3407 | 2095203.17011 | 37.7340004248815 | -122.38248933632 | (37.7340004248815, -122.38248933632) | 10 | 3 | 8 | 58 | 1 | |||
| 74252 | 188958 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1710 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014921.65166 | 2096653.12278 | 37.7378487372257 | -122.390894085388 | (37.7378487372257, -122.390894085388) | 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 | |||
| 74564 | 54552 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 7 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 14 | Permit Number 10347 | 6012795.21693 | 2095672.85449 | 37.7350389071076 | -122.398177501316 | (37.7350389071076, -122.398177501316) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 75121 | 199914 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1220 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6017119.8344 | 2092922.0985 | 37.7277258082427 | -122.38303422196 | (37.7277258082427, -122.38303422196) | 10 | 3 | 8 | 58 | 1 | |||
| 75704 | 202111 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1833 Egbert Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6011984.90914 | 2092821.29658 | 37.7271639540293 | -122.400778772341 | (37.7271639540293, -122.400778772341) | 10 | 3 | 8 | 58 | 1 | |||
| 75966 | 5802 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 218X Cashmere St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6016122.2563 | 2096227.44621 | 37.7367464597726 | -122.386713296401 | (37.7367464597726, -122.386713296401) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 76901 | 56724 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1582 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6015504.0444 | 2095869.4942 | 37.7357293502019 | -122.388825761039 | (37.7357293502019, -122.388825761039) | 10 | 3 | 8 | 58 | 1 | ||||
| 77427 | 10850 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1220X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017356.4574634 | 2095156.0177673 | 37.7338727832056 | -122.382371560842 | (37.7338727832056, -122.382371560842) | 10 | 3 | 8 | 58 | 1 | |||
| 77585 | 188975 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1901 Quint St | 6 | : | Tree | Private 2 | 10 | Width 1ft | 6012428.39873 | 2095250.09643 | 37.7338576629061 | -122.399416061108 | (37.7338576629061, -122.399416061108) | 10 | 3 | 8 | 58 | 1 | |||
| 78023 | 199931 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1254 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016771.1469 | 2092830.933 | 37.7274562124229 | -122.38423330569 | (37.7274562124229, -122.38423330569) | 10 | 3 | 8 | 58 | 1 | |||
| 78124 | 1875 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6018011.4321332 | 2094063.1260405 | 37.7309080736078 | -122.380031174991 | (37.7309080736078, -122.380031174991) | 10 | 3 | 8 | 58 | 1 | |||
| 78667 | 199898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1829 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6015950.3818 | 2093292.5446 | 37.728678291075 | -122.387102902636 | (37.728678291075, -122.387102902636) | 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 | |||
| 79893 | 188955 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1711 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 1ft | 6014937.85326 | 2096568.85447 | 37.737618252668 | -122.390832180559 | (37.737618252668, -122.390832180559) | 10 | 3 | 8 | 58 | 1 | |||
| 79896 | 56392 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1363 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 9 | Permit Number 12548 | 6016014.8311 | 2092970.2978 | 37.7277970339363 | -122.386857631263 | (37.7277970339363, -122.386857631263) | 10 | 3 | 8 | 58 | 1 | ||
| 80972 | 188277 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017947.76694 | 2094045.54207 | 37.7308562789814 | -122.380250056804 | (37.7308562789814, -122.380250056804) | 10 | 3 | 8 | 58 | 1 | |||
| 81783 | 175612 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 423 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012227.11334 | 2086656.26164 | 37.7102495175719 | -122.399508825282 | (37.7102495175719, -122.399508825282) | 10 | 3 | 8 | 309 | 1 | |||
| 81999 | 188271 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017623.68849 | 2094312.33343 | 37.7315709495417 | -122.381389005013 | (37.7315709495417, -122.381389005013) | 10 | 3 | 8 | 58 | 1 | |||
| 83513 | 188981 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Robblee Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6012603.96331 | 2095970.26137 | 37.7358448696291 | -122.398859603804 | (37.7358448696291, -122.398859603804) | 10 | 3 | 8 | 58 | 1 | |||
| 83983 | 199969 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400 Hawes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6017155.9541 | 2092761.9827 | 37.7272881573332 | -122.382898216023 | (37.7272881573332, -122.382898216023) | 10 | 3 | 8 | 58 | 1 | |||
| 84111 | 188960 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1728 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 1ft | 6014895.27133 | 2096673.06939 | 37.7379020427381 | -122.390986689509 | (37.7379020427381, -122.390986689509) | 10 | 3 | 8 | 58 | 1 | |||
| 84243 | 54629 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1693 Quint St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 11 | Permit Number 10452 | 6012827.80218 | 2095784.63135 | 37.7353476380685 | -122.39807268081 | (37.7353476380685, -122.39807268081) | 10 | 3 | 8 | 58 | 1 | ||
| 84255 | 188263 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1322 Hudson Ave | 52 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017270.30063 | 2095300.86237 | 37.7342657383686 | -122.382679509676 | (37.7342657383686, -122.382679509676) | 10 | 3 | 8 | 58 | 1 | |||
| 84725 | 188940 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2225 Jerrold Ave | 2 | : | Tree | Private 2 | 12 | Width 2ft | 6012204.04277 | 2099300.38228 | 37.7449663847043 | -122.400476139687 | (37.7449663847043, -122.400476139687) | 10 | 3 | 8 | 58 | 1 | |||
| 84748 | 103998 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1410X Hawes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | 10 | 3 | 8 | 58 | 1 | |||
| 85528 | 175608 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 466 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012381.21088 | 2086413.92424 | 37.7095926950223 | -122.398959231579 | (37.7095926950223, -122.398959231579) | 10 | 3 | 8 | 309 | 1 | |||
| 85612 | 199956 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1238 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6016851.5709 | 2092773.0939 | 37.7273018440116 | -122.38395125115 | (37.7273018440116, -122.38395125115) | 10 | 3 | 8 | 58 | 1 | |||
| 86223 | 5805 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5 Dukes Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016140.1129448 | 2096198.2445968 | 37.7366672666368 | -122.386649521955 | (37.7366672666368, -122.386649521955) | 10 | 3 | 8 | 58 | 1 | |||
| 88170 | 59679 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1246 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1981 12:00:00 AM | 7 | Permit Number 19105 | 6016818.5199 | 2092798.4329 | 37.7273695927226 | -122.384067273223 | (37.7273695927226, -122.384067273223) | 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 | |||
| 88838 | 54479 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 108 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1972 12:00:00 AM | 9 | Permit Number 10271 | 6012495.87675 | 2095234.91266 | 37.7338197321998 | -122.399181702273 | (37.7338197321998, -122.399181702273) | 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 | |||
| 89334 | 18800 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017918.7507593 | 2094507.5509584 | 37.732123263915 | -122.380382469104 | (37.732123263915, -122.380382469104) | 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 | |||
| 91875 | 188989 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Topeka Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012384.41951 | 2095296.84991 | 37.7339835868704 | -122.399571392929 | (37.7339835868704, -122.399571392929) | 10 | 3 | 8 | 58 | 1 | |||
| 92463 | 111565 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x HAWES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017154 | 2092794 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | 10 | 3 | 8 | 58 | 1 | ||||
| 92599 | 188988 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012367.17642 | 2095308.04996 | 37.7340133787081 | -122.399631794081 | (37.7340133787081, -122.399631794081) | 10 | 3 | 8 | 58 | 1 | |||
| 92814 | 103995 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1410X Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | 10 | 3 | 8 | 58 | 1 | |||
| 93070 | 189015 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1710 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014923.18832 | 2096650.89402 | 37.7378427027714 | -122.390888616642 | (37.7378427027714, -122.390888616642) | 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 | |||
| 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 | |||
| 94066 | 188942 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2250 Revere Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 6011601.74393 | 2097042.7843 | 37.7387338958451 | -122.402400080905 | (37.7387338958451, -122.402400080905) | 10 | 3 | 8 | 58 | 1 | |||
| 95331 | 111566 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x HAWES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017154 | 2092794 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | 10 | 3 | 8 | 58 | 1 | ||||
| 95824 | 188257 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6016188.2742 | 2096253.73483 | 37.7368222978047 | -122.38648687409 | (37.7368222978047, -122.38648687409) | 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 | |||
| 97768 | 5801 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 218X Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6016115.70396 | 2096246.37508 | 37.7367980718607 | -122.386737270517 | (37.7367980718607, -122.386737270517) | 10 | 3 | 8 | 58 | 1 | |||
| 98986 | 199916 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1255 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6016905.5541 | 2092999.2174 | 37.7279257189991 | -122.383780366921 | (37.7279257189991, -122.383780366921) | 10 | 3 | 8 | 58 | 1 | |||
| 99472 | 188278 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Lillian St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6017724.20983 | 2094242.07575 | 37.7313835847835 | -122.381036596687 | (37.7313835847835, -122.381036596687) | 10 | 3 | 8 | 58 | 1 | |||
| 100096 | 56386 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1310 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 13 | Permit Number 12538 | 6016291.3574 | 2092843.6025 | 37.727464460543 | -122.385892838032 | (37.727464460543, -122.385892838032) | 10 | 3 | 8 | 58 | 1 | ||
| 100192 | 188979 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Thomas Ave | 4 | : | Tree | Private 2 | 9 | Width 3ft | 6012664.04998 | 2095467.26552 | 37.7344670956772 | -122.398616572822 | (37.7344670956772, -122.398616572822) | 10 | 3 | 8 | 58 | 1 | |||
| 100256 | 189013 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1728 La Salle Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6014896.64739 | 2096670.03652 | 37.7378937914553 | -122.390981719843 | (37.7378937914553, -122.390981719843) | 10 | 3 | 8 | 58 | 1 | |||
| 100390 | 199970 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400 Hawes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6017142.6877 | 2092741.1355 | 37.7272301819921 | -122.382942628131 | (37.7272301819921, -122.382942628131) | 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 | ||||
| 100530 | 199919 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1208 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6017156.1904 | 2092897.3103 | 37.7276597535169 | -122.382906813046 | (37.7276597535169, -122.382906813046) | 10 | 3 | 8 | 58 | 1 | |||
| 101063 | 202112 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1833 Egbert Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 5ft | 6011990.44763 | 2092817.45551 | 37.7271537161593 | -122.400759355986 | (37.7271537161593, -122.400759355986) | 10 | 3 | 8 | 58 | 1 | |||
| 101808 | 5804 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6016140.1129448 | 2096198.2445968 | 37.7366672666368 | -122.386649521955 | (37.7366672666368, -122.386649521955) | 10 | 3 | 8 | 58 | 1 | |||
| 103528 | 199897 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1395 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6016007.6701 | 2093322.8413 | 37.7287646519973 | -122.386906963777 | (37.7287646519973, -122.386906963777) | 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 | |||
| 104418 | 188961 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1734 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014842.71506 | 2096714.04694 | 37.7380116422333 | -122.391171267237 | (37.7380116422333, -122.391171267237) | 10 | 3 | 8 | 58 | 1 | |||
| 105229 | 200080 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1352 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6016078.1788 | 2093000.5945 | 37.7278837299247 | -122.386640746762 | (37.7278837299247, -122.386640746762) | 10 | 3 | 8 | 58 | 1 | |||
| 105655 | 199921 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1322 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6016230.764 | 2092890.4247 | 37.7275896716386 | -122.386105574291 | (37.7275896716386, -122.386105574291) | 10 | 3 | 8 | 58 | 1 | |||
| 106792 | 188264 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1322 Hudson Ave | 53 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017261.07145 | 2095318.28053 | 37.7343130553028 | -122.382712629894 | (37.7343130553028, -122.382712629894) | 10 | 3 | 8 | 58 | 1 | |||
| 107082 | 54557 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 47 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 10 | Permit Number 10352 | 6012770.21141 | 2095473.4574 | 37.7344900113118 | -122.398249969574 | (37.7344900113118, -122.398249969574) | 10 | 3 | 8 | 58 | 1 | ||
| 107964 | 103999 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6017169.9617 | 2092803.1151 | 37.727401872803 | -122.382852652572 | (37.727401872803, -122.382852652572) | 10 | 3 | 8 | 58 | 1 | |||
| 108217 | 87177 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1572 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50147 | 6014901.6694 | 2093877.1498 | 37.7302253707536 | -122.390769233 | (37.7302253707536, -122.390769233) | 10 | 3 | 8 | 58 | 1 | |
| 108410 | 200069 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1543 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015198.46 | 2093925.2409 | 37.7303738816119 | -122.38974653751 | (37.7303738816119, -122.38974653751) | 10 | 3 | 8 | 58 | 1 | |||
| 108502 | 56391 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1344 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 10 | Permit Number 12544 | 6016127.2043 | 2092964.2385 | 37.7277866175614 | -122.386468729017 | (37.7277866175614, -122.386468729017) | 10 | 3 | 8 | 58 | 1 | ||
| 108884 | 111564 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x HAWES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017154 | 2092794 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | 10 | 3 | 8 | 58 | 1 | ||||
| 110029 | 53731 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 137 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 11 | 3x3 | Permit Number 9410 | 6012616.20175 | 2095211.8932 | 37.7337632304952 | -122.398764085002 | (37.7337632304952, -122.398764085002) | 10 | 3 | 8 | 58 | 1 | |
| 111247 | 199955 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1226 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016917.6728 | 2092728.4751 | 37.7271829836155 | -122.383719629667 | (37.7271829836155, -122.383719629667) | 10 | 3 | 8 | 58 | 1 | |||
| 113288 | 199915 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1278 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016654.3669 | 2092917.9672 | 37.7276887336226 | -122.384643078505 | (37.7276887336226, -122.384643078505) | 10 | 3 | 8 | 58 | 1 | |||
| 113371 | 53509 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 4 | Permit Number 12537 | 6016318.8998 | 2092822.1194 | 37.7274069963434 | -122.385796126204 | (37.7274069963434, -122.385796126204) | 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 | |||
| 113541 | 18812 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017743.9455674 | 2094518.0196352 | 37.7321423618577 | -122.380987543086 | (37.7321423618577, -122.380987543086) | 10 | 3 | 8 | 58 | 1 | |||
| 114343 | 199875 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1467 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6015608.3045 | 2093619.7489 | 37.7295577802107 | -122.388308322353 | (37.7295577802107, -122.388308322353) | 10 | 3 | 8 | 58 | 1 | |||
| 114808 | 6392 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Espanola St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017974.4315502 | 2094113.8790238 | 37.7310453900638 | -122.380162619042 | (37.7310453900638, -122.380162619042) | 10 | 3 | 8 | 58 | 1 | |||
| 114884 | 199872 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1452 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6015728.3896 | 2093608.7319 | 37.7295341830028 | -122.387892403836 | (37.7295341830028, -122.387892403836) | 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 | |||
| 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 | |||
| 115339 | 199880 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1387 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016216.5667 | 2093521.9579 | 37.7293229510399 | -122.386198663854 | (37.7293229510399, -122.386198663854) | 10 | 3 | 8 | 58 | 1 | |||
| 115506 | 99545 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1345 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016251.7 | 2093118.1 | 37.7282159817318 | -122.386049062135 | (37.7282159817318, -122.386049062135) | 10 | 3 | 8 | 58 | 1 | ||||
| 117115 | 18806 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 54 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X4 | 6017853.0028401 | 2094472.3604 | 37.7320230094763 | -122.380607331399 | (37.7320230094763, -122.380607331399) | 10 | 3 | 8 | 58 | 1 | |||
| 118039 | 188985 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Maddux Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012675.20565 | 2095233.03889 | 37.7338245795424 | -122.398561572976 | (37.7338245795424, -122.398561572976) | 10 | 3 | 8 | 58 | 1 | |||
| 118290 | 60062 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1554 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/1982 12:00:00 AM | 8 | Permit Number 19561 | 6015777.30989 | 2097062.16866 | 37.7390193343766 | -122.387964167027 | (37.7390193343766, -122.387964167027) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );