Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109226 | 109226 | 109516 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 105 MIDCREST WAY | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 12x12 | 5998180.4 | 2101012.8 | 37.748876224655795 | -122.4490904711 | (37.7488762246558, -122.4490904711) | ||||
| 293 | 293 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 362 | 362 | 187139 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 0ft | 5984937.035 | 2099496.8257 | 37.7439474344515 | -122.494773601416 | (37.7439474344515, -122.494773601416) | |||
| 713 | 713 | 251364 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 784 | 784 | 251384 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 869 | 869 | 124177 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 8X Almaden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10 | Width 9ft | 5995876.0 | 2112606.0 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | |||
| 1029 | 1029 | 251428 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5030 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999555.0 | 2100128.0 | 37.7465253005744 | -122.444273545879 | (37.7465253005744, -122.444273545879) | ||||
| 1030 | 1030 | 251424 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 5016 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999555.0 | 2100128.0 | 37.7465253005744 | -122.444273545879 | (37.7465253005744, -122.444273545879) | ||||
| 1736 | 1736 | 251677 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 772x Panorama Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996636.0 | 2102785.0 | 37.7536537924326 | -122.454558985212 | (37.7536537924326, -122.454558985212) | ||||
| 3132 | 3132 | 253339 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 2019X 24th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | PUC 13 | 3x3 | 5988853.0 | 2101569.0 | 37.7498655183494 | -122.481384971136 | (37.7498655183494, -122.481384971136) | ||||
| 18889 | 18889 | 106642 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4540X 17TH ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5999139.0 | 2105833.0 | 37.762166086231204 | -122.446122313424 | (37.7621660862312, -122.446122313424) | ||||
| 26275 | 26275 | 223757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5745 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6000755.6342 | 2096957.8752099997 | 37.7378893137452 | -122.439894635432 | (37.7378893137452, -122.439894635432) | |||
| 30529 | 30529 | 102468 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 50 Saint Germain Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998217.7 | 2104179.8 | 37.757574157371295 | -122.44918961776699 | (37.7575741573713, -122.449189617767) | |||||
| 34630 | 34630 | 205915 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 506 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6000129.85009 | 2095267.01455 | 37.7332109649183 | -122.44193694363199 | (37.7332109649183, -122.441936943632) | |||
| 35760 | 35760 | 223799 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 8 Laidley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | 6003000.19412 | 2098305.51493 | 37.741717135947205 | -122.43223031618601 | (37.7417171359472, -122.432230316186) | ||||
| 38550 | 38550 | 205889 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Stanford Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5997824.88709 | 2095746.51675 | 37.734395947598 | -122.449940335175 | (37.734395947598, -122.449940335175) | |||
| 40038 | 40038 | 185669 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 53 | Width 0ft | 5984862.5592 | 2100842.9002 | 37.7476390291225 | -122.49513035843701 | (37.7476390291225, -122.495130358437) | |||
| 45479 | 45479 | 206804 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 66 Aerial Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 4ft | 5992257.723230001 | 2102553.22068 | 37.7527653009777 | -122.46968303065901 | (37.7527653009777, -122.469683030659) | |||
| 52563 | 52563 | 185073 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985016.5679 | 2096146.6077 | 37.7347532910302 | -122.494251709723 | (37.7347532910302, -122.494251709723) | |||
| 53440 | 53440 | 126417 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2745 Larkin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6006522.5634 | 2120685.74713 | 37.8033669833519 | -122.42164030356301 | (37.8033669833519, -122.421640303563) | ||||
| 57594 | 57594 | 223778 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 731 Noe St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6003093.21791 | 2103983.10417 | 37.757311735462295 | -122.432314067334 | (37.7573117354623, -122.432314067334) | |||
| 60160 | 60160 | 223790 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Storrie St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000695.90206 | 2105313.46128 | 37.7608283472609 | -122.44070032905701 | (37.7608283472609, -122.440700329057) | |||
| 61768 | 61768 | 206845 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 5ft | 5993220.45249 | 2089938.0951 | 37.7181829076919 | -122.465437434707 | (37.7181829076919, -122.465437434707) | |||
| 64573 | 64573 | 206839 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 112 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | 5998729.31623 | 2093223.3736599998 | 37.7275196997604 | -122.446631964111 | (37.7275196997604, -122.446631964111) | ||||
| 64824 | 64824 | 205899 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 106 Miraloma Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994504.976530001 | 2097169.62353 | 37.7381129265739 | -122.461521406103 | (37.7381129265739, -122.461521406103) | |||
| 67489 | 67489 | 223788 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 798 Sanchez St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 48 | Width 3ft | 6003684.1064 | 2103653.23065 | 37.7564394677117 | -122.430247009802 | (37.7564394677117, -122.430247009802) | |||
| 71307 | 71307 | 223724 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 Belgrave Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 66 | Width 2ft | 5997664.737000001 | 2104901.53877 | 37.7595242277824 | -122.451154026041 | (37.7595242277824, -122.451154026041) | |||
| 71780 | 71780 | 223731 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 College Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6005275.60501 | 2095869.1731 | 37.7351562416517 | -122.424189464283 | (37.7351562416517, -122.424189464283) | |||
| 72747 | 72747 | 119989 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2750 Cabrillo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5986984.16114 | 2110526.5625 | 37.7743516837382 | -122.488505680665 | (37.7743516837382, -122.488505680665) | |||
| 72912 | 72912 | 126411 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3398 Pierce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 3ft | 6001324.1548 | 2120088.88928 | 37.8014336702784 | -122.439586737243 | (37.8014336702784, -122.439586737243) | |||
| 73912 | 73912 | 223762 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 177 Twin Peaks Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 44 | Width 10ft | 5998552.863609999 | 2104689.94598 | 37.758994055855496 | -122.448067221836 | (37.7589940558555, -122.448067221836) | |||
| 76030 | 76030 | 206838 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 11 Edgehill Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 53 | 5994833.8129199995 | 2099043.81007 | 37.7432778994565 | -122.460520231332 | (37.7432778994565, -122.460520231332) | ||||
| 82039 | 82039 | 116084 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 127 Edgehill Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | Permit Number 773426 | 5994851.1 | 2098962.7 | 37.7430561859317 | -122.46045458158301 | (37.7430561859317, -122.460454581583) | |||
| 88391 | 88391 | 122637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 102089 | 102089 | 113091 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 398X ARBOR ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6000747.0 | 2096921.0 | 37.7377875715629 | -122.439921844785 | (37.7377875715629, -122.439921844785) | ||||
| 117956 | 117956 | 114707 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500X CONGO ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x10 | 6000185.0 | 2095264.0 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | ||||
| 118710 | 118710 | 105850 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 44 MENDOSA AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 100 | 6x15 | 5993395.1 | 2101192.7 | 37.7490953323683 | -122.465650972372 | (37.7490953323683, -122.465650972372) | |||
| 131318 | 131318 | 223802 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 177 Moffitt St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6002408.06016 | 2097073.2728 | 37.7383000934596 | -122.434189644859 | (37.7383000934596, -122.434189644859) | |||
| 131737 | 131737 | 223810 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 62 Digby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 42 | Width 5ft | 6002815.82616 | 2097712.3092099996 | 37.7400778751 | -122.432825430853 | (37.7400778751, -122.432825430853) | |||
| 134629 | 134629 | 45072 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 580 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Permit Number 770844 | 6012040.04022 | 2105787.48822 | 37.7627694124935 | -122.401499066356 | (37.7627694124935, -122.401499066356) | |||
| 137097 | 137097 | 181441 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984891.7288 | 2105036.7347 | 37.759155850149 | -122.49533873513501 | (37.759155850149, -122.495338735135) | |||
| 137510 | 137510 | 118414 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 641 48th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 5980997.21538 | 2111360.64896 | 37.7762906814163 | -122.509277221064 | (37.7762906814163, -122.509277221064) | ||||
| 142323 | 142323 | 111587 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | ||||
| 147594 | 147594 | 206851 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3800 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 6ft | 5990535.05203 | 2090576.85379 | 37.7197815380709 | -122.47476621738899 | (37.7197815380709, -122.474766217389) | |||
| 150704 | 150704 | 126418 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2237 Hyde St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6007090.48557 | 2119992.12642 | 37.8014944842289 | -122.41962574124099 | (37.8014944842289, -122.419625741241) | ||||
| 153155 | 153155 | 205898 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 142 Bella Vista Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 5998216.302630001 | 2097080.2321099997 | 37.738080399879706 | -122.448683118058 | (37.7380803998797, -122.448683118058) | |||
| 157404 | 157404 | 126412 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Jefferson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6000088.69563 | 2121303.7240299997 | 37.804698887418105 | -122.443949299933 | (37.8046988874181, -122.443949299933) | |||
| 159880 | 159880 | 223800 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 50 Hiliritas Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 2ft | 6001424.08839 | 2096900.34292 | 37.7377693720626 | -122.437579347922 | (37.7377693720626, -122.437579347922) | |||
| 160056 | 160056 | 205906 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 20 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 5ft | 6001210.67203 | 2095218.5824 | 37.7331395119639 | -122.438196788261 | (37.7331395119639, -122.438196788261) | |||
| 160898 | 160898 | 186852 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2700 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 0ft | 5985203.396000001 | 2096268.9816 | 37.7351002284248 | -122.493614804408 | (37.7351002284248, -122.493614804408) | |||
| 161302 | 161302 | 190966 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1912 23rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | 6012683.0695 | 2102873.5527 | 37.7548042439346 | -122.39907049840099 | (37.7548042439346, -122.399070498401) | ||||
| 161313 | 161313 | 122257 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5991472.5237300005 | 2113448.5530000003 | 37.78263554306471 | -122.473192897736 | (37.7826355430647, -122.473192897736) | |||
| 162360 | 162360 | 186263 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1800 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5984973.2141 | 2102324.4773 | 37.7517135119609 | -122.494856946907 | (37.7517135119609, -122.494856946907) | |||
| 164158 | 164158 | 185152 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2500 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5985154.6071 | 2097578.7599 | 37.7386936753561 | -122.49387997533199 | (37.7386936753561, -122.493879975332) | |||
| 165216 | 165216 | 205921 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 335 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | 5997888.47996 | 2095505.4814799998 | 37.7337377607861 | -122.449703111117 | (37.7337377607861, -122.449703111117) | ||||
| 165726 | 165726 | 205902 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 110 Kensington Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5994974.56869 | 2098324.33345 | 37.741310492185605 | -122.45998142862699 | (37.7413104921856, -122.459981428627) | |||
| 167901 | 167901 | 185517 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 56 | Width 0ft | 5984884.6253 | 2100174.2165 | 37.745804297711395 | -122.495004757586 | (37.7458042977114, -122.495004757586) | |||
| 170557 | 170557 | 223763 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 126 Bradford St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6009530.79254 | 2097866.09723 | 37.740878707894296 | -122.409618578334 | (37.7408787078943, -122.409618578334) | |||
| 171054 | 171054 | 206834 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 375 Casitas Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 5ft | 5995064.96816 | 2095832.8748700002 | 37.7344747596986 | -122.45948846344 | (37.7344747596986, -122.45948846344) | |||
| 171399 | 171399 | 184735 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984680.1977 | 2106291.6891 | 37.7625892162308 | -122.496162889393 | (37.7625892162308, -122.496162889393) | |||
| 174021 | 174021 | 206805 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 68 Aerial Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 2ft | 5992337.85259 | 2102586.3377799997 | 37.752860862941205 | -122.469408341716 | (37.7528608629412, -122.469408341716) | |||
| 175698 | 175698 | 205893 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1110 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 5998235.76076 | 2095666.83858 | 37.734200671531504 | -122.448514080556 | (37.7342006715315, -122.448514080556) | |||
| 176897 | 176897 | 186982 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 0ft | 5984958.5274 | 2098137.713 | 37.7402169360885 | -122.49459911154499 | (37.7402169360885, -122.494599111545) | |||
| 179404 | 179404 | 223742 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 921 Alvarado St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 42 | Width 8ft | 6000348.4325 | 2102535.54442 | 37.753181072867 | -122.441702702621 | (37.753181072867, -122.441702702621) | |||
| 183624 | 183624 | 205888 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 300 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 5996225.80911 | 2095294.3314200002 | 37.733062728758505 | -122.455436166843 | (37.7330627287585, -122.455436166843) | |||
| 183726 | 183726 | 205911 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 198 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | 6000172.88009 | 2095259.68329 | 37.733193286925996 | -122.441787651691 | (37.733193286926, -122.441787651691) | ||||
| 184882 | 184882 | 223774 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 615 Sanchez St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 53 | Width 3ft | 6003694.6697 | 2104650.23962 | 37.759177615567296 | -122.43028160673201 | (37.7591776155673, -122.430281606732) | |||
| 185755 | 185755 | 205895 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 110 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5995734.854669999 | 2096206.24435 | 37.7355384364582 | -122.457199459482 | (37.7355384364582, -122.457199459482) | |||
| 186276 | 186276 | 186413 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 64 | Width 0ft | 5984739.2681 | 2104238.7582 | 37.75695590087879 | -122.495807145737 | (37.7569559008788, -122.495807145737) | |||
| 186743 | 186743 | 223811 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 80 Digby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 49 | Width 7ft | 6002713.41805 | 2097728.02904 | 37.7401152293236 | -122.433180638776 | (37.7401152293236, -122.433180638776) | |||
| 300 | 300 | 251263 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 682 | 682 | 251365 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 782 | 782 | 251385 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 9720 | 9720 | 173652 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 65 ZIRCON PL | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6002398.2 | 2098694.7 | 37.7427515964219 | -122.43433962698201 | (37.7427515964219, -122.434339626982) | |||||
| 27038 | 27038 | 119401 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3150 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5985750.26334 | 2110481.7384 | 37.774156534172505 | -122.492770599571 | (37.7741565341725, -122.492770599571) | |||
| 28910 | 28910 | 114708 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500X CONGO ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x10 | 6000185.0 | 2095264.0 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | ||||
| 34543 | 34543 | 123503 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2550 Fulton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 1ft | 5995405.4626400005 | 2110341.7489400003 | 37.774332019483296 | -122.459361641514 | (37.7743320194833, -122.459361641514) | |||
| 36089 | 36089 | 206844 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 488 Ralston St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5992249.47453 | 2091186.11142 | 37.72155360809921 | -122.46888442997299 | (37.7215536080992, -122.468884429973) | |||
| 38624 | 38624 | 223803 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 177 Moffitt St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6002410.1357 | 2097069.9071099998 | 37.7382909698537 | -122.43418222813 | (37.7382909698537, -122.43418222813) | |||
| 39035 | 39035 | 126426 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3130 Lyon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 5999057.94156 | 2119543.59601 | 37.7998072004939 | -122.44738954670099 | (37.7998072004939, -122.447389546701) | |||
| 41442 | 41442 | 205894 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1110 Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 3ft | 5998252.60091 | 2095669.89095 | 37.7342100154709 | -122.44845607881099 | (37.7342100154709, -122.448456078811) | |||
| 46273 | 46273 | 185670 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 44 | Width 0ft | 5984847.5216 | 2100821.9783 | 37.7475807029126 | -122.49518081421999 | (37.7475807029126, -122.49518081422) | |||
| 54161 | 54161 | 223732 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 College Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 6005270.68564 | 2095872.41003 | 37.7351648517715 | -122.424206702478 | (37.7351648517715, -122.424206702478) | |||
| 63473 | 63473 | 205910 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 192 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | 6000206.522969999 | 2095259.2471900003 | 37.7331940064051 | -122.44167130819599 | (37.7331940064051, -122.441671308196) | ||||
| 78166 | 78166 | 111586 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | ||||
| 91819 | 91819 | 122638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 104660 | 104660 | 113092 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 598x ARBOR ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6000747.0 | 2096921.0 | 37.7377875715629 | -122.439921844785 | (37.7377875715629, -122.439921844785) | ||||
| 109835 | 109835 | 205875 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 145 Ridgewood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5996774.44348 | 2094614.15423 | 37.7312265910382 | -122.453490310026 | (37.7312265910382, -122.453490310026) | |||
| 135027 | 135027 | 223758 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5745 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 10ft | 6000740.67954 | 2096967.1117599998 | 37.737913823852104 | -122.439947002964 | (37.7379138238521, -122.439947002964) | |||
| 148117 | 148117 | 223791 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 69 Levant St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 3ft | 6000368.06545 | 2106346.5780599997 | 37.7636463558292 | -122.441908320012 | (37.7636463558292, -122.441908320012) | |||
| 153876 | 153876 | 184003 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1600 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 0ft | 5984924.5288 | 2103681.69 | 37.7554371938568 | -122.49512537658998 | (37.7554371938568, -122.49512537659) | |||
| 154407 | 154407 | 186853 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2700 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985216.0775 | 2096268.8219 | 37.7351005317957 | -122.493570948779 | (37.7351005317957, -122.493570948779) | |||
| 163766 | 163766 | 185074 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984997.7254 | 2096135.7209 | 37.7347222961152 | -122.49431605154301 | (37.7347222961152, -122.494316051543) | |||
| 166548 | 166548 | 206841 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 246 Thrift St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5994549.17298 | 2089660.24802 | 37.7174965486989 | -122.46082452325199 | (37.7174965486989, -122.460824523252) | ||||
| 166696 | 166696 | 223775 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 615 Sanchez St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 3ft | 6003692.3051 | 2104663.83541 | 37.7592148124283 | -122.43029075463998 | (37.7592148124283, -122.43029075464) | |||
| 169563 | 169563 | 223779 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 731 Noe St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6003094.682440001 | 2103994.83983 | 37.7573440418231 | -122.43230984055201 | (37.7573440418231, -122.432309840552) | |||
| 171960 | 171960 | 205890 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Stanford Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5997823.46765 | 2095740.1408099998 | 37.7343783595712 | -122.449944783251 | (37.7343783595712, -122.449944783251) | |||
| 174210 | 174210 | 205916 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 506 Congo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 6000130.425 | 2095272.3934400002 | 37.73322576685489 | -122.44193534195401 | (37.7332257668549, -122.441935341954) | |||
| 174648 | 174648 | 223764 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 126 Bradford St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6009530.67949 | 2097860.55808 | 37.7408634922583 | -122.40961857835899 | (37.7408634922583, -122.409618578359) | |||
| 175401 | 175401 | 185622 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5985035.4121 | 2100280.3783 | 37.7461046152286 | -122.494491190588 | (37.7461046152286, -122.494491190588) |
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");