trees
6,714 rows where qSpecies_id = 7 sorted by qSiteInfo
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 152 | 235666 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Jessie St | 4 | : | Tree | Private 2 | 3 | Width 2ft | 6006462.25734 | 2109005.38337 | 37.7712921868165 | -122.421019169707 | (37.7712921868165, -122.421019169707) | 8 | 2 | 9 | 28853 | 19 | |||
| 211 | 196303 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 249 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011469.59111 | 2111688.37468 | 37.7789400547713 | -122.403887319468 | (37.7789400547713, -122.403887319468) | 14 | 2 | 9 | 28856 | 34 | |||
| 312 | 201949 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 18 | : | Tree | Private 2 | 2 | Width 3ft | 6013468.57071 | 2092447.06427 | 37.7262190300648 | -122.395623522912 | (37.7262190300648, -122.395623522912) | 10 | 3 | 8 | 58 | 1 | |||
| 437 | 202267 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 28 Orsi Cir | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6013033.98272 | 2093207.99375 | 37.7282842035544 | -122.397179214247 | (37.7282842035544, -122.397179214247) | 10 | 3 | 8 | 58 | 1 | |||
| 1550 | 201970 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 21 | : | Tree | Private 2 | 3 | Width 3ft | 6013765.00423 | 2092206.62002 | 37.7255753034535 | -122.39458193082 | (37.7255753034535, -122.39458193082) | 10 | 3 | 8 | 58 | 1 | |||
| 2505 | 196318 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 323 11th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008553.79261 | 2109149.29537 | 37.7718050135221 | -122.413794615322 | (37.7718050135221, -122.413794615322) | 8 | 2 | 9 | 28853 | 34 | |||
| 2811 | 246987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Clipper St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6004726.23458 | 2101068.69852 | 37.7494019174823 | -122.426458941248 | (37.7494019174823, -122.426458941248) | 2 | 4 | 5 | 28862 | 22 | |||
| 6844 | 235670 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 69 Elgin Park | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6005833.06667 | 2108709.07327 | 37.7704431026896 | -122.423174504696 | (37.7704431026896, -122.423174504696) | 8 | 2 | 5 | 28853 | 19 | |||
| 7843 | 202011 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 35 Wheat St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6012102.79015 | 2091227.84985 | 37.7227952498849 | -122.400259388686 | (37.7227952498849, -122.400259388686) | 10 | 3 | 8 | 58 | 1 | |||
| 8287 | 196310 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 928 Clara St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6011726.41935 | 2111671.91567 | 37.7789092071182 | -122.402997684908 | (37.7789092071182, -122.402997684908) | 14 | 2 | 9 | 28856 | 34 | |||
| 8768 | 246988 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Clipper St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6004704.08454 | 2101068.96131 | 37.7494013868777 | -122.426535555381 | (37.7494013868777, -122.426535555381) | 2 | 4 | 5 | 28862 | 22 | |||
| 10828 | 196319 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 83 Lafayette St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6007736.57644 | 2109492.64153 | 37.7727018336483 | -122.416645755806 | (37.7727018336483, -122.416645755806) | 8 | 2 | 9 | 28853 | 19 | |||
| 12073 | 201265 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 15 Orsi Cir | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6013080.9244 | 2093125.28837 | 37.728059724652 | -122.397011137269 | (37.728059724652, -122.397011137269) | 10 | 3 | 8 | 58 | 1 | |||
| 12977 | 235705 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Scott St | 9 | : | Tree | Private 2 | 6 | Width 3ft | 6002413.688 | 2108646.89138 | 37.7700788062318 | -122.434997685721 | (37.7700788062318, -122.434997685721) | 15 | 5 | 5 | 29492 | 9 | |||
| 13712 | 202138 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2639 Newhall St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6012756.67365 | 2093454.87992 | 37.728946660355 | -122.398155203507 | (37.728946660355, -122.398155203507) | 10 | 3 | 8 | 58 | 1 | |||
| 13727 | 246993 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 55 Clipper St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6004785.89781 | 2101026.33834 | 37.7492889788082 | -122.426249608749 | (37.7492889788082, -122.426249608749) | 2 | 4 | 5 | 28862 | 22 | |||
| 14420 | 235664 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Jessie St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6006467.28289 | 2108921.03594 | 37.7710608721893 | -122.42099579632 | (37.7710608721893, -122.42099579632) | 8 | 2 | 9 | 28853 | 19 | |||
| 15150 | 235718 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 575 Florida St | 5 | : | Tree | Private 2 | 1 | Width 3ft | 6009281.61031 | 2105592.54154 | 37.7620798339263 | -122.411025768244 | (37.7620798339263, -122.411025768244) | 8 | 4 | 7 | 28859 | 19 | |||
| 15411 | 235712 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2800 18th St | 5 | : | Tree | Private 2 | 2 | Width 3ft | 6009409.0711 | 2105486.80385 | 37.7617966491233 | -122.410577461607 | (37.7617966491233, -122.410577461607) | 8 | 4 | 7 | 28859 | 19 | |||
| 16551 | 196136 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 893 Wisconsin St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6012789.60739 | 2103393.313 | 37.7562373289042 | -122.398738532573 | (37.7562373289042, -122.398738532573) | 10 | 3 | 8 | 28856 | 29 | |||
| 16715 | 212653 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 238 Vernon St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5992477.51296 | 2089454.93509 | 37.7168133912952 | -122.467970312297 | (37.7168133912952, -122.467970312297) | 9 | 8 | 6 | 64 | 24 | |||
| 17379 | 196308 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 928 Clara St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011682.43832 | 2111628.83367 | 37.7787884578701 | -122.403146802398 | (37.7787884578701, -122.403146802398) | 14 | 2 | 9 | 28856 | 34 | |||
| 17400 | 212661 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 542 Head St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5993519.05172 | 2089481.79849 | 37.7169472436938 | -122.464372202114 | (37.7169472436938, -122.464372202114) | 9 | 8 | 6 | 64 | 24 | |||
| 17994 | 235734 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2727 Mariposa St | 5 | : | Tree | Private 2 | 6 | Width 3ft | 6009451.23627 | 2105908.82416 | 37.7629577845068 | -122.410461429278 | (37.7629577845068, -122.410461429278) | 8 | 4 | 7 | 28859 | 19 | |||
| 18855 | 201262 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 31 Orsi Cir | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6013038.33649 | 2093158.36768 | 37.728148182884 | -122.397160684615 | (37.728148182884, -122.397160684615) | 10 | 3 | 8 | 58 | 1 | |||
| 20132 | 235665 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Jessie St | 3 | : | Tree | Private 2 | 3 | Width 2ft | 6006464.5058 | 2108970.07849 | 37.7711953747872 | -122.421008885051 | (37.7711953747872, -122.421008885051) | 8 | 2 | 9 | 28853 | 19 | |||
| 20160 | 212660 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 229 Victoria St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5993215.92884 | 2088803.07717 | 37.7150661605497 | -122.465370667224 | (37.7150661605497, -122.465370667224) | 9 | 8 | 6 | 64 | 24 | |||
| 20774 | 236795 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 155 Saint Germain Ave | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5997672.86518 | 2104113.27373 | 37.7573603150384 | -122.451069070676 | (37.7573603150384, -122.451069070676) | 15 | 5 | 4 | 28862 | 38 | |||
| 20920 | 212632 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 319 Ralston St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5992190.56348 | 2089982.35509 | 37.7182449834113 | -122.469000508175 | (37.7182449834113, -122.469000508175) | 9 | 8 | 6 | 64 | 24 | |||
| 20935 | 235686 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 260 Church St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6004129.16065 | 2107296.98061 | 37.7664695336678 | -122.428967630673 | (37.7664695336678, -122.428967630673) | 8 | 4 | 5 | 28862 | 3 | |||
| 21066 | 235683 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 348 Church St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6004150.8189 | 2106918.45723 | 37.7654314255387 | -122.428865730283 | (37.7654314255387, -122.428865730283) | 8 | 4 | 5 | 28862 | 3 | |||
| 21552 | 249411 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Olive St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6007136.98967 | 2113833.35507 | 37.7845866470086 | -122.419027733462 | (37.7845866470086, -122.419027733462) | 7 | 9 | 9 | 28858 | 36 | |||
| 21685 | 196155 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 418 Mississippi St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014037.44823 | 2105136.58178 | 37.7610934134625 | -122.394545104498 | (37.7610934134625, -122.394545104498) | 10 | 3 | 8 | 28856 | 29 | |||
| 22041 | 187551 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2441 19th Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5990426.26048 | 2098774.7795 | 37.7422846621229 | -122.475740599546 | (37.7422846621229, -122.475740599546) | 1 | 8 | 3 | 29491 | 35 | |||
| 23463 | 235674 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Pearl St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6005644.63819 | 2108622.46194 | 37.7701946533013 | -122.423820120807 | (37.7701946533013, -122.423820120807) | 8 | 2 | 5 | 28853 | 19 | |||
| 24366 | 202304 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 152 Orsi Cir | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6012919.13392 | 2092996.02429 | 37.7276957843337 | -122.397561393738 | (37.7276957843337, -122.397561393738) | 10 | 3 | 8 | 58 | 1 | |||
| 24476 | 212671 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 615 Garfield St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992392.42852 | 2090471.1623 | 37.7195987904413 | -122.468338294185 | (37.7195987904413, -122.468338294185) | 9 | 8 | 6 | 64 | 24 | |||
| 25547 | 212641 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 451 Vernon St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992462.51142 | 2090828.2308 | 37.7205832611878 | -122.468122005451 | (37.7205832611878, -122.468122005451) | 9 | 8 | 6 | 64 | 24 | |||
| 27740 | 201904 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1797 Yosemite Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6013567.70299 | 2093393.69523 | 37.7288238003734 | -122.395347110876 | (37.7288238003734, -122.395347110876) | 10 | 3 | 8 | 58 | 1 | |||
| 28199 | 235719 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 575 Florida St | 6 | : | Tree | Private 2 | 1 | Width 3ft | 6009281.11866 | 2105609.9991 | 37.7621277408309 | -122.411028701807 | (37.7621277408309, -122.411028701807) | 8 | 4 | 7 | 28859 | 19 | |||
| 28948 | 218204 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 935 Ulloa St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 5993128.32647 | 2098280.97709 | 37.7410850897185 | -122.466361881116 | (37.7410850897185, -122.466361881116) | 1 | 8 | 4 | 59 | 40 | |||
| 31111 | 196152 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 648 Missouri St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6013554.34152 | 2104016.61461 | 37.7579913585422 | -122.396137481863 | (37.7579913585422, -122.396137481863) | 10 | 3 | 8 | 28856 | 29 | |||
| 31904 | 236796 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 175 Saint Germain Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5997594.42954 | 2104109.9282 | 37.7573466381489 | -122.451340089471 | (37.7573466381489, -122.451340089471) | 15 | 5 | 4 | 28862 | 38 | |||
| 32331 | 196301 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 246 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011446.6125 | 2111705.38284 | 37.7789854714477 | -122.403968009318 | (37.7789854714477, -122.403968009318) | 14 | 2 | 9 | 28856 | 34 | |||
| 32731 | 196133 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1007 Rhode Island St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6011938.93616 | 2103592.22231 | 37.7567360569294 | -122.401694443163 | (37.7567360569294, -122.401694443163) | 10 | 3 | 8 | 28856 | 29 | |||
| 33115 | 212656 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 426 Victoria St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993265.19823 | 2090019.96829 | 37.7184102922832 | -122.465288712912 | (37.7184102922832, -122.465288712912) | 9 | 8 | 6 | 64 | 24 | |||
| 33903 | 235668 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 99 Elgin Park | 1 | : | Tree | Private 2 | 2 | Width 2ft | 6005845.90944 | 2108547.05251 | 37.7699989572271 | -122.423118563291 | (37.7699989572271, -122.423118563291) | 8 | 2 | 5 | 28853 | 19 | |||
| 34908 | 235692 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 17 Laussat St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6004588.55294 | 2109288.87963 | 37.7719647996542 | -122.427520597194 | (37.7719647996542, -122.427520597194) | 7 | 9 | 11 | 28852 | 10 | |||
| 35691 | 196180 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2555 Phelps St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6012050.36585 | 2093618.49269 | 37.7293565407635 | -122.400608465023 | (37.7293565407635, -122.400608465023) | 10 | 3 | 8 | 58 | 1 | |||
| 35870 | 212672 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 609 Garfield St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992414.13264 | 2090471.45088 | 37.7196008363947 | -122.468263292533 | (37.7196008363947, -122.468263292533) | 9 | 8 | 6 | 64 | 24 | |||
| 36105 | 235691 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 61 Laussat St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6004436.15344 | 2109270.60375 | 37.771905997508 | -122.428046455984 | (37.771905997508, -122.428046455984) | 7 | 9 | 11 | 28852 | 10 | |||
| 36652 | 235708 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2800 18th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6009490.24351 | 2105489.79848 | 37.7618094221989 | -122.410296928887 | (37.7618094221989, -122.410296928887) | 8 | 4 | 7 | 28859 | 19 | |||
| 39380 | 235703 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Scott St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 6002429.14614 | 2108537.1184 | 37.7697782743853 | -122.434936364546 | (37.7697782743853, -122.434936364546) | 15 | 5 | 5 | 29492 | 9 | |||
| 39737 | 201947 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 16 | : | Tree | Private 2 | 2 | Width 3ft | 6013508.30345 | 2092417.86904 | 37.7261410759436 | -122.395484123498 | (37.7261410759436, -122.395484123498) | 10 | 3 | 8 | 58 | 1 | |||
| 41082 | 196311 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 960 Harrison St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011645.79902 | 2111357.16189 | 37.7780404638396 | -122.403254436838 | (37.7780404638396, -122.403254436838) | 14 | 2 | 9 | 28856 | 34 | |||
| 41348 | 196316 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 333 11th St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 6008680.78872 | 2109012.77169 | 37.7714372825214 | -122.413345669294 | (37.7714372825214, -122.413345669294) | 8 | 2 | 9 | 28853 | 34 | |||
| 41354 | 235733 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2727 Mariposa St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6009434.87178 | 2105908.14162 | 37.7629549929938 | -122.410517980442 | (37.7629549929938, -122.410517980442) | 8 | 4 | 7 | 28859 | 19 | |||
| 41400 | 235684 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 348 Church St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6004150.65093 | 2106933.36631 | 37.765472352778 | -122.428867374245 | (37.765472352778, -122.428867374245) | 8 | 4 | 5 | 28862 | 3 | |||
| 42107 | 196183 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 52 Robblee Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012510.53762 | 2095915.58622 | 37.7356895369409 | -122.399178778585 | (37.7356895369409, -122.399178778585) | 10 | 3 | 8 | 58 | 1 | |||
| 42891 | 246992 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 65 Clipper St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6004752.26844 | 2101024.33311 | 37.749281571994 | -122.426365757074 | (37.749281571994, -122.426365757074) | 2 | 4 | 5 | 28862 | 22 | |||
| 43474 | 202271 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 46 Orsi Cir | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6012970.02613 | 2093256.16358 | 37.7284129073171 | -122.397403693121 | (37.7284129073171, -122.397403693121) | 10 | 3 | 8 | 58 | 1 | |||
| 44489 | 235678 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 370 Church St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6004156.7095 | 2106731.66134 | 37.7649188623484 | -122.428832038066 | (37.7649188623484, -122.428832038066) | 8 | 4 | 5 | 28862 | 3 | |||
| 45038 | 236800 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 190 Saint Germain Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5997430.38587 | 2104139.0852 | 37.7574173014766 | -122.45190951773 | (37.7574173014766, -122.45190951773) | 15 | 5 | 4 | 28862 | 38 | |||
| 47570 | 196181 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2545 Phelps St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012082.65235 | 2093663.02061 | 37.7294806058403 | -122.400499973489 | (37.7294806058403, -122.400499973489) | 10 | 3 | 8 | 58 | 1 | |||
| 50075 | 196300 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 25 Stillman St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6014184.73952 | 2113142.03031 | 37.7830827763816 | -122.3945962858 | (37.7830827763816, -122.3945962858) | 6 | 2 | 9 | 28856 | 6 | |||
| 50673 | 201945 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 12 | : | Tree | Private 2 | 2 | Width 3ft | 6013588.62557 | 2092382.18651 | 37.7260475662288 | -122.395203954116 | (37.7260475662288, -122.395203954116) | 10 | 3 | 8 | 58 | 1 | |||
| 52876 | 201991 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1751 Carroll Ave | 7 | : | Tree | Private 2 | 2 | Width 3ft | 6013485.64387 | 2092346.48409 | 37.7259438069368 | -122.395557457834 | (37.7259438069368, -122.395557457834) | 10 | 3 | 8 | 58 | 1 | |||
| 53147 | 201984 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6013594.77768 | 2092310.70039 | 37.7258516219291 | -122.395177681321 | (37.7258516219291, -122.395177681321) | 10 | 3 | 8 | 58 | 1 | |||
| 53592 | 212669 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 131 Garfield St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993624.74466 | 2090472.09024 | 37.7196724386082 | -122.464078723674 | (37.7196724386082, -122.464078723674) | 9 | 8 | 6 | 64 | 24 | |||
| 54176 | 235682 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 348 Church St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 6004154.64723 | 2106873.66178 | 37.7653086446928 | -122.428849295158 | (37.7653086446928, -122.428849295158) | 8 | 4 | 5 | 28862 | 3 | |||
| 54193 | 201266 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 5 Orsi Cir | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6013111.33657 | 2093102.58113 | 37.7279990680861 | -122.396904409335 | (37.7279990680861, -122.396904409335) | 10 | 3 | 8 | 58 | 1 | |||
| 54450 | 212650 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 319 Vernon St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992450.00346 | 2089979.5572 | 37.7182522876938 | -122.46810353875 | (37.7182522876938, -122.46810353875) | 9 | 8 | 6 | 64 | 24 | |||
| 55481 | 201976 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 15 | : | Tree | Private 2 | 5 | Width 3ft | 6013710.28394 | 2092247.91618 | 37.7256856520577 | -122.394773986446 | (37.7256856520577, -122.394773986446) | 10 | 3 | 8 | 58 | 1 | |||
| 56776 | 236798 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 175 Saint Germain Ave | 3 | : | Tree | Private 2 | 5 | Width 3ft | 5997618.19625 | 2104110.26255 | 37.75734891704 | -122.451257919334 | (37.75734891704, -122.451257919334) | 15 | 5 | 4 | 28862 | 38 | |||
| 57229 | 196304 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 249 Shipley St | 2 | : | Tree | Private 2 | 1 | Width 5ft | 6011481.85957 | 2111700.79426 | 37.7789748414544 | -122.403845751896 | (37.7789748414544, -122.403845751896) | 14 | 2 | 9 | 28856 | 34 | |||
| 57340 | 196306 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 218 Clara St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6011621.39145 | 2111749.7942 | 37.779117178052 | -122.40336650048 | (37.779117178052, -122.40336650048) | 14 | 2 | 9 | 28856 | 34 | |||
| 57963 | 202273 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Orsi Cir | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6012938.89237 | 2093280.23143 | 37.7284772592045 | -122.397513012032 | (37.7284772592045, -122.397513012032) | 10 | 3 | 8 | 58 | 1 | |||
| 58026 | 202139 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2635 Newhall St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6012761.28148 | 2093461.72838 | 37.7289657214742 | -122.398139754066 | (37.7289657214742, -122.398139754066) | 10 | 3 | 8 | 58 | 1 | |||
| 58665 | 201951 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 21 | : | Tree | Private 2 | 2 | Width 3ft | 6013437.11385 | 2092477.4793 | 37.7263007937235 | -122.39573439854 | (37.7263007937235, -122.39573439854) | 10 | 3 | 8 | 58 | 1 | |||
| 59028 | 196147 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 358 Arkansas St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6012905.74623 | 2105264.51054 | 37.7613816974298 | -122.398468176592 | (37.7613816974298, -122.398468176592) | 10 | 3 | 8 | 28856 | 29 | |||
| 59071 | 212613 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 637 Mount Vernon Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5997495.03052 | 2090233.55986 | 37.7192397900563 | -122.450683408119 | (37.7192397900563, -122.450683408119) | 9 | 8 | 6 | 28861 | 24 | |||
| 59593 | 201941 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 7 | : | Tree | Private 2 | 2 | Width 3ft | 6013681.12245 | 2092335.8479 | 37.7259254733716 | -122.394880951809 | (37.7259254733716, -122.394880951809) | 10 | 3 | 8 | 58 | 1 | |||
| 59803 | 246915 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 453 Frederick St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5997627.7084 | 2107444.25662 | 37.7665037672476 | -122.451465489148 | (37.7665037672476, -122.451465489148) | 15 | 5 | 11 | 29492 | 9 | |||
| 59925 | 246449 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 435 Duncan St | 1 | : | Tree | Private 2 | 18 | Width 3ft | 6003682.43356 | 2099795.27401 | 37.745846329063 | -122.429977604393 | (37.745846329063, -122.429977604393) | 2 | 7 | 5 | 63 | 22 | |||
| 59983 | 235713 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2828 18th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6009324.87579 | 2105481.33415 | 37.7617769099015 | -122.410868274463 | (37.7617769099015, -122.410868274463) | 8 | 4 | 7 | 28859 | 19 | |||
| 60423 | 236793 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 559 Dellbrook Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5996921.83514 | 2103634.98097 | 37.7560040168957 | -122.453631879524 | (37.7560040168957, -122.453631879524) | 1 | 5 | 4 | 63 | 38 | |||
| 60772 | 212639 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 466 Ralston St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992234.36824 | 2090921.5704 | 37.7208263704132 | -122.468917406335 | (37.7208263704132, -122.468917406335) | 9 | 8 | 6 | 64 | 24 | |||
| 61425 | 235690 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 63 Laussat St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6004411.60055 | 2109266.67882 | 37.7718938314631 | -122.428131106459 | (37.7718938314631, -122.428131106459) | 7 | 9 | 11 | 28852 | 10 | |||
| 62438 | 196146 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 356 Arkansas St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6012905.17801 | 2105301.00747 | 37.7614818782994 | -122.39847270287 | (37.7614818782994, -122.39847270287) | 10 | 3 | 8 | 28856 | 29 | |||
| 63717 | 202265 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 18 Orsi Cir | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6013066.32076 | 2093183.78139 | 37.7282195215999 | -122.397065722507 | (37.7282195215999, -122.397065722507) | 10 | 3 | 8 | 58 | 1 | |||
| 65680 | 212621 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Beverly St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5991409.18042 | 2089964.95615 | 37.7181520321783 | -122.471700124589 | (37.7181520321783, -122.471700124589) | 9 | 8 | 6 | 64 | 24 | |||
| 66392 | 212676 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 124 Sargent St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993606.85369 | 2089199.82617 | 37.7161780760225 | -122.464048258239 | (37.7161780760225, -122.464048258239) | 9 | 8 | 6 | 64 | 24 | |||
| 67075 | 196185 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 199 Venus St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6012826.45571 | 2093927.0961 | 37.7302471555839 | -122.397947072506 | (37.7302471555839, -122.397947072506) | 10 | 3 | 8 | 58 | 1 | |||
| 67464 | 235685 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 268 Church St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6004128.94808 | 2107263.6256 | 37.766377936821 | -122.428965987604 | (37.766377936821, -122.428965987604) | 8 | 4 | 5 | 28862 | 3 | |||
| 67513 | 212637 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 401 Ralston St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5992197.26293 | 2090572.74875 | 37.7198664475464 | -122.469020294145 | (37.7198664475464, -122.469020294145) | 9 | 8 | 6 | 64 | 24 | |||
| 67515 | 202274 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 56 Orsi Cir | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6012930.69463 | 2093286.64754 | 37.7284944200689 | -122.397541802039 | (37.7284944200689, -122.397541802039) | 10 | 3 | 8 | 58 | 1 | |||
| 68186 | 178758 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3092 25th Ave | 1 | : | Tree | Private 2 | 3 | Width 2ft | 5988865.41335 | 2094809.64231 | 37.7313068078649 | -122.480847233437 | (37.7313068078649, -122.480847233437) | 1 | 8 | 4 | 64 | 35 | |||
| 68368 | 235676 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 398 Church St | 3 | : | Tree | Private 2 | 6 | Width 4ft | 6004163.62618 | 2106652.25883 | 37.7647012336104 | -122.428802453987 | (37.7647012336104, -122.428802453987) | 8 | 4 | 5 | 28862 | 3 | |||
| 68746 | 202137 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2645 Newhall St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6012739.3871 | 2093431.02241 | 37.7288801896589 | -122.398213291624 | (37.7288801896589, -122.398213291624) | 10 | 3 | 8 | 58 | 1 | |||
| 69186 | 196305 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 218 Clara St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011726.31972 | 2111713.41774 | 37.7790231566266 | -122.40300094945 | (37.7790231566266, -122.40300094945) | 14 | 2 | 9 | 28856 | 34 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );