trees
8,659 rows where qSpecies_id = 11 sorted by TreeID 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 152273 | 99984 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 535 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
| 173075 | 99983 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 535@Clay Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
| 165282 | 99957 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 308 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2012 12:00:00 AM | 3 | 7x7 | Permit Number 768921 | 5998118.54102 | 2115379.99567 | 37.7883213434981 | -122.450339905768 | (37.7883213434981, -122.450339905768) | 13 | 6 | 1 | 54 | 31 | |
| 74500 | 99945 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 499X FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769035 | 6014477 | 2114572 | 37.787025389439 | -122.393685294607 | (37.787025389439, -122.393685294607) | 6 | 2 | 9 | 28855 | 6 | |
| 127896 | 99910 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 710 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 769055 | 5986442 | 2114842 | 37.7861689922045 | -122.490698673964 | (37.7861689922045, -122.490698673964) | 11 | 6 | 1 | 55 | 33 | |||
| 108734 | 9935 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1540 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6004965.3085 | 2119892.9444 | 37.8011022176998 | -122.426972746439 | (37.8011022176998, -122.426972746439) | 13 | 9 | 1 | 57 | 17 | |||
| 104979 | 99305 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1345 Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2012 12:00:00 AM | 2 | Permit Number 768843 | 6003570.3 | 2112353.3 | 37.7803212947721 | -122.431261586889 | (37.7803212947721, -122.431261586889) | 15 | 9 | 11 | 29490 | 41 | ||
| 105623 | 99304 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1345 Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2012 12:00:00 AM | 2 | Permit Number 768843 | 6003570.3 | 2112353.3 | 37.7803212947721 | -122.431261586889 | (37.7803212947721, -122.431261586889) | 15 | 9 | 11 | 29490 | 41 | ||
| 101345 | 9929 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2221 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1990 12:00:00 AM | 9 | 3X3 | 6005046.52749 | 2117287.74508 | 37.7939535969247 | -122.426506085481 | (37.7939535969247, -122.426506085481) | 13 | 9 | 1 | 28858 | 27 | ||
| 52321 | 99246 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 590X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008037.7 | 2113792.5 | 37.7845251480988 | -122.415908676516 | (37.7845251480988, -122.415908676516) | 7 | 10 | 9 | 28858 | 36 | |||
| 55556 | 99245 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 590X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6008204 | 2113818 | 37.784604512923 | -122.41533513918 | (37.784604512923, -122.41533513918) | 7 | 10 | 9 | 28858 | 36 | |||
| 122581 | 99224 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 201@ Mariposa Missouri St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12.5x6 | 6013503.3 | 2106114.2 | 37.7637480286929 | -122.396461033594 | (37.7637480286929, -122.396461033594) | 14 | 3 | 8 | 28856 | 29 | ||||
| 157134 | 99222 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 201@ Mariposa Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7.5x6 | 6013503.3 | 2106114.2 | 37.7637480286929 | -122.396461033594 | (37.7637480286929, -122.396461033594) | 14 | 3 | 8 | 28856 | 29 | ||||
| 138273 | 99106 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1400 Evans Ave | 3 | Front Yard : Yard | Tree | Private 2 | 04/09/2012 12:00:00 AM | Permit Number 768768 | 6016404 | 2098045.1 | 37.7417529632601 | -122.385865834439 | (37.7417529632601, -122.385865834439) | 10 | 3 | 8 | 58 | 1 | |||
| 26236 | 99105 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1400@ Mendell Evans Ave | 1 | Front Yard : Yard | Tree | Private 2 | 04/09/2012 12:00:00 AM | Permit Number 768768 | 6016404 | 2098045.1 | 37.7417529632601 | -122.385865834439 | (37.7417529632601, -122.385865834439) | 10 | 3 | 8 | 58 | 1 | |||
| 150390 | 99101 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 55x Santa Monica Way | 1 | Median : Yard | Tree | Private 2 | 04/07/2012 12:00:00 AM | Permit Number 768464 | 5993693.6 | 2097654.3 | 37.7393969918941 | -122.464361897304 | (37.7393969918941, -122.464361897304) | 1 | 8 | 4 | 59 | 40 | |||
| 187809 | 99099 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 65X Santa Monica Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2012 12:00:00 AM | Permit Number 768467 | 5993743.4 | 2097365.9 | 37.7386079879791 | -122.464168780849 | (37.7386079879791, -122.464168780849) | 1 | 8 | 4 | 59 | 40 | |||
| 146154 | 99098 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 66 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2012 12:00:00 AM | Permit Number 768466 | 5993736.6 | 2097303.5 | 37.7384362612216 | -122.464187762983 | (37.7384362612216, -122.464187762983) | 1 | 8 | 4 | 59 | 40 | |||
| 120411 | 99090 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 677 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6006238 | 2105632 | 37.762017031056 | -122.421555263176 | (37.762017031056, -122.421555263176) | 8 | 4 | 7 | 28859 | 19 | |||
| 110418 | 99083 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 699X Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/04/2010 12:00:00 AM | 3 | 3x3 | 6006248.38684 | 2105527.75981 | 37.7617313976 | -122.421511935601 | (37.7617313976, -122.421511935601) | 8 | 4 | 7 | 28859 | 19 | ||
| 148665 | 99082 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 511 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2012 12:00:00 AM | 3 | 3x3 | 6006244.53682 | 2106614.02725 | 37.7647138154977 | -122.421602404791 | (37.7647138154977, -122.421602404791) | 8 | 4 | 7 | 28859 | 19 | ||
| 193940 | 99081 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 511 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2012 12:00:00 AM | 3 | 3x3 | 6006244.53682 | 2106614.02725 | 37.7647138154977 | -122.421602404791 | (37.7647138154977, -122.421602404791) | 8 | 4 | 7 | 28859 | 19 | ||
| 183310 | 99069 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 599 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/04/2010 12:00:00 AM | 3 | 3x3 | 6006292.32281 | 2106190.86011 | 37.7635545925838 | -122.421407071207 | (37.7635545925838, -122.421407071207) | 8 | 4 | 7 | 28859 | 19 | ||
| 120993 | 99054 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 502 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x6 | 6006083.07455 | 2106599.19361 | 37.7646639800831 | -122.422159807273 | (37.7646639800831, -122.422159807273) | 8 | 4 | 5 | 28859 | 19 | |||
| 76350 | 99051 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 405 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 6006224.94631 | 2107231.94891 | 37.7664093776727 | -122.421714056291 | (37.7664093776727, -122.421714056291) | 8 | 4 | 7 | 28853 | 19 | |||
| 26732 | 9905 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1801 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3X3 | Permit Number 779094 | 6005234.1394 | 2115947.34634 | 37.790283803614 | -122.425761478317 | (37.790283803614, -122.425761478317) | 13 | 9 | 1 | 28858 | 27 | |
| 135810 | 99042 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 412 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 6006090.04336 | 2107187.69047 | 37.7662802463103 | -122.422177516849 | (37.7662802463103, -122.422177516849) | 8 | 4 | 5 | 28853 | 19 | |||
| 32799 | 99041 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 400 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006087.58569 | 2107232.04635 | 37.7664018984216 | -122.422189169062 | (37.7664018984216, -122.422189169062) | 8 | 4 | 5 | 28853 | 19 | |||
| 87127 | 99008 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
| 152727 | 99006 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
| 16686 | 99005 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
| 76955 | 99004 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
| 45985 | 99003 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
| 94774 | 99002 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |||
| 161524 | 99001 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |||
| 76830 | 99000 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |||
| 35671 | 99 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6002314.25424 | 2107678.41928 | 37.7674139737948 | -122.435272341345 | (37.7674139737948, -122.435272341345) | 15 | 5 | 5 | 28862 | 3 | |||
| 141911 | 98998 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |||
| 15243 | 98997 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | ||||
| 170079 | 9897 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800X Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/31/2017 11:04:00 AM | 3 | 3X3 | 6004987.6321 | 2115455.9012 | 37.788920485652 | -122.426579366951 | (37.788920485652, -122.426579366951) | 13 | 9 | 1 | 28858 | 27 | ||
| 68945 | 9896 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2007 12:00:00 AM | 3 | 3X3 | 6004999.6173 | 2115457.4476 | 37.7889254092316 | -122.426538009917 | (37.7889254092316, -122.426538009917) | 13 | 9 | 1 | 28858 | 27 | ||
| 97664 | 98958 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 401 Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
| 117773 | 98957 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 401 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
| 144732 | 98956 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 401 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
| 190857 | 98955 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 401 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
| 49182 | 9893 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1700 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6005337.6793 | 2115599.88016 | 37.7893355988943 | -122.425378500212 | (37.7893355988943, -122.425378500212) | 13 | 9 | 1 | 28858 | 41 | |||
| 175842 | 98899 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1440X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013939 | 2096227 | 37.7366241191951 | -122.39426179075 | (37.7366241191951, -122.39426179075) | 10 | 3 | 8 | 58 | 1 | |||
| 37231 | 98898 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1420 Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013939 | 2096227 | 37.7366241191951 | -122.39426179075 | (37.7366241191951, -122.39426179075) | 10 | 3 | 8 | 58 | 1 | |||
| 82771 | 9887 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1666 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005367.96574 | 2115336.46074 | 37.7886140260739 | -122.425254960342 | (37.7886140260739, -122.425254960342) | 13 | 9 | 1 | 28858 | 41 | |||
| 70149 | 98853 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4043X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 5991835.94326 | 2086997.82238 | 37.710029684074 | -122.470009076276 | (37.710029684074, -122.470009076276) | 9 | 8 | 4 | 64 | 24 | |||||
| 76089 | 98585 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2415 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015851.26334 | 2104350.49273 | 37.7590356503023 | -122.388216981957 | (37.7590356503023, -122.388216981957) | 10 | 3 | 8 | 28856 | 29 | ||||
| 28294 | 98584 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2415 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015851.26334 | 2104350.49273 | 37.7590356503023 | -122.388216981957 | (37.7590356503023, -122.388216981957) | 10 | 3 | 8 | 28856 | 29 | ||||
| 189287 | 98413 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 790 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002783 | 2109590 | 37.7726893128067 | -122.433787659392 | (37.7726893128067, -122.433787659392) | 15 | 5 | 11 | 29492 | 9 | ||||
| 102973 | 9832 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1103 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2009 12:00:00 AM | 3 | 4X4 | 6005549.67699 | 2113553.49893 | 37.7837287192729 | -122.424499392125 | (37.7837287192729, -122.424499392125) | 7 | 9 | 11 | 28858 | 41 | ||
| 179169 | 9831 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1103 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/23/2012 12:00:00 AM | 3 | 3x3 | 6005549.67699 | 2113553.49893 | 37.7837287192729 | -122.424499392125 | (37.7837287192729, -122.424499392125) | 7 | 9 | 11 | 28858 | 41 | ||
| 123649 | 98302 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 6 Locksley Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5994194 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | 1 | 5 | 4 | 56 | 12 | |||||
| 180522 | 98301 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 6 Locksley Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5994194 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | 1 | 5 | 4 | 56 | 12 | |||||
| 114999 | 98249 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | I believe these were planted in 2010 by FUF. | 6007258.63749 | 2113341.44217 | 37.7832428233388 | -122.418571977707 | (37.7832428233388, -122.418571977707) | 7 | 9 | 9 | 28858 | 36 | |
| 16642 | 98248 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | I believe these were planted in 2010 by FUF. C.Buck | 6007281.49549 | 2113344.84788 | 37.7832534614285 | -122.41849313956 | (37.7832534614285, -122.41849313956) | 7 | 9 | 9 | 28858 | 36 | |
| 50203 | 98247 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | I think these were planted in 2010 by FUF. | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | 7 | 9 | 9 | 28858 | 36 | ||
| 182222 | 98246 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | I think these were planted by FUF in 2010. C.Buck | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | 7 | 9 | 9 | 28858 | 36 | ||
| 66264 | 98174 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2637 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010674.2 | 2102223.2 | 37.7529063677509 | -122.405971946405 | (37.7529063677509, -122.405971946405) | 10 | 4 | 8 | 28859 | 19 | ||||
| 179691 | 98109 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2754 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2011 12:00:00 AM | 5 | 3x3 | Permit Number 768562 | 6004422.19039 | 2118602.65573 | 37.7975286916446 | -122.428760135465 | (37.7975286916446, -122.428760135465) | 13 | 9 | 1 | 57 | 17 | |
| 102522 | 98108 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 850 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001068 | 2114562 | 37.7862436951175 | -122.440076605796 | (37.7862436951175, -122.440076605796) | 13 | 6 | 1 | 29490 | 27 | |||
| 90515 | 98107 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 850 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001068 | 2114562 | 37.7862436951175 | -122.440076605796 | (37.7862436951175, -122.440076605796) | 13 | 6 | 1 | 29490 | 27 | |||
| 113124 | 98106 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 850 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001068 | 2114562 | 37.7862436951175 | -122.440076605796 | (37.7862436951175, -122.440076605796) | 13 | 6 | 1 | 29490 | 27 | |||
| 48998 | 98105 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 850 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001068 | 2114562 | 37.7862436951175 | -122.440076605796 | (37.7862436951175, -122.440076605796) | 13 | 6 | 1 | 29490 | 27 | |||
| 111531 | 9800 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | ||
| 98911 | 98 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002352.63479 | 2107680.76294 | 37.7674225884029 | -122.435139756108 | (37.7674225884029, -122.435139756108) | 15 | 5 | 5 | 28862 | 3 | |||
| 147003 | 9799 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/30/2006 12:00:00 AM | 30 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | ||
| 173276 | 9797 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | ||
| 32890 | 9796 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/08/2006 12:00:00 AM | 3X3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 152187 | 9795 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 26 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 94516 | 9794 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 26 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 139725 | 9793 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 40 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 633 | 9792 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 132578 | 9791 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 175880 | 9790 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 40 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 25322 | 9783 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 115788 | 9782 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/25/1997 12:00:00 AM | 12 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | ||
| 159184 | 9781 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 15513 | 9780 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 128881 | 9778 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 18990 | 97775 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 639 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2014 12:00:00 AM | 3 | Permit Number 773141 | 5991602.6 | 2111067.7 | 37.7761059040631 | -122.472569257531 | (37.7761059040631, -122.472569257531) | 11 | 6 | 2 | 54 | 26 | ||
| 7597 | 9777 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 47663 | 9776 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 125043 | 9775 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 40 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 30006 | 9774 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 05/26/1992 12:00:00 AM | 34 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | ||
| 150401 | 9773 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/25/1997 12:00:00 AM | 18 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | ||
| 102172 | 97726 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 4x4 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | ||
| 97520 | 9772 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 880X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6005733.11038 | 2112704.49078 | 37.7814079088132 | -122.423804392248 | (37.7814079088132, -122.423804392248) | 7 | 9 | 11 | 28852 | 41 | |||
| 118889 | 9771 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 880X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6005733.11038 | 2112704.49078 | 37.7814079088132 | -122.423804392248 | (37.7814079088132, -122.423804392248) | 7 | 9 | 11 | 28852 | 41 | |||
| 143042 | 9770 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 880X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6005733.11038 | 2112704.49078 | 37.7814079088132 | -122.423804392248 | (37.7814079088132, -122.423804392248) | 7 | 9 | 11 | 28852 | 41 | |||
| 147026 | 9769 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 880X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6005733.11038 | 2112704.49078 | 37.7814079088132 | -122.423804392248 | (37.7814079088132, -122.423804392248) | 7 | 9 | 11 | 28852 | 41 | |||
| 76283 | 9768 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 720 Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/04/2014 03:01:00 PM | 3 | 3x3 | 6005810.3094046 | 2112150.9834888 | 37.7798924709779 | -122.423497958027 | (37.7798924709779, -122.423497958027) | 7 | 9 | 11 | 28852 | 41 | ||
| 105189 | 9767 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 720 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1997 12:00:00 AM | 8 | 3x3 | 6005824.48648 | 2112196.6775 | 37.7800187357496 | -122.42345216256 | (37.7800187357496, -122.42345216256) | 7 | 9 | 11 | 28852 | 41 | ||
| 98787 | 9760 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 745 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1990 12:00:00 AM | 12 | 3x3 | 6005731.04498 | 2112345.55339 | 37.7804222381015 | -122.423786007836 | (37.7804222381015, -122.423786007836) | 7 | 9 | 11 | 28852 | 41 | ||
| 128243 | 9759 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 745 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/1990 12:00:00 AM | 12 | 3x3 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | 7 | 9 | 11 | 28852 | 41 | ||
| 24564 | 9757 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 735 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2011 12:00:00 AM | 3 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | 7 | 9 | 11 | 28852 | 41 | ||
| 162321 | 9756 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 735 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/05/2005 12:00:00 AM | 8 | 4x4 | 6005741.53964 | 2112282.65586 | 37.7802501293077 | -122.423745228365 | (37.7802501293077, -122.423745228365) | 7 | 9 | 11 | 28852 | 41 |
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) );