trees
11,635 rows where qSpecies_id = 27 sorted by qSiteInfo
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
118 | 236256 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 151 Valencia St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6006073.15075 | 2108915.83898 | 37.7710243776945 | -122.422358744984 | (37.7710243776945, -122.422358744984) | 8 | 2 | 9 | 28853 | 19 | |||
278 | 247719 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 12 Broderick St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6001402.47389 | 2108783.95066 | 37.770397668046 | -122.438505276404 | (37.770397668046, -122.438505276404) | 15 | 5 | 11 | 29492 | 9 | |||
2082 | 195047 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 06th St | 2 | : | Tree | DPW 1 | 02/25/2002 12:00:00 AM | 3 | Width 3ft | Permit Number 42039 | 6011214.59355 | 2111232.18316 | 37.7776732094966 | -122.404737337955 | (37.7776732094966, -122.404737337955) | 14 | 2 | 9 | 28853 | 34 | |
2322 | 218250 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2751 14th Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 5992235.80201 | 2097238.62713 | 37.738171520993 | -122.469372026199 | (37.738171520993, -122.469372026199) | 1 | 8 | 4 | 59 | 40 | |||
2850 | 178600 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Winston Dr | 6 | : | Tree | Private 2 | 6 | Width 0ft | 5989476.93903 | 2093627.59215 | 37.7280967254778 | -122.478646687712 | (37.7280967254778, -122.478646687712) | 1 | 8 | 4 | 64 | 14 | |||
3538 | 249405 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 430 Turk St | 1 | : | Tree | Private 2 | 8 | Width 4ft | 6007893.39158 | 2113084.10787 | 37.7825719605735 | -122.416357743418 | (37.7825719605735, -122.416357743418) | 7 | 10 | 9 | 28852 | 36 | |||
5700 | 247227 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 754 Duboce Ave | 3 | : | Tree | Private 2 | 13 | Width 4ft | 6002088.83354 | 2108298.92928 | 37.7691049375705 | -122.436096447702 | (37.7691049375705, -122.436096447702) | 15 | 5 | 5 | 29492 | 9 | |||
10038 | 195214 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501 Davidson Ave | 3 | : | Tree | Private 2 | 9 | Width 4ft | 6014827.69575 | 2099442.30699 | 37.7455020460878 | -122.391413870179 | (37.7455020460878, -122.391413870179) | 10 | 3 | 8 | 58 | 1 | |||
12395 | 195067 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501 Bryant St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6008874.83792 | 2108609.10047 | 37.7703397885684 | -122.412645899583 | (37.7703397885684, -122.412645899583) | 8 | 2 | 9 | 28853 | 19 | |||
13379 | 250006 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Starr King Way | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6005940.10765 | 2113829.6095 | 37.784508891608 | -122.423168280499 | (37.784508891608, -122.423168280499) | 13 | 9 | 11 | 28858 | 41 | |||
15448 | 178519 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 74 Kelloch Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6008207.90106 | 2086273.84024 | 37.7089746188665 | -122.413373061735 | (37.7089746188665, -122.413373061735) | 9 | 7 | 8 | 309 | 39 | |||
16684 | 201625 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 401 Galvez Ave | 7 | : | Tree | Private 2 | 11 | Width 3ft | 6021338.5629 | 2093518.11855 | 37.729594575111 | -122.368490962388 | (37.729594575111, -122.368490962388) | 10 | 3 | 8 | 58 | 1 | |||
17253 | 195065 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501 Harrison St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6008838.8659 | 2108569.87412 | 37.7702300631845 | -122.4127675536 | (37.7702300631845, -122.4127675536) | 8 | 2 | 9 | 28853 | 19 | |||
17353 | 195199 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 201 Rankin St | 2 | : | Tree | Private 2 | 7 | Width 4ft | 6014703.6451 | 2099406.06072 | 37.7453956355978 | -122.391840287324 | (37.7453956355978, -122.391840287324) | 10 | 3 | 8 | 58 | 1 | |||
19660 | 236250 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 95 McCoppin St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6006111.46032 | 2109098.98428 | 37.7715294117894 | -122.422239244855 | (37.7715294117894, -122.422239244855) | 8 | 2 | 9 | 28853 | 19 | |||
19901 | 178517 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 328 Schwerin St | 1 | : | Tree | Private 2 | 19 | Width 4ft | 6008541.04755 | 2086224.10569 | 37.7088567573154 | -122.412218142448 | (37.7088567573154, -122.412218142448) | 9 | 7 | 8 | 309 | 39 | |||
19919 | 195198 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 201 Rankin St | 1 | : | Tree | Private 2 | 12 | Width 4ft | 6014650.6097 | 2099336.75033 | 37.7452023793922 | -122.392018830619 | (37.7452023793922, -122.392018830619) | 10 | 3 | 8 | 58 | 1 | |||
21447 | 247727 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 49 Broderick St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6001335.32176 | 2108938.35648 | 37.7708178079159 | -122.438748621246 | (37.7708178079159, -122.438748621246) | 15 | 5 | 11 | 29492 | 9 | |||
22572 | 195244 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2251 Silver Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6012880.31753 | 2096318.78099 | 37.7368172265255 | -122.397928572554 | (37.7368172265255, -122.397928572554) | 10 | 3 | 8 | 58 | 1 | |||
22664 | 247246 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100 Waller St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6000111.42711 | 2108530.98327 | 37.7696295597745 | -122.44295282683 | (37.7696295597745, -122.44295282683) | 15 | 5 | 11 | 29492 | 9 | |||
22905 | 234536 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 330 Valencia St | 2 | : | Tree | Private 2 | 4 | Width 4ft | 6006075.19571 | 2107661.64535 | 37.7675807764555 | -122.422262548987 | (37.7675807764555, -122.422262548987) | 8 | 4 | 5 | 28853 | 19 | |||
23394 | 247746 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 863 Waller St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6001497.53746 | 2108674.50696 | 37.7701025699058 | -122.438168610708 | (37.7701025699058, -122.438168610708) | 15 | 5 | 5 | 29492 | 9 | |||
24229 | 247704 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 824 Waller St | 1 | : | Tree | Private 2 | 16 | Width 5ft | 6001711.33695 | 2108752.87226 | 37.7703298987379 | -122.437434694661 | (37.7703298987379, -122.437434694661) | 15 | 5 | 11 | 29492 | 9 | |||
24346 | 247721 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 20 Broderick St | 2 | : | Tree | Private 2 | 17 | Width 3ft | 6001398.10609 | 2108828.29534 | 37.7705191790463 | -122.438523562338 | (37.7705191790463, -122.438523562338) | 15 | 5 | 11 | 29492 | 9 | |||
25093 | 195165 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 690 Wisconsin St | 2 | : | Tree | Private 2 | 18 | Width 3ft | 6012683.25425 | 2104289.74415 | 37.758692806358 | -122.399169262863 | (37.758692806358, -122.399169262863) | 10 | 3 | 8 | 28856 | 29 | |||
25205 | 195046 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 06th St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6011210.30238 | 2111237.08029 | 37.7776864160348 | -122.404752527502 | (37.7776864160348, -122.404752527502) | 14 | 2 | 9 | 28853 | 34 | |||
25207 | 195055 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 403 06th St | 1 | : | Tree | Private 2 | 23 | Width 3ft | 6011430.17139 | 2111003.88761 | 37.7770584095405 | -122.403975506976 | (37.7770584095405, -122.403975506976) | 14 | 2 | 9 | 28853 | 34 | |||
26238 | 247771 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 801 Waller St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6001750.77286 | 2108707.14029 | 37.7702065720126 | -122.437295011077 | (37.7702065720126, -122.437295011077) | 15 | 5 | 5 | 29492 | 9 | |||
33478 | 249587 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000 Ofarrell St | 1 | : | Tree | Private 2 | 7 | Width 4ft | 6006408.39813 | 2113920.93025 | 37.7847860518873 | -122.421554640444 | (37.7847860518873, -122.421554640444) | 13 | 9 | 11 | 28858 | 41 | |||
34907 | 247773 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 801 Waller St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6001804.9938 | 2108715.66096 | 37.7702330498442 | -122.437108071705 | (37.7702330498442, -122.437108071705) | 15 | 5 | 5 | 29492 | 9 | |||
37252 | 247713 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 880 Waller St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6001495.04463 | 2108722.80835 | 37.7702350517434 | -122.438180694009 | (37.7702350517434, -122.438180694009) | 15 | 5 | 11 | 29492 | 9 | |||
38144 | 195153 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 747 Rhode Island St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6011866.39234 | 2104881.06105 | 37.7602708746342 | -122.402035931016 | (37.7602708746342, -122.402035931016) | 10 | 3 | 8 | 28856 | 29 | |||
38238 | 195063 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1440 Harrison St | 25 | : | Tree | Private 2 | 12 | Width 3ft | 6009088.88483 | 2108916.86222 | 37.7711968415799 | -122.411927260359 | (37.7711968415799, -122.411927260359) | 8 | 2 | 9 | 28853 | 34 | |||
38622 | 234534 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 250 Valencia St | 7 | : | Tree | Private 2 | 3 | Width 4ft | 6006047.64371 | 2108148.24766 | 37.7689153164221 | -122.422392426395 | (37.7689153164221, -122.422392426395) | 8 | 4 | 5 | 28853 | 19 | |||
38842 | 247723 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 36 Broderick St | 1 | : | Tree | Private 2 | 27 | Width 3ft | 6001391.64061 | 2108867.08956 | 37.7706253305347 | -122.438548706468 | (37.7706253305347, -122.438548706468) | 15 | 5 | 11 | 29492 | 9 | |||
40769 | 212741 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 142 Vernon St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5992469.93504 | 2088840.59445 | 37.7151261228375 | -122.467951845594 | (37.7151261228375, -122.467951845594) | 9 | 8 | 6 | 64 | 24 | |||
41233 | 247697 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 72 Central Ave | 1 | : | Tree | Private 2 | 14 | Width 4ft | 5999967.70775 | 2108632.64756 | 37.7699005093291 | -122.443457249359 | (37.7699005093291, -122.443457249359) | 15 | 5 | 11 | 29492 | 9 | |||
41234 | 247772 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 801 Waller St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6001787.28968 | 2108713.82842 | 37.7702270117872 | -122.437169178816 | (37.7702270117872, -122.437169178816) | 15 | 5 | 5 | 29492 | 9 | |||
41249 | 238673 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 85 Saint Germain Ave | 1 | : | Tree | Private 2 | 6 | Width 6ft | 5998049.30483 | 2104134.89853 | 37.757441236042 | -122.449768758028 | (37.757441236042, -122.449768758028) | 15 | 5 | 4 | 28862 | 38 | |||
41904 | 236249 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 95 McCoppin St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6006094.40654 | 2109097.71989 | 37.7715249781286 | -122.422298145049 | (37.7715249781286, -122.422298145049) | 8 | 2 | 9 | 28853 | 19 | |||
42616 | 195181 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 469 Mississippi St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014105.50369 | 2104939.78373 | 37.7605568320595 | -122.394295949124 | (37.7605568320595, -122.394295949124) | 10 | 3 | 8 | 28856 | 29 | |||
43255 | 234555 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 389 Webster St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6004106.69081 | 2110050.71211 | 37.7740293391026 | -122.429241726948 | (37.7740293391026, -122.429241726948) | 7 | 9 | 11 | 29492 | 10 | |||
44283 | 247748 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 855 Waller St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6001543.73976 | 2108680.07706 | 37.7701204915851 | -122.438009196863 | (37.7701204915851, -122.438009196863) | 15 | 5 | 5 | 29492 | 9 | |||
44528 | 195158 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1188 Rhode Island St | 1 | : | Tree | Private 2 | 14 | Width 4ft | 6011916.5871 | 2102892.02207 | 37.7548122137394 | -122.401722520004 | (37.7548122137394, -122.401722520004) | 10 | 3 | 8 | 28856 | 29 | |||
45730 | 218253 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2751 14th Ave | 4 | : | Tree | Private 2 | 16 | Width 3ft | 5992274.63868 | 2097193.69767 | 37.7380504002994 | -122.469234480313 | (37.7380504002994, -122.469234480313) | 1 | 8 | 4 | 59 | 40 | |||
46438 | 247703 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 Waller St | 5 | : | Tree | Private 2 | 8 | Width 4ft | 6001741.79294 | 2108758.83097 | 37.7703479913065 | -122.437329774362 | (37.7703479913065, -122.437329774362) | 15 | 5 | 11 | 29492 | 9 | |||
46633 | 247168 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 165 Buena Vista Ave East | 2 | : | Tree | Private 2 | 2 | Width 5ft | 6001401.68664 | 2108432.37227 | 37.7694322764028 | -122.438482805937 | (37.7694322764028, -122.438482805937) | 15 | 5 | 5 | 29492 | 9 | |||
46795 | 247699 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 Waller St | 1 | : | Tree | Private 2 | 8 | Width 4ft | 6001818.73975 | 2108768.05732 | 37.7703776985995 | -122.437064276515 | (37.7703776985995, -122.437064276515) | 15 | 5 | 11 | 29492 | 9 | |||
47237 | 234563 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2901 Mariposa St | 3 | : | Tree | Private 2 | 19 | Width 4ft | 6008912.29955 | 2105878.19903 | 37.7628434671624 | -122.412323267827 | (37.7628434671624, -122.412323267827) | 8 | 4 | 7 | 28859 | 19 | |||
47835 | 234533 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Valencia St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6006066.34871 | 2109048.22957 | 37.7713875068512 | -122.422391681731 | (37.7713875068512, -122.422391681731) | 8 | 2 | 9 | 28853 | 19 | |||
48368 | 234546 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 390 Valencia St | 3 | : | Tree | Private 2 | 8 | Width 4ft | 6006093.30748 | 2107339.39133 | 37.7666969650198 | -122.422177005484 | (37.7666969650198, -122.422177005484) | 8 | 4 | 5 | 28853 | 19 | |||
48709 | 247769 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 845 Waller St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6001717.5162 | 2108703.54506 | 37.7701948097837 | -122.437409787932 | (37.7701948097837, -122.437409787932) | 15 | 5 | 5 | 29492 | 9 | |||
50022 | 195029 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 603 02nd St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6013830.29257 | 2113762.02506 | 37.7847654277311 | -122.395865995416 | (37.7847654277311, -122.395865995416) | 6 | 2 | 9 | 28856 | 6 | |||
50256 | 195044 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 363 06th St | 4 | : | Tree | Private 2 | 12 | Width 3ft | 6011215.55292 | 2111326.94957 | 37.7779334696865 | -122.40474069243 | (37.7779334696865, -122.40474069243) | 14 | 2 | 9 | 28856 | 34 | |||
50538 | 234560 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 7 Octavia St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6005652.57574 | 2109436.18865 | 37.772429399337 | -122.423850535 | (37.772429399337, -122.423850535) | 7 | 9 | 11 | 28852 | 10 | |||
50550 | 234545 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 390 Valencia St | 2 | : | Tree | Private 2 | 4 | Width 4ft | 6006091.71874 | 2107360.04302 | 37.7667535800508 | -122.422183968027 | (37.7667535800508, -122.422183968027) | 8 | 4 | 5 | 28853 | 19 | |||
51984 | 195168 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 690 Wisconsin St | 7 | : | Tree | Private 2 | 17 | Width 3ft | 6012685.05223 | 2104255.68233 | 37.7585993802777 | -122.399160653651 | (37.7585993802777, -122.399160653651) | 10 | 3 | 8 | 28856 | 29 | |||
51989 | 195218 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501 Davidson Ave | 7 | : | Tree | Private 2 | 8 | Width 4ft | 6014967.27978 | 2099336.85287 | 37.7452202372225 | -122.390923837661 | (37.7452202372225, -122.390923837661) | 10 | 3 | 8 | 58 | 1 | |||
52588 | 247700 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 Waller St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6001801.87342 | 2108765.96342 | 37.7703709905579 | -122.437122467121 | (37.7703709905579, -122.437122467121) | 15 | 5 | 11 | 29492 | 9 | |||
53542 | 247749 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 855 Waller St | 2 | : | Tree | Private 2 | 15 | Width 3ft | 6001558.52342 | 2108681.81075 | 37.7701260925823 | -122.437958184647 | (37.7701260925823, -122.437958184647) | 15 | 5 | 5 | 29492 | 9 | |||
55890 | 195066 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501 Harrison St | 2 | : | Tree | Private 2 | 10 | Width 3ft | 6008855.0352 | 2108588.85086 | 37.7702830764251 | -122.412712965653 | (37.7702830764251, -122.412712965653) | 8 | 2 | 9 | 28853 | 19 | |||
56297 | 195061 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1140 Harrison St | 4 | : | Tree | Private 2 | 6 | Width 3ft | 6010383.57672 | 2110052.37077 | 37.7743872369211 | -122.407528919945 | (37.7743872369211, -122.407528919945) | 14 | 2 | 9 | 28853 | 34 | |||
56383 | 195182 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 469 Mississippi St | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6014105.1082 | 2104950.44493 | 37.7605860834115 | -122.394298063409 | (37.7605860834115, -122.394298063409) | 10 | 3 | 8 | 28856 | 29 | |||
57145 | 247712 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 876 Waller St | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6001514.06581 | 2108723.89481 | 37.7702391166779 | -122.438114977827 | (37.7702391166779, -122.438114977827) | 15 | 5 | 11 | 29492 | 9 | |||
58666 | 195163 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 787 Wisconsin St | 1 | : | Tree | Private 2 | 14 | Width 6ft | 6012760.96484 | 2103859.57999 | 37.7575160002684 | -122.398870312036 | (37.7575160002684, -122.398870312036) | 10 | 3 | 8 | 28856 | 29 | |||
58831 | 195045 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 312 06th St | 1 | : | Tree | DPW 1 | 10 | Width 3ft | 6010980.17572 | 2111476.79231 | 37.7783317443601 | -122.405565505645 | (37.7783317443601, -122.405565505645) | 14 | 2 | 9 | 28853 | 34 | |||
59527 | 249591 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000 Ofarrell St | 5 | : | Tree | Private 2 | 13 | Width 4ft | 6006303.77672 | 2113904.77053 | 37.7847357815627 | -122.421915448459 | (37.7847357815627, -122.421915448459) | 13 | 9 | 11 | 28858 | 41 | |||
61901 | 247715 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 894 Waller St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6001455.5652 | 2108715.07131 | 37.7702115623373 | -122.438316698476 | (37.7702115623373, -122.438316698476) | 15 | 5 | 11 | 29492 | 9 | |||
62885 | 195245 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1808 Newhall St | 2 | : | Tree | Private 2 | 3 | Width 2ft | 6013672.6153 | 2094756.94757 | 37.7325728473411 | -122.395079867451 | (37.7325728473411, -122.395079867451) | 10 | 3 | 8 | 58 | 1 | |||
63016 | 234562 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2901 Mariposa St | 2 | : | Tree | Private 2 | 14 | Width 4ft | 6008881.39711 | 2105875.21762 | 37.7628335467539 | -122.412429938194 | (37.7628335467539, -122.412429938194) | 8 | 4 | 7 | 28859 | 19 | |||
63221 | 247226 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 754 Duboce Ave | 2 | : | Tree | Private 2 | 5 | Width 4ft | 6002102.7276 | 2108299.74329 | 37.7691079619876 | -122.43604844729 | (37.7691079619876, -122.43604844729) | 15 | 5 | 5 | 29492 | 9 | |||
63320 | 246913 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 455 Frederick St | 1 | : | Tree | Private 2 | 14 | Width 4ft | 5997595.30029 | 2107440.49216 | 37.7664915751467 | -122.451577310862 | (37.7664915751467, -122.451577310862) | 15 | 5 | 11 | 29492 | 9 | |||
66271 | 247714 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 888 Waller St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6001473.17505 | 2108719.80654 | 37.7702255656925 | -122.438256125528 | (37.7702255656925, -122.438256125528) | 15 | 5 | 11 | 29492 | 9 | |||
67725 | 178596 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Winston Dr | 1 | : | Tree | Private 2 | 10 | Width 0ft | 5989485.56542 | 2093493.23297 | 37.7277283101093 | -122.478607044688 | (37.7277283101093, -122.478607044688) | 1 | 8 | 4 | 64 | 14 | |||
67898 | 195157 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1186 Rhode Island St | 1 | : | Tree | Private 2 | 17 | Width 4ft | 6011914.58494 | 2102915.14043 | 37.7548755799578 | -122.401731068949 | (37.7548755799578, -122.401731068949) | 10 | 3 | 8 | 28856 | 29 | |||
68483 | 195177 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 394 19th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6013172.75141 | 2105230.87083 | 37.7613042010408 | -122.397542351521 | (37.7613042010408, -122.397542351521) | 10 | 3 | 8 | 28856 | 29 | |||
68882 | 250975 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 7010 California St | 4 | : | Tree | Private 2 | 2 | Width 4ft | 5985704.58491 | 2113917.15567 | 37.7835865343301 | -122.493181741967 | (37.7835865343301, -122.493181741967) | 11 | 6 | 1 | 55 | 33 | |||
69369 | 195054 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 820 Bryant St | 1 | : | Tree | Private 2 | 18 | Width 3ft | 6011686.5663 | 2110516.64779 | 37.7757348827023 | -122.403054272047 | (37.7757348827023, -122.403054272047) | 14 | 2 | 9 | 28853 | 34 | |||
70525 | 247747 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 863 Waller St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6001518.0666 | 2108676.73344 | 37.770109850805 | -122.438097760312 | (37.770109850805, -122.438097760312) | 15 | 5 | 5 | 29492 | 9 | |||
70760 | 236253 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 95 McCoppin St | 5 | : | Tree | Private 2 | 11 | Width 3ft | 6006170.16969 | 2109101.81576 | 37.771540497736 | -122.42203636681 | (37.771540497736, -122.42203636681) | 8 | 2 | 9 | 28853 | 19 | |||
71156 | 249510 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1301 Van Ness Ave | 5 | : | Tree | Private 2 | 7 | Width 1ft | 6006317.71181 | 2114977.48986 | 37.7876819902699 | -122.421943465924 | (37.7876819902699, -122.421943465924) | 13 | 9 | 1 | 28858 | 41 | |||
71423 | 178515 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 304 Schwerin St | 1 | : | Tree | Private 2 | 22 | Width 5ft | 6008576.98547 | 2086321.37555 | 37.7091258569317 | -122.412100805216 | (37.7091258569317, -122.412100805216) | 9 | 7 | 8 | 309 | 39 | |||
73109 | 247248 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100 Waller St | 3 | : | Tree | Private 2 | 9 | Width 3ft | 6000080.03929 | 2108527.4495 | 37.7696180673454 | -122.443061142079 | (37.7696180673454, -122.443061142079) | 15 | 5 | 11 | 29492 | 9 | |||
73209 | 250051 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1338 Franklin St | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6005935.36197 | 2114756.97743 | 37.787054946975 | -122.42325064312 | (37.787054946975, -122.42325064312) | 13 | 9 | 1 | 28858 | 41 | |||
73385 | 195217 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501 Davidson Ave | 6 | : | Tree | Private 2 | 7 | Width 4ft | 6014951.13752 | 2099351.9188 | 37.7452607094218 | -122.390980708107 | (37.7452607094218, -122.390980708107) | 10 | 3 | 8 | 58 | 1 | |||
73739 | 195202 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 201 Rankin St | 5 | : | Tree | Private 2 | 8 | Width 4ft | 6014746.50414 | 2099463.98706 | 37.7455570684194 | -122.391696135872 | (37.7455570684194, -122.391696135872) | 10 | 3 | 8 | 58 | 1 | |||
75210 | 234532 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 115 Valencia St | 1 | : | Tree | Private 2 | 11 | Width 4ft | 6006067.08782 | 2109011.03469 | 37.7712854203131 | -122.422386481876 | (37.7712854203131, -122.422386481876) | 8 | 2 | 9 | 28853 | 19 | |||
75260 | 195041 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 402 06th St | 1 | : | Tree | DPW 1 | 28 | Width 3ft | 6011480.36813 | 2111044.01847 | 37.7771714039683 | -122.403804684362 | (37.7771714039683, -122.403804684362) | 14 | 2 | 9 | 28856 | 34 | |||
76703 | 195215 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501 Davidson Ave | 4 | : | Tree | Private 2 | 9 | Width 4ft | 6014851.78372 | 2099427.08038 | 37.7454615738897 | -122.391329512854 | (37.7454615738897, -122.391329512854) | 10 | 3 | 8 | 58 | 1 | |||
77618 | 247716 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 894 Waller St | 2 | : | Tree | Private 2 | 14 | Width 3ft | 6001434.3903 | 2108713.70034 | 37.7702065935938 | -122.438389843923 | (37.7702065935938, -122.438389843923) | 15 | 5 | 11 | 29492 | 9 | |||
77970 | 249497 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1765 California St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6005893.50071 | 2115878.24568 | 37.7901313082605 | -122.423475218205 | (37.7901313082605, -122.423475218205) | 13 | 9 | 1 | 28858 | 41 | |||
78044 | 247249 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100 Waller St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 6000067.79858 | 2108524.98288 | 37.7696105966925 | -122.443103304968 | (37.7696105966925, -122.443103304968) | 15 | 5 | 11 | 29492 | 9 | |||
78322 | 195201 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 201 Rankin St | 4 | : | Tree | Private 2 | 7 | Width 4ft | 6014735.86247 | 2099450.505 | 37.745519458775 | -122.391731990932 | (37.745519458775, -122.391731990932) | 10 | 3 | 8 | 58 | 1 | |||
78504 | 247701 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 Waller St | 3 | : | Tree | Private 2 | 11 | Width 4ft | 6001785.70024 | 2108763.50636 | 37.7703633247418 | -122.43717823411 | (37.7703633247418, -122.43717823411) | 15 | 5 | 11 | 29492 | 9 | |||
78609 | 249502 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1765 California St | 6 | : | Tree | Private 2 | 11 | Width 3ft | 6005987.72763 | 2115889.97486 | 37.7901688315689 | -122.423150034159 | (37.7901688315689, -122.423150034159) | 13 | 9 | 1 | 28858 | 41 | |||
79591 | 195246 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1638 Kirkwood Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014988.0451 | 2096950.5651 | 37.7386691365775 | -122.390685308687 | (37.7386691365775, -122.390685308687) | 10 | 3 | 8 | 58 | 1 | |||
80230 | 195216 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501 Davidson Ave | 5 | : | Tree | Private 2 | 7 | Width 4ft | 6014904.95641 | 2099386.15345 | 37.7453521479783 | -122.391142788429 | (37.7453521479783, -122.391142788429) | 10 | 3 | 8 | 58 | 1 | |||
80767 | 195057 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 109 Harrison St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6010680.65818 | 2110429.45219 | 37.7754392395602 | -122.406527831496 | (37.7754392395602, -122.406527831496) | 8 | 2 | 9 | 28853 | 34 | |||
80837 | 234561 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 600 Duboce Ave | 4 | : | Tree | Private 2 | 4 | Width 5ft | 6002820.93135 | 2108336.92419 | 37.7692508273841 | -122.433566882319 | (37.7692508273841, -122.433566882319) | 15 | 5 | 5 | 29492 | 9 | |||
81061 | 247725 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 49 Broderick St | 2 | : | Tree | Private 2 | 19 | Width 5ft | 6001330.00617 | 2108965.19653 | 37.7708912015977 | -122.438768931557 | (37.7708912015977, -122.438768931557) | 15 | 5 | 11 | 29492 | 9 |
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) );