trees

5,599 rows where qSpecies_id = 38 sorted by qAddress

✎ 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)
40175 190200 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6014315.19536 2116534.70436 37.7924055282487 -122.394382582609 (37.7924055282487, -122.394382582609) 12 2 9 28855 6
110720 190202 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6014298.64009 2116519.30136 37.7923623149076 -122.394438785721 (37.7923623149076, -122.394438785721) 12 2 9 28855 6
122704 190198 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6014331.7928 2116550.66298 37.7924502695099 -122.394326272441 (37.7924502695099, -122.394326272441) 12 2 9 28855 6
149262 190203 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Mission St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6014289.71306 2116512.05011 37.7923419084079 -122.394469165733 (37.7923419084079, -122.394469165733) 12 2 9 28855 6
151670 190201 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6014306.70716 2116527.44421 37.7923851217206 -122.394411443656 (37.7923851217206, -122.394411443656) 12 2 9 28855 6
21674 112696 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6010197.93258 2122016.89458 37.8072285445333 -122.409015474098 (37.8072285445333, -122.409015474098) 3 1 10 308 23
23136 112697 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6010180.49666 2122013.17318 37.807217349764 -122.409075552403 (37.807217349764, -122.409075552403) 3 1 10 308 23
26930 112710 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 14 Sidewalk: Curb side : Cutout Tree Private 2     19 3x3   6009944.98971 2121981.12086 37.8071161463469 -122.40988831469 (37.8071161463469, -122.40988831469) 3 1 10 308 23
29276 112698 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6010162.10827 2122010.9389 37.8072101848662 -122.409139031937 (37.8072101848662, -122.409139031937) 3 1 10 308 23
34309 112705 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 10 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6010037.29215 2121993.91508 37.8071564485694 -122.409569784717 (37.8071564485694, -122.409569784717) 3 1 10 308 23
58244 112706 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 11 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6010019.71915 2121991.50115 37.8071488358223 -122.409630429619 (37.8071488358223, -122.409630429619) 3 1 10 308 23
75713 112707 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 12 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6010000.18827 2121989.4534 37.8071421187683 -122.409697876062 (37.8071421187683, -122.409697876062) 3 1 10 308 23
87207 112699 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6010148.47409 2122008.93385 37.8072039156867 -122.4091860746 (37.8072039156867, -122.4091860746) 3 1 10 308 23
129382 112709 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 13 Sidewalk: Curb side : Cutout Tree Private 2     19 3x3   6009982.61169 2121986.87678 37.8071340590486 -122.409758521838 (37.8071340590486, -122.409758521838) 3 1 10 308 23
154858 112704 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 9 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6010051.40091 2121995.09516 37.8071604793321 -122.409521041462 (37.8071604793321, -122.409521041462) 3 1 10 308 23
159869 112701 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 6 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6010119.58871 2122005.93511 37.8071940636195 -122.409285827389 (37.8071940636195, -122.409285827389) 3 1 10 308 23
163517 112700 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 5 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6010133.84115 2122006.13363 37.8071954071956 -122.409236517546 (37.8071954071956, -122.409236517546) 3 1 10 308 23
183483 112703 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 8 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6010065.02511 2121996.61103 37.8071654049198 -122.409473998846 (37.8071654049198, -122.409473998846) 3 1 10 308 23
190366 112702 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 North Point St 7 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6010077.3299 2121997.6645 37.8071689869277 -122.409431489691 (37.8071689869277, -122.409431489691) 3 1 10 308 23
144462 225319 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Oak St 5 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6006215.02853 2110426.44989 37.7751801547778 -122.421975311837 (37.7751801547778, -122.421975311837) 7 9 11 28852 10
72144 225592 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002850.63273 2108947.74072 37.7709296647016 -122.433507804049 (37.7709296647016, -122.433507804049) 15 5 11 29492 9
161918 18305 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6010224.24414 2107746.60355 37.7680472125438 -122.407917452249 (37.7680472125438, -122.407917452249) 8 4 8 28853 19
7342 26844 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3 Permit Number 775213 6006969.72882 2110998.7322 37.7767940394414 -122.419405236481 (37.7767940394414, -122.419405236481) 7 9 9 28852 36
61265 26845 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Van Ness Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3 Permit Number 775213 6006964.16578 2111032.60038 37.7768867199943 -122.419426884038 (37.7768867199943, -122.419426884038) 7 9 9 28852 36
73121 26842 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3 Permit Number 775213 6006970.058 2110963.93279 37.7766985071661 -122.419401628405 (37.7766985071661, -122.419401628405) 7 9 9 28852 36
164272 26843 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3 Permit Number 775213 6006968.35618 2110982.6622 37.7767498377733 -122.419408844544 (37.7767498377733, -122.419408844544) 7 9 9 28852 36
26432 128672 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Washington St 8 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6013392.30755 2117975.00239 37.796308901584 -122.397676888287 (37.796308901584, -122.397676888287) 3 1 10 28860 6
40490 128676 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Washington St 12 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6013311.40182 2117965.30288 37.7962777634623 -122.397956160144 (37.7962777634623, -122.397956160144) 3 1 10 28860 6
44415 128675 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Washington St 11 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6013334.73327 2117968.4564 37.7962877216558 -122.39787564926 (37.7962877216558, -122.39787564926) 3 1 10 28860 6
44727 128670 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Washington St 6 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6013432.92529 2117981.57564 37.7963292118859 -122.397536802701 (37.7963292118859, -122.397536802701) 3 1 10 28860 6
53536 128677 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Washington St 13 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6013274.45075 2117959.00066 37.7962584010691 -122.39808357702 (37.7962584010691, -122.39808357702) 3 1 10 28860 6
93969 128666 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6013510.67014 2117994.10265 37.7963679366843 -122.39726866624 (37.7963679366843, -122.39726866624) 3 1 10 28860 6
104924 128668 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6013471.72934 2117989.45228 37.796352999841 -122.397403084284 (37.796352999841, -122.397403084284) 3 1 10 28860 6
115498 128674 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Washington St 10 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6013352.81872 2117972.32063 37.7962993390922 -122.397813340609 (37.7962993390922, -122.397813340609) 3 1 10 28860 6
120018 128669 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6013452.64097 2117986.0115 37.7963424894733 -122.397468893095 (37.7963424894733, -122.397468893095) 3 1 10 28860 6
120128 128667 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6013490.78503 2117991.28229 37.7963590855596 -122.39733727552 (37.7963590855596, -122.39733727552) 3 1 10 28860 6
127935 128665 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6013533.79535 2117997.05909 37.7963773417917 -122.397188854979 (37.7963773417917, -122.397188854979) 3 1 10 28860 6
172593 128671 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Washington St 7 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6013413.2137 2117977.34147 37.7963164882801 -122.397604712284 (37.7963164882801, -122.397604712284) 3 1 10 28860 6
178662 128673 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Washington St 9 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6013372.48948 2117974.54062 37.7963065300838 -122.397745431009 (37.7963065300838, -122.397745431009) 3 1 10 28860 6
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
22072 128239 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Battery St 4 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6012346.02917 2119632.64296 37.8008020665329 -122.401413805224 (37.8008020665329, -122.401413805224) 3 1 10 28860 6
117839 128236 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Battery St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6012355.01891 2119573.79712 37.8006409916432 -122.401378558984 (37.8006409916432, -122.401378558984) 3 1 10 28860 6
119733 128237 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Battery St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6012352.64847 2119592.62299 37.8006925506804 -122.401388085489 (37.8006925506804, -122.401388085489) 3 1 10 28860 6
122919 128238 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Battery St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6012349.16368 2119610.78631 37.8007422283398 -122.401401421557 (37.8007422283398, -122.401401421557) 3 1 10 28860 6
27685 66675 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/1991 12:00:00 AM 10 3x3 Permit Number 29899 6010436.29506 2108454.16337 37.7700018791163 -122.407233871257 (37.7700018791163, -122.407233871257) 8 2 9 28853 34
156600 103346 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Brannan St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3 Permit Number 29899 6010363.29379 2108386.27696 37.7698113928049 -122.40748159581 (37.7698113928049, -122.40748159581) 8 2 9 28853 34
47449 7869 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Franklin St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X2   6006093.62914 2113643.3001 37.7840059943141 -122.422623903791 (37.7840059943141, -122.422623903791) 7 9 11 28858 41
49281 7866 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Franklin St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X2   6006104.07556 2113580.8996 37.7838352472299 -122.422583327268 (37.7838352472299, -122.422583327268) 7 9 11 28858 41
86060 7865 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Franklin St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X2   6006105.0189 2113565.09712 37.7837919107224 -122.422578940363 (37.7837919107224, -122.422578940363) 7 9 11 28858 41
113723 7867 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Franklin St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X2   6006097.1257 2113612.92468 37.7839227881431 -122.42260964772 (37.7839227881431, -122.42260964772) 7 9 11 28858 41
151065 7868 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Franklin St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X2   6006094.88273 2113627.1755 37.7839617908505 -122.422618420601 (37.7839617908505, -122.422618420601) 7 9 11 28858 41
156498 7864 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Franklin St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X2   6006105.6971 2113551.82535 37.7837555079643 -122.42257565064 (37.7837555079643, -122.42257565064) 7 9 11 28858 41
171269 127700 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Jones St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008666.84419 2116036.99582 37.7907233400461 -122.413890871591 (37.7907233400461, -122.413890871591) 5 1 10 28857 21
75602 127956 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6012064.85758 2119176.00834 37.79953256642 -122.402354657058 (37.79953256642, -122.402354657058) 3 1 10 28860 6
142818 127958 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Sansome St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6012058.65906 2119212.94594 37.799633642131 -122.402378704906 (37.799633642131, -122.402378704906) 3 1 10 28860 6
165000 127959 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Sansome St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6012056.09498 2119232.28738 37.7996866059181 -122.402388938317 (37.7996866059181, -122.402388938317) 3 1 10 28860 6
187937 127957 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Sansome St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6012062.32761 2119189.75387 37.7995701670969 -122.402364378726 (37.7995701670969, -122.402364378726) 3 1 10 28860 6
15883 127489 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Sutter St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2019 12:00:00 AM 3 Width 4ft   6007666.04374 2115128.71351 37.7881731631139 -122.41728920634 (37.7881731631139, -122.41728920634) 13 1 10 28858 21
42478 127488 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6007674.70811 2115131.74841 37.7881819836647 -122.417259444165 (37.7881819836647, -122.417259444165) 13 1 10 28858 21
46137 63976 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1987 12:00:00 AM 18   Permit Number 24713 6008118.77344 2119296.69749 37.7996428790721 -122.416018115343 (37.7996428790721, -122.416018115343) 5 1 1 308 32
157013 10572 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000X Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6011306.3762 2111038.8058 37.7771473695905 -122.404406213897 (37.7771473695905, -122.404406213897) 14 2 9 28853 34
13688 189611 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1001x Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 8ft   6011323 2110932 37.776855034552 -122.404341187165 (37.776855034552, -122.404341187165) 14 2 9 28853 34
35056 218936 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1003 Ortega St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5990723.76369 2102432.25259 37.7523443750999 -122.474978856684 (37.7523443750999, -122.474978856684) 1 8 4 29491 12
55928 218937 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1003 Ortega St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5990714.31106 2102432.45211 37.7523443751123 -122.475011559633 (37.7523443751123, -122.475011559633) 1 8 4 29491 12
79708 218935 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1003 Ortega St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5990744.94543 2102432.18219 37.7523454093323 -122.474905602418 (37.7523454093323, -122.474905602418) 1 8 4 29491 12
130872 218934 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1003 Ortega St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5990760.83366 2102432.22352 37.7523464435445 -122.47485066193 (37.7523464435445, -122.47485066193) 1 8 4 29491 12
137483 218939 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1003 Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5990690.45077 2102431.07242 37.7523392040079 -122.475093970812 (37.7523392040079, -122.475093970812) 1 8 4 29491 12
173583 218933 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1003 Ortega St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5990778.98274 2102431.84048 37.7523464435342 -122.474787872164 (37.7523464435342, -122.474787872164) 1 8 4 29491 12
178346 218938 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1003 Ortega St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5990704.08635 2102431.91459 37.7523423066512 -122.475046878734 (37.7523423066512, -122.475046878734) 1 8 4 29491 12
21888 127758 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1005 Jones St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008623.20133 2116011.5553 37.7906510354728 -122.4140400736 (37.7906510354728, -122.4140400736) 5 1 10 28858 21
27230 61903 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1005 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1985 12:00:00 AM 13   Permit Number 21947 6008617.2267 2116046.34412 37.7907462215147 -122.414063207745 (37.7907462215147, -122.414063207745) 5 1 10 28858 21
82082 127759 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1005 Jones St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008626.18102 2115991.84376 37.7905970797476 -122.41402836894 (37.7905970797476, -122.41402836894) 5 1 10 28858 21
120910 127757 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1005 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6008619.34985 2116025.54828 37.7906892404615 -122.414054389904 (37.7906892404615, -122.414054389904) 5 1 10 28858 21
29858 127816 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1009 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6008187.06074 2118913.96163 37.7985958209075 -122.415754700319 (37.7985958209075, -122.415754700319) 5 1 10 28858 21
56337 15173 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1009 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/29/1997 12:00:00 AM 6 3X3   6009997.61179 2112323.54052 37.780601724933 -122.409024335124 (37.780601724933, -122.409024335124) 14 2 9 28853 34
161577 23045 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1009 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/1994 12:00:00 AM 20 3X3   6006363.7277 2103674.62704 37.756649629388 -122.420981438653 (37.756649629388, -122.420981438653) 2 4 7 28859 19
157252 123905 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   5992698.89323 2114764.97557 37.78632100959 -122.469046057882 (37.78632100959, -122.469046057882) 11 6 2 54 11
53969 122058 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5990191.66474 2114668.45777 37.7859108144747 -122.477713273252 (37.7859108144747, -122.477713273252) 11 6 2 55 26
110939 122057 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 18th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   5990191.69083 2114652.84953 37.7858679601396 -122.477712041657 (37.7858679601396, -122.477712041657) 11 6 2 55 26
126900 56410 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/1973 12:00:00 AM 18   Permit Number 12570 5990190.56265 2114683.73374 37.7859526940453 -122.477718203176 (37.7859526940453, -122.477718203176) 11 6 2 55 26
80035 31505 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2014 12:00:00 AM 13 3x3 Permit Number 54070 6005154.62899 2099588.74591 37.7453625153619 -122.424872264669 (37.7453625153619, -122.424872264669) 2 7 5 63 22
65146 5328 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 6x6   6004844.5773 2107740.43574 37.7677276240574 -122.426524712264 (37.7677276240574, -122.426524712264) 8 4 5 28862 19
55124 190339 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Howard St 5 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6014796.07981 2116028.26498 37.7910416829656 -122.392683252424 (37.7910416829656, -122.392683252424) 6 2 9 28855 6
75241 190342 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Howard St 8 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6014826.26604 2116061.6193 37.7911349426626 -122.392581142522 (37.7911349426626, -122.392581142522) 6 2 9 28855 6
78545 190338 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Howard St 4 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6014779.60174 2116014.8679 37.7910039825033 -122.39273932877 (37.7910039825033, -122.39273932877) 6 2 9 28855 6
102241 190343 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Howard St 9 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6014833.65153 2116067.97369 37.7911528005014 -122.392556033445 (37.7911528005014, -122.392556033445) 6 2 9 28855 6
115515 190336 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Howard St 2 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6014755.21053 2115992.9592 37.7909424715624 -122.392822188693 (37.7909424715624, -122.392822188693) 6 2 9 28855 6
122533 190340 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Howard St 6 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6014805.5019 2116039.63688 37.7910734308558 -122.392651447929 (37.7910734308558, -122.392651447929) 6 2 9 28855 6
146689 190337 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Howard St 3 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6014767.49042 2116002.10502 37.7909682659168 -122.392780340547 (37.7909682659168, -122.392780340547) 6 2 9 28855 6
162040 190335 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Howard St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6014743.61218 2115981.63102 37.790910722793 -122.392861525945 (37.790910722793, -122.392861525945) 6 2 9 28855 6
191626 190341 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Howard St 7 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6014814.94374 2116051.97196 37.7911078245033 -122.392619642478 (37.7911078245033, -122.392619642478) 6 2 9 28855 6
15939 128288 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Lombard St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6011508.83416 2120753.62103 37.8038332521574 -122.404389812943 (37.8038332521574, -122.404389812943) 3 1 10 28860 6
65681 59206 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/17/1980 12:00:00 AM 11   Permit Number 18526 6011447.01867 2120744.84852 37.8038057104345 -122.404603112344 (37.8038057104345, -122.404603112344) 3 1 10 28860 6
71862 128296 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Lombard St 11 Sidewalk: Property side : Yard Tree Private 2     16 Width 6ft   6011760.21977 2120791.0173 37.8039499778675 -122.403522505873 (37.8039499778675, -122.403522505873) 3 1 10 28860 6
73215 128294 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Lombard St 9 Sidewalk: Property side : Yard Tree Private 2     11 Width 5ft   6011739.96085 2120785.45853 37.8039335832322 -122.403592222228 (37.8039335832322, -122.403592222228) 3 1 10 28860 6
81663 128292 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Lombard St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6011685.15599 2120779.40875 37.8039139105473 -122.403781453055 (37.8039139105473, -122.403781453055) 3 1 10 28860 6
91811 128295 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Lombard St 10 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6011737.98777 2120794.57425 37.8039585025572 -122.403599691991 (37.8039585025572, -122.403599691991) 3 1 10 28860 6
134424 128289 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Lombard St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6011528.34981 2120758.00025 37.8038463669751 -122.404322585929 (37.8038463669751, -122.404322585929) 3 1 10 28860 6
136389 128291 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Lombard St 6 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6011656.52084 2120774.7371 37.8038994836227 -122.403880218409 (37.8038994836227, -122.403880218409) 3 1 10 28860 6
137282 128287 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6011473.93691 2120747.64407 37.8038148907035 -122.404510156613 (37.8038148907035, -122.404510156613) 3 1 10 28860 6

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