Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
158420 | 158420 | 124824 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000864.5368099995 | 2121488.01218 | 37.805249118725 | -122.44127766236099 | (37.805249118725, -122.441277662361) | |||
122594 | 122594 | 104809 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 685 Marina Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 770974 | 5999736.8 | 2121509.8 | 37.8052446370698 | -122.445181890463 | (37.8052446370698, -122.445181890463) | ||||
65509 | 65509 | 124995 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 251 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000785.78079 | 2121487.92009 | 37.8052443792868 | -122.441550200077 | (37.8052443792868, -122.441550200077) | |||
185154 | 185154 | 140112 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 84 VANDEWATER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6009019.9173 | 2121317.2474 | 37.8052414292046 | -122.41304276436001 | (37.8052414292046, -122.41304276436) | |||
64981 | 64981 | 124838 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 80 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 6001766.13786 | 2121465.01579 | 37.8052372944152 | -122.43815591678499 | (37.8052372944152, -122.438155916785) | |||
27813 | 27813 | 140113 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 84 VANDEWATER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6009000.3362 | 2121315.7016 | 37.8052360856065 | -122.41311041806999 | (37.8052360856065, -122.41311041807) | |||
169164 | 169164 | 52614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 230@ AVILA Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2006 12:00:00 AM | 10 | Permit Number 48779 | 6000874.42374 | 2121481.75095 | 37.8052324902599 | -122.441242997973 | (37.8052324902599, -122.441242997973) | ||
153485 | 153485 | 142642 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2350 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6008900.3697 | 2121311.0639 | 37.805217739247205 | -122.413456037604 | (37.8052177392472, -122.413456037604) | |||
174779 | 174779 | 142641 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 90 VANDEWATER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6008933.8636 | 2121305.911 | 37.805205471231105 | -122.413339762783 | (37.8052054712311, -122.413339762783) | |||
162476 | 162476 | 125048 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3101 Van Ness Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6005420.68062 | 2121375.93261 | 37.8051998601557 | -122.42550256169599 | (37.8051998601557, -122.425502561696) | |||
162547 | 162547 | 124976 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3751 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999589.16481 | 2121495.98811 | 37.8051982854271 | -122.44569180475 | (37.8051982854271, -122.44569180475) | |||
162155 | 162155 | 124814 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3766 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999635.682030001 | 2121493.77888 | 37.8051948752069 | -122.44553066781499 | (37.8051948752069, -122.445530667815) | |||
179489 | 179489 | 124837 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 74 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001772.172780001 | 2121441.71119 | 37.805173649400295 | -122.43813336178002 | (37.8051736494003, -122.43813336178) | |||
46909 | 46909 | 124855 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Casa Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001720.89506 | 2121441.74849 | 37.805170835422004 | -122.438310816889 | (37.805170835422, -122.438310816889) | |||
41670 | 41670 | 142660 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 85 Vandewater St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6008994.668 | 2121289.937 | 37.8051650242759 | -122.41312821068999 | (37.8051650242759, -122.41312821069) | |||
76571 | 76571 | 142665 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 87 Vandewater St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6008980.7551 | 2121289.4217 | 37.8051628283357 | -122.413176321677 | (37.8051628283357, -122.413176321677) | |||
158460 | 158460 | 142664 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 89 Vandewater St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6008968.9034 | 2121287.3605 | 37.80515650344 | -122.41321719022 | (37.80515650344, -122.41321719022) | |||
48401 | 48401 | 124856 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Casa Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001727.95085 | 2121436.12662 | 37.805155800572706 | -122.438285996516 | (37.8051558005727, -122.438285996516) | |||
34242 | 34242 | 142663 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 91 Vandewater St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6008956.5365 | 2121285.8147 | 37.80515156476479 | -122.41325987814301 | (37.8051515647648, -122.413259878143) | |||
135254 | 135254 | 117640 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3839 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6000083.60438 | 2121466.9257 | 37.8051467048289 | -122.443978652001 | (37.8051467048289, -122.443978652001) | |||
166054 | 166054 | 142662 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 93 Vandewater St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6008939.5318 | 2121284.2688 | 37.805146365416896 | -122.413318615775 | (37.8051463654169, -122.413318615775) | |||
73653 | 73653 | 124836 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 66 Retiro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001774.9431 | 2121429.3686599997 | 37.80513991764771 | -122.43812289007201 | (37.8051399176477, -122.438122890072) | |||
62022 | 62022 | 124857 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Casa Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001735.95246 | 2121430.00924 | 37.8051394589735 | -122.438257867517 | (37.8051394589735, -122.438257867517) | |||
76657 | 76657 | 124977 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3751 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999590.283530001 | 2121474.4775799997 | 37.8051392872022 | -122.445686385433 | (37.8051392872022, -122.445686385433) | |||
52518 | 52518 | 124815 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3766 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999638.74415 | 2121468.4947 | 37.8051256264981 | -122.44551825176 | (37.8051256264981, -122.44551825176) | |||
42156 | 42156 | 124996 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 233 Cervantes Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 2ft | 6000861.45694 | 2121438.45328 | 37.8051128678164 | -122.441284762493 | (37.8051128678164, -122.441284762493) | |||
178779 | 178779 | 117641 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3839 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000085.9118 | 2121452.90349 | 37.8051083352412 | -122.443969658797 | (37.8051083352412, -122.443969658797) | |||
161417 | 161417 | 124858 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 55 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001741.90446 | 2121417.2680200003 | 37.805104813493294 | -122.43823635661998 | (37.8051048134933, -122.43823635662) | |||
52104 | 52104 | 124835 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 66 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001776.28867 | 2121415.66492 | 37.805102367345704 | -122.43811725131201 | (37.8051023673457, -122.438117251312) | |||
188772 | 188772 | 125012 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 799 Marina Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999213.87978 | 2121467.47063 | 37.8050985506219 | -122.44698846615499 | (37.8050985506219, -122.446988466155) | |||
32390 | 32390 | 142668 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2310 MASON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6008906.5532 | 2121265.7183 | 37.8050935787991 | -122.41343142985001 | (37.8050935787991, -122.41343142985) | |||
134701 | 134701 | 124978 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3751 Broderick St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999596.26924 | 2121456.63185 | 37.805090629397505 | -122.44566438710501 | (37.8050906293975, -122.445664387105) | |||
123724 | 123724 | 125011 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 799 Marina Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999200.0070400005 | 2121464.1419900004 | 37.8050886184966 | -122.447036234534 | (37.8050886184966, -122.447036234534) | |||
100882 | 100882 | 99854 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 755 Marina Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x7 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.805088551244204 | -122.446400961387 | (37.8050885512442, -122.446400961387) | |||
124199 | 124199 | 99853 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 755 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x12 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.805088551244204 | -122.446400961387 | (37.8050885512442, -122.446400961387) | |||
28569 | 28569 | 116888 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 799X Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5999171.6155 | 2121461.35655 | 37.80507934829679 | -122.447134285827 | (37.8050793482968, -122.447134285827) | |||
135685 | 135685 | 114420 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 227 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000878.35425 | 2121425.6538 | 37.8050786864012 | -122.44122536857999 | (37.8050786864012, -122.44122536858) | |||
175605 | 175605 | 124859 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 55 Retiro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001743.08696 | 2121405.10216 | 37.8050714765314 | -122.438231392365 | (37.8050714765314, -122.438231392365) | |||
72804 | 72804 | 124834 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Retiro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6001777.197790001 | 2121403.36061 | 37.8050686346845 | -122.43811322324899 | (37.8050686346845, -122.438113223249) | |||
65860 | 65860 | 117642 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3839 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6000088.97702 | 2121437.83021 | 37.8050671229244 | -122.443957967589 | (37.8050671229244, -122.443957967589) | |||
170886 | 170886 | 124816 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3766 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5999641.32764 | 2121440.48851 | 37.805048876559404 | -122.44550729622298 | (37.8050488765594, -122.445507296223) | |||
104493 | 104493 | 115074 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2371X MASON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6008645.0 | 2121254.0 | 37.805046714355505 | -122.414335738873 | (37.8050467143555, -122.414335738873) | |||
77569 | 77569 | 98569 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301X Francisco St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
111189 | 111189 | 98571 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301X Francisco St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
53668 | 53668 | 124979 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3751 Broderick St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999598.096369999 | 2121437.70787 | 37.805038773582 | -122.445656702412 | (37.805038773582, -122.445656702412) | |||
187982 | 187982 | 124833 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001778.79024 | 2121390.34711 | 37.8050329936375 | -122.438106779619 | (37.8050329936375, -122.438106779619) | |||
25294 | 25294 | 117643 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3839 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6000091.76635 | 2121421.98639 | 37.805023779173496 | -122.443947175743 | (37.8050237791735, -122.443947175743) | |||
26948 | 26948 | 124860 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 55 Retiro Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001745.3408699995 | 2121386.96215 | 37.8050217970778 | -122.438222292145 | (37.8050217970778, -122.438222292145) | |||
167917 | 167917 | 124861 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 55 Retiro Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001746.80672 | 2121376.93282 | 37.8049943425735 | -122.43821650049 | (37.8049943425735, -122.43821650049) | |||
177187 | 177187 | 142667 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2310 MASON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008909.645 | 2121229.1326 | 37.804993297242206 | -122.413418141285 | (37.8049932972422, -122.413418141285) | |||
146981 | 146981 | 80074 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3720 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 6002094.445730001 | 2121362.10917 | 37.804973406361206 | -122.43701239642598 | (37.8049734063612, -122.437012396426) | ||||
173155 | 173155 | 124862 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001736.54326 | 2121366.19398 | 37.804964272841396 | -122.438251248491 | (37.8049642728414, -122.438251248491) | |||
57411 | 57411 | 124863 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Rico Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001725.02336 | 2121364.0520900004 | 37.8049577365759 | -122.438290960774 | (37.8049577365759, -122.438290960774) | |||
1523 | 1523 | 142666 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2310 MASON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6008911.1908 | 2121214.7045 | 37.8049537680909 | -122.413411770849 | (37.8049537680909, -122.413411770849) | |||
67435 | 67435 | 124864 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Rico Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001713.03536 | 2121362.3958099997 | 37.804952507028496 | -122.438332327771 | (37.8049525070285, -122.438332327771) | |||
41349 | 41349 | 124865 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Rico Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001701.0624 | 2121361.45357 | 37.804949238885996 | -122.438373693902 | (37.804949238886, -122.438373693902) | |||
68278 | 68278 | 124866 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 12 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001683.07545 | 2121358.73098 | 37.804940740282895 | -122.43843574443501 | (37.8049407402829, -122.438435744435) | |||
4570 | 4570 | 142547 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301 FRANCISCO ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 20 | Width 0ft | 6009612.5597 | 2121193.6724 | 37.804935373675605 | -122.41098310943799 | (37.8049353736756, -122.410983109438) | |||
72714 | 72714 | 124867 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 12 Rico Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001659.8265 | 2121355.87963 | 37.8049315887888 | -122.438515995417 | (37.8049315887888, -122.438515995417) | |||
4568 | 4568 | 142545 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301 FRANCISCO ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 20 | Width 0ft | 6009562.3577 | 2121186.5007 | 37.80491286675579 | -122.41115633279499 | (37.8049128667558, -122.411156332795) | |||
154199 | 154199 | 124832 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 48 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001785.82044 | 2121336.42463 | 37.804885336651004 | -122.438078585852 | (37.804885336651, -122.438078585852) | |||
157721 | 157721 | 103939 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2300 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6008915.3132 | 2121187.3941 | 37.8048790120409 | -122.413395572179 | (37.8048790120409, -122.413395572179) | ||||
188416 | 188416 | 103938 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2300 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6008916.3437 | 2121176.0576 | 37.80484794271371 | -122.413391203795 | (37.8048479427137, -122.413391203795) | ||||
54656 | 54656 | 103940 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2300 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | |||||
155711 | 155711 | 124825 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 190 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6001088.45735 | 2121331.42825 | 37.804831934000795 | -122.44049152176001 | (37.8048319340008, -122.44049152176) | |||
50994 | 50994 | 124831 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 42 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001789.09706 | 2121314.79977 | 37.804826146873104 | -122.438065696786 | (37.8048261468731, -122.438065696786) | |||
3374 | 3374 | 26538 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6008873.5963 | 2121134.1535 | 37.8047304843802 | -122.413536170716 | (37.8047304843802, -122.413536170716) | |||
6881 | 6881 | 26539 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6008853.6446 | 2121130.7332 | 37.8047199727818 | -122.413604973767 | (37.8047199727818, -122.413604973767) | |||
111265 | 111265 | 26543 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 530 Francisco St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | |||
70494 | 70494 | 124868 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 33 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001767.1744 | 2121262.67411 | 37.8046817768964 | -122.43813782600401 | (37.8046817768964, -122.438137826004) | |||
176476 | 176476 | 124980 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3715 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999618.92595 | 2121303.95434 | 37.804672711733 | -122.44557499538799 | (37.804672711733, -122.445574995388) | |||
74477 | 74477 | 124830 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 22 Retiro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001797.45608 | 2121257.6042400002 | 37.804669578513796 | -122.438032670081 | (37.8046695785138, -122.438032670081) | |||
154107 | 154107 | 124981 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3715 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999619.99781 | 2121289.3125400003 | 37.8046325704986 | -122.445570232594 | (37.8046325704986, -122.445570232594) | |||
136635 | 136635 | 124829 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 22 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6001801.25075 | 2121238.5185 | 37.8046173899385 | -122.43801817031999 | (37.8046173899385, -122.43801817032) | |||
42564 | 42564 | 124997 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 155 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 6001135.21043 | 2121244.14227 | 37.8045949320656 | -122.44032346455799 | (37.8045949320656, -122.440323464558) | |||
162484 | 162484 | 124998 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 155 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6001147.9154900005 | 2121233.5395400003 | 37.8045665431681 | -122.440278736772 | (37.8045665431681, -122.440278736772) | |||
188539 | 188539 | 125273 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3150 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6005555.61971 | 2121140.11755 | 37.8045599961102 | -122.425018799299 | (37.8045599961102, -122.425018799299) | |||
33559 | 33559 | 249811 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 0ft | 6010658.60603 | 2121034.26523 | 37.80455628281221 | -122.40735188838 | (37.8045562828122, -122.40735188838) | |||
25037 | 25037 | 249812 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Chestnut St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010650.1980099995 | 2121033.7396299997 | 37.8045543690542 | -122.40738094817699 | (37.8045543690542, -122.407380948177) | |||
89207 | 89207 | 7698 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 640 Francisco St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 6x6 | 6008421.7430194 | 2121075.8582463 | 37.804545038259505 | -122.415095730646 | (37.8045450382595, -122.415095730646) | |||
48623 | 48623 | 124869 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 19 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001772.24863 | 2121209.38367 | 37.8045357440831 | -122.438116446413 | (37.8045357440831, -122.438116446413) | |||
123109 | 123109 | 103476 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 147 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2013 12:00:00 AM | Permit Number 775299 | 6001179.7 | 2121217.2 | 37.8045234887457 | -122.440167571349 | (37.8045234887457, -122.440167571349) | |||
137458 | 137458 | 125045 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3648 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002608.49512 | 2121186.0740099996 | 37.8045192649129 | -122.43522087404699 | (37.8045192649129, -122.435220874047) | |||
185458 | 185458 | 125049 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3101 Van Ness Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6005457.64274 | 2121120.08776 | 37.8044994645471 | -122.425356431775 | (37.8044994645471, -122.425356431775) | |||
164801 | 164801 | 124999 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 145 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6001188.59055 | 2121202.52335 | 37.8044836967293 | -122.44013575177601 | (37.8044836967293, -122.440135751776) | |||
179467 | 179467 | 124870 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 15 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6001774.83404 | 2121189.88179 | 37.804482344134996 | -122.438106101537 | (37.804482344135, -122.438106101537) | |||
159528 | 159528 | 7699 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 640 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1991 12:00:00 AM | 15 | 7x7 | 6008241.9422 | 2121047.1896 | 37.804456215657 | -122.415715918685 | (37.804456215657, -122.415715918685) | ||
146387 | 146387 | 125000 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 145 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6001202.99473 | 2121192.09668 | 37.8044558879034 | -122.440085156821 | (37.8044558879034, -122.440085156821) | |||
60799 | 60799 | 142726 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 650 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 6008226.8051 | 2121045.8618 | 37.8044517189216 | -122.415768208034 | (37.8044517189216, -122.415768208034) | |||
95288 | 95288 | 7701 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 640 Francisco St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 6x6 | 6008187.1407969 | 2121043.7620312 | 37.804443723648895 | -122.415905321467 | (37.8044437236489, -122.415905321467) | |||
89284 | 89284 | 96357 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3622 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5 x6 | 5999184.0 | 2121228.0 | 37.8044393220775 | -122.44707462406299 | (37.8044393220775, -122.447074624063) | ||||
92226 | 92226 | 96356 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3622 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2011 12:00:00 AM | 2.5 x6 | 5999184.0 | 2121228.0 | 37.8044393220775 | -122.44707462406299 | (37.8044393220775, -122.447074624063) | |||
118390 | 118390 | 142567 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2237 MASON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008908.0459 | 2120998.3361 | 37.8043594981364 | -122.413407342952 | (37.8043594981364, -122.413407342952) | |||
188382 | 188382 | 142568 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2237 MASON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008908.9878 | 2120990.33 | 37.804337568276 | -122.413403516875 | (37.804337568276, -122.413403516875) | |||
42235 | 42235 | 142986 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 291 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6010426.2416 | 2120953.9134 | 37.8043226486754 | -122.40815034039 | (37.8043226486754, -122.40815034039) | |||
180878 | 180878 | 142985 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 293 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6010414.8862 | 2120952.2911 | 37.8043175584205 | -122.408189522377 | (37.8043175584205, -122.408189522377) | |||
181613 | 181613 | 142984 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 295 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010405.1529 | 2120950.1282 | 37.80431107462729 | -122.408223052773 | (37.8043110746273, -122.408223052773) | |||
155657 | 155657 | 142569 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2237 MASON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008909.9297 | 2120976.6726 | 37.8043001213615 | -122.413399290893 | (37.8043001213615, -122.413399290893) | |||
28140 | 28140 | 142570 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2237 MASON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6008911.8135 | 2120966.7828 | 37.8042730722163 | -122.41339207199199 | (37.8042730722163, -122.413392071992) | |||
181714 | 181714 | 102613 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 388 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2015 12:00:00 AM | 17 | 3x3 | 6009962.0 | 2120934.0 | 37.8042419665701 | -122.40975548693599 | (37.8042419665701, -122.409755486936) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");