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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40227 | 40227 | 203406 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994466.0383 | 2096440.3744299999 | 37.736108347605295 | -122.461603176966 | (37.7361083476053, -122.461603176966) | |||
| 71761 | 71761 | 203405 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994431.87617 | 2096469.95405 | 37.736187599465204 | -122.46172343251101 | (37.7361875994652, -122.461723432511) | |||
| 159278 | 159278 | 203404 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994396.0657 | 2096501.5652400001 | 37.7362723344984 | -122.461849534529 | (37.7362723344984, -122.461849534529) | |||
| 167748 | 167748 | 203403 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994381.0014 | 2096518.06805 | 37.736316779896995 | -122.461902813967 | (37.736316779897, -122.461902813967) | |||
| 42234 | 42234 | 187869 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 6015103.96021 | 2100930.78351 | 37.749604420516896 | -122.390562573713 | (37.7496044205169, -122.390562573713) | |||
| 31410 | 31410 | 203402 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 20 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993459.6533 | 2097164.40162 | 37.738038365583 | -122.465135202222 | (37.738038365583, -122.465135202222) | |||
| 32405 | 32405 | 203412 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993816.05949 | 2102205.88495 | 37.7519015516321 | -122.464268849347 | (37.7519015516321, -122.464268849347) | |||
| 34402 | 34402 | 203409 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993779.2225 | 2102246.7483099997 | 37.7520116286371 | -122.46439920245399 | (37.7520116286371, -122.464399202454) | |||
| 46595 | 46595 | 203410 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993793.04129 | 2102233.18002 | 37.7519751701323 | -122.464350430425 | (37.7519751701323, -122.464350430425) | |||
| 59063 | 59063 | 187896 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 7 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6015200.4277800005 | 2100533.54912 | 37.748519049422704 | -122.390201234205 | (37.7485190494227, -122.390201234205) | |||
| 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) | |||
| 63718 | 63718 | 203407 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5993759.21038 | 2102270.66076 | 37.7520761325235 | -122.46447014280899 | (37.7520761325235, -122.464470142809) | |||
| 67284 | 67284 | 187895 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 6 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6015201.97274 | 2100509.17213 | 37.7484522010065 | -122.39019418890601 | (37.7484522010065, -122.390194188906) | |||
| 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) | |||
| 129642 | 129642 | 187897 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 6ft | 6015199.38185 | 2100557.40869 | 37.7485845047902 | -122.39020651771999 | (37.7485845047902, -122.39020651772) | |||
| 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) | |||
| 135019 | 135019 | 203401 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 24 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993518.80789 | 2097119.92672 | 37.737919659575404 | -122.46492744804199 | (37.7379196595754, -122.464927448042) | |||
| 149627 | 149627 | 187893 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6015205.088280001 | 2100461.68616 | 37.7483219872815 | -122.390180098326 | (37.7483219872815, -122.390180098326) | |||
| 149677 | 149677 | 187890 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6015208.72001 | 2100389.3363099997 | 37.7481235311712 | -122.39016248603001 | (37.7481235311712, -122.39016248603) | |||
| 149696 | 149696 | 203400 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 34 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993596.06359 | 2097068.4927400001 | 37.737782888861396 | -122.46465660552201 | (37.7377828888614, -122.464656605522) | |||
| 159899 | 159899 | 187898 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 7 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6015180.25331 | 2100882.371 | 37.749475722127 | -122.390295365361 | (37.749475722127, -122.390295365361) | |||
| 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) | |||
| 161699 | 161699 | 203411 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5993801.541669999 | 2102222.78745 | 37.751947124766104 | -122.46432028066201 | (37.7519471247661, -122.464320280662) | |||
| 171730 | 171730 | 203413 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993820.42059 | 2102181.53499 | 37.7518349442394 | -122.464252000534 | (37.7518349442394, -122.464252000534) | |||
| 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) | |||
| 186986 | 186986 | 187899 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 8 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6015181.09261 | 2100903.60273 | 37.7495340665546 | -122.39029394621201 | (37.7495340665546, -122.390293946212) | |||
| 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) | |||
| 30483 | 30483 | 187888 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1799 Indiana St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6015216.20725 | 2100273.8122 | 37.747806741405 | -122.390128525805 | (37.747806741405, -122.390128525805) | |||
| 42641 | 42641 | 220445 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2501 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6009766.24645 | 2102672.6598 | 37.7540896615292 | -122.409143546541 | (37.7540896615292, -122.409143546541) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 185558 | 185558 | 220438 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2814 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6009797.76242 | 2100932.26628 | 37.749312693037 | -122.40891177146001 | (37.749312693037, -122.40891177146) | |||
| 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) | |||
| 24181 | 24181 | 125409 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 680 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005915.1308699995 | 2112115.06535 | 37.7797997643918 | -122.42313277978 | (37.7797997643918, -122.42313277978) | |||
| 28822 | 28822 | 220469 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2320 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009645.3794 | 2103705.18616 | 37.756917975403205 | -122.40963440819701 | (37.7569179754032, -122.409634408197) | |||
| 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) | |||
| 32646 | 32646 | 203423 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 10 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993355.35449 | 2097236.83517 | 37.7382312350687 | -122.465501072513 | (37.7382312350687, -122.465501072513) | |||
| 34428 | 34428 | 187860 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014887.824680001 | 2103924.74261 | 37.7578132028277 | -122.391519270711 | (37.7578132028277, -122.391519270711) | |||
| 35502 | 35502 | 203417 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993769.4905900005 | 2096990.17002 | 37.7375778308529 | -122.46405130512 | (37.7375778308529, -122.46405130512) | |||
| 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) | |||
| 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) | |||
| 38296 | 38296 | 220467 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2104 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009541.05061 | 2104932.28838 | 37.7602814740251 | -122.41008184609699 | (37.7602814740251, -122.410081846097) | |||
| 39249 | 39249 | 175137 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1802 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6001243.74865 | 2091600.63197 | 37.7232073291514 | -122.437823395139 | (37.7232073291514, -122.437823395139) | |||
| 43633 | 43633 | 203422 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 9 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993354.866669999 | 2097295.22775 | 37.738391538344004 | -122.465506999949 | (37.738391538344, -122.465506999949) | |||
| 46106 | 46106 | 187868 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6015107.19877 | 2100940.7961 | 37.749632092648795 | -122.390552074121 | (37.7496320926488, -122.390552074121) | |||
| 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) | |||
| 63579 | 63579 | 220446 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2429 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009737.03412 | 2103201.22316 | 37.7555393416751 | -122.409281867669 | (37.7555393416751, -122.409281867669) | |||
| 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) | |||
| 66367 | 66367 | 187886 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1798 Indiana St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6015167.00373 | 2100296.44162 | 37.7478661479108 | -122.39030025137698 | (37.7478661479108, -122.390300251377) | |||
| 66862 | 66862 | 220460 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1801 Bryant St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009531.1613 | 2106219.4289 | 37.7638151144958 | -122.410206925636 | (37.7638151144958, -122.410206925636) | |||
| 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) | |||
| 68410 | 68410 | 220458 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1801 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009537.4352400005 | 2106105.46914 | 37.7635025587051 | -122.41017717965799 | (37.7635025587051, -122.410177179658) | |||
| 68972 | 68972 | 203416 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 75 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993822.50089 | 2096951.1599400002 | 37.7374737738828 | -122.463865194036 | (37.7374737738828, -122.463865194036) | |||
| 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) | |||
| 73338 | 73338 | 187861 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014851.37518 | 2103923.26798 | 37.7578071306235 | -122.391645226173 | (37.7578071306235, -122.391645226173) | |||
| 74171 | 74171 | 203427 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 101 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994083.74487 | 2096763.2179299998 | 37.7369727831569 | -122.462948326201 | (37.7369727831569, -122.462948326201) | |||
| 130360 | 130360 | 203420 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 15 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993455.07316 | 2097218.01136 | 37.7381853004145 | -122.465154930655 | (37.7381853004145, -122.465154930655) | |||
| 130777 | 130777 | 203419 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 35 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993568.7451 | 2097128.9038799999 | 37.7379471878035 | -122.464755443717 | (37.7379471878035, -122.464755443717) | |||
| 132785 | 132785 | 203421 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993401.40723 | 2097258.40143 | 37.738293106632 | -122.46534341236799 | (37.738293106632, -122.465343412368) | |||
| 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) | |||
| 134499 | 134499 | 125410 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 680 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005899.660080001 | 2112113.57436 | 37.77979479743679 | -122.423186194101 | (37.7797947974368, -122.423186194101) | |||
| 147976 | 147976 | 203424 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 135 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994267.45762 | 2096626.89262 | 37.7366090478713 | -122.462303269505 | (37.7366090478713, -122.462303269505) | |||
| 150977 | 150977 | 189099 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6015984.41779 | 2097613.57521 | 37.740544856170295 | -122.387286529648 | (37.7405448561703, -122.387286529648) | |||
| 154121 | 154121 | 189097 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6016014.59263 | 2097591.62431 | 37.7404862545337 | -122.387180665066 | (37.7404862545337, -122.387180665066) | |||
| 155871 | 155871 | 203426 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 135 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994229.44749 | 2096660.50029 | 37.7366991374492 | -122.462437122787 | (37.7366991374492, -122.462437122787) | |||
| 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) | |||
| 159682 | 159682 | 220457 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1801 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009539.42698 | 2106062.60789 | 37.7633849831425 | -122.410167264604 | (37.7633849831425, -122.410167264604) | |||
| 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) | |||
| 165796 | 165796 | 187862 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014817.13681 | 2103921.30652 | 37.7577998442984 | -122.391763500508 | (37.7577998442984, -122.391763500508) | |||
| 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) | |||
| 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) | |||
| 175947 | 175947 | 203418 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993705.93526 | 2097033.15738 | 37.7376922003421 | -122.464274164331 | (37.7376922003421, -122.464274164331) | |||
| 177219 | 177219 | 187863 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014779.35542 | 2103919.85891 | 37.7577937720836 | -122.391894064084 | (37.7577937720836, -122.391894064084) | |||
| 181067 | 181067 | 220488 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 4276 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6000665.21266 | 2102890.6244900003 | 37.754174080892795 | -122.44063268295 | (37.7541740808928, -122.44063268295) | |||
| 182213 | 182213 | 125408 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 830 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006361.841019999 | 2113219.81406 | 37.7828583334858 | -122.42166589828001 | (37.7828583334858, -122.42166589828) | |||
| 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) | |||
| 186987 | 186987 | 220459 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1801 Bryant St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009533.63521 | 2106182.62398 | 37.763714195267205 | -122.410195770427 | (37.7637141952672, -122.410195770427) | |||
| 226 | 226 | 220498 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 217 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | 8 | Width 3ft | Permit Number 11470 | 6001117.07632 | 2105053.576 | 37.760138741716794 | -122.43922504972001 | (37.7601387417168, -122.43922504972) | |
| 1475 | 1475 | 187957 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 81 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014291.0 | 2114089.0 | 37.78568884516871 | -122.39429498812099 | (37.7856888451687, -122.394294988121) | |||
| 1577 | 1577 | 220490 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3040 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | Width 3ft | 6008734.34434 | 2102169.4736599997 | 37.75265016257671 | -122.41267655749901 | (37.7526501625767, -122.412676557499) | ||
| 25016 | 25016 | 220501 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 14 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003128.49952 | 2108178.20652 | 37.768832473561794 | -122.432491682542 | (37.7688324735618, -122.432491682542) |
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");