trees
3,965 rows where qSpecies_id = 70 sorted by Latitude descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
153430 | 104809 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 685 Marina Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | Permit Number 770974 | 5999736.8 | 2121509.8 | 37.8052446370698 | -122.445181890463 | (37.8052446370698, -122.445181890463) | 13 | 9 | 1 | 57 | 17 | ||||
150181 | 124995 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 251 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6000785.78079 | 2121487.92009 | 37.8052443792868 | -122.441550200077 | (37.8052443792868, -122.441550200077) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
74168 | 124838 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6001766.13786 | 2121465.01579 | 37.8052372944152 | -122.438155916785 | (37.8052372944152, -122.438155916785) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
129109 | 52614 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 230@ AVILA Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2006 12:00:00 AM | 10 | Permit Number 48779 | 6000874.42374 | 2121481.75095 | 37.8052324902599 | -122.441242997973 | (37.8052324902599, -122.441242997973) | 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 | |||
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 | |||
122265 | 124976 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3751 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999589.16481 | 2121495.98811 | 37.8051982854271 | -122.44569180475 | (37.8051982854271, -122.44569180475) | 13 | 9 | 1 | 57 | 17 | |||
114786 | 124814 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3766 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999635.68203 | 2121493.77888 | 37.8051948752069 | -122.445530667815 | (37.8051948752069, -122.445530667815) | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
68346 | 117640 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3839 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6000083.60438 | 2121466.9257 | 37.8051467048289 | -122.443978652001 | (37.8051467048289, -122.443978652001) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
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 | |||
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 | |||
21431 | 124977 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3751 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999590.28353 | 2121474.47758 | 37.8051392872022 | -122.445686385433 | (37.8051392872022, -122.445686385433) | 13 | 9 | 1 | 57 | 17 | |||
10690 | 124815 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3766 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999638.74415 | 2121468.4947 | 37.8051256264981 | -122.44551825176 | (37.8051256264981, -122.44551825176) | 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 | |||
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 | |||
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 | |||
114751 | 125012 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 799 Marina Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999213.87978 | 2121467.47063 | 37.8050985506219 | -122.446988466155 | (37.8050985506219, -122.446988466155) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
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 | |||
139192 | 125011 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 799 Marina Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999200.00704 | 2121464.14199 | 37.8050886184966 | -122.447036234534 | (37.8050886184966, -122.447036234534) | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
154473 | 142986 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 291 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010426.2416 | 2120953.9134 | 37.8043226486754 | -122.40815034039 | (37.8043226486754, -122.40815034039) | 3 | 1 | 10 | 308 | 23 | |||
27065 | 142985 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 293 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010414.8862 | 2120952.2911 | 37.8043175584205 | -122.408189522377 | (37.8043175584205, -122.408189522377) | 3 | 1 | 10 | 308 | 23 | |||
33821 | 142984 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 295 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010405.1529 | 2120950.1282 | 37.8043110746273 | -122.408223052773 | (37.8043110746273, -122.408223052773) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
184677 | 142570 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2237 MASON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6008911.8135 | 2120966.7828 | 37.8042730722163 | -122.413392071992 | (37.8042730722163, -122.413392071992) | 3 | 1 | 10 | 308 | 23 | |||
123018 | 142571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2237 MASON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6008916.052 | 2120946.0612 | 37.8042164138671 | -122.413375937957 | (37.8042164138671, -122.413375937957) | 3 | 1 | 10 | 308 | 23 | |||
119753 | 102623 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 351 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010148.1574 | 2120916.7901 | 37.8042051428233 | -122.409110056734 | (37.8042051428233, -122.409110056734) | 3 | 1 | 10 | 308 | 23 |
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) );