trees
2,421 rows where qSpecies_id = 8 sorted by qLegalStatus_id descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id ▲ | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6326 | 117138 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
| 55582 | 117143 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
| 90738 | 117140 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
| 106857 | 111194 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x JARBOE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | 3x3 | Permit Number 774267 | 6009115 | 2096842 | 37.7380434517433 | -122.410983924329 | (37.7380434517433, -122.410983924329) | 10 | 7 | 7 | 28859 | 2 | ||
| 107804 | 112688 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 259 BRIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2015 12:00:00 AM | 3 | 5x4 | 5993720 | 2088919 | 37.71541351482 | -122.4636368036 | (37.71541351482, -122.4636368036) | 9 | 8 | 6 | 64 | 24 | ||
| 109380 | 111193 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774267 | 6009115 | 2096842 | 37.7380434517433 | -122.410983924329 | (37.7380434517433, -122.410983924329) | 10 | 7 | 7 | 28859 | 2 | |
| 114728 | 117145 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
| 126441 | 117136 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
| 132994 | 117150 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 TOLAND ST | 5 | Front Yard : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011950 | 2098029 | 37.7414612698949 | -122.401265252936 | (37.7414612698949, -122.401265252936) | 10 | 3 | 8 | 58 | 1 | |
| 140065 | 117142 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
| 143699 | 117137 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
| 154253 | 117141 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
| 167623 | 117139 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
| 172332 | 117144 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
| 893 | 226590 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 08/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784594 | 6001099.54842 | 2099653.23365 | 37.7453097044788 | -122.438898660558 | (37.7453097044788, -122.438898660558) | 2 | 4 | 5 | 63 | 22 |
| 3984 | 243570 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 3 | 3x3 | Permit Number 784594 | 6001117.2647 | 2099653.19311 | 37.7453106011164 | -122.438837397829 | (37.7453106011164, -122.438837397829) | 2 | 4 | 5 | 63 | 22 | |
| 165045 | 114647 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 331 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774946 | 6008851.6 | 2097283.6 | 37.7392412152063 | -122.41192582952 | (37.7392412152063, -122.41192582952) | 10 | 7 | 7 | 28859 | 2 | |||
| 39751 | 96590 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 44908 | 96593 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 63210 | 96591 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 81530 | 96594 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 145479 | 96592 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 156111 | 96589 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 495 | 69056 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33064 | 5992348.34951393 | 2107046.09564514 | 37.7651067945026 | -122.469696689595 | (37.7651067945026, -122.469696689595) | 11 | 8 | 11 | 56 | 12 | ||
| 499 | 180799 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Mount Vernon Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 8x8 | Permit Number 782754 | 5998557.73755 | 2089669.84713 | 37.7177527376786 | -122.446969503064 | (37.7177527376786, -122.446969503064) | 9 | 7 | 6 | 28861 | 25 | |
| 1004 | 50532 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47171 | 5996679.82856356 | 2106618.62344586 | 37.7641824656847 | -122.454684361894 | (37.7641824656847, -122.454684361894) | 15 | 5 | 11 | 29492 | 12 | |||
| 1037 | 63388 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 139 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23969 | 6005989.66886949 | 2095872.0431692 | 37.7352044148911 | -122.421720887046 | (37.7352044148911, -122.421720887046) | 2 | 7 | 7 | 28859 | 2 | ||
| 1308 | 52427 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1815X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004786.32091155 | 2115731.58720361 | 37.7896660673411 | -122.427295522794 | (37.7896660673411, -122.427295522794) | 13 | 9 | 11 | 28858 | 27 |
| 2215 | 49868 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46634 | 6003577.84688999 | 2095267.92973361 | 37.7334093561858 | -122.430016351279 | (37.7334093561858, -122.430016351279) | 2 | 7 | 5 | 28861 | 25 | ||
| 2884 | 46077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 814 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2001 12:00:00 AM | Permit Number 44458 | 6003949.63841524 | 2110800.90118746 | 37.7760802817088 | -122.429838518249 | (37.7760802817088, -122.429838518249) | 7 | 9 | 11 | 29492 | 10 | |||
| 3218 | 84023 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 309 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 773233 | 6004808.26935881 | 2101900.57071737 | 37.7516906826671 | -122.42623448013 | (37.7516906826671, -122.42623448013) | 2 | 4 | 5 | 28862 | 22 | ||
| 4370 | 38420 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1542 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42357 | 6004548.16357043 | 2099910.23270392 | 37.7462109701995 | -122.426992216906 | (37.7462109701995, -122.426992216906) | 2 | 7 | 5 | 63 | 22 | ||
| 4498 | 58438 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 905 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 3x3 | Permit Number 51484 | 5999161.38005537 | 2107089.77623283 | 37.7656181571992 | -122.446135313725 | (37.7656181571992, -122.446135313725) | 15 | 5 | 11 | 29492 | 9 | ||
| 5257 | 62102 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 440 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1985 12:00:00 AM | Permit Number 22195 | 6006762.92692973 | 2101210.352632 | 37.7499057910946 | -122.419426042368 | (37.7499057910946, -122.419426042368) | 2 | 4 | 7 | 28859 | 19 | ||
| 5548 | 64543 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1547 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25426 | 6015321.62159268 | 2095235.25021997 | 37.7339777321734 | -122.389412195042 | (37.7339777321734, -122.389412195042) | 10 | 3 | 8 | 58 | 1 | ||
| 5654 | 31560 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 178 Ewing Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1995 12:00:00 AM | Permit Number 35104 | 5998523.78697564 | 2112531.01963796 | 37.7805219856792 | -122.448732545056 | (37.7805219856792, -122.448732545056) | 15 | 6 | 2 | 54 | 16 | |||
| 6315 | 46517 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 182 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2003 12:00:00 AM | Permit Number 46010 | 6005209.24135079 | 2109497.7250609 | 37.7725733258296 | -122.425388452589 | (37.7725733258296, -122.425388452589) | 7 | 9 | 11 | 28852 | 10 | ||
| 7390 | 27682 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 141 Industrial St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2009 12:00:00 AM | 3 | 2X3 | 6011440.5288809 | 2097124.3937126 | 37.738948976933 | -122.402963228074 | (37.738948976933, -122.402963228074) | 10 | 3 | 8 | 58 | 1 | ||
| 8207 | 47474 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
| 8415 | 96169 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 45 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767802 | 6007419 | 2097998 | 37.7411223211925 | -122.416929733801 | (37.7411223211925, -122.416929733801) | 2 | 7 | 7 | 28859 | 2 | |
| 8593 | 91087 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51982 | 5992207 | 2088764 | 37.7149006256244 | -122.46885508368 | (37.7149006256244, -122.46885508368) | 9 | 8 | 6 | 64 | 24 | |||
| 8997 | 47687 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2002 12:00:00 AM | Permit Number 45486 | 6003826.76338909 | 2102198.68251842 | 37.7524537008518 | -122.429649915481 | (37.7524537008518, -122.429649915481) | 2 | 4 | 5 | 28862 | 22 | |||
| 9047 | 47479 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
| 9670 | 85554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 360X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | 8 | 2 | 9 | 28853 | 19 | |||
| 9689 | 63382 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 261 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23962 | 6006733.60001952 | 2095809.91850213 | 37.7350757572483 | -122.41914443544 | (37.7350757572483, -122.41914443544) | 2 | 7 | 7 | 28859 | 2 | ||
| 10902 | 259838 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 306 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1997 12:00:00 AM | 3 | Permit Number 38009 | 5996907.65838 | 2089596.01103 | 37.7174555905703 | -122.452667732297 | (37.7174555905703, -122.452667732297) | 9 | 8 | 6 | 28861 | 24 | ||
| 11137 | 46998 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
| 12387 | 88728 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 68 Pontiac St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51663 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | 3 | 1 | 10 | 308 | 4 | |||
| 12550 | 63379 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 311 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23959 | 6006965.60744401 | 2095790.54383517 | 37.7350356215507 | -122.418340927554 | (37.7350356215507, -122.418340927554) | 2 | 7 | 7 | 28859 | 2 | ||
| 14053 | 62766 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1988 12:00:00 AM | Permit Number 25290 | 5993348.39587904 | 2103942.72221653 | 37.7566434919089 | -122.466012277578 | (37.7566434919089, -122.466012277578) | 1 | 8 | 4 | 56 | 12 | ||
| 14205 | 79589 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1746 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53534 | 5993448.84463132 | 2103598.20779392 | 37.7557033388246 | -122.465639863764 | (37.7557033388246, -122.465639863764) | 1 | 8 | 4 | 56 | 12 | ||
| 14895 | 42944 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42839 | 6007671.6020798 | 2107773.96917263 | 37.7679791099284 | -122.416748729284 | (37.7679791099284, -122.416748729284) | 8 | 4 | 7 | 28853 | 19 | ||
| 14957 | 85546 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 250X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007915.610259 | 2108965.748791 | 37.7712651780879 | -122.415989137093 | (37.7712651780879, -122.415989137093) | 8 | 2 | 9 | 28853 | 19 | |||
| 17189 | 39942 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 27 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | Permit Number 41213 | 6009741.23684285 | 2089425.45829631 | 37.7177142900305 | -122.408295747981 | (37.7177142900305, -122.408295747981) | 9 | 7 | 8 | 309 | 39 | ||
| 17404 | 37672 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3270 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40070 | 6007686 | 2105618 | 37.7620601307471 | -122.416546187971 | (37.7620601307471, -122.416546187971) | 8 | 4 | 7 | 28859 | 19 |
| 17913 | 35078 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 18040 | 33037 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 494 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37315 | 6006779.65662971 | 2100908.40918731 | 37.7490776652966 | -122.41934677281 | (37.7490776652966, -122.41934677281) | 2 | 4 | 7 | 28859 | 19 | |||
| 18297 | 51025 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 51 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | Permit Number 47502 | 6005670.67188859 | 2109250.29159524 | 37.7719199923513 | -122.423774718207 | (37.7719199923513, -122.423774718207) | 7 | 9 | 5 | 28852 | 10 | |||
| 20012 | 63372 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 371 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23952 | 6007253.22314461 | 2095766.52547538 | 37.7349858586394 | -122.417344833557 | (37.7349858586394, -122.417344833557) | 2 | 7 | 7 | 28859 | 2 | ||
| 21319 | 91088 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 132 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51983 | 5992207 | 2088751 | 37.7148649307688 | -122.468854138233 | (37.7148649307688, -122.468854138233) | 9 | 8 | 6 | 64 | 24 | ||
| 21456 | 34943 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3968 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2016 12:00:00 AM | 3 | Permit Number 775333 | 6003347.35755113 | 2102457.99102165 | 37.7531385434777 | -122.43132628846 | (37.7531385434777, -122.43132628846) | 2 | 4 | 5 | 28862 | 22 | ||
| 23473 | 87390 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3318 Fillmore St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 3x3 | Permit Number 50367 | 6002344.5 | 2119563.8 | 37.8000499325498 | -122.436018296661 | (37.8000499325498, -122.436018296661) | 13 | 9 | 1 | 57 | 17 | |||
| 23536 | 108612 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3628 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 774590 | 6002731.19846 | 2106518.35077 | 37.764252377203 | -122.433747267607 | (37.764252377203, -122.433747267607) | 15 | 5 | 5 | 28862 | 3 | |
| 23668 | 66231 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 299 Tara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/1994 12:00:00 AM | Permit Number 29328 | 5997721.47171687 | 2090151.04761265 | 37.7190261896858 | -122.449894746819 | (37.7190261896858, -122.449894746819) | 9 | 8 | 6 | 28861 | 24 | ||
| 23823 | 45113 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1272 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43975 | 5992408.94148991 | 2106797.24353803 | 37.7644270145157 | -122.46946900258 | (37.7644270145157, -122.46946900258) | 11 | 8 | 11 | 56 | 12 | ||
| 23922 | 58026 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 680 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/1987 12:00:00 AM | Permit Number 16994 | 6008648.68681502 | 2095709.61951023 | 37.7349080209093 | -122.412516183192 | (37.7349080209093, -122.412516183192) | 10 | 7 | 7 | 28859 | 2 | ||
| 24334 | 48686 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2002 12:00:00 AM | Permit Number 45967 | 5995920.95422115 | 2113779.82862982 | 37.7838017006932 | -122.457827310949 | (37.7838017006932, -122.457827310949) | 11 | 6 | 1 | 54 | 31 | |||
| 24439 | 49859 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 338 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46630 | 6003649.21999567 | 2095274.80996329 | 37.7334322896584 | -122.429770085042 | (37.7334322896584, -122.429770085042) | 2 | 7 | 5 | 28861 | 25 | ||
| 24478 | 69061 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1259 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33069 | 5992353.79544263 | 2106887.79671216 | 37.764672462389 | -122.469666328544 | (37.764672462389, -122.469666328544) | 11 | 8 | 11 | 56 | 12 | ||
| 24551 | 62760 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 409 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23114 | 5993046.38592213 | 2104560.1415905 | 37.7583213372073 | -122.467101616449 | (37.7583213372073, -122.467101616449) | 1 | 8 | 4 | 56 | 12 | ||
| 25797 | 35077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 25810 | 48572 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 24 | |||
| 27234 | 69058 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1243 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33066 | 5992350.1648235 | 2106993.32933415 | 37.7649620171359 | -122.469686569205 | (37.7649620171359, -122.469686569205) | 11 | 8 | 11 | 56 | 12 | ||
| 27726 | 254276 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 102 Bache St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778482 | 6007158.62699 | 2095375.94585 | 37.7339080899914 | -122.417644212443 | (37.7339080899914, -122.417644212443) | 2 | 7 | 7 | 28859 | 2 | |
| 27990 | 7136 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 336X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2005 12:00:00 AM | 6 | 3X3 | 5994611.62343 | 2110790.08992 | 37.775517371009 | -122.462140179219 | (37.775517371009, -122.462140179219) | 11 | 6 | 2 | 54 | 11 | ||
| 28255 | 39127 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 739 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40808 | 6007354.16846215 | 2103008.55652832 | 37.7548765329449 | -122.417508922955 | (37.7548765329449, -122.417508922955) | 2 | 4 | 7 | 28859 | 19 | ||
| 28303 | 56711 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1659 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2015 12:00:00 AM | Permit Number 774226 | 5983116.27836009 | 2103843.81660781 | 37.7557763190096 | -122.501390749613 | (37.7557763190096, -122.501390749613) | 1 | 8 | 3 | 56 | 35 | |||
| 29004 | 254341 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 38 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776525 | 6007503.72696 | 2099881.72077 | 37.7462993638251 | -122.416770197945 | (37.7462993638251, -122.416770197945) | 2 | 7 | 7 | 28859 | 2 |
| 29323 | 84791 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 499x Lisbon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2007 12:00:00 AM | Permit No. 49321 | 6002176 | 2090606 | 37.7205292596373 | -122.434529703705 | (37.7205292596373, -122.434529703705) | 9 | 7 | 6 | 28861 | 5 | |||
| 29773 | 63456 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 801 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1987 12:00:00 AM | Permit Number 24046 | 6007615.99374583 | 2095696.52300413 | 37.7348140509231 | -122.416085647719 | (37.7348140509231, -122.416085647719) | 2 | 7 | 7 | 28859 | 2 | ||
| 29985 | 59550 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 374 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24919 | 6003521.85163486 | 2098666.09972032 | 37.7427367824396 | -122.43045232079 | (37.7427367824396, -122.43045232079) | 2 | 7 | 5 | 63 | 22 | ||
| 30001 | 115382 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 625 Moultrie St | 1 | Side Yard : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776180 | 6007689.5 | 2096426.5 | 37.7368225406079 | -122.415883184956 | (37.7368225406079, -122.415883184956) | 2 | 7 | 7 | 28859 | 2 | ||
| 30235 | 35086 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 30387 | 60896 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1226 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1992 12:00:00 AM | Permit Number 20684 | 5995496.17178877 | 2107213.04806332 | 37.7657466388052 | -122.458821302083 | (37.7657466388052, -122.458821302083) | 15 | 5 | 11 | 56 | 12 | ||
| 30499 | 83186 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3453 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50577 | 6006512.76900503 | 2105506.90807829 | 37.7616890471737 | -122.420596061932 | (37.7616890471737, -122.420596061932) | 2 | 4 | 7 | 28859 | 19 | ||
| 30539 | 67015 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 379 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30370 | 5995013.54183778 | 2088325.60684353 | 37.7138586475181 | -122.459122836548 | (37.7138586475181, -122.459122836548) | 9 | 8 | 6 | 28861 | 24 | ||
| 30640 | 38839 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 947 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | Permit Number 40668 | 5992575.8845778 | 2114792.63949005 | 37.7863898589993 | -122.469473646902 | (37.7863898589993, -122.469473646902) | 11 | 6 | 2 | 54 | 11 | ||
| 30876 | 88307 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 401 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | 9 | 7 | 6 | 28861 | 5 | ||
| 31066 | 56439 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 12650 | 6005234.88834925 | 2109313.51101723 | 37.7720689675781 | -122.425286625875 | (37.7720689675781, -122.425286625875) | 7 | 9 | 11 | 28852 | 10 | ||
| 31788 | 64128 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 627 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24899 | 6002528.44281747 | 2098851.45130448 | 37.7431893908467 | -122.433900486749 | (37.7431893908467, -122.433900486749) | 2 | 7 | 5 | 63 | 7 | ||
| 31891 | 63321 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 308 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1987 12:00:00 AM | Permit Number 23894 | 6009704.28478725 | 2099627.84542916 | 37.7457258041449 | -122.409142988334 | (37.7457258041449, -122.409142988334) | 2 | 7 | 7 | 28859 | 2 | ||
| 32023 | 85527 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008215.27395 | 2108839.588309 | 37.7709356143391 | -122.414943653714 | (37.7709356143391, -122.414943653714) | 8 | 2 | 9 | 28853 | 19 | |||
| 32151 | 22922 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6006142.65939 | 2107729.77965 | 37.7677716622264 | -122.422034041273 | (37.7677716622264, -122.422034041273) | 8 | 4 | 7 | 28853 | 19 | |||
| 32297 | 48573 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 24 | |||
| 32383 | 88740 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51675 | 6004299 | 2109043 | 37.7712732924091 | -122.428504653556 | (37.7712732924091, -122.428504653556) | 7 | 9 | 11 | 28852 | 10 | ||
| 32577 | 35506 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3451 22nd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38909 | 6005392.68349986 | 2103106.02983212 | 37.75503360932 | -122.424299225131 | (37.75503360932, -122.424299225131) | 2 | 4 | 5 | 28859 | 19 | ||
| 32693 | 46869 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
| 32770 | 60516 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 273 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1982 12:00:00 AM | Permit Number 20119 | 6004763.14449697 | 2099853.52664846 | 37.7460674222913 | -122.42624480255 | (37.7460674222913, -122.42624480255) | 2 | 7 | 5 | 63 | 22 | ||
| 32978 | 66244 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 545 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29343 | 5995212.13315242 | 2091201.87256763 | 37.7217676067917 | -122.458644529473 | (37.7217676067917, -122.458644529473) | 9 | 8 | 6 | 28861 | 24 | ||
| 33032 | 95765 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 200 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767501 | 6004737 | 2091251 | 37.7224453364084 | -122.425723020763 | (37.7224453364084, -122.425723020763) | 9 | 7 | 6 | 28861 | 5 |
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) );