trees
254 rows where qSpecies_id = 78 sorted by Latitude 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |
| 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 | |
| 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 | ||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||
| 191304 | 23366 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1356X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 6 | 9 | 6006391.3825894 | 2115174.2493055 | 37.7882263975959 | -122.421702559542 | (37.7882263975959, -122.421702559542) | 13 | 9 | 10 | 28858 | 21 | ||
| 144179 | 249478 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1300x Van Ness Ave | 2 | Median : Yard | Tree | DPW 1 | 12 | 6006350.91475 | 2115079.54882 | 37.7879640914292 | -122.421835842261 | (37.7879640914292, -122.421835842261) | 13 | 9 | 1 | 28858 | 21 | ||||
| 179134 | 249476 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Van Ness Ave | 3 | Median : Yard | Tree | DPW 1 | 16 | 6006383.25331 | 2114827.68427 | 37.7872743572577 | -122.421706060208 | (37.7872743572577, -122.421706060208) | 13 | 9 | 1 | 28858 | 21 | ||||
| 194279 | 249475 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Van Ness Ave | 2 | Median : Yard | Tree | DPW 1 | 18 | Permit Number 787880 | 6006389.52859 | 2114780.40651 | 37.7871448980627 | -122.421680989782 | (37.7871448980627, -122.421680989782) | 13 | 9 | 1 | 28858 | 21 | |||
| 77034 | 23354 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1250X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 3 | 9 | 6006448.1236467 | 2114767.6788933 | 37.7871132551315 | -122.421477359088 | (37.7871132551315, -122.421477359088) | 13 | 9 | 10 | 28858 | 21 | ||
| 137610 | 23355 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1250X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12/10/2003 12:00:00 AM | 3 | 9 | 6006448.1236467 | 2114767.6788933 | 37.7871132551315 | -122.421477359088 | (37.7871132551315, -122.421477359088) | 13 | 9 | 10 | 28858 | 21 | ||
| 36962 | 249474 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Van Ness Ave | 1 | Median : Yard | Tree | DPW 1 | 8 | 6006395.0323 | 2114736.35179 | 37.7870242450239 | -122.421658817911 | (37.7870242450239, -122.421658817911) | 13 | 9 | 1 | 28858 | 21 | ||||
| 165987 | 99962 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1202X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 8 | 9x5 | 6006588.9 | 2114703 | 37.7869435992692 | -122.420985708971 | (37.7869435992692, -122.420985708971) | 13 | 9 | 10 | 28858 | 21 | |||
| 48159 | 23340 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1202X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 8 | 9x5 | 6006445.1571238 | 2114583.3806769 | 37.7866070504124 | -122.42147452901 | (37.7866070504124, -122.42147452901) | 13 | 9 | 10 | 28858 | 36 | ||
| 108620 | 23339 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1202X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 6 | 9x5 | 6006445.1571238 | 2114583.3806769 | 37.7866070504124 | -122.42147452901 | (37.7866070504124, -122.42147452901) | 13 | 9 | 10 | 28858 | 36 | ||
| 164558 | 249473 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1100x Van Ness Ave | 1 | Median : Yard | Tree | DPW 1 | 14 | 6006432.64407 | 2114489.3949 | 37.7863482830936 | -122.421511143829 | (37.7863482830936, -122.421511143829) | 13 | 9 | 11 | 28858 | 41 | ||||
| 70792 | 23332 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1142X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 3 | 9 | 6006495.0913449 | 2114431.1382441 | 37.7861918455124 | -122.42129095338 | (37.7861918455124, -122.42129095338) | 13 | 9 | 10 | 28858 | 36 | ||
| 74430 | 23333 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1142X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 3 | 9 | 6006495.0913449 | 2114431.1382441 | 37.7861918455124 | -122.42129095338 | (37.7861918455124, -122.42129095338) | 13 | 9 | 10 | 28858 | 36 | ||
| 158904 | 23324 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1108X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 3 | 3x3 | 6006505.7907443 | 2114265.3196899 | 37.7857371517591 | -122.421242157065 | (37.7857371517591, -122.421242157065) | 13 | 9 | 9 | 28858 | 36 | ||
| 187789 | 23323 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1108X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 3 | 3x3 | 6006505.7907443 | 2114265.3196899 | 37.7857371517591 | -122.421242157065 | (37.7857371517591, -122.421242157065) | 13 | 9 | 9 | 28858 | 36 | ||
| 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 | |||
| 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 | ||
| 38940 | 95980 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 6700 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 6 | 5986162.43558 | 2112587.6567 | 37.7799628795758 | -122.491499884152 | (37.7799628795758, -122.491499884152) | 11 | 6 | 2 | 55 | 26 | |||
| 19693 | 119298 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 6700x Geary Blvd | 7 | Median : Yard | Tree | DPW 1 | 8 | 5986043.64284 | 2112521.46731 | 37.7797741997502 | -122.491905961239 | (37.7797741997502, -122.491905961239) | 11 | 6 | 2 | 55 | 26 | ||||
| 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 | |||
| 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 | ||||
| 13469 | 260844 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 651 06th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 5994076.91489 | 2111079.35374 | 37.7762808110216 | -122.464010852721 | (37.7762808110216, -122.464010852721) | 11 | 6 | 2 | 54 | 11 | ||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 1709 | 224383 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 125 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2019 12:00:00 AM | 3 | 5x5 | Permit Number 778492 | 6006444.85004 | 2107119.85754 | 37.7661139992865 | -122.420945489154 | (37.7661139992865, -122.420945489154) | 8 | 4 | 7 | 28853 | 19 | |
| 82383 | 197225 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015963.59101 | 2106011.38061 | 37.7636023160031 | -122.387944392722 | (37.7636023160031, -122.387944392722) | 14 | 3 | 8 | 28856 | 29 | |||
| 163343 | 197226 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015965.03581 | 2105988.90006 | 37.7635406692923 | -122.387937826789 | (37.7635406692923, -122.387937826789) | 14 | 3 | 8 | 28856 | 29 | |||
| 109059 | 197227 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015965.05283 | 2105966.21151 | 37.7634783723591 | -122.38793618463 | (37.7634783723591, -122.38793618463) | 14 | 3 | 8 | 28856 | 29 | |||
| 139403 | 100171 | Significant Tree 6 | Quercus suber :: Cork Oak 78 | 109 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996563.8 | 2106359.1 | 37.763463224844 | -122.455066914463 | (37.763463224844, -122.455066914463) | 15 | 5 | 11 | 29492 | 12 | |||||
| 146620 | 197228 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015966.4036 | 2105950.82285 | 37.7634361932415 | -122.387930438833 | (37.7634361932415, -122.387930438833) | 14 | 3 | 8 | 28856 | 29 | |||
| 147723 | 197229 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015967.79725 | 2105937.55997 | 37.7633998534335 | -122.387924693077 | (37.7633998534335, -122.387924693077) | 14 | 3 | 8 | 28856 | 29 | |||
| 11056 | 111333 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
| 16757 | 111332 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
| 34139 | 111331 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
| 47021 | 111329 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
| 63631 | 111325 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
| 69479 | 111326 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
| 87605 | 111327 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
| 106469 | 111328 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
| 169584 | 111330 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
| 109788 | 197230 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015968.5174 | 2105926.2015 | 37.7633687054139 | -122.387921409661 | (37.7633687054139, -122.387921409661) | 14 | 3 | 8 | 28856 | 29 | |||
| 166919 | 197231 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015968.40199 | 2105908.71514 | 37.7633206852369 | -122.387920588579 | (37.7633206852369, -122.387920588579) | 14 | 3 | 8 | 28856 | 29 | |||
| 90584 | 197232 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015969.52981 | 2105893.92675 | 37.7632801419786 | -122.38791565581 | (37.7632801419786, -122.38791565581) | 14 | 3 | 8 | 28856 | 29 | |||
| 194494 | 264749 | Section 806 (d) 5 | Quercus suber :: Cork Oak 78 | 1339 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2021 12:00:00 AM | 3 | 3x3 | Permit Number 785207 | 5991088 | 2106284 | 37.7629413570223 | -122.474000279679 | (37.7629413570223, -122.474000279679) | 1 | 8 | 11 | 56 | 12 | |
| 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 | ||||
| 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 | |||
| 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 | |||
| 129947 | 240359 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 24 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6004303.32084 | 2105026.7227 | 37.7602458051206 | -122.428203429952 | (37.7602458051206, -122.428203429952) | 2 | 4 | 5 | 28862 | 3 | |||
| 30444 | 240358 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 23 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6004302.67089 | 2105008.50736 | 37.760195753352 | -122.428204379638 | (37.760195753352, -122.428204379638) | 2 | 4 | 5 | 28862 | 3 | |||
| 77159 | 240356 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 19 | Front Yard : Yard | Tree | Private 2 | 18 | Width 3ft | 6004321.88535 | 2104984.17972 | 37.760130042589 | -122.428136192158 | (37.760130042589, -122.428136192158) | 2 | 4 | 5 | 28862 | 3 | |||
| 70692 | 240357 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 20 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6004316.61445 | 2104979.98621 | 37.7601182299832 | -122.428154122837 | (37.7601182299832, -122.428154122837) | 2 | 4 | 5 | 28862 | 3 | |||
| 29767 | 240355 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 18 | Front Yard : Yard | Tree | Private 2 | 19 | Width 3ft | 6004321.65497 | 2104972.99929 | 37.7600993307501 | -122.428136192147 | (37.7600993307501, -122.428136192147) | 2 | 4 | 5 | 28862 | 3 | |||
| 30660 | 240354 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 17 | Front Yard : Yard | Tree | Private 2 | 13 | Width 3ft | 6004324.4915 | 2104963.90622 | 37.7600745238281 | -122.428125733918 | (37.7600745238281, -122.428125733918) | 2 | 4 | 5 | 28862 | 3 | |||
| 21876 | 240353 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 10 | Front Yard : Yard | Tree | Private 2 | 29 | Width 3ft | 6004318.10753 | 2104946.36781 | 37.7600260063222 | -122.428146563117 | (37.7600260063222, -122.428146563117) | 2 | 4 | 5 | 28862 | 3 | |||
| 185478 | 240352 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 9 | Front Yard : Yard | Tree | Private 2 | 18 | Width 3ft | 6004316.09652 | 2104917.27177 | 37.7599460017266 | -122.428151444657 | (37.7599460017266, -122.428151444657) | 2 | 4 | 5 | 28862 | 3 | |||
| 13228 | 197239 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 830 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 4x4 | Permit Number 785334 | 6011827.26305 | 2104492.53285 | 37.7592018783746 | -122.40214394589 | (37.7592018783746, -122.40214394589) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |
| 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 | |||||
| 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 | |||
| 154453 | 197238 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1101 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6016145.70434 | 2103719.54836 | 37.7573195208837 | -122.387154647679 | (37.7573195208837, -122.387154647679) | 10 | 3 | 8 | 28856 | 29 | |||
| 131145 | 197237 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1101 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016149.20682 | 2103671.84274 | 37.7571887253073 | -122.387139207224 | (37.7571887253073, -122.387139207224) | 10 | 3 | 8 | 28856 | 29 | |||
| 65290 | 197236 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1101 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016150.08513 | 2103652.13569 | 37.7571346625573 | -122.38713479513 | (37.7571346625573, -122.38713479513) | 10 | 3 | 8 | 28856 | 29 | |||
| 92029 | 197235 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1101 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016151.23089 | 2103629.88261 | 37.7570736237573 | -122.387129280509 | (37.7570736237573, -122.387129280509) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |
| 36362 | 197234 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1201 Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6016171.82655 | 2103275.37534 | 37.7561013622073 | -122.387033327344 | (37.7561013622073, -122.387033327344) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |
| 66294 | 197233 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1201 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6016183.78444 | 2103092.78575 | 37.7556006718551 | -122.386979238508 | (37.7556006718551, -122.386979238508) | 10 | 3 | 8 | 28856 | 29 | |||
| 42378 | 27556 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 47677 | 27571 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 22 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 57168 | 27558 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 61310 | 27570 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 21 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 |
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) );