Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | 5 | 188702 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Evans Ave | 2 | : 4 | Tree 1 | DPW 2 | 17 | Width 4ft | 6015994.71985 | 2098219.31717 | 37.7422086702947 | -122.387293152263 | (37.7422086702947, -122.387293152263) | |||
| 7 | 7 | 188697 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Evans Ave | 13 | : 4 | Tree 1 | DPW 2 | 15 | Width 3ft | 6017236.81305 | 2097292.98379 | 37.7397338556296 | -122.38293388291001 | (37.7397338556296, -122.38293388291) | |||
| 29 | 29 | 188686 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Evans Ave | 20 | : 4 | Tree 1 | DPW 2 | 12 | Width 3ft | 6017760.57019 | 2097020.5910900002 | 37.739014844955705 | -122.381104000867 | (37.7390148449557, -122.381104000867) | |||
| 74 | 74 | 188665 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2175X Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 37 | 6011669.71313 | 2097723.45025 | 37.740606653987705 | -122.402212916691 | (37.7406066539877, -122.402212916691) | ||||
| 105 | 105 | 6251 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/06/2003 12:00:00 AM | 24 | 3X3 | 6004480.8051 | 2113256.6545 | 37.7828532389184 | -122.428176124144 | (37.7828532389184, -122.428176124144) | ||
| 341 | 341 | 14553 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 875 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999239.2853 | 2109883.9856 | 37.7732947980524 | -122.446066856713 | (37.7732947980524, -122.446066856713) | |||
| 613 | 613 | 20019 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 854 | 854 | 203901 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3794 19th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 12 | Width 3ft | 5990470.121669999 | 2090714.3108400002 | 37.720155198286 | -122.475000685058 | (37.720155198286, -122.475000685058) | |||
| 1022 | 1022 | 186874 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 0ft | 5985204.8462 | 2096382.2812 | 37.7354114037883 | -122.493618136413 | (37.7354114037883, -122.493618136413) | |||
| 1059 | 1059 | 186952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 0ft | 5985204.8226 | 2096075.4539 | 37.734568936321295 | -122.493595616872 | (37.7345689363213, -122.493595616872) | |||
| 1084 | 1084 | 8287 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1601 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2017 12:00:00 AM | 6 | 3x3 | 6015799.31492 | 2097666.33838 | 37.7406794801837 | -122.387930230222 | (37.7406794801837, -122.387930230222) | ||
| 1109 | 1109 | 20024 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 1171 | 1171 | 172952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3000X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 0 | Width 3ft | 6005556.34576 | 2120733.12845 | 37.8034425497953 | -122.42498731221201 | (37.8034425497953, -122.424987312212) | ||
| 1175 | 1175 | 2161 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x100 | 6009743.36579 | 2090187.72527 | 37.71980743673429 | -122.408342124702 | (37.7198074367343, -122.408342124702) | |||
| 1297 | 1297 | 245226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 451 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | Width 0ft | 6005125.512 | 2110566.2977 | 37.7755026358833 | -122.42575415301701 | (37.7755026358833, -122.425754153017) | |||
| 1309 | 1309 | 9930 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6005037.50257 | 2117672.2143200003 | 37.7950087418189 | -122.42656470240699 | (37.7950087418189, -122.426564702407) | |||
| 1376 | 1376 | 141859 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1126 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 0ft | 6004579.5781 | 2112622.703 | 37.7811181533984 | -122.42778922577801 | (37.7811181533984, -122.427789225778) | |||
| 1479 | 1479 | 23464 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2305 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005842.187999999 | 2118344.10635 | 37.796899045714504 | -122.423828167031 | (37.7968990457145, -122.423828167031) | |||
| 1500 | 1500 | 251574 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 191 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999731.0 | 2100707.0 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | ||||
| 1555 | 1555 | 18077 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2946 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5999820.6048 | 2114741.0687 | 37.7866642791044 | -122.44440512772499 | (37.7866642791044, -122.444405127725) | |||
| 1647 | 1647 | 20023 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 1784 | 1784 | 7098 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2006 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5997799.556 | 2109595.5069 | 37.772420388962296 | -122.451026246506 | (37.7724203889623, -122.451026246506) | |||
| 1983 | 1983 | 124970 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 170 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | Width 4ft | 5999252.18429 | 2119704.33945 | 37.8002596566144 | -122.446728969472 | (37.8002596566144, -122.446728969472) | |||
| 2007 | 2007 | 124969 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150 Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 4ft | 5999290.62404 | 2119668.8610400003 | 37.800164438189896 | -122.44659339936199 | (37.8001644381899, -122.446593399362) | |||
| 2110 | 2110 | 140215 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 736 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | Width 0ft | 6003875.2018 | 2110441.9467 | 37.7750904655336 | -122.430070401808 | (37.7750904655336, -122.430070401808) | |||
| 2269 | 2269 | 125219 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2269 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 4ft | 6003923.5815 | 2115960.33762 | 37.7902453288032 | -122.430296840347 | (37.7902453288032, -122.430296840347) | |||
| 2529 | 2529 | 141382 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1294X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001285.0 | 2110102.0 | 37.7740100190711 | -122.439006092772 | (37.7740100190711, -122.439006092772) | |||
| 2681 | 2681 | 10334 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 850 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 6002067.0 | 2109164.0 | 37.7714789673294 | -122.436233885162 | (37.7714789673294, -122.436233885162) | |||
| 2794 | 2794 | 7088 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1864 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998522.1287 | 2109694.9471 | 37.7727347674481 | -122.448533971797 | (37.7727347674481, -122.448533971797) | |||
| 2828 | 2828 | 7026 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1138 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 6001973.7961 | 2110177.6605 | 37.7742569308448 | -122.436628850709 | (37.7742569308448, -122.436628850709) | |||
| 2844 | 2844 | 17858 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2121 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003631.9915 | 2115212.7417 | 37.7881760994608 | -122.43125233371799 | (37.7881760994608, -122.431252333718) | |||
| 2971 | 2971 | 7062 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6000002.1366 | 2109905.8257 | 37.773398298516 | -122.44342962722 | (37.773398298516, -122.44342962722) | |||
| 3010 | 3010 | 245175 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1128 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 0ft | 6000703.1785 | 2108961.6377 | 37.770845749220705 | -122.44093688299 | (37.7708457492207, -122.44093688299) | |||
| 3196 | 3196 | 9420 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6005985.41292 | 2112474.4888400002 | 37.780790619431706 | -122.422915195091 | (37.7807906194317, -122.422915195091) | |||
| 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) | |||
| 3385 | 3385 | 23505 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2600 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5x5 | 6005801.9507 | 2119345.52815 | 37.7996464242096 | -122.424038648866 | (37.7996464242096, -122.424038648866) | |||
| 3503 | 3503 | 14499 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4x4 | 5999064.4701 | 2111602.7455 | 37.7780040877061 | -122.44679526057199 | (37.7780040877061, -122.446795260572) | |||
| 3572 | 3572 | 7105 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2130 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 5997237.8283 | 2109516.8856 | 37.7721723399981 | -122.452963630149 | (37.7721723399981, -122.452963630149) | |||
| 3767 | 3767 | 7104 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2100 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5997303.9815 | 2109524.8914 | 37.7721981126985 | -122.452735379757 | (37.7721981126985, -122.452735379757) | |||
| 3819 | 3819 | 19829 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY25 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 4407 | 4407 | 5225 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1034 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001461.1836 | 2111997.0255 | 37.779223304768 | -122.43853244967698 | (37.779223304768, -122.438532449677) | |||
| 4446 | 4446 | 253627 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 5991061.0 | 2093828.0 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | ||||
| 4479 | 4479 | 18084 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2982 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4.5x15 | 5999689.9288 | 2114724.6521 | 37.786611746671205 | -122.444856053153 | (37.7866117466712, -122.444856053153) | |||
| 5001 | 5001 | 17864 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2121 Pine St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003749.9172 | 2115228.4651 | 37.78822595410529 | -122.430845453567 | (37.7882259541053, -122.430845453567) | |||
| 5165 | 5165 | 18104 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3047 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999356.199 | 2114621.5583 | 37.786309626644 | -122.446003255008 | (37.786309626644, -122.446003255008) | |||
| 5167 | 5167 | 27271 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2134 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 2X2 | 6006018.78384 | 2117780.42149 | 37.7953612769429 | -122.42317701472 | (37.7953612769429, -122.42317701472) | |||
| 5281 | 5281 | 17859 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2121 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003647.2236 | 2115215.6899 | 37.7881850576658 | -122.431199843789 | (37.7881850576658, -122.431199843789) | |||
| 5371 | 5371 | 18271 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1949 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002897.9436 | 2114073.452 | 37.785006273193495 | -122.43371055367399 | (37.7850062731935, -122.433710553674) | |||
| 5383 | 5383 | 23482 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2450 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6005868.84657 | 2118854.8733 | 37.7983029872579 | -122.423772257989 | (37.7983029872579, -122.423772257989) | |||
| 5388 | 5388 | 6963 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004011.7809 | 2110463.0214 | 37.7751560657789 | -122.42959944801599 | (37.7751560657789, -122.429599448016) | |||
| 5395 | 5395 | 5286 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1363 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001243.7155 | 2113125.1285 | 37.78230841581821 | -122.439365644426 | (37.7823084158182, -122.439365644426) | |||
| 5421 | 5421 | 13063 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 590 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X2 | 6009554.3361 | 2120533.7978 | 37.803120257284 | -122.41113795910499 | (37.803120257284, -122.411137959105) | |||
| 5472 | 5472 | 6255 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 55 | 3X3 | 6004589.0866 | 2113270.6263 | 37.782897727980206 | -122.427802511173 | (37.7828977279802, -122.427802511173) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 6171 | 6171 | 8616 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2600 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999337.0471 | 2113224.2861 | 37.78247198716561 | -122.44596898090299 | (37.7824719871656, -122.445968980903) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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 | ||||||||
| 6495 | 6495 | 26421 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2235X Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 6004624.1328 | 2116974.76242 | 37.793070338586205 | -122.427945300259 | (37.7930703385862, -122.427945300259) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");