trees
1,985 rows where qSpecies_id = 83 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27070 | 179328 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 381 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003082.18231 | 2091589.31338 | 37.7232806193946 | -122.431467482451 | (37.7232806193946, -122.431467482451) | 9 | 7 | 6 | 28861 | 5 | |||
27277 | 18635 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 Reuel Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 0 | 3X3 | 6017095.3922155 | 2096110.4018038 | 37.736478907812 | -122.3833405631 | (37.736478907812, -122.3833405631) | 10 | 3 | 8 | 58 | 1 | ||
27479 | 136226 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1570 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004327.39771 | 2120155.21272 | 37.8017862476969 | -122.429198904827 | (37.8017862476969, -122.429198904827) | 13 | 9 | 1 | 57 | 17 | |||
27515 | 139278 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 725 FULTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004349.2802 | 2111499.4808 | 37.7780210326226 | -122.428505855992 | (37.7780210326226, -122.428505855992) | 7 | 9 | 11 | 28852 | 10 | |||
27533 | 138455 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1901 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002947.3238 | 2114874.0081 | 37.7872071991092 | -122.433596947338 | (37.7872071991092, -122.433596947338) | 13 | 9 | 11 | 29490 | 27 | |||
27648 | 21211 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2392X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||
27834 | 138037 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1928 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002982.5354 | 2114995.4141 | 37.7875425469434 | -122.433483802199 | (37.7875425469434, -122.433483802199) | 13 | 9 | 11 | 29490 | 27 | |||
27855 | 2465 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1832 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2000 12:00:00 AM | 3 | 4X4 | 6003995.9995029 | 2114715.2873188 | 37.7868308367846 | -122.429957429665 | (37.7868308367846, -122.429957429665) | 13 | 9 | 11 | 29490 | 27 | ||
27982 | 85620 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1344 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016632.8917 | 2093635.0593 | 37.729656539473 | -122.384767252586 | (37.729656539473, -122.384767252586) | 10 | 3 | 8 | 58 | 1 | ||
28051 | 240145 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1209 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998178.05243 | 2106154.45126 | 37.7629937870534 | -122.449469012203 | (37.7629937870534, -122.449469012203) | 15 | 5 | 11 | 29492 | 9 | |||
28070 | 120249 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 164 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5988365.91336 | 2114852.64965 | 37.7863104293457 | -122.484043303996 | (37.7863104293457, -122.484043303996) | 11 | 6 | 1 | 55 | 33 | |||
28102 | 4618 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 354 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6010598.00994 | 2118821.58602 | 37.7984774173787 | -122.407405500457 | (37.7984774173787, -122.407405500457) | 3 | 1 | 10 | 308 | 23 | |||
28368 | 255602 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 317 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006745 | 2104248 | 37.7582454635603 | -122.419703539884 | (37.7582454635603, -122.419703539884) | 2 | 4 | 7 | 28859 | 19 | ||||
28462 | 7316 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2000 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6002972.25432 | 2115230.97031 | 37.7881887410682 | -122.433536213059 | (37.7881887410682, -122.433536213059) | 13 | 9 | 1 | 29490 | 27 | |||
28482 | 142842 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1343 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6006739.5174 | 2115575.1482 | 37.7893467921177 | -122.420526537815 | (37.7893467921177, -122.420526537815) | 13 | 9 | 10 | 28858 | 21 | |||
28541 | 51529 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 846 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | 5 | Permit Number 47831 | 6013038.03413 | 2103130.63922 | 37.7555299221754 | -122.397860957035 | (37.7555299221754, -122.397860957035) | 10 | 3 | 8 | 28856 | 29 | ||
28575 | 54817 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1414 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49953 | 6015568.3491 | 2093032.3958 | 37.7279428116622 | -122.388405474303 | (37.7279428116622, -122.388405474303) | 10 | 3 | 8 | 58 | 1 | |
28645 | 111869 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3399x 16TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004303 | 2106535 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | 8 | 4 | 5 | 28862 | 3 | ||||
28692 | 48873 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/1993 12:00:00 AM | 12 | 3x3 | Permit Number 46081 | 6011769.28798 | 2120850.10657 | 37.8041127290715 | -122.40349528428 | (37.8041127290715, -122.40349528428) | 3 | 1 | 10 | 28860 | 6 | |
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 | |||
28751 | 18256 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1850 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2007 12:00:00 AM | 12 | 4X4 | 6003320.917844 | 2114181.6927542 | 37.7853274664658 | -122.432254931219 | (37.7853274664658, -122.432254931219) | 13 | 9 | 11 | 29490 | 13 | ||
28771 | 8049 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 600 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2001 12:00:00 AM | 12 | 3X3 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | 7 | 9 | 11 | 28852 | 41 | ||
28895 | 115389 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 378 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776292 | 6007259.3 | 2096222.3 | 37.7362376572368 | -122.417356112468 | (37.7362376572368, -122.417356112468) | 2 | 7 | 7 | 28859 | 2 | ||
29084 | 95303 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 701 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | ||
29106 | 47638 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 301 Anza St | 3 | 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 | |||
29386 | 8257 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1525 GALVEZ AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/13/1992 12:00:00 AM | 6 | 3x3 | 6016246 | 2097351 | 37.7398383611722 | -122.386363768789 | (37.7398383611722, -122.386363768789) | 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 | |||
29411 | 124324 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 109 Jordan Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5996182.48161 | 2113700.35533 | 37.7835985094544 | -122.45691677945 | (37.7835985094544, -122.45691677945) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||||
29648 | 239342 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 249 Mullen Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010242.33819 | 2100031.51649 | 37.7468643247282 | -122.40731092156 | (37.7468643247282, -122.40731092156) | 2 | 7 | 7 | 28859 | 2 | |||
29821 | 138936 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 611 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004391.0086 | 2110998.5233 | 37.7766478878909 | -122.428325789109 | (37.7766478878909, -122.428325789109) | 7 | 9 | 11 | 28852 | 10 | |||
29832 | 197131 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 Newhall St | 17 | : | Tree | Private 2 | 5 | Width 3ft | 6015885.54456 | 2097735.33833 | 37.740873716654 | -122.38763689115 | (37.740873716654, -122.38763689115) | 10 | 3 | 8 | 58 | 1 | |||
30035 | 53150 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1499@ LANE Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2006 12:00:00 AM | Permit Number 49076 | 6015286.17606683 | 2093519.24782482 | 37.7292639697355 | -122.389414946979 | (37.7292639697355, -122.389414946979) | 10 | 3 | 8 | 58 | 1 | |||
30443 | 136227 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3630 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002616.6752 | 2121115.11425 | 37.804324892641 | -122.435187487615 | (37.804324892641, -122.435187487615) | 13 | 9 | 1 | 57 | 17 | |||
30750 | 239283 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2750 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009688.59129 | 2105501.22435 | 37.7618519115522 | -122.409611726409 | (37.7618519115522, -122.409611726409) | 8 | 4 | 8 | 28859 | 19 | |||
30941 | 136212 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Spruce St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997026.47763 | 2115953.79939 | 37.7898342954728 | -122.454159706 | (37.7898342954728, -122.454159706) | 11 | 6 | 1 | 54 | 31 | |||
31005 | 94179 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 603 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53587 | 6010992.28107 | 2105475.07827 | 37.7618530869812 | -122.405100914986 | (37.7618530869812, -122.405100914986) | 10 | 3 | 8 | 28856 | 29 | |
31021 | 244040 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 540 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5997548.4099 | 2108554.3655 | 37.7695473010692 | -122.451819858751 | (37.7695473010692, -122.451819858751) | 15 | 5 | 11 | 29492 | 9 | |||
31031 | 1693 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 26 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1996 12:00:00 AM | 3 | 3X3 | 6017694.7378197 | 2093654.8040295 | 37.7297694248505 | -122.381097672052 | (37.7297694248505, -122.381097672052) | 10 | 3 | 8 | 58 | 1 | ||
31543 | 159341 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 40 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 01:44:00 PM | 3 | Width 0ft | 5998211.29778 | 2087238.08175 | 37.7110558677139 | -122.447991998028 | (37.7110558677139, -122.447991998028) | 9 | 7 | 6 | 28861 | 25 | ||
31675 | 197094 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6014478.47867 | 2102089.91001 | 37.7527524163908 | -122.392806608832 | (37.7527524163908, -122.392806608832) | 10 | 3 | 8 | 28856 | 29 | |||
31837 | 240162 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 497 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998550.13742 | 2106327.4431 | 37.7634900572362 | -122.448194560431 | (37.7634900572362, -122.448194560431) | 15 | 5 | 11 | 29492 | 9 | |||
32033 | 138074 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1900 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6002997.6045 | 2114890.8811 | 37.7872563808289 | -122.43342419332 | (37.7872563808289, -122.43342419332) | 13 | 9 | 11 | 29490 | 27 | |||
32099 | 41461 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 460 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42046 | 5993018.50469486 | 2090233.49581681 | 37.7189823574514 | -122.466156931137 | (37.7189823574514, -122.466156931137) | 9 | 8 | 6 | 64 | 24 | |||
32131 | 239306 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 130 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006646.90418 | 2105336.48484 | 37.7612286633914 | -122.420120046409 | (37.7612286633914, -122.420120046409) | 2 | 4 | 7 | 28859 | 19 | |||
32162 | 107809 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 174 14TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773719 | 6007550.6 | 2107982.4 | 37.7685446055333 | -122.417182034417 | (37.7685446055333, -122.417182034417) | 8 | 4 | 7 | 28853 | 19 | ||
32287 | 240137 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 466 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6003486.65901 | 2100127.76337 | 37.7467481782042 | -122.430678286872 | (37.7467481782042, -122.430678286872) | 2 | 7 | 5 | 63 | 22 | |||
32346 | 179313 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Yale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006918.39852 | 2093488.03593 | 37.728710780776 | -122.418340943684 | (37.728710780776, -122.418340943684) | 9 | 3 | 7 | 309 | 5 | |||
32452 | 4617 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 348 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1995 12:00:00 AM | 10 | 3x3 | 6010597.9091 | 2118822.5443 | 37.7984800429378 | -122.40740591699 | (37.7984800429378, -122.40740591699) | 3 | 1 | 10 | 308 | 23 | ||
32470 | 110524 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 995X Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2015 12:00:00 AM | 3 | Permit Number 775198 | 6003269.72698 | 2111024.20368 | 37.7766548889563 | -122.432206462364 | (37.7766548889563, -122.432206462364) | 15 | 9 | 11 | 29492 | 10 | ||
32765 | 213953 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994770.43192 | 2090973.10157 | 37.7211140599462 | -122.460154799032 | (37.7211140599462, -122.460154799032) | 9 | 8 | 6 | 28861 | 24 | |||
32780 | 46422 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 708 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2002 12:00:00 AM | 1 | Permit Number 44644 | 5992896.66955 | 2110586.40461 | 37.7748592156207 | -122.468057745767 | (37.7748592156207, -122.468057745767) | 11 | 6 | 2 | 54 | 11 | ||
32894 | 85619 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1338 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016653.5768 | 2093624.593 | 37.7296289450877 | -122.384695012523 | (37.7296289450877, -122.384695012523) | 10 | 3 | 8 | 58 | 1 | ||
32999 | 48812 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.05373 | 2102353.10418 | 37.7534744568981 | -122.392864530587 | (37.7534744568981, -122.392864530587) | 10 | 3 | 8 | 28856 | 29 | ||
33109 | 239244 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1300 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010301.83503 | 2101602.35091 | 37.7511808205419 | -122.407215899201 | (37.7511808205419, -122.407215899201) | 2 | 4 | 7 | 28859 | 19 | |||
33160 | 20136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 890 Steiner St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/11/2011 12:00:00 AM | 3 | 8x4 | Permit Number 54087 | 6003007 | 2111306 | 37.777413731872 | -122.433135450293 | (37.777413731872, -122.433135450293) | 15 | 9 | 11 | 29492 | 10 | |
33350 | 136264 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Montgomery St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6011327.59811 | 2121029.05024 | 37.8045793836809 | -122.405036399426 | (37.8045793836809, -122.405036399426) | 3 | 1 | 10 | 28860 | 6 | |||
33517 | 179311 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 427 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006943.30245 | 2092535.62338 | 37.7260970640242 | -122.418187352968 | (37.7260970640242, -122.418187352968) | 9 | 3 | 7 | 309 | 28 | |||
33520 | 239298 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1475 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 10ft | 6010135.52625 | 2100699.74587 | 37.7486931572616 | -122.407727378721 | (37.7486931572616, -122.407727378721) | 2 | 4 | 7 | 28859 | 19 | |||
33527 | 136257 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2106 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007681.63018 | 2119639.37861 | 37.8005592082118 | -122.417555094503 | (37.8005592082118, -122.417555094503) | 5 | 1 | 1 | 308 | 32 | |||
33554 | 197092 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6014476.97343 | 2102121.40509 | 37.752838811567 | -122.392814017467 | (37.752838811567, -122.392814017467) | 10 | 3 | 8 | 28856 | 29 | |||
33810 | 85643 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1235 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017171.4256 | 2093155.5219 | 37.7283695937915 | -122.382872106202 | (37.7283695937915, -122.382872106202) | 10 | 3 | 8 | 58 | 1 | ||
33924 | 67694 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3330 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1992 12:00:00 AM | 6 | 3x3 | Permit Number 31302 | 5998887.34453115 | 2115637.9553757 | 37.7890736016783 | -122.447698559552 | (37.7890736016783, -122.447698559552) | 13 | 6 | 1 | 54 | 31 | |
33930 | 213991 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1 Merced Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5995344.90173 | 2100199.2685 | 37.7464798897511 | -122.458836668093 | (37.7464798897511, -122.458836668093) | 1 | 8 | 4 | 59 | 40 | |||
33994 | 12670 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1128 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/1998 12:00:00 AM | 6 | 3X3 | 5991921.00031 | 2114824.39199 | 37.786439173997 | -122.471741673868 | (37.786439173997, -122.471741673868) | 11 | 6 | 1 | 54 | 11 | ||
34236 | 213918 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 50 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5996378.46422 | 2106655.73366 | 37.7642670705822 | -122.455729371032 | (37.7642670705822, -122.455729371032) | 15 | 5 | 11 | 29492 | 12 | |||
34480 | 197115 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1231 Rhode Island St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6011991.85547 | 2102642.48446 | 37.7541312380906 | -122.401444683423 | (37.7541312380906, -122.401444683423) | 10 | 3 | 8 | 28856 | 29 | |||
34547 | 93825 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 14 | 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 | ||
34605 | 10379 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1316 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1990 12:00:00 AM | 18 | 3X3 | 5999827.9509 | 2108872.87214 | 37.7705521343685 | -122.44395792635 | (37.7705521343685, -122.44395792635) | 15 | 5 | 11 | 29492 | 9 | ||
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 | |||
34865 | 40635 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2577 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | 1 | Permit Number 41635 | 5999855.0848 | 2113645.9018 | 37.7836592022764 | -122.444207108714 | (37.7836592022764, -122.444207108714) | 15 | 6 | 1 | 29490 | 31 | ||
34959 | 138058 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1908 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002987.8129 | 2114950.6613 | 37.7874199665492 | -122.43346234377 | (37.7874199665492, -122.43346234377) | 13 | 9 | 11 | 29490 | 27 | |||
35078 | 39115 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 501 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50596 | 6006834.26665835 | 2100862.7419909 | 37.7489553490953 | -122.419154691519 | (37.7489553490953, -122.419154691519) | 2 | 4 | 7 | 28859 | 19 | ||
35133 | 36194 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 107 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 39260 | 5997029.24357 | 2115938.23155 | 37.7897917089598 | -122.454149011282 | (37.7897917089598, -122.454149011282) | 11 | 6 | 1 | 54 | 31 | |||
35271 | 111866 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3399x 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004303 | 2106535 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | 8 | 4 | 5 | 28862 | 3 | |||
35353 | 197076 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1101 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6014915.77906 | 2102946.70504 | 37.7551292724085 | -122.391354222641 | (37.7551292724085, -122.391354222641) | 10 | 3 | 8 | 28856 | 29 | |||
35410 | 87680 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.8053691339868 | -122.421720734847 | (37.8053691339868, -122.421720734847) | 5 | 1 | 1 | 28858 | 32 | ||
35420 | 93812 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 1 | 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 | ||
35534 | 140555 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 864 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003696.4035 | 2111458.3246 | 37.7778710601657 | -122.430761450875 | (37.7778710601657, -122.430761450875) | 15 | 9 | 11 | 29492 | 41 | |||
35647 | 34349 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 406 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51609 | 6004013.55416632 | 2096149.85411864 | 37.7358555876111 | -122.428572831878 | (37.7358555876111, -122.428572831878) | 2 | 7 | 5 | 63 | 7 | ||
35912 | 24578 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2301 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/12/1996 12:00:00 AM | 6 | 3x3 | 6002768.23016 | 2116232.67907 | 37.7909275993488 | -122.434313744932 | (37.7909275993488, -122.434313744932) | 13 | 9 | 1 | 29490 | 27 | ||
36008 | 246033 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 17 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998175.5001 | 2108450.8177 | 37.769298881123 | -122.44964332461 | (37.769298881123, -122.44964332461) | 15 | 5 | 11 | 29492 | 9 | |||
36052 | 179295 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 103 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004297.98606 | 2093012.31391 | 37.7272566975202 | -122.42736600014 | (37.7272566975202, -122.42736600014) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
36501 | 8119 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 850X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6003699.00422 | 2111459.33104 | 37.7778739709463 | -122.430752525918 | (37.7778739709463, -122.430752525918) | 15 | 9 | 11 | 29492 | 41 | ||
36615 | 138937 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 609 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004415.7448 | 2111001.1974 | 37.7766566299655 | -122.428240409959 | (37.7766566299655, -122.428240409959) | 7 | 9 | 11 | 28852 | 10 | |||
37197 | 179291 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 65 Badger St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002393.53271 | 2094418.30005 | 37.731009322903 | -122.434050139316 | (37.731009322903, -122.434050139316) | 9 | 7 | 5 | 28861 | 25 | |||
37445 | 118287 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 240 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2.5 | 6006177 | 2111293 | 37.7775573470216 | -122.422168438332 | (37.7775573470216, -122.422168438332) | 7 | 9 | 11 | 28852 | 10 | ||||
37453 | 16492 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 305X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016524.6681965 | 2098330.497802 | 37.7425432844059 | -122.385468484111 | (37.7425432844059, -122.385468484111) | 10 | 3 | 8 | 58 | 1 | ||
37483 | 85089 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
37742 | 7193 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 898 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1992 12:00:00 AM | 6 | 3X3 | 6003489.55797 | 2111353.68492 | 37.7775720243799 | -122.431469529604 | (37.7775720243799, -122.431469529604) | 7 | 9 | 11 | 29492 | 10 | ||
37745 | 15619 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3517 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2001 12:00:00 AM | 6 | 3X3 | 6005685.7885 | 2097881.8817 | 37.7407058402708 | -122.422914311238 | (37.7407058402708, -122.422914311238) | 2 | 7 | 7 | 28859 | 2 | ||
37749 | 179298 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Peru Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004373.55102 | 2093025.79015 | 37.7272979737044 | -122.427105731855 | (37.7272979737044, -122.427105731855) | 9 | 7 | 6 | 28861 | 5 | |||
37770 | 15611 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3361 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2001 12:00:00 AM | 7 | 3X3 | 6006103.7046 | 2098658.8645 | 37.7428628326579 | -122.421524482148 | (37.7428628326579, -122.421524482148) | 2 | 7 | 7 | 28859 | 2 | ||
37783 | 67598 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3320 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/1992 12:00:00 AM | 5 | Permit Number 31166 | 5998906.2009 | 2115636.68755 | 37.7890711982373 | -122.447633227902 | (37.7890711982373, -122.447633227902) | 13 | 6 | 1 | 54 | 31 | ||
37817 | 248302 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3165 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006787.2124 | 2099920.739 | 37.746366172175 | -122.419250592102 | (37.746366172175, -122.419250592102) | 2 | 7 | 7 | 28859 | 2 | |||
38016 | 239368 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 7 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004707.84944 | 2103578.58278 | 37.7562924348615 | -122.426701228489 | (37.7562924348615, -122.426701228489) | 2 | 4 | 5 | 28862 | 22 | |||
38017 | 122096 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 515 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990911.76477 | 2111862.01127 | 37.7782468532741 | -122.475017013162 | (37.7782468532741, -122.475017013162) | 11 | 6 | 2 | 54 | 26 | |||
38069 | 117046 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2205x Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6002022.6426 | 2114300.8047 | 37.7855808202172 | -122.436755092227 | (37.7855808202172, -122.436755092227) | 13 | 6 | 11 | 29490 | 13 |
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) );