trees
254 rows where qSpecies_id = 78 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||
| 139219 | 15047 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1115 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 6015512.6554 | 2096045.3172 | 37.7362126017611 | -122.388808259867 | (37.7362126017611, -122.388808259867) | 10 | 3 | 8 | 58 | 1 | ||
| 80580 | 29655 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X La Salle Ave | 15 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015616.5769 | 2096101.5164 | 37.7363726727082 | -122.388452878787 | (37.7363726727082, -122.388452878787) | 10 | 3 | 8 | 58 | 1 | ||
| 144344 | 29654 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X La Salle Ave | 13 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015636.0426 | 2096086.4462 | 37.7363323716667 | -122.388384525603 | (37.7363323716667, -122.388384525603) | 10 | 3 | 8 | 58 | 1 | ||
| 96482 | 29653 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X La Salle Ave | 12 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015651.7407 | 2096073.8877 | 37.7362987584373 | -122.388329374012 | (37.7362987584373, -122.388329374012) | 10 | 3 | 8 | 58 | 1 | ||
| 43316 | 15036 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1011 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6015667.53207 | 2096259.44011 | 37.7368091227302 | -122.388287722415 | (37.7368091227302, -122.388287722415) | 10 | 3 | 8 | 58 | 1 | |||
| 17228 | 29643 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X La Salle Ave | 2 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015873.398 | 2095908.1157 | 37.7358558618741 | -122.387551444245 | (37.7358558618741, -122.387551444245) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||||
| 160117 | 197267 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 822 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6015954.57272 | 2096709.3738 | 37.7380604502387 | -122.387326664599 | (37.7380604502387, -122.387326664599) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 3491 | 30093 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 835 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 5 | 3x3 | 6015986 | 2096642 | 37.7378771959016 | -122.387213305704 | (37.7378771959016, -122.387213305704) | 10 | 3 | 8 | 58 | 1 | ||
| 61879 | 25474 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 830X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6015988.77798 | 2096759.23326 | 37.7381992484921 | -122.387211875796 | (37.7381992484921, -122.387211875796) | 10 | 3 | 8 | 58 | 1 | ||
| 96726 | 197266 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 818 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015992.31531 | 2096760.75352 | 37.738203618709 | -122.387199751367 | (37.738203618709, -122.387199751367) | 10 | 3 | 8 | 58 | 1 | |||
| 38538 | 119910 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X La Salle Ave | 15 | Median : Cutout | Tree | DPW 1 | 12x31 | 6015992.6911276 | 2095862.2429535 | 37.735736511316 | -122.38713579848 | (37.735736511316, -122.38713579848) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | ||
| 79318 | 11430 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 810X Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 3 | 3x3 | 6016021.05885 | 2096802.45168 | 37.7383197051187 | -122.387103277147 | (37.7383197051187, -122.387103277147) | 10 | 3 | 8 | 58 | 1 | ||
| 98474 | 27536 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1300 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016135.46193 | 2102904.74697 | 37.7550816812001 | -122.387133239331 | (37.7550816812001, -122.387133239331) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | |||
| 138232 | 27542 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1390 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/06/2006 12:00:00 AM | 3 | 3X3 | 6016157.095863 | 2102619.361637 | 37.7542992711205 | -122.387038518734 | (37.7542992711205, -122.387038518734) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | |||
| 178961 | 27547 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1301X Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/06/2006 12:00:00 AM | 3 | 3X3 | 6016173.411126 | 2103023.95301 | 37.7554110972717 | -122.387010312465 | (37.7554110972717, -122.387010312465) | 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 | ||
| 71826 | 27553 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 4 | 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 | ||
| 160181 | 27573 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 24 | 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 | ||
| 167697 | 27569 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 20 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 10 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 184011 | 27550 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 1 | 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 | ||
| 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 | |||
| 161842 | 15016 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 670 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2008 12:00:00 AM | 5 | 3x3 | 6016248.60441 | 2097127.21289 | 37.7392240313668 | -122.386339165233 | (37.7392240313668, -122.386339165233) | 10 | 3 | 8 | 58 | 1 | ||
| 111989 | 65579 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/1990 12:00:00 AM | 4 | Permit Number 28479 | 6016251.26211 | 2097105.49291 | 37.739164539819 | -122.386328462099 | (37.739164539819, -122.386328462099) | 10 | 3 | 8 | 58 | 1 | ||
| 49522 | 197273 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 618 Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016318.01168 | 2097190.59348 | 37.7394019032644 | -122.386103601013 | (37.7394019032644, -122.386103601013) | 10 | 3 | 8 | 58 | 1 | |||
| 20000 | 15008 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 600X Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2008 12:00:00 AM | 12 | 3x3 | 6016372.25512 | 2097272.64218 | 37.7396301943656 | -122.385921767044 | (37.7396301943656, -122.385921767044) | 10 | 3 | 8 | 58 | 1 | ||
| 186057 | 93980 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 54 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53404 | 6016373.3 | 2096115.1 | 37.7364518752706 | -122.385837492382 | (37.7364518752706, -122.385837492382) | 10 | 3 | 8 | 58 | 1 | |
| 78512 | 12132 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1400X La Salle Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2016 05:53:00 AM | 3 | 3X3 | 6016426.99502 | 2095242.04569 | 37.734057614557 | -122.385591017134 | (37.734057614557, -122.385591017134) | 10 | 3 | 8 | 58 | 1 | ||
| 79040 | 14988 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 500 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/11/2013 12:00:00 AM | 3 | 3x3 | 6016447.53347 | 2097406.0602 | 37.7400006988631 | -122.385670780678 | (37.7400006988631, -122.385670780678) | 10 | 3 | 8 | 58 | 1 | ||
| 14458 | 197268 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 623 Mendell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016457.45945 | 2097300.20103 | 37.7397105802781 | -122.385629084527 | (37.7397105802781, -122.385629084527) | 10 | 3 | 8 | 58 | 1 | |||
| 135622 | 14987 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 500 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/2008 12:00:00 AM | 2 | 3X3 | 6016458.61367 | 2097424.13027 | 37.7400509287079 | -122.38563372862 | (37.7400509287079, -122.38563372862) | 10 | 3 | 8 | 58 | 1 | ||
| 17414 | 197269 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 623 Mendell St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016467.03521 | 2097318.03546 | 37.7397600798502 | -122.385597217932 | (37.7397600798502, -122.385597217932) | 10 | 3 | 8 | 58 | 1 | |||
| 65712 | 197270 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 621 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6016507.88272 | 2097368.67206 | 37.7399013777473 | -122.385459511073 | (37.7399013777473, -122.385459511073) | 10 | 3 | 8 | 58 | 1 | |||
| 125089 | 197271 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 621 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016522.12387 | 2097389.36221 | 37.7399589766173 | -122.385411712102 | (37.7399589766173, -122.385411712102) | 10 | 3 | 8 | 58 | 1 | |||
| 31353 | 15000 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 501 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6016547.41943 | 2097394.04536 | 37.7399732350602 | -122.385324575969 | (37.7399732350602, -122.385324575969) | 10 | 3 | 8 | 58 | 1 | |||
| 53291 | 15001 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 501 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6016547.41943 | 2097394.04536 | 37.7399732350602 | -122.385324575969 | (37.7399732350602, -122.385324575969) | 10 | 3 | 8 | 58 | 1 | ||
| 127157 | 15003 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 501 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6016547.41943 | 2097394.04536 | 37.7399732350602 | -122.385324575969 | (37.7399732350602, -122.385324575969) | 10 | 3 | 8 | 58 | 1 | ||
| 135673 | 197272 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 621 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016550.5665 | 2097428.77687 | 37.7400687748538 | -122.385316114164 | (37.7400687748538, -122.385316114164) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 170555 | 14881 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6017041.97386 | 2098599.86831 | 37.7433115287015 | -122.383698526073 | (37.7433115287015, -122.383698526073) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 |
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) );