Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9188 | 9188 | 24853 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2434 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2009 12:00:00 AM | 5 | 3x3 | 6010702.6993234 | 2094455.8290061 | 37.7315804365911 | -122.40532643981899 | (37.7315804365911, -122.405326439819) | ||
| 10401 | 10401 | 24863 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2636 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2015 12:00:00 AM | 5 | 4x4 | 6011074.2033 | 2093259.325 | 37.7283158506885 | -122.40395790213002 | (37.7283158506885, -122.40395790213) | ||
| 10879 | 10879 | 27312 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2670 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 5 | 4x4 | 6011119.0302 | 2093108.0343 | 37.7279029423042 | -122.403792291485 | (37.7279029423042, -122.403792291485) | ||
| 11114 | 11114 | 24872 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2675 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 5 | 3x3 | 6011136.5589 | 2093211.8894 | 37.728189086016705 | -122.40373899855601 | (37.7281890860167, -122.403738998556) | ||
| 11321 | 11321 | 24880 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2473 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2015 12:00:00 AM | 5 | 3X3 | 6010833.7586 | 2094203.8757 | 37.73089595245371 | -122.40485560772899 | (37.7308959524537, -122.404855607729) | ||
| 12270 | 12270 | 24873 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2585 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 5 | 3x3 | 6011029.3172 | 2093570.939 | 37.7291689698102 | -122.40413499793101 | (37.7291689698102, -122.404134997931) | ||
| 12370 | 12370 | 27313 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2684 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 5 | 3X3 | 6011127.7854 | 2093073.5386 | 37.7278087133965 | -122.403759598129 | (37.7278087133965, -122.403759598129) | ||
| 14524 | 14524 | 52852 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 50 Lansing St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014360.0420699995 | 2114216.81563 | 37.7860436350529 | -122.394065071555 | (37.7860436350529, -122.394065071555) | |
| 14673 | 14673 | 52844 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 50 Lansing St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014342.2793 | 2114200.39615 | 37.785997563678706 | -122.39412537650401 | (37.7859975636787, -122.394125376504) | |
| 14677 | 14677 | 52149 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1566 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48340 | 6015439.23849 | 2096619.2496 | 37.737784433906995 | -122.389102155646 | (37.737784433907, -122.389102155646) |
| 15384 | 15384 | 52851 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 50 Lansing St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014328.65794 | 2114187.65388 | 37.785961819236604 | -122.39417161065799 | (37.7859618192366, -122.394171610658) | |
| 15397 | 15397 | 52842 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 50 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014392.61709 | 2114247.3993599997 | 37.786129421386796 | -122.393954511599 | (37.7861294213868, -122.393954511599) | |
| 16605 | 16605 | 52850 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 50 Lansing St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014308.484180001 | 2114166.94411 | 37.7859038336441 | -122.39423995641701 | (37.7859038336441, -122.394239956417) | |
| 23161 | 23161 | 2363 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2478 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6009688.22905 | 2102936.69302 | 37.754810266704794 | -122.409431983418 | (37.7548102667048, -122.409431983418) | ||||
| 29636 | 29636 | 189067 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 521 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013772.20207 | 2112425.8554700003 | 37.781093380699296 | -122.395973304322 | (37.7810933806993, -122.395973304322) | |||
| 33159 | 33159 | 220430 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1401 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009429.13636 | 2107984.68576 | 37.7686563845084 | -122.410684471035 | (37.7686563845084, -122.410684471035) | |||
| 35436 | 35436 | 220439 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2865 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009873.7476699995 | 2100752.39413 | 37.7488230598385 | -122.408636324412 | (37.7488230598385, -122.408636324412) | |||
| 36136 | 36136 | 125413 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 677 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6005987.46942 | 2112075.6403900003 | 37.7796955950146 | -122.42287972583999 | (37.7796955950146, -122.42287972584) | |||
| 38160 | 38160 | 121504 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014396.4001 | 2115093.29031 | 37.7884522533286 | -122.39400066032499 | (37.7884522533286, -122.394000660325) | |||
| 39100 | 39100 | 189065 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 521 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013721.13353 | 2112372.28155 | 37.78094343761921 | -122.396146221471 | (37.7809434376192, -122.396146221471) | |||
| 41500 | 41500 | 220419 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009469.46402 | 2107213.1866900004 | 37.76654028692471 | -122.41049049535299 | (37.7665402869247, -122.410490495353) | |||
| 43908 | 43908 | 62024 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 427 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1985 12:00:00 AM | 5 | Permit Number 22097 | 6014298.34567 | 2112925.54615 | 37.782494675542296 | -122.39418809073099 | (37.7824946755423, -122.394188090731) | ||
| 46572 | 46572 | 121505 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014377.50413 | 2115113.61118 | 37.7885069995398 | -122.394067461056 | (37.7885069995398, -122.394067461056) | |||
| 51020 | 51020 | 220412 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1650 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009419.37169 | 2107143.6677099997 | 37.766346595437 | -122.410658846644 | (37.766346595437, -122.410658846644) | |||
| 57140 | 57140 | 220437 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2806 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6009797.25951 | 2100951.65905 | 37.7493659131273 | -122.40891487861401 | (37.7493659131273, -122.408914878614) | |||
| 59465 | 59465 | 189069 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 639 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012927.18586 | 2111608.3632799997 | 37.778801685994 | -122.398839266512 | (37.778801685994, -122.398839266512) | |||
| 60719 | 60719 | 187894 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6015203.0238 | 2100485.5663 | 37.748387442638396 | -122.390188905397 | (37.7483874426384, -122.390188905397) | |||
| 64160 | 64160 | 220475 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1177 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5997354.16789 | 2106085.5022299998 | 37.7627573058278 | -122.452313556128 | (37.7627573058278, -122.452313556128) | |||
| 65235 | 65235 | 220496 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3953 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003484.16047 | 2101832.5449 | 37.7514289677954 | -122.430808566285 | (37.7514289677954, -122.430808566285) | |||
| 66051 | 66051 | 220406 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1798 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009456.39848 | 2106458.4435400004 | 37.7644672030258 | -122.410482387068 | (37.7644672030258, -122.410482387068) | |||
| 67525 | 67525 | 125412 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 677 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6005967.2010699995 | 2112072.2293700003 | 37.779685085531 | -122.42294960046999 | (37.779685085531, -122.42294960047) | |||
| 67944 | 67944 | 189070 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1157 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009807.6250599995 | 2108635.36026 | 37.77046419989421 | -122.409421229304 | (37.7704641998942, -122.409421229304) | |||
| 68156 | 68156 | 220444 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2521 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6009768.45632 | 2102644.2094099997 | 37.754011666912604 | -122.409133896833 | (37.7540116669126, -122.409133896833) | |||
| 73430 | 73430 | 81717 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 5 | 6014951.75745 | 2104011.46368 | 37.758054868645395 | -122.391304224825 | (37.7580548686454, -122.391304224825) | ||
| 74004 | 74004 | 189061 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 670 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011084.455490001 | 2108738.6767700003 | 37.770819341272 | -122.40501191898399 | (37.770819341272, -122.405011918984) | |||
| 133115 | 133115 | 187891 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6015208.193580001 | 2100413.69272 | 37.7481903795776 | -122.390166007757 | (37.7481903795776, -122.390166007757) | |||
| 133541 | 133541 | 125407 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2600 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6003635.60452 | 2117293.35447 | 37.793889137127294 | -122.43138841675501 | (37.7938891371273, -122.431388416755) | |||
| 135445 | 135445 | 220450 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2464 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009683.32663 | 2103015.52487 | 37.755026446627795 | -122.40945450063299 | (37.7550264466278, -122.409454500633) | |||
| 142268 | 142268 | 24854 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2442 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2015 12:00:00 AM | 5 | 3x3 | 6010724.9783872 | 2094386.6708818001 | 37.7313917885461 | -122.40524454808399 | (37.7313917885461, -122.405244548084) | ||
| 149033 | 149033 | 220431 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1650 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006511.20977 | 2099774.83296 | 37.745949999295604 | -122.420194625406 | (37.7459499992956, -122.420194625406) | |||
| 149466 | 149466 | 52126 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 482 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | 5 | Permit Number 48311 | 6005097.5281 | 2110773.3561 | 37.7760695863917 | -122.425865698035 | (37.7760695863917, -122.425865698035) | |
| 150236 | 150236 | 220436 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2800 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6009792.7974 | 2100982.4644299997 | 37.749450247945106 | -122.40893248196501 | (37.7494502479451, -122.408932481965) | |||
| 151686 | 151686 | 121503 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014412.49464 | 2115075.87435 | 37.7884053276005 | -122.39394375569401 | (37.7884053276005, -122.393943755694) | |||
| 151988 | 151988 | 220421 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009460.3962199995 | 2107397.55212 | 37.7670460035972 | -122.410534879606 | (37.7670460035972, -122.410534879606) | |||
| 153823 | 153823 | 220413 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1650 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009421.97424 | 2107100.16313 | 37.766227287782606 | -122.41064677233 | (37.7662272877826, -122.41064677233) | |||
| 155503 | 155503 | 72302 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 595 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 5 | 6013261.50947 | 2111935.00833 | 37.779717201230504 | -122.397705618927 | (37.7797172012305, -122.397705618927) | ||
| 156256 | 156256 | 187911 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013715.2454 | 2115334.02667 | 37.7890753791659 | -122.39637424548701 | (37.7890753791659, -122.396374245487) | |||
| 165470 | 165470 | 220440 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2831 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009868.71469 | 2100872.67042 | 37.7491530301063 | -122.408662212302 | (37.7491530301063, -122.408662212302) | |||
| 166919 | 166919 | 187916 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013874.567969999 | 2115495.81816 | 37.7895284855 | -122.395834347372 | (37.7895284855, -122.395834347372) | |||
| 168315 | 168315 | 220416 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009481.587040001 | 2107055.98222 | 37.766109319220206 | -122.410437462315 | (37.7661093192202, -122.410437462315) | |||
| 169901 | 169901 | 220435 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2680 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009751.75361 | 2101774.10517 | 37.7516216187644 | -122.409130266252 | (37.7516216187644, -122.409130266252) | |||
| 170038 | 170038 | 220474 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6005470.47971 | 2102115.81456 | 37.7523191005603 | -122.423959772048 | (37.7523191005603, -122.423959772048) | |||
| 171189 | 171189 | 220432 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1650 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006509.92654 | 2099814.31154 | 37.7460583262406 | -122.420201864026 | (37.7460583262406, -122.420201864026) | |||
| 177296 | 177296 | 187914 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013751.11841 | 2115368.97395 | 37.7891733324224 | -122.39625257892 | (37.7891733324224, -122.39625257892) | |||
| 187187 | 187187 | 175134 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1447 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6002380.17476 | 2093694.6098 | 37.72902147586029 | -122.434044607568 | (37.7290214758603, -122.434044607568) |
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");