trees
379 rows where qSpecies_id = 86 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12157 | 241051 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 961 San Bruno Ave | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6011090.2221 | 2103848.38169 | 37.757392016144 | -122.40464765488 | (37.757392016144, -122.40464765488) | 10 | 4 | 8 | 28859 | 19 | |||
| 29197 | 136662 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1307 Bay St | 4 | : | Tree | Private 2 | 1 | Width 1ft | 6004522.84241 | 2120815.90939 | 37.8036114118857 | -122.428569697738 | (37.8036114118857, -122.428569697738) | 13 | 9 | 1 | 28858 | 17 | |||
| 53129 | 136663 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3109 Franklin St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6005049.76701 | 2120690.58566 | 37.8032971105329 | -122.426737318298 | (37.8032971105329, -122.426737318298) | 13 | 9 | 1 | 28858 | 17 | |||
| 84447 | 241052 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 961 San Bruno Ave | 2 | : | Tree | Private 2 | 6 | Width 2ft | 6011089.42148 | 2103864.30149 | 37.7574356836305 | -122.404651544442 | (37.7574356836305, -122.404651544442) | 10 | 4 | 8 | 28859 | 19 | |||
| 93014 | 136664 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3109 Franklin St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6005052.80958 | 2120674.99367 | 37.8032544709705 | -122.42672567836 | (37.8032544709705, -122.42672567836) | 13 | 9 | 1 | 28858 | 17 | |||
| 103768 | 136642 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3035 Divisadero St | 1 | : | Tree | Private 2 | 12 | Width 4ft | 6000450.1684 | 2118732.62208 | 37.7976599396021 | -122.442513681577 | (37.7976599396021, -122.442513681577) | 13 | 9 | 1 | 57 | 17 | |||
| 105124 | 136656 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1425 Jefferson St | 4 | : | Tree | Private 2 | 18 | Width 3ft | 6002391.37561 | 2121563.03053 | 37.8055419559627 | -122.435999224706 | (37.8055419559627, -122.435999224706) | 13 | 9 | 1 | 57 | 17 | |||
| 114945 | 241055 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 877 Treat Ave | 2 | : | Tree | Private 2 | 2 | Width 2ft | 6008598.03279 | 2103456.37285 | 37.7561760455159 | -122.413238943149 | (37.7561760455159, -122.413238943149) | 2 | 4 | 7 | 28859 | 19 | |||
| 128853 | 136661 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1307 Bay St | 3 | : | Tree | Private 2 | 4 | Width 1ft | 6004511.51487 | 2120814.19666 | 37.8036060681264 | -122.428608775088 | (37.8036060681264, -122.428608775088) | 13 | 9 | 1 | 28858 | 17 | |||
| 140976 | 241054 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 877 Treat Ave | 1 | : | Tree | Private 2 | 10 | Width 2ft | 6008599.28066 | 2103440.07697 | 37.7561313707826 | -122.413233475267 | (37.7561313707826, -122.413233475267) | 2 | 4 | 7 | 28859 | 19 | |||
| 144301 | 136647 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6002197.32767 | 2121601.52004 | 37.8056366123151 | -122.436673510277 | (37.8056366123151, -122.436673510277) | 13 | 9 | 1 | 57 | 17 | |||
| 7835 | 258799 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 566 29th Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5986943 | 2112080 | 37.7786145821325 | -122.488762272653 | (37.7786145821325, -122.488762272653) | 11 | 6 | 2 | 55 | 26 | ||||
| 71235 | 98244 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 901 Bay St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6006420.63185 | 2121080.7781 | 37.8044458892203 | -122.422021121489 | (37.8044458892203, -122.422021121489) | 5 | 1 | 1 | 28858 | 32 | ||||
| 75958 | 136705 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1120 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 14 | 6007496.45618 | 2119889.74411 | 37.8012362277192 | -122.418213633845 | (37.8012362277192, -122.418213633845) | 5 | 1 | 1 | 28858 | 32 | ||||
| 103524 | 179808 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1401 Cayuga Ave | 1 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 5999197.61143 | 2089687.82893 | 37.7178386481083 | -122.444759045 | (37.7178386481083, -122.444759045) | 9 | 7 | 6 | 28861 | 25 | |||
| 159259 | 104674 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 3649-3651 17TH ST | 1 | Front Yard : Yard | Tree | Private 2 | 20 | Permit Number 770917 | 6004555.5 | 2105964.3 | 37.7628344347284 | -122.427398052716 | (37.7628344347284, -122.427398052716) | 8 | 4 | 5 | 28862 | 3 | |||
| 7366 | 444 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 700X 23rd Ave | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8-HOA | 5988817.90932 | 2110395.27546 | 37.774098034723 | -122.482152859676 | (37.774098034723, -122.482152859676) | 11 | 6 | 2 | 55 | 26 | |||
| 69762 | 11201 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 100 Idora Ave | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 5995318.65927 | 2099418.1217 | 37.7443335470614 | -122.458870864793 | (37.7443335470614, -122.458870864793) | 1 | 8 | 4 | 59 | 40 | |||
| 71787 | 256414 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 3001 Sunset Blvd | 2 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 110991 | 256413 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 3001 Sunset Blvd | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 145014 | 256324 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3000X Sunset Blvd | 3 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
| 163182 | 256443 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 3001 Sunset Blvd | 27 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 5600 | 241053 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Coso Ave | 3 | Side Yard : Yard | Tree | Private 2 | 11 | Width 5ft | 6007672.87316 | 2099533.13544 | 37.7453517387841 | -122.416160625529 | (37.7453517387841, -122.416160625529) | 2 | 7 | 7 | 28859 | 2 | |||
| 40704 | 136716 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 14 | Side Yard : Yard | Tree | Private 2 | 15 | Width 7ft | 6003215.33658 | 2120983.87446 | 37.8039985196804 | -122.43310638985 | (37.8039985196804, -122.43310638985) | 13 | 9 | 1 | 57 | 17 | |||
| 54469 | 136659 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 11 | Side Yard : Yard | Tree | Private 2 | 13 | Width 7ft | 6003202.74777 | 2120982.34817 | 37.8039936147875 | -122.433149845112 | (37.8039936147875, -122.433149845112) | 13 | 9 | 1 | 57 | 17 | |||
| 72527 | 120265 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 100 24th Ave | 3 | Side Yard : Yard | Tree | Private 2 | 20 | 5988361.48129 | 2115164.47421 | 37.7871663527314 | -122.484081512932 | (37.7871663527314, -122.484081512932) | 11 | 6 | 1 | 55 | 33 | ||||
| 85899 | 136715 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 9 | Side Yard : Yard | Tree | Private 2 | 9 | Width 7ft | 6003190.85748 | 2120979.91426 | 37.803986257417 | -122.433190818205 | (37.803986257417, -122.433190818205) | 13 | 9 | 1 | 57 | 17 | |||
| 93918 | 136660 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 17 | Side Yard : Yard | Tree | Private 2 | 14 | Width 7ft | 6003228.45993 | 2120985.21121 | 37.8040029344509 | -122.433061071222 | (37.8040029344509, -122.433061071222) | 13 | 9 | 1 | 57 | 17 | |||
| 111535 | 136714 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 3 | Side Yard : Yard | Tree | Private 2 | 18 | Width 7ft | 6003161.03368 | 2120976.61805 | 37.8039755150326 | -122.433293789677 | (37.8039755150326, -122.433293789677) | 13 | 9 | 1 | 57 | 17 | |||
| 134209 | 136658 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 6 | Side Yard : Yard | Tree | Private 2 | 15 | Width 7ft | 6003175.48548 | 2120978.26665 | 37.8039808614944 | -122.433243896185 | (37.8039808614944, -122.433243896185) | 13 | 9 | 1 | 57 | 17 | |||
| 290 | 72670 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 203 04th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5994586.71732 | 2114106.61682 | 37.7846222306097 | -122.462466948558 | (37.7846222306097, -122.462466948558) | 11 | 6 | 2 | 54 | 11 | |||
| 1950 | 71713 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 782 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983564.60428 | 2110493.72832 | 37.7740614056929 | -122.500331946576 | (37.7740614056929, -122.500331946576) | 11 | 6 | 2 | 55 | 26 | |||
| 3404 | 74737 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 151X Palm Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5995889.08215 | 2113282.06845 | 37.7824331529909 | -122.457901543211 | (37.7824331529909, -122.457901543211) | 11 | 6 | 1 | 54 | 31 | ||
| 4496 | 74361 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 299 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6005755.65434 | 2092345.08491 | 37.7255069657486 | -122.422279456248 | (37.7255069657486, -122.422279456248) | 9 | 7 | 7 | 309 | 5 | |||
| 5140 | 70173 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 246 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5992471.1879 | 2113801.97828 | 37.7836637247597 | -122.469763717453 | (37.7836637247597, -122.469763717453) | 11 | 6 | 2 | 54 | 11 | |||
| 5435 | 70223 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2011 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989310.46344 | 2111227.07993 | 37.776410575875 | -122.480509949706 | (37.776410575875, -122.480509949706) | 11 | 6 | 2 | 55 | 26 | |||
| 5717 | 72392 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2220 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5988673.5466 | 2110578.22329 | 37.7745919608967 | -122.48266563867 | (37.7745919608967, -122.48266563867) | 11 | 6 | 2 | 55 | 26 | |||
| 6245 | 75019 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 151X Palm Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5995892.05475 | 2113163.21783 | 37.782106991639 | -122.457882656117 | (37.782106991639, -122.457882656117) | 11 | 6 | 1 | 54 | 31 | ||
| 6392 | 70172 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3027 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5989237.11171 | 2111905.73167 | 37.7782697016213 | -122.480813388031 | (37.7782697016213, -122.480813388031) | 11 | 6 | 2 | 55 | 26 | |||
| 11189 | 136665 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 65 Normandie Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000886.70084 | 2117510.54537 | 37.7943293112096 | -122.4409154505 | (37.7943293112096, -122.4409154505) | 13 | 9 | 1 | 57 | 27 | |||
| 11629 | 47454 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 5135 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 6 | Permit Number 45360 | 5982684.34734 | 2111666.51211 | 37.7772298203102 | -122.50346371712 | (37.7772298203102, -122.50346371712) | 11 | 6 | 2 | 55 | 26 | |
| 12934 | 16022 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 123 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001242.37794 | 2094603.69246 | 37.7314529692816 | -122.438043142671 | (37.7314529692816, -122.438043142671) | 9 | 7 | 4 | 63 | 40 | |||
| 14728 | 62484 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 81 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1986 12:00:00 AM | 10 | Permit Number 22655 | 6000565.24487 | 2092874.98588 | 37.7266678079605 | -122.440260189157 | (37.7266678079605, -122.440260189157) | 9 | 7 | 6 | 28861 | 25 | |
| 20460 | 100528 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1728 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4.5x6 | 6008351.1313 | 2118382.01094 | 37.7971444383282 | -122.415149288427 | (37.7971444383282, -122.415149288427) | 5 | 1 | 10 | 308 | 21 | |||
| 21064 | 45165 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 227 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2001 12:00:00 AM | 3 | Permit Number 44015 | 5987719.09382 | 2114404.67144 | 37.7850427307042 | -122.486248205367 | (37.7850427307042, -122.486248205367) | 11 | 6 | 1 | 55 | 26 | ||
| 24426 | 197912 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 784 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011813.78735 | 2104727.66115 | 37.7598467363702 | -122.40220708279 | (37.7598467363702, -122.40220708279) | 10 | 3 | 8 | 28856 | 29 | |||
| 24490 | 197906 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012889.3839 | 2106630.87087 | 37.7651325088853 | -122.398620653922 | (37.7651325088853, -122.398620653922) | 14 | 3 | 8 | 28856 | 20 | |||
| 34915 | 215298 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6000134.87473 | 2094332.54938 | 37.7306454275316 | -122.441852526992 | (37.7306454275316, -122.441852526992) | 9 | 7 | 4 | 63 | 40 | |||
| 34996 | 31114 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Edna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 5 | Permit Number 34839 | 5998792.19171 | 2094330.53052 | 37.7305632843566 | -122.44649422303 | (37.7305632843566, -122.44649422303) | 9 | 7 | 4 | 28861 | 40 | |
| 38031 | 215288 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Pacheco St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5991477.1073 | 2101838.1015 | 37.7507566211347 | -122.472330389247 | (37.7507566211347, -122.472330389247) | 1 | 8 | 4 | 29491 | 12 | |||
| 38090 | 949 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1468 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/1990 12:00:00 AM | 6 | 3X6 | 6002168.03285 | 2093561.19975 | 37.7286431202677 | -122.434768461095 | (37.7286431202677, -122.434768461095) | 9 | 7 | 6 | 28861 | 25 | ||
| 40383 | 105515 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 701 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6002668.24171 | 2089385.75875 | 37.7172066783264 | -122.432741059164 | (37.7172066783264, -122.432741059164) | 9 | 7 | 6 | 28861 | 5 | |||
| 41820 | 68457 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 119 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | 12 | Permit Number 32319 | 5991463.79981 | 2114626.05304 | 37.7858681269791 | -122.473308986123 | (37.7858681269791, -122.473308986123) | 11 | 6 | 2 | 54 | 26 | |
| 47539 | 31120 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Edna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 9 | Permit Number 34839 | 5998792.22814 | 2094324.02861 | 37.7305454337211 | -122.446493629496 | (37.7305454337211, -122.446493629496) | 9 | 7 | 4 | 28861 | 40 | |
| 50876 | 39476 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1425 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 14 | Permit Number 40937 | 6002367.56738 | 2121559.91338 | 37.8055320445375 | -122.436081393069 | (37.8055320445375, -122.436081393069) | 13 | 9 | 1 | 57 | 17 | ||
| 51532 | 179818 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Dichiera Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998665.00636 | 2087845.19043 | 37.7127487749191 | -122.446467526652 | (37.7127487749191, -122.446467526652) | 9 | 7 | 6 | 28861 | 25 | |||
| 59411 | 179908 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 316 Chicago Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002616.49516 | 2086635.08435 | 37.7096509944651 | -122.432723539456 | (37.7096509944651, -122.432723539456) | 9 | 7 | 6 | 28861 | 5 | |||
| 60405 | 120082 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 261 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5987725.3967 | 2114231.06843 | 37.7845664337094 | -122.486213650773 | (37.7845664337094, -122.486213650773) | 11 | 6 | 1 | 55 | 26 | |||
| 63804 | 179827 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 701 Vienna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002666.48138 | 2089402.27505 | 37.7172519286027 | -122.432748322975 | (37.7172519286027, -122.432748322975) | 9 | 7 | 6 | 28861 | 5 | |||
| 69558 | 84155 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 770 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52704 | 5981697.89996 | 2110507.76717 | 37.7739902053501 | -122.506790127416 | (37.7739902053501, -122.506790127416) | 11 | 6 | 2 | 55 | 26 | |
| 73016 | 120230 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 154 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5988064.78369 | 2114963.42937 | 37.7865970627596 | -122.485093253087 | (37.7865970627596, -122.485093253087) | 11 | 6 | 1 | 55 | 33 | |||
| 80852 | 54662 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 353 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 18 | Permit Number 10486 | 6012290.80379 | 2086856.89359 | 37.7108039630942 | -122.39930277173 | (37.7108039630942, -122.39930277173) | 10 | 3 | 8 | 309 | 1 | ||
| 81024 | 113456 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 6X Leroy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008347.73797 | 2116436.02263 | 37.7918010435277 | -122.415023221461 | (37.7918010435277, -122.415023221461) | 5 | 1 | 10 | 28858 | 21 | |||
| 83289 | 64384 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 290 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53175 | 6011583.39503 | 2119434.85196 | 37.8002164001168 | -122.404038925378 | (37.8002164001168, -122.404038925378) | 3 | 1 | 10 | 308 | 23 | |
| 85795 | 215323 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1222 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5993013.20867 | 2107124.46318 | 37.7653603763971 | -122.467402823005 | (37.7653603763971, -122.467402823005) | 11 | 8 | 11 | 56 | 12 | |||
| 87428 | 215300 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6000205.65358 | 2094331.35281 | 37.730646174877 | -122.441607748599 | (37.730646174877, -122.441607748599) | 9 | 7 | 4 | 63 | 40 | |||
| 88824 | 179826 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 838 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001050.56087 | 2088944.05849 | 37.7159019895732 | -122.438300979212 | (37.7159019895732, -122.438300979212) | 9 | 7 | 6 | 28861 | 5 | |||
| 94393 | 68663 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 142 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 10 | Permit Number 32570 | 5993373.867 | 2114549.20899 | 37.7857675498482 | -122.466695151518 | (37.7857675498482, -122.466695151518) | 11 | 6 | 2 | 54 | 11 | |
| 94688 | 215286 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1642 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5992803.42046 | 2104269.10188 | 37.757508190571 | -122.467920721889 | (37.757508190571, -122.467920721889) | 1 | 8 | 4 | 56 | 12 | |||
| 98485 | 104833 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 901 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6006442.50157 | 2121083.02679 | 37.8044532969577 | -122.421945599118 | (37.8044532969577, -122.421945599118) | 5 | 1 | 1 | 28858 | 32 | ||||
| 101151 | 179820 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Dichiera Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998698.87726 | 2087810.60096 | 37.712655734647 | -122.446347971688 | (37.712655734647, -122.446347971688) | 9 | 7 | 6 | 28861 | 25 | |||
| 105769 | 17447 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1967 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 3X3 | 6012920.44639 | 2096678.64853 | 37.7378075824587 | -122.397815063738 | (37.7378075824587, -122.397815063738) | 10 | 3 | 8 | 58 | 1 | |||
| 106810 | 197910 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Arkansas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6012885.09091 | 2106720.68948 | 37.7653788916393 | -122.39864180598 | (37.7653788916393, -122.39864180598) | 14 | 3 | 8 | 28856 | 20 | |||
| 107311 | 179825 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1115 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6000416.25611 | 2090642.64667 | 37.7205298306712 | -122.440615189366 | (37.7205298306712, -122.440615189366) | 9 | 7 | 6 | 28861 | 25 | |||
| 108553 | 179909 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 316 Chicago Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002595.51683 | 2086620.13725 | 37.7096087631907 | -122.432794977119 | (37.7096087631907, -122.432794977119) | 9 | 7 | 6 | 28861 | 5 | |||
| 112978 | 215283 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1448 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5993067.04344 | 2105615.39 | 37.7612199660593 | -122.467106895686 | (37.7612199660593, -122.467106895686) | 1 | 8 | 4 | 56 | 12 | |||
| 113842 | 25295 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 154 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 7x3 | 6000605.77697 | 2091736.42859 | 37.7235438977056 | -122.440038466696 | (37.7235438977056, -122.440038466696) | 9 | 7 | 6 | 28861 | 25 | |||
| 118052 | 52756 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 176@ GEARY Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2006 12:00:00 AM | 7 | Permit Number 48800 | 5995950.25747 | 2113100.83881 | 37.7819390591214 | -122.457676787394 | (37.7819390591214, -122.457676787394) | 11 | 6 | 1 | 54 | 31 | ||
| 119328 | 215333 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 8 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5993587.48804 | 2101138.42118 | 37.7489573915925 | -122.464981756306 | (37.7489573915925, -122.464981756306) | 1 | 8 | 4 | 29491 | 40 | |||
| 124748 | 179822 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 364 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998692.05829 | 2087780.21802 | 37.7125719205336 | -122.446369355756 | (37.7125719205336, -122.446369355756) | 9 | 7 | 6 | 28861 | 25 | |||
| 129935 | 215324 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1288 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5993647.63812 | 2106753.81902 | 37.764379290687 | -122.465181573075 | (37.764379290687, -122.465181573075) | 11 | 8 | 11 | 56 | 12 | |||
| 129943 | 123960 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 241 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | Permit Number 782043 | 5993663.58723 | 2113895.36148 | 37.7839889783025 | -122.465645289525 | (37.7839889783025, -122.465645289525) | 11 | 6 | 2 | 54 | 11 | ||
| 132265 | 87248 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 236323 Larkin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2008 12:00:00 AM | 3x3 | Permit Number 50274 | 6006714 | 2119291 | 37.7995481543168 | -122.420878746938 | (37.7995481543168, -122.420878746938) | 5 | 9 | 1 | 28858 | 32 | ||
| 132805 | 136694 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1201 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007018.29249 | 2119785.88696 | 37.8009241359937 | -122.41986091934 | (37.8009241359937, -122.41986091934) | 5 | 1 | 1 | 28858 | 32 | |||
| 134836 | 99719 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2164 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007186.17673 | 2119740.01598 | 37.8008076423232 | -122.419276711652 | (37.8008076423232, -122.419276711652) | 5 | 1 | 1 | 28858 | 32 | |||
| 134958 | 215299 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6000184.62411 | 2094332.33386 | 37.730647670445 | -122.441680520847 | (37.730647670445, -122.441680520847) | 9 | 7 | 4 | 63 | 40 | |||
| 136982 | 215322 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1546 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993091.78936 | 2104948.86266 | 37.7593912846005 | -122.466972852608 | (37.7593912846005, -122.466972852608) | 1 | 8 | 4 | 56 | 12 | |||
| 137276 | 179819 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Dichiera Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5998682.50802 | 2087825.81458 | 37.7126965728687 | -122.446405642516 | (37.7126965728687, -122.446405642516) | 9 | 7 | 6 | 28861 | 25 | |||
| 138676 | 215328 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992029.37698 | 2098355.00215 | 37.7412248722329 | -122.470167004418 | (37.7412248722329, -122.470167004418) | 1 | 8 | 4 | 59 | 40 | |||
| 145870 | 197909 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Arkansas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6012886.11406 | 2106697.30378 | 37.7653147367117 | -122.398636625887 | (37.7653147367117, -122.398636625887) | 14 | 3 | 8 | 28856 | 20 | |||
| 146312 | 17448 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1967 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 3X3 | 6012936.47341 | 2096667.45251 | 37.7377777330535 | -122.397758865084 | (37.7377777330535, -122.397758865084) | 10 | 3 | 8 | 58 | 1 | |||
| 150071 | 67960 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 819 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 12 | Permit Number 31680 | 5987243.89988 | 2110346.29905 | 37.7738718832899 | -122.487593962509 | (37.7738718832899, -122.487593962509) | 11 | 6 | 2 | 55 | 26 | |
| 152327 | 17449 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1967 Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 3X3 | 6012949.37731 | 2096657.76915 | 37.7377518631542 | -122.39771357075 | (37.7377518631542, -122.39771357075) | 10 | 3 | 8 | 58 | 1 | |||
| 152699 | 215321 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1546 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993089.7363 | 2104935.14056 | 37.7593534887954 | -122.466978955425 | (37.7593534887954, -122.466978955425) | 1 | 8 | 4 | 56 | 12 | |||
| 157310 | 215326 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992028.53266 | 2098327.51469 | 37.7411493498502 | -122.470167922636 | (37.7411493498502, -122.470167922636) | 1 | 8 | 4 | 59 | 40 | |||
| 158694 | 197907 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012887.44209 | 2106652.03819 | 37.7651905214559 | -122.398628855746 | (37.7651905214559, -122.398628855746) | 14 | 3 | 8 | 28856 | 20 | |||
| 161074 | 41928 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 524 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 9 | Permit Number 42287 | 5994708.51972 | 2111929.51477 | 37.7786515066402 | -122.461887634901 | (37.7786515066402, -122.461887634901) | 11 | 6 | 2 | 54 | 11 | |
| 166310 | 179817 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5998649.3213 | 2087861.75891 | 37.712793372299 | -122.446522930295 | (37.712793372299, -122.446522930295) | 9 | 7 | 6 | 28861 | 25 | |||
| 169423 | 41927 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 524 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 6 | Permit Number 42287 | 5994711.05634 | 2111911.6847 | 37.7786026960614 | -122.46187756658 | (37.7786026960614, -122.46187756658) | 11 | 6 | 2 | 54 | 11 | |
| 175671 | 67619 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1101 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | 11 | Permit Number 31202 | 6007683.17057 | 2118835.54867 | 37.7983521792584 | -122.417492763389 | (37.7983521792584, -122.417492763389) | 5 | 1 | 10 | 28858 | 32 |
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) );