trees
614 rows where qSpecies_id = 29 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
178489 | 100234 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 701X 39th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5983811.49615 | 2110876.46915 | 37.7751267903243 | -122.499506209788 | (37.7751267903243, -122.499506209788) | 11 | 6 | 2 | 55 | 26 | |||
188763 | 100236 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 701X 39th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5983814.22353 | 2110811.15249 | 37.7749476096575 | -122.499491947241 | (37.7749476096575, -122.499491947241) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
104859 | 101262 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1948 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989728.00904 | 2106533.07201 | 37.7635463706673 | -122.478722183397 | (37.7635463706673, -122.478722183397) | 1 | 8 | 3 | 56 | 35 | ||||
98374 | 101956 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 510X Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6x6 | 6012441.7 | 2108540.8 | 37.7703517934984 | -122.400303251175 | (37.7703517934984, -122.400303251175) | 14 | 2 | 8 | 28856 | 20 | |||
60116 | 102078 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 35 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769728 | 6005184.6 | 2096720.6 | 37.7374889299957 | -122.424564647037 | (37.7374889299957, -122.424564647037) | 2 | 7 | 5 | 28859 | 2 |
81022 | 102592 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 124 Baden St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 04/17/2010 12:00:00 AM | 3 | 6x6 | 6000765 | 2094428 | 37.7309433983829 | -122.439680933747 | (37.7309433983829, -122.439680933747) | 9 | 7 | 4 | 63 | 40 | |
114385 | 102595 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 133 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769795 | 6000714.8 | 2094523.9 | 37.7312038601891 | -122.439861356334 | (37.7312038601891, -122.439861356334) | 9 | 7 | 4 | 63 | 40 |
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 | |||
178523 | 105432 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 341 WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2014 12:00:00 AM | 20 | 3x3 | Permit Number 772598 | 6004076.5 | 2108982.1 | 37.7710934821162 | -122.429269947188 | (37.7710934821162, -122.429269947188) | 7 | 9 | 11 | 29492 | 10 | |
117908 | 106008 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1800X Lane St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6014836.2656 | 2094091.4986 | 37.7308103003106 | -122.391010320168 | (37.7308103003106, -122.391010320168) | 10 | 3 | 8 | 58 | 1 | |||
131587 | 106045 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2201X 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2014 12:00:00 AM | 14 | 4x14 | Permit Number 772230 | 6011471.49227 | 2104620.16703 | 37.7595324691706 | -122.403383358282 | (37.7595324691706, -122.403383358282) | 10 | 3 | 8 | 28856 | 29 | |
96947 | 106210 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 585X Bush St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774310 | 6010773.37918 | 2115862.19303 | 37.7903614528559 | -122.406590009715 | (37.7903614528559, -122.406590009715) | 5 | 1 | 10 | 28857 | 6 | |
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 | |||
104544 | 112525 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 471 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011292 | 2118586 | 37.7978693737352 | -122.404987470864 | (37.7978693737352, -122.404987470864) | 3 | 1 | 10 | 308 | 23 | ||||
178870 | 112526 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 471 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011292 | 2118586 | 37.7978693737352 | -122.404987470864 | (37.7978693737352, -122.404987470864) | 3 | 1 | 10 | 308 | 23 | ||||
108733 | 112527 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 459 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011361 | 2118561 | 37.797804586609 | -122.404746949234 | (37.797804586609, -122.404746949234) | 3 | 1 | 10 | 308 | 23 | ||||
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 | ||||
95401 | 112529 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 459 BROADWAY | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011361 | 2118561 | 37.797804586609 | -122.404746949234 | (37.797804586609, -122.404746949234) | 3 | 1 | 10 | 308 | 23 | ||||
123940 | 112530 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 435 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 07:26:00 AM | 3 | 3x3 | 6011409.86951 | 2118646.99301 | 37.7980434339179 | -122.404583902832 | (37.7980434339179, -122.404583902832) | 3 | 1 | 10 | 308 | 23 | ||
145993 | 112531 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 435 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011430 | 2118629 | 37.7979951544919 | -122.404512977901 | (37.7979951544919, -122.404512977901) | 3 | 1 | 10 | 308 | 23 | ||||
179944 | 112532 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 435 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6011441.2715 | 2118651.07916 | 37.7980564084299 | -122.404475530047 | (37.7980564084299, -122.404475530047) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
115957 | 112538 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 412 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2016 12:00:00 AM | 2 | 3x3 | 6011488.50983 | 2118723.01839 | 37.7982565759239 | -122.404317136927 | (37.7982565759239, -122.404317136927) | 3 | 1 | 10 | 308 | 23 | ||
193050 | 112539 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 426 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2016 11:10:00 AM | 3 | 3x3 | 6011460.82325 | 2118719.23159 | 37.7982446311281 | -122.404412674615 | (37.7982446311281, -122.404412674615) | 3 | 1 | 10 | 308 | 23 | ||
131847 | 112540 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 432 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011444.64707 | 2118714.34063 | 37.7982302977556 | -122.404468304876 | (37.7982302977556, -122.404468304876) | 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 | |||
5774 | 112542 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 438 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6011405.06525 | 2118709.92574 | 37.7982159634572 | -122.40460495956 | (37.7982159634572, -122.40460495956) | 3 | 1 | 10 | 308 | 23 | ||
178687 | 112543 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 448 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011394 | 2118786 | 37.798424226523 | -122.404648607058 | (37.798424226523, -122.404648607058) | 3 | 1 | 10 | 308 | 23 | ||||
95613 | 112546 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 464 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011322 | 2118712 | 37.7982170161506 | -122.404892537684 | (37.7982170161506, -122.404892537684) | 3 | 1 | 10 | 308 | 23 | |||
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 | ||||
119382 | 112588 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 TEHAMA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009004 | 2110266 | 37.7748964951756 | -122.41231625471 | (37.7748964951756, -122.41231625471) | 8 | 2 | 9 | 28853 | 34 | |||||
87519 | 112589 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 TEHAMA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009004 | 2110266 | 37.7748964951756 | -122.41231625471 | (37.7748964951756, -122.41231625471) | 8 | 2 | 9 | 28853 | 34 | |||||
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 | ||
140053 | 113423 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1583 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6015002.21794725 | 2094078.95124561 | 37.7307850551093 | -122.390435715218 | (37.7307850551093, -122.390435715218) | 10 | 3 | 8 | 58 | 1 | |||
132444 | 11343 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1300X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/1999 12:00:00 AM | 16 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.7306777467756 | -122.382320962891 | (37.7306777467756, -122.382320962891) | 10 | 3 | 8 | 58 | 1 | ||
109155 | 11347 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1300X Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/06/1997 12:00:00 AM | 18 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.7306777467756 | -122.382320962891 | (37.7306777467756, -122.382320962891) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
72383 | 117792 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3801 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5983744.15991 | 2111021.91382 | 37.7755221883124 | -122.499749889479 | (37.7755221883124, -122.499749889479) | 11 | 6 | 2 | 55 | 26 | |||
163298 | 117837 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 660x 39th Ave | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 6ft | 5983820.01458 | 2111273.23439 | 37.7762166927907 | -122.499506071449 | (37.7762166927907, -122.499506071449) | 11 | 6 | 2 | 55 | 26 | |||
190642 | 117962 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4340 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5985111.43248 | 2111810.6865 | 37.7777680685843 | -122.495078411045 | (37.7777680685843, -122.495078411045) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
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 | |||
131353 | 120769 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4500 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5989405.82896 | 2109925.10593 | 37.7728412569544 | -122.480084750137 | (37.7728412569544, -122.480084750137) | 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 | |||
187462 | 122278 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990134.53204 | 2111321.8992 | 37.7767187801238 | -122.477666227559 | (37.7767187801238, -122.477666227559) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
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 | |||
138651 | 122281 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990111.6262 | 2111320.57885 | 37.7767138255075 | -122.477745368245 | (37.7767138255075, -122.477745368245) | 11 | 6 | 2 | 55 | 26 | |||
191450 | 122282 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990106.33926 | 2111321.30269 | 37.7767155061466 | -122.477763710061 | (37.7767155061466, -122.477763710061) | 11 | 6 | 2 | 55 | 26 | |||
107679 | 122283 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990098.96698 | 2111321.01529 | 37.7767142891731 | -122.477789191669 | (37.7767142891731, -122.477789191669) | 11 | 6 | 2 | 55 | 26 | |||
135102 | 122284 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990094.44484 | 2111319.97098 | 37.7767111593397 | -122.477804758562 | (37.7767111593397, -122.477804758562) | 11 | 6 | 2 | 55 | 26 | |||
110347 | 122285 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990089.24883 | 2111319.73817 | 37.7767102185501 | -122.477822715879 | (37.7767102185501, -122.477822715879) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
117671 | 122287 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990077.48759 | 2111319.81791 | 37.7767097549041 | -122.477863406875 | (37.7767097549041, -122.477863406875) | 11 | 6 | 2 | 55 | 26 | |||
87071 | 122288 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990072.17969 | 2111319.40231 | 37.7767083057208 | -122.477881737882 | (37.7767083057208, -122.477881737882) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
80392 | 124542 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992469.9646 | 2111331.12947 | 37.776879377114 | -122.46958801958 | (37.776879377114, -122.46958801958) | 11 | 6 | 2 | 54 | 11 | |||
109657 | 124543 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992464.59444 | 2111330.54171 | 37.7768774529142 | -122.469606553628 | (37.7768774529142, -122.469606553628) | 11 | 6 | 2 | 54 | 11 | |||
122245 | 124544 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992459.19305 | 2111330.13563 | 37.7768760257506 | -122.469625208938 | (37.7768760257506, -122.469625208938) | 11 | 6 | 2 | 54 | 11 | |||
96775 | 124545 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992450.31032 | 2111329.62958 | 37.776874122883 | -122.46965589987 | (37.776874122883, -122.46965589987) | 11 | 6 | 2 | 54 | 11 | |||
81683 | 124546 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992441.4203 | 2111328.77742 | 37.7768712692618 | -122.469686590816 | (37.7768712692618, -122.469686590816) | 11 | 6 | 2 | 54 | 11 | |||
181144 | 13408 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 364 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 45 | 5 | 5999660.108164 | 2097381.7238333 | 37.7389906787724 | -122.443712833155 | (37.7389906787724, -122.443712833155) | 9 | 7 | 4 | 59 | 40 | |||
185546 | 136299 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 21 Mallorca Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001939.11813 | 2119948.35287 | 37.8010827755037 | -122.43744862338 | (37.8010827755037, -122.43744862338) | 13 | 9 | 1 | 57 | 17 | |||
72922 | 136300 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 119 Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997500.20956 | 2116012.95103 | 37.7900238635497 | -122.452524916594 | (37.7900238635497, -122.452524916594) | 11 | 6 | 1 | 54 | 31 | |||
108417 | 136301 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 119 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997498.90653 | 2116025.43206 | 37.790058058469 | -122.452530326034 | (37.790058058469, -122.452530326034) | 11 | 6 | 1 | 54 | 31 | |||
83156 | 136302 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3362 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998728.18247 | 2115610.02714 | 37.788987820287 | -122.448247225637 | (37.788987820287, -122.448247225637) | 13 | 6 | 1 | 54 | 31 | |||
127392 | 136303 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008623.1195 | 2116351.39928 | 37.7915841594399 | -122.414064409258 | (37.7915841594399, -122.414064409258) | 5 | 1 | 10 | 28857 | 21 | |||
70236 | 136304 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008621.36418 | 2116364.4323 | 37.791619846337 | -122.414071405095 | (37.791619846337, -122.414071405095) | 5 | 1 | 10 | 28857 | 21 | |||
91849 | 136305 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008618.49447 | 2116385.90895 | 37.7916786547855 | -122.414082854345 | (37.7916786547855, -122.414082854345) | 5 | 1 | 10 | 28857 | 21 | |||
89184 | 136306 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008615.34001 | 2116402.44898 | 37.7917238924876 | -122.414094939449 | (37.7917238924876, -122.414094939449) | 5 | 1 | 10 | 28857 | 21 | |||
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 | |||
168528 | 136308 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008610.17492 | 2116437.51898 | 37.7918198960214 | -122.414115292883 | (37.7918198960214, -122.414115292883) | 5 | 1 | 10 | 28857 | 21 | |||
78187 | 136309 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008608.17525 | 2116456.59832 | 37.7918721709048 | -122.41412356217 | (37.7918721709048, -122.41412356217) | 5 | 1 | 10 | 28857 | 21 | |||
173586 | 136310 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008741.78085 | 2116636.60472 | 37.7923739278622 | -122.413674022565 | (37.7923739278622, -122.413674022565) | 5 | 1 | 10 | 28857 | 21 | |||
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 | |||
91621 | 136312 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008787.57627 | 2116642.7504 | 37.7923933739042 | -122.413516003555 | (37.7923933739042, -122.413516003555) | 5 | 1 | 10 | 28857 | 21 | |||
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 | |||
143437 | 136314 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 107 Bernard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008318.73536 | 2118064.92593 | 37.796271980829 | -122.415238929252 | (37.796271980829, -122.415238929252) | 5 | 1 | 10 | 28858 | 21 | |||
100100 | 136315 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 895 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009067.06929 | 2119033.92208 | 37.7989746333364 | -122.41271806751 | (37.7989746333364, -122.41271806751) | 3 | 1 | 10 | 308 | 21 | |||
177388 | 136316 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 895 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009084.75499 | 2119036.14381 | 37.798981726274 | -122.412657026025 | (37.798981726274, -122.412657026025) | 3 | 1 | 10 | 308 | 21 | |||
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 | |||
180060 | 136318 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2431 Jones St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6007955.59027 | 2120758.45752 | 37.8036473290331 | -122.416686400679 | (37.8036473290331, -122.416686400679) | 5 | 1 | 1 | 308 | 32 | |||
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 | |||
75438 | 136320 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 99 North Point St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6010568.43745 | 2122006.80544 | 37.8072215900736 | -122.407732543518 | (37.8072215900736, -122.407732543518) | 3 | 1 | 10 | 308 | 23 | |||
190698 | 136321 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Francisco St | 13 | Front Yard : Yard | Tree | Private 2 | 7 | 6010437.78302 | 2121369.6786 | 37.8054648831642 | -122.408139740375 | (37.8054648831642, -122.408139740375) | 3 | 1 | 10 | 308 | 23 | ||||
53841 | 136322 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 360 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 1 | Width 5ft | 6011695.90155 | 2118747.3363 | 37.7983349338553 | -122.403601207338 | (37.7983349338553, -122.403601207338) | 3 | 1 | 10 | 308 | 23 | ||
167630 | 136323 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 360 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 1 | Width 5ft | Permit Number 775228 | 6011675.19116 | 2118742.88561 | 37.7983215564568 | -122.403672558643 | (37.7983215564568, -122.403672558643) | 3 | 1 | 10 | 308 | 23 | |
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 | |||
133154 | 136325 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 464 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011322 | 2118712 | 37.7982170161506 | -122.404892537684 | (37.7982170161506, -122.404892537684) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
115176 | 136327 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 463 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011305.85301 | 2118630.68117 | 37.7979928317715 | -122.404942682854 | (37.7979928317715, -122.404942682854) | 3 | 1 | 10 | 308 | 23 | |||
126649 | 136328 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 447 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6011327.03299 | 2118633.79421 | 37.7980025633245 | -122.404869612942 | (37.7980025633245, -122.404869612942) | 3 | 1 | 10 | 308 | 23 | |||
154166 | 136329 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 447 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6011341.08824 | 2118636.57968 | 37.7980109971731 | -122.404821173685 | (37.7980109971731, -122.404821173685) | 3 | 1 | 10 | 308 | 23 | |||
135679 | 136330 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 447 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6011365.83057 | 2118639.85606 | 37.7980213762507 | -122.40473578842 | (37.7980213762507, -122.40473578842) | 3 | 1 | 10 | 308 | 23 | |||
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 |
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) );