trees

5,599 rows where qSpecies_id = 38 sorted by qSiteInfo

✎ View and edit SQL

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)
648 189633 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 10 : Tree Private 2     10 Width 3ft   6007281.55408 2110475.16176 37.775373998252 -122.418289406239 (37.775373998252, -122.418289406239) 8 2 9 28853 34
649 189627 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 4 : Tree Private 2     16 Width 3ft   6007528.52851 2110215.72509 37.7746755460784 -122.417416671761 (37.7746755460784, -122.417416671761) 8 2 9 28853 34
1042 189625 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 2 : Tree Private 2     18 Width 3ft   6007555.58457 2110185.16197 37.7745931492825 -122.417320912844 (37.7745931492825, -122.417320912844) 8 2 9 28853 34
3047 189052 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1498 Fairfax Ave 9 : Tree Private 2   04/13/2020 12:00:00 AM 3 Width 4ft   6016122.19881 2097851.77649 37.7412065377553 -122.386826739572 (37.7412065377553, -122.386826739572) 10 3 8 58 1
3164 249333 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 840 Post St 4 : Tree Private 2     15 Width 4ft   6008047.50765 2114838.3401 37.7873973224712 -122.415948831592 (37.7873973224712, -122.415948831592) 13 1 10 28858 21
5848 189784 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 230 Texas St 1 : Tree Private 2     20 Width 4ft   6013708.09947 2105987.51004 37.7634115608072 -122.39574381262 (37.7634115608072, -122.39574381262) 14 3 8 28856 29
8438 189632 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 9 : Tree Private 2     7 Width 3ft   6007298.00895 2110457.3775 37.7753260931545 -122.4182312237 (37.7753260931545, -122.4182312237) 8 2 9 28853 34
10727 190148 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1711 Oakdale Ave 1 : Tree Private 2     6 Width 3ft   6014397.54059 2095926.93864 37.7358256897857 -122.392655422032 (37.7358256897857, -122.392655422032) 10 3 8 58 1
11011 249339 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 839 Post St 1 : Tree Private 2     13 Width 3ft   6008120.77004 2114802.70738 37.7873036023197 -122.415692834155 (37.7873036023197, -122.415692834155) 13 1 9 28858 36
11305 189630 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 7 : Tree Private 2     14 Width 3ft   6007441.71426 2110305.43642 37.7749169870715 -122.417723340559 (37.7749169870715, -122.417723340559) 8 2 9 28853 34
11597 189629 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 6 : Tree Private 2     16 Width 3ft   6007461.61467 2110284.7901 37.774861417042 -122.417653036967 (37.774861417042, -122.417653036967) 8 2 9 28853 34
11615 189628 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 5 : Tree Private 2     11 Width 3ft   6007505.86156 2110238.1728 37.7747359067747 -122.417496672745 (37.7747359067747, -122.417496672745) 8 2 9 28853 34
12034 189635 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 12 : Tree Private 2     13 Width 3ft   6007252.77598 2110507.15575 37.7754602261381 -122.418391225675 (37.7754602261381, -122.418391225675) 8 2 9 28853 34
12375 226540 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1220 Potrero Ave 2 : Tree Private 2     28 Width 4ft   6010529.29654 2102158.63708 37.752720986907 -122.406468503221 (37.752720986907, -122.406468503221) 10 4 7 28859 19
12427 189631 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 8 : Tree Private 2     9 Width 3ft   6007308.18753 2110441.11785 37.7752820209699 -122.418194860528 (37.7752820209699, -122.418194860528) 8 2 9 28853 34
12592 190145 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1270 Fairfax Ave 5 : Tree Private 2     16 Width 4ft   6017279.69898 2096994.64423 37.7389170445949 -122.38276484453 (37.7389170445949, -122.38276484453) 10 3 8 58 1
12810 189626 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 3 : Tree Private 2     14 Width 3ft   6007544.58338 2110195.50679 37.7746209347449 -122.417359701486 (37.7746209347449, -122.417359701486) 8 2 9 28853 34
12986 189793 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 308 Hernandez Ave 1 : Tree Private 2     13 Width 3ft   6013450.09241 2105609.9853 37.7623606049856 -122.396609715861 (37.7623606049856, -122.396609715861) 10 3 8 28856 29
15146 92502 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 645 05th St 3 : Tree Private 2     23     6013059.80814 2110709.87576 37.7763420329883 -122.398317413322 (37.7763420329883, -122.398317413322) 6 2 9 28856 34
17091 189634 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 11 : Tree Private 2     7 Width 3ft   6007263.01198 2110493.68646 37.7754238188976 -122.418354861603 (37.7754238188976, -122.418354861603) 8 2 9 28853 34
18035 189589 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 15 Stillman St 4 : Tree Private 2     15 Width 3ft   6014277.53935 2113227.76018 37.7833233297614 -122.394281237993 (37.7833233297614, -122.394281237993) 6 2 9 28856 6
18082 190134 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 599 Barneveld Ave 2 : Tree Private 2     2 Width 2ft   6011052.12686 2097137.70773 37.7389638381042 -122.404307086999 (37.7389638381042, -122.404307086999) 10 3 8 58 1
19142 189624 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 1 : Tree Private 2     18 Width 3ft   6007595.48584 2110148.75293 37.7744954235495 -122.417180305629 (37.7744954235495, -122.417180305629) 8 2 9 28853 34
19234 127064 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3252 Pierce St 4 : Tree Private 2     8 Width 3ft   6001385.25853 2119550.33485 37.7999584196931 -122.439336666363 (37.7999584196931, -122.439336666363) 13 9 1 57 17
19964 226539 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1220 Potrero Ave 1 : Tree Private 2     23 Width 4ft   6010527.00308 2102195.727 37.7528226993215 -122.406479047766 (37.7528226993215, -122.406479047766) 10 4 7 28859 19
20354 190147 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1779 Oakdale Ave 1 : Tree Private 2     15 Width 3ft   6014086.91592 2096161.37872 37.7364521575355 -122.393745786146 (37.7364521575355, -122.393745786146) 10 3 8 58 1
27883 249337 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 851 Post St 3 : Tree Private 2     12 Width 3ft   6008084.28411 2114798.49621 37.787289988396 -122.415818769842 (37.787289988396, -122.415818769842) 13 1 9 28858 36
27958 189608 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Sherman St 21 : Tree Private 2     27 Width 10ft   6010698.53691 2111009.64615 37.7770333175687 -122.406506877295 (37.7770333175687, -122.406506877295) 14 2 9 28853 34
31179 189599 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 420 Bryant St 1 : Tree Private 2     16 Width 3ft   6014295.66507 2113017.59337 37.7827472672103 -122.394203810878 (37.7827472672103, -122.394203810878) 6 2 9 28856 6
31629 189591 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 480 02nd St 3 : Tree Private 2     13 Width 3ft   6014351.962 2113206.27271 37.7832684666162 -122.394022258432 (37.7832684666162, -122.394022258432) 6 2 9 28856 6
33163 189782 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1631 20th St 1 : Tree Private 2     12 Width 3ft   6013069.21854 2104711.38788 37.7598720495856 -122.397863989547 (37.7598720495856, -122.397863989547) 10 3 8 28856 29
33471 190128 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Industrial St 4 : Tree Private 2     8 Width 4ft   6011796.42353 2097334.30265 37.7395452093339 -122.401747451892 (37.7395452093339, -122.401747451892) 10 3 8 58 1
34146 249437 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 900 Ellis St 2 : Tree Private 2     16 Width 6ft   6006423.6127 2113573.86871 37.7838339639157 -122.421477346411 (37.7838339639157, -122.421477346411) 7 9 11 28858 41
36566 249330 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 840 Post St 1 : Tree Private 2     13 Width 4ft   6008126.92427 2114851.24734 37.7874372271876 -122.415674979915 (37.7874372271876, -122.415674979915) 13 1 10 28858 21
38367 190138 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 411 Barneveld Ave 6 : Tree Private 2     2 Width 2ft   6011253.6233 2097979.03397 37.7412851978498 -122.403669581886 (37.7412851978498, -122.403669581886) 10 3 8 58 1
40512 189605 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 215 Clara St 3 : Tree Private 2     2 Width 3ft   6011774.59908 2111718.41989 37.7790395872403 -122.402834282601 (37.7790395872403, -122.402834282601) 14 2 9 28856 34
41394 189788 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 677 Connecticut St 1 : Tree Private 2     14 Width 3ft   6013320.33604 2103932.96244 37.7577486450122 -122.396940912811 (37.7577486450122, -122.396940912811) 10 3 8 28856 29
42625 189607 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 06th St 2 : Tree Private 2     25 Width 3ft   6011287.74653 2111158.98765 37.777476320014 -122.404479121929 (37.777476320014, -122.404479121929) 14 2 9 28853 34
43731 189778 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 800 Wisconsin St 10 : Tree Private 2     32 Width 5ft   6012724.71744 2103552.97155 37.7566721007586 -122.39897415133 (37.7566721007586, -122.39897415133) 10 3 8 28856 29
46938 249336 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 851 Post St 2 : Tree Private 2     11 Width 3ft   6008067.24057 2114796.28027 37.7872829458064 -122.415877580082 (37.7872829458064, -122.415877580082) 13 1 9 28858 36
47464 189054 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1498 Fairfax Ave 11 : Tree Private 2     17 Width 4ft   6016089.14176 2097873.99534 37.7412657158495 -122.386942589337 (37.7412657158495, -122.386942589337) 10 3 8 58 1
47647 190129 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Industrial St 5 : Tree Private 2     4 Width 4ft   6011744.4272 2097318.12593 37.739497889703 -122.401926096826 (37.739497889703, -122.401926096826) 10 3 8 58 1
47689 246459 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401 Duncan St 2 : Tree Private 2     11 Width 3ft   6003883.97814 2099806.25098 37.7458878813339 -122.429281474276 (37.7458878813339, -122.429281474276) 2 7 5 63 22
49224 189586 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 15 Stillman St 1 : Tree Private 2     20 Width 3ft   6014223.36299 2113181.97862 37.7831946124959 -122.394465461439 (37.7831946124959, -122.394465461439) 6 2 9 28856 6
49863 189781 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1651 20th St 3 : Tree Private 2     10 Width 3ft   6013048.21421 2104711.53321 37.7598712788584 -122.397936643959 (37.7598712788584, -122.397936643959) 10 3 8 28856 29
51042 246458 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401 Duncan St 1 : Tree Private 2     11 Width 3ft   6003866.26481 2099806.76686 37.7458882950042 -122.429342761286 (37.7458882950042, -122.429342761286) 2 7 5 63 22
51251 189590 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 15 Stillman St 5 : Tree Private 2     13 Width 3ft   6014290.16171 2113241.33755 37.7833613117285 -122.394238520192 (37.7833613117285, -122.394238520192) 6 2 9 28856 6
51310 249392 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 318 Turk St 1 : Tree Private 2     17 Width 3ft   6008424.06306 2113156.66711 37.7828010178889 -122.414526979149 (37.7828010178889, -122.414526979149) 7 10 9 28852 36
52139 189583 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 25 Stillman St 1 : Tree Private 2     19 Width 3ft   6014132.81504 2113093.12947 37.7829456189933 -122.394772498951 (37.7829456189933, -122.394772498951) 6 2 9 28856 6
61595 189637 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1457 11th St 2 : Tree Private 2     29 Width 3ft   6007464.35939 2110196.45279 37.7746190182897 -122.417637279952 (37.7746190182897, -122.417637279952) 8 2 9 28853 19
61597 189639 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 52 Kissling St 1 : Tree Private 2     25 Width 3ft   6008374.77621 2109634.15975 37.7731262821758 -122.414448161646 (37.7731262821758, -122.414448161646) 8 2 9 28853 34
65358 189604 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 215 Clara St 2 : Tree Private 2     9 Width 3ft   6011760.81782 2111704.36546 37.7790002275232 -122.402880969084 (37.7790002275232, -122.402880969084) 14 2 9 28856 34
68198 249440 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 900 Ellis St 5 : Tree Private 2     15 Width 6ft   6006344.64005 2113562.97552 37.7837996008221 -122.421749788816 (37.7837996008221, -122.421749788816) 7 9 11 28858 41
69171 249377 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 764 Geary St 1 : Tree Private 2     17 Width 4ft   6008079.22511 2114494.71861 37.7864556045784 -122.415814754355 (37.7864556045784, -122.415814754355) 13 1 9 28858 36
70876 189790 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 671 Connecticut St 1 : Tree Private 2     12 Width 3ft   6013319.6658 2103964.90842 37.7578363244071 -122.396945470566 (37.7578363244071, -122.396945470566) 10 3 8 28856 29
72290 190130 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Industrial St 6 : Tree Private 2     6 Width 4ft   6011690.7758 2097300.73442 37.7394471418669 -122.402110378693 (37.7394471418669, -122.402110378693) 10 3 8 58 1
73977 249378 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 764 Geary St 2 : Tree Private 2     16 Width 4ft   6008051.64406 2114491.85735 37.7864461976841 -122.41590997547 (37.7864461976841, -122.41590997547) 13 1 9 28858 36
76108 189056 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1298 Fairfax Ave 2 : Tree Private 2     17 Width 4ft   6017215.97894 2097042.62645 37.7390452735231 -122.382988499612 (37.7390452735231, -122.382988499612) 10 3 8 58 1
78138 189603 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 514 Bryant St 2 : Tree Private 2     14 Width 3ft   6013664.01939 2112409.94185 37.7810436661816 -122.396346449248 (37.7810436661816, -122.396346449248) 6 2 9 28856 34
79205 226529 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 69 Pearl St 2 : Tree Private 2     14 Width 3ft   6005643.87962 2108670.88729 37.7703275748736 -122.42382618854 (37.7703275748736, -122.42382618854) 8 2 5 28853 19
83419 190127 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2177 Jerrold Ave 4 : Tree Private 2     21 Width 4ft   6012375.88653 2099169.23989 37.7446158775204 -122.399872724272 (37.7446158775204, -122.399872724272) 10 3 8 58 1
84728 190140 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1401 Fairfax Ave 1 : Tree Private 2     19 Width 3ft   6016375.81622 2097583.85317 37.7404849136356 -122.385931141602 (37.7404849136356, -122.385931141602) 10 3 8 58 1
84914 189053 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1498 Fairfax Ave 10 : Tree Private 2     17 Width 4ft   6016104.71748 2097862.07599 37.7412338501722 -122.386887902452 (37.7412338501722, -122.386887902452) 10 3 8 58 1
85740 189636 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1457 11th St 1 : Tree Private 2     26 Width 3ft   6007413.8507 2110245.29241 37.7747502779465 -122.417815462623 (37.7747502779465, -122.417815462623) 8 2 9 28853 19
86829 246817 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 188 Brewster St 1 : Tree Private 2     7 Width 2ft   6010169.08234 2098827.13597 37.7435532583908 -122.407479337616 (37.7435532583908, -122.407479337616) 2 7 7 28859 2
88065 247219 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 898 Duboce Ave 3 : Tree Private 2     17 Width 3ft   6001696.73287 2108310.3892 37.7691141196542 -122.437453519276 (37.7691141196542, -122.437453519276) 15 5 5 29492 9
89546 189585 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 25 Stillman St 3 : Tree Private 2     18 Width 3ft   6014156.36179 2113112.63363 37.7830004821267 -122.394692402629 (37.7830004821267, -122.394692402629) 6 2 9 28856 6
92173 246959 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2173 15th St 1 : Tree Private 2     22 Width 4ft   6003061.26496 2107089.31896 37.7658388409276 -122.432646450467 (37.7658388409276, -122.432646450467) 15 5 5 28862 3
93542 190137 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 411 Barneveld Ave 1 : Tree Private 2     3 Width 2ft   6011221.00191 2097926.45403 37.7411390022656 -122.403778676853 (37.7411390022656, -122.403778676853) 10 3 8 58 1
94554 189777 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1027 Rhode Island St 1 : Tree Private 2     16 Width 7ft   6011952.80925 2103344.35283 37.7560562360087 -122.401629043553 (37.7560562360087, -122.401629043553) 10 3 8 28856 29
95934 92501 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 645 05th St 2 : Tree Private 2     24     6013077.25048 2110692.4491 37.7762951549369 -122.398255852047 (37.7762951549369, -122.398255852047) 6 2 9 28856 34
97361 189638 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1457 11th St 3 : Tree Private 2     29 Width 3ft   6007490.46455 2110170.79422 37.774550034893 -122.417545157896 (37.774550034893, -122.417545157896) 8 2 9 28853 19
97670 127063 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3252 Pierce St 3 : Tree Private 2     10 Width 3ft   6001387.77011 2119526.14518 37.7998921441711 -122.439326240526 (37.7998921441711, -122.439326240526) 13 9 1 57 17
100612 249413 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 640 Turk St 2 : Tree Private 2     14 Width 4ft   6006896.39396 2112943.46706 37.7821296802828 -122.419796949688 (37.7821296802828, -122.419796949688) 7 9 9 28852 36
101239 247217 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 898 Duboce Ave 1 : Tree Private 2     18 Width 3ft   6001734.68886 2108311.17777 37.769118442685 -122.437322288417 (37.769118442685, -122.437322288417) 15 5 5 29492 9
102211 190151 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 43 Bridgeview Dr 1 : Tree Private 2     9 Width 2ft   6013910.41512 2095496.08824 37.7346155971136 -122.394309462337 (37.7346155971136, -122.394309462337) 10 3 8 58 1
102542 246961 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2179 15th St 1 : Tree Private 2     15 Width 3ft   6003024.34646 2107086.69679 37.7658295473207 -122.43277395635 (37.7658295473207, -122.43277395635) 15 5 5 28862 3
102609 189587 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 15 Stillman St 2 : Tree Private 2     13 Width 3ft   6014237.43529 2113190.91564 37.7832199337918 -122.394417402538 (37.7832199337918, -122.394417402538) 6 2 9 28856 6
103827 249375 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 746 Geary St 2 : Tree Private 2     16 Width 3ft   6008127.05575 2114504.28031 37.7864845474758 -122.41564994908 (37.7864845474758, -122.41564994908) 13 1 9 28858 36
107690 189785 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 500 Texas St 3 : Tree Private 2     10 Width 3ft   6013782.84096 2104671.65945 37.7598026803771 -122.395393116622 (37.7598026803771, -122.395393116622) 10 3 8 28856 29
108906 127070 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3252 Pierce St 10 : Tree Private 2     12 Width 3ft   6001375.8548 2119619.21037 37.8001469985396 -122.439374146505 (37.8001469985396, -122.439374146505) 13 9 1 57 17
110097 190146 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1298 Fairfax Ave 3 : Tree Private 2     18 Width 4ft   6017196.21156 2097055.62091 37.7390798614415 -122.383057751016 (37.7390798614415, -122.383057751016) 10 3 8 58 1
110483 189794 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 334 Mississippi St 1 : Tree Private 2     16 Width 4ft   6014017.77828 2105474.13273 37.7620191611724 -122.394636773263 (37.7620191611724, -122.394636773263) 10 3 8 28856 29
112612 189786 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 600 Arkansas St 1 : Tree Private 2     13 Width 3ft   6012965.34427 2104244.75446 37.7585849911234 -122.398190503706 (37.7585849911234, -122.398190503706) 10 3 8 28856 29
114748 226501 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Pearl St 1 : Tree Private 2     16 Width 4ft   6005629.70573 2108993.07475 37.7712114241035 -122.423898129812 (37.7712114241035, -122.423898129812) 8 2 5 28853 19
116118 246956 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2157 15th St 1 : Tree Private 2     9 Width 3ft   6003133.80616 2107095.11064 37.7658588571132 -122.432395959599 (37.7658588571132, -122.432395959599) 15 5 5 28862 3
119060 249530 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 236 Myrtle St 1 : Tree Private 2     6 Width 3ft   6006266.61639 2114058.09654 37.7851546812964 -122.422054907229 (37.7851546812964, -122.422054907229) 13 9 11 28858 41
122603 126640 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 619 Hayes St 1 : Tree Private 2     10 Width 3ft   6004870.87553 2110876.49293 37.776339963658 -122.426657096074 (37.776339963658, -122.426657096074) 7 9 11 28852 10
122770 189779 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1651 20th St 1 : Tree Private 2     10 Width 3ft   6013017.59805 2104710.46941 37.7598666527441 -122.398042456397 (37.7598666527441, -122.398042456397) 10 3 8 28856 29
122772 246957 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2157 15th St 2 : Tree Private 2     11 Width 3ft   6003142.68624 2107094.66687 37.7658581421603 -122.432365213587 (37.7658581421603, -122.432365213587) 15 5 5 28862 3
123292 190126 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2177 Jerrold Ave 2 : Tree Private 2     18 Width 4ft   6012310.55549 2099218.77103 37.7447482370351 -122.400102105343 (37.7447482370351, -122.400102105343) 10 3 8 58 1
124202 189600 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 420 Bryant St 2 : Tree Private 2     15 Width 3ft   6014290.12506 2113010.78907 37.7827282762222 -122.394222500581 (37.7827282762222, -122.394222500581) 6 2 9 28856 6
125861 249531 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 246 Myrtle St 1 : Tree Private 2     7 Width 3ft   6006201.54989 2114050.08669 37.7851290182315 -122.422279448136 (37.7851290182315, -122.422279448136) 13 9 11 28858 41
127910 246982 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 38 Clipper St 1 : Tree Private 2     18 Width 8ft   6004902.47134 2101076.48908 37.7494332696347 -122.425850064247 (37.7494332696347, -122.425850064247) 2 4 5 28862 22
129705 226530 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 498 Oak St 1 : Tree DPW 1     16 Width 4ft   6004664.90455 2110206.95803 37.7744899376984 -122.427321901889 (37.7744899376984, -122.427321901889) 7 9 11 28852 10
131253 190144 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1270 Fairfax Ave 2 : Tree Private 2     13 Width 3ft   6017331.65483 2096956.72169 37.7388157872258 -122.382582565458 (37.7388157872258, -122.382582565458) 10 3 8 58 1
135041 249334 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 875 Post St 1 : Tree Private 2     10 Width 3ft   6007974.74657 2114781.52678 37.7872372359533 -122.416196545342 (37.7872372359533, -122.416196545342) 13 1 9 28858 36
138492 189780 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1651 20th St 2 : Tree Private 2     10 Width 3ft   6013032.11681 2104710.31542 37.7598670385488 -122.397992231954 (37.7598670385488, -122.397992231954) 10 3 8 28856 29
139284 189602 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 514 Bryant St 1 : Tree Private 2     15 Width 3ft   6013672.98606 2112416.44632 37.7810620249253 -122.396315884881 (37.7810620249253, -122.396315884881) 6 2 9 28856 34
141576 249332 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 840 Post St 3 : Tree Private 2     16 Width 4ft   6008070.22885 2114841.12367 37.7874062428634 -122.415870417888 (37.7874062428634, -122.415870417888) 13 1 10 28858 21

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);