Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, SiteOrder, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23580 | 23580 | 212649 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 321 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5992450.10328 | 2090020.5964400002 | 37.7183649772426 | -122.468106177365 | (37.7183649772426, -122.468106177365) | |||
| 23687 | 23687 | 235690 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 63 Laussat St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6004411.60055 | 2109266.67882 | 37.7718938314631 | -122.428131106459 | (37.7718938314631, -122.428131106459) | |||
| 24067 | 24067 | 201949 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 18 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013468.57071 | 2092447.06427 | 37.7262190300648 | -122.395623522912 | (37.7262190300648, -122.395623522912) | |||
| 25220 | 25220 | 235688 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 242 Church St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6004123.15327 | 2107397.4194400003 | 37.766744974426395 | -122.428995570805 | (37.7667449744264, -122.428995570805) | |||
| 25347 | 25347 | 235710 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2800 18th St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6009444.36409 | 2105489.04346 | 37.7618047771799 | -122.41045555487301 | (37.7618047771799, -122.410455554873) | |||
| 25698 | 25698 | 202267 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 28 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6013033.98272 | 2093207.99375 | 37.728284203554395 | -122.397179214247 | (37.7282842035544, -122.397179214247) | |||
| 25917 | 25917 | 235705 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 50 Scott St | 9 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6002413.687999999 | 2108646.89138 | 37.7700788062318 | -122.434997685721 | (37.7700788062318, -122.434997685721) | |||
| 26547 | 26547 | 212674 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 641 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992267.89136 | 2090473.0375 | 37.719596745362395 | -122.46876890666 | (37.7195967453624, -122.46876890666) | |||
| 26563 | 26563 | 246795 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 195 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6010198.18555 | 2098814.08058 | 37.7435190400824 | -122.407377785258 | (37.7435190400824, -122.407377785258) | |||
| 26565 | 26565 | 196129 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 537 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011814.46291 | 2105877.37979 | 37.763003645435205 | -122.402285583717 | (37.7630036454352, -122.402285583717) | |||
| 28254 | 28254 | 235714 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 575 Florida St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009284.05083 | 2105508.94115 | 37.761850423188704 | -122.41101142226499 | (37.7618504231887, -122.411011422265) | |||
| 28821 | 28821 | 235706 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 50 Scott St | 11 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6002406.66247 | 2108692.93634 | 37.7702048354241 | -122.43502528051701 | (37.7702048354241, -122.435025280517) | |||
| 29013 | 29013 | 236797 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 175 Saint Germain Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997604.4379 | 2104110.13447 | 37.7573477775868 | -122.45130549166299 | (37.7573477775868, -122.451305491663) | |||
| 29237 | 29237 | 196145 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 356 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012905.6272599995 | 2105323.15012 | 37.7615427021613 | -122.398472702866 | (37.7615427021613, -122.398472702866) | |||
| 29565 | 29565 | 212676 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 124 Sargent St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993606.85369 | 2089199.82617 | 37.7161780760225 | -122.464048258239 | (37.7161780760225, -122.464048258239) | |||
| 30088 | 30088 | 212617 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 Margaret Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997114.72788 | 2089830.80854 | 37.7181121526199 | -122.45196892242599 | (37.7181121526199, -122.451968922426) | |||
| 30439 | 30439 | 246993 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6004785.89781 | 2101026.3383400002 | 37.7492889788082 | -122.426249608749 | (37.7492889788082, -122.426249608749) | |||
| 30707 | 30707 | 250995 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 453 44th Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5982194.00965 | 2112744.27477 | 37.780160200984604 | -122.505239820464 | (37.7801602009846, -122.505239820464) | |||
| 30783 | 30783 | 202270 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012994.98381 | 2093237.0284400003 | 37.728361755688894 | -122.39731607130301 | (37.7283617556889, -122.397316071303) | |||
| 31006 | 31006 | 202273 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 50 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012938.89237 | 2093280.23143 | 37.7284772592045 | -122.397513012032 | (37.7284772592045, -122.397513012032) | |||
| 31680 | 31680 | 212666 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 772 Head St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993533.344330001 | 2090952.0360299998 | 37.72098498564 | -122.464429488032 | (37.72098498564, -122.464429488032) | |||
| 32448 | 32448 | 212637 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 401 Ralston St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992197.26293 | 2090572.74875 | 37.719866447546394 | -122.469020294145 | (37.7198664475464, -122.469020294145) | |||
| 32713 | 32713 | 196317 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 333 11th St | 6 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6008676.43803 | 2109018.47977 | 37.7714527113022 | -122.413361122339 | (37.7714527113022, -122.413361122339) | |||
| 33705 | 33705 | 202264 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 12 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6013090.69479 | 2093165.6197900001 | 37.728171010371796 | -122.396980187094 | (37.7281710103718, -122.396980187094) | |||
| 33781 | 33781 | 196319 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 83 Lafayette St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6007736.57644 | 2109492.64153 | 37.7727018336483 | -122.416645755806 | (37.7727018336483, -122.416645755806) | |||
| 33949 | 33949 | 196186 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Venus St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012832.08257 | 2093948.98425 | 37.7303075693197 | -122.397929154401 | (37.7303075693197, -122.397929154401) | |||
| 34750 | 34750 | 236795 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 155 Saint Germain Ave | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5997672.865180001 | 2104113.27373 | 37.7573603150384 | -122.451069070676 | (37.7573603150384, -122.451069070676) | |||
| 34926 | 34926 | 235675 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 Pearl St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005643.27449 | 2108641.45468 | 37.7702467258258 | -122.423826188538 | (37.7702467258258, -122.423826188538) | |||
| 34982 | 34982 | 235712 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2800 18th St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6009409.0711 | 2105486.80385 | 37.7617966491233 | -122.410577461607 | (37.7617966491233, -122.410577461607) | |||
| 35000 | 35000 | 235716 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 575 Florida St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6009284.605280001 | 2105547.28061 | 37.7619557256901 | -122.411012212741 | (37.7619557256901, -122.411012212741) | |||
| 35009 | 35009 | 196179 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1998 Carroll Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012048.7693 | 2093556.75708 | 37.7291869385061 | -122.40060964941401 | (37.7291869385061, -122.400609649414) | |||
| 35195 | 35195 | 196310 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 928 Clara St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011726.41935 | 2111671.91567 | 37.778909207118204 | -122.402997684908 | (37.7789092071182, -122.402997684908) | |||
| 35379 | 35379 | 235694 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 11 Laussat St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004612.357000001 | 2109292.4506900003 | 37.771975951266796 | -122.42743851158501 | (37.7719759512668, -122.427438511585) | |||
| 36042 | 36042 | 235681 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 350 Church St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004154.18633 | 2106828.24499 | 37.765183915022895 | -122.428847651203 | (37.7651839150229, -122.428847651203) | |||
| 36200 | 36200 | 235700 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 51 Webster St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004285.19479 | 2108787.04893 | 37.7705697317337 | -122.428534159217 | (37.7705697317337, -122.428534159217) | |||
| 36513 | 36513 | 235731 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2727 Mariposa St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009390.15483 | 2105905.76988 | 37.7629459737104 | -122.41067247408199 | (37.7629459737104, -122.410672474082) | |||
| 37111 | 37111 | 212660 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 229 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993215.92884 | 2088803.0771700002 | 37.7150661605497 | -122.46537066722401 | (37.7150661605497, -122.465370667224) | |||
| 38214 | 38214 | 212630 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 186 Byxbee St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5991963.5826 | 2089803.15651 | 37.7177398306004 | -122.46977203837099 | (37.7177398306004, -122.469772038371) | |||
| 38490 | 38490 | 235671 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 33 Elgin Park | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6005828.27728 | 2108838.78299 | 37.7707989842116 | -122.423200292771 | (37.7707989842116, -122.423200292771) | |||
| 39806 | 39806 | 202011 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 Wheat St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6012102.79015 | 2091227.84985 | 37.722795249884896 | -122.40025938868601 | (37.7227952498849, -122.400259388686) | |||
| 40068 | 40068 | 196188 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 88 Neptune St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013049.10875 | 2093942.96421 | 37.7303031239855 | -122.39717843815001 | (37.7303031239855, -122.39717843815) | |||
| 40286 | 40286 | 178844 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 52 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 2ft | 6009171.05644 | 2086338.49099 | 37.7092061672978 | -122.410048805012 | (37.7092061672978, -122.410048805012) | |||
| 40323 | 40323 | 212653 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 238 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5992477.51296 | 2089454.93509 | 37.716813391295204 | -122.467970312297 | (37.7168133912952, -122.467970312297) | |||
| 40407 | 40407 | 250787 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 277 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5985873.31121 | 2114054.8468299997 | 37.7839744613866 | -122.49260816604601 | (37.7839744613866, -122.492608166046) | |||
| 40635 | 40635 | 196144 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 354 Arkansas St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012902.24063 | 2105349.71395 | 37.7616154519153 | -122.39848627993901 | (37.7616154519153, -122.398486279939) | |||
| 40758 | 40758 | 235696 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 437 Webster St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6004075.95102 | 2110295.93849 | 37.7747009303442 | -122.429365551889 | (37.7747009303442, -122.429365551889) | |||
| 41983 | 41983 | 212629 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 186 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5991963.2488 | 2089763.89053 | 37.717631996493395 | -122.46977033503599 | (37.7176319964934, -122.469770335036) | |||
| 42699 | 42699 | 196153 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 672 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013557.16695 | 2103938.65044 | 37.7577774430852 | -122.39612224644699 | (37.7577774430852, -122.396122246447) | |||
| 43064 | 43064 | 212621 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 115 Beverly St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5991409.18042 | 2089964.95615 | 37.718152032178295 | -122.471700124589 | (37.7181520321783, -122.471700124589) | |||
| 44292 | 44292 | 202136 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2655 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012733.3643 | 2093424.9143700001 | 37.7288630827546 | -122.398233684638 | (37.7288630827546, -122.398233684638) | |||
| 46005 | 46005 | 246996 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 41 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6004880.21483 | 2101034.21529 | 37.7493159377957 | -122.425924019088 | (37.7493159377957, -122.425924019088) | |||
| 46317 | 46317 | 212648 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 359 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992453.38509 | 2090231.05356 | 37.7189430308699 | -122.468110134397 | (37.7189430308699, -122.468110134397) | |||
| 46787 | 46787 | 235687 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 248 Church St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6004125.729280001 | 2107337.98196 | 37.7665819192584 | -122.428982422702 | (37.7665819192584, -122.428982422702) | |||
| 46970 | 46970 | 202265 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 18 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6013066.32076 | 2093183.7813900001 | 37.7282195215999 | -122.397065722507 | (37.7282195215999, -122.397065722507) | |||
| 47293 | 47293 | 235711 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2800 18th St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6009428.19922 | 2105487.68214 | 37.761800133084996 | -122.41051136681699 | (37.761800133085, -122.410511366817) | |||
| 47409 | 47409 | 202275 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 92 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012843.365259999 | 2093277.3613099998 | 37.7284640589493 | -122.397843055137 | (37.7284640589493, -122.397843055137) | |||
| 47553 | 47553 | 246914 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 453 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5997611.12933 | 2107443.4923799997 | 37.7665007194508 | -122.45152277776 | (37.7665007194508, -122.45152277776) | |||
| 48192 | 48192 | 196300 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Stillman St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014184.739519999 | 2113142.03031 | 37.783082776381605 | -122.3945962858 | (37.7830827763816, -122.3945962858) | |||
| 48234 | 48234 | 196302 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 271 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6011407.60626 | 2111629.45684 | 37.7787748169373 | -122.404097603449 | (37.7787748169373, -122.404097603449) | |||
| 48720 | 48720 | 196185 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Venus St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012826.455709999 | 2093927.0961 | 37.730247155583896 | -122.39794707250601 | (37.7302471555839, -122.397947072506) | |||
| 49055 | 49055 | 235713 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2828 18th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009324.87579 | 2105481.33415 | 37.7617769099015 | -122.410868274463 | (37.7617769099015, -122.410868274463) | |||
| 49808 | 49808 | 202272 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 48 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012963.7391099995 | 2093261.57932 | 37.7284274277828 | -122.397425807452 | (37.7284274277828, -122.397425807452) | |||
| 49983 | 49983 | 218202 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 935 Ulloa St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993100.98429 | 2098296.8432 | 37.7411270763539 | -122.466457572568 | (37.7411270763539, -122.466457572568) | |||
| 50431 | 50431 | 246992 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 65 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6004752.26844 | 2101024.33311 | 37.749281571994 | -122.426365757074 | (37.749281571994, -122.426365757074) | |||
| 50719 | 50719 | 196312 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 175 Langton St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6010488.38064 | 2110422.4509900003 | 37.775409257068205 | -122.407192474555 | (37.7754092570682, -122.407192474555) | |||
| 51099 | 51099 | 235730 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2799 Mariposa St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6009367.68275 | 2105903.36909 | 37.7629381217303 | -122.41075002800501 | (37.7629381217303, -122.410750028005) | |||
| 51469 | 51469 | 235709 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2800 18th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009468.56012 | 2105488.54947 | 37.7618047772022 | -122.41037183521601 | (37.7618047772022, -122.410371835216) | |||
| 51943 | 51943 | 196184 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 160 Venus St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012817.540030001 | 2094120.4485 | 37.730777564924004 | -122.397991454042 | (37.730777564924, -122.397991454042) | |||
| 52347 | 52347 | 201970 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 21 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013765.00423 | 2092206.62002 | 37.725575303453496 | -122.39458193081998 | (37.7255753034535, -122.39458193082) | |||
| 53036 | 53036 | 235729 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2799 Mariposa St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6009350.444069999 | 2105901.57906 | 37.762932240148004 | -122.41080952445499 | (37.762932240148, -122.410809524455) | |||
| 53375 | 53375 | 196142 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 310 Arkansas St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012893.1643900005 | 2105525.8086200003 | 37.762098463386 | -122.39853002833799 | (37.762098463386, -122.398530028338) | |||
| 53509 | 53509 | 178760 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3077 25th Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5988826.827409999 | 2094817.3494900002 | 37.7313257268874 | -122.48098119462601 | (37.7313257268874, -122.480981194626) | |||
| 54190 | 54190 | 201951 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 21 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013437.11385 | 2092477.4793 | 37.7263007937235 | -122.39573439853999 | (37.7263007937235, -122.39573439854) | |||
| 54572 | 54572 | 235685 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 268 Church St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6004128.9480800005 | 2107263.6256 | 37.766377936821 | -122.428965987604 | (37.766377936821, -122.428965987604) | |||
| 54699 | 54699 | 196189 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 49 Lucy St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6014162.436290001 | 2093869.58355 | 37.7301635528011 | -122.393324350359 | (37.7301635528011, -122.393324350359) | |||
| 56024 | 56024 | 201979 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 12 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013673.656359999 | 2092275.41387 | 37.7257591185834 | -122.39490253103901 | (37.7257591185834, -122.394902531039) | |||
| 56132 | 56132 | 235692 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Laussat St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6004588.55294 | 2109288.87963 | 37.7719647996542 | -122.427520597194 | (37.7719647996542, -122.427520597194) | |||
| 56482 | 56482 | 212662 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 718 Head St | 6 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993530.84896 | 2090554.84493 | 37.7198942509911 | -122.464409290177 | (37.7198942509911, -122.464409290177) | |||
| 56580 | 56580 | 235698 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 427 Webster St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6004081.68484 | 2110241.59311 | 37.774552035881 | -122.429341841278 | (37.774552035881, -122.429341841278) | |||
| 56714 | 56714 | 212665 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 772 Head St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993534.0623 | 2090935.62343 | 37.7209399619961 | -122.464425815196 | (37.7209399619961, -122.464425815196) | |||
| 57064 | 57064 | 196316 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 333 11th St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6008680.78872 | 2109012.7716900003 | 37.7714372825214 | -122.41334566929399 | (37.7714372825214, -122.413345669294) | |||
| 57333 | 57333 | 235693 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Laussat St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004598.976290001 | 2109290.88002 | 37.7719708817873 | -122.427484684569 | (37.7719708817873, -122.427484684569) | |||
| 57340 | 57340 | 196156 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 418 Mississippi St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6014038.63136 | 2105124.6384 | 37.7610606853181 | -122.39454017618999 | (37.7610606853181, -122.39454017619) | |||
| 57933 | 57933 | 235684 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 348 Church St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6004150.6509300005 | 2106933.36631 | 37.765472352778 | -122.428867374245 | (37.765472352778, -122.428867374245) | |||
| 58002 | 58002 | 249931 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 345 Filbert St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 6011214.74621 | 2120016.06231 | 37.801791658008106 | -122.405355554416 | (37.8017916580081, -122.405355554416) | |||
| 58251 | 58251 | 196301 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 246 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011446.6125 | 2111705.38284 | 37.778985471447704 | -122.403968009318 | (37.7789854714477, -122.403968009318) | |||
| 58745 | 58745 | 201263 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6013048.513180001 | 2093149.69314 | 37.7281249309054 | -122.39712489518999 | (37.7281249309054, -122.39712489519) | |||
| 58888 | 58888 | 212636 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 401 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992198.0920400005 | 2090594.0117 | 37.7199248783202 | -122.46901897484301 | (37.7199248783202, -122.469018974843) | |||
| 58929 | 58929 | 246796 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 191 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6010217.17604 | 2098868.17948 | 37.7436686467848 | -122.407315933508 | (37.7436686467848, -122.407315933508) | |||
| 59221 | 59221 | 212641 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 451 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992462.511419999 | 2090828.2308 | 37.7205832611878 | -122.468122005451 | (37.7205832611878, -122.468122005451) | |||
| 59409 | 59409 | 235686 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 260 Church St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004129.16065 | 2107296.98061 | 37.766469533667795 | -122.42896763067301 | (37.7664695336678, -122.428967630673) | |||
| 59533 | 59533 | 196133 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1007 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6011938.93616 | 2103592.2223099996 | 37.7567360569294 | -122.401694443163 | (37.7567360569294, -122.401694443163) | |||
| 59610 | 59610 | 236796 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 175 Saint Germain Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997594.42954 | 2104109.9282 | 37.757346638148896 | -122.451340089471 | (37.7573466381489, -122.451340089471) | |||
| 59727 | 59727 | 235718 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 575 Florida St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009281.610309999 | 2105592.54154 | 37.76207983392629 | -122.411025768244 | (37.7620798339263, -122.411025768244) | |||
| 59825 | 59825 | 235715 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 575 Florida St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009284.56601 | 2105531.7473299997 | 37.7619130726453 | -122.411011251367 | (37.7619130726453, -122.411011251367) | |||
| 59969 | 59969 | 196146 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 356 Arkansas St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012905.17801 | 2105301.00747 | 37.7614818782994 | -122.39847270286998 | (37.7614818782994, -122.39847270287) | |||
| 60157 | 60157 | 196303 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 249 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6011469.591109999 | 2111688.37468 | 37.7789400547713 | -122.403887319468 | (37.7789400547713, -122.403887319468) | |||
| 60693 | 60693 | 196132 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1333 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6012008.04219 | 2102176.90375 | 37.7528537582936 | -122.401355988713 | (37.7528537582936, -122.401355988713) | |||
| 61278 | 61278 | 235702 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 599 Hickory St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6004146.37122 | 2110271.75391 | 37.774638512002795 | -122.42912022942 | (37.7746385120028, -122.42912022942) | |||
| 62153 | 62153 | 236793 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 559 Dellbrook Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5996921.83514 | 2103634.98097 | 37.7560040168957 | -122.453631879524 | (37.7560040168957, -122.453631879524) |
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");