Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2759 | 2759 | 253203 | Planning Code 138.1 required 4 | Acer buergeranum :: Trident Maple 120 | 349 Mangels Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999103.0 | 2095207.0 | 37.732987611392005 | -122.44548271607799 | (37.732987611392, -122.445482716078) | ||||
| 66737 | 66737 | 52400 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 47@ MISSION Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2005 12:00:00 AM | Permit Number 48521 | 6005927.537671201 | 2097730.99268597 | 37.7403051709369 | -122.42206771657101 | (37.7403051709369, -122.422067716571) | ||
| 80528 | 80528 | 108822 | Section 143 8 | Acer buergeranum :: Trident Maple 120 | 101x FREMONT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6013648.6 | 2115847.1 | 37.7904804500674 | -122.396640813258 | (37.7904804500674, -122.396640813258) | ||||
| 80693 | 80693 | 82113 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 879 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49917 | 6009150.8680199 | 2104052.95048314 | 37.75784513460721 | -122.411369187565 | (37.7578451346072, -122.411369187565) | ||
| 81611 | 81611 | 81834 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 298X Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2007 12:00:00 AM | 6x6 | Permit Number 49798 | 5997424.88906207 | 2109543.24349754 | 37.772255430160605 | -122.452318476797 | (37.7722554301606, -122.452318476797) | ||
| 83622 | 83622 | 104974 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 752 Carolina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770765 | 6012376.8 | 2104435.9 | 37.7590770349231 | -122.400239393453 | (37.7590770349231, -122.400239393453) | |||
| 85760 | 85760 | 104972 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 752 Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770765 | 6012376.8 | 2104435.9 | 37.7590770349231 | -122.400239393453 | (37.7590770349231, -122.400239393453) | |||
| 87018 | 87018 | 84452 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1851 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52645 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | ||
| 88712 | 88712 | 60745 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 422 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2003 12:00:00 AM | Permit Number 20409 | 6007334.40549184 | 2097245.88253216 | 37.7390524145146 | -122.41716894979099 | (37.7390524145146, -122.417168949791) | ||
| 90118 | 90118 | 122683 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 425 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000126.0 | 2110519.0 | 37.7750889825958 | -122.443045211806 | (37.7750889825958, -122.443045211806) | ||||
| 91052 | 91052 | 84451 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1851 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52645 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | ||
| 92990 | 92990 | 111060 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1851 Bryant St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | ||||
| 94332 | 94332 | 84450 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1851 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52645 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | ||
| 95371 | 95371 | 44002 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1800 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2010 12:00:00 AM | Permit Number 53179 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | |||
| 98535 | 98535 | 51303 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 3995 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2004 12:00:00 AM | Permit Number 47671 | 5992078.32104931 | 2087181.87180329 | 37.7105490480114 | -122.46918476594401 | (37.7105490480114, -122.469184765944) | |||
| 102958 | 102958 | 84449 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1851 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52645 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | ||
| 103729 | 103729 | 95616 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2793 16TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767383 | 6008124.7 | 2106783.6 | 37.7652852608497 | -122.41511139845 | (37.7652852608497, -122.41511139845) | |
| 104131 | 104131 | 115162 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 615 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775225 | 5998622.9 | 2105584.3 | 37.7614537320174 | -122.44788939310499 | (37.7614537320174, -122.447889393105) | |||
| 104922 | 104922 | 122841 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 20x Seymour St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001693.0 | 2112151.0 | 37.77965926371179 | -122.437741533251 | (37.7796592637118, -122.437741533251) | ||||
| 105240 | 105240 | 92132 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 82 West View Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52485 | 6007205.2 | 2094288.6 | 37.7309250963222 | -122.41740616237699 | (37.7309250963222, -122.417406162377) | ||
| 107156 | 107156 | 95403 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 385 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767277 | 6003420.0 | 2099198.0 | 37.744191487367104 | -122.43084244532301 | (37.7441914873671, -122.430842445323) | |
| 108033 | 108033 | 61291 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 399 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2003 12:00:00 AM | Permit Number 21183 | 6007155.55605938 | 2097324.01854012 | 37.739256895439794 | -122.417792867933 | (37.7392568954398, -122.417792867933) | ||
| 108765 | 108765 | 65169 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 650 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1989 12:00:00 AM | 6x18 | Permit Number 49965 | 6001191.63682568 | 2102599.3727913 | 37.7534043375019 | -122.438791312875 | (37.7534043375019, -122.438791312875) | ||
| 110893 | 110893 | 114964 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 365 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 775367 | 6005522.4 | 2101591.5 | 37.750882384979995 | -122.423742946306 | (37.75088238498, -122.423742946306) | |||
| 112992 | 112992 | 84453 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1851 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52645 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | ||
| 113754 | 113754 | 51383 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1535 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2004 12:00:00 AM | Permit Number 47713 | 6008370.90757832 | 2109003.97067657 | 37.771395713863605 | -122.41441694433 | (37.7713957138636, -122.41441694433) | |||
| 114607 | 114607 | 112776 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 366 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774291 | 5992832.6 | 2113015.6 | 37.781525427838396 | -122.46845614796699 | (37.7815254278384, -122.468456147967) | ||
| 115704 | 115704 | 114985 | Planning Code 138.1 required 4 | Acer buergeranum :: Trident Maple 120 | 1188 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | Permit Number 773128 | 6003158.9 | 2101346.9 | 37.7500770674438 | -122.43189868142001 | (37.7500770674438, -122.43189868142) | |||
| 116349 | 116349 | 87984 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 809 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51021 | 6002006.0 | 2111228.0 | 37.777142730335 | -122.43659264798 | (37.777142730335, -122.43659264798) | ||
| 118738 | 118738 | 50684 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 143 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | Permit Number 47256 | 6007969.07490995 | 2097962.19651327 | 37.741054939322204 | -122.41502523375799 | (37.7410549393222, -122.415025233758) | |||
| 119731 | 119731 | 102080 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 27 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769730 | 6007460.8 | 2099922.6 | 37.7464091944673 | -122.416921530448 | (37.7464091944673, -122.416921530448) | |
| 120503 | 120503 | 111058 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1851 Bryant St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | ||||
| 123106 | 123106 | 52401 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 47@ MISSION Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2005 12:00:00 AM | Permit Number 48521 | 6005927.537671201 | 2097730.99268597 | 37.7403051709369 | -122.42206771657101 | (37.7403051709369, -122.422067716571) | ||
| 123925 | 123925 | 95383 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 3882 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767254 | 6004605.0 | 2101349.0 | 37.7501647061891 | -122.42689813390301 | (37.7501647061891, -122.426898133903) | |
| 124707 | 124707 | 92974 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1739 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2010 12:00:00 AM | Permit Number 53130 | 6001710.0 | 2112178.0 | 37.7797343655013 | -122.437684657223 | (37.7797343655013, -122.437684657223) | |||
| 124774 | 124774 | 95617 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2797 16TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767383 | 6008167.0 | 2106709.1 | 37.765083078176204 | -122.41495981886999 | (37.7650830781762, -122.41495981887) | |
| 127962 | 127962 | 104973 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 752 Carolina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770765 | 6012376.8 | 2104435.9 | 37.7590770349231 | -122.400239393453 | (37.7590770349231, -122.400239393453) | |||
| 128251 | 128251 | 62905 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 322 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2003 12:00:00 AM | Permit Number 23280 | 6006976.21109695 | 2097296.87142555 | 37.739172261084 | -122.418411039627 | (37.739172261084, -122.418411039627) | ||
| 128820 | 128820 | 111061 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1851 Bryant St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | ||||
| 139258 | 139258 | 64715 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 144 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2005 12:00:00 AM | Permit Number 25667 | 6006489.13363316 | 2097549.49596669 | 37.739838480174896 | -122.42011306053301 | (37.7398384801749, -122.420113060533) | ||
| 139955 | 139955 | 111059 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1851 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | ||||
| 141977 | 141977 | 82695 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1555-1557 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50231 | 6010513.29558366 | 2100547.672123 | 37.7482967364932 | -122.40641033512199 | (37.7482967364932, -122.406410335122) | ||
| 145351 | 145351 | 108823 | Section 143 8 | Acer buergeranum :: Trident Maple 120 | 101x FREMONT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6013648.6 | 2115847.1 | 37.7904804500674 | -122.396640813258 | (37.7904804500674, -122.396640813258) | ||||
| 140426 | 140426 | 175081 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 27 Sears St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 1ft | 5996779.12148 | 2087015.14863 | 37.71036177455 | -122.45292583705601 | (37.71036177455, -122.452925837056) | |||
| 23337 | 23337 | 99375 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 3921 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768860 | 5996022.78804 | 2115189.92908 | 37.7876793085021 | -122.45757706543002 | (37.7876793085021, -122.45757706543) | |
| 25750 | 25750 | 187815 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1020 Le Conte Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6013104.719330001 | 2089623.63357 | 37.7184462121049 | -122.39668350344601 | (37.7184462121049, -122.396683503446) | |||
| 26330 | 26330 | 221652 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 303 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004504.7671 | 2098377.5922 | 37.742000237123605 | -122.42703313408701 | (37.7420002371236, -122.427033134087) | |||
| 30150 | 30150 | 57960 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 340 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 1 | Permit Number 772773 | 5999451.90276 | 2086477.9387 | 37.709039522936294 | -122.443649609852 | (37.7090395229363, -122.443649609852) | ||
| 31377 | 31377 | 140826 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 510 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996775.194 | 2113867.2875 | 37.7840908785082 | -122.45487829896601 | (37.7840908785082, -122.454878298966) | |||
| 33875 | 33875 | 123291 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 506 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994083.888830001 | 2112023.10777 | 37.778872508647204 | -122.464055253517 | (37.7788725086472, -122.464055253517) | |||
| 39556 | 39556 | 49560 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 49 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2015 12:00:00 AM | 1 | Permit Number 777029 | 6003156.442369999 | 2119085.5556099997 | 37.798782890681 | -122.433174477517 | (37.798782890681, -122.433174477517) | ||
| 40973 | 40973 | 125330 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1335 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007763.34926 | 2117482.29154 | 37.794640982941104 | -122.41711938017201 | (37.7946409829411, -122.417119380172) | |||
| 41082 | 41082 | 120843 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 295 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5989915.80244 | 2113424.7782 | 37.782480005786205 | -122.47857668806002 | (37.7824800057862, -122.47857668806) | |||
| 45145 | 45145 | 203298 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1405 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992698.7106099995 | 2105851.9736 | 37.7618482944917 | -122.46839800376301 | (37.7618482944917, -122.468398003763) | |||
| 52378 | 52378 | 221595 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 206 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004515.099330001 | 2098718.51485 | 37.7429369170054 | -122.42702168481199 | (37.7429369170054, -122.427021684812) | |||
| 52846 | 52846 | 175093 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 44 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003678.86336 | 2093990.74117 | 37.7299082046944 | -122.42957605349599 | (37.7299082046944, -122.429576053496) | |||
| 53496 | 53496 | 221601 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 418 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998530.76454 | 2106730.59265 | 37.7645958968999 | -122.448290597257 | (37.7645958968999, -122.448290597257) | |||
| 55164 | 55164 | 221603 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 431 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008783.89037 | 2096761.2657 | 37.7378032000621 | -122.41212303465599 | (37.7378032000621, -122.412123034656) | |||
| 55635 | 55635 | 221639 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 262 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004605.60731 | 2103984.0713400003 | 37.7574000299964 | -122.42708369757601 | (37.7574000299964, -122.427083697576) | |||
| 56292 | 56292 | 122090 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 743 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990658.64233 | 2110307.2925 | 37.7739633495154 | -122.475779083636 | (37.7739633495154, -122.475779083636) | |||
| 56866 | 56866 | 182405 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1543 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985575.3942 | 2104706.1132 | 37.7582880604292 | -122.492949973167 | (37.7582880604292, -122.492949973167) | |||
| 57251 | 57251 | 175092 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 318 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998127.55186 | 2088899.90602 | 37.7156140698133 | -122.44840104028098 | (37.7156140698133, -122.448401040281) | |||
| 59932 | 59932 | 83369 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1055 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2014 12:00:00 AM | 1 | Permit Number 772823 | 6012226.746040001 | 2103450.91527 | 37.7563641153385 | -122.40068915850401 | (37.7563641153385, -122.400689158504) | |
| 62037 | 62037 | 187814 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1020 Le Conte Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6013124.66356 | 2089609.91274 | 37.718409647453 | -122.39661360273199 | (37.718409647453, -122.396613602732) | |||
| 63687 | 63687 | 203296 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1969 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990940.45703 | 2102022.49787 | 37.751231851693 | -122.474199607622 | (37.751231851693, -122.474199607622) | |||
| 67121 | 67121 | 203302 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 974 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995940.56903 | 2090377.0190299999 | 37.71954459370029 | -122.456066927048 | (37.7195445937003, -122.456066927048) | |||
| 67335 | 67335 | 187818 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 205 Salinas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6012618.73899 | 2090601.3502900002 | 37.7211037654109 | -122.398431913204 | (37.7211037654109, -122.398431913204) | |||
| 68226 | 68226 | 113035 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 251 06th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 1 | 3x3 | 5993975.80165 | 2113783.25834 | 37.7836991768592 | -122.464557007516 | (37.7836991768592, -122.464557007516) | |||
| 69597 | 69597 | 140825 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 500 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996795.1609 | 2113868.6412 | 37.784095740758 | -122.454809318923 | (37.784095740758, -122.454809318923) | |||
| 69609 | 69609 | 45195 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 533 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/2013 12:00:00 AM | 1 | Permit Number 770806 | 6013564.94322 | 2104599.1713099997 | 37.759591522239795 | -122.39614164302401 | (37.7595915222398, -122.396141643024) | |
| 70452 | 70452 | 187807 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1501 25th St | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6014157.8907 | 2101958.46235 | 37.7523736777015 | -122.39390606780898 | (37.7523736777015, -122.393906067809) | ||||
| 70951 | 70951 | 187816 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1020 Le Conte Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6013083.517469999 | 2089639.6532599998 | 37.7184890189273 | -122.396757912441 | (37.7184890189273, -122.396757912441) | |||
| 71142 | 71142 | 203308 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 254 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5999724.87507 | 2095247.89 | 37.7331353678889 | -122.443335674514 | (37.7331353678889, -122.443335674514) | |||
| 73284 | 73284 | 221589 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1298 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010298.25709 | 2101707.85409 | 37.751470308726894 | -122.40723570858201 | (37.7514703087269, -122.407235708582) | |||
| 76278 | 76278 | 141263 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 57 PARKER AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996811.9128 | 2114193.0185 | 37.7849873555455 | -122.45477480773899 | (37.7849873555455, -122.454774807739) | |||
| 112691 | 112691 | 221590 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 40 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6005356.48432 | 2103446.19483 | 37.7559655789711 | -122.424448606638 | (37.7559655789711, -122.424448606638) | |||
| 131590 | 131590 | 221598 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3835 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004922.63411 | 2100744.76364 | 37.7485235676072 | -122.42575673258001 | (37.7485235676072, -122.42575673258) | |||
| 134635 | 134635 | 221596 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 284 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004141.2523 | 2098697.9231 | 37.7428592299584 | -122.42831287746401 | (37.7428592299584, -122.428312877464) | |||
| 134714 | 134714 | 140827 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 520 Euclid Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996759.2882 | 2113866.2722 | 37.7840871783405 | -122.454933253599 | (37.7840871783405, -122.454933253599) | |||
| 135285 | 135285 | 58364 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 830 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1978 12:00:00 AM | 1 | Permit Number 17393 | 6000499.2722 | 2111849.5321 | 37.7787635613104 | -122.441849500148 | (37.7787635613104, -122.441849500148) | ||
| 136373 | 136373 | 140828 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 522 Euclid Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996742.3671 | 2113865.9338 | 37.7840852784904 | -122.454991769706 | (37.7840852784904, -122.454991769706) | |||
| 137911 | 137911 | 221640 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 264 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004586.45702 | 2103983.55816 | 37.7573975379924 | -122.427149890352 | (37.7573975379924, -122.427149890352) | |||
| 150298 | 150298 | 122935 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 366 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992808.12502 | 2113018.7034 | 37.7815325351796 | -122.468541044774 | (37.7815325351796, -122.468541044774) | |||
| 156359 | 156359 | 221576 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 98 Elgin Park | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6005820.21347 | 2108567.35172 | 37.7700532438971 | -122.42320888847799 | (37.7700532438971, -122.423208888478) | |||
| 160215 | 160215 | 221608 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2901 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009434.747819999 | 2102163.68308 | 37.752673548562605 | -122.41025402043199 | (37.7526735485626, -122.410254020432) | |||
| 162243 | 162243 | 187817 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 205 Salinas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6012612.74982 | 2090602.9708900002 | 37.7211078816055 | -122.39845272981199 | (37.7211078816055, -122.398452729812) | |||
| 162787 | 162787 | 182734 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1751 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985931.2126 | 2103316.1262 | 37.754492340305 | -122.49161709709499 | (37.754492340305, -122.491617097095) | |||
| 163943 | 163943 | 120842 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 295 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5989915.896240001 | 2113429.21441 | 37.7824921918256 | -122.47857668807501 | (37.7824921918256, -122.478576688075) | |||
| 164444 | 164444 | 121985 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 454 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5991269.55621 | 2112312.02155 | 37.779503186990794 | -122.473812131609 | (37.7795031869908, -122.473812131609) | |||
| 166711 | 166711 | 41281 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 850 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2013 12:00:00 AM | 1 | Permit Number 770203 | 6012419.16584 | 2119105.18058 | 37.79935786234 | -122.401123636248 | (37.79935786234, -122.401123636248) | ||
| 168627 | 168627 | 221573 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 40 Elgin Park | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6005806.54195 | 2108839.22973 | 37.7707989842145 | -122.42327550758101 | (37.7707989842145, -122.423275507581) | |||
| 171247 | 171247 | 221599 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3834 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004934.18141 | 2100789.3668299997 | 37.748646690198896 | -122.425719976397 | (37.7486466901989, -122.425719976397) | |||
| 172284 | 172284 | 175087 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 339 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004286.79403 | 2090457.00677 | 37.7202397543384 | -122.427222750735 | (37.7202397543384, -122.427222750735) | |||
| 176508 | 176508 | 175088 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 375 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002107.93429 | 2091559.7629 | 37.7231442147086 | -122.434833155628 | (37.7231442147086, -122.434833155628) | |||
| 177040 | 177040 | 221600 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 617 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998650.226869999 | 2105582.31202 | 37.7614498354487 | -122.44779473806001 | (37.7614498354487, -122.44779473806) | |||
| 181821 | 181821 | 221579 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 365 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6005497.37078 | 2101576.73958 | 37.7508404433343 | -122.423828450348 | (37.7508404433343, -122.423828450348) | |||
| 188142 | 188142 | 175091 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 315 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998119.37359 | 2088859.0564599999 | 37.7155014387137 | -122.44842636790301 | (37.7155014387137, -122.448426367903) | |||
| 23501 | 23501 | 187800 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2 Heron St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6009988.42633 | 2110014.66553 | 37.7742615809293 | -122.40889316451499 | (37.7742615809293, -122.408893164515) | |||
| 27288 | 27288 | 203304 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1531 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992105.89675 | 2105003.70672 | 37.759484918408496 | -122.470386514529 | (37.7594849184085, -122.470386514529) | |||
| 27584 | 27584 | 221634 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 3647 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003905.15604 | 2103026.4808 | 37.7547310787034 | -122.4294378484 | (37.7547310787034, -122.4294378484) |
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");