Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 173013 | 173013 | 109047 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2146 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6000527.7493 | 2120317.86339 | 37.802017012842995 | -122.44235909620701 | (37.802017012843, -122.442359096207) | ||||
| 114101 | 114101 | 142930 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 581 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6010719.0959 | 2118913.2737 | 37.7987359458828 | -122.40699296942499 | (37.7987359458828, -122.406992969425) | |||
| 152371 | 152371 | 142929 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 591 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6010700.0761 | 2118912.2456 | 37.7987320586367 | -122.407058711866 | (37.7987320586367, -122.407058711866) | |||
| 36568 | 36568 | 125406 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2650 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6001656.15712 | 2117548.20785 | 37.794476515841495 | -122.43825574691799 | (37.7944765158415, -122.438255746918) | |||
| 82990 | 82990 | 122582 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2500X Lyon St | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 6 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
| 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) | |||
| 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) | ||||
| 88825 | 88825 | 107152 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | In front of Gap Inc. | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | |||
| 99988 | 99988 | 107153 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | ||||
| 107872 | 107872 | 107156 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | ||||
| 112179 | 112179 | 107154 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | ||||
| 70136 | 70136 | 187903 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 47 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6013582.62491 | 2115938.98616 | 37.790729075944206 | -122.396875529384 | (37.7907290759442, -122.396875529384) | |||
| 169731 | 169731 | 187902 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 47 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6013611.03319 | 2115912.70701 | 37.790658500748 | -122.39677539438101 | (37.790658500748, -122.396775394381) | |||
| 20380 | 20380 | 112084 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 104211 | 104211 | 112085 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 70381 | 70381 | 187935 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6015174.64356 | 2115822.5435099998 | 37.790497836842796 | -122.391359037593 | (37.7904978368428, -122.391359037593) | |||
| 176685 | 176685 | 187934 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015195.69866 | 2115800.94411 | 37.7904396983948 | -122.391284677144 | (37.7904396983948, -122.391284677144) | |||
| 176021 | 176021 | 187933 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015208.90661 | 2115787.01653 | 37.7904021894671 | -122.391238004144 | (37.7904021894671, -122.391238004144) | |||
| 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) | |||
| 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) | |||
| 25823 | 25823 | 187931 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6015237.31948 | 2115756.16147 | 37.790319045339 | -122.391137539076 | (37.790319045339, -122.391137539076) | |||
| 151901 | 151901 | 187909 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 145 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013732.28694 | 2115779.57523 | 37.7902997000163 | -122.39634652479602 | (37.7902997000163, -122.396346524796) | |||
| 183883 | 183883 | 187930 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6015248.50297 | 2115743.86859 | 37.790285912521 | -122.391097985077 | (37.790285912521, -122.391097985077) | |||
| 163928 | 163928 | 187917 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013888.85856 | 2115506.90932 | 37.7895597342357 | -122.395785680575 | (37.7895597342357, -122.395785680575) | |||
| 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) | |||
| 70138 | 70138 | 38959 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3186 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | 6 | Permit Number 40754 | 5999542.34025 | 2115724.95595 | 37.7893498954312 | -122.445438624911 | (37.7893498954312, -122.445438624911) | ||
| 24244 | 24244 | 187915 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013761.85881 | 2115378.38602 | 37.7891997734024 | -122.396216078116 | (37.7891997734024, -122.396216078116) | |||
| 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) | |||
| 189078 | 189078 | 187940 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015048.62855 | 2115342.19505 | 37.7891719160015 | -122.39176144464899 | (37.7891719160015, -122.391761444649) | ||||
| 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) | |||
| 47402 | 47402 | 187941 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015065.49236 | 2115322.58848 | 37.7891190169896 | -122.391701726057 | (37.7891190169896, -122.391701726057) | ||||
| 132233 | 132233 | 187912 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013728.03817 | 2115347.11788 | 37.7891120364521 | -122.396330901758 | (37.7891120364521, -122.396330901758) | |||
| 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) | ||||
| 78470 | 78470 | 121547 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 79273 | 79273 | 121543 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 90872 | 90872 | 121545 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 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) | ||||
| 115120 | 115120 | 121546 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 126027 | 126027 | 121544 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 129011 | 129011 | 121540 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 144636 | 144636 | 121541 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 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) | |||
| 46513 | 46513 | 187943 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015093.730769999 | 2115293.30797 | 37.7890401869059 | -122.391601975949 | (37.7890401869059, -122.391601975949) | ||||
| 49996 | 49996 | 187944 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015109.7038 | 2115276.55289 | 37.7889950679055 | -122.391545539018 | (37.7889950679055, -122.391545539018) | ||||
| 182424 | 182424 | 187945 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015129.7605099995 | 2115255.3706 | 37.7889380194338 | -122.391474663423 | (37.7889380194338, -122.391474663423) | ||||
| 163969 | 163969 | 187946 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015145.56326 | 2115239.56325 | 37.788895493169896 | -122.391418882079 | (37.7888954931699, -122.391418882079) | ||||
| 158483 | 158483 | 187947 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015161.72984 | 2115222.99296 | 37.7888508922136 | -122.391361788631 | (37.7888508922136, -122.391361788631) | ||||
| 53943 | 53943 | 187929 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Natoma St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013625.5813 | 2115247.15828 | 37.788831868855205 | -122.396678381805 | (37.7888318688552, -122.396678381805) | |||
| 71721 | 71721 | 187928 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Natoma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013614.18616 | 2115234.9562 | 37.788797730571396 | -122.396716951919 | (37.7887977305714, -122.396716951919) | |||
| 62879 | 62879 | 187927 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Natoma St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013603.72769 | 2115224.95515 | 37.7887696879241 | -122.39675243559601 | (37.7887696879241, -122.396752435596) | |||
| 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) | |||
| 134632 | 134632 | 187925 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013571.0237 | 2115195.4234 | 37.7886867803215 | -122.396863516254 | (37.7886867803215, -122.396863516254) | |||
| 66786 | 66786 | 187924 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013555.31002 | 2115180.42433 | 37.7886447217118 | -122.39691683164301 | (37.7886447217118, -122.396916831643) | |||
| 37847 | 37847 | 187948 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6015252.9594 | 2115128.97629 | 37.788597806797796 | -122.391039570534 | (37.7885978067978, -122.391039570534) | ||||
| 30838 | 30838 | 187949 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015269.3196 | 2115112.5908 | 37.7885537238177 | -122.390981820563 | (37.7885537238177, -122.390981820563) | ||||
| 79454 | 79454 | 49231 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 81986 | 81986 | 49242 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 99081 | 99081 | 49229 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 99509 | 99509 | 49215 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 108123 | 108123 | 49228 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 139175 | 139175 | 49216 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 60711 | 60711 | 187936 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 255 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014368.82149 | 2115126.24847 | 37.7885412160406 | -122.394098386929 | (37.7885412160406, -122.394098386929) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 39657 | 39657 | 187951 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015307.966030001 | 2115072.7119299998 | 37.7884463699393 | -122.390845320574 | (37.7884463699393, -122.390845320574) | ||||
| 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) | |||
| 35251 | 35251 | 121502 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | |||
| 60824 | 60824 | 121501 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014441.60375 | 2115047.86993 | 37.7883300516388 | -122.39384108102101 | (37.7883300516388, -122.393841081021) | |||
| 28247 | 28247 | 187919 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 48 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013100.51395 | 2115046.75094 | 37.7882523600964 | -122.398480985606 | (37.7882523600964, -122.398480985606) | |||
| 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) | |||
| 53660 | 53660 | 187921 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 48 Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6013082.0927800005 | 2115028.0005200002 | 37.7881998495857 | -122.398543403948 | (37.7881998495857, -122.398543403948) | |||
| 38415 | 38415 | 187922 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 48 Minna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013074.697930001 | 2115022.06537 | 37.7881831410762 | -122.398568572402 | (37.7881831410762, -122.398568572402) | |||
| 35323 | 35323 | 187923 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 48 Minna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6013066.988580001 | 2115014.97781 | 37.7881632507911 | -122.398594748068 | (37.7881632507911, -122.398594748068) | |||
| 166765 | 166765 | 123540 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 27 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994225.0963 | 2115400.2579200002 | 37.788153386103204 | -122.463811955609 | (37.7881533861032, -122.463811955609) | |||
| 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) | |||
| 163783 | 163783 | 187938 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 235 01st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6014012.10729 | 2114977.49045 | 37.7881129283138 | -122.395322147516 | (37.7881129283138, -122.395322147516) | |||
| 72829 | 72829 | 187937 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 235 01st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6014022.484619999 | 2114966.0106 | 37.7880819844437 | -122.395285438995 | (37.7880819844437, -122.395285438995) | |||
| 16382 | 16382 | 108062 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014690.02107 | 2114784.12371 | 37.787619667256706 | -122.392963130455 | (37.7876196672567, -122.392963130455) | ||
| 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) | ||
| 14670 | 14670 | 108060 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014722.47105 | 2114748.4926400003 | 37.7875236349662 | -122.39284836525299 | (37.7875236349662, -122.392848365253) | ||
| 41167 | 41167 | 53357 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/1969 12:00:00 AM | 3 | Permit Number 6250 | 6014738.317419999 | 2114732.62752 | 37.7874809531407 | -122.392792429224 | (37.7874809531407, -122.392792429224) | ||
| 13813 | 13813 | 115356 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014763.69701 | 2114705.74438 | 37.7874085478076 | -122.39270273893801 | (37.7874085478076, -122.392702738938) | |
| 14429 | 14429 | 115355 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014786.34664 | 2114681.69198 | 37.7873437633547 | -122.392622692086 | (37.7873437633547, -122.392622692086) | |
| 14383 | 14383 | 118374 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x6 | 6014693.17098 | 2114681.8097099997 | 37.787338911495 | -122.392945071183 | (37.787338911495, -122.392945071183) | |||
| 78293 | 78293 | 118379 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 83570 | 83570 | 118377 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 86944 | 86944 | 118378 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 89450 | 89450 | 118380 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 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) | ||||
| 15478 | 15478 | 115354 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014804.627730001 | 2114662.16926 | 37.7872911737029 | -122.39255807669 | (37.7872911737029, -122.39255807669) | |
| 26030 | 26030 | 118375 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4x6 | 6014712.487269999 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | |||
| 13917 | 13917 | 115353 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014819.91687 | 2114646.3157900004 | 37.787248492781295 | -122.39250406973 | (37.7872484927813, -122.39250406973) | |
| 57750 | 57750 | 187952 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 350 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014738.2491 | 2114633.8383299997 | 37.7872096969197 | -122.39278575178601 | (37.7872096969197, -122.392785751786) | |||
| 14382 | 14382 | 115352 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014845.33617 | 2114621.37484 | 37.7871814222392 | -122.392414378515 | (37.7871814222392, -122.392414378515) | |
| 61724 | 61724 | 187953 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 350 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014758.29255 | 2114615.93494 | 37.787161651545205 | -122.392715152285 | (37.7871616515452, -122.392715152285) | |||
| 16337 | 16337 | 115351 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014858.418740001 | 2114606.67601 | 37.7871417890985 | -122.39236808681801 | (37.7871417890985, -122.392368086818) | |
| 159723 | 159723 | 187908 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 167 Jessie St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012100.151219999 | 2114661.96833 | 37.7871400579 | -122.401915035175 | (37.7871400579, -122.401915035175) | |||
| 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) | |||
| 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) |
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");