Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114778 | 114778 | 29905 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 Fell St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004657.19551 | 2110576.88809 | 37.7755052392808 | -122.427374927138 | (37.7755052392808, -122.427374927138) | ||||
| 123948 | 123948 | 29904 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 Fell St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6004657.19551 | 2110576.88809 | 37.7755052392808 | -122.427374927138 | (37.7755052392808, -122.427374927138) | ||||||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 8054 | 8054 | 14425 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 90X Masonic Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 12 | 5998875.1013 | 2112962.0092 | 37.781725454134396 | -122.447548220181 | (37.7817254541344, -122.447548220181) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 8563 | 8563 | 6013 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1719 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/1993 12:00:00 AM | 12 | 3X3 | 6002233.091 | 2112591.9993 | 37.780900831757705 | -122.43590469061 | (37.7809008317577, -122.43590469061) | ||
| 8589 | 8589 | 7108 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2150 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3X3 | 5997133.9635 | 2109500.6634 | 37.7721218452706 | -122.453321733951 | (37.7721218452706, -122.453321733951) | |||
| 8611 | 8611 | 5309 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1736 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001119.1558 | 2114392.6005 | 37.7857814798006 | -122.439887470169 | (37.7857814798006, -122.439887470169) | |||
| 8616 | 8616 | 23547 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2806 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6005703.65589 | 2120048.52482 | 37.801571123555895 | -122.424428815235 | (37.8015711235559, -122.424428815235) | |||
| 8727 | 8727 | 7110 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1892X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998395.8128 | 2109678.4377 | 37.7726822136463 | -122.448969721072 | (37.7726822136463, -122.448969721072) | |||
| 8859 | 8859 | 5308 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1722 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6001127.4861 | 2114346.0125 | 37.785654035319396 | -122.439855308268 | (37.7856540353194, -122.439855308268) | |||
| 8868 | 8868 | 7107 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2140 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 4X4 | 5997173.1498 | 2109507.8264 | 37.77214375901271 | -122.453186703241 | (37.7721437590127, -122.453186703241) | |||
| 8899 | 8899 | 5319 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1844 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001069.8732 | 2114771.5539 | 37.786819182767296 | -122.44008515695101 | (37.7868191827673, -122.440085156951) | |||
| 9002 | 9002 | 6927 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 488 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005098.7367 | 2110617.0491 | 37.7756404737796 | -122.425850388577 | (37.7756404737796, -122.425850388577) | |||
| 9010 | 9010 | 23574 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3035 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6005498.0371199995 | 2120829.33235 | 37.8037034071495 | -122.425195941456 | (37.8037034071495, -122.425195941456) | |||
| 9888 | 9888 | 173719 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 922 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3x3 | 6012422.0 | 2103621.0 | 37.7568420188621 | -122.40002584196199 | (37.7568420188621, -122.400025841962) | |||
| 9906 | 9906 | 173728 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
| 9908 | 9908 | 3768 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1098 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.39983195341699 | (37.754754478768, -122.399831953417) | |||
| 10113 | 10113 | 5402 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 368 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 4X4 | 6004841.2181400005 | 2106223.26914 | 37.763561657659295 | -122.426428293246 | (37.7635616576593, -122.426428293246) | |||
| 10841 | 10841 | 25393 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1051 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001007.68114 | 2088741.24323 | 37.7153426652198 | -122.438434668834 | (37.7153426652198, -122.438434668834) | |||
| 11295 | 11295 | 773 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1500X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3 | 5984696.2443 | 2104420.7984 | 37.7574532129065 | -122.495969365063 | (37.7574532129065, -122.495969365063) | |||
| 11825 | 11825 | 20029 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY50 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 13683 | 13683 | 1710 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 5 Bass Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016578.92227 | 2095125.73941 | 37.73374666585679 | -122.385057651709 | (37.7337466658568, -122.385057651709) | |||
| 13964 | 13964 | 24120 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6016647.77235 | 2095170.8389599998 | 37.7338743084492 | -122.384822755067 | (37.7338743084492, -122.384822755067) | |||
| 14161 | 14161 | 24226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6017135.66368 | 2094974.09134 | 37.7333610509772 | -122.38312226117901 | (37.7333610509772, -122.383122261179) | |||
| 14364 | 14364 | 6420 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100X Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/29/1990 12:00:00 AM | 12 | 3x3 | 6018302.7051 | 2096585.42337 | 37.7378498712671 | -122.379199309611 | (37.7378498712671, -122.379199309611) | ||
| 14568 | 14568 | 8258 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1555 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2004 12:00:00 AM | 30 | 3x3 | 6015878.41647 | 2097607.57172 | 37.7405225008163 | -122.387652625679 | (37.7405225008163, -122.387652625679) | ||
| 14728 | 14728 | 6594 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 12 | 3X3 | 6016699.98802 | 2097810.08527 | 37.741124035759796 | -122.384826027706 | (37.7411240357598, -122.384826027706) | ||
| 14857 | 14857 | 6772 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1353 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2016 12:00:00 AM | 12 | 3x3 | 6017054.96873 | 2097078.5407099999 | 37.739134988985796 | -122.38354770437401 | (37.7391349889858, -122.383547704374) | ||
| 14947 | 14947 | 24225 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 58 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6017167.401959999 | 2094982.30239 | 37.7333853506538 | -122.38301310328698 | (37.7333853506538, -122.383013103287) | ||
| 15650 | 15650 | 24228 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 62 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6017105.8284599995 | 2094967.47212 | 37.7333412272151 | -122.383224950289 | (37.7333412272151, -122.383224950289) | |||
| 16309 | 16309 | 6731 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6017098.09908 | 2097131.4743700002 | 37.7392827179327 | -122.38340226151699 | (37.7392827179327, -122.383402261517) | ||
| 16537 | 16537 | 24220 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 52 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017233.65569 | 2094997.2718200001 | 37.7334301143948 | -122.38278508468001 | (37.7334301143948, -122.38278508468) | |||
| 17143 | 17143 | 10434 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1457 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999128.9575 | 2108690.2041 | 37.7700106766776 | -122.44636259863998 | (37.7700106766776, -122.44636259864) | |||
| 17243 | 17243 | 9406 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 479 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6001730.266559999 | 2097665.12438 | 37.7398866873164 | -122.436575468878 | (37.7398866873164, -122.436575468878) |
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");