trees
379 rows where qSpecies_id = 86 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
191808 | 103623 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/04/2013 12:00:00 AM | 13x2 | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | ||
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 | |||
753 | 197913 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Conkling St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6011758.24884 | 2095732.01029 | 37.7351435225424 | -122.40176684758 | (37.7351435225424, -122.40176684758) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
3399 | 197903 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 578 San Bruno Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6010927.90334 | 2105602.38731 | 37.762199049855 | -122.405332538967 | (37.762199049855, -122.405332538967) | 8 | 3 | 8 | 28856 | 29 | |||
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 | ||
4119 | 179884 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007440.99847 | 2094010.17739 | 37.7301738725104 | -122.416571250581 | (37.7301738725104, -122.416571250581) | 9 | 3 | 7 | 309 | 28 | |||
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 | |||
5035 | 103624 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/04/2013 12:00:00 AM | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | |||
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 | |||
5344 | 102057 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 5 Eureka St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1x1 | Permit Number 18946 | 6001387 | 2105809 | 37.7622283076155 | -122.438345635253 | (37.7622283076155, -122.438345635253) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
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 | |||
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 | ||
6275 | 215306 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 490 Faxon Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994798.91109 | 2091839.85894 | 37.7234956059322 | -122.46011911751 | (37.7234956059322, -122.46011911751) | 9 | 8 | 4 | 28861 | 24 | |||
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 | |||
6411 | 136695 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1200 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 6007098.70591 | 2119850.28744 | 37.8011054932745 | -122.419587225988 | (37.8011054932745, -122.419587225988) | 5 | 1 | 1 | 28858 | 32 | ||||
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 | |||
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 | ||||
8931 | 215339 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 637 Detroit St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5999420.83111 | 2095184.41503 | 37.7329437376643 | -122.444382272244 | (37.7329437376643, -122.444382272244) | 9 | 7 | 4 | 59 | 40 | |||
9034 | 179812 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1349 Cayuga Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 5999375.14619 | 2089880.54718 | 37.71837793826 | -122.444159228684 | (37.71837793826, -122.444159228684) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |
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 | |||
12690 | 179887 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6007462.62751 | 2094011.80961 | 37.7301795706263 | -122.416496591546 | (37.7301795706263, -122.416496591546) | 9 | 3 | 7 | 309 | 28 | |||
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 | |||
12939 | 136649 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002175.88564 | 2121598.89549 | 37.8056281874435 | -122.436747525379 | (37.8056281874435, -122.436747525379) | 13 | 9 | 1 | 57 | 17 | |||
13058 | 260903 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 51 Shore View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 5984536 | 2112849 | 37.7805852728313 | -122.497145662996 | (37.7805852728313, -122.497145662996) | 11 | 6 | 2 | 55 | 26 | ||||
14557 | 179896 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008623.46871 | 2091235.83896 | 37.7226225602776 | -122.412287269767 | (37.7226225602776, -122.412287269767) | 9 | 3 | 7 | 309 | 28 | |||
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 | |
15056 | 136668 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2640 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000716.04305 | 2117375.36701 | 37.793948425839 | -122.44149623986 | (37.793948425839, -122.44149623986) | 13 | 9 | 1 | 57 | 27 | |||
17039 | 136666 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 45 Normandie Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000890.78199 | 2117450.16174 | 37.7941637460202 | -122.440896995501 | (37.7941637460202, -122.440896995501) | 13 | 9 | 1 | 57 | 27 | |||
20054 | 179816 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 300 Ellington Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 1ft | 5998896.47943 | 2087985.98749 | 37.713148590116 | -122.445677603554 | (37.713148590116, -122.445677603554) | 9 | 7 | 6 | 28861 | 25 | |||
20238 | 197904 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 654 Minnesota St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6015148.99162 | 2105385.9246 | 37.761839786886 | -122.390718148347 | (37.761839786886, -122.390718148347) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
20747 | 215303 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 681 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5997546.26853 | 2094964.87379 | 37.7322337966419 | -122.450847264584 | (37.7322337966419, -122.450847264584) | 9 | 7 | 4 | 59 | 40 | ||||
21045 | 179811 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1367 Cayuga Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 0ft | 5999338.15399 | 2089837.49101 | 37.7182576053899 | -122.444284002399 | (37.7182576053899, -122.444284002399) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||
21329 | 136680 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1369 Hyde St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6007505.03866 | 2117018.90394 | 37.7933541007707 | -122.417980305661 | (37.7933541007707, -122.417980305661) | 5 | 1 | 10 | 28858 | 32 | |||
22738 | 120295 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 191 24th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 5988321.26869 | 2114707.42753 | 37.7859090914651 | -122.484187107183 | (37.7859090914651, -122.484187107183) | 11 | 6 | 1 | 55 | 33 | |||
22753 | 136655 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002095.53828 | 2121587.56307 | 37.80559250506 | -122.437024766584 | (37.80559250506, -122.437024766584) | 13 | 9 | 1 | 57 | 17 | |||
23212 | 179853 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 802 Delano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5998760.78346 | 2089904.78247 | 37.7184094145512 | -122.446284557804 | (37.7184094145512, -122.446284557804) | 9 | 7 | 6 | 28861 | 25 | |||
23215 | 218419 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 206 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5994236.56093 | 2100588.83344 | 37.7474857670642 | -122.462697413572 | (37.7474857670642, -122.462697413572) | 1 | 8 | 4 | 29491 | 40 | |||
23410 | 215313 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997655.06789 | 2090049.20462 | 37.7187427527624 | -122.450116941352 | (37.7187427527624, -122.450116941352) | 9 | 8 | 6 | 28861 | 24 | |||
24370 | 215317 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997677.83985 | 2090093.68651 | 37.7188661927949 | -122.450041432477 | (37.7188661927949, -122.450041432477) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
24655 | 215338 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998226.11251 | 2096380.78786 | 37.7361604543418 | -122.448598839867 | (37.7361604543418, -122.448598839867) | 9 | 7 | 4 | 59 | 40 | |||
25989 | 101973 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1695 21st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x4 | Permit Number 769633 | 5989621.7 | 2103844.4 | 37.7561578263999 | -122.478893204843 | (37.7561578263999, -122.478893204843) | 1 | 8 | 3 | 56 | 35 | |||
26893 | 241069 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 415 Collingwood St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6002146.1874 | 2103426.00537 | 37.7557283324003 | -122.435549412575 | (37.7557283324003, -122.435549412575) | 2 | 4 | 5 | 28862 | 22 | |||
27027 | 179833 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1468 Alemany Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6002155.36157 | 2093545.08036 | 37.7285981406774 | -122.434811114144 | (37.7285981406774, -122.434811114144) | 9 | 7 | 6 | 28861 | 25 | |||
27037 | 106347 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 415 DEWEY BLVD | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5995172.1 | 2100351 | 37.7468865723154 | -122.459445180048 | (37.7468865723154, -122.459445180048) | 1 | 8 | 4 | 59 | 40 | |||||
27119 | 215314 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997659.25231 | 2090057.81858 | 37.7187666441474 | -122.450103098091 | (37.7187666441474, -122.450103098091) | 9 | 8 | 6 | 28861 | 24 | |||
27327 | 179900 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008639.8841 | 2091240.95748 | 37.7226375357801 | -122.412230886773 | (37.7226375357801, -122.412230886773) | 9 | 3 | 7 | 309 | 28 | |||
27598 | 179854 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 339 Mount Vernon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998465.19432 | 2089720.01475 | 37.7178851988142 | -122.447292991002 | (37.7178851988142, -122.447292991002) | 9 | 7 | 6 | 28861 | 25 | ||||
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 | |||
29990 | 215341 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 3ft | 6000114.95424 | 2094335.27384 | 37.7306517731413 | -122.441921590428 | (37.7306517731413, -122.441921590428) | 9 | 7 | 4 | 63 | 40 | |||
30022 | 215307 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 490 Faxon Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994799.16087 | 2091851.78305 | 37.7235283610397 | -122.460119117526 | (37.7235283610397, -122.460119117526) | 9 | 8 | 4 | 28861 | 24 | |||
31433 | 136684 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 57 Russell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6007021.76535 | 2118934.77129 | 37.7985873825495 | -122.41978847538 | (37.7985873825495, -122.41978847538) | 5 | 1 | 10 | 28858 | 32 | |||
31608 | 136644 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3801 Webster St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002496.13752 | 2121660.90327 | 37.8058166394946 | -122.435643688532 | (37.8058166394946, -122.435643688532) | 13 | 9 | 1 | 57 | 17 | |||
32212 | 179898 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008631.84124 | 2091237.77549 | 37.7226283473964 | -122.412258464481 | (37.7226283473964, -122.412258464481) | 9 | 3 | 7 | 309 | 28 | |||
33199 | 179907 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 600 Somerset St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6010281.08553 | 2091712.86969 | 37.7240252643514 | -122.406590826309 | (37.7240252643514, -122.406590826309) | 10 | 3 | 7 | 309 | 28 | |||
33262 | 116307 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | |||
34212 | 136690 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1101 Green St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6007706.55666 | 2118838.72504 | 37.7983622165993 | -122.417412065427 | (37.7983622165993, -122.417412065427) | 5 | 1 | 10 | 28858 | 32 | |||
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 | |
35059 | 116297 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
35581 | 179842 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002649.41519 | 2093884.99893 | 37.7295595177473 | -122.433127421409 | (37.7295595177473, -122.433127421409) | 9 | 7 | 6 | 28861 | 25 | |||
36884 | 136634 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3600 Baker St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5999197.43818 | 2121197.11006 | 37.8043552744421 | -122.447025895951 | (37.8043552744421, -122.447025895951) | 13 | 9 | 1 | 57 | 17 | ||||
37032 | 215337 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998231.9169 | 2096387.51631 | 37.7361792609492 | -122.448579256245 | (37.7361792609492, -122.448579256245) | 9 | 7 | 4 | 59 | 40 | |||
37296 | 179836 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 2ft | 6002646.43295 | 2094204.87454 | 37.7304376544756 | -122.433160577611 | (37.7304376544756, -122.433160577611) | 9 | 7 | 5 | 28861 | 25 | |||
37301 | 241067 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 229 Grand View Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000638.50789 | 2103037.93604 | 37.7545770419209 | -122.440735600467 | (37.7545770419209, -122.440735600467) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
38106 | 247551 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 815 Buena Vista Ave West | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 2ft | 6000085.81992 | 2108391.87741 | 37.769246150022 | -122.443031409565 | (37.769246150022, -122.443031409565) | 15 | 5 | 11 | 29492 | 9 | |||
39011 | 179881 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1151 Felton St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007539.25103 | 2092829.10153 | 37.7269364183715 | -122.416147963965 | (37.7269364183715, -122.416147963965) | 9 | 3 | 7 | 309 | 28 | |||
39108 | 179880 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1151 Felton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6007526.36673 | 2092824.84352 | 37.7269240023301 | -122.416192203412 | (37.7269240023301, -122.416192203412) | 9 | 3 | 7 | 309 | 28 | |||
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 | |||
40385 | 215342 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Circular Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5999549.56796 | 2093580.96212 | 37.7285483748934 | -122.443822037778 | (37.7285483748934, -122.443822037778) | 9 | 7 | 4 | 63 | 40 | |||
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 | |||
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 | |
42109 | 215292 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 4ft | 5994414.45382 | 2100572.16969 | 37.747450256423 | -122.462081067713 | (37.747450256423, -122.462081067713) | 1 | 8 | 4 | 29491 | 40 | |||
42725 | 215295 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Burnside Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6001248.26665 | 2095899.59415 | 37.7350115506281 | -122.43811558039 | (37.7350115506281, -122.43811558039) | 2 | 7 | 5 | 63 | 7 | |||
42831 | 215318 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997681.5922 | 2090099.04662 | 37.7188811251298 | -122.450028848265 | (37.7188811251298, -122.450028848265) | 9 | 8 | 6 | 28861 | 24 | |||
43003 | 136693 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2164 Hyde St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6007181.34298 | 2119779.01061 | 37.8009144395066 | -122.41929620626 | (37.8009144395066, -122.41929620626) | 5 | 1 | 1 | 28858 | 32 | |||
43129 | 100849 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 1 Estero Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
44005 | 179893 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 101 Dartmouth St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6008518.11565 | 2093559.33094 | 37.7289964630154 | -122.412815641254 | (37.7289964630154, -122.412815641254) | 9 | 3 | 7 | 309 | 28 | |||
44075 | 215290 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 496 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5993542.94164 | 2101911.83549 | 37.7510784210541 | -122.465191965655 | (37.7510784210541, -122.465191965655) | 1 | 8 | 4 | 29491 | 12 | |||
44291 | 215312 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997649.01848 | 2090038.45407 | 37.7187128880716 | -122.450137077175 | (37.7187128880716, -122.450137077175) | 9 | 8 | 6 | 28861 | 24 | |||
44377 | 116296 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
44452 | 136673 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2650 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000708.53208 | 2117436.75891 | 37.7941165639844 | -122.441526636039 | (37.7941165639844, -122.441526636039) | 13 | 9 | 1 | 57 | 27 | |||
44578 | 179805 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1475 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5998972.41815 | 2089460.57977 | 37.7172018201812 | -122.445521103537 | (37.7172018201812, -122.445521103537) | 9 | 7 | 6 | 28861 | 25 | |||
44958 | 136637 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 91 Mayfair Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5997659.79036 | 2114483.77284 | 37.7858342881777 | -122.451862419331 | (37.7858342881777, -122.451862419331) | 15 | 6 | 1 | 54 | 31 | |||
46050 | 215344 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Circular Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5999563.31377 | 2093588.13313 | 37.7285688488645 | -122.443775032896 | (37.7285688488645, -122.443775032896) | 9 | 7 | 4 | 63 | 40 | |||
46559 | 179844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 19 Camellia Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6003286.16791 | 2094080.48748 | 37.7301323849801 | -122.430940049855 | (37.7301323849801, -122.430940049855) | 9 | 7 | 6 | 28861 | 25 | |||
46609 | 215311 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 536 Plymouth Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 5995931.93989 | 2088894.46571 | 37.7154733555918 | -122.455989631214 | (37.7154733555918, -122.455989631214) | 9 | 8 | 6 | 28861 | 24 | |||
46837 | 179803 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1481 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5998958.13876 | 2089448.31197 | 37.7171673203931 | -122.445569578776 | (37.7171673203931, -122.445569578776) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |
48837 | 241065 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1801 Castro St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6002656.66446 | 2100292.18739 | 37.7471525907236 | -122.433560071737 | (37.7471525907236, -122.433560071737) | 2 | 7 | 5 | 63 | 22 |
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) );