trees
2,306 rows where qSpecies_id = 15 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 138186 | 1 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 10 10th Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 16 | 5992719.40718 | 2114869.71245 | 37.7866097734767 | -122.468982710496 | (37.7866097734767, -122.468982710496) | 11 | 6 | 1 | 54 | 11 | |||
| 188916 | 100069 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 619 Gonzalez Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2012 12:00:00 AM | Permit Number 769006 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||
| 164886 | 100169 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 180X Manchester St | Back Yard : Yard | Tree | DPW 1 | Adjacent to rear of property - DPW parcel | 6008242 | 2099158 | 37.7443536844995 | -122.414166136282 | (37.7443536844995, -122.414166136282) | 2 | 7 | 7 | 28859 | 2 | |||||
| 17896 | 100177 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 252 States St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 768965 | 6000636 | 2106677.4 | 37.7645699751489 | -122.44100535545 | (37.7645699751489, -122.44100535545) | 15 | 5 | 5 | 28862 | 3 | ||||
| 58651 | 100191 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1201 Holloway Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5992431.5 | 2091178.1 | 37.7215421255294 | -122.468254640211 | (37.7215421255294, -122.468254640211) | 9 | 8 | 6 | 64 | 24 | |||||
| 167578 | 100472 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 70 Stanford Heights Ave | Back Yard : Yard | Tree | Private 2 | 5997872.4 | 2096006.9 | 37.735113616296 | -122.449794826729 | (37.735113616296, -122.449794826729) | 9 | 7 | 4 | 59 | 40 | ||||||
| 154657 | 100850 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 Estero Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
| 175191 | 101038 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1010X Portola Dr | 12 | Front Yard : Yard | Tree | DPW 1 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||||
| 109137 | 101039 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1010X Portola Dr | 13 | Front Yard : Yard | Tree | DPW 1 | 08/23/2014 12:00:00 AM | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | ||||
| 157181 | 101138 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1290 Portola Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5994035.6 | 2097938.3 | 37.7401964926879 | -122.463200022957 | (37.7401964926879, -122.463200022957) | 1 | 8 | 4 | 59 | 40 | |||||
| 2352 | 101748 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 700X Panorama Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5997177.2 | 2102739.1 | 37.7535587877907 | -122.452684092588 | (37.7535587877907, -122.452684092588) | 1 | 5 | 4 | 63 | 38 | |||||
| 12060 | 101900 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100 Ocean Ave | 1 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
| 193463 | 102056 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 332 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5990007.7 | 2113121.3 | 37.7816520743217 | -122.478236569715 | (37.7816520743217, -122.478236569715) | 11 | 6 | 2 | 55 | 26 | |||||
| 165272 | 102111 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 18 Saturn St | 1 | Median : Yard | Tree | Private 2 | 24 | 6000559 | 2106017 | 37.7627522940794 | -122.441224290546 | (37.7627522940794, -122.441224290546) | 15 | 5 | 5 | 28862 | 3 | ||||
| 150925 | 102127 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 79 Starview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 769583 | 5997451.3 | 2101874.2 | 37.7511996890852 | -122.451673814863 | (37.7511996890852, -122.451673814863) | 1 | 5 | 4 | 63 | 38 | ||||
| 55743 | 102128 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 79 Starview Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 769583 | 5997451.3 | 2101874.2 | 37.7511996890852 | -122.451673814863 | (37.7511996890852, -122.451673814863) | 1 | 5 | 4 | 63 | 38 | ||||
| 53102 | 102229 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 254 WINDING WAY | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 6x9 | 6001720 | 2086577.5 | 37.7094419958048 | -122.435817862229 | (37.7094419958048, -122.435817862229) | 9 | 7 | 6 | 28861 | 5 | |||
| 138693 | 102270 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100X Casitas Ave | 4 | Median : Cutout | Tree | DPW 1 | 12 | 6x100 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | 9 | 7 | 4 | 59 | 40 | |||
| 176195 | 102381 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 258 Molimo Dr | Back Yard : Yard | Tree | Private 2 | 5997615 | 2096604 | 37.7367383790998 | -122.450727783905 | (37.7367383790998, -122.450727783905) | 9 | 7 | 4 | 59 | 40 | ||||||
| 135834 | 102467 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 36 Saint Germain Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5997576.7 | 2104111.9 | 37.757351037011 | -122.451401547119 | (37.757351037011, -122.451401547119) | 15 | 5 | 4 | 28862 | 38 | |||||
| 134592 | 102469 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1021 Kirkham St | 1 | Back Yard : Yard | Tree | Private 2 | 5991773 | 2105198 | 37.7599991432047 | -122.471551983129 | (37.7599991432047, -122.471551983129) | 1 | 8 | 4 | 56 | 12 | |||||
| 56515 | 102470 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1021 Kirkham St | 2 | Back Yard : Yard | Tree | Private 2 | 5991773 | 2105198 | 37.7599991432047 | -122.471551983129 | (37.7599991432047, -122.471551983129) | 1 | 8 | 4 | 56 | 12 | |||||
| 125905 | 102521 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1X 31st St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 5999966.2 | 2097547.4 | 37.7394630398899 | -122.442666404233 | (37.7394630398899, -122.442666404233) | 9 | 7 | 4 | 59 | 40 | |||||
| 159982 | 102589 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 5157 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6000788.8 | 2100195.2 | 37.7467801300642 | -122.440012028415 | (37.7467801300642, -122.440012028415) | 2 | 4 | 5 | 63 | 22 | ||||
| 176836 | 102639 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 251 Dorado Ter | 1 | Back Yard : Yard | Tree | Private 2 | 5994312.1 | 2092840.7 | 37.7262156610351 | -122.461874461465 | (37.7262156610351, -122.461874461465) | 9 | 8 | 4 | 28861 | 40 | |||||
| 130332 | 102729 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 49X Esmeralda Ave | 1 | Unaccepted Street : Yard | Tree | Private 2 | 24 | 6006840.1 | 2099056.7 | 37.7439966940099 | -122.419006438675 | (37.7439966940099, -122.419006438675) | 2 | 7 | 7 | 28859 | 2 | ||||
| 15154 | 102838 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 136614 | 102840 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1101X Portola Dr | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | 5994967.95791 | 2097979.30417 | 37.740362747151 | -122.459979297607 | (37.740362747151, -122.459979297607) | 9 | 8 | 4 | 59 | 40 | |||||
| 177640 | 103084 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 30X Zircon Pl | 1 | Back Yard : Yard | Tree | Private 2 | 6002309.6 | 2098789.5 | 37.7430068656447 | -122.434652757436 | (37.7430068656447, -122.434652757436) | 2 | 7 | 5 | 63 | 7 | |||||
| 75814 | 103457 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800X Bosworth St | 3 | Back Yard : Yard | Tree | DPW 1 | 26 | Located on DPW property next to 84 Lippard Ave | 6001796.5 | 2095573.7 | 37.7341478843848 | -122.436196831648 | (37.7341478843848, -122.436196831648) | 2 | 7 | 5 | 63 | 7 | |||
| 177799 | 103504 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 148 Huntington Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5984515 | 2095210 | 37.7321522522788 | -122.49591670505 | (37.7321522522788, -122.49591670505) | 1 | 8 | 4 | 64 | 35 | |||||
| 144400 | 103566 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 51X Prentiss St | 1 | Back Yard : Yard | Tree | DPW 1 | 12 | DPW property; below Bernal Heights Blvd near this address | 6008906.8 | 2098323.8 | 37.7421004736884 | -122.411808454692 | (37.7421004736884, -122.411808454692) | 10 | 7 | 7 | 28859 | 2 | |||
| 114744 | 103947 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2363X 36th Ave | 1 | Median : Yard | Tree | DPW 1 | 15 | 5985162.60331 | 2099213.25819 | 37.7431820356393 | -122.493972755113 | (37.7431820356393, -122.493972755113) | 1 | 8 | 3 | 29491 | 35 | ||||
| 72389 | 103993 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2425 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5x5 | 6002155.3 | 2105752.9 | 37.7621179405028 | -122.435684366446 | (37.7621179405028, -122.435684366446) | 15 | 4 | 5 | 28862 | 3 | ||||
| 158127 | 104008 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 357 Collingwood St | 1 | Back Yard : Yard | Tree | Private 2 | 36 | 6002124 | 2103789 | 37.7567237682266 | -122.435652112093 | (37.7567237682266, -122.435652112093) | 2 | 4 | 5 | 28862 | 3 | ||||
| 178069 | 104027 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 520X Oak Park Dr | 1 | Back Yard : Yard | Tree | Private 2 | 07/25/2013 12:00:00 AM | Permit Number 770238 | 5995008.5 | 2103700.7 | 37.7560745928775 | -122.460253542676 | (37.7560745928775, -122.460253542676) | 1 | 5 | 4 | 63 | 12 | |||
| 164999 | 104135 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 254 WINDING WAY | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 6x9 | 6001720 | 2086577 | 37.7094406229145 | -122.435817826478 | (37.7094406229145, -122.435817826478) | 9 | 7 | 6 | 28861 | 5 | |||
| 49109 | 104146 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1710-1738 Diamond St | 1 | Front Yard : Yard | Tree | Private 2 | 40 | 6001979.7 | 2099047.6 | 37.7436968136687 | -122.435811922611 | (37.7436968136687, -122.435811922611) | 2 | 7 | 5 | 63 | 22 | ||||
| 151692 | 104169 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 470X Roosevelt Way | 1 | Front Yard : Yard | Tree | Private 2 | 5999944.58235 | 2106286.89423 | 37.7634583383964 | -122.443368723848 | (37.7634583383964, -122.443368723848) | 15 | 5 | 5 | 29492 | 3 | |||||
| 81315 | 104261 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1556X O'Farrell St | 1 | Front Yard : Yard | Tree | Private 2 | 6003781.85581 | 2113525.38813 | 37.783551542878 | -122.430613377711 | (37.783551542878, -122.430613377711) | 13 | 9 | 11 | 29490 | 41 | |||||
| 95436 | 104406 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 290 Stonecrest Dr | 1 | Back Yard : Yard | Tree | Private 2 | 36 | Permit Number 770927 | 5990725 | 2092655 | 37.7254986161427 | -122.474261202586 | (37.7254986161427, -122.474261202586) | 9 | 8 | 4 | 64 | 40 | |||
| 3326 | 104499 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 44X SATURN ST | 1 | Median : Yard | Tree | DPW 1 | 18 | 6000456 | 2106003 | 37.7627079858093 | -122.44157952537 | (37.7627079858093, -122.44157952537) | 15 | 5 | 5 | 28862 | 3 | ||||
| 16189 | 104502 | Private 9 | Pinus radiata :: Monterey Pine 15 | 30X SATURN ST | 1 | Median : Yard | Tree | DPW 1 | 14 | 6000456 | 2106003 | 37.7627079858093 | -122.44157952537 | (37.7627079858093, -122.44157952537) | 15 | 5 | 5 | 28862 | 3 | ||||
| 170706 | 104522 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 53X BONVIEW ST | 1 | Front Yard : Yard | Tree | DPW 1 | 14 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
| 112528 | 104689 | Private 9 | Pinus radiata :: Monterey Pine 15 | 657 PALMETTO AVE | 1 | Back Yard : Yard | Tree | Private 2 | 30 | 5991786 | 2087190.1 | 37.7105547448876 | -122.470195680575 | (37.7105547448876, -122.470195680575) | 9 | 8 | 4 | 64 | 24 | ||||
| 93552 | 104749 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1X Junipero Serra Blvd Off Ramp | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719554 | (37.7132507161795, -122.47185719554) | 1 | 8 | 4 | 64 | 14 | ||||
| 142019 | 104750 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1X Junipero Serra Blvd Off Ramp | 2 | Front Yard : Yard | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719554 | (37.7132507161795, -122.47185719554) | 1 | 8 | 4 | 64 | 14 | ||
| 6334 | 104866 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Holladay Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 7 | 7 | 28859 | 2 | |||||
| 123534 | 104868 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Holladay Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 7 | 7 | 28859 | 2 | |||||
| 60828 | 104882 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 130 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990320.4 | 2090026.5 | 37.7182579620451 | -122.475468023466 | (37.7182579620451, -122.475468023466) | 1 | 8 | 4 | 64 | 14 | |||||
| 4918 | 104883 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 132 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990322.1 | 2090011.1 | 37.7182157760013 | -122.475461023549 | (37.7182157760013, -122.475461023549) | 1 | 8 | 4 | 64 | 14 | |||||
| 172194 | 104884 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 134 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 37079 | 104885 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 134 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 166713 | 104887 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 143 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
| 177618 | 104889 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 149 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
| 170969 | 104893 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 233 Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | ||||||
| 172539 | 104894 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 235 Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | ||||||
| 131899 | 104906 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 423 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
| 30556 | 104909 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 533 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
| 173819 | 104916 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 700 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 11878 | 104919 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 732 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990421 | 2090607 | 37.719857702396 | -122.475162650507 | (37.719857702396, -122.475162650507) | 1 | 8 | 4 | 64 | 40 | |||||
| 163382 | 104924 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 801 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990419 | 2090610 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | 1 | 8 | 4 | 64 | 40 | |||||
| 176350 | 104930 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 839 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990419 | 2090610 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | 1 | 8 | 4 | 64 | 40 | |||||
| 53316 | 104931 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 841 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990419 | 2090610 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | 1 | 8 | 4 | 64 | 40 | |||||
| 151938 | 104939 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 109X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | 1 | 8 | 4 | 64 | 14 | ||||||
| 191821 | 104940 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 111X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | 1 | 8 | 4 | 64 | 14 | ||||||
| 26584 | 104941 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 133X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | 1 | 8 | 4 | 64 | 14 | ||||||
| 119559 | 104999 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 180X SAN MARCOS AVE | 5 | Median : Cutout | Tree | DPW 1 | 42 | 5993452.8 | 2100406.9 | 37.7469410536635 | -122.465394372338 | (37.7469410536635, -122.465394372338) | 1 | 8 | 4 | 29491 | 40 | ||||
| 128515 | 105137 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 175X ESMERALDA AVE | 3 | unknown : Yard | Tree | DPW 1 | 18 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | ||||
| 186602 | 105138 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 175X ESMERALDA AVE | 4 | unknown : Yard | Tree | DPW 1 | 25 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | ||||
| 172129 | 105139 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 175X ESMERALDA AVE | 4 | unknown : Yard | Tree | DPW 1 | 25 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | ||||
| 113568 | 105140 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 125X ESMERALDA AVE | 1 | unknown : Yard | Tree | DPW 1 | 12 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | ||||
| 149052 | 105232 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 460X ROOSEVELT WAY | 2 | Front Yard : Yard | Tree | Private 2 | 17 | 5999944 | 2106286 | 37.7634558498539 | -122.443370673769 | (37.7634558498539, -122.443370673769) | 15 | 5 | 5 | 29492 | 3 | ||||
| 44835 | 105258 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 132 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 50 | 5990327 | 2090136 | 37.7185590045312 | -122.47545320092 | (37.7185590045312, -122.47545320092) | 1 | 8 | 4 | 64 | 14 | ||||
| 30591 | 105422 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 5827 DIAMOND HEIGHTS BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 6000844.1 | 2096795.2 | 37.7374476811542 | -122.439577108095 | (37.7374476811542, -122.439577108095) | 2 | 7 | 5 | 63 | 7 | ||||
| 28927 | 105423 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 GARFIELD ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/28/2014 12:00:00 AM | 28 | 3x20 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.462873531809 | (37.7201106425596, -122.462873531809) | 9 | 8 | 6 | 64 | 24 | ||
| 127970 | 105424 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 GARFIELD ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/28/2014 12:00:00 AM | 30 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.462873531809 | (37.7201106425596, -122.462873531809) | 9 | 8 | 6 | 64 | 24 | |||
| 59764 | 105504 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 39 MAGELLAN AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 5994694.1 | 2101166.3 | 37.7490976851152 | -122.461157135733 | (37.7490976851152, -122.461157135733) | 1 | 8 | 4 | 29491 | 40 | ||||
| 193436 | 105653 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 150 BRONTE ST | 3 | Unaccepted Street : Yard | Tree | Private 2 | 16 | Permit Number 770978 | 6009287.5 | 2096640.3 | 37.737499298819 | -122.410373266073 | (37.737499298819, -122.410373266073) | 10 | 7 | 7 | 28859 | 2 | |||
| 155662 | 105755 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1100X Divisadero St | 1 | Front Yard : Yard | Tree | Private 2 | 6001418 | 2112151 | 37.7796436231931 | -122.438692875339 | (37.7796436231931, -122.438692875339) | 15 | 5 | 11 | 29490 | 41 | |||||
| 79321 | 105761 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400X CASTRO ST | 12 | Median : Yard | Tree | DPW 1 | 16 | 6002698 | 2098487 | 37.7421983129634 | -122.433288166914 | (37.7421983129634, -122.433288166914) | 2 | 7 | 5 | 63 | 7 | ||||
| 33709 | 105762 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400X CASTRO ST | 13 | Median : Yard | Tree | DPW 1 | 20 | 6002698 | 2098487 | 37.7421983129634 | -122.433288166914 | (37.7421983129634, -122.433288166914) | 2 | 7 | 5 | 63 | 7 | ||||
| 50063 | 105765 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 95 ORA WAY | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6001454.9 | 2097857 | 37.7403978808149 | -122.437541306682 | (37.7403978808149, -122.437541306682) | 2 | 7 | 5 | 63 | 7 | ||||
| 34790 | 105768 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 98X GOLD MINE DR | 3 | Front Yard : Yard | Tree | Private 2 | 16 | 6001350 | 2099153 | 37.7439504273559 | -122.437996817375 | (37.7439504273559, -122.437996817375) | 2 | 7 | 5 | 63 | 22 | ||||
| 24614 | 105834 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3031 QUINTARA ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 5984010.9 | 2100823.5 | 37.747535864547 | -122.498073868906 | (37.747535864547, -122.498073868906) | 1 | 8 | 3 | 29491 | 35 | ||||
| 154333 | 105839 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 41X Bonview St | 1 | Front Yard : Yard | Tree | DPW 1 | 15 | 6007716.90579 | 2099172.41141 | 37.7443637468546 | -122.415982827151 | (37.7443637468546, -122.415982827151) | 2 | 7 | 7 | 28859 | 2 | ||||
| 157045 | 105845 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 355 Buena Vista Ave | Front Yard : Yard | Tree | Private 2 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.440214908068 | (37.767492540377, -122.440214908068) | 15 | 5 | 5 | 29492 | 3 | ||||||
| 51148 | 105904 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 700X BROTHERHOOD WAY | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 772491 | 5991178.9 | 2088065.4 | 37.7129229890255 | -122.472357697274 | (37.7129229890255, -122.472357697274) | 1 | 8 | 4 | 64 | 14 | |||||
| 131335 | 106057 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 140X CANYON DR | 1 | Median : Yard | Tree | DPW 1 | 18 | 6002713 | 2086188.2 | 37.7084294197398 | -122.432358106226 | (37.7084294197398, -122.432358106226) | 9 | 7 | 6 | 28861 | 5 | ||||
| 103484 | 106061 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 12X Canyon Dr | 1 | Median : Yard | Tree | DPW 1 | 40 | 6003256.93175 | 2086330.47946 | 37.7088509162175 | -122.430488359046 | (37.7088509162175, -122.430488359046) | 9 | 7 | 6 | 28861 | 5 | ||||
| 77383 | 106062 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 140X CANYON DR | 2 | Median : Yard | Tree | DPW 1 | 30 | 6002713 | 2086188.2 | 37.7084294197398 | -122.432358106226 | (37.7084294197398, -122.432358106226) | 9 | 7 | 6 | 28861 | 5 | ||||
| 22273 | 106336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 112 EUGENIA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6006345.6 | 2098165.7 | 37.7415223501304 | -122.420653072553 | (37.7415223501304, -122.420653072553) | 2 | 7 | 7 | 28859 | 2 | ||||
| 153731 | 106821 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 495 Collingwood St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 770776 | 6002186.6 | 2103026 | 37.7546323087418 | -122.435381040855 | (37.7546323087418, -122.435381040855) | 2 | 4 | 5 | 28862 | 22 | ||||
| 117590 | 106878 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 180X SAN MARCOS AVE | 1 | Median : Cutout | Tree | Private 2 | DPW | 26 | 5993452.8 | 2100406.9 | 37.7469410536635 | -122.465394372338 | (37.7469410536635, -122.465394372338) | 1 | 8 | 4 | 29491 | 40 | |||
| 168621 | 106903 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 20X MAYFAIR DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5998146 | 2114573 | 37.7861071180483 | -122.450186711437 | (37.7861071180483, -122.450186711437) | 11 | 6 | 1 | 54 | 31 | ||||
| 65188 | 106909 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 254 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 51 | 6x6 | 6001705.95388 | 2086562.81591 | 37.7094008786158 | -122.435865357921 | (37.7094008786158, -122.435865357921) | 9 | 7 | 6 | 28861 | 5 | |||
| 103964 | 106914 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1192 PAGE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x4 | Permit Number 774208 | 6000862.8 | 2109319.8 | 37.7718382630699 | -122.440410441009 | (37.7718382630699, -122.440410441009) | 15 | 5 | 11 | 29492 | 9 | ||
| 27030 | 106971 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 3479X San Bruno Ave | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 6011510.60551 | 2091910.03431 | 37.7246353494236 | -122.402354399294 | (37.7246353494236, -122.402354399294) | 10 | 3 | 7 | 309 | 28 | ||||
| 123285 | 107037 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1060 Clayton St | 1 | Front Yard : Yard | Tree | Private 2 | 99 | 5998985 | 2106259 | 37.7633269800406 | -122.446685590868 | (37.7633269800406, -122.446685590868) | 15 | 5 | 5 | 29492 | 9 | ||||
| 160967 | 107067 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1758 12th Ave | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 773344 | 5992506.32742 | 2103625.79831 | 37.7557246862805 | -122.468901366602 | (37.7557246862805, -122.468901366602) | 1 | 8 | 4 | 56 | 12 |
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) );