Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 512 | 512 | 6424 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1100X Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 12:46:00 PM | 3 | 3x3 | 6018234.67827 | 2096633.8011 | 37.7379789554566 | -122.37943787365299 | (37.7379789554566, -122.379437873653) | ||
| 674 | 674 | 251361 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 301 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010388.0 | 2110913.0 | 37.7767505721368 | -122.40757431033701 | (37.7767505721368, -122.407574310337) | ||||
| 709 | 709 | 251360 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 301 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1991 12:00:00 AM | 3x3 | 6010388.0 | 2110913.0 | 37.7767505721368 | -122.40757431033701 | (37.7767505721368, -122.407574310337) | |||
| 781 | 781 | 251370 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 390 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 1033 | 1033 | 14582 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1157 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999380.4238 | 2108868.5189 | 37.7705146429615 | -122.445505607921 | (37.7705146429615, -122.445505607921) | |||
| 1140 | 1140 | 6454 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 02:46:00 PM | 3 | 3X3 | 6017932.4783 | 2096773.48366 | 37.738345824884895 | -122.380492444782 | (37.7383458248849, -122.380492444782) | ||
| 1143 | 1143 | 6430 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1100X Evans Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 12:48:00 PM | 3 | 3x3 | 6018115.58754 | 2096722.72512 | 37.7382165545353 | -122.379855810196 | (37.7382165545353, -122.379855810196) | ||
| 1706 | 1706 | 192430 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 340 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | DPW for City Agency 2 | 9 | Width 3ft | 6011111.5516 | 2111334.7393 | 37.7779490450386 | -122.405101020214 | (37.7779490450386, -122.405101020214) | ||
| 1837 | 1837 | 17821 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1911 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6004660.7047 | 2115356.9434 | 37.788630284766704 | -122.427703438305 | (37.7886302847667, -122.427703438305) | |||
| 1990 | 1990 | 123760 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 201 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/14/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 778327 | 5994952.60534 | 2110751.23907 | 37.7754303235309 | -122.460957832773 | (37.7754303235309, -122.460957832773) | |
| 2222 | 2222 | 4694 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 850X Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x8 | 6008940.69941 | 2120350.9777900004 | 37.802583847399 | -122.41324853649999 | (37.802583847399, -122.4132485365) | |||
| 2732 | 2732 | 27493 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/04/1999 12:00:00 AM | 8 | 8 | 5999060.5624 | 2111177.3019 | 37.7768357058082 | -122.446778158439 | (37.7768357058082, -122.446778158439) | ||
| 3464 | 3464 | 5297 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1600 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/07/1995 12:00:00 AM | 3 | 2X3 | 6001162.4866 | 2114099.2454 | 37.7849784685073 | -122.439716519057 | (37.7849784685073, -122.439716519057) | ||
| 3469 | 3469 | 26817 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1701 Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001074.1672 | 2114240.365 | 37.7853609192564 | -122.440032197736 | (37.7853609192564, -122.440032197736) | |||
| 4311 | 4311 | 14485 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 281 Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5998949.7233 | 2111970.6025 | 37.7790075723669 | -122.447218690561 | (37.7790075723669, -122.447218690561) | |||
| 4582 | 4582 | 129053 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 400X Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/25/2014 02:27:00 PM | 6 | Width 4ft | 6012415.44443 | 2117838.5310400003 | 37.795879738801496 | -122.401047465462 | (37.7958797388015, -122.401047465462) | ||
| 4589 | 4589 | 129055 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 444 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2004 12:00:00 AM | 5 | Width 4ft | 6012276.75519 | 2117819.30425 | 37.795819209030796 | -122.401526007337 | (37.7958192090308, -122.401526007337) | ||
| 4613 | 4613 | 129054 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 444 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/2012 12:00:00 AM | 2 | Width 4ft | 6012321.89911 | 2117825.32237 | 37.795838252184204 | -122.401370223173 | (37.7958382521842, -122.401370223173) | ||
| 5288 | 5288 | 27497 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2000 12:00:00 AM | 3 | 8 | 5999037.4754 | 2111324.4818 | 37.7772385050767 | -122.44686861623998 | (37.7772385050767, -122.44686861624) | ||
| 5770 | 5770 | 26813 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1701 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001062.3024 | 2114325.3961 | 37.7855937173461 | -122.440079345712 | (37.7855937173461, -122.440079345712) | |||
| 5890 | 5890 | 14472 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 235 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1990 12:00:00 AM | 40 | 2X2 | 5998919.6038 | 2112167.2256 | 37.7795457275321 | -122.44733704131501 | (37.7795457275321, -122.447337041315) | ||
| 5917 | 5917 | 14486 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 281 Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5998954.4612 | 2111920.5161 | 37.7788703187651 | -122.447198694655 | (37.7788703187651, -122.447198694655) | |||
| 6168 | 6168 | 14501 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/04/1999 12:00:00 AM | 6 | 8 | 5999062.4864 | 2111159.5057 | 37.776786951926105 | -122.446770221959 | (37.7767869519261, -122.446770221959) | ||
| 6197 | 6197 | 23919 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1700X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6x6 | 6003523.3584 | 2114587.3577 | 37.7864527963196 | -122.431583520291 | (37.7864527963196, -122.431583520291) | |||
| 6285 | 6285 | 14483 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 281 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5998945.3239 | 2112016.2894 | 37.7791327654133 | -122.447237198812 | (37.7791327654133, -122.447237198812) | |||
| 6469 | 6469 | 5298 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1600 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1995 12:00:00 AM | 3 | 2X3 | 6001159.4674 | 2114123.3993 | 37.785044617067 | -122.439728696784 | (37.785044617067, -122.439728696784) | ||
| 6479 | 6479 | 10680 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1133 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002410.4328 | 2110539.1175 | 37.7752742053449 | -122.435144305311 | (37.7752742053449, -122.435144305311) | |||
| 6577 | 6577 | 28805 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2005 12:00:00 AM | 6 | 8 | 5999050.9428 | 2111235.5005 | 37.7769949546715 | -122.446815624115 | (37.7769949546715, -122.446815624115) | ||
| 6595 | 6595 | 27496 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/13/2005 12:00:00 AM | 6 | 8 | 5999036.5134 | 2111342.759 | 37.7772886346083 | -122.44687325959801 | (37.7772886346083, -122.446873259598) | ||
| 6768 | 6768 | 14500 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2005 12:00:00 AM | 8 | 8 | 5999057.6765 | 2111195.0982 | 37.7768844050144 | -122.446789422429 | (37.7768844050144, -122.446789422429) | ||
| 6853 | 6853 | 26814 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1701 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001067.2461 | 2114300.6778 | 37.785526128691295 | -122.440060468908 | (37.7855261286913, -122.440060468908) | |||
| 7179 | 7179 | 14495 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 339 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X4 | 5998997.0731 | 2111620.7655 | 37.778049715609704 | -122.44702970697399 | (37.7780497156097, -122.447029706974) | |||
| 7316 | 7316 | 27494 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2000 12:00:00 AM | 6 | 8 | 5999041.3232 | 2111309.0904 | 37.7771964640696 | -122.446854197732 | (37.7771964640696, -122.446854197732) | ||
| 7377 | 7377 | 26815 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1701 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001070.2123 | 2114280.9031 | 37.7854720013115 | -122.44004878829399 | (37.7854720013115, -122.440048788294) | |||
| 7432 | 7432 | 8194 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1301 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001422.3613 | 2111092.2721 | 37.7767368720245 | -122.43860190684799 | (37.7767368720245, -122.438601906848) | |||
| 7718 | 7718 | 28806 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2005 12:00:00 AM | 6 | 8 | 5999054.7907 | 2111214.8184 | 37.7769383867596 | -122.446800824554 | (37.7769383867596, -122.446800824554) | ||
| 7993 | 7993 | 14466 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 201 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 2X3 | 5998899.6369 | 2112323.9149 | 37.7799748148245 | -122.44741739632799 | (37.7799748148245, -122.447417396328) | |||
| 8029 | 8029 | 1717 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 555 Battery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6012534.63593 | 2117926.51881 | 37.7961279804624 | -122.400641221934 | (37.7961279804624, -122.400641221934) | |||
| 8294 | 8294 | 7346 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2225 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/2005 12:00:00 AM | 1 | 3X3 | 6002798.59801 | 2115979.15257 | 37.7902332041481 | -122.43419054146001 | (37.7902332041481, -122.43419054146) | ||
| 8411 | 8411 | 26812 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1701 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001060.3249 | 2114356.0469 | 37.785677763980395 | -122.44008838592801 | (37.7856777639804, -122.440088385928) | |||
| 8486 | 8486 | 27495 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2005 12:00:00 AM | 6 | 8 | 5999043.2471 | 2111289.3703 | 37.7771424276553 | -122.446846123038 | (37.7771424276553, -122.446846123038) | ||
| 8717 | 8717 | 26816 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1701 Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001075.1559 | 2114260.1397 | 37.7854152717832 | -122.440030195581 | (37.7854152717832, -122.440030195581) | |||
| 8944 | 8944 | 5220 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 998X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1995 12:00:00 AM | 3 | 3X4 | 6001495.4192 | 2111745.9646 | 37.7785359024219 | -122.438396022881 | (37.7785359024219, -122.438396022881) | ||
| 9500 | 9500 | 17808 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1900X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6004382.775 | 2115429.5647 | 37.7888139592602 | -122.4286702126 | (37.7888139592602, -122.4286702126) | |||
| 10764 | 10764 | 19741 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY15 | -14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 1OST | ||||||||
| 11829 | 11829 | 19801 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY21 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 12425 | 12425 | 19740 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY15 | -50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 1OST | ||||||||
| 13383 | 13383 | 6551 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1275 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3x3 | 6017377.10796 | 2097187.95737 | 37.7394532248805 | -122.382441492395 | (37.7394532248805, -122.382441492395) | ||
| 13468 | 13468 | 6601 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1400 Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 18 | 3X3 | 6016563.26404 | 2097911.91125 | 37.7413960662634 | -122.38530586818099 | (37.7413960662634, -122.385305868181) | ||
| 13847 | 13847 | 7403 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1052 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6010579.4997 | 2111206.152 | 37.7775662166508 | -122.40693251939 | (37.7775662166508, -122.40693251939) | |||
| 14011 | 14011 | 4036 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6011851.38946 | 2100896.5951099996 | 37.7493295679091 | -122.401807737936 | (37.7493295679091, -122.401807737936) | |||
| 14064 | 14064 | 19797 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 14138 | 14138 | 25914 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1800 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6013877.589480001 | 2096388.75827 | 37.737064860262706 | -122.394485438074 | (37.7370648602627, -122.394485438074) | |||
| 14306 | 14306 | 6663 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1550 Evans Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1997 12:00:00 AM | 6 | 3X3 | 6015993.25804 | 2098345.2218299997 | 37.742554297736504 | -122.387306987444 | (37.7425542977365, -122.387306987444) | ||
| 14311 | 14311 | 4044 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2014 12:00:00 AM | 3 | 2X3 | 6012170.1171 | 2100910.58495 | 37.7493857629599 | -122.400706546863 | (37.7493857629599, -122.400706546863) | ||
| 14323 | 14323 | 7412 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1085 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6010447.7014 | 2110998.9241 | 37.776989841318205 | -122.40737384334999 | (37.7769898413182, -122.40737384335) | |||
| 14330 | 14330 | 6654 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1550 Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016161.31179 | 2098218.8555900003 | 37.742216627489796 | -122.38671709151699 | (37.7422166274898, -122.386717091517) | ||
| 14344 | 14344 | 4047 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012259.88232 | 2100916.2126599997 | 37.749406221625 | -122.40039652989401 | (37.749406221625, -122.400396529894) | |||
| 14402 | 14402 | 7408 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1070X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6010493.6316 | 2111129.8248 | 37.7773518347 | -122.40722418556801 | (37.7773518347, -122.407224185568) | |||
| 14422 | 14422 | 105179 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1845X Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6013865.3937099995 | 2096317.18633 | 37.73686766051579 | -122.394522594469 | (37.7368676605158, -122.394522594469) | |||
| 14610 | 14610 | 6657 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1550 Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2001 12:00:00 AM | 6 | 3X3 | 6016109.874890001 | 2098256.6589900004 | 37.742317580005995 | -122.386897581869 | (37.742317580006, -122.386897581869) | ||
| 14611 | 14611 | 6664 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1550 Evans Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1997 12:00:00 AM | 6 | 3X3 | 6015978.92164 | 2098355.83465 | 37.7425826443858 | -122.38735729911501 | (37.7425826443858, -122.387357299115) | ||
| 14770 | 14770 | 25912 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1800 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6013918.7634 | 2096357.1856 | 37.736980457086794 | -122.39434087026001 | (37.7369804570868, -122.39434087026) | |||
| 14843 | 14843 | 25988 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1863 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/2015 07:57:00 AM | 3 | 3X3 | 6013632.3496 | 2096491.11087 | 37.737332262873295 | -122.395340517063 | (37.7373322628733, -122.395340517063) | ||
| 14872 | 14872 | 6661 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1550 Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2001 12:00:00 AM | 3 | 3X3 | 6016028.90772 | 2098318.24105 | 37.7424821883031 | -122.387181838675 | (37.7424821883031, -122.387181838675) | ||
| 14887 | 14887 | 4041 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012003.952769999 | 2100904.2897799998 | 37.7493592086764 | -122.40128070823401 | (37.7493592086764, -122.401280708234) | |||
| 15018 | 15018 | 25913 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1800 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6013897.73879 | 2096372.1426400002 | 37.7370203572955 | -122.39441460924101 | (37.7370203572955, -122.394414609241) | |||
| 15043 | 15043 | 4046 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012224.99422 | 2100912.98992 | 37.74939542707129 | -122.40051694820801 | (37.7493954270713, -122.400516948208) | |||
| 15059 | 15059 | 7393 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1058 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6010566.1424 | 2111194.703 | 37.777534032927605 | -122.406977919834 | (37.7775340329276, -122.406977919834) | |||
| 15186 | 15186 | 25911 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1800 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2014 12:00:00 AM | 3 | 3X3 | 6013940.91022 | 2096342.20585 | 37.7369405568534 | -122.39426324976101 | (37.7369405568534, -122.394263249761) | ||
| 15246 | 15246 | 7387 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1034 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6010706.5406 | 2111333.1971 | 37.7779221608577 | -122.40650199464899 | (37.7779221608577, -122.406501994649) | |||
| 15248 | 15248 | 4037 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6011877.987480001 | 2100898.0514700003 | 37.749335051069004 | -122.401715863223 | (37.749335051069, -122.401715863223) | |||
| 15414 | 15414 | 6656 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1550 Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2004 12:00:00 AM | 3 | 3X3 | 6016128.17059 | 2098243.97439 | 37.7422837636921 | -122.38683343593 | (37.7422837636921, -122.38683343593) | ||
| 15473 | 15473 | 6658 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1550 Evans Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/17/2009 12:00:00 AM | 3 | 3X3 | 6016095.55691 | 2098268.17698 | 37.742348413262704 | -122.386947892648 | (37.7423484132627, -122.386947892648) | ||
| 15586 | 15586 | 6602 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1400 Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/04/1997 12:00:00 AM | 6 | 3X3 | 6016545.709430001 | 2097925.3054299997 | 37.7414318727766 | -122.385367499637 | (37.7414318727766, -122.385367499637) | ||
| 15660 | 15660 | 4048 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012292.256030001 | 2100918.21603 | 37.74941352772171 | -122.40028472078998 | (37.7494135277217, -122.40028472079) | |||
| 15823 | 15823 | 6660 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1550 Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2001 12:00:00 AM | 6 | 3X3 | 6016043.95648 | 2098306.88974 | 37.742451853283896 | -122.38712901248999 | (37.7424518532839, -122.38712901249) | ||
| 15838 | 15838 | 4042 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012031.32912 | 2100905.9879099997 | 37.749365398695396 | -122.40118615893299 | (37.7493653986954, -122.401186158933) | |||
| 15850 | 15850 | 7381 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/2012 12:00:00 AM | 3 | 3x3 | 6010836.3299 | 2111459.1038 | 37.7782751314106 | -122.40606187778499 | (37.7782751314106, -122.406061877785) | ||
| 15866 | 15866 | 6595 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1400 Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 6 | 3X3 | 6016681.72094 | 2097824.21819 | 37.741161831548794 | -122.38489017364799 | (37.7411618315488, -122.384890173648) | ||
| 15893 | 15893 | 6603 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1400 Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/04/1997 12:00:00 AM | 6 | 3X3 | 6016522.05024 | 2097942.62587 | 37.741478122223704 | -122.385450512434 | (37.7414781222237, -122.385450512434) | ||
| 15900 | 15900 | 6596 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1400 Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 6 | 3X3 | 6016665.24254 | 2097836.86612 | 37.741195648757206 | -122.384948031546 | (37.7411956487572, -122.384948031546) | ||
| 15992 | 15992 | 4049 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012317.265430001 | 2100919.43782 | 37.749418277035296 | -122.400198322911 | (37.7494182770353, -122.400198322911) | |||
| 16122 | 16122 | 6634 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1495 Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2016 08:44:00 AM | 3 | 3X3 | 6016398.96858 | 2097918.11995 | 37.7414040234725 | -122.38587438271401 | (37.7414040234725, -122.385874382714) | ||
| 16189 | 16189 | 19840 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY25 | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 16209 | 16209 | 27243 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1877 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6013583.54144 | 2096526.75062 | 37.737427407546605 | -122.395511766876 | (37.7374274075466, -122.395511766876) | |||
| 16216 | 16216 | 4045 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2014 12:00:00 AM | 3 | 2X3 | 6012204.22169 | 2100912.2871 | 37.74939233879871 | -122.40058873120199 | (37.7493923387987, -122.400588731202) | ||
| 16270 | 16270 | 6655 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1550 Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2001 12:00:00 AM | 6 | 3X3 | 6016144.11034 | 2098231.69923 | 37.7422509411428 | -122.38677746482 | (37.7422509411428, -122.38677746482) | ||
| 16361 | 16361 | 6659 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1550 Evans Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 3 | 3X3 | 6016081.5878 | 2098278.96345 | 37.7423772572113 | -122.386996946162 | (37.7423772572113, -122.386996946162) | ||
| 16495 | 16495 | 4043 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2005 12:00:00 AM | 3 | 2X3 | 6012152.10777 | 2100910.4709400004 | 37.7493844454379 | -122.400768815931 | (37.7493844454379, -122.400768815931) | ||
| 16577 | 16577 | 6662 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1550 Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 6 | 3X3 | 6016012.0516099995 | 2098330.17252 | 37.7425140162093 | -122.387240954701 | (37.7425140162093, -122.387240954701) | ||
| 16628 | 16628 | 4038 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6011915.6161 | 2100899.61614 | 37.7493414470685 | -122.401585851825 | (37.7493414470685, -122.401585851825) | |||
| 16641 | 16641 | 19305 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 345 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/09/2002 12:00:00 AM | 20 | 3X3 | 6010549.63293 | 2110708.85281 | 37.7761990776491 | -122.407000778664 | (37.7761990776491, -122.407000778664) | ||
| 16687 | 16687 | 4039 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2014 12:00:00 AM | 5 | 2X3 | 6011942.20762 | 2100900.73993 | 37.7493460165275 | -122.401493976188 | (37.7493460165275, -122.401493976188) | ||
| 16883 | 16883 | 6447 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2015 07:28:00 AM | 3 | 3X3 | 6017815.25315 | 2096866.6700099998 | 37.7385952266854 | -122.380904232644 | (37.7385952266854, -122.380904232644) | ||
| 16989 | 16989 | 5648 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1301 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/1997 12:00:00 AM | 12 | 3x3 | 6005228.5165 | 2100736.6422099997 | 37.748518548492996 | -122.424698417605 | (37.748518548493, -122.424698417605) | ||
| 17011 | 17011 | 27422 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 6004589.1156 | 2099049.54321 | 37.7438500301684 | -122.426789326068 | (37.7438500301684, -122.426789326068) | |||
| 17210 | 17210 | 559 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2933 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009274.565719999 | 2102151.76119 | 37.7526318334984 | -122.410807118757 | (37.7526318334984, -122.410807118757) | |||
| 17432 | 17432 | 5700 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1574 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/1999 12:00:00 AM | 6 | 3X3 | 6005230.11909 | 2099176.7707599998 | 37.744235589305504 | -122.42458193203001 | (37.7442355893055, -122.42458193203) | ||
| 17434 | 17434 | 4191 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 3859 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004825.90537 | 2100443.7423799997 | 37.747691566130904 | -122.426069792902 | (37.7476915661309, -122.426069792902) |
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");