trees
1,985 rows where qSpecies_id = 83 sorted by SiteOrder 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11540 | 102493 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2001 McAllister St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5999461.6709 | 2111166.2585 | 37.7768282889466 | -122.445389813922 | (37.7768282889466, -122.445389813922) | 15 | 5 | 11 | 29492 | 16 | |||
| 36378 | 138447 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1820 POST ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003269.2692 | 2114178.8859 | 37.7853168309586 | -122.432433419204 | (37.7853168309586, -122.432433419204) | 13 | 9 | 11 | 29490 | 13 | |||
| 39855 | 138129 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1850 FILLMORE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003011.9121 | 2114750.6049 | 37.7868720297123 | -122.433364664404 | (37.7868720297123, -122.433364664404) | 13 | 9 | 11 | 29490 | 27 | |||
| 48659 | 16518 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | ||
| 50430 | 197123 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Napoleon St | 9 | : | Tree | Private 2 | 4 | Width 4ft | 6013823.14287 | 2100134.69381 | 37.7473473883884 | -122.39493596693 | (37.7473473883884, -122.39493596693) | 10 | 3 | 8 | 58 | 1 | |||
| 65262 | 93820 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
| 70918 | 16558 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 500X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/1997 12:00:00 AM | 3 | 3x3 | 6016006.287148 | 2097894.9109735 | 37.7413185578473 | -122.387230532448 | (37.7413185578473, -122.387230532448) | 10 | 3 | 8 | 58 | 1 | ||
| 74210 | 24149 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 100X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016357.373923 | 2096088.8828188 | 37.736379006836 | -122.385890729183 | (37.736379006836, -122.385890729183) | 10 | 3 | 8 | 58 | 1 | ||
| 76177 | 213976 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995023.46765 | 2090970.59824 | 37.7211217374705 | -122.459279952923 | (37.7211217374705, -122.459279952923) | 9 | 8 | 6 | 28861 | 24 | |||
| 88049 | 87399 | - 12 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | 9 | 7 | 4 | 59 | 40 | ||
| 108446 | 213982 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Lobos St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994935.45629 | 2088691.95467 | 37.714860062915 | -122.459419242599 | (37.714860062915, -122.459419242599) | 9 | 8 | 6 | 28861 | 24 | |||
| 108572 | 197165 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 15 Reuel Ct | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017366.51517 | 2096051.55948 | 37.7363323183867 | -122.382399074074 | (37.7363323183867, -122.382399074074) | 10 | 3 | 8 | 58 | 1 | |||
| 114931 | 213960 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994774.81066 | 2091163.63557 | 37.7216374725616 | -122.460153459937 | (37.7216374725616, -122.460153459937) | 9 | 8 | 6 | 28861 | 24 | |||
| 132695 | 48806 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
| 154474 | 237028 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 8 Octavia St | 9 | : | Tree | DPW 1 | 04/15/2017 01:55:00 PM | 3 | Width 6ft | 6005756.39315 | 2109517.28856 | 37.7726579404383 | -122.423497186858 | (37.7726579404383, -122.423497186858) | 7 | 9 | 11 | 28852 | 10 | ||
| 184472 | 197091 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6014475.63706 | 2102134.76481 | 37.7528754202862 | -122.392819573486 | (37.7528754202862, -122.392819573486) | 10 | 3 | 8 | 28856 | 29 | |||
| 185707 | 30630 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008012.82240629 | 2108413.03711614 | 37.7697530267823 | -122.415613735449 | (37.7697530267823, -122.415613735449) | 8 | 4 | 9 | 28853 | 19 | |
| 1502 | 77647 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | 9 | 3 | 7 | 309 | 5 | ||
| 10984 | 138446 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1820 POST ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003295.7109 | 2114182.3135 | 37.7853277416205 | -122.432342183898 | (37.7853277416205, -122.432342183898) | 13 | 9 | 11 | 29490 | 13 | |||
| 11688 | 141943 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1101 GOLDEN GATE AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004162.7275 | 2112162.4936 | 37.77983094307 | -122.429198496132 | (37.77983094307, -122.429198496132) | 7 | 9 | 11 | 29490 | 41 | |||
| 27684 | 24086 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 141X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016393.5495733 | 2095983.6738742 | 37.7360921261264 | -122.385758322913 | (37.7360921261264, -122.385758322913) | 10 | 3 | 8 | 58 | 1 | ||
| 29410 | 138128 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1850 FILLMORE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003016.992 | 2114720.1259 | 37.7867886303047 | -122.433344910367 | (37.7867886303047, -122.433344910367) | 13 | 9 | 11 | 29490 | 27 | |||
| 40799 | 256171 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 75 Arkansas St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | Width 3ft | 6012886.11406 | 2106697.30378 | 37.7653147367117 | -122.398636625887 | (37.7653147367117, -122.398636625887) | 14 | 3 | 8 | 28856 | 20 | ||
| 57570 | 141626 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1801 GROVE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998957.5366 | 2110405.2337 | 37.7747099187277 | -122.44707897901 | (37.7747099187277, -122.44707897901) | 15 | 5 | 11 | 29492 | 16 | |||
| 59889 | 213985 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 431 Capitol Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995022.34889 | 2088455.31671 | 37.714215306566 | -122.459101782823 | (37.714215306566, -122.459101782823) | 9 | 8 | 6 | 28861 | 24 | |||
| 63861 | 93819 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
| 67048 | 90388 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 20 12th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
| 76064 | 4354 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 15X Burnside Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2008 12:00:00 AM | 3 | 3X3 | 6001141.00413 | 2095696.99513 | 37.7344491599181 | -122.438471913289 | (37.7344491599181, -122.438471913289) | 9 | 7 | 5 | 63 | 7 | ||
| 83659 | 48807 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
| 87410 | 30626 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 769481 | 6008034.8095 | 2108530.1235 | 37.7700757544141 | -122.415545973379 | (37.7700757544141, -122.415545973379) | 8 | 2 | 9 | 28853 | 19 | |
| 97560 | 9555 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1195X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.430062547125 | (37.7797350134544, -122.430062547125) | 7 | 9 | 11 | 29490 | 41 | |||
| 97733 | 213959 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994775.57323 | 2091144.94508 | 37.721586196814 | -122.460149470543 | (37.721586196814, -122.460149470543) | 9 | 8 | 6 | 28861 | 24 | |||
| 99225 | 16557 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 500X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1997 12:00:00 AM | 3 | 3x3 | 6016006.287148 | 2097894.9109735 | 37.7413185578473 | -122.387230532448 | (37.7413185578473, -122.387230532448) | 10 | 3 | 8 | 58 | 1 | ||
| 124638 | 213975 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995024.51997 | 2091003.24873 | 37.7212114484221 | -122.459278678595 | (37.7212114484221, -122.459278678595) | 9 | 8 | 6 | 28861 | 24 | |||
| 136484 | 136219 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2901 Steiner St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002007.17609 | 2118176.89143 | 37.7962226754808 | -122.437086212761 | (37.7962226754808, -122.437086212761) | 13 | 9 | 1 | 57 | 17 | |||
| 139723 | 197090 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6014474.31148 | 2102148.65752 | 37.7529134930813 | -122.39282512948 | (37.7529134930813, -122.39282512948) | 10 | 3 | 8 | 28856 | 29 | |||
| 140866 | 27681 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | 5 | 5999414.3973652 | 2094721.8518036 | 37.731673280479 | -122.444371284807 | (37.731673280479, -122.444371284807) | 9 | 7 | 4 | 59 | 40 | |||
| 143126 | 14773 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1000X McAllister St | 8 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 05/13/1992 12:00:00 AM | 6 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
| 168471 | 111489 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1745 FOLSOM ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 28853 | 19 | ||||
| 670 | 197144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 67 Jennings Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012875.71849 | 2089235.92195 | 37.7173688854414 | -122.397447893917 | (37.7173688854414, -122.397447893917) | 10 | 3 | 8 | 58 | 1 | |||
| 2453 | 49617 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1626 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | 8 | 2 | 9 | 28853 | 19 | |||
| 7988 | 24147 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016689.05107 | 2095205.54183 | 37.7339718785836 | -122.384682457242 | (37.7339718785836, -122.384682457242) | 10 | 3 | 8 | 58 | 1 | |||
| 45599 | 48808 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
| 46887 | 197089 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6014473.51573 | 2102162.27258 | 37.7529508329366 | -122.392828833791 | (37.7529508329366, -122.392828833791) | 10 | 3 | 8 | 28856 | 29 | |||
| 48638 | 213990 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 380 Kingston St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5994010.04933 | 2099244.86467 | 37.7437825198608 | -122.463383156521 | (37.7437825198608, -122.463383156521) | 1 | 8 | 4 | 59 | 40 | |||
| 52287 | 93818 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
| 64761 | 30627 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008040.0718 | 2108546.913 | 37.770122150229 | -122.415528959959 | (37.770122150229, -122.415528959959) | 8 | 2 | 9 | 28853 | 19 | |
| 66361 | 138445 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1820 POST ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003321.1733 | 2114185.7412 | 37.7853385969606 | -122.432254336651 | (37.7853385969606, -122.432254336651) | 13 | 9 | 11 | 29490 | 13 | |||
| 88487 | 213958 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5994774.32905 | 2091126.87145 | 37.7215364993901 | -122.460152462564 | (37.7215364993901, -122.460152462564) | 9 | 8 | 6 | 28861 | 24 | |||
| 91056 | 113204 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 3225 26TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008227 | 2100905 | 37.7491497143695 | -122.414341588448 | (37.7491497143695, -122.414341588448) | 2 | 4 | 7 | 28859 | 19 | ||||
| 108376 | 11472 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 39X Hawkins Ln | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6016881.34744 | 2095602.56066 | 37.7350726460825 | -122.384045260583 | (37.7350726460825, -122.384045260583) | 10 | 3 | 8 | 58 | 1 | |||
| 112393 | 111488 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1745 FOLSOM ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 28853 | 19 | ||||
| 133184 | 213974 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995026.3935 | 2091022.299 | 37.7212638636298 | -122.459273581222 | (37.7212638636298, -122.459273581222) | 9 | 8 | 6 | 28861 | 24 | |||
| 136855 | 136262 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 11 Filbert St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6012539.85481 | 2120210.2855 | 37.8023989459081 | -122.400783688018 | (37.8023989459081, -122.400783688018) | 3 | 1 | 10 | 28860 | 6 | ||||
| 141214 | 90387 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 12th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2014 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
| 142553 | 8096 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 762 Fulton St | 7 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 04/14/1998 12:00:00 AM | 18 | 3X3 | 6004110.3708 | 2111520.4613 | 37.7780651171853 | -122.429333825297 | (37.7780651171853, -122.429333825297) | 7 | 9 | 11 | 28852 | 41 | ||
| 150742 | 4356 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 15X Burnside Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2011 12:00:00 AM | 3 | 5x5 | 6001141.00413 | 2095696.99513 | 37.7344491599181 | -122.438471913289 | (37.7344491599181, -122.438471913289) | 9 | 7 | 5 | 63 | 7 | ||
| 162505 | 16161 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 7 | Median : Cutout | Tree | DPW 1 | 04/06/1998 12:00:00 AM | 3 | G | 5999414.3973652 | 2094721.8518036 | 37.731673280479 | -122.444371284807 | (37.731673280479, -122.444371284807) | 9 | 7 | 4 | 59 | 40 | ||
| 189409 | 16496 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 305X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016807.79285 | 2098273.54956 | 37.7424025765764 | -122.384485547297 | (37.7424025765764, -122.384485547297) | 10 | 3 | 8 | 58 | 1 | ||
| 281 | 136194 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002528.73575 | 2118269.03723 | 37.7965053162169 | -122.435288106477 | (37.7965053162169, -122.435288106477) | 13 | 9 | 1 | 57 | 17 | |||
| 1294 | 136237 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008274 | 2116946 | 37.7931971721852 | -122.415314473397 | (37.7931971721852, -122.415314473397) | 5 | 1 | 10 | 28858 | 21 | |||
| 1920 | 213973 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995027.24606 | 2091045.40909 | 37.7213273674346 | -122.459272306869 | (37.7213273674346, -122.459272306869) | 9 | 8 | 6 | 28861 | 24 | |||
| 9515 | 239254 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3715 26th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005705.30849 | 2100786.77225 | 37.748683110957 | -122.423053239242 | (37.748683110957, -122.423053239242) | 2 | 4 | 5 | 28859 | 19 | |||
| 17729 | 197162 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 123 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016438.8167 | 2095743.2053 | 37.735434352517 | -122.385585060917 | (37.735434352517, -122.385585060917) | 10 | 3 | 8 | 58 | 1 | |||
| 24442 | 24127 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 140X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016343.6401634 | 2095980.6654178 | 37.7360811036021 | -122.385930671948 | (37.7360811036021, -122.385930671948) | 10 | 3 | 8 | 58 | 1 | ||
| 28724 | 197143 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 67 Jennings Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012876.39378 | 2089220.96781 | 37.7173278619583 | -122.397444511578 | (37.7173278619583, -122.397444511578) | 10 | 3 | 8 | 58 | 1 | |||
| 29594 | 96720 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008320 | 2116937 | 37.7931750456071 | -122.415154672616 | (37.7931750456071, -122.415154672616) | 5 | 1 | 10 | 28858 | 21 | |||||
| 34803 | 47635 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 301 Anza St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.449834095773 | (37.7806775849758, -122.449834095773) | 15 | 6 | 2 | 54 | 16 | |||
| 39932 | 49616 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1626 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | 8 | 2 | 9 | 28853 | 19 | |||
| 42867 | 18277 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1950 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 6 | 4X4 | 6002776.9831 | 2114109.0569 | 37.7850971709049 | -122.434131584258 | (37.7850971709049, -122.434131584258) | 13 | 9 | 11 | 29490 | 13 | ||
| 44419 | 42167 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 525 05th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 14 | Permit Number 42460 | 6012577.4664 | 2111216.9324 | 37.7777074143023 | -122.400021595319 | (37.7777074143023, -122.400021595319) | 6 | 2 | 9 | 28856 | 34 | ||
| 56276 | 8916 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 4455X Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5993207.14557 | 2112702.93338 | 37.7806885575202 | -122.467137671277 | (37.7806885575202, -122.467137671277) | 11 | 6 | 2 | 54 | 11 | |||
| 62118 | 41238 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 270 Masonic Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | 15 | 5 | 1 | 54 | 16 | |||
| 63506 | 197158 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 106 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016583.16711 | 2095682.22839 | 37.7352749081106 | -122.385081735533 | (37.7352749081106, -122.385081735533) | 10 | 3 | 8 | 58 | 1 | |||
| 67741 | 138428 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1901 SUTTER ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003441.7914 | 2114496.0219 | 37.7861973877355 | -122.431859197478 | (37.7861973877355, -122.431859197478) | 13 | 9 | 11 | 29490 | 13 | |||
| 69106 | 197107 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1468 25th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6014386.38736 | 2102037.52751 | 37.7526034697945 | -122.393121414743 | (37.7526034697945, -122.393121414743) | 10 | 3 | 8 | 28856 | 29 | |||
| 69735 | 213957 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994771.7805 | 2091087.85201 | 37.7214292147603 | -122.460158446674 | (37.7214292147603, -122.460158446674) | 9 | 8 | 6 | 28861 | 24 | |||
| 70828 | 88492 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Quesada Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.7324604500235 | -122.389636207884 | (37.7324604500235, -122.389636207884) | 10 | 3 | 8 | 58 | 1 | ||
| 72759 | 200043 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1598 Lane St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015271.0088 | 2094675.4616 | 37.7324378594728 | -122.389548098564 | (37.7324378594728, -122.389548098564) | 10 | 3 | 8 | 58 | 1 | |||
| 77881 | 141931 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1050 MCALLISTER ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004116.6344 | 2111867.0624 | 37.7790171527246 | -122.42933687954 | (37.7790171527246, -122.42933687954) | 7 | 9 | 11 | 29490 | 41 | |||
| 79833 | 138456 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1901 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002949.306 | 2114858.1502 | 37.7871637698126 | -122.433588955619 | (37.7871637698126, -122.433588955619) | 13 | 9 | 11 | 29490 | 27 | |||
| 80050 | 93817 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
| 80757 | 16526 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 375 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016351.58796 | 2098272.95822 | 37.7423757148758 | -122.386062939968 | (37.7423757148758, -122.386062939968) | 10 | 3 | 8 | 58 | 1 | ||
| 81578 | 123265 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 460 07th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993761.50417 | 2112485.63219 | 37.7801238908447 | -122.465204105338 | (37.7801238908447, -122.465204105338) | 11 | 6 | 2 | 54 | 11 | |||
| 85785 | 213967 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 621 Holloway Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994931.65056 | 2091213.50095 | 37.72178341096 | -122.459614919817 | (37.72178341096, -122.459614919817) | 9 | 8 | 6 | 28861 | 24 | |||
| 88985 | 48809 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | 3 | Permit Number 46042 | 6014468.62547 | 2102279.90426 | 37.7532735528322 | -122.392853974356 | (37.7532735528322, -122.392853974356) | 10 | 3 | 8 | 28856 | 29 | ||
| 105111 | 197169 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Baldwin Ct | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6017690.0216 | 2093651.3665 | 37.7297597257339 | -122.38111373781 | (37.7297597257339, -122.38111373781) | 10 | 3 | 8 | 58 | 1 | |||
| 109062 | 182749 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1791 30th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986862.6162 | 2103130.803 | 37.754037881879 | -122.488382483852 | (37.754037881879, -122.488382483852) | 1 | 8 | 3 | 56 | 35 | |||
| 111833 | 141624 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1801 GROVE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998927.5552 | 2110401.5996 | 37.7746982273973 | -122.447182428734 | (37.7746982273973, -122.447182428734) | 15 | 5 | 11 | 29492 | 16 | |||
| 115665 | 100415 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 201x Linden St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 767727 | 6006435 | 2110776 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | 7 | 9 | 11 | 28852 | 10 | ||||
| 122755 | 112869 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 750 VICENTE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990595 | 2097751 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | 1 | 8 | 4 | 29491 | 40 | ||||
| 125777 | 30638 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008054.606 | 2108589.5131 | 37.7702399370436 | -122.415481702601 | (37.7702399370436, -122.415481702601) | 8 | 2 | 9 | 28853 | 19 | |
| 130488 | 16495 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 305X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016789.27845 | 2098277.7028 | 37.7424129566932 | -122.384549854363 | (37.7424129566932, -122.384549854363) | 10 | 3 | 8 | 58 | 1 | ||
| 135917 | 137621 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2290 Turk Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999066.3943 | 2111876.2674 | 37.7787552182629 | -122.446808290442 | (37.7787552182629, -122.446808290442) | 15 | 5 | 1 | 54 | 16 | |||
| 139977 | 138444 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1820 POST ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003354.9599 | 2114191.1274 | 37.785355301736 | -122.43213783009 | (37.785355301736, -122.43213783009) | 13 | 9 | 11 | 29490 | 13 | |||
| 145895 | 111487 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1745 FOLSOM ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 28853 | 19 | ||||
| 149337 | 8095 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 762 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 04/14/1998 12:00:00 AM | 24 | 3X3 | 6004129.5547 | 2111522.3059 | 37.77807126806 | -122.429267592872 | (37.77807126806, -122.429267592872) | 7 | 9 | 11 | 28852 | 41 | ||
| 151874 | 249824 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Kearny St | 6 | Front Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010866.76079 | 2120642.67591 | 37.8034927229673 | -122.40660393394 | (37.8034927229673, -122.40660393394) | 3 | 1 | 10 | 308 | 23 | |||
| 152428 | 141941 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1101 GOLDEN GATE AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004098.4852 | 2112152.8429 | 37.7798008076738 | -122.42942005016 | (37.7798008076738, -122.42942005016) | 7 | 9 | 11 | 29490 | 41 | |||
| 159395 | 136269 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Joice St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010214.18023 | 2117016.13292 | 37.7934985921435 | -122.408606245692 | (37.7934985921435, -122.408606245692) | 3 | 1 | 10 | 28857 | 4 |
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) );