3,965 rows where qSpecies_id = 70 sorted by YCoord descending

View and edit SQL

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)
8928 116888 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 799X Marina Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5999171.6155 2121461.35655 37.8050793482968 -122.447134285827 (37.8050793482968, -122.447134285827) 13 9 1 57 17
23626 99853 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 755 Marina Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       3x12 Permit Number 768797 5999383.5 2121460.3 37.8050885512442 -122.446400961387 (37.8050885512442, -122.446400961387) 13 9 1 57 17
111262 99854 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 755 Marina Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       4x7 Permit Number 768797 5999383.5 2121460.3 37.8050885512442 -122.446400961387 (37.8050885512442, -122.446400961387) 13 9 1 57 17
99541 124978 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3751 Broderick St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5999596.26924 2121456.63185 37.8050906293975 -122.445664387105 (37.8050906293975, -122.445664387105) 13 9 1 57 17
140405 117641 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3839 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6000085.9118 2121452.90349 37.8051083352412 -122.443969658797 (37.8051083352412, -122.443969658797) 13 9 1 57 17
104514 87964 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 393 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50997 6008895 2121449 37.8055961756376 -122.413484381593 (37.8055961756376, -122.413484381593) 3 1 10 308 23
105134 87963 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 393 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50997 6008895 2121449 37.8055961756376 -122.413484381593 (37.8055961756376, -122.413484381593) 3 1 10 308 23
26679 124855 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1 Casa Way 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6001720.89506 2121441.74849 37.805170835422 -122.438310816889 (37.805170835422, -122.438310816889) 13 9 1 57 17
178651 124837 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 74 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6001772.17278 2121441.71119 37.8051736494003 -122.43813336178 (37.8051736494003, -122.43813336178) 13 9 1 57 17
70360 124816 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3766 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5999641.32764 2121440.48851 37.8050488765594 -122.445507296223 (37.8050488765594, -122.445507296223) 13 9 1 57 17
40598 124996 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 233 Cervantes Blvd 4 Sidewalk: Curb side : Yard Tree Private 2     24 Width 2ft   6000861.45694 2121438.45328 37.8051128678164 -122.441284762493 (37.8051128678164, -122.441284762493) 13 9 1 57 17
115236 117642 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3839 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6000088.97702 2121437.83021 37.8050671229244 -122.443957967589 (37.8050671229244, -122.443957967589) 13 9 1 57 17
48848 124979 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3751 Broderick St 13 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999598.09637 2121437.70787 37.805038773582 -122.445656702412 (37.805038773582, -122.445656702412) 13 9 1 57 17
36994 124856 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1 Casa Way 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001727.95085 2121436.12662 37.8051558005727 -122.438285996516 (37.8051558005727, -122.438285996516) 13 9 1 57 17
193342 124857 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1 Casa Way 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6001735.95246 2121430.00924 37.8051394589735 -122.438257867517 (37.8051394589735, -122.438257867517) 13 9 1 57 17
31521 124836 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 66 Retiro Way 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001774.9431 2121429.36866 37.8051399176477 -122.438122890072 (37.8051399176477, -122.438122890072) 13 9 1 57 17
146956 114420 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 227 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6000878.35425 2121425.6538 37.8050786864012 -122.44122536858 (37.8050786864012, -122.44122536858) 13 9 1 57 17
38358 117643 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3839 Divisadero St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6000091.76635 2121421.98639 37.8050237791735 -122.443947175743 (37.8050237791735, -122.443947175743) 13 9 1 57 17
74425 125047 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3101 Van Ness Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   6005418.05896 2121421.58215 37.8053250538732 -122.425514885098 (37.8053250538732, -122.425514885098) 13 1 1 28858 17
133038 124858 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 55 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001741.90446 2121417.26802 37.8051048134933 -122.43823635662 (37.8051048134933, -122.43823635662) 13 9 1 57 17
100822 124835 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 66 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001776.28867 2121415.66492 37.8051023673457 -122.438117251312 (37.8051023673457, -122.438117251312) 13 9 1 57 17
63951 23585 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3205X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005442.50763 2121408.51694 37.8052905615414 -122.42542934689 (37.8052905615414, -122.42542934689) 13 1 1 28858 17
144581 124859 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 55 Retiro Way 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6001743.08696 2121405.10216 37.8050714765314 -122.438231392365 (37.8050714765314, -122.438231392365) 13 9 1 57 17
23702 124834 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 60 Retiro Way 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6001777.19779 2121403.36061 37.8050686346845 -122.438113223249 (37.8050686346845, -122.438113223249) 13 9 1 57 17
27408 124833 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 60 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001778.79024 2121390.34711 37.8050329936375 -122.438106779619 (37.8050329936375, -122.438106779619) 13 9 1 57 17
41148 124860 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 55 Retiro Way 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001745.34087 2121386.96215 37.8050217970778 -122.438222292145 (37.8050217970778, -122.438222292145) 13 9 1 57 17
185173 124861 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 55 Retiro Way 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001746.80672 2121376.93282 37.8049943425735 -122.43821650049 (37.8049943425735, -122.43821650049) 13 9 1 57 17
36288 125048 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3101 Van Ness Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6005420.68062 2121375.93261 37.8051998601557 -122.425502561696 (37.8051998601557, -122.425502561696) 13 1 1 28858 17
43856 111715 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2390x MASON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008938 2121373 37.8053899130211 -122.413330195558 (37.8053899130211, -122.413330195558) 3 1 10 308 23
74577 49310 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 499@ Taylor Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2003 12:00:00 AM     Permit Number 46313 6008403.82866353 2121370.35158903 37.8053526360585 -122.415178583983 (37.8053526360585, -122.415178583983) 5 1 10 308 23
77458 124862 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Rico Way 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6001736.54326 2121366.19398 37.8049642728414 -122.438251248491 (37.8049642728414, -122.438251248491) 13 9 1 57 17
93778 124863 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Rico Way 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001725.02336 2121364.05209 37.8049577365759 -122.438290960774 (37.8049577365759, -122.438290960774) 13 9 1 57 17
185184 124864 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Rico Way 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001713.03536 2121362.39581 37.8049525070285 -122.438332327771 (37.8049525070285, -122.438332327771) 13 9 1 57 17
171455 80074 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3720 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     17     6002094.44573 2121362.10917 37.8049734063612 -122.437012396426 (37.8049734063612, -122.437012396426) 13 9 1 57 17
103981 124865 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Rico Way 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6001701.0624 2121361.45357 37.804949238886 -122.438373693902 (37.804949238886, -122.438373693902) 13 9 1 57 17
22959 124866 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 12 Rico Way 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001683.07545 2121358.73098 37.8049407402829 -122.438435744435 (37.8049407402829, -122.438435744435) 13 9 1 57 17
148537 124867 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 12 Rico Way 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001659.8265 2121355.87963 37.8049315887888 -122.438515995417 (37.8049315887888, -122.438515995417) 13 9 1 57 17
122162 124832 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 48 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001785.82044 2121336.42463 37.804885336651 -122.438078585852 (37.804885336651, -122.438078585852) 13 9 1 57 17
52622 124825 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 190 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6001088.45735 2121331.42825 37.8048319340008 -122.44049152176 (37.8048319340008, -122.44049152176) 13 9 1 57 17
92681 115442 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 99x Vandewater St 3 Sidewalk: Curb side : Cutout Tree Private 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
95648 115441 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 99x Vandewater St 2 Sidewalk: Curb side : Cutout Tree Private 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
137554 115443 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 99x Vandewater St 4 Sidewalk: Curb side : Cutout Tree Private 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
150284 115440 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 99x Vandewater St 1 Sidewalk: Curb side : Cutout Tree Private 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
156023 115444 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 99x Vandewater St 5 Sidewalk: Curb side : Cutout Tree Private 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
121057 140112 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 84 VANDEWATER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30 Width 0ft   6009019.9173 2121317.2474 37.8052414292046 -122.41304276436 (37.8052414292046, -122.41304276436) 3 1 10 308 23
125494 140113 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 84 VANDEWATER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   6009000.3362 2121315.7016 37.8052360856065 -122.41311041807 (37.8052360856065, -122.41311041807) 3 1 10 308 23
98848 124831 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 42 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6001789.09706 2121314.79977 37.8048261468731 -122.438065696786 (37.8048261468731, -122.438065696786) 13 9 1 57 17
37511 142642 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2350 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6008900.3697 2121311.0639 37.8052177392472 -122.413456037604 (37.8052177392472, -122.413456037604) 3 1 10 308 23
51179 142641 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 90 VANDEWATER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6008933.8636 2121305.911 37.8052054712311 -122.413339762783 (37.8052054712311, -122.413339762783) 3 1 10 308 23
53909 124980 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3715 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5999618.92595 2121303.95434 37.804672711733 -122.445574995388 (37.804672711733, -122.445574995388) 13 9 1 57 17
60685 142660 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 85 Vandewater St 5 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6008994.668 2121289.937 37.8051650242759 -122.41312821069 (37.8051650242759, -122.41312821069) 3 1 10 308 23
19982 142665 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 87 Vandewater St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6008980.7551 2121289.4217 37.8051628283357 -122.413176321677 (37.8051628283357, -122.413176321677) 3 1 10 308 23
77812 124981 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3715 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5999619.99781 2121289.31254 37.8046325704986 -122.445570232594 (37.8046325704986, -122.445570232594) 13 9 1 57 17
184531 142664 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 89 Vandewater St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6008968.9034 2121287.3605 37.80515650344 -122.41321719022 (37.80515650344, -122.41321719022) 3 1 10 308 23
56732 142663 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 91 Vandewater St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6008956.5365 2121285.8147 37.8051515647648 -122.413259878143 (37.8051515647648, -122.413259878143) 3 1 10 308 23
61875 142662 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 93 Vandewater St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   6008939.5318 2121284.2688 37.8051463654169 -122.413318615775 (37.8051463654169, -122.413318615775) 3 1 10 308 23
118907 142668 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2310 MASON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6008906.5532 2121265.7183 37.8050935787991 -122.41343142985 (37.8050935787991, -122.41343142985) 3 1 10 308 23
160968 124868 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 33 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6001767.1744 2121262.67411 37.8046817768964 -122.438137826004 (37.8046817768964, -122.438137826004) 13 9 1 57 17
38186 124830 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 22 Retiro Way 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001797.45608 2121257.60424 37.8046695785138 -122.438032670081 (37.8046695785138, -122.438032670081) 13 9 1 57 17
116392 115074 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2371X MASON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6008645 2121254 37.8050467143555 -122.414335738873 (37.8050467143555, -122.414335738873) 3 1 10 308 23
91078 124997 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 155 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 2ft   6001135.21043 2121244.14227 37.8045949320656 -122.440323464558 (37.8045949320656, -122.440323464558) 13 9 1 57 17
74953 124829 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 22 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6001801.25075 2121238.5185 37.8046173899385 -122.43801817032 (37.8046173899385, -122.43801817032) 13 9 1 57 17
33207 124998 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 155 Cervantes Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6001147.91549 2121233.53954 37.8045665431681 -122.440278736772 (37.8045665431681, -122.440278736772) 13 9 1 57 17
57165 142667 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2310 MASON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6008909.645 2121229.1326 37.8049932972422 -122.413418141285 (37.8049932972422, -122.413418141285) 3 1 10 308 23
66241 96357 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 3622 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2       2.5 x6   5999184 2121228 37.8044393220775 -122.447074624063 (37.8044393220775, -122.447074624063) 13 9 1 57 17
77387 96356 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 3622 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2011 12:00:00 AM   2.5 x6   5999184 2121228 37.8044393220775 -122.447074624063 (37.8044393220775, -122.447074624063) 13 9 1 57 17
22336 98569 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301X Francisco St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
137680 98571 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301X Francisco St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
162685 103476 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 147 Cervantes Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2013 12:00:00 AM     Permit Number 775299 6001179.7 2121217.2 37.8045234887457 -122.440167571349 (37.8045234887457, -122.440167571349) 13 9 1 57 17
54642 124869 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 19 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001772.24863 2121209.38367 37.8045357440831 -122.438116446413 (37.8045357440831, -122.438116446413) 13 9 1 57 17
167669 124999 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 145 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6001188.59055 2121202.52335 37.8044836967293 -122.440135751776 (37.8044836967293, -122.440135751776) 13 9 1 57 17
65057 142547 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301 FRANCISCO ST 9 Sidewalk: Curb side : Cutout Tree SFUSD 4     20 Width 0ft   6009612.5597 2121193.6724 37.8049353736756 -122.410983109438 (37.8049353736756, -122.410983109438) 3 1 10 308 23
73722 125000 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 145 Cervantes Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6001202.99473 2121192.09668 37.8044558879034 -122.440085156821 (37.8044558879034, -122.440085156821) 13 9 1 57 17
39246 124870 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 15 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6001774.83404 2121189.88179 37.804482344135 -122.438106101537 (37.804482344135, -122.438106101537) 13 9 1 57 17
73593 103939 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2300 Mason St 3 Sidewalk: Curb side : Cutout Tree Private 2     9     6008915.3132 2121187.3941 37.8048790120409 -122.413395572179 (37.8048790120409, -122.413395572179) 3 1 10 308 23
66275 142545 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301 FRANCISCO ST 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     20 Width 0ft   6009562.3577 2121186.5007 37.8049128667558 -122.411156332795 (37.8049128667558, -122.411156332795) 3 1 10 308 23
141019 125045 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3648 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002608.49512 2121186.07401 37.8045192649129 -122.435220874047 (37.8045192649129, -122.435220874047) 13 9 1 57 17
142547 103938 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2300 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2     15     6008916.3437 2121176.0576 37.8048479427137 -122.413391203795 (37.8048479427137, -122.413391203795) 3 1 10 308 23
16200 103940 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2300 Mason St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008943.2 2121170.5 37.804834190774 -122.413297871125 (37.804834190774, -122.413297871125) 3 1 10 308 23
84049 142666 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2300 Mason St 4 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 0ft   6008943 2121170 37.8048328066707 -122.413298527868 (37.8048328066707, -122.413298527868) 3 1 10 308 23
41195 125273 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3150 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 5ft   6005555.61971 2121140.11755 37.8045599961102 -122.425018799299 (37.8045599961102, -122.425018799299) 5 1 1 28858 32
43886 26538 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 500 Francisco St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6008873.5963 2121134.1535 37.8047304843802 -122.413536170716 (37.8047304843802, -122.413536170716) 3 1 10 308 23
127829 26539 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 500 Francisco St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6008853.6446 2121130.7332 37.8047199727818 -122.413604973767 (37.8047199727818, -122.413604973767) 3 1 10 308 23
135320 26543 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 530 Francisco St 5 Sidewalk: Curb side : Cutout Tree DPW 1     24 4X4   6008751.4918274 2121120.9717011 37.8046874335197 -122.41395779393 (37.8046874335197, -122.41395779393) 3 1 10 308 23
72168 125049 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3101 Van Ness Ave 15 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6005457.64274 2121120.08776 37.8044994645471 -122.425356431775 (37.8044994645471, -122.425356431775) 13 1 1 28858 17
68675 7698 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 640 Francisco St 6 Sidewalk: Curb side : Cutout Tree DPW 1     14 6x6   6008421.7430194 2121075.8582463 37.8045450382595 -122.415095730646 (37.8045450382595, -122.415095730646) 5 1 10 308 23
45352 29770 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 640 Francisco St 3 Sidewalk: Curb side : Cutout Tree DPW 1     22 6x6   6008266.3741 2121051.4386 37.8044692557294 -122.415631670711 (37.8044692557294, -122.415631670711) 5 1 10 308 23
109012 7699 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 640 Francisco St 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/21/1991 12:00:00 AM 15 7x7   6008241.9422 2121047.1896 37.804456215657 -122.415715918685 (37.804456215657, -122.415715918685) 5 1 10 308 23
83589 7701 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 640 Francisco St 5 Sidewalk: Curb side : Cutout Tree DPW 1     16 6x6   6008187.1407969 2121043.7620312 37.8044437236489 -122.415905321467 (37.8044437236489, -122.415905321467) 5 1 10 308 23
141874 249811 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 260 Chestnut St 1 Front Yard : Yard Tree Private 2     11 Width 0ft   6010658.60603 2121034.26523 37.8045562828122 -122.40735188838 (37.8045562828122, -122.40735188838) 3 1 10 308 23
90893 249812 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 260 Chestnut St 2 Front Yard : Yard Tree Private 2     14 Width 0ft   6010650.19801 2121033.73963 37.8045543690542 -122.407380948177 (37.8045543690542, -122.407380948177) 3 1 10 308 23
66735 125042 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3601 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6002587.96608 2121001.45923 37.8040111956201 -122.435278703153 (37.8040111956201, -122.435278703153) 13 9 1 57 17
26287 119617 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3536 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/02/2016 12:00:00 AM 3 3x10   5999214.99092 2121000.37655 37.8038161003064 -122.446950987796 (37.8038161003064, -122.446950987796) 13 9 1 57 17
147170 142567 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2237 MASON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6008908.0459 2120998.3361 37.8043594981364 -122.413407342952 (37.8043594981364, -122.413407342952) 3 1 10 308 23
176030 142568 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2237 MASON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6008908.9878 2120990.33 37.804337568276 -122.413403516875 (37.804337568276, -122.413403516875) 3 1 10 308 23
172324 23575 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3100X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6005553.25134 2120985.40407 37.8041350589572 -122.425015980687 (37.8041350589572, -122.425015980687) 5 1 1 28858 32
97065 125043 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3601 Webster St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6002590.33245 2120984.42962 37.8039645711809 -122.435269295337 (37.8039645711809, -122.435269295337) 13 9 1 57 17
40162 95366 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3101X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   14 3x3   6005504.90819 2120981.97244 37.8041229057048 -122.425183031522 (37.8041229057048, -122.425183031522) 13 9 1 28858 17
126560 142569 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2237 MASON ST 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008909.9297 2120976.6726 37.8043001213615 -122.413399290893 (37.8043001213615, -122.413399290893) 3 1 10 308 23
73425 125001 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 89 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6001511.47441 2120975.96758 37.8038800115288 -122.439002139235 (37.8038800115288, -122.439002139235) 13 9 1 57 17

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);