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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5528 | 5528 | 23516 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2656 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/26/1994 12:00:00 AM | 30 | 5x5 | 6005775.26266 | 2119527.50037 | 37.800144566769205 | -122.42414394780899 | (37.8001445667692, -122.424143947809) | ||
5576 | 5576 | 14497 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5999071.4256 | 2111558.1482 | 37.7778820323449 | -122.446767989356 | (37.7778820323449, -122.446767989356) | |||
5588 | 5588 | 9934 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005029.63249 | 2117730.67065 | 37.7951688031463 | -122.426596098652 | (37.7951688031463, -122.426596098652) | |||
5704 | 5704 | 17832 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1977 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6004499.0246 | 2115333.9095 | 37.7885578925396 | -122.428261185185 | (37.7885578925396, -122.428261185185) | |||
5707 | 5707 | 23479 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2418 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 38 | 4x6 | 6005891.1574800005 | 2118710.22844 | 37.7979070885885 | -122.423684765642 | (37.7979070885885, -122.423684765642) | |||
5742 | 5742 | 14498 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999068.9707 | 2111582.6972 | 37.7779492973394 | -122.44677824853001 | (37.7779492973394, -122.44677824853) | |||
5759 | 5759 | 114574 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3621 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5997452.80117 | 2115716.84337 | 37.7892081146058 | -122.45266756527201 | (37.7892081146058, -122.452667565272) | |||
5765 | 5765 | 23561 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2930 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005650.5577 | 2120458.20498 | 37.8026930017358 | -122.424641718951 | (37.8026930017358, -122.424641718951) | |||
5811 | 5811 | 17867 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2126 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003744.3566 | 2115283.9831 | 37.78837807743321 | -122.430868655963 | (37.7883780774332, -122.430868655963) | |||
5814 | 5814 | 6256 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6004614.9344 | 2113276.215 | 37.7829145353129 | -122.427713486832 | (37.7829145353129, -122.427713486832) | |||
5827 | 5827 | 120505 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3001X Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5999789.0039 | 2116358.84365 | 37.7911044628415 | -122.44463077918199 | (37.7911044628415, -122.444630779182) | |||
5878 | 5878 | 5285 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1363 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001249.1303 | 2113085.1947 | 37.7821990759369 | -122.439344048338 | (37.7821990759369, -122.439344048338) | |||
5995 | 5995 | 7109 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2160 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 5997101.518999999 | 2109497.2925 | 37.772110729949105 | -122.453433718113 | (37.7721107299491, -122.453433718113) | |||
6029 | 6029 | 112618 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777210 | 6002384.2725 | 2115806.13213 | 37.7897346101096 | -122.435611691534 | (37.7897346101096, -122.435611691534) | |
6067 | 6067 | 114090 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2835 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001183.088719999 | 2115909.2328 | 37.7899493996846 | -122.43977505527701 | (37.7899493996846, -122.439775055277) | ||||
6078 | 6078 | 31879 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2135 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 18 | 4x4 | Permit Number 35317 | 6002171.6748 | 2119433.3444 | 37.7996819159911 | -122.43660699413 | (37.7996819159911, -122.43660699413) | |
6082 | 6082 | 6924 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 446 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X4 | 6005254.8423 | 2110638.1989 | 37.775707366557 | -122.425311885836 | (37.775707366557, -122.425311885836) | |||
6086 | 6086 | 7024 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1124 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002012.3902 | 2110183.0208 | 37.774273842043904 | -122.43649573066601 | (37.7742738420439, -122.436495730666) | |||
6192 | 6192 | 18042 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2815 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000288.8455 | 2114746.503 | 37.7867059051394 | -122.442785522834 | (37.7867059051394, -122.442785522834) | |||
6251 | 6251 | 18079 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2958 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999776.6083 | 2114733.1887 | 37.786640132310296 | -122.444556777947 | (37.7866401323103, -122.444556777947) | |||
6287 | 6287 | 102623 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 351 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010148.1574 | 2120916.7901 | 37.80420514282329 | -122.40911005673401 | (37.8042051428233, -122.409110056734) | |||
6334 | 6334 | 6269 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1355 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 6004413.7404 | 2113247.5728 | 37.7828245080819 | -122.42840749249201 | (37.7828245080819, -122.428407492492) | |||
6338 | 6338 | 6270 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1355 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6004445.8756 | 2113251.7643 | 37.782837835273206 | -122.428296616989 | (37.7828378352732, -122.428296616989) | |||
6364 | 6364 | 13127 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004182.8465 | 2119787.4466 | 37.8007682730329 | -122.42967287413 | (37.8007682730329, -122.42967287413) | |||
6397 | 6397 | 18075 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2945 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5999836.3647 | 2114682.6256 | 37.786504708751 | -122.444346400919 | (37.786504708751, -122.444346400919) | |||
6431 | 6431 | 6926 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 474 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005147.8848 | 2110623.4947 | 37.7756609491529 | -122.425680831948 | (37.7756609491529, -122.425680831948) | |||
6449 | 6449 | 7072 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1652 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999508.2617 | 2109836.0506 | 37.7731785369509 | -122.44513298700899 | (37.7731785369509, -122.445132987009) | |||
6466 | 6466 | 5201 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 730 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x6 | 6001603.6657 | 2110963.249 | 37.7763929190422 | -122.43796547839199 | (37.7763929190422, -122.437965478392) | |||
6476 | 6476 | 13064 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 590 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 2X2 | 6009534.3118 | 2120532.6199 | 37.8031159000828 | -122.411207170734 | (37.8031159000828, -122.411207170734) | |||
6478 | 6478 | 98738 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1150 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 3 | 4X4 | 6001885.6171 | 2112431.4484 | 37.780440254610205 | -122.43709527307301 | (37.7804402546102, -122.437095273073) | ||
6492 | 6492 | 20389 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 262X Sunset Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
6519 | 6519 | 23572 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3015 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 6005516.07344 | 2120742.37785 | 37.8034656713563 | -122.425127334879 | (37.8034656713563, -122.425127334879) | |||
6522 | 6522 | 14481 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 281 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1990 12:00:00 AM | 40 | 3X3 | 5998935.5096 | 2112063.3301 | 37.779261366231104 | -122.447274536897 | (37.7792613662311, -122.447274536897) | ||
6550 | 6550 | 114575 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3621 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5997436.353519999 | 2115714.9226900004 | 37.789201898491704 | -122.452724333156 | (37.7892018984917, -122.452724333156) | |||
6625 | 6625 | 9932 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6005031.67767 | 2117702.0644 | 37.795090373265296 | -122.42658698402501 | (37.7950903732653, -122.426586984025) | |||
6654 | 6654 | 7065 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1588 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/2014 12:00:00 AM | 30 | 3X3 | 5999848.9957 | 2109884.015 | 37.7733296774154 | -122.443957794129 | (37.7733296774154, -122.443957794129) | ||
6667 | 6667 | 17874 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2158 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003619.9977 | 2115267.4707 | 37.7883256917387 | -122.4312977384 | (37.7883256917387, -122.4312977384) | |||
6669 | 6669 | 17873 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2152 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003637.0261 | 2115269.5348 | 37.7883323242451 | -122.431238970337 | (37.7883323242451, -122.431238970337) | |||
6676 | 6676 | 102748 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2900 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x5 | Permit Number 20974 | 6001048.4849 | 2118395.3154599997 | 37.7967678705825 | -122.440419145231 | (37.7967678705825, -122.440419145231) | ||
6683 | 6683 | 7097 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1988 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x6 | 5997952.7475 | 2109617.0075 | 37.7724881931803 | -122.450497895204 | (37.7724881931803, -122.450497895204) | |||
6686 | 6686 | 114571 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3633 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777013 | 5997418.550890001 | 2115712.12008 | 37.7891931831629 | -122.452785725389 | (37.7891931831629, -122.452785725389) | ||
6716 | 6716 | 17870 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2140 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003687.0793 | 2115278.307 | 37.788359246862896 | -122.431066420843 | (37.7883592468629, -122.431066420843) | |||
6738 | 6738 | 17820 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1911 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004637.6708 | 2115354.7286 | 37.7886229005187 | -122.427782974318 | (37.7886229005187, -122.427782974318) | |||
6746 | 6746 | 20018 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
6819 | 6819 | 23867 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1460 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X6 | 6003686.8148 | 2113759.4476 | 37.7841888268021 | -122.430958893029 | (37.7841888268021, -122.430958893029) | |||
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) | |||
6885 | 6885 | 18901 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2590 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6002400.944180001 | 2115794.1415 | 37.7897026338206 | -122.435553151076 | (37.7897026338206, -122.435553151076) | |||
6886 | 6886 | 55233 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2900 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1983 12:00:00 AM | 24 | 4x5 | Permit Number 20974 | 6001057.82109 | 2118342.00896 | 37.7966220365405 | -122.440383014983 | (37.7966220365405, -122.440383014983) | |
6921 | 6921 | 53479 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3600 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1969 12:00:00 AM | 36 | 6x12 | Permit Number 6388 | 5997506.20792 | 2115767.61462 | 37.7893505789022 | -122.45248645079201 | (37.7893505789022, -122.452486450792) | |
6972 | 6972 | 17861 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2121 Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003684.0754 | 2115220.6034 | 37.7882006371659 | -122.431072693705 | (37.7882006371659, -122.431072693705) | |||
6982 | 6982 | 17878 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2189 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003500.3079 | 2115200.4578 | 37.78813490757079 | -122.431707058922 | (37.7881349075708, -122.431707058922) | |||
7022 | 7022 | 14504 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 436 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5999110.8967 | 2111284.0293 | 37.7771316270833 | -122.446611718241 | (37.7771316270833, -122.446611718241) | |||
7056 | 7056 | 110847 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2668 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778643 | 6000834.0024 | 2117585.61695 | 37.7945324365719 | -122.44110318127599 | (37.7945324365719, -122.441103181276) | |
7059 | 7059 | 18085 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2986 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x9 | 5999664.9755 | 2114716.7721 | 37.7865886861458 | -122.44494181853001 | (37.7865886861458, -122.44494181853) | |||
7077 | 7077 | 6266 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1355 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6004309.6505 | 2113217.5334 | 37.7827361367074 | -122.428765457764 | (37.7827361367074, -122.428765457764) | |||
7101 | 7101 | 7075 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1702 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5999191.7179 | 2109787.4763 | 37.7730270916611 | -122.44622445463699 | (37.7730270916611, -122.446224454637) | |||
7116 | 7116 | 7056 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1390 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6000868.0121 | 2110028.3766 | 37.77378413322079 | -122.440443239867 | (37.7737841332208, -122.440443239867) | |||
7128 | 7128 | 17833 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2003 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6004227.6624 | 2115298.5998 | 37.788445582937 | -122.429197538284 | (37.788445582937, -122.429197538284) | |||
7137 | 7137 | 6252 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6004508.0501 | 2113262.2432 | 37.78287012558321 | -122.42808226621099 | (37.7828701255832, -122.428082266211) | |||
7202 | 7202 | 23877 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1499X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6003598.0216 | 2113733.7356 | 37.784113196541796 | -122.431264249788 | (37.7841131965418, -122.431264249788) | |||
7234 | 7234 | 113746 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 840X Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6009590.33174 | 2118455.97825 | 37.7974170965836 | -122.410866557642 | (37.7974170965836, -122.410866557642) | ||||
7235 | 7235 | 120506 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3001X Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5999798.014359999 | 2116362.9569200003 | 37.791116270957 | -122.444599899165 | (37.791116270957, -122.444599899165) | |||
7251 | 7251 | 67295 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2021 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2015 12:00:00 AM | 3 | Permit Number 775844 | 5999878.81667 | 2115908.61359 | 37.7898733737087 | -122.444287662668 | (37.7898733737087, -122.444287662668) | ||
7274 | 7274 | 112384 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3080 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 6x6 | 5999474.64167 | 2116368.74438 | 37.791113704275 | -122.445719170201 | (37.791113704275, -122.445719170201) | |||
7305 | 7305 | 7157 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 719 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6003511.3637 | 2110856.3338 | 37.776207657227204 | -122.431358584421 | (37.7762076572272, -122.431358584421) | |||
7320 | 7320 | 5190 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 518 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001706.5859 | 2110230.9953 | 37.7743881862019 | -122.43755699782899 | (37.7743881862019, -122.437556997829) | |||
7369 | 7369 | 17863 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2121 Pine St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003725.8407 | 2115226.9911 | 37.7882205427126 | -122.43092864894399 | (37.7882205427126, -122.430928648944) | |||
7372 | 7372 | 6254 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 85 | 3X3 | 6004557.65 | 2113267.8319 | 37.7828882768645 | -122.427911069574 | (37.7828882768645, -122.427911069574) | |||
7496 | 7496 | 6049 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1865 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001591.0462 | 2112505.5339 | 37.7806269262997 | -122.438119638656 | (37.7806269262997, -122.438119638656) | |||
7499 | 7499 | 104699 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6011357.95285 | 2118999.80647 | 37.7990092725121 | -122.40478840238801 | (37.7990092725121, -122.404788402388) | |||
7508 | 7508 | 100204 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2237 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 5x5 | 6001902.2596 | 2114280.466 | 37.7855181330415 | -122.437170124873 | (37.7855181330415, -122.437170124873) | |||
7634 | 7634 | 5240 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100 Divisadero St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001405.3119 | 2112421.3803 | 37.780385297097205 | -122.43875614904499 | (37.7803852970972, -122.438756149045) | |||
7639 | 7639 | 18080 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2964 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999752.9685 | 2114731.2187 | 37.7866333742754 | -122.444638424012 | (37.7866333742754, -122.444638424012) | |||
7705 | 7705 | 104698 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6011319.973040001 | 2118997.1094299997 | 37.7989997441925 | -122.40491963593901 | (37.7989997441925, -122.404919635939) | |||
7729 | 7729 | 5905 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1276 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6x6 | 6004411.4514 | 2112945.733 | 37.7819956014908 | -122.42839389105801 | (37.7819956014908, -122.428393891058) | |||
7745 | 7745 | 13062 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 590 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2000 12:00:00 AM | 6 | 2X2 | 6009500.6409 | 2120545.5727 | 37.8031495768645 | -122.41132460578899 | (37.8031495768645, -122.411324605789) | ||
7768 | 7768 | 22759 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1620 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6002316.427999999 | 2112303.8634 | 37.7801144169363 | -122.435595767889 | (37.7801144169363, -122.435595767889) | |||
7780 | 7780 | 18269 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1933 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 12 | 3X3 | 6002915.6118 | 2114073.452 | 37.7850072757126 | -122.433649427379 | (37.7850072757126, -122.433649427379) | ||
7838 | 7838 | 20021 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
7853 | 7853 | 114578 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3610 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x6 | 5997431.80475 | 2115758.42968 | 37.789321096433504 | -122.45274321263099 | (37.7893210964335, -122.452743212631) | |||
7857 | 7857 | 17860 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2121 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003663.9297 | 2115217.6553 | 37.7881914008546 | -122.431142183883 | (37.7881914008546, -122.431142183883) | |||
7888 | 7888 | 17843 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2043 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004037.5783 | 2115265.5157 | 37.7883439798751 | -122.42985283841999 | (37.7883439798751, -122.42985283842) | |||
7973 | 7973 | 107590 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2760 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6000109.34681 | 2118076.29285 | 37.7958384005634 | -122.443645838983 | (37.7958384005634, -122.443645838983) | |||
8001 | 8001 | 20026 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
8005 | 8005 | 7086 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1842 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998607.747 | 2109706.8492 | 37.7727723426265 | -122.448238667085 | (37.7727723426265, -122.448238667085) | |||
8035 | 8035 | 6267 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1355 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6004345.2786 | 2113236.3953 | 37.7827899431792 | -122.42864354459499 | (37.7827899431792, -122.428643544595) | |||
8047 | 8047 | 5281 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1350 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6001314.4457 | 2113067.2583 | 37.782153543884604 | -122.439116800935 | (37.7821535438846, -122.439116800935) | |||
8063 | 8063 | 23548 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2822 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6005698.29125 | 2120114.21678 | 37.8017511939304 | -122.42445205462201 | (37.8017511939304, -122.424452054622) | |||
8111 | 8111 | 6041 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1830 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/1990 12:00:00 AM | 3 | 3X3 | 6001487.9166 | 2112537.6047 | 37.78070911887679 | -122.438478710972 | (37.7807091188768, -122.438478710972) | ||
8132 | 8132 | 23875 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1499X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6003587.5262 | 2113806.0374 | 37.7843111243358 | -122.43130572288901 | (37.7843111243358, -122.431305722889) | |||
8154 | 8154 | 104700 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6011383.62949 | 2119002.34589 | 37.7990176802704 | -122.40469973101801 | (37.7990176802704, -122.404699731018) | |||
8214 | 8214 | 23518 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/1989 12:00:00 AM | 20 | 3X3 | 6005659.14507 | 2119690.7477 | 37.800586245414294 | -122.424557378741 | (37.8005862454143, -122.424557378741) | ||
8236 | 8236 | 5312 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1750 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001109.2828 | 2114487.0108 | 37.7860401441829 | -122.43992839962799 | (37.7860401441829, -122.439928399628) | |||
8245 | 8245 | 20020 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
8261 | 8261 | 9933 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005030.19216 | 2117715.21137 | 37.7951263875274 | -122.426593060744 | (37.7951263875274, -122.426593060744) | |||
8346 | 8346 | 23481 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2440 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005877.50588 | 2118803.04662 | 37.7981611731605 | -122.423738607169 | (37.7981611731605, -122.423738607169) | |||
8403 | 8403 | 23863 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1420 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6003705.9488 | 2113626.0727 | 37.783823696929396 | -122.430883174483 | (37.7838236969294, -122.430883174483) | |||
8435 | 8435 | 19808 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY23 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
8460 | 8460 | 20385 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 262X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
8469 | 8469 | 46251 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2683 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 7 | Permit Number 777339 | 6000247.41446 | 2117804.02133 | 37.7950986884031 | -122.44314853640101 | (37.7950986884031, -122.443148536401) |
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");