Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 132 | 132 | 116641 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
| 139 | 139 | 116640 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
| 454 | 454 | 251309 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2111 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991606.081259999 | 2101026.68041 | 37.7485361329461 | -122.471825260742 | (37.7485361329461, -122.471825260742) | ||||
| 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) | ||||
| 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) | |||
| 847 | 847 | 107475 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1099x Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5999355.4 | 2109104.7 | 37.77116170781979 | -122.445609151717 | (37.7711617078198, -122.445609151717) | |||
| 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) | |||
| 1049 | 1049 | 110158 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1061 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 775265 | 6008518.81141 | 2118257.36351 | 37.7968116091339 | -122.41456024686501 | (37.7968116091339, -122.414560246865) | ||
| 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) | ||
| 1785 | 1785 | 228278 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2050 15th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 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) | |||
| 1965 | 1965 | 123761 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 201 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994919.422180001 | 2110746.11008 | 37.7754143312074 | -122.461072248502 | (37.7754143312074, -122.461072248502) | |||
| 1991 | 1991 | 123758 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 201 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5994989.32477 | 2110751.87532 | 37.7754341833406 | -122.46083085861 | (37.7754341833406, -122.46083085861) | |||
| 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) | |||
| 2775 | 2775 | 253211 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1858 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993493.0 | 2102864.0 | 37.753689940286606 | -122.465433828694 | (37.7536899402866, -122.465433828694) | ||||
| 2829 | 2829 | 172061 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 148 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6010428.10303 | 2093767.62468 | 37.729675416078294 | -122.406227307752 | (37.7296754160783, -122.406227307752) | |||
| 3037 | 3037 | 253283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 673 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005929.0 | 2099335.0 | 37.7447094953859 | -122.422176588207 | (37.7447094953859, -122.422176588207) | ||||
| 3256 | 3256 | 253373 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 78 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6010457.0 | 2100357.0 | 37.7477700431666 | -122.406591570174 | (37.7477700431666, -122.406591570174) | ||||
| 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) | |||
| 3768 | 3768 | 228283 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3773 | 3773 | 228285 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3775 | 3775 | 228281 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3776 | 3776 | 228280 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3780 | 3780 | 228286 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3781 | 3781 | 228284 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3791 | 3791 | 228279 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3795 | 3795 | 228282 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3812 | 3812 | 253561 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 530 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5993033.55222 | 2099443.36305 | 37.744271238444206 | -122.46677405027799 | (37.7442712384442, -122.466774050278) | ||||
| 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) | |||
| 4344 | 4344 | 253624 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 735 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998960.0 | 2095994.0 | 37.735140362702396 | -122.446033688862 | (37.7351403627024, -122.446033688862) | ||||
| 4617 | 4617 | 129052 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 400 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012440.41364 | 2117843.22562 | 37.7958940218454 | -122.40096139676001 | (37.7958940218454, -122.40096139676) | |||
| 4836 | 4836 | 226130 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 468 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002884.55982 | 2099217.44999 | 37.7442145406813 | -122.43269526838999 | (37.7442145406813, -122.43269526839) | |||
| 4872 | 4872 | 171862 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 600 Dartmouth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 2ft | 6009157.70808 | 2091305.9821099997 | 37.722845122689 | -122.41044546539801 | (37.722845122689, -122.410445465398) | |||
| 5251 | 5251 | 14528 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 647 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999145.2065 | 2110546.2822 | 37.775107922491706 | -122.446439942682 | (37.7751079224917, -122.446439942682) | |||
| 5343 | 5343 | 110157 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1045-1059 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 775264 | 6008554.60995 | 2118262.34224 | 37.7968272906045 | -122.41443672767599 | (37.7968272906045, -122.414436727676) | ||
| 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) | |||
| 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) | |||
| 6043 | 6043 | 10681 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1145 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002358.7398 | 2110530.7348 | 37.7752482530433 | -122.435322523233 | (37.7752482530433, -122.435322523233) | |||
| 6177 | 6177 | 14545 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 800 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5999282.0507 | 2110078.3239 | 37.7738308435165 | -122.445932905938 | (37.7738308435165, -122.445932905938) | |||
| 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) | |||
| 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) | |||
| 6584 | 6584 | 10679 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1125 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002427.1981 | 2110540.5146 | 37.775278993428394 | -122.43508641032301 | (37.7752789934284, -122.435086410323) | |||
| 6832 | 6832 | 14547 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 810 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5999284.7278 | 2110047.5378 | 37.7737464656007 | -122.4459214308 | (37.7737464656007, -122.4459214308) | |||
| 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) | |||
| 6864 | 6864 | 99895 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2101X Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 768908 | 6004333.92311 | 2116670.5989599996 | 37.7922187606381 | -122.428927747522 | (37.7922187606381, -122.428927747522) | ||
| 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) | |||
| 7216 | 7216 | 92890 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 800 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Tree no. 2 on Montgomery | 6011720.98401 | 2118117.86666 | 37.796607963049 | -122.403470105059 | (37.796607963049, -122.403470105059) | ||
| 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) | |||
| 7929 | 7929 | 5252 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1149 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001343.3807 | 2112375.6934 | 37.7802563289851 | -122.43896712240499 | (37.7802563289851, -122.438967122405) | |||
| 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) | |||
| 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) | |||
| 8528 | 8528 | 28094 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 560 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001682.4646 | 2110397.1642 | 37.7748430729481 | -122.437652340718 | (37.7748430729481, -122.437652340718) | |||
| 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) | |||
| 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) | |||
| 9619 | 9619 | 17809 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1900X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004377.7264 | 2115455.3687 | 37.7888845248195 | -122.428689520238 | (37.7888845248195, -122.428689520238) | |||
| 10627 | 10627 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 10x10 | 5992081.50866 | 2087171.0422099999 | 37.710519496741206 | -122.469172961285 | (37.7105194967412, -122.469172961285) | |||
| 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 | ||||||||
| 12077 | 12077 | 94990 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 48 Leland Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010713.1186 | 2087200.5157 | 37.7116594240627 | -122.40477981842301 | (37.7116594240627, -122.404779818423) | ||||
| 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 | ||||||||
| 12794 | 12794 | 95013 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 93 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010463.1246 | 2087285.1839 | 37.7118779294401 | -122.40564982910401 | (37.7118779294401, -122.405649829104) | ||||
| 13805 | 13805 | 25987 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1867 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6013610.36867 | 2096507.3445599999 | 37.7373756146805 | -122.39541765280701 | (37.7373756146805, -122.395417652807) | |||
| 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) | |||
| 13979 | 13979 | 25990 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1845X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013804.269309999 | 2096361.3192200002 | 37.736985442024 | -122.39473701982 | (37.736985442024, -122.39473701982) | |||
| 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) | |||
| 14183 | 14183 | 7380 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010853.2469 | 2111475.4662 | 37.7783210049209 | -122.40600450833401 | (37.7783210049209, -122.406004508334) | |||
| 14271 | 14271 | 25992 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1845X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013845.47996 | 2096331.5621599997 | 37.7369060264874 | -122.39459245198299 | (37.7369060264874, -122.394592451983) | |||
| 14312 | 14312 | 115576 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 900X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6015313.29826 | 2096960.63807 | 37.7387148347127 | -122.389561431329 | (37.7387148347127, -122.389561431329) | |||
| 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) | |||
| 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) | |||
| 14412 | 14412 | 108590 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 900x Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6015291.6077 | 2096931.09034 | 37.738632499980895 | -122.38963436456001 | (37.7386324999809, -122.38963436456) | |||
| 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) | |||
| 14541 | 14541 | 25985 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1899 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6013478.7737300005 | 2096605.16178 | 37.737636880348894 | -122.395879493351 | (37.7376368803489, -122.395879493351) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 15295 | 15295 | 6623 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1415 Evans Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 18 | 3x3 | 6016531.01979 | 2097819.1041099997 | 37.7411394528345 | -122.385410892796 | (37.7411394528345, -122.385410892796) | |||
| 15435 | 15435 | 7420 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1095 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6010426.8513 | 2110979.2324 | 37.7769346055078 | -122.407444582017 | (37.7769346055078, -122.407444582017) | |||
| 15454 | 15454 | 7377 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010910.3764 | 2111530.9317 | 37.7784764953194 | -122.405810783213 | (37.7784764953194, -122.405810783213) | |||
| 15495 | 15495 | 7411 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1085 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010439.592999999 | 2110990.8158 | 37.7769671239898 | -122.40740132117901 | (37.7769671239898, -122.407401321179) | |||
| 15575 | 15575 | 25986 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1889 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6013508.76181 | 2096582.47787 | 37.737576263320896 | -122.39577422051201 | (37.7375762633209, -122.395774220512) | |||
| 15604 | 15604 | 7382 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 60 | 3X3 | 6010814.6984 | 2111439.6909 | 37.7782206182135 | -122.406135341461 | (37.7782206182135, -122.406135341461) | |||
| 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) | |||
| 15693 | 15693 | 7378 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010884.8623 | 2111505.4176 | 37.7784050126686 | -122.40589724881 | (37.7784050126686, -122.40589724881) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 16441 | 16441 | 34987 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | Permit Number 41601 | 6011225.3523699995 | 2111221.4707400003 | 37.7776443970062 | -122.404699365001 | (37.7776443970062, -122.404699365001) | |||
| 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) |
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");