Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 387 | 387 | 85807 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 2719 | 2719 | 141993 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 818 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2008 12:00:00 AM | 2 | Width 0ft | 6003993.152000001 | 2111582.4748 | 37.778228754000004 | -122.429743751351 | (37.778228754, -122.429743751351) | ||
| 3726 | 3726 | 14780 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1019 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004321.3595 | 2111841.1408 | 37.7789575666093 | -122.42862680452801 | (37.7789575666093, -122.428626804528) | ||
| 11649 | 11649 | 122647 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 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) | |
| 14738 | 14738 | 8260 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2004 12:00:00 AM | 3 | 3x3 | 6015944.99866 | 2097559.42208 | 37.74039397959 | -122.38741905015301 | (37.74039397959, -122.387419050153) | ||
| 15102 | 15102 | 115350 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014880.23802 | 2114582.9179 | 37.7870777663613 | -122.39229093398599 | (37.7870777663613, -122.392290933986) | |
| 15143 | 15143 | 86673 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1157 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009836.98822 | 2108663.0502 | 37.770541875235 | -122.409321615924 | (37.770541875235, -122.409321615924) | ||
| 15322 | 15322 | 27454 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6X6 | 6015187.13368 | 2100745.31925 | 37.7490997884263 | -122.390261998696 | (37.7490997884263, -122.390261998696) | |||
| 16307 | 16307 | 108061 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014711.31667 | 2114762.0418700003 | 37.7875602184789 | -122.392887905777 | (37.7875602184789, -122.392887905777) | ||
| 16419 | 16419 | 86689 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 833 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011647.231000001 | 2110392.1587400003 | 37.775390867731794 | -122.40318158457701 | (37.7753908677318, -122.403181584577) | ||
| 18132 | 18132 | 25478 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2451X Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2002 12:00:00 AM | 6 | 3X3 | 6009740.95146 | 2103104.50441 | 37.7552739931277 | -122.40926149534401 | (37.7552739931277, -122.409261495344) | ||
| 19947 | 19947 | 28120 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1640 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2005 12:00:00 AM | 6 | 3X3 | 6006506.93128 | 2099856.40454 | 37.746173735321705 | -122.42021520818199 | (37.7461737353217, -122.420215208182) | ||
| 29247 | 29247 | 125411 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 680 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6005845.66481 | 2112104.7354 | 37.7797674805156 | -122.423372359172 | (37.7797674805156, -122.423372359172) | |||
| 30082 | 30082 | 141368 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 500x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001677.0206 | 2110226.585 | 37.774374395633394 | -122.43765895363701 | (37.7743743956334, -122.437658953637) | |||
| 32027 | 32027 | 187962 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 787 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011933.30583 | 2110670.66458 | 37.7761715530167 | -122.402211564127 | (37.7761715530167, -122.402211564127) | |||
| 32037 | 32037 | 187942 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015080.74918 | 2115307.92538 | 37.789079602378294 | -122.391647913344 | (37.7890796023783, -122.391647913344) | ||||
| 32188 | 32188 | 141618 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001576.0331 | 2110923.0014 | 37.77628083782329 | -122.438058183449 | (37.7762808378233, -122.438058183449) | |||
| 32741 | 32741 | 220423 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1525 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009450.02537 | 2107605.87811 | 37.7676174373262 | -122.41058546376699 | (37.7676174373262, -122.410585463767) | |||
| 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) | |||
| 38969 | 38969 | 203414 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 95 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993945.5640199995 | 2096868.34313 | 37.7372534705646 | -122.463433702031 | (37.7372534705646, -122.463433702031) | |||
| 42109 | 42109 | 247508 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001724.0539 | 2109895.2534 | 37.7734673159842 | -122.43747252535401 | (37.7734673159842, -122.437472525354) | |||
| 42445 | 42445 | 138175 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001483.6566 | 2111580.5714 | 37.778081105415396 | -122.438424861346 | (37.7780811054154, -122.438424861346) | |||
| 43311 | 43311 | 137723 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001529.3435 | 2111250.6101 | 37.7771777134961 | -122.438243170212 | (37.7771777134961, -122.438243170212) | |||
| 46232 | 46232 | 189059 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 925 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011015.17329 | 2109787.29138 | 37.7736947229667 | -122.405325426246 | (37.7736947229667, -122.405325426246) | |||
| 49093 | 49093 | 189078 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1047 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010207.59565 | 2109022.90661 | 37.771550714911896 | -122.40806505798 | (37.7715507149119, -122.40806505798) | |||
| 50072 | 50072 | 187910 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 145 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013716.26626 | 2115794.0259700003 | 37.7903384868766 | -122.396402968917 | (37.7903384868766, -122.396402968917) | |||
| 50461 | 50461 | 187926 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013589.1856 | 2115211.48481 | 37.788731892112004 | -122.39680180476499 | (37.788731892112, -122.396801804765) | |||
| 50858 | 50858 | 187901 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2240 Silver Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6012923.64855 | 2096289.98894 | 37.7367405826988 | -122.39777673821101 | (37.7367405826988, -122.397776738211) | |||
| 52366 | 52366 | 187913 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013740.8132 | 2115359.33428 | 37.7891462907102 | -122.396287558027 | (37.7891462907102, -122.396287558027) | |||
| 57164 | 57164 | 187920 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 48 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013088.63275 | 2115034.82195 | 37.7882189439825 | -122.398521255459 | (37.7882189439825, -122.398521255459) | |||
| 58733 | 58733 | 187950 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015285.41791 | 2115092.62187 | 37.788499786972295 | -122.390924726221 | (37.7884997869723, -122.390924726221) | ||||
| 59265 | 59265 | 187867 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015121.61936 | 2100940.75662 | 37.74963278423721 | -122.390502204035 | (37.7496327842372, -122.390502204035) | |||
| 63699 | 63699 | 141326 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 600x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001622.302 | 2110598.2625 | 37.775391817545206 | -122.437874862045 | (37.7753918175452, -122.437874862045) | |||
| 66685 | 66685 | 244891 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001778.4482 | 2109561.7211 | 37.7725546117714 | -122.437260481611 | (37.7725546117714, -122.437260481611) | |||
| 70825 | 70825 | 189066 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 521 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6013735.14278 | 2112387.07191 | 37.7809848280366 | -122.396098793052 | (37.7809848280366, -122.396098793052) | |||
| 71869 | 71869 | 49375 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 522Walbridge Carter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 46344 | 6005207.53082 | 2086275.43702 | 37.708810086982396 | -122.423742899628 | (37.7088100869824, -122.423742899628) | |||
| 73165 | 73165 | 175136 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 313 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5999930.3709 | 2092032.12822 | 37.7243173479397 | -122.442394436857 | (37.7243173479397, -122.442394436857) | |||
| 76056 | 76056 | 189074 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1111 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009972.167330001 | 2108791.01573 | 37.770900811749 | -122.40886305789101 | (37.770900811749, -122.408863057891) | |||
| 78501 | 78501 | 48548 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 630(REVISED) 08th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.40499689848801 | (37.7708540159333, -122.404996898488) | |||
| 84171 | 84171 | 107155 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | ||||
| 85504 | 85504 | 116466 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 90357 | 90357 | 96783 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 219 Prentiss St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | |||
| 92136 | 92136 | 28684 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2961 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6011474.8425665 | 2092113.9713098 | 37.725193321952894 | -122.402492361636 | (37.7251933219529, -122.402492361636) | |||
| 93372 | 93372 | 672 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3300X 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2013 12:00:00 AM | 3 | 4X4 | 6007057.4653098 | 2102078.7676165 | 37.7523068461089 | -122.41846908204701 | (37.7523068461089, -122.418469082047) | ||
| 94226 | 94226 | 9751 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 688X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/25/2006 12:00:00 AM | 3 | 3x3 | 6005981.3683502 | 2112123.5425617 | 37.7798267784404 | -122.422904237561 | (37.7798267784404, -122.422904237561) | ||
| 96231 | 96231 | 100775 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 99469 | 99469 | 102507 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.43512657661199 | (37.782944132882, -122.435126576612) | ||
| 103876 | 103876 | 94416 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 5800 03rd St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 105020 | 105020 | 8224 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 105474 | 105474 | 87551 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3195 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6011859.438328 | 2090836.432048 | 37.7217069237885 | -122.401073119638 | (37.7217069237885, -122.401073119638) | ||||
| 106586 | 106586 | 121542 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 109208 | 109208 | 118376 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 113409 | 113409 | 104203 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3135 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/30/2015 12:00:00 AM | 2 | 3x3 | Permit Number 770708 | 6008143.9 | 2102068.3 | 37.7523392058798 | -122.41471126484 | (37.7523392058798, -122.41471126484) | |
| 115466 | 115466 | 14755 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 950X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2013 12:00:00 AM | 0 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | ||
| 116615 | 116615 | 14653 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 655X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2008 12:00:00 AM | 3 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.779703716761496 | -122.422781416289 | (37.7797037167615, -122.422781416289) | ||
| 122108 | 122108 | 101992 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 124105 | 124105 | 187892 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6015206.13934 | 2100438.08 | 37.74825722800529 | -122.39017481481501 | (37.7482572280053, -122.390174814815) | |||
| 127098 | 127098 | 84889 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1699X Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643.0 | 2099756.0 | 37.7459057132351 | -122.41973757574301 | (37.7459057132351, -122.419737575743) | |
| 127997 | 127997 | 88152 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 132111 | 132111 | 220502 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 203 States St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001052.7455400005 | 2106320.2037400003 | 37.7636129298281 | -122.439538340217 | (37.7636129298281, -122.439538340217) | |||
| 132208 | 132208 | 187887 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1798 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6015168.3741 | 2100272.0996 | 37.7477993858291 | -122.39029381222299 | (37.7477993858291, -122.390293812223) | |||
| 132940 | 132940 | 220482 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3135 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008165.93149 | 2102089.85128 | 37.7523996186474 | -122.41463660112 | (37.7523996186474, -122.41463660112) | |||
| 137715 | 137715 | 88170 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011731.581680001 | 2112591.71808 | 37.781435059217 | -122.403044540485 | (37.781435059217, -122.403044540485) | |
| 138085 | 138085 | 137763 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001437.9696 | 2111922.039 | 37.77901609029121 | -122.438607381917 | (37.7790160902912, -122.438607381917) | |||
| 143813 | 143813 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | ||
| 145230 | 145230 | 53153 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1397@ JENNINGS Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49077 | 6016165.18448304 | 2093562.93446239 | 37.729432620466596 | -122.386379154297 | (37.7294326204666, -122.386379154297) | ||
| 145774 | 145774 | 28679 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3125X San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2X3 | 6011481.7390123 | 2092091.2460015 | 37.7251313079457 | -122.40246692394899 | (37.7251313079457, -122.402466923949) | |||
| 150271 | 150271 | 187954 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 350 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014772.69279 | 2114599.27503 | 37.7871167070277 | -122.392664164317 | (37.7871167070277, -122.392664164317) | |||
| 151063 | 151063 | 187960 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 43 Lansing St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014392.0374 | 2114215.18935 | 37.7860409478825 | -122.393954261603 | (37.7860409478825, -122.393954261603) | |||
| 151481 | 151481 | 220492 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3316 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006986.84997 | 2102068.95383 | 37.752275924113704 | -122.418712585824 | (37.7522759241137, -122.418712585824) | |||
| 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) | |||
| 152580 | 152580 | 220480 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 211 Prentiss St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008820.1543 | 2097512.38681 | 37.739867649565 | -122.412050719273 | (37.739867649565, -122.412050719273) | |||
| 157299 | 157299 | 187889 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1799 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6015203.04299 | 2100298.1861 | 37.747872936885706 | -122.390175750107 | (37.7478729368857, -122.390175750107) | |||
| 159298 | 159298 | 141318 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001293.2943 | 2112947.457 | 37.781823396493394 | -122.439181385856 | (37.7818233964934, -122.439181385856) | |||
| 159468 | 159468 | 187939 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 235 01st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6014002.16352 | 2114987.08347 | 37.7881387154874 | -122.395357223783 | (37.7881387154874, -122.395357223783) | |||
| 160113 | 160113 | 203408 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5993769.17892 | 2102256.91781 | 37.7520389725334 | -122.464434672649 | (37.7520389725334, -122.464434672649) | |||
| 160930 | 160930 | 137753 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001391.9443 | 2112251.3234 | 37.779917603505 | -122.438790204132 | (37.779917603505, -122.438790204132) | |||
| 161235 | 161235 | 139864 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 716 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005563.5601 | 2112069.7671 | 37.779655540357105 | -122.424345796171 | (37.7796555403571, -122.424345796171) | |||
| 162225 | 162225 | 138252 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1400x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001247.9458 | 2113288.2478 | 37.7827565405151 | -122.439362705553 | (37.7827565405151, -122.439362705553) | |||
| 162619 | 162619 | 189094 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016058.30905 | 2097557.96705 | 37.7403962593718 | -122.387027162495 | (37.7403962593718, -122.387027162495) | |||
| 162704 | 162704 | 175142 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 199 Hamilton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6009135.1326 | 2093603.39042 | 37.7291520547186 | -122.41068566890499 | (37.7291520547186, -122.410685668905) | |||
| 163119 | 163119 | 189086 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 350 Tehama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011640.52015 | 2112779.45353 | 37.781945451451605 | -122.403372782229 | (37.7819454514516, -122.403372782229) | |||
| 163804 | 163804 | 187932 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015226.56568 | 2115767.0795400003 | 37.790348427077106 | -122.39117551026101 | (37.7903484270771, -122.391175510261) | |||
| 165972 | 165972 | 112593 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200M Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001345.5805 | 2112610.0505 | 37.7808999391999 | -122.43897631246901 | (37.7808999391999, -122.438976312469) | |||
| 167597 | 167597 | 189091 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1433 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6016333.586630001 | 2097354.23847 | 37.739852101202004 | -122.38606115391 | (37.739852101202, -122.38606115391) | |||
| 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) | |||
| 170700 | 170700 | 247515 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001817.1167 | 2109233.3781 | 37.7716552616846 | -122.437103211063 | (37.7716552616846, -122.437103211063) | |||
| 174214 | 174214 | 141990 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 780 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004028.4702 | 2111508.2869 | 37.778027052231394 | -122.42961628033301 | (37.7780270522314, -122.429616280333) | |||
| 177676 | 177676 | 189062 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 670 08th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011094.42559 | 2108729.00589 | 37.7707933445767 | -122.404976750984 | (37.7707933445767, -122.404976750984) | |||
| 177732 | 177732 | 123077 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 723 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992233.23043 | 2110491.18489 | 37.774559431962 | -122.47034576378599 | (37.774559431962, -122.470345763786) | |||
| 178826 | 178826 | 187900 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 6ft | 6015174.133909999 | 2101026.33165 | 37.749870668392504 | -122.390326583523 | (37.7498706683925, -122.390326583523) | |||
| 181583 | 181583 | 187905 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 167 Jessie St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011979.98788 | 2114548.14877 | 37.786820829172704 | -122.402322770701 | (37.7868208291727, -122.402322770701) | |||
| 184899 | 184899 | 203425 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 135 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994247.20035 | 2096642.9024 | 37.7366518402943 | -122.46237446791099 | (37.7366518402943, -122.462374467911) | |||
| 188610 | 188610 | 220464 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1900 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009491.007180001 | 2105849.8478099997 | 37.762798078402795 | -122.410319710493 | (37.7627980784028, -122.410319710493) |
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");