Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189137 | 189137 | 237759 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 365 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999267.64686 | 2104906.15907 | 37.7596285572291 | -122.44561072185499 | (37.7596285572291, -122.445610721855) | |||
189096 | 189096 | 212933 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1950 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5990982.0324 | 2102119.7924200003 | 37.7515014054748 | -122.47406293496901 | (37.7515014054748, -122.474062934969) | |||
189073 | 189073 | 236556 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2445 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008240.80913 | 2104185.04128 | 37.7581567411682 | -122.414525908043 | (37.7581567411682, -122.414525908043) | |||
189020 | 189020 | 237480 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 508 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002957.32404 | 2103311.17002 | 37.755459058298605 | -122.43273604273399 | (37.7554590582986, -122.432736042734) | |||
189010 | 189010 | 235790 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 19 Woodward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6006490.31542 | 2108352.63521 | 37.7695014774321 | -122.420875764729 | (37.7695014774321, -122.420875764729) | |||
188926 | 188926 | 235831 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1960 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009499.060269999 | 2105650.63341 | 37.7622515325076 | -122.41027779129801 | (37.7622515325076, -122.410277791298) | |||
188916 | 188916 | 235896 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 290 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006689.35782 | 2104440.3941099998 | 37.7587705986009 | -122.419909627549 | (37.7587705986009, -122.419909627549) | |||
188909 | 188909 | 141637 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1537 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000360.391 | 2110943.6425 | 37.7762683045045 | -122.44226489457701 | (37.7762683045045, -122.442264894577) | |||
188894 | 188894 | 236811 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1236 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996773.9051 | 2107149.84009 | 37.765646446248496 | -122.454397355451 | (37.7656464462485, -122.454397355451) | |||
188892 | 188892 | 122076 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 363 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5990564.43068 | 2112959.17169 | 37.7812392167443 | -122.47629871950399 | (37.7812392167443, -122.476298719504) | |||
188864 | 188864 | 178831 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 399 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003310.24269 | 2091435.5476900002 | 37.7228713361369 | -122.43066815423201 | (37.7228713361369, -122.430668154232) | |||
188860 | 188860 | 235832 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1960 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009500.047259999 | 2105637.60116 | 37.7622158042445 | -122.41027345747601 | (37.7622158042445, -122.410273457476) | |||
188834 | 188834 | 42140 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 646 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | 4 | Permit Number 45847 | 5991316.63664 | 2111003.25845 | 37.7759124087321 | -122.47355376984699 | (37.7759124087321, -122.473553769847) | |
188786 | 188786 | 235930 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 701 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010159.37177 | 2104922.45933 | 37.760289122755 | -122.40794266023799 | (37.760289122755, -122.407942660238) | |||
188773 | 188773 | 237852 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 204 Addison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002664.59723 | 2097398.56275 | 37.7392078214825 | -122.433325904463 | (37.7392078214825, -122.433325904463) | |||
188613 | 188613 | 234930 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005817.15804 | 2108261.8712400002 | 37.7692142951364 | -122.42319773960699 | (37.7692142951364, -122.423197739607) | |||
188580 | 188580 | 212727 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1275 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 5992975.53418 | 2106772.36033 | 37.764391419843705 | -122.46750752205 | (37.7643914198437, -122.46750752205) | |||
188570 | 188570 | 236339 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 63 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005549.573030001 | 2099312.558 | 37.74462646613429 | -122.42348697956001 | (37.7446264661343, -122.42348697956) | |||
188569 | 188569 | 237546 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 73 Pond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003190.52282 | 2106122.06518 | 37.763190325802604 | -122.43213029447399 | (37.7631903258026, -122.432130294474) | |||
188544 | 188544 | 212503 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 65 Sotelo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993861.6339300005 | 2101357.5005200002 | 37.7495747312094 | -122.464049667463 | (37.7495747312094, -122.464049667463) | |||
188524 | 188524 | 123164 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 567 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5992805.53108 | 2111610.19032 | 37.7776649910865 | -122.46844751130399 | (37.7776649910865, -122.468447511304) | ||||
188501 | 188501 | 235886 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1227 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010323.242869999 | 2102045.6213 | 37.7523991411094 | -122.40717311125299 | (37.7523991411094, -122.407173111253) | |||
188428 | 188428 | 38099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1261 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 5 | Permit Number 46959 | 5987676.3129 | 2106697.6607 | 37.7638789444346 | -122.485830340707 | (37.7638789444346, -122.485830340707) | |
188387 | 188387 | 236380 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 477 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6003467.60557 | 2100078.3840099997 | 37.7466115145144 | -122.43074064856 | (37.7466115145144, -122.43074064856) | |||
188386 | 188386 | 237565 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 77 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003801.99414 | 2105069.29428 | 37.760334318193294 | -122.42994031940799 | (37.7603343181933, -122.429940319408) | |||
188361 | 188361 | 72888 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2506 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 3 | 5989566.1304 | 2098258.2718 | 37.7408165618747 | -122.47867686749201 | (37.7408165618747, -122.478676867492) | ||
188360 | 188360 | 236539 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 148 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6007318.636419999 | 2096745.15962 | 37.737676652866 | -122.417188000226 | (37.737676652866, -122.417188000226) | |||
188350 | 188350 | 236278 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 342 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007174.74374 | 2105310.6862 | 37.7611875526839 | -122.41829264019199 | (37.7611875526839, -122.418292640192) | |||
188321 | 188321 | 181941 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2338 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985894.7639 | 2098931.5489 | 37.7424513496728 | -122.49142044264 | (37.7424513496728, -122.49142044264) | |||
188284 | 188284 | 38434 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2624 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1998 12:00:00 AM | 5 | Permit Number 40461 | 6004032.02879 | 2117927.41778 | 37.7956525718497 | -122.43006200398199 | (37.7956525718497, -122.430062003982) | ||
188258 | 188258 | 235755 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2 Duncan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006248.463880001 | 2099982.91089 | 37.7465065258611 | -122.421117938644 | (37.7465065258611, -122.421117938644) | |||
188221 | 188221 | 236362 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1316 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003863.53295 | 2100588.48988 | 37.7480345702415 | -122.429407944142 | (37.7480345702415, -122.429407944142) | |||
188219 | 188219 | 237455 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005396.93745 | 2096449.8539900002 | 37.7367575115422 | -122.423811249886 | (37.7367575115422, -122.423811249886) | |||
188218 | 188218 | 196236 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 457 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010494.60827 | 2112515.413 | 37.7811563899075 | -122.407318509161 | (37.7811563899075, -122.407318509161) | |||
188193 | 188193 | 135762 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2487 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6001732.40168 | 2117306.51799 | 37.793817234538004 | -122.43797461165899 | (37.793817234538, -122.437974611659) | |||
188163 | 188163 | 135837 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2333 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007565.4054 | 2120114.29452 | 37.801856667323705 | -122.417990966211 | (37.8018566673237, -122.417990966211) | |||
188161 | 188161 | 108485 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 41 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009911.00607 | 2111023.57735 | 37.7770274800675 | -122.40923218641599 | (37.7770274800675, -122.409232186416) | |||
188144 | 188144 | 212370 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 257 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992383.26559 | 2097580.3945299997 | 37.739118448658296 | -122.468887038901 | (37.7391184486583, -122.468887038901) | |||
188141 | 188141 | 217893 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 240 Edgewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5996593.03691 | 2105698.23577 | 37.761650337504 | -122.454918040462 | (37.761650337504, -122.454918040462) | |||
188118 | 188118 | 212997 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1627 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993679.49927 | 2104412.68352 | 37.757952979968294 | -122.464901340744 | (37.7579529799683, -122.464901340744) | |||
188103 | 188103 | 62253 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 415 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | 3 | Permit Number 22379 | 6000969.7318400005 | 2092330.5175599998 | 37.7251958434923 | -122.43882289446998 | (37.7251958434923, -122.43882289447) | |
188092 | 188092 | 217929 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1882 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990657.386080001 | 2102600.85975 | 37.752803479004605 | -122.475220706895 | (37.7528034790046, -122.475220706895) | |||
188082 | 188082 | 196233 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 615 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013115.78594 | 2111800.11069 | 37.7793386873661 | -122.39820027663201 | (37.7793386873661, -122.398200276632) | |||
188065 | 188065 | 237711 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 30 Levant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000235.45842 | 2106712.3169400003 | 37.7646430267787 | -122.442393223693 | (37.7646430267787, -122.442393223693) | |||
188042 | 188042 | 178718 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004594.54509 | 2090439.6067599999 | 37.72020937703 | -122.42615771873001 | (37.72020937703, -122.42615771873) | |||
188024 | 188024 | 236368 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4086 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6003364.22363 | 2100408.52432 | 37.747512145082204 | -122.431121692231 | (37.7475121450822, -122.431121692231) | |||
188020 | 188020 | 237658 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4183 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002533.666540001 | 2104116.37072 | 37.7576459100511 | -122.434258740642 | (37.7576459100511, -122.434258740642) | |||
188000 | 188000 | 196238 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 455 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010553.687390001 | 2112573.85543 | 37.781320165440704 | -122.40711824453501 | (37.7813201654407, -122.407118244535) | |||
187999 | 187999 | 140339 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1300x WEBSTER ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6003689.95 | 2113371.7397 | 37.7831244557567 | -122.430920367043 | (37.7831244557567, -122.430920367043) | |||
187989 | 187989 | 236401 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 620 Belvedere St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5998688.86487 | 2105557.55466 | 37.7613840662398 | -122.44765932353701 | (37.7613840662398, -122.447659323537) | |||
187950 | 187950 | 45592 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1767 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 2 | Permit Number 44328 | 5985625.0375 | 2103206.7223 | 37.754174049116294 | -122.492667858454 | (37.7541740491163, -122.492667858454) | |
187904 | 187904 | 121910 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 336 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5990605.42659 | 2113132.9514200003 | 37.78171874503129 | -122.47616959207 | (37.7817187450313, -122.47616959207) | |||
187881 | 187881 | 237854 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 204 Addison St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002598.25112 | 2097625.55901 | 37.7398273365707 | -122.43357151742399 | (37.7398273365707, -122.433571517424) | |||
187880 | 187880 | 83324 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 354 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 4x3 | 5987173.082 | 2113552.1603 | 37.782670140120295 | -122.48807454413901 | (37.7826701401203, -122.488074544139) | ||
187845 | 187845 | 236515 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 45 Nebraska St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009310.01525 | 2097758.58604 | 37.7405711316611 | -122.41037435781 | (37.7405711316611, -122.41037435781) | |||
187838 | 187838 | 237697 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3506 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003478.77058 | 2106571.27755 | 37.7644400929538 | -122.431165407384 | (37.7644400929538, -122.431165407384) | |||
187834 | 187834 | 236684 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 835 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001297.4593400005 | 2101515.3491700003 | 37.750433888624 | -122.43834770079599 | (37.750433888624, -122.438347700796) | |||
187753 | 187753 | 246786 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 175 Brewster St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6010089.416540001 | 2098717.54188 | 37.74324787739471 | -122.407747077462 | (37.7432478773947, -122.407747077462) | ||||
187699 | 187699 | 62284 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 40 Loraine Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | 11 | Permit Number 22422 | 5996159.215890001 | 2112395.0855799997 | 37.780013249453795 | -122.456902830387 | (37.7800132494538, -122.456902830387) | |
187669 | 187669 | 31093 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 105 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34826 | 6007741.23443 | 2107311.13584 | 37.7667121941381 | -122.416475089665 | (37.7667121941381, -122.416475089665) | |
187666 | 187666 | 217868 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Edgewood Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5996613.6648 | 2106198.4514200003 | 37.763024985445796 | -122.454882840992 | (37.7630249854458, -122.454882840992) | |||
187644 | 187644 | 202304 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 152 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6012919.13392 | 2092996.02429 | 37.727695784333704 | -122.397561393738 | (37.7276957843337, -122.397561393738) | |||
187621 | 187621 | 140893 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 650 SPRUCE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997213.9579 | 2113398.4041 | 37.7828286078195 | -122.45332647925 | (37.7828286078195, -122.45332647925) | |||
187618 | 187618 | 213040 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 125 Edgewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996574.82053 | 2106215.99402 | 37.7630709246162 | -122.455018456958 | (37.7630709246162, -122.455018456958) | |||
187605 | 187605 | 135756 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2714 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6000655.98708 | 2117730.78342 | 37.7949208843442 | -122.44172955819401 | (37.7949208843442, -122.441729558194) | |||
187591 | 187591 | 84413 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 738 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 7 | 3x3 | Permit Number 51575 | 5994139.251180001 | 2110527.76109 | 37.7747698770868 | -122.463755171286 | (37.7747698770868, -122.463755171286) | |
187589 | 187589 | 201974 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 17 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013727.10603 | 2092236.0738 | 37.725654070573704 | -122.39471500442 | (37.7256540705737, -122.39471500442) | |||
187576 | 187576 | 31742 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2683 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 0 | Permit Number 35232 | 5990177.71472403 | 2097127.35673415 | 37.7377468512318 | -122.47647966560899 | (37.7377468512318, -122.476479665609) | |
187565 | 187565 | 237676 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 172 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001697.972580001 | 2107814.0525700003 | 37.7677513724546 | -122.43741368471399 | (37.7677513724546, -122.437413684714) | |||
187506 | 187506 | 212614 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 511 Mount Vernon Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997779.607340001 | 2090076.68387 | 37.7188253303138 | -122.449688439586 | (37.7188253303138, -122.449688439586) | |||
187487 | 187487 | 212586 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 201 Judson Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5998722.40615 | 2093468.5206900002 | 37.728192421422 | -122.44667348310301 | (37.728192421422, -122.446673483103) | |||
187486 | 187486 | 235749 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 27 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006297.05558 | 2099936.31823 | 37.7463813321394 | -122.420946606108 | (37.7463813321394, -122.420946606108) | |||
187449 | 187449 | 196192 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2198 Revere Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6011951.07495 | 2096769.0187900001 | 37.7380016885201 | -122.40117301982 | (37.7380016885201, -122.40117301982) | ||||
187430 | 187430 | 218414 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5994295.2079300005 | 2100668.92449 | 37.747709054341 | -122.46250042605101 | (37.747709054341, -122.462500426051) | |||
187392 | 187392 | 236360 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1270 Sanchez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003842.96435 | 2100880.5057599996 | 37.748835213281495 | -122.429499891731 | (37.7488352132815, -122.429499891731) | |||
187385 | 187385 | 212883 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1700 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5990926.90707 | 2103772.3258 | 37.7560356343581 | -122.47437414267999 | (37.7560356343581, -122.47437414268) | |||
187373 | 187373 | 138826 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 640 IVY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004239.9171 | 2111001.0303 | 37.7766462209107 | -122.428848637655 | (37.7766462209107, -122.428848637655) | |||
187363 | 187363 | 212887 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1989 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5990945.3142 | 2101894.89239 | 37.7508817617934 | -122.474173501224 | (37.7508817617934, -122.474173501224) | |||
187344 | 187344 | 31692 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 61 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 7 | Permit Number 35553 | 5998816.4378 | 2107906.1796 | 37.767840090069896 | -122.44738715512501 | (37.7678400900699, -122.447387155125) | |
187324 | 187324 | 60799 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 275 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | 5 | Permit Number 20474 | 5998494.132 | 2112280.5701 | 37.7798326205261 | -122.448817090257 | (37.7798326205261, -122.448817090257) | |
187306 | 187306 | 140811 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 92 Commonwealth Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5996557.5888 | 2113916.3587 | 37.784213129993795 | -122.455634678211 | (37.7842131299938, -122.455634678211) | |||
187302 | 187302 | 212889 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2047 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5990962.11857 | 2101474.7356 | 37.749729094418605 | -122.474084738123 | (37.7497290944186, -122.474084738123) | |||
187286 | 187286 | 212374 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 175 Garcia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5994630.54538 | 2099448.58618 | 37.744377617447206 | -122.46125240808901 | (37.7443776174472, -122.461252408089) | |||
187179 | 187179 | 212465 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 181 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993680.85125 | 2094035.61163 | 37.729460235302604 | -122.464143344438 | (37.7294602353026, -122.464143344438) | |||
187154 | 187154 | 237627 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 296 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002062.172069999 | 2104172.82528 | 37.7577741479695 | -122.43589339786999 | (37.7577741479695, -122.43589339787) | |||
187137 | 187137 | 87178 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1850 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50167 | 5987398.7116 | 2100339.5275 | 37.7464050543011 | -122.486323651924 | (37.7464050543011, -122.486323651924) |
187132 | 187132 | 95604 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 345 08th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767215 | 5993376.04734 | 2113151.0888900002 | 37.7819288190409 | -122.466585947825 | (37.7819288190409, -122.466585947825) | |
187106 | 187106 | 236898 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1521 Piedmont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999664.45541 | 2107169.95253 | 37.7658670175704 | -122.444401055478 | (37.7658670175704, -122.444401055478) | |||
187086 | 187086 | 249631 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2498 Golden Gate Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997554.63334 | 2111312.07091 | 37.777119603925904 | -122.451997320318 | (37.7771196039259, -122.451997320318) | |||
187031 | 187031 | 48598 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1444 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | 8 | Permit Number 45908 | 6006635.91115 | 2118390.9929400003 | 37.79707255999389 | -122.42108502346501 | (37.7970725599939, -122.421085023465) | |
187013 | 187013 | 218061 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5991867.74451 | 2095942.81987 | 37.734592284912 | -122.47055022353099 | (37.734592284912, -122.470550223531) | |||
187012 | 187012 | 236408 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 525 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998573.85055 | 2106134.51224 | 37.7629616731566 | -122.448098652239 | (37.7629616731566, -122.448098652239) | |||
187010 | 187010 | 182605 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1887 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5989991.864 | 2102534.498 | 37.752582670687296 | -122.47751732906099 | (37.7525826706873, -122.477517329061) | |||
186992 | 186992 | 178798 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 58 Valmar Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005344.4697199995 | 2092746.60269 | 37.726586243056396 | -122.423729423281 | (37.7265862430564, -122.423729423281) | |||
186970 | 186970 | 43222 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 640 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 5 | Permit Number 43011 | 6007646.36593 | 2094163.38617 | 37.7306060983812 | -122.415872111321 | (37.7306060983812, -122.415872111321) | |
186955 | 186955 | 95607 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 345 08th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5993380.81309 | 2113072.51492 | 37.7817133512738 | -122.46656374773899 | (37.7817133512738, -122.466563747739) | |||
186951 | 186951 | 236553 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1800 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007973.56805 | 2107893.50809 | 37.7683243152315 | -122.415712724475 | (37.7683243152315, -122.415712724475) | |||
186947 | 186947 | 212672 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 609 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992414.13264 | 2090471.45088 | 37.719600836394704 | -122.468263292533 | (37.7196008363947, -122.468263292533) | |||
186939 | 186939 | 49811 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 820 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46603 | 6015361.637130001 | 2103953.4257900002 | 37.7579182481496 | -122.389882619693 | (37.7579182481496, -122.389882619693) | |
186928 | 186928 | 135794 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 210 Larch St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006462.882540001 | 2113039.98936 | 37.7823702759156 | -122.42130356232799 | (37.7823702759156, -122.421303562328) |
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");