trees
614 rows where qSpecies_id = 29 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1858 | 124541 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992474.53157 | 2111331.5451 | 37.7768807822685 | -122.46957225145 | (37.7768807822685, -122.46957225145) | 11 | 6 | 2 | 54 | 11 | |||
| 2004 | 73758 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2220 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988694.03882 | 2110577.4842 | 37.7745911237516 | -122.482594698718 | (37.7745911237516, -122.482594698718) | 11 | 6 | 2 | 55 | 26 | |||
| 2740 | 74867 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997417.18704 | 2116038.42588 | 37.7900890536146 | -122.452814005488 | (37.7900890536146, -122.452814005488) | 11 | 6 | 1 | 54 | 31 | |||
| 2771 | 240393 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 35 Hill St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6006109.51353 | 2103440.58038 | 37.7559926584484 | -122.421843980221 | (37.7559926584484, -122.421843980221) | 2 | 4 | 5 | 28859 | 19 | |||
| 3822 | 74719 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997437.82689 | 2116041.06971 | 37.7900974955643 | -122.452742784551 | (37.7900974955643, -122.452742784551) | 11 | 6 | 1 | 54 | 31 | |||
| 4031 | 73753 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2019 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989295.11737 | 2111227.81825 | 37.7764117112404 | -122.480563089536 | (37.7764117112404, -122.480563089536) | 11 | 6 | 2 | 55 | 26 | |||
| 5160 | 240388 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008348.72479 | 2098315.88712 | 37.7420474227613 | -122.413737549756 | (37.7420474227613, -122.413737549756) | 2 | 7 | 7 | 28859 | 2 | |||
| 6470 | 78275 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014137.61661 | 2094337.23888 | 37.7314462603177 | -122.393442871089 | (37.7314462603177, -122.393442871089) | 10 | 3 | 8 | 58 | 1 | |||
| 7825 | 197345 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008901.33871 | 2110395.02653 | 37.7752450102959 | -122.412680506426 | (37.7752450102959, -122.412680506426) | 8 | 2 | 9 | 28853 | 34 | |||
| 8833 | 240424 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 6 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002452.23233 | 2096379.1355 | 37.7363966594644 | -122.433987315365 | (37.7363966594644, -122.433987315365) | 2 | 7 | 5 | 63 | 7 | |||
| 9509 | 136313 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008832.97743 | 2116650.20878 | 37.7924164019518 | -122.413359441492 | (37.7924164019518, -122.413359441492) | 5 | 1 | 10 | 28857 | 21 | |||
| 12126 | 184960 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1990 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983549.8392 | 2101614.3877 | 37.7496803803898 | -122.499726609203 | (37.7496803803898, -122.499726609203) | 1 | 8 | 3 | 29491 | 35 | |||
| 12169 | 70387 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 81 Lyell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003118.96111 | 2094567.61018 | 37.7314604381496 | -122.431552867694 | (37.7314604381496, -122.431552867694) | 9 | 7 | 5 | 28861 | 25 | |||
| 13087 | 103083 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012579.2635 | 2114003.58062 | 37.785359006363 | -122.400211142746 | (37.785359006363, -122.400211142746) | 12 | 2 | 9 | 28855 | 6 | |||
| 13360 | 75003 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5997399.30482 | 2116036.40743 | 37.7900824867734 | -122.452875730442 | (37.7900824867734, -122.452875730442) | 11 | 6 | 1 | 54 | 31 | |||
| 13609 | 200054 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1800 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6014879.1353 | 2094151.956 | 37.7309786828797 | -122.39086633517 | (37.7309786828797, -122.39086633517) | 10 | 3 | 8 | 58 | 1 | |||
| 13641 | 136307 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008614.23308 | 2116420.22843 | 37.7917726483359 | -122.41410002782 | (37.7917726483359, -122.41410002782) | 5 | 1 | 10 | 28857 | 21 | |||
| 13916 | 240385 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 310 Gates St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008245.55924 | 2097104.87481 | 37.7387164553078 | -122.41400861353 | (37.7387164553078, -122.41400861353) | 2 | 7 | 7 | 28859 | 2 | |||
| 13949 | 70219 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2519 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5999766.96115 | 2119470.28489 | 37.7996463981067 | -122.444930811031 | (37.7996463981067, -122.444930811031) | 13 | 9 | 1 | 57 | 17 | |||
| 13999 | 73403 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 81 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003121.92331 | 2094558.5911 | 37.7314358416937 | -122.43154198317 | (37.7314358416937, -122.43154198317) | 9 | 7 | 5 | 28861 | 25 | |||
| 14362 | 197348 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009001.8467 | 2110254.60923 | 37.7748650979682 | -122.412322898178 | (37.7748650979682, -122.412322898178) | 8 | 2 | 9 | 28853 | 34 | |||
| 14387 | 181350 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2270 25th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5988575.9018 | 2099879.6972 | 37.7452110255779 | -122.48221942867 | (37.7452110255779, -122.48221942867) | 1 | 8 | 3 | 29491 | 35 | |||
| 16030 | 72309 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3555 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997281.41005 | 2116017.68654 | 37.7900243276015 | -122.453282282457 | (37.7900243276015, -122.453282282457) | 11 | 6 | 1 | 54 | 31 | |||
| 16645 | 74566 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997456.57692 | 2116043.58234 | 37.7901054689466 | -122.452678092717 | (37.7901054689466, -122.452678092717) | 11 | 6 | 1 | 54 | 31 | |||
| 16920 | 78303 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4200 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5985601.84615 | 2111830.05832 | 37.7778499560934 | -122.493383352985 | (37.7778499560934, -122.493383352985) | 11 | 6 | 2 | 55 | 26 | |||
| 17790 | 181349 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2254 29th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5987333.026 | 2099936.24 | 37.7452939056167 | -122.486521176816 | (37.7452939056167, -122.486521176816) | 1 | 8 | 3 | 29491 | 35 | |||
| 18662 | 72377 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2015 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5989328.1004 | 2111226.70664 | 37.776410575889 | -122.480448911859 | (37.776410575889, -122.480448911859) | 11 | 6 | 2 | 55 | 26 | |||
| 19085 | 70121 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2220 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988662.20068 | 2110577.24438 | 37.7745886129839 | -122.482704814222 | (37.7745886129839, -122.482704814222) | 11 | 6 | 2 | 55 | 26 | |||
| 20373 | 122290 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990062.61204 | 2111318.02169 | 37.7767039596239 | -122.477914733898 | (37.7767039596239, -122.477914733898) | 11 | 6 | 2 | 55 | 26 | |||
| 20573 | 122277 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990139.99053 | 2111321.69927 | 37.7767185479371 | -122.477647330613 | (37.7767185479371, -122.477647330613) | 11 | 6 | 2 | 55 | 26 | |||
| 20954 | 137686 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2143 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999343.9567 | 2111495.7816 | 37.7777263543907 | -122.445820725833 | (37.7777263543907, -122.445820725833) | 15 | 5 | 11 | 54 | 16 | |||
| 21474 | 183295 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1262 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981829.8203 | 2106490.9182 | 37.7629688694519 | -122.506035915679 | (37.7629688694519, -122.506035915679) | 1 | 8 | 3 | 56 | 35 | |||
| 21889 | 240418 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001776.14511 | 2096508.83113 | 37.73671438186 | -122.436334107928 | (37.73671438186, -122.436334107928) | 2 | 7 | 5 | 63 | 7 | |||
| 23177 | 29219 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1902X 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
| 23194 | 136319 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 99 North Point St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6010537.58998 | 2122003.14861 | 37.8072098224406 | -122.407839040359 | (37.8072098224406, -122.407839040359) | 3 | 1 | 10 | 308 | 23 | |||
| 23269 | 1772 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2000X Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | |||
| 23748 | 124092 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 601 Funston Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5991890.07496 | 2111196.52278 | 37.7764762519633 | -122.471584203691 | (37.7764762519633, -122.471584203691) | 11 | 6 | 2 | 54 | 11 | ||||
| 24081 | 118563 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 8000 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5982185.81739 | 2112405.54556 | 37.7792296683273 | -122.505243048821 | (37.7792296683273, -122.505243048821) | 11 | 6 | 2 | 55 | 26 | |||
| 26259 | 217579 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 636 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5992273.5996 | 2088560.7555 | 37.7143464128453 | -122.468610110073 | (37.7143464128453, -122.468610110073) | 9 | 8 | 6 | 64 | 24 | |||
| 27362 | 197344 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012519.57167 | 2113947.09446 | 37.7852005799736 | -122.400413690752 | (37.7852005799736, -122.400413690752) | 12 | 2 | 9 | 28855 | 6 | |||
| 29514 | 214024 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000768.15588 | 2094464.11739 | 37.7310427480136 | -122.439672611702 | (37.7310427480136, -122.439672611702) | 9 | 7 | 4 | 63 | 40 | |||
| 30102 | 184465 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2182 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5982354.8718 | 2100269.3302 | 37.7459170344363 | -122.503759179813 | (37.7459170344363, -122.503759179813) | 1 | 8 | 3 | 29491 | 35 | |||
| 31150 | 214014 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1462 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992138.11746 | 2105483.85764 | 37.7608051492715 | -122.47031004699 | (37.7608051492715, -122.47031004699) | 1 | 8 | 4 | 56 | 12 | |||
| 31447 | 240421 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 3 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002440.89213 | 2096392.57557 | 37.7364329192297 | -122.434027483591 | (37.7364329192297, -122.434027483591) | 2 | 7 | 5 | 63 | 7 | |||
| 31605 | 118182 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 615 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985646.49411 | 2111667.23632 | 37.7774055049593 | -122.493216904169 | (37.7774055049593, -122.493216904169) | 11 | 6 | 2 | 55 | 26 | |||
| 32542 | 214022 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 659 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997050.53703 | 2094389.33231 | 37.7306251064676 | -122.452519591711 | (37.7306251064676, -122.452519591711) | 9 | 7 | 4 | 28861 | 40 | |||
| 33110 | 197353 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 22nd St | 13 | Side Yard : Yard | Tree | Private 2 | 4 | 6012786.799 | 2103803.61301 | 37.7573637666391 | -122.398777038841 | (37.7573637666391, -122.398777038841) | 10 | 3 | 8 | 28856 | 29 | ||||
| 33474 | 10670 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1045 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002868.6063491 | 2110598.6567928 | 37.7754636919659 | -122.433563635643 | (37.7754636919659, -122.433563635643) | 15 | 5 | 11 | 29492 | 10 | |||
| 35846 | 113422 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1583 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x3 | 6015014.3399 | 2094064.2928 | 37.7307454784064 | -122.390392783554 | (37.7307454784064, -122.390392783554) | 10 | 3 | 8 | 58 | 1 | ||
| 36318 | 112537 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 412 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011527.0722 | 2118728.84616 | 37.7982747323527 | -122.404184109226 | (37.7982747323527, -122.404184109226) | 3 | 1 | 10 | 308 | 23 | |||
| 36465 | 214012 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1479 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992097.04207 | 2105377.93896 | 37.7605119495939 | -122.47044439309 | (37.7605119495939, -122.47044439309) | 1 | 8 | 4 | 56 | 12 | |||
| 39109 | 186232 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984802.7052 | 2103358.5602 | 37.7545428359635 | -122.495522842112 | (37.7545428359635, -122.495522842112) | 1 | 8 | 3 | 56 | 35 | |||
| 39553 | 214034 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 218 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 5998609.02608 | 2093807.55818 | 37.7291168615442 | -122.447089829625 | (37.7291168615442, -122.447089829625) | 9 | 7 | 4 | 28861 | 40 | |||
| 40164 | 136317 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 954 Vallejo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008931.36114 | 2118725.70113 | 37.7981207171523 | -122.413165857925 | (37.7981207171523, -122.413165857925) | 3 | 1 | 10 | 308 | 21 | |||
| 40883 | 240415 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 751 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003800.46059 | 2107711.4253 | 37.7675888874331 | -122.430134113409 | (37.7675888874331, -122.430134113409) | 7 | 9 | 5 | 28862 | 3 | |||
| 40932 | 179375 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 778 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001912.74857 | 2089301.24621 | 37.7169317492882 | -122.435346396016 | (37.7169317492882, -122.435346396016) | 9 | 7 | 6 | 28861 | 5 | |||
| 41119 | 184434 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3816 Quintara St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981590.8846 | 2100821.8038 | 37.7473890220179 | -122.506441860059 | (37.7473890220179, -122.506441860059) | 1 | 8 | 3 | 29491 | 35 | |||
| 41839 | 122286 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990082.62166 | 2111319.5038 | 37.7767091904138 | -122.477845623834 | (37.7767091904138, -122.477845623834) | 11 | 6 | 2 | 55 | 26 | |||
| 41944 | 140855 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 621 Euclid Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996425.9427 | 2113796.2189 | 37.7838757026194 | -122.456081435491 | (37.7838757026194, -122.456081435491) | 11 | 6 | 1 | 54 | 31 | |||
| 42377 | 140854 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 623 Euclid Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996411.3906 | 2113796.8958 | 37.7838767259243 | -122.456131829019 | (37.7838767259243, -122.456131829019) | 11 | 6 | 1 | 54 | 31 | |||
| 44625 | 186236 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984809.6691 | 2103350.7929 | 37.7545219168817 | -122.495498186629 | (37.7545219168817, -122.495498186629) | 1 | 8 | 3 | 56 | 35 | |||
| 45022 | 240381 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 98 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008070.80857 | 2107998.41684 | 37.7686178359612 | -122.415383805538 | (37.7686178359612, -122.415383805538) | 8 | 4 | 7 | 28853 | 19 | |||
| 45935 | 7243 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1929X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002956.0424065 | 2114080.0912444 | 37.7850277993699 | -122.433510025097 | (37.7850277993699, -122.433510025097) | 13 | 9 | 11 | 29490 | 13 | |||
| 45998 | 112547 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 462 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011324 | 2118723 | 37.798247331278 | -122.404886391926 | (37.798247331278, -122.404886391926) | 3 | 1 | 10 | 308 | 23 | ||||
| 49755 | 112541 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 438 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011421.73685 | 2118713.41459 | 37.798226474727 | -122.404547516275 | (37.798226474727, -122.404547516275) | 3 | 1 | 10 | 308 | 23 | |||
| 51701 | 98673 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
| 51794 | 214043 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 212 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998768.52981 | 2093586.90837 | 37.7285201208974 | -122.446522546303 | (37.7285201208974, -122.446522546303) | 9 | 7 | 4 | 28861 | 40 | |||
| 51945 | 214035 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 142 Staples Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999120.59989 | 2093807.09624 | 37.7291448088802 | -122.445321250796 | (37.7291448088802, -122.445321250796) | 9 | 7 | 4 | 28861 | 40 | ||||
| 52077 | 122289 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990067.41245 | 2111319.50308 | 37.7767083057233 | -122.477898236364 | (37.7767083057233, -122.477898236364) | 11 | 6 | 2 | 55 | 26 | |||
| 52120 | 136324 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 448 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011401 | 2118734 | 37.798281838344 | -122.404620722239 | (37.798281838344, -122.404620722239) | 3 | 1 | 10 | 308 | 23 | |||
| 52593 | 98672 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
| 53151 | 122280 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990124.51868 | 2111321.36168 | 37.7767167231412 | -122.477700827061 | (37.7767167231412, -122.477700827061) | 11 | 6 | 2 | 55 | 26 | |||
| 55616 | 140094 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1652 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999863.0392 | 2110926.6558 | 37.7761933050322 | -122.44398414486 | (37.7761933050322, -122.44398414486) | 15 | 5 | 11 | 29492 | 16 | |||
| 57321 | 179374 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 906 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001350.07755 | 2088911.8778 | 37.71583065984 | -122.437263408906 | (37.71583065984, -122.437263408906) | 9 | 7 | 6 | 28861 | 5 | |||
| 58083 | 201725 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1915 Quesada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 2 | 6013561.8417 | 2095888.78027 | 37.7356744661038 | -122.395542109982 | (37.7356744661038, -122.395542109982) | 10 | 3 | 8 | 58 | 1 | ||||
| 58114 | 197341 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 696 Amador St | 3 | Front Yard : Yard | Tree | Private 2 | 21 | 6016796.90554 | 2099573.89089 | 37.745972446388 | -122.384613749949 | (37.745972446388, -122.384613749949) | 10 | 3 | 8 | 58 | 1 | ||||
| 58215 | 240423 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 5 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002449.92079 | 2096381.92143 | 37.7364041778047 | -122.433995506402 | (37.7364041778047, -122.433995506402) | 2 | 7 | 5 | 63 | 7 | |||
| 58885 | 197342 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012547.87891 | 2113973.86639 | 37.785275667977 | -122.400317636871 | (37.785275667977, -122.400317636871) | 12 | 2 | 9 | 28855 | 6 | |||
| 59349 | 136311 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008756.30767 | 2116638.98455 | 37.7923812780273 | -122.413623927626 | (37.7923812780273, -122.413623927626) | 5 | 1 | 10 | 28857 | 21 | |||
| 59848 | 112528 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 459 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011361 | 2118561 | 37.797804586609 | -122.404746949234 | (37.797804586609, -122.404746949234) | 3 | 1 | 10 | 308 | 23 | ||||
| 60862 | 240422 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 4 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002442.71855 | 2096389.33655 | 37.7364241292793 | -122.434020937432 | (37.7364241292793, -122.434020937432) | 2 | 7 | 5 | 63 | 7 | |||
| 61307 | 34 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 759 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003742.09963 | 2107707.87999 | 37.7675758472752 | -122.430335723414 | (37.7675758472752, -122.430335723414) | 7 | 9 | 5 | 28862 | 3 | |||
| 61566 | 214027 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 130 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6000768.47308 | 2094513.82924 | 37.7311792633149 | -122.439675077667 | (37.7311792633149, -122.439675077667) | 9 | 7 | 4 | 63 | 40 | |||
| 61871 | 117228 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 66 POTOMAC ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003144 | 2108708 | 37.7702880357607 | -122.432475913278 | (37.7702880357607, -122.432475913278) | 15 | 5 | 5 | 29492 | 9 | |||
| 62258 | 214017 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1438 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993685.58433 | 2105688.82171 | 37.7614572746516 | -122.464972976223 | (37.7614572746516, -122.464972976223) | 1 | 8 | 11 | 56 | 12 | |||
| 62872 | 240373 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1373 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6010904.97586 | 2101974.91384 | 37.7522375329589 | -122.405156394162 | (37.7522375329589, -122.405156394162) | 10 | 4 | 8 | 28859 | 19 | |||
| 64517 | 179382 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 143 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007980.64963 | 2093237.82874 | 37.7280835045466 | -122.414650965095 | (37.7280835045466, -122.414650965095) | 9 | 3 | 7 | 309 | 28 | |||
| 64703 | 183216 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3150 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983362.6255 | 2100199.941 | 37.7457857131054 | -122.500269432817 | (37.7457857131054, -122.500269432817) | 1 | 8 | 3 | 29491 | 35 | |||
| 64803 | 214023 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 111 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000598.84895 | 2094335.44716 | 37.7306798113107 | -122.440248709336 | (37.7306798113107, -122.440248709336) | 9 | 7 | 4 | 63 | 40 | |||
| 64914 | 122279 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990130.41151 | 2111322.13937 | 37.7767192004406 | -122.477680499098 | (37.7767192004406, -122.477680499098) | 11 | 6 | 2 | 55 | 26 | |||
| 65177 | 136326 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 463 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011288.49181 | 2118628.67213 | 37.79798634496 | -122.405002616378 | (37.79798634496, -122.405002616378) | 3 | 1 | 10 | 308 | 23 | |||
| 66246 | 100238 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 701X 39th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5983814.58777 | 2110777.43528 | 37.7748550533025 | -122.499488194975 | (37.7748550533025, -122.499488194975) | 11 | 6 | 2 | 55 | 26 | |||
| 67315 | 240401 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 499 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000694.66286 | 2101176.32982 | 37.749468718214 | -122.440407898332 | (37.749468718214, -122.440407898332) | 2 | 4 | 5 | 28862 | 22 | |||
| 67379 | 186234 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984803.2409 | 2103355.3462 | 37.7545340425765 | -122.495520752512 | (37.7545340425765, -122.495520752512) | 1 | 8 | 3 | 56 | 35 | |||
| 67662 | 240398 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1636 Diamond St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6002001.74432 | 2099212.54095 | 37.7441509550044 | -122.435747497273 | (37.7441509550044, -122.435747497273) | 2 | 7 | 5 | 63 | 22 | |||
| 68958 | 246759 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 70 Waltham St | 3 | Front Yard : Yard | Tree | Private 2 | 8 | 6009196.74806 | 2098886.80636 | 37.7436626276403 | -122.410845655606 | (37.7436626276403, -122.410845655606) | 2 | 7 | 7 | 28859 | 2 | ||||
| 69114 | 122462 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1351 42nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | 1 | 8 | 3 | 56 | 35 | ||||
| 69393 | 184400 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2087 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5982288.7103 | 2100911.824 | 37.747677253327 | -122.504035534429 | (37.747677253327, -122.504035534429) | 1 | 8 | 3 | 29491 | 35 | |||
| 69805 | 179380 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 77 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5993077.06779 | 2086425.74691 | 37.7085305695939 | -122.465678009642 | (37.7085305695939, -122.465678009642) | 9 | 8 | 6 | 28861 | 25 | |||
| 70017 | 240417 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001765.76464 | 2096530.83358 | 37.7367742056673 | -122.436371571893 | (37.7367742056673, -122.436371571893) | 2 | 7 | 5 | 63 | 7 |
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) );