trees
254 rows where qSpecies_id = 78 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 155357 | 29644 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X La Salle Ave | 3 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015992.6911276 | 2095862.2429535 | 37.735736511316 | -122.38713579848 | (37.735736511316, -122.38713579848) | 10 | 3 | 8 | 58 | 1 | ||
| 20823 | 23388 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 6 | G | 6006302.3156668 | 2115604.1529311 | 37.789401783497 | -122.42204126893 | (37.789401783497, -122.42204126893) | 13 | 9 | 10 | 28858 | 21 | ||
| 56994 | 23390 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 12/09/2003 12:00:00 AM | 6 | 9 | 6006302.3156668 | 2115604.1529311 | 37.789401783497 | -122.42204126893 | (37.789401783497, -122.42204126893) | 13 | 9 | 10 | 28858 | 21 | ||
| 153438 | 23389 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006261.55669 | 2115711.13882 | 37.7896932412903 | -122.422189894555 | (37.7896932412903, -122.422189894555) | 13 | 9 | 1 | 28858 | 21 | |||
| 91055 | 249487 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 1 | Median : Yard | Tree | DPW 1 | 13 | 6006262.64335 | 2115713.01946 | 37.7896984663527 | -122.422186268479 | (37.7896984663527, -122.422186268479) | 13 | 9 | 1 | 28858 | 21 | ||||
| 92608 | 136294 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 6 | Median : Yard | Tree | DPW 1 | 14 | 6006242.09436 | 2115852.50489 | 37.7900802996014 | -122.422267280337 | (37.7900802996014, -122.422267280337) | 13 | 9 | 1 | 28858 | 21 | ||||
| 111813 | 249489 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 3 | Median : Yard | Tree | DPW 1 | 11 | 6006246.93776 | 2115807.86331 | 37.7899579981201 | -122.422247349544 | (37.7899579981201, -122.422247349544) | 13 | 9 | 1 | 28858 | 21 | ||||
| 171090 | 249490 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 4 | Median : Yard | Tree | DPW 1 | 12 | 6006241.6595 | 2115852.26392 | 37.7900796134287 | -122.422268767791 | (37.7900796134287, -122.422268767791) | 13 | 9 | 1 | 28858 | 21 | ||||
| 186305 | 136293 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 5 | Median : Yard | Tree | DPW 1 | 11 | 6006248.16207 | 2115803.32411 | 37.7899456036636 | -122.422242790899 | (37.7899456036636, -122.422242790899) | 13 | 9 | 1 | 28858 | 21 | ||||
| 25983 | 14895 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 151 Mendell St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2000 12:00:00 AM | 3 | 3x3 | 6017124.74499 | 2098611.99106 | 37.7433493901711 | -122.383413165805 | (37.7433493901711, -122.383413165805) | 10 | 3 | 8 | 58 | 1 | ||
| 38770 | 197242 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 151 Mendell St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6017080.03361 | 2098493.68243 | 37.7430220675307 | -122.383559533147 | (37.7430220675307, -122.383559533147) | 10 | 3 | 8 | 58 | 1 | |||
| 83689 | 14891 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 151 Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/2008 12:00:00 AM | 3 | 3x3 | 6017309.26732 | 2098441.11643 | 37.7428903993232 | -122.382763240232 | (37.7428903993232, -122.382763240232) | 10 | 3 | 8 | 58 | 1 | ||
| 122943 | 14893 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 151 Mendell St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2008 12:00:00 AM | 3 | 3x3 | 6017107.5762 | 2098575.41356 | 37.7432480069006 | -122.38346998587 | (37.7432480069006, -122.38346998587) | 10 | 3 | 8 | 58 | 1 | ||
| 170929 | 14896 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 151 Mendell St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/15/2016 12:00:00 AM | 3 | 3x3 | 6017148.9857 | 2098654.51037 | 37.7434674792458 | -122.383332305946 | (37.7434674792458, -122.383332305946) | 10 | 3 | 8 | 58 | 1 | ||
| 13584 | 170477 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 17 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6003910.26031 | 2094625.94541 | 37.7316654323041 | -122.428821353234 | (37.7316654323041, -122.428821353234) | 9 | 7 | 5 | 28861 | 25 | |||
| 51588 | 14901 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 175 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2008 12:00:00 AM | 12 | 3x3 | 6017044.13522 | 2098333.33165 | 37.7425797926155 | -122.383672499702 | (37.7425797926155, -122.383672499702) | 10 | 3 | 8 | 58 | 1 | ||
| 15199 | 778 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1800X 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 5984768.5556 | 2102340.232 | 37.7517447878795 | -122.49556583439 | (37.7517447878795, -122.49556583439) | 1 | 8 | 3 | 56 | 35 | ||
| 149866 | 240363 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 19 Ohlone Way | 1 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002113.49716 | 2096265.44164 | 37.7360652530044 | -122.435150333941 | (37.7360652530044, -122.435150333941) | 2 | 7 | 5 | 63 | 7 | |||
| 179909 | 14923 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 190 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/2015 08:59:00 AM | 3 | 3x3 | 6016976.73758 | 2098306.80908 | 37.7425032414108 | -122.383903696919 | (37.7425032414108, -122.383903696919) | 10 | 3 | 8 | 58 | 1 | ||
| 50276 | 104601 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1945 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770083 | 6007231.00881 | 2119029.96908 | 37.7988605570185 | -122.419071181514 | (37.7988605570185, -122.419071181514) | 5 | 1 | 10 | 28858 | 32 | |
| 61724 | 104602 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1945 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770083 | 6007233.09491 | 2119016.60883 | 37.7988239906011 | -122.41906301476 | (37.7988239906011, -122.41906301476) | 5 | 1 | 10 | 28858 | 32 | |
| 71707 | 104600 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1945 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770083 | 6007230.70015 | 2119043.68461 | 37.7988981990374 | -122.419073222948 | (37.7988981990374, -122.419073222948) | 5 | 1 | 10 | 28858 | 32 | |
| 38964 | 29684 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2000X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 24 | 6006028.67336 | 2117355.72849 | 37.7941957348865 | -122.423112593587 | (37.7941957348865, -122.423112593587) | 13 | 9 | 10 | 28858 | 32 | ||||
| 102906 | 29780 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2000X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 03/12/2006 12:00:00 AM | 4 | 5x5 | 6006071.7874482 | 2117255.4874462 | 37.7939229310388 | -122.422956286012 | (37.7939229310388, -122.422956286012) | 13 | 9 | 10 | 28858 | 32 | ||
| 151505 | 29785 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2000x Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 03/12/2006 12:00:00 AM | 4 | 5x5 | 6006071.7874482 | 2117255.4874462 | 37.7939229310388 | -122.422956286012 | (37.7939229310388, -122.422956286012) | 13 | 9 | 10 | 28858 | 32 | ||
| 34475 | 14945 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 200X Mendell St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 6016835.65669 | 2097927.0465 | 37.7414526902904 | -122.384365073909 | (37.7414526902904, -122.384365073909) | 10 | 3 | 8 | 58 | 1 | ||
| 63088 | 14944 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 200X Mendell St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6016843.84768 | 2097941.18235 | 37.7414919573859 | -122.384337736299 | (37.7414919573859, -122.384337736299) | 10 | 3 | 8 | 58 | 1 | ||
| 158925 | 197241 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 201 Mendell St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6016985.47526 | 2098058.34628 | 37.7418214959701 | -122.383856188014 | (37.7418214959701, -122.383856188014) | 10 | 3 | 8 | 58 | 1 | |||
| 19437 | 3542 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 201X Cargo Way | 52 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018537.99972 | 2097717.76917 | 37.7409720404334 | -122.378464368331 | (37.7409720404334, -122.378464368331) | 10 | 3 | 8 | 58 | 1 | ||
| 154283 | 3521 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 201X Cargo Way | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6018183.10085 | 2097983.12019 | 37.7416810722141 | -122.379709922198 | (37.7416810722141, -122.379709922198) | 10 | 3 | 8 | 58 | 1 | |||
| 1244 | 27591 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2100X San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 06/21/2001 12:00:00 AM | 3 | 3x3 | 6009789.2811665 | 2096218.949435 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | 10 | 7 | 7 | 309 | 2 | ||
| 76183 | 27589 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2100X San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 06/21/2001 12:00:00 AM | 3 | 3X3 | 6009789.2811665 | 2096218.949435 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | 10 | 7 | 7 | 309 | 2 | ||
| 88124 | 27588 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2100X San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 06/21/2001 12:00:00 AM | 3 | 3X3 | 6009789.2811665 | 2096218.949435 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | 10 | 7 | 7 | 309 | 2 | ||
| 159213 | 27590 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2100X San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 06/21/2001 12:00:00 AM | 3 | 3X3 | 6009789.2811665 | 2096218.949435 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | 10 | 7 | 7 | 309 | 2 | ||
| 166245 | 27592 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2100X San Bruno Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 06/21/2001 12:00:00 AM | 3 | 3X3 | 6009789.2811665 | 2096218.949435 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | 10 | 7 | 7 | 309 | 2 | ||
| 87659 | 21043 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2101X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
| 15250 | 222585 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 219 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6001765.70571 | 2104562.10445 | 37.7588261686132 | -122.436946567843 | (37.7588261686132, -122.436946567843) | 2 | 4 | 5 | 28862 | 3 | |||
| 18244 | 222586 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 219 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6001763.88203 | 2104576.51068 | 37.7588656209757 | -122.436953906316 | (37.7588656209757, -122.436953906316) | 2 | 4 | 5 | 28862 | 3 | |||
| 27247 | 93191 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 220 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x10 | 5994811.8 | 2087851.3 | 37.7125447127349 | -122.459785791066 | (37.7125447127349, -122.459785791066) | 9 | 8 | 6 | 28861 | 24 | |||
| 12987 | 27593 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2200X San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2001 12:00:00 AM | 12 | 3X3 | 6010149.0566544 | 2095763.2891254 | 37.7351394742744 | -122.407332636882 | (37.7351394742744, -122.407332636882) | 10 | 7 | 7 | 309 | 28 | ||
| 33402 | 27596 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2200X San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/20/2003 12:00:00 AM | 6 | 3X3 | 6010149.0566544 | 2095763.2891254 | 37.7351394742744 | -122.407332636882 | (37.7351394742744, -122.407332636882) | 10 | 7 | 7 | 309 | 28 | ||
| 60368 | 27594 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2200X San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2001 12:00:00 AM | 16 | 3X3 | 6010149.05665 | 2095763.28912 | 37.7351394742594 | -122.407332636897 | (37.7351394742594, -122.407332636897) | 10 | 7 | 7 | 309 | 28 | ||
| 112325 | 27595 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2200X San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2001 12:00:00 AM | 8 | 3X3 | 6010149.0566544 | 2095763.2891254 | 37.7351394742744 | -122.407332636882 | (37.7351394742744, -122.407332636882) | 10 | 7 | 7 | 309 | 28 | ||
| 75037 | 214008 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 222 Sadowa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994773.56041 | 2087779.1496 | 37.7123444055547 | -122.459912734779 | (37.7123444055547, -122.459912734779) | 9 | 8 | 6 | 28861 | 24 | |||
| 52600 | 179364 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010224.85869 | 2095626.21613 | 37.7347673433273 | -122.407060901965 | (37.7347673433273, -122.407060901965) | 10 | 3 | 7 | 309 | 28 | |||
| 92011 | 179362 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010207.20881 | 2095669.3235 | 37.7348847192535 | -122.407124961546 | (37.7348847192535, -122.407124961546) | 10 | 3 | 7 | 309 | 28 | |||
| 144852 | 179366 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010245.15068 | 2095586.70884 | 37.7346600002662 | -122.406987961537 | (37.7346600002662, -122.406987961537) | 10 | 3 | 7 | 309 | 28 | |||
| 148351 | 179365 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010237.42069 | 2095603.49038 | 37.7347056462347 | -122.407015869312 | (37.7347056462347, -122.407015869312) | 10 | 3 | 7 | 309 | 28 | |||
| 154737 | 179363 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010218.26631 | 2095644.80145 | 37.7348180057356 | -122.407085003796 | (37.7348180057356, -122.407085003796) | 10 | 3 | 7 | 309 | 28 | |||
| 60358 | 179368 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2302 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010304.52848 | 2095452.39798 | 37.7342945337677 | -122.406773208834 | (37.7342945337677, -122.406773208834) | 10 | 3 | 7 | 309 | 28 | |||
| 100005 | 179370 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2302 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010321.94566 | 2095411.61629 | 37.7341835304417 | -122.406710118682 | (37.7341835304417, -122.406710118682) | 10 | 3 | 7 | 309 | 28 | |||
| 119990 | 179367 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2302 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010293.44641 | 2095472.02067 | 37.7343477934225 | -122.406812905791 | (37.7343477934225, -122.406812905791) | 10 | 3 | 7 | 309 | 28 | |||
| 132053 | 179369 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2302 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010313.94209 | 2095431.38029 | 37.7342373503731 | -122.406739182082 | (37.7342373503731, -122.406739182082) | 10 | 3 | 7 | 309 | 28 | |||
| 1119 | 113031 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 251 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 14 | 3x3 | 5993971.49407 | 2113867.66105 | 37.7839306754778 | -122.464578040665 | (37.7839306754778, -122.464578040665) | 11 | 6 | 2 | 54 | 11 | |||
| 57758 | 23507 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2600X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 9 | 6005789.5650879 | 2119282.8766016 | 37.799473699725 | -122.424077049734 | (37.799473699725, -122.424077049734) | 13 | 9 | 1 | 28858 | 32 | |||
| 97214 | 136295 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2600x Van Ness Ave | 4 | Median : Yard | Tree | DPW 1 | 16 | Width 8ft | 6005728.53037 | 2119520.31629 | 37.8001222024312 | -122.424305148569 | (37.8001222024312, -122.424305148569) | 13 | 9 | 1 | 28858 | 32 | |||
| 121021 | 14957 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 275 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2007 12:00:00 AM | 3 | 3X3 | 6016965.76785 | 2098027.33997 | 37.7417352694795 | -122.383922171933 | (37.7417352694795, -122.383922171933) | 10 | 3 | 8 | 58 | 1 | ||
| 77807 | 13296 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2770 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2016 12:00:00 AM | 2 | 3X3 | Permit Number 770074 | 5999335.52143 | 2119120.50059 | 37.7986613518083 | -122.446398566642 | (37.7986613518083, -122.446398566642) | 13 | 9 | 1 | 57 | 17 | |
| 13875 | 226227 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2955 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2020 12:00:00 AM | 3 | 6x6 | Permit Number 787786 | 6008507.27789 | 2103281.70589 | 37.755691354088 | -122.413540452526 | (37.755691354088, -122.413540452526) | 2 | 4 | 7 | 28859 | 19 | |
| 23481 | 29669 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 300X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 3 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.419772706207 | (37.778265495762, -122.419772706207) | 7 | 9 | 9 | 28852 | 36 | ||||
| 101457 | 23180 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 300X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 3 | 9 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.419772706207 | (37.778265495762, -122.419772706207) | 7 | 9 | 9 | 28852 | 36 | |||
| 178117 | 29670 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 300X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.419772706207 | (37.778265495762, -122.419772706207) | 7 | 9 | 9 | 28852 | 36 | ||||
| 39591 | 197240 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 301 Mendell St | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6016921.73157 | 2097930.91265 | 37.7414680650873 | -122.384067722948 | (37.7414680650873, -122.384067722948) | 10 | 3 | 8 | 58 | 1 | |||
| 68597 | 23583 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3100X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 24 | 9 | 6005493.5455 | 2121226.72691 | 37.8047942964921 | -122.425239779807 | (37.8047942964921, -122.425239779807) | 5 | 1 | 1 | 28858 | 32 | |||
| 72754 | 23582 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3100X Van Ness Ave | 5 | Median : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005497.77155 | 2121198.52122 | 37.8047170896849 | -122.425223146826 | (37.8047170896849, -122.425223146826) | 5 | 1 | 1 | 28858 | 32 | ||
| 119078 | 23581 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3100X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005553.2513401 | 2120985.4040713 | 37.8041350589608 | -122.425015980687 | (37.8041350589608, -122.425015980687) | 5 | 1 | 1 | 28858 | 32 | ||
| 14449 | 260124 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 3195X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2019 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 69653 | 14961 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 355 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016837.91572 | 2097829.62207 | 37.7411853074635 | -122.384350479174 | (37.7411853074635, -122.384350479174) | 10 | 3 | 8 | 58 | 1 | |||
| 541 | 225969 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3599 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6005840.01853 | 2101965.47506 | 37.7519271589233 | -122.422671163153 | (37.7519271589233, -122.422671163153) | 2 | 4 | 5 | 28859 | 19 | |||
| 69328 | 1227 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3600X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/2004 12:00:00 AM | 8 | 3X5 | 5993524.0546702 | 2087589.4711722 | 37.7117516532039 | -122.464217607089 | (37.7117516532039, -122.464217607089) | 9 | 8 | 4 | 64 | 24 | ||
| 19880 | 243367 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 3686 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782225 | 6005735.65581 | 2104339.74223 | 37.7584404565742 | -122.423200817986 | (37.7584404565742, -122.423200817986) | 2 | 4 | 5 | 28859 | 19 | |
| 189645 | 224739 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 3686 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782225 | 6005758.94029 | 2104340.80798 | 37.7584446968891 | -122.423120365536 | (37.7584446968891, -122.423120365536) | 2 | 4 | 5 | 28859 | 19 | |
| 46463 | 1243 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3700X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/2004 12:00:00 AM | 3 | 3X5 | 5993218.71389 | 2087629.40018 | 37.7118436847502 | -122.465275838287 | (37.7118436847502, -122.465275838287) | 9 | 8 | 4 | 64 | 24 | ||
| 189970 | 1241 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3702X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3X5 | 5992970.26911 | 2087627.91348 | 37.711825271896 | -122.466134417365 | (37.711825271896, -122.466134417365) | 9 | 8 | 4 | 64 | 24 | |||
| 19431 | 242096 | Planning Code 138.1 required 2 | Quercus suber :: Cork Oak 78 | 3721 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2019 12:00:00 AM | 3 | 4x4 | Permit Number 769571 | 6003563.92038 | 2103590.2718 | 37.756259789464 | -122.430658162741 | (37.756259789464, -122.430658162741) | 2 | 4 | 5 | 28862 | 22 | |
| 161719 | 14971 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 400X Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 6016631.74011 | 2097650.02311 | 37.7406807626184 | -122.385050857322 | (37.7406807626184, -122.385050857322) | 10 | 3 | 8 | 58 | 1 | ||
| 56405 | 201668 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 08th St | 4 | Front Yard : Yard | Tree | Private 2 | 11 | 6010243.64351 | 2109736.80769 | 37.7735129403066 | -122.407990719097 | (37.7735129403066, -122.407990719097) | 14 | 2 | 9 | 28853 | 34 | ||||
| 70732 | 201670 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 08th St | 6 | Front Yard : Yard | Tree | Private 2 | 10 | 6010207.48998 | 2109776.17317 | 37.7736190045563 | -122.408118556848 | (37.7736190045563, -122.408118556848) | 14 | 2 | 9 | 28853 | 34 | ||||
| 104712 | 201665 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 08th St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 6010317.6274 | 2109676.05195 | 37.7733502610444 | -122.407730511973 | (37.7733502610444, -122.407730511973) | 14 | 2 | 9 | 28853 | 34 | ||||
| 178580 | 201667 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 08th St | 3 | Front Yard : Yard | Tree | Private 2 | 5 | 6010257.0488 | 2109725.83328 | 37.7734835576458 | -122.407943573961 | (37.7734835576458, -122.407943573961) | 14 | 2 | 9 | 28853 | 34 | ||||
| 23991 | 197244 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Mendell St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6016639.49339 | 2097549.35813 | 37.7404047858594 | -122.385017037417 | (37.7404047858594, -122.385017037417) | 10 | 3 | 8 | 58 | 1 | |||
| 75684 | 197245 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Mendell St | 5 | : | Tree | Private 2 | 6 | Width 3ft | 6016656.39457 | 2097572.22784 | 37.7404685163083 | -122.38496019216 | (37.7404685163083, -122.38496019216) | 10 | 3 | 8 | 58 | 1 | |||
| 81664 | 197243 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Mendell St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6016629.41985 | 2097534.84725 | 37.7403643847096 | -122.385050857321 | (37.7403643847096, -122.385050857321) | 10 | 3 | 8 | 58 | 1 | |||
| 45458 | 136290 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006768.37866 | 2112062.50938 | 37.7797035719992 | -122.420177283766 | (37.7797035719992, -122.420177283766) | 7 | 9 | 9 | 28852 | 36 | |||
| 67441 | 136291 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006783.12153 | 2111963.42533 | 37.779432341874 | -122.420119247825 | (37.779432341874, -122.420119247825) | 7 | 9 | 9 | 28852 | 36 | |||
| 97907 | 136292 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006812.66695 | 2111768.16026 | 37.7788978558793 | -122.420003176823 | (37.7788978558793, -122.420003176823) | 7 | 9 | 9 | 28852 | 36 | |||
| 95650 | 240351 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4090 20th St | 1 | : Yard | Tree | Private 2 | 22 | Width 3ft | 6003153.88022 | 2104182.56452 | 37.7578628454134 | -122.432118516979 | (37.7578628454134, -122.432118516979) | 2 | 4 | 5 | 28862 | 3 | |||
| 103279 | 113196 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4090X 20th St | 1 | Median : Yard | Tree | DPW 1 | 6003325.96697 | 2104184.75857 | 37.7578786248615 | -122.431523525971 | (37.7578786248615, -122.431523525971) | 2 | 4 | 5 | 28862 | 3 | |||||
| 14698 | 53201 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 428@ CLEMENT 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2006 12:00:00 AM | 8 | Permit Number 49135 | 5983471.70703 | 2112915.4813 | 37.7807053822414 | -122.50083241779 | (37.7807053822414, -122.50083241779) | 11 | 6 | 2 | 55 | 26 | ||
| 565 | 170476 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 46 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6003788.04729 | 2094625.21712 | 37.7316565146416 | -122.429243816075 | (37.7316565146416, -122.429243816075) | 9 | 7 | 5 | 28861 | 25 | ||
| 77040 | 240349 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4736 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 4ft | 5998465.34509 | 2105692.76775 | 37.7617425503974 | -122.448442119502 | (37.7617425503974, -122.448442119502) | 15 | 5 | 11 | 29492 | 9 | |||
| 193294 | 98540 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 4736 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 5998512 | 2105692 | 37.7617431097225 | -122.448280704282 | (37.7617431097225, -122.448280704282) | 15 | 5 | 11 | 29492 | 9 | ||||
| 72255 | 240350 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4746 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5998436.06596 | 2105691.7221 | 37.7617380052332 | -122.448543308522 | (37.7617380052332, -122.448543308522) | 15 | 5 | 11 | 29492 | 9 | |||
| 68533 | 14977 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 495X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016593.75941 | 2097492.39708 | 37.7402458525216 | -122.385171201108 | (37.7402458525216, -122.385171201108) | 10 | 3 | 8 | 58 | 1 | ||
| 170483 | 14981 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 495X Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2008 12:00:00 AM | 3 | 3X3 | 6016593.75941 | 2097492.39708 | 37.7402458525216 | -122.385171201108 | (37.7402458525216, -122.385171201108) | 10 | 3 | 8 | 58 | 1 | ||
| 32722 | 14877 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6017083.42225 | 2098683.73205 | 37.7435440924819 | -122.383561044027 | (37.7435440924819, -122.383561044027) | 10 | 3 | 8 | 58 | 1 | |||
| 36718 | 14879 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017057.00036 | 2098638.4724 | 37.7434183582727 | -122.383649254902 | (37.7434183582727, -122.383649254902) | 10 | 3 | 8 | 58 | 1 | |||
| 89094 | 14884 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6017061.80062 | 2098665.73573 | 37.7434934831644 | -122.383634554347 | (37.7434934831644, -122.383634554347) | 10 | 3 | 8 | 58 | 1 | ||
| 116959 | 14878 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6017061.80062 | 2098665.73573 | 37.7434934831644 | -122.383634554347 | (37.7434934831644, -122.383634554347) | 10 | 3 | 8 | 58 | 1 | ||
| 159580 | 14882 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017027.26925 | 2098565.83494 | 37.7432172671691 | -122.383747002247 | (37.7432172671691, -122.383747002247) | 10 | 3 | 8 | 58 | 1 |
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) );