trees
6,714 rows where qSpecies_id = 7 sorted by Police Districts descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1627 | 35149 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 11 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38681 | 6004664.75137838 | 2109286.2995173 | 37.7719620248453 | -122.427256837171 | (37.7719620248453, -122.427256837171) | 7 | 9 | 11 | 28852 | 10 | ||
| 5448 | 140339 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1300x WEBSTER ST | 7 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6003689.95 | 2113371.7397 | 37.7831244557567 | -122.430920367043 | (37.7831244557567, -122.430920367043) | 15 | 9 | 11 | 29490 | 41 | |||
| 7329 | 83337 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2815 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6000055.78832 | 2117427.57453 | 37.7940541366405 | -122.443784531525 | (37.7940541366405, -122.443784531525) | 13 | 9 | 1 | 57 | 27 | |||
| 9007 | 23899 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1600X Webster St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6003605.1476962 | 2114190.7261663 | 37.785368381567 | -122.431272227533 | (37.785368381567, -122.431272227533) | 13 | 9 | 11 | 29490 | 13 | |||
| 9410 | 79837 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2808 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006109.45612 | 2120466.37489 | 37.8027413403128 | -122.423054277046 | (37.8027413403128, -122.423054277046) | 5 | 9 | 1 | 28858 | 32 | |||
| 10699 | 50602 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1700 Buchanan St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2003 12:00:00 AM | Permit Number 47204 | 6004061.24207522 | 2114267.02341516 | 37.7856037113433 | -122.429699722138 | (37.7856037113433, -122.429699722138) | 13 | 9 | 11 | 29490 | 13 | |||
| 12052 | 32168 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 400 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | 6 | Permit Number 35510 | 6004141.09622 | 2110159.63618 | 37.7743303655916 | -122.429130480813 | (37.7743303655916, -122.429130480813) | 7 | 9 | 11 | 28852 | 10 | |
| 12951 | 44312 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2574 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2001 12:00:00 AM | 5 | Permit Number 43710 | 6001338.87734 | 2117308.19748 | 37.7937994594324 | -122.439336359686 | (37.7937994594324, -122.439336359686) | 13 | 9 | 1 | 57 | 27 | ||
| 13599 | 80235 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1820 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004189.43733 | 2119092.90581 | 37.7988616164221 | -122.429600505158 | (37.7988616164221, -122.429600505158) | 13 | 9 | 1 | 57 | 17 | |||
| 13768 | 106948 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2710 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2014 12:00:00 AM | 1 | 3x3 | 5999606.41459 | 2118186.75395 | 37.7961130004661 | -122.445394018543 | (37.7961130004661, -122.445394018543) | 13 | 9 | 1 | 57 | 17 | ||
| 14653 | 47070 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 610 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | 7 | Permit Number 45053 | 6004032.90703 | 2110923.42535 | 37.7764214179404 | -122.429559210103 | (37.7764214179404, -122.429559210103) | 7 | 9 | 11 | 28852 | 10 | |
| 15408 | 138826 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 640 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004239.9171 | 2111001.0303 | 37.7766462209107 | -122.428848637655 | (37.7766462209107, -122.428848637655) | 7 | 9 | 11 | 28852 | 10 | |||
| 16259 | 48679 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 581 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2002 12:00:00 AM | 2 | Permit Number 45960 | 6005059.5328 | 2110905.0392 | 37.7764290087682 | -122.426006510169 | (37.7764290087682, -122.426006510169) | 7 | 9 | 11 | 28852 | 10 | ||
| 16286 | 47898 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 925 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2002 12:00:00 AM | 5 | Permit Number 45641 | 6003370.3978 | 2111018.9016 | 37.7766460381078 | -122.431857834022 | (37.7766460381078, -122.431857834022) | 15 | 9 | 11 | 29492 | 10 | |
| 16571 | 237808 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 381 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003904.1243 | 2109008.0982 | 37.7711551067578 | -122.42986805526 | (37.7711551067578, -122.42986805526) | 7 | 9 | 11 | 29492 | 10 | |||
| 16759 | 55973 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2221 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2019 12:00:00 AM | 3 | Permit Number 783032 | 6003231.299 | 2116343.71442 | 37.7912587469411 | -122.432719482638 | (37.7912587469411, -122.432719482638) | 13 | 9 | 1 | 29490 | 27 | ||
| 17953 | 30574 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 170 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1995 12:00:00 AM | 6 | Permit Number 34551 | 6004467.68034 | 2108789.06417 | 37.7705855903724 | -122.427903083363 | (37.7705855903724, -122.427903083363) | 7 | 9 | 11 | 28852 | 10 | |
| 19227 | 97806 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1440 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6006763.57941 | 2118064.07992 | 37.7961821349483 | -122.420620040693 | (37.7961821349483, -122.420620040693) | 13 | 9 | 10 | 28858 | 32 | |||
| 19768 | 23901 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1600X Webster St | 4 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 6003605.1476962 | 2114190.7261663 | 37.785368381567 | -122.431272227533 | (37.785368381567, -122.431272227533) | 13 | 9 | 11 | 29490 | 13 | |||
| 20215 | 33650 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 228 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37741 | 6006293.44854624 | 2110954.16637531 | 37.7766335593155 | -122.421741530175 | (37.7766335593155, -122.421741530175) | 7 | 9 | 11 | 28852 | 10 | |||
| 21402 | 135678 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2607 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005300.04249 | 2118927.30269 | 37.7984697341355 | -122.425745651145 | (37.7984697341355, -122.425745651145) | 13 | 9 | 1 | 57 | 17 | |||
| 21495 | 97807 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1440 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768317 | 6006742.70153 | 2118062.30449 | 37.7961760834019 | -122.420692156425 | (37.7961760834019, -122.420692156425) | 13 | 9 | 10 | 28858 | 32 | |
| 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 | |||
| 21853 | 139404 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 941 Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6003105.9135 | 2111324.9278 | 37.777471313327 | -122.432794628765 | (37.777471313327, -122.432794628765) | 15 | 9 | 11 | 29492 | 10 | |||
| 22377 | 235701 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 530 Hickory St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 6004254.58515 | 2110310.97621 | 37.7747523319835 | -122.428748692499 | (37.7747523319835, -122.428748692499) | 7 | 9 | 11 | 28852 | 10 | |||
| 23179 | 2467 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1848 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1989 12:00:00 AM | 12 | 4X4 | 6003976.525 | 2114838.4 | 37.7871677703016 | -122.430033592456 | (37.7871677703016, -122.430033592456) | 13 | 9 | 11 | 29490 | 27 | ||
| 24441 | 138059 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1799 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004397.6472 | 2114960.8205 | 37.7875277472677 | -122.42858533058 | (37.7875277472677, -122.42858533058) | 13 | 9 | 11 | 29490 | 27 | |||
| 24706 | 91492 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1748 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52111 | 6006401.68599 | 2116679.61872 | 37.792360349007 | -122.421773879866 | (37.792360349007, -122.421773879866) | 13 | 9 | 10 | 28858 | 32 | |
| 25916 | 97805 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1440 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6006782.47105 | 2118067.91668 | 37.7961937344091 | -122.420554944153 | (37.7961937344091, -122.420554944153) | 13 | 9 | 10 | 28858 | 32 | |||
| 26151 | 244927 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 250 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005378.3818 | 2109958.5916 | 37.7738483085574 | -122.424836171267 | (37.7738483085574, -122.424836171267) | 7 | 9 | 11 | 28852 | 10 | |||
| 26405 | 143228 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2061 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6006468.1132 | 2117532.528 | 37.7947059704189 | -122.421604643694 | (37.7947059704189, -122.421604643694) | 13 | 9 | 10 | 28858 | 32 | |||
| 27342 | 135791 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 211 Larch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006517.33983 | 2113030.04427 | 37.7823460391879 | -122.42111445739 | (37.7823460391879, -122.42111445739) | 7 | 9 | 11 | 28852 | 41 | |||
| 28770 | 48598 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1444 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | 8 | Permit Number 45908 | 6006635.91115 | 2118390.99294 | 37.7970725599939 | -122.421085023465 | (37.7970725599939, -122.421085023465) | 13 | 9 | 10 | 28858 | 32 | |
| 29181 | 55217 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2341 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1972 12:00:00 AM | 3 | Permit Number 11131 | 6002352.66684 | 2117748.91519 | 37.7950671959414 | -122.435860108554 | (37.7950671959414, -122.435860108554) | 13 | 9 | 1 | 29490 | 27 | ||
| 29394 | 48776 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2423 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 52958 | 6001866.8355 | 2117312.40288 | 37.793841036895 | -122.437509880678 | (37.793841036895, -122.437509880678) | 13 | 9 | 1 | 29490 | 27 | ||
| 29620 | 66201 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2206 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1990 12:00:00 AM | 6 | Permit Number 29285 | 6002370.58115 | 2115902.05733 | 37.7899972184366 | -122.435665927851 | (37.7899972184366, -122.435665927851) | 13 | 9 | 1 | 29490 | 27 | ||
| 31063 | 28642 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1300 Webster St | 4 | Median : Cutout | Tree | DPW 1 | 10 | 20 | 6003705.0759 | 2113297.4854 | 37.7829214290684 | -122.430862736641 | (37.7829214290684, -122.430862736641) | 15 | 9 | 11 | 29490 | 41 | |||
| 31793 | 28645 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1600X Webster St | 2 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6003605.1476962 | 2114190.7261663 | 37.785368381567 | -122.431272227533 | (37.785368381567, -122.431272227533) | 13 | 9 | 11 | 29490 | 13 | |||
| 32461 | 60055 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 427 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31110 | 6004078.96484861 | 2110256.28017055 | 37.7745922089558 | -122.429352297813 | (37.7745922089558, -122.429352297813) | 7 | 9 | 11 | 29492 | 10 | ||
| 32945 | 135785 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 750 Willow St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006841.78708 | 2113423.0519 | 37.7834434270041 | -122.420019909605 | (37.7834434270041, -122.420019909605) | 7 | 9 | 9 | 28858 | 36 | |||
| 33200 | 42998 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 205X Rose St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | 7 | 9 | 11 | 28852 | 10 | |||
| 33906 | 2581 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1671 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1990 12:00:00 AM | 12 | 4X4 | 6005533.42791 | 2115131.9638 | 37.7880618747142 | -122.424667932377 | (37.7880618747142, -122.424667932377) | 13 | 9 | 1 | 28858 | 41 | ||
| 34084 | 102045 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2853 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 1x1 | Permit Number 769645 | 5999896.35932 | 2117404.6933 | 37.7939822160532 | -122.444334525426 | (37.7939822160532, -122.444334525426) | 13 | 9 | 1 | 57 | 27 | ||
| 34594 | 42626 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2630 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42684 | 6004057.62131117 | 2117766.00182931 | 37.7952108143764 | -122.42996192942 | (37.7952108143764, -122.42996192942) | 13 | 9 | 1 | 28858 | 27 | ||
| 34899 | 135778 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 151 Willow St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006696.30515 | 2113402.79123 | 37.7833795985299 | -122.420521782549 | (37.7833795985299, -122.420521782549) | 7 | 9 | 9 | 28858 | 36 | |||
| 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 | |||
| 35032 | 62099 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2423 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1985 12:00:00 AM | 8 | Permit Number 22192 | 6003671.00405 | 2116729.08453 | 37.7923418022811 | -122.431225634948 | (37.7923418022811, -122.431225634948) | 13 | 9 | 1 | 29490 | 27 | ||
| 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 | |||
| 36329 | 51940 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2630 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2005 12:00:00 AM | 6 | Permit Number 48165 | 5999253.26706 | 2119447.90516 | 37.7995556187462 | -122.446706761626 | (37.7995556187462, -122.446706761626) | 13 | 9 | 1 | 57 | 17 | ||
| 37148 | 135762 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2487 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6001732.40168 | 2117306.51799 | 37.793817234538 | -122.437974611659 | (37.793817234538, -122.437974611659) | 13 | 9 | 1 | 29490 | 27 | |||
| 37170 | 135794 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 210 Larch St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006462.88254 | 2113039.98936 | 37.7823702759156 | -122.421303562328 | (37.7823702759156, -122.421303562328) | 7 | 9 | 11 | 28852 | 41 | |||
| 37935 | 135776 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 102 Willow St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006971.50878 | 2113460.79408 | 37.7835543655835 | -122.419573800897 | (37.7835543655835, -122.419573800897) | 7 | 9 | 9 | 28858 | 36 | |||
| 38049 | 113404 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 2052 POLK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6006506 | 2117885 | 37.7956759063958 | -122.421498594593 | (37.7956759063958, -122.421498594593) | 13 | 9 | 10 | 28858 | 32 | |||
| 39504 | 55103 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3044 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1972 12:00:00 AM | 10 | Permit Number 11001 | 5999074.18378 | 2119269.48917 | 37.7990555048549 | -122.447313603458 | (37.7990555048549, -122.447313603458) | 13 | 9 | 1 | 57 | 17 | ||
| 39657 | 139403 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 939 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6003089.2967 | 2111323.2662 | 37.7774658085421 | -122.432851992999 | (37.7774658085421, -122.432851992999) | 15 | 9 | 11 | 29492 | 10 | |||
| 39924 | 41234 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3743 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 5 | Permit Number 41939 | 6002518.8447 | 2121486.57255 | 37.8053392631726 | -122.435552627664 | (37.8053392631726, -122.435552627664) | 13 | 9 | 1 | 57 | 17 | |
| 40050 | 135752 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2555 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5999630.51606 | 2117664.2662 | 37.794679763523 | -122.445273038144 | (37.794679763523, -122.445273038144) | 13 | 9 | 1 | 57 | 27 | |||
| 40922 | 138061 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1795 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004405.7151 | 2114920.5526 | 37.7874176383031 | -122.428554545839 | (37.7874176383031, -122.428554545839) | 13 | 9 | 11 | 29490 | 27 | |||
| 41113 | 135808 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1441 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006638.16659 | 2118343.33159 | 37.7969418210534 | -122.421073833191 | (37.7969418210534, -122.421073833191) | 13 | 9 | 10 | 28858 | 32 | |||
| 42447 | 68974 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3555 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 8 | Permit Number 32964 | 5999680.68438 | 2120824.08507 | 37.8033586457513 | -122.445326751025 | (37.8033586457513, -122.445326751025) | 13 | 9 | 1 | 57 | 17 | |
| 42758 | 41637 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2129 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2000 12:00:00 AM | 10 | Permit Number 42115 | 6002696.74237 | 2119185.54816 | 37.7990313562755 | -122.434772340797 | (37.7990313562755, -122.434772340797) | 13 | 9 | 1 | 57 | 17 | ||
| 44131 | 55104 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3050 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1972 12:00:00 AM | 11 | Permit Number 11002 | 5999072.14016 | 2119290.80376 | 37.7991139122229 | -122.447322209969 | (37.7991139122229, -122.447322209969) | 13 | 9 | 1 | 57 | 17 | ||
| 46085 | 50600 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1700 Buchanan St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2003 12:00:00 AM | Permit Number 47204 | 6004061.24207522 | 2114267.02341516 | 37.7856037113433 | -122.429699722138 | (37.7856037113433, -122.429699722138) | 13 | 9 | 11 | 29490 | 13 | |||
| 46421 | 112639 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2470 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001807.148 | 2117372.77339 | 37.7940034049855 | -122.437720730351 | (37.7940034049855, -122.437720730351) | 13 | 9 | 1 | 57 | 27 | |||
| 46796 | 135682 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2525 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000942.20858 | 2118246.49234 | 37.7963531896107 | -122.440776203963 | (37.7963531896107, -122.440776203963) | 13 | 9 | 1 | 57 | 17 | |||
| 47525 | 105287 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2567 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 770757 | 6000732.18991 | 2118218.38629 | 37.7962640551003 | -122.441500892961 | (37.7962640551003, -122.441500892961) | 13 | 9 | 1 | 57 | 17 | ||
| 49938 | 27 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 740 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2008 12:00:00 AM | 3 | 3X3 | 6003877.1873918 | 2107766.1695161 | 37.7677435471091 | -122.429872630659 | (37.7677435471091, -122.429872630659) | 7 | 9 | 5 | 28862 | 3 | ||
| 50102 | 135714 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1697 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006751.68542 | 2116355.18797 | 37.7914892737742 | -122.420539831045 | (37.7914892737742, -122.420539831045) | 13 | 9 | 10 | 28858 | 21 | |||
| 50262 | 135783 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 750 Willow St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006794.92567 | 2113414.60417 | 37.7834175912848 | -122.420181432353 | (37.7834175912848, -122.420181432353) | 7 | 9 | 9 | 28858 | 36 | |||
| 51617 | 235981 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 410 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004130 | 2110185 | 37.7743993802832 | -122.429170673587 | (37.7743993802832, -122.429170673587) | 7 | 9 | 11 | 28852 | 10 | |||
| 52411 | 21725 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1938X Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003302.0683313 | 2114526.316247 | 37.7862726467398 | -122.432344766725 | (37.7862726467398, -122.432344766725) | 13 | 9 | 11 | 29490 | 27 | |||
| 52472 | 138062 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1793 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004409.3498 | 2114884.8111 | 37.7873197068097 | -122.428539421894 | (37.7873197068097, -122.428539421894) | 13 | 9 | 11 | 29490 | 27 | |||
| 52522 | 92748 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2740 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52975 | 6000116.7231 | 2118022.58322 | 37.7956913488182 | -122.443616455462 | (37.7956913488182, -122.443616455462) | 13 | 9 | 1 | 57 | 17 | |
| 52714 | 135755 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2714 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6000658.039 | 2117716.73942 | 37.7948824401251 | -122.44172144989 | (37.7948824401251, -122.44172144989) | 13 | 9 | 1 | 57 | 27 | |||
| 53160 | 249679 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2400 Baker St | 11 | Front Yard : Yard | Tree | Private 2 | 8 | 5999741.43988 | 2117216.47572 | 37.7934565803204 | -122.44485702434 | (37.7934565803204, -122.44485702434) | 13 | 9 | 1 | 57 | 27 | ||||
| 55173 | 138939 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 955 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6003223.616 | 2110999.5153 | 37.7765844862689 | -122.432364209952 | (37.7765844862689, -122.432364209952) | 15 | 9 | 11 | 29492 | 10 | |||
| 55256 | 99870 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2244 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768957 | 6002355.52291 | 2116016.09819 | 37.7903094900332 | -122.435726190525 | (37.7903094900332, -122.435726190525) | 13 | 9 | 1 | 29490 | 27 | |
| 56572 | 42708 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1600 Union St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42723 | 6005315.92998199 | 2118904.40480493 | 37.7984077601464 | -122.42568904485 | (37.7984077601464, -122.42568904485) | 13 | 9 | 1 | 57 | 17 | |||
| 58234 | 135683 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2265 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002155.23033 | 2118414.35252 | 37.7968830962323 | -122.436590921031 | (37.7968830962323, -122.436590921031) | 13 | 9 | 1 | 57 | 17 | |||
| 58316 | 237703 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 67 Belcher St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6003822.87752 | 2107928.98523 | 37.7681875238589 | -122.430072097943 | (37.7681875238589, -122.430072097943) | 7 | 9 | 5 | 28862 | 3 | |||
| 60548 | 135679 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2710 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5999610.9166 | 2118151.58373 | 37.7960166893825 | -122.445375910666 | (37.7960166893825, -122.445375910666) | 13 | 9 | 1 | 57 | 17 | |||
| 60707 | 135681 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2525 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000927.41477 | 2118244.96171 | 37.7963481443919 | -122.440827283678 | (37.7963481443919, -122.440827283678) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 61726 | 135711 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3213 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001339.31122 | 2119500.01762 | 37.7998176470232 | -122.439492052127 | (37.7998176470232, -122.439492052127) | 13 | 9 | 1 | 57 | 17 | |||
| 61736 | 115005 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1050 MCALLISTER ST | 2 | Front Yard : Cutout | Tree | Office of Mayor 9 | DPW | 3x3 | 6004148 | 2111858 | 37.7789940453007 | -122.429227726914 | (37.7789940453007, -122.429227726914) | 7 | 9 | 11 | 29490 | 41 | |||
| 62453 | 41226 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 155 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 8 | Permit Number 41932 | 6001878.60529 | 2121714.18401 | 37.8059278397599 | -122.437784566908 | (37.8059278397599, -122.437784566908) | 13 | 9 | 1 | 57 | 17 | |
| 62597 | 50596 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1700 Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2003 12:00:00 AM | Permit Number 47204 | 6004061.24207522 | 2114267.02341516 | 37.7856037113433 | -122.429699722138 | (37.7856037113433, -122.429699722138) | 13 | 9 | 11 | 29490 | 13 | |||
| 63469 | 12419 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1691 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/1997 12:00:00 AM | 3 | 4X4 | 6004453.7544 | 2114557.5752 | 37.7864237118677 | -122.428362459156 | (37.7864237118677, -122.428362459156) | 13 | 9 | 11 | 29490 | 13 | ||
| 63948 | 138969 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 610 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004035.3418 | 2110925.4845 | 37.776427209717 | -122.429550934434 | (37.776427209717, -122.429550934434) | 7 | 9 | 11 | 28852 | 10 | |||
| 64790 | 135712 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3213 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001342.31798 | 2119480.82403 | 37.7997651176115 | -122.439480271006 | (37.7997651176115, -122.439480271006) | 13 | 9 | 1 | 57 | 17 | |||
| 65038 | 138992 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 636 STEINER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003115.3297 | 2110549.7536 | 37.7753434114442 | -122.432706667478 | (37.7753434114442, -122.432706667478) | 15 | 9 | 11 | 29492 | 10 | |||
| 65200 | 135792 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 210 Larch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006538.43664 | 2113050.20731 | 37.7824025912374 | -122.421042903704 | (37.7824025912374, -122.421042903704) | 7 | 9 | 11 | 28852 | 41 | |||
| 65756 | 110275 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2612 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2016 12:00:00 AM | 3 | Permit Number 778382 | 6001183.56283 | 2117454.33561 | 37.794191876798 | -122.43988424377 | (37.794191876798, -122.43988424377) | 13 | 9 | 1 | 57 | 27 | ||
| 66008 | 33700 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 117 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 9 | 3x3 | Permit Number 37769 | 6003661.70880782 | 2108800.16267952 | 37.7705704357115 | -122.430691738532 | (37.7705704357115, -122.430691738532) | 15 | 9 | 11 | 29492 | 10 | |
| 66419 | 51279 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2555 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2004 12:00:00 AM | 4 | Permit Number 47653 | 6000779.0494 | 2118223.84551 | 37.7962817141912 | -122.441339141794 | (37.7962817141912, -122.441339141794) | 13 | 9 | 1 | 57 | 17 | ||
| 66620 | 28855 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 999X Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | 15 | 9 | 11 | 29492 | 10 | |||
| 68135 | 135686 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2518 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000832.47655 | 2118279.41325 | 37.7964373319644 | -122.441158262047 | (37.7964373319644, -122.441158262047) | 13 | 9 | 1 | 57 | 17 | |||
| 68838 | 138064 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1781 Laguna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004414.8019 | 2114830.29 | 37.7871703140915 | -122.428516671071 | (37.7871703140915, -122.428516671071) | 13 | 9 | 11 | 29490 | 27 | |||
| 68849 | 34140 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2711 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/1997 12:00:00 AM | Permit Number 37988 | 5999567.80789989 | 2118121.89332869 | 37.7959327064982 | -122.445522938607 | (37.7959327064982, -122.445522938607) | 13 | 9 | 1 | 57 | 17 | |||
| 69272 | 138933 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 676 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004115.5674 | 2110982.311 | 37.776587783373 | -122.429277464518 | (37.776587783373, -122.429277464518) | 7 | 9 | 11 | 28852 | 10 |
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) );