trees
3,267 rows where qSpecies_id = 67 sorted by PlotSize descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46384 | 204550 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 62 | Median : Cutout | Tree | DPW 1 | 12 | Width 5ft | 5999656.91248 | 2097430.30525 | 37.7391238895455 | -122.443727371535 | (37.7391238895455, -122.443727371535) | 9 | 7 | 4 | 59 | 40 | |||
| 64242 | 204560 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 54 | Median : Cutout | Tree | DPW 1 | 16 | Width 5ft | 5999598.12734 | 2097466.83361 | 37.7392208346642 | -122.443933247029 | (37.7392208346642, -122.443933247029) | 9 | 7 | 4 | 59 | 40 | |||
| 65060 | 121854 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 594 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 5990047.88808 | 2111338.10204 | 37.7767582401401 | -122.477967136227 | (37.7767582401401, -122.477967136227) | 11 | 6 | 2 | 55 | 26 | |||
| 67043 | 204547 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 68 | Median : Cutout | Tree | DPW 1 | 15 | Width 5ft | 5999723.97514 | 2097336.19746 | 37.7388693166702 | -122.443488741839 | (37.7388693166702, -122.443488741839) | 9 | 7 | 4 | 59 | 40 | |||
| 69833 | 222367 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 70 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6004078.24367 | 2102661.88709 | 37.7537397883793 | -122.428813273739 | (37.7537397883793, -122.428813273739) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 77170 | 204555 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 59 | Median : Cutout | Tree | DPW 1 | 14 | Width 5ft | 5999635.81986 | 2097444.21934 | 37.7391608912586 | -122.443801299384 | (37.7391608912586, -122.443801299384) | 9 | 7 | 4 | 59 | 40 | |||
| 79967 | 222383 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 534 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6002966.0239 | 2105080.34846 | 37.7603172922179 | -122.432832337652 | (37.7603172922179, -122.432832337652) | 2 | 4 | 5 | 28862 | 3 | |||
| 81918 | 222407 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 730 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6003028.51187 | 2103966.99485 | 37.7572638339676 | -122.432536695429 | (37.7572638339676, -122.432536695429) | 2 | 4 | 5 | 28862 | 3 | |||
| 83673 | 204553 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 64 | Median : Cutout | Tree | DPW 1 | 14 | Width 5ft | 5999694.8834 | 2097395.01803 | 37.7390291648714 | -122.443593551518 | (37.7390291648714, -122.443593551518) | 9 | 7 | 4 | 59 | 40 | |||
| 85498 | 125856 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2843 Larkin St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6006461.58499 | 2121022.99007 | 37.804289527702 | -122.421875291912 | (37.804289527702, -122.421875291912) | 5 | 9 | 1 | 28858 | 32 | |||
| 88228 | 204590 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 298 Monterey Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6000146.34132 | 2094716.84444 | 37.7317012657846 | -122.441840456285 | (37.7317012657846, -122.441840456285) | 9 | 7 | 4 | 63 | 40 | |||
| 97848 | 204556 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 58 | Median : Cutout | Tree | DPW 1 | 15 | Width 5ft | 5999628.6217 | 2097449.48982 | 37.7391749521682 | -122.443826565843 | (37.7391749521682, -122.443826565843) | 9 | 7 | 4 | 59 | 40 | |||
| 98997 | 205772 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 31 | Median : Cutout | Tree | DPW 1 | 23 | Width 5ft | 5999313.6439 | 2097558.63922 | 37.7394566791949 | -122.444923457253 | (37.7394566791949, -122.444923457253) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 101575 | 125855 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2843 Larkin St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6006460.99405 | 2121028.21686 | 37.8043038458052 | -122.421877708416 | (37.8043038458052, -122.421877708416) | 5 | 9 | 1 | 28858 | 32 | |||
| 101986 | 222384 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 552 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6002973.50824 | 2104978.67687 | 37.7600385509657 | -122.432799189556 | (37.7600385509657, -122.432799189556) | 2 | 4 | 5 | 28862 | 3 | |||
| 102502 | 204591 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 298 Monterey Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6000137.52565 | 2094717.93006 | 37.7317037443113 | -122.441871011631 | (37.7317037443113, -122.441871011631) | 9 | 7 | 4 | 63 | 40 | |||
| 110989 | 204554 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 63 | Median : Cutout | Tree | DPW 1 | 17 | Width 5ft | 5999684.52262 | 2097404.39689 | 37.7390543260871 | -122.443630047808 | (37.7390543260871, -122.443630047808) | 9 | 7 | 4 | 59 | 40 | |||
| 112326 | 125848 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1156 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6008008.91714 | 2118589.10669 | 37.7976938341652 | -122.416348113498 | (37.7976938341652, -122.416348113498) | 5 | 1 | 10 | 28858 | 21 | |||
| 119376 | 204557 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 57 | Median : Cutout | Tree | DPW 1 | 13 | Width 5ft | 5999620.61184 | 2097454.77716 | 37.7391890130662 | -122.443854640005 | (37.7391890130662, -122.443854640005) | 9 | 7 | 4 | 59 | 40 | |||
| 123141 | 205770 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 21 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 5999265.98235 | 2097572.41051 | 37.7394917716315 | -122.445089239201 | (37.7394917716315, -122.445089239201) | 9 | 7 | 4 | 59 | 40 | |||
| 124289 | 222400 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 116 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6000348.37213 | 2104909.38661 | 37.759699060486 | -122.441873275228 | (37.759699060486, -122.441873275228) | 2 | 4 | 5 | 28862 | 3 | |||
| 126625 | 205771 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 22 | Median : Cutout | Tree | DPW 1 | 17 | Width 5ft | 5999270.55629 | 2097571.10979 | 37.7394884612284 | -122.445073331084 | (37.7394884612284, -122.445073331084) | 9 | 7 | 4 | 59 | 40 | |||
| 127539 | 222417 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 21 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6003327.35397 | 2107394.57322 | 37.7666920816941 | -122.431747901838 | (37.7666920816941, -122.431747901838) | 15 | 5 | 5 | 28862 | 3 | |||
| 127624 | 205762 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 10 | Median : Cutout | Tree | DPW 1 | 4 | Width 5ft | 5999196.86818 | 2097590.96864 | 37.739538782785 | -122.445329538954 | (37.739538782785, -122.445329538954) | 9 | 7 | 4 | 59 | 40 | |||
| 131871 | 204551 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 61 | Median : Cutout | Tree | DPW 1 | 13 | Width 5ft | 5999648.64901 | 2097436.4062 | 37.739140169982 | -122.443756380962 | (37.739140169982, -122.443756380962) | 9 | 7 | 4 | 59 | 40 | |||
| 135271 | 222419 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6003348.1743 | 2107394.45751 | 37.7666929441597 | -122.43167587965 | (37.7666929441597, -122.43167587965) | 15 | 5 | 5 | 28862 | 3 | |||
| 142378 | 247636 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 336 Bradford St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 5ft | 6009466.72308 | 2096666.25261 | 37.737580604353 | -122.409755436259 | (37.737580604353, -122.409755436259) | 10 | 7 | 7 | 28859 | 2 | |||
| 142689 | 205768 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 18 | Median : Cutout | Tree | DPW 1 | 10 | Width 5ft | 5999248.63953 | 2097576.8704 | 37.7395030275415 | -122.445149523442 | (37.7395030275415, -122.445149523442) | 9 | 7 | 4 | 59 | 40 | |||
| 142772 | 125847 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1752 Taylor St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6008754.65133 | 2118947.56933 | 37.7987199902862 | -122.413793029843 | (37.7987199902862, -122.413793029843) | 3 | 1 | 10 | 308 | 21 | |||
| 144796 | 175751 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Dartmouth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6008533.24007 | 2093511.74636 | 37.7288666548595 | -122.412759992088 | (37.7288666548595, -122.412759992088) | 9 | 3 | 7 | 309 | 28 | |||
| 145958 | 202113 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1833 Egbert Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6011995.35784 | 2092813.4202 | 37.7271429099005 | -122.400742097966 | (37.7271429099005, -122.400742097966) | 10 | 3 | 8 | 58 | 1 | |||
| 151773 | 175752 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Dartmouth St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6008529.08194 | 2093527.37027 | 37.7289093213844 | -122.412775471205 | (37.7289093213844, -122.412775471205) | 9 | 3 | 7 | 309 | 28 | |||
| 153372 | 202110 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1833 Egbert Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6011956.80735 | 2092843.90085 | 37.7272244532319 | -122.40087750799 | (37.7272244532319, -122.40087750799) | 10 | 3 | 8 | 58 | 1 | |||
| 153674 | 175705 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Dartmouth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 5ft | 6008531.54001 | 2093517.90327 | 37.7288834649957 | -122.412766304433 | (37.7288834649957, -122.412766304433) | 9 | 3 | 7 | 309 | 28 | |||
| 158135 | 204559 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 55 | Median : Cutout | Tree | DPW 1 | 16 | Width 5ft | 5999606.14252 | 2097461.81571 | 37.7392075139067 | -122.443905173798 | (37.7392075139067, -122.443905173798) | 9 | 7 | 4 | 59 | 40 | |||
| 158529 | 205765 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 14 | Median : Cutout | Tree | DPW 1 | 9 | Width 5ft | 5999225.79466 | 2097584.57981 | 37.7395228917684 | -122.445229064894 | (37.7395228917684, -122.445229064894) | 9 | 7 | 4 | 59 | 40 | |||
| 159056 | 204495 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 255x San Marcos Ave | 8 | Median : Cutout | Tree | DPW 1 | 4 | Width 5ft | 5993111.4957 | 2100245.72605 | 37.7464788213471 | -122.466562848991 | (37.7464788213471, -122.466562848991) | 1 | 8 | 4 | 29491 | 40 | |||
| 159401 | 204558 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 56 | Median : Cutout | Tree | DPW 1 | 13 | Width 5ft | 5999610.45434 | 2097460.91746 | 37.7392052934789 | -122.443890200994 | (37.7392052934789, -122.443890200994) | 9 | 7 | 4 | 59 | 40 | |||
| 160463 | 202109 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1833 Egbert Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6011952.26669 | 2092845.65038 | 37.7272290038035 | -122.400893327982 | (37.7272290038035, -122.400893327982) | 10 | 3 | 8 | 58 | 1 | |||
| 160740 | 117982 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 82 Shore View Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 5984203.12595 | 2112857.27884 | 37.7805884909022 | -122.498297826626 | (37.7805884909022, -122.498297826626) | 11 | 6 | 2 | 55 | 26 | |||
| 165884 | 205654 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1418 14th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 5ft | 5991827.79825 | 2105762.9565 | 37.7615535344796 | -122.471403629768 | (37.7615535344796, -122.471403629768) | 1 | 8 | 4 | 56 | 12 | |||
| 168200 | 205773 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 367 Kensington Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 5ft | 5994090.41781 | 2099105.65375 | 37.7434049116147 | -122.463095164805 | (37.7434049116147, -122.463095164805) | 1 | 8 | 4 | 59 | 40 | |||
| 171078 | 205766 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 15 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 5999230.5906 | 2097582.30956 | 37.7395169319577 | -122.4452123195 | (37.7395169319577, -122.4452123195) | 9 | 7 | 4 | 59 | 40 | |||
| 173765 | 204546 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 69 | Median : Cutout | Tree | DPW 1 | 13 | Width 5ft | 5999726.30548 | 2097318.09097 | 37.7388197334385 | -122.443479384359 | (37.7388197334385, -122.443479384359) | 9 | 7 | 4 | 59 | 40 | |||
| 174838 | 175706 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Dartmouth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6008529.71113 | 2093523.77753 | 37.7288994918046 | -122.412773042148 | (37.7288994918046, -122.412773042148) | 9 | 3 | 7 | 309 | 28 | |||
| 178085 | 204548 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 67 | Median : Cutout | Tree | DPW 1 | 13 | Width 5ft | 5999721.47669 | 2097346.22168 | 37.738896698316 | -122.443498100161 | (37.738896698316, -122.443498100161) | 9 | 7 | 4 | 59 | 40 | |||
| 180000 | 204549 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 66 | Median : Cutout | Tree | DPW 1 | 12 | Width 5ft | 5999718.50993 | 2097359.75923 | 37.7389337000243 | -122.44350932999 | (37.7389337000243, -122.44350932999) | 9 | 7 | 4 | 59 | 40 | |||
| 181456 | 205767 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 17 | Median : Cutout | Tree | DPW 1 | 10 | Width 5ft | 5999244.31767 | 2097578.64834 | 37.7395076626552 | -122.445164594286 | (37.7395076626552, -122.445164594286) | 9 | 7 | 4 | 59 | 40 | |||
| 185615 | 125836 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Golden Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6008214.16509 | 2116540.37994 | 37.7920800761809 | -122.415492776366 | (37.7920800761809, -122.415492776366) | 5 | 1 | 10 | 28858 | 21 | |||
| 190555 | 222420 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Henry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6003357.339 | 2107395.21062 | 37.7666955314936 | -122.431644234308 | (37.7666955314936, -122.431644234308) | 15 | 5 | 5 | 28862 | 3 | |||
| 156 | 222165 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 953 Elizabeth St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6000303.11526 | 2101951.8939 | 37.7515759277946 | -122.441817532557 | (37.7515759277946, -122.441817532557) | 2 | 4 | 5 | 28862 | 22 | |||
| 1094 | 124411 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3906 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5996074.1747 | 2115241.80305 | 37.7878246921221 | -122.457403032995 | (37.7878246921221, -122.457403032995) | 11 | 6 | 1 | 54 | 31 | |||
| 5075 | 125815 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2081 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003051.46393 | 2118195.99672 | 37.7963344369473 | -122.433474132552 | (37.7963344369473, -122.433474132552) | 13 | 9 | 1 | 57 | 17 | |||
| 7365 | 125750 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2870 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5999187.17827 | 2118395.44877 | 37.7966620797435 | -122.446859678745 | (37.7966620797435, -122.446859678745) | 13 | 9 | 1 | 57 | 17 | |||
| 8129 | 222155 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4655 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6000428.56832 | 2101076.36707 | 37.7491790897485 | -122.441320886466 | (37.7491790897485, -122.441320886466) | 2 | 4 | 5 | 28862 | 22 | |||
| 11008 | 125832 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005294.88878 | 2118203.51089 | 37.7964820948146 | -122.425711940964 | (37.7964820948146, -122.425711940964) | 13 | 9 | 1 | 28858 | 17 | |||
| 14118 | 125818 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2081 Green St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003105.57534 | 2118201.45062 | 37.7963524818244 | -122.433287285795 | (37.7963524818244, -122.433287285795) | 13 | 9 | 1 | 57 | 17 | |||
| 15023 | 125822 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2301 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6003751.95692 | 2115935.88569 | 37.7901684673368 | -122.430888902704 | (37.7901684673368, -122.430888902704) | 13 | 9 | 1 | 29490 | 27 | |||
| 18204 | 125749 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2672 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000224.25426 | 2118193.8188 | 37.7961676486817 | -122.443256684343 | (37.7961676486817, -122.443256684343) | 13 | 9 | 1 | 57 | 17 | |||
| 19656 | 125824 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2210 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004068.4927 | 2116354.72552 | 37.7913364249795 | -122.429823600886 | (37.7913364249795, -122.429823600886) | 13 | 9 | 1 | 29490 | 27 | |||
| 21707 | 204401 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1426 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5994301.11248 | 2105797.04761 | 37.7617899068936 | -122.462851987244 | (37.7617899068936, -122.462851987244) | 1 | 5 | 11 | 56 | 12 | |||
| 22003 | 125776 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 25 Heather Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5997332.30363 | 2114303.61712 | 37.7853208661167 | -122.452982417028 | (37.7853208661167, -122.452982417028) | 15 | 6 | 1 | 54 | 31 | |||
| 22444 | 204402 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1426 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5994299.73168 | 2105778.36459 | 37.7617385286395 | -122.462855407375 | (37.7617385286395, -122.462855407375) | 1 | 5 | 11 | 56 | 12 | |||
| 24802 | 122162 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 553 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5991248.88976 | 2111615.51669 | 37.7775895788166 | -122.473832798234 | (37.7775895788166, -122.473832798234) | 11 | 6 | 2 | 54 | 26 | |||
| 24983 | 220898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 82 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998243.00011 | 2106881.99825 | 37.7649951626328 | -122.449296801911 | (37.7649951626328, -122.449296801911) | 15 | 5 | 11 | 29492 | 9 | |||
| 25438 | 123463 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 640 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5995355.59472 | 2111175.27155 | 37.7766177851051 | -122.459594525244 | (37.7766177851051, -122.459594525244) | 11 | 6 | 2 | 54 | 11 | |||
| 26342 | 220895 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 842 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998713.61111 | 2107159.2684 | 37.7657833842225 | -122.447689044327 | (37.7657833842225, -122.447689044327) | 15 | 5 | 11 | 29492 | 9 | |||
| 27106 | 222267 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 252 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006992.10855 | 2097505.51767 | 37.7397460522488 | -122.418370863232 | (37.7397460522488, -122.418370863232) | 2 | 7 | 7 | 28859 | 2 | |||
| 29150 | 175710 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 Gaven St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6008896.74795 | 2094854.28773 | 37.7325733824383 | -122.411598132751 | (37.7325733824383, -122.411598132751) | 9 | 3 | 7 | 309 | 28 | |||
| 29199 | 125834 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1880 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005178.96144 | 2117491.50362 | 37.7945205520321 | -122.426062362682 | (37.7945205520321, -122.426062362682) | 13 | 9 | 1 | 28858 | 27 | |||
| 30696 | 175647 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 199 Shakespeare St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993520.37631 | 2086668.28967 | 37.7092220951912 | -122.464163488366 | (37.7092220951912, -122.464163488366) | 9 | 8 | 6 | 28861 | 25 | |||
| 30977 | 220816 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100 Alemany Blvd | 27 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6009324.41886 | 2095855.67364 | 37.7353469537051 | -122.410190239591 | (37.7353469537051, -122.410190239591) | 10 | 7 | 7 | 28859 | 2 | |||
| 32885 | 205746 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 33 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5993900.499 | 2101145.11653 | 37.7489938186198 | -122.46389985752 | (37.7489938186198, -122.46389985752) | 1 | 8 | 4 | 29491 | 40 | |||
| 34802 | 123986 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 7 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5993605.6147 | 2115370.6558 | 37.7880363894105 | -122.465953086481 | (37.7880363894105, -122.465953086481) | 11 | 6 | 1 | 54 | 11 | |||
| 34815 | 125833 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1870 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005225.66086 | 2117499.28655 | 37.7945445612278 | -122.425901330993 | (37.7945445612278, -122.425901330993) | 13 | 9 | 1 | 28858 | 27 | |||
| 35503 | 222179 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500x 27th St | 30 | Median : Cutout | Tree | DPW 1 | 5 | Width 4ft | 6003006.9083 | 2100074.76415 | 37.7465754633878 | -122.432333431553 | (37.7465754633878, -122.432333431553) | 2 | 7 | 5 | 63 | 22 | |||
| 36164 | 220776 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Florida St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009138.53931 | 2107166.48847 | 37.7663935067762 | -122.411631809669 | (37.7663935067762, -122.411631809669) | 8 | 4 | 7 | 28853 | 19 | |||
| 41239 | 205748 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 80 Sotelo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5993792.60369 | 2101417.15346 | 37.7497345443361 | -122.46429270474 | (37.7497345443361, -122.46429270474) | 1 | 8 | 4 | 29491 | 40 | |||
| 45211 | 123902 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 10th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5992691.42698 | 2114893.08742 | 37.7866723380473 | -122.469081216144 | (37.7866723380473, -122.469081216144) | 11 | 6 | 1 | 54 | 11 | |||
| 47553 | 222162 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 841 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6001933.05858 | 2101564.08955 | 37.7506038496939 | -122.436153243489 | (37.7506038496939, -122.436153243489) | 2 | 4 | 5 | 28862 | 22 | |||
| 48137 | 204468 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 180 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5994276.47552 | 2099234.04461 | 37.7437681567899 | -122.462461140072 | (37.7437681567899, -122.462461140072) | 1 | 8 | 4 | 59 | 40 | |||
| 48141 | 175747 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 58 Baltimore Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6002963.82508 | 2086583.0162 | 37.709527718998 | -122.431519392204 | (37.709527718998, -122.431519392204) | 9 | 7 | 6 | 28861 | 5 | |||
| 49606 | 205740 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 32 Mesa Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5993640.80754 | 2100768.42511 | 37.7479445508167 | -122.464770513651 | (37.7479445508167, -122.464770513651) | 1 | 8 | 4 | 29491 | 40 | |||
| 50156 | 125809 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2152 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6000391.06255 | 2116068.2231 | 37.7903408314189 | -122.442526808093 | (37.7903408314189, -122.442526808093) | 13 | 6 | 1 | 29490 | 27 | |||
| 50409 | 220813 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2990 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009595.57365 | 2101631.24362 | 37.75122060205 | -122.409660276315 | (37.75122060205, -122.409660276315) | 2 | 4 | 7 | 28859 | 19 | |||
| 50649 | 250734 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2801 Lake St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5986725.81276 | 2114419.04313 | 37.7850242490072 | -122.489685654482 | (37.7850242490072, -122.489685654482) | 11 | 6 | 1 | 55 | 33 | |||
| 52325 | 220773 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2800 Mariposa St | 2 | : | Tree | Private 2 | 11 | Width 4ft | 6009163.19506 | 2105934.0417 | 37.7630108741738 | -122.41145945011 | (37.7630108741738, -122.41145945011) | 8 | 4 | 7 | 28859 | 19 | |||
| 54253 | 204472 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 293 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5994575.1706 | 2100200.25095 | 37.746438313181 | -122.461498364577 | (37.746438313181, -122.461498364577) | 1 | 8 | 4 | 29491 | 40 | |||
| 54702 | 222206 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 245 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6004627.77227 | 2096895.80624 | 37.7379385444269 | -122.426502335314 | (37.7379385444269, -122.426502335314) | 2 | 7 | 5 | 63 | 7 | |||
| 56288 | 125817 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2081 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6003091.73227 | 2118199.34696 | 37.7963459203936 | -122.433335035292 | (37.7963459203936, -122.433335035292) | 13 | 9 | 1 | 57 | 17 | |||
| 57295 | 205656 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1280 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5991461.94774 | 2106749.02205 | 37.7642398373174 | -122.472740844327 | (37.7642398373174, -122.472740844327) | 11 | 8 | 11 | 56 | 12 | |||
| 58748 | 220868 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1203 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5997388.6326 | 2105850.76689 | 37.7621147564205 | -122.45217741766 | (37.7621147564205, -122.45217741766) | 15 | 5 | 11 | 29492 | 12 | |||
| 58836 | 118063 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 436 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5984715.27231 | 2112914.45835 | 37.7807755068603 | -122.49653031582 | (37.7807755068603, -122.49653031582) | 11 | 6 | 2 | 55 | 26 | |||
| 58843 | 204404 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1440 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5994305.88631 | 2105718.15994 | 37.7615735767848 | -122.4628297533 | (37.7615735767848, -122.4628297533) | 1 | 5 | 11 | 56 | 12 | |||
| 59523 | 205794 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 618 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5997298.05605 | 2094421.90373 | 37.7307287182504 | -122.451666234016 | (37.7307287182504, -122.451666234016) | 9 | 7 | 4 | 59 | 40 | |||
| 59533 | 123901 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5992691.28495 | 2114901.15699 | 37.7866944866565 | -122.469082295037 | (37.7866944866565, -122.469082295037) | 11 | 6 | 1 | 54 | 11 | |||
| 59748 | 250738 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2801 Lake St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986770.52108 | 2114418.70237 | 37.7850259235546 | -122.489530954893 | (37.7850259235546, -122.489530954893) | 11 | 6 | 1 | 55 | 33 | |||
| 60200 | 205759 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 158 Stillings Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 5999706.25726 | 2095793.86202 | 37.7346334171983 | -122.443439244924 | (37.7346334171983, -122.443439244924) | 9 | 7 | 4 | 63 | 40 |
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) );