Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4145 | 4145 | 113403 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2052 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006463.2485 | 2117908.2188 | 37.7957372487994 | -122.42164817262501 | (37.7957372487994, -122.421648172625) | |||
| 4166 | 4166 | 143128 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2052 POLK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6006467.2287 | 2117887.8753 | 37.795681615093 | -122.421632954779 | (37.795681615093, -122.421632954779) | |||
| 10592 | 10592 | 26788 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 78 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1999 12:00:00 AM | 4 | 3X3 | 6010596.3656 | 2087261.1203 | 37.711819305554 | -122.40518761518801 | (37.711819305554, -122.405187615188) | ||
| 11181 | 11181 | 95011 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6010324.7589 | 2087356.7063 | 37.7120665771229 | -122.406133097694 | (37.7120665771229, -122.406133097694) | |||
| 12918 | 12918 | 26791 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 110 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1999 12:00:00 AM | 4 | 3x3 | 6010397.1725 | 2087366.7328 | 37.712098157972605 | -122.40588352001801 | (37.7120981579726, -122.405883520018) | ||
| 24195 | 24195 | 244515 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 426 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003699.3803 | 2109847.5959 | 37.7734485650794 | -122.430636186348 | (37.7734485650794, -122.430636186348) | |||
| 27817 | 27817 | 141769 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1360 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003743.0385 | 2113357.1314 | 37.7830873528992 | -122.430735659623 | (37.7830873528992, -122.430735659623) | |||
| 28134 | 28134 | 218416 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 206 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5994263.50524 | 2100633.1916900002 | 37.747609115379 | -122.46260745978901 | (37.747609115379, -122.462607459789) | |||
| 30204 | 30204 | 74333 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1118 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2002 12:00:00 AM | 4 | 6015132.5367 | 2090213.511 | 37.720178552846 | -122.389715298726 | (37.720178552846, -122.389715298726) | ||
| 34860 | 34860 | 237993 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 480 Jersey St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6001987.72906 | 2101502.95079 | 37.7504390831161 | -122.43595981461701 | (37.7504390831161, -122.435959814617) | |||
| 35596 | 35596 | 79919 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1343 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2001 12:00:00 AM | 4 | 5988008.149 | 2106155.0675 | 37.762408463106496 | -122.484642830378 | (37.7624084631065, -122.484642830378) | ||
| 35667 | 35667 | 138101 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1750 Webster St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003541.5257 | 2114778.8993 | 37.7869797508763 | -122.43153434535401 | (37.7869797508763, -122.431534345354) | |||
| 35955 | 35955 | 214400 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 225 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992660.56821 | 2095241.10617 | 37.7327113663366 | -122.467758171225 | (37.7327113663366, -122.467758171225) | |||
| 36105 | 36105 | 139499 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 620 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000599.1066 | 2111158.1364 | 37.7768708526781 | -122.441454508958 | (37.7768708526781, -122.441454508958) | |||
| 37179 | 37179 | 138872 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 OCTAVIA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005567.8228 | 2110765.4538 | 37.7760744547885 | -122.424238259715 | (37.7760744547885, -122.424238259715) | |||
| 37372 | 37372 | 101729 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 90 Rotteck St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6003352.201090001 | 2094564.6464200001 | 37.731465517513 | -122.43074630169501 | (37.731465517513, -122.430746301695) | |||
| 40942 | 40942 | 178925 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1699 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001853.21575 | 2094253.6838200002 | 37.73052664507 | -122.435906329212 | (37.73052664507, -122.435906329212) | |||
| 41303 | 41303 | 118024 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 455 37th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5984366.776430001 | 2112718.2833 | 37.7802164441611 | -122.497721424423 | (37.7802164441611, -122.497721424423) | |||
| 42943 | 42943 | 178899 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012660.08669 | 2087284.72268 | 37.7119992718279 | -122.39805643095801 | (37.7119992718279, -122.398056430958) | |||
| 46837 | 46837 | 178884 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003708.27118 | 2090552.3037299998 | 37.720468684870504 | -122.42922930371599 | (37.7204686848705, -122.429229303716) | |||
| 48637 | 48637 | 140842 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 133 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5996517.655 | 2113507.2067 | 37.783087415663 | -122.455743248453 | (37.783087415663, -122.455743248453) | |||
| 49913 | 49913 | 199985 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1032 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018147.7753 | 2092169.4169 | 37.725715836336896 | -122.379428312297 | (37.7257158363369, -122.379428312297) | |||
| 53491 | 53491 | 142243 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 530 LINDEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004841.3136 | 2110737.0993 | 37.7759555514889 | -122.426749430003 | (37.7759555514889, -122.426749430003) | |||
| 54063 | 54063 | 237992 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1217 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001369.41512 | 2100163.22575 | 37.7467253722857 | -122.438002031971 | (37.7467253722857, -122.438002031971) | |||
| 57293 | 57293 | 139421 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1655 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004270.6386 | 2114261.9481 | 37.7856016305795 | -122.428974908892 | (37.7856016305795, -122.428974908892) | |||
| 61894 | 61894 | 178932 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000025.30894 | 2091607.27425 | 37.7231562071699 | -122.44203576925501 | (37.7231562071699, -122.442035769255) | |||
| 62057 | 62057 | 214444 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 26 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992635.01675 | 2098889.7212400003 | 37.7427280701488 | -122.468111823327 | (37.7427280701488, -122.468111823327) | |||
| 62295 | 62295 | 178901 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 811 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008890.15805 | 2090268.5562 | 37.719981566167995 | -122.411297082012 | (37.719981566168, -122.411297082012) | |||
| 67122 | 67122 | 244365 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 301 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005511.8056 | 2110439.7613 | 37.775177019128606 | -122.424408867351 | (37.7751770191286, -122.424408867351) | |||
| 69845 | 69845 | 214425 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 41 Lagunitas Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991075.83745 | 2095563.72513 | 37.7335055639152 | -122.473260445626 | (37.7335055639152, -122.473260445626) | |||
| 70065 | 70065 | 245026 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1255 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000539.9879 | 2109236.7846 | 37.771591937743295 | -122.441521109042 | (37.7715919377433, -122.441521109042) | |||
| 70581 | 70581 | 106985 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1737-1795 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2010 12:00:00 AM | 4 | 6003795.2547 | 2114190.67 | 37.7853789990287 | -122.430614510729 | (37.7853789990287, -122.430614510729) | |||
| 70819 | 70819 | 138871 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005570.116 | 2110750.5481 | 37.7760336568414 | -122.42422926657 | (37.7760336568414, -122.42422926657) | |||
| 70905 | 70905 | 142255 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 521 LINDEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004876.8784 | 2110720.6117 | 37.775912291272704 | -122.426625227687 | (37.7759122912727, -122.426625227687) | |||
| 72594 | 72594 | 244969 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 215 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005489.602999999 | 2109760.4598 | 37.7733105679298 | -122.424437343055 | (37.7733105679298, -122.424437343055) | |||
| 72821 | 72821 | 178885 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003721.71366 | 2090575.2726099999 | 37.720532513349106 | -122.42918447430401 | (37.7205325133491, -122.429184474304) | |||
| 73431 | 73431 | 138925 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 431 OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005461.4768 | 2110789.2454 | 37.7761337753876 | -122.424607831994 | (37.7761337753876, -122.424607831994) | |||
| 78614 | 78614 | 196378 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012410.6733800005 | 2112360.21924 | 37.78083731581879 | -122.400678929615 | (37.7808373158188, -122.400678929615) | |||
| 105785 | 105785 | 182711 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1707 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988401.4839 | 2103680.4418 | 37.755636709970496 | -122.48310105766899 | (37.7556367099705, -122.483101057669) | |||
| 119846 | 119846 | 238027 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Alma St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997671.60097 | 2106142.0382 | 37.7629307194099 | -122.45121975030199 | (37.7629307194099, -122.451219750302) | |||
| 127102 | 127102 | 27759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1099X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/25/2005 12:00:00 AM | 4 | 3x3 | 6015711.817910201 | 2101113.2850563 | 37.750139234821 | -122.38847329943701 | (37.750139234821, -122.388473299437) | ||
| 131720 | 131720 | 238018 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Ashbury Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5999581.71277 | 2106854.10087 | 37.7649950466081 | -122.444664539759 | (37.7649950466081, -122.444664539759) | |||
| 132416 | 132416 | 139393 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 476 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005043.2512 | 2111112.0094 | 37.776996378171894 | -122.426077570324 | (37.7769963781719, -122.426077570324) | |||
| 132598 | 132598 | 71210 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2263 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 4 | 5988533.227999999 | 2099925.3582 | 37.7453339163785 | -122.482370330567 | (37.7453339163785, -122.482370330567) | ||
| 133712 | 133712 | 214426 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 41 Lagunitas Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991077.3957 | 2095586.31529 | 37.7335676810093 | -122.473256705357 | (37.7335676810093, -122.473256705357) | |||
| 136058 | 136058 | 178931 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000005.37826 | 2091604.23935 | 37.7231467382161 | -122.44210444775801 | (37.7231467382161, -122.442104447758) | |||
| 146623 | 146623 | 178923 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 88 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6000952.168380001 | 2093553.63725 | 37.7285532510089 | -122.43897122505899 | (37.7285532510089, -122.438971225059) | |||
| 149154 | 149154 | 214396 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 195 Granville Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 5994309.483109999 | 2098688.20376 | 37.742271315265 | -122.462307427938 | (37.742271315265, -122.462307427938) | |||
| 151145 | 151145 | 139389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 432 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005549.1907 | 2110899.3178 | 37.7764409607239 | -122.424312236277 | (37.7764409607239, -122.424312236277) | |||
| 151489 | 151489 | 238026 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Alma St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997640.69708 | 2106136.91348 | 37.7629148787356 | -122.45132626601801 | (37.7629148787356, -122.451326266018) | |||
| 152260 | 152260 | 214387 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2466 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992373.19537 | 2098669.75746 | 37.742108981343605 | -122.469001114305 | (37.7421089813436, -122.469001114305) | |||
| 155686 | 155686 | 139394 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 486 Ivy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005015.0309 | 2111107.9249 | 37.776983568125296 | -122.426174902271 | (37.7769835681253, -122.426174902271) | |||
| 160352 | 160352 | 196417 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 74 Langton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010044.800559999 | 2110849.16971 | 37.776556092323 | -122.40875704040701 | (37.776556092323, -122.408757040407) | |||
| 160863 | 160863 | 138926 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 431 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005464.9166 | 2110768.0336 | 37.776075727206205 | -122.424594423557 | (37.7760757272062, -122.424594423557) | |||
| 161288 | 161288 | 178948 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 27 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6005299.6177 | 2093092.1987599998 | 37.7275326418944 | -122.423909039465 | (37.7275326418944, -122.423909039465) | ||||
| 162534 | 162534 | 70939 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1925 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1995 12:00:00 AM | 4 | 5989075.8648 | 2102218.2021 | 37.7516610101851 | -122.480661823031 | (37.7516610101851, -122.480661823031) | ||
| 163081 | 163081 | 183514 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2547 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5987976.8381 | 2097955.1738 | 37.739891928689 | -122.484149754415 | (37.739891928689, -122.484149754415) | |||
| 163157 | 163157 | 178893 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 377 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002334.05893 | 2091412.9256900002 | 37.7227538684718 | -122.43404099680201 | (37.7227538684718, -122.434040996802) | |||
| 164030 | 164030 | 184601 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1763 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983763.5526 | 2103165.7132 | 37.753952428223 | -122.49910220128099 | (37.753952428223, -122.499102201281) | |||
| 165001 | 165001 | 139978 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1002 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001945.5177 | 2111990.8232 | 37.7792338137079 | -122.436856496835 | (37.7792338137079, -122.436856496835) | |||
| 165452 | 165452 | 214381 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1862 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5990969.19969 | 2102754.50273 | 37.75324341026371 | -122.47415361899401 | (37.7532434102637, -122.474153618994) | |||
| 165895 | 165895 | 238010 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1231 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997428.72694 | 2105545.13928 | 37.76127787699421 | -122.452016696208 | (37.7612778769942, -122.452016696208) | |||
| 167172 | 167172 | 183033 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2471 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5989508.364 | 2098550.6846 | 37.7416160972257 | -122.478897981954 | (37.7416160972257, -122.478897981954) | |||
| 173300 | 173300 | 214475 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 209 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998738.950669999 | 2093576.3454200001 | 37.72848942794221 | -122.446624042887 | (37.7284894279422, -122.446624042887) | |||
| 174006 | 174006 | 214388 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 209 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992612.38787 | 2097825.75729 | 37.73980538771 | -122.468112688465 | (37.73980538771, -122.468112688465) | |||
| 175247 | 175247 | 238016 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Ashbury Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5999571.744519999 | 2106835.86862 | 37.7649444165749 | -122.44469770674 | (37.7649444165749, -122.44469770674) | |||
| 176135 | 176135 | 214422 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 529 Bright St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993759.81051 | 2090686.52668 | 37.7202690128731 | -122.463627407878 | (37.7202690128731, -122.463627407878) | |||
| 178351 | 178351 | 71165 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2119 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 4 | 5988190.2092 | 2100857.5067 | 37.747873389373396 | -122.48362474712499 | (37.7478733893734, -122.483624747125) | ||
| 178433 | 178433 | 137654 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 915 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999488.4062 | 2111737.8529 | 37.77839926671621 | -122.44533843675801 | (37.7783992667162, -122.445338436758) | |||
| 180512 | 180512 | 139392 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 466 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005058.4753 | 2111113.4947 | 37.7770013168736 | -122.426025011181 | (37.7770013168736, -122.426025011181) | |||
| 181182 | 181182 | 138874 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 OCTAVIA ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005562.0898 | 2110802.7178 | 37.7761764489655 | -122.424260742604 | (37.7761764489655, -122.424260742604) | |||
| 181205 | 181205 | 139523 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 705 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999605.1618 | 2110921.5795 | 37.7761646531155 | -122.444875844748 | (37.7761646531155, -122.444875844748) | |||
| 182838 | 182838 | 238031 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3896 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002524.05826 | 2102994.76083 | 37.75456569247171 | -122.43421178796001 | (37.7545656924717, -122.43421178796) | |||
| 183681 | 183681 | 250308 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 10 Redfield Aly | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.41476992380801 | (37.8002391853351, -122.414769923808) | |||
| 183961 | 183961 | 139417 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1701 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004046.3972 | 2114236.4215 | 37.78551884556639 | -122.429748897639 | (37.7855188455664, -122.429748897639) | |||
| 184229 | 184229 | 218417 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 206 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5994252.951119999 | 2100616.68956 | 37.7475631968785 | -122.462642758156 | (37.7475631968785, -122.462642758156) | |||
| 184862 | 184862 | 196379 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012397.66121 | 2112347.77768 | 37.7808024284316 | -122.400723071038 | (37.7808024284316, -122.400723071038) | |||
| 67287 | 67287 | 63267 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2679 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1986 12:00:00 AM | 4 | Permit Number 23823 | 5988937.7362 | 2097128.8354 | 37.7376789174614 | -122.480766928043 | (37.7376789174614, -122.480766928043) | ||
| 158113 | 158113 | 65196 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 326 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 4 | Permit Number 27181 | 6003265.18452 | 2091962.93655 | 37.7243168758021 | -122.43086153005501 | (37.7243168758021, -122.430861530055) | |
| 130092 | 130092 | 56543 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1645 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/1990 12:00:00 AM | 4 | Permit Number 29153 | 5989817.2724 | 2101726.9901 | 37.7503553345464 | -122.47806205844499 | (37.7503553345464, -122.478062058445) | ||
| 56362 | 56362 | 69494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 368 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 4 | Permit Number 33617 | 5999712.35805 | 2091715.6264799999 | 37.7234358783342 | -122.443125353647 | (37.7234358783342, -122.443125353647) | |
| 112282 | 112282 | 33708 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 4 | 3x3 | Permit Number 37775 | 6004167.63204268 | 2108922.73514509 | 37.770935639433105 | -122.42895048520799 | (37.7709356394331, -122.428950485208) | |
| 44585 | 44585 | 37353 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 131 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 4 | Permit Number 39859 | 6000725.3710199995 | 2087720.25032 | 37.7125231844795 | -122.43933731388 | (37.7125231844795, -122.43933731388) | |
| 76635 | 76635 | 38116 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1346 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 4 | Permit Number 40280 | 5987121.6044 | 2106101.731 | 37.7622103462776 | -122.487705101187 | (37.7622103462776, -122.487705101187) | |
| 98165 | 98165 | 40257 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3502 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | 4 | Permit Number 41417 | 6006132.27744777 | 2102027.63127436 | 37.7521143101544 | -122.421664902947 | (37.7521143101544, -122.421664902947) | |
| 35382 | 35382 | 40325 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 655 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1999 12:00:00 AM | 4 | Permit Number 41463 | 6013209.4791 | 2113639.3788 | 37.78439411283129 | -122.39800521351201 | (37.7843941128313, -122.398005213512) | ||
| 132335 | 132335 | 43320 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 283 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 4 | Permit Number 43083 | 6004355.20098 | 2091606.0340900002 | 37.7233985996382 | -122.427068088028 | (37.7233985996382, -122.427068088028) | |
| 26064 | 26064 | 43329 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 4 | Permit Number 43087 | 6003232.20541 | 2091824.6572900002 | 37.7239353231315 | -122.43096566975402 | (37.7239353231315, -122.430965669754) | |
| 34748 | 34748 | 43826 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2657 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43454 | 5985520.0574 | 2097206.122 | 37.7376918862353 | -122.49258900314899 | (37.7376918862353, -122.492589003149) | |
| 185028 | 185028 | 43836 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2690 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43458 | 5985569.2648 | 2097041.677 | 37.737243241151496 | -122.492406765684 | (37.7372432411515, -122.492406765684) | |
| 39935 | 39935 | 43837 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2707 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43459 | 5985531.9387 | 2096872.5005 | 37.736776545221204 | -122.492523362027 | (37.7367765452212, -122.492523362027) | |
| 70310 | 70310 | 43849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2638 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43471 | 5985246.7805 | 2097245.1976 | 37.73778319502121 | -122.49353671716999 | (37.7377831950212, -122.49353671717) | |
| 76367 | 76367 | 45053 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2275 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 4 | Permit Number 43938 | 5988225.1228 | 2099842.9977 | 37.7450898488188 | -122.483429658025 | (37.7450898488188, -122.483429658025) | |
| 75915 | 75915 | 46075 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 126 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2001 12:00:00 AM | 4 | Permit Number 44456 | 5996572.8178 | 2113519.7283 | 37.7831249622244 | -122.455553314082 | (37.7831249622244, -122.455553314082) | ||
| 88435 | 88435 | 46906 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1449 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | 4 | 5x6 | Permit Number 44962 | 5994565.97066106 | 2105665.83691195 | 37.761444887920206 | -122.46192644019399 | (37.7614448879202, -122.461926440194) |
| 3043 | 3043 | 244994 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 231 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | 4 | Width 0ft | Permit Number 45013 | 6005396.3109 | 2110099.8972 | 37.774237312156295 | -122.4247842062 | (37.7742373121563, -122.4247842062) | |
| 75226 | 75226 | 34636 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1466 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 4 | Permit Number 45216 | 5988080.2573 | 2105318.5059 | 37.760115692139394 | -122.48433207977399 | (37.7601156921394, -122.484332079774) | |
| 185181 | 185181 | 47469 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2907 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 4 | Permit Number 45370 | 5999522.715 | 2114292.4911 | 37.785415601023395 | -122.445403484856 | (37.7854156010234, -122.445403484856) | |
| 163864 | 163864 | 47758 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2517 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2002 12:00:00 AM | 4 | Permit Number 45537 | 5989832.0192 | 2098195.9454 | 37.740660864188 | -122.477752978845 | (37.740660864188, -122.477752978845) | |
| 65110 | 65110 | 49209 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1901 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | 4 | Permit Number 46298 | 6001476.6938 | 2115031.787 | 37.7875568675655 | -122.438696309687 | (37.7875568675655, -122.438696309687) |
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");