Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| 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) | ||||
| 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) | ||
| 641 | 641 | 5315 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1820 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1990 12:00:00 AM | 3 | 3X3 | 6001085.4403 | 2114655.5077 | 37.7865014360219 | -122.440022974412 | (37.7865014360219, -122.440022974412) | ||
| 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) | |||
| 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) | |||
| 1065 | 1065 | 24631 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 601 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 04/03/2013 12:00:00 AM | 3 | 3X3 | 6001596.3507 | 2110541.037 | 37.775233214934104 | -122.43796053363701 | (37.7752332149341, -122.437960533637) | |
| 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) | ||
| 1174 | 1174 | 5198 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 635 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2001 12:00:00 AM | 3 | 3x3 | 6001582.4984 | 2110645.9942 | 37.775520613317 | -122.43801597154 | (37.775520613317, -122.43801597154) | ||
| 1551 | 1551 | 28720 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1881 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2003 12:00:00 AM | 3 | 3X3 | 6004463.0033 | 2114982.1337 | 37.787589966374895 | -122.428360731182 | (37.7875899663749, -122.428360731182) | ||
| 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) | ||
| 1723 | 1723 | 112197 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2570 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2015 12:00:00 AM | 3 | 3x3 | 6001886.22681 | 2116705.46829 | 37.792175654341605 | -122.43739930364599 | (37.7921756543416, -122.437399303646) | ||
| 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) | |||
| 2402 | 2402 | 201606 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 598 Innes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 1 | Width 3ft | 6020954.32481 | 2093200.4635700001 | 37.7287012794353 | -122.36979738594101 | (37.7287012794353, -122.369797385941) | ||
| 2465 | 2465 | 201607 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 598 Innes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 1 | Width 3ft | 6020934.32673 | 2093214.8340900003 | 37.7287396409072 | -122.36986751418699 | (37.7287396409072, -122.369867514187) | ||
| 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) | ||
| 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) | |||
| 2883 | 2883 | 5188 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 506 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | 3 | 3X3 | 6001711.9462 | 2110180.0726 | 37.774248669965296 | -122.437534808127 | (37.7742486699653, -122.437534808127) | ||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 4045 | 4045 | 159340 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 38 Whipple Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 12:16:00 PM | 3 | Width 0ft | 5998227.58529 | 2087220.48645 | 37.7110084860347 | -122.447934438717 | (37.7110084860347, -122.447934438717) | ||
| 4051 | 4051 | 177275 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 134 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:50:00 PM | 3 | Width 2ft | 5998042.78598 | 2087418.21702 | 37.7115408441972 | -122.44858737803101 | (37.7115408441972, -122.448587378031) | ||
| 4199 | 4199 | 216866 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 225 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:20:00 PM | 3 | Width 3ft | 5995872.63368 | 2087895.2558900001 | 37.712726354807295 | -122.45612241881399 | (37.7127263548073, -122.456122418814) | ||
| 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) | ||||
| 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) | ||
| 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) | |||
| 4705 | 4705 | 226129 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 468 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2016 12:00:00 AM | 9 | Width 3ft | 6002897.69632 | 2099218.5981799997 | 37.7442184383445 | -122.432649927259 | (37.7442184383445, -122.432649927259) | ||
| 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) | |||
| 4935 | 4935 | 190564 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1748 Alameda St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | Width 3ft | 6011532.83475 | 2107953.47602 | 37.7686884129717 | -122.403405708214 | (37.7686884129717, -122.403405708214) | ||
| 4957 | 4957 | 190565 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1748 Alameda St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | Width 3ft | 6011489.99866 | 2107952.31705 | 37.7686828380703 | -122.403553794194 | (37.7686828380703, -122.403553794194) | ||
| 4964 | 4964 | 253756 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 41x Division St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 5x5 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4967 | 4967 | 190563 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1748 Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | Width 3ft | 6011562.23742 | 2107955.71991 | 37.7686962163789 | -122.40330416396401 | (37.7686962163789, -122.403304163964) | ||
| 4981 | 4981 | 190562 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1748 Alameda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | Width 3ft | 6011586.29241 | 2107955.63677 | 37.7686973315464 | -122.403220953295 | (37.7686973315464, -122.403220953295) | ||
| 5007 | 5007 | 253755 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 41x Division St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 5x5 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 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) | |||
| 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) | ||
| 5379 | 5379 | 14477 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 12 | 3X3 | 5999009.9624 | 2111977.0325 | 37.7790286692875 | -122.44701076292299 | (37.7790286692875, -122.447010762923) | ||
| 5734 | 5734 | 28721 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1881 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2003 12:00:00 AM | 3 | 3X3 | 6004471.9612 | 2114982.8802 | 37.7875925229583 | -122.428329791837 | (37.7875925229583, -122.428329791837) | ||
| 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) | |||
| 5948 | 5948 | 13140 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1785 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1997 12:00:00 AM | 18 | 3X3 | 6003874.8006 | 2119664.6973 | 37.8004137877384 | -122.430730076432 | (37.8004137877384, -122.430730076432) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 6627 | 6627 | 28722 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1881 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2003 12:00:00 AM | 3 | 3X3 | 6004480.9191 | 2114982.5069999998 | 37.7875920051185 | -122.42829877265699 | (37.7875920051185, -122.428298772657) | ||
| 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) | ||
| 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) | |||
| 6985 | 6985 | 10684 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1161 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2010 12:00:00 AM | 3 | 3X3 | 6002309.8411 | 2110524.4478 | 37.775228213443704 | -122.435491224879 | (37.7752282134437, -122.435491224879) | ||
| 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) | ||
| 7767 | 7767 | 5249 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1135 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1990 12:00:00 AM | 6 | 3X3 | 6001356.9176 | 2112269.0905 | 37.7799643946727 | -122.438912650424 | (37.7799643946727, -122.438912650424) | ||
| 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) | |||
| 8004 | 8004 | 110481 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 573 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/2016 12:00:00 AM | 3 | 4x4 | 6002115.7966 | 2110416.1461 | 37.7749198214087 | -122.436154715842 | (37.7749198214087, -122.436154715842) | |
| 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) | |||
| 8104 | 8104 | 21713 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1900 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/2004 12:00:00 AM | 3 | 4X4 | 6003349.0279 | 2114538.6375 | 37.786309140387395 | -122.432183179125 | (37.7863091403874, -122.432183179125) | ||
| 8113 | 8113 | 75258 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 288 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/23/2015 04:17:00 PM | 3 | 6009102.38385 | 2113598.35596 | 37.7840518741506 | -122.41221149286699 | (37.7840518741506, -122.412211492867) | |||
| 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) | ||
| 8352 | 8352 | 5316 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1823 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1997 12:00:00 AM | 5 | 2X3 | 6001019.2169 | 2114657.038 | 37.786501867674495 | -122.44025220015699 | (37.7865018676745, -122.440252200157) | ||
| 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) | ||
| 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) |
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");