5,599 rows where qSpecies_id = 38 sorted by Longitude

View and edit SQL

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)
10998 100001 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 501X 01st St 2 Sidewalk: Curb side : Pot Tree Private 2         Address is 100 1st Street                    
120247 6749 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1215 Fairfax Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     21 3x3   6017498.17872 2096747.56806 37.7382506910122 -122.381992253155 (37.7382506910122, -122.381992253155) 10 3 8 58 1
172279 6750 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1215 Fairfax Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     21 3x3   6017497.29462 2096749.09377 37.7382548314821 -122.381995416066 (37.7382548314821, -122.381995416066) 10 3 8 58 1
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
159882 189055 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1270 Fairfax Ave 4 : Tree Private 2     16 Width 4ft   6017298.65982 2096980.57474 37.7388794601286 -122.382698307296 (37.7388794601286, -122.382698307296) 10 3 8 58 1
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
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
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
186451 189678 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 24th St 19 : Yard Tree Private 2     15     6017295.34569 2102596.83049 37.7543003681831 -122.383100556043 (37.7543003681831, -122.383100556043) 10 3 8 28856 29
86101 189677 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 24th St 14 : Yard Tree Private 2     9     6017255.58244 2102660.6719 37.7544734661028 -122.383242512238 (37.7544734661028, -122.383242512238) 10 3 8 28856 29
117845 189679 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 24th St 20 : Yard Tree Private 2     12     6017238.94696 2102621.26617 37.7543643468473 -122.383297299846 (37.7543643468473, -122.383297299846) 10 3 8 28856 29
129212 189680 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 24th St 21 : Yard Tree Private 2     9     6017213.38014 2102597.10976 37.7542966054277 -122.383384035867 (37.7542966054277, -122.383384035867) 10 3 8 28856 29
186362 189676 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 24th St 11 : Yard Tree Private 2     11     6017209.44087 2102637.39107 37.7544069918113 -122.383400462871 (37.7544069918113, -122.383400462871) 10 3 8 28856 29
25086 189675 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 24th St 10 : Yard Tree Private 2     8     6017194.50129 2102669.93128 37.7544955147815 -122.383454393407 (37.7544955147815, -122.383454393407) 10 3 8 28856 29
152201 6792 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1375 Fairfax Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6016736.55231 2097315.71329 37.739768612644 -122.384665171383 (37.739768612644, -122.384665171383) 10 3 8 58 1
186232 190142 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1385 Fairfax Ave 2 : Tree Private 2     19 Width 4ft   6016719.34934 2097329.5303 37.7398055999553 -122.384725614793 (37.7398055999553, -122.384725614793) 10 3 8 58 1
51265 6804 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1381 Fairfax Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     18 3x9   6016716.56136 2097329.28644 37.7398047761739 -122.384735237561 (37.7398047761739, -122.384735237561) 10 3 8 58 1
23471 6803 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1381 Fairfax Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6016702.46097 2097342.51463 37.7398403182643 -122.384784912507 (37.7398403182643, -122.384784912507) 10 3 8 58 1
85307 6802 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1381 Fairfax Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     20 3x3   6016686.26757 2097353.7409 37.7398702477042 -122.384841684893 (37.7398702477042, -122.384841684893) 10 3 8 58 1
188139 190141 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1385 Fairfax Ave 1 : Tree Private 2     22 Width 4ft   6016685.94194 2097355.07165 37.7398738836642 -122.384842903479 (37.7398738836642, -122.384842903479) 10 3 8 58 1
172534 189057 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1398 Fairfax Ave 1 : Tree Private 2     16 Width 4ft   6016659.73338 2097454.68952 37.7401459645668 -122.384940461042 (37.7401459645668, -122.384940461042) 10 3 8 58 1
117768 6814 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1400X Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016451.12132 2097615.70854 37.7405765491786 -122.385672983138 (37.7405765491786, -122.385672983138) 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
61635 6819 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1400X Fairfax Ave 11 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016343.96785 2097693.33127 37.7407837556653 -122.386048891651 (37.7407837556653, -122.386048891651) 10 3 8 58 1
164160 189050 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1498 Fairfax Ave 7 : Tree Private 2     18 Width 4ft   6016154.01606 2097829.997 37.7411484972995 -122.386715207445 (37.7411484972995, -122.386715207445) 10 3 8 58 1
165295 189051 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1498 Fairfax Ave 8 : Tree Private 2     16 Width 4ft   6016137.18374 2097841.52701 37.7411792244368 -122.386774211962 (37.7411792244368, -122.386774211962) 10 3 8 58 1
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
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
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
66010 192167 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 818 Mendell St 2 Sidewalk: Curb side : Cutout Tree Private 2     29 Width 3ft   6016012.76751 2096784.5302 37.7382700372322 -122.387130695121 (37.7382700372322, -122.387130695121) 10 3 8 58 1
94630 15028 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 900 Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     5 3X3   6015848.12217 2096570.14906 37.737672271366 -122.387685009354 (37.737672271366, -122.387685009354) 10 3 8 58 1
588 59987 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1546 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/11/1982 12:00:00 AM 20   Permit Number 19471 6015827.92235 2097026.68646 37.7389247113108 -122.387786695709 (37.7389247113108, -122.387786695709) 10 3 8 58 1
37210 15030 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 900 Mendell St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6015814.84309 2096523.32446 37.7375418570556 -122.387796805884 (37.7375418570556, -122.387796805884) 10 3 8 58 1
172419 15031 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 900 Mendell St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6015804.02925 2096508.49114 37.7375005287238 -122.38783316007 (37.7375005287238, -122.38783316007) 10 3 8 58 1
49062 15032 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 900 Mendell St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6015793.96455 2096498.22382 37.7374717791904 -122.387867242574 (37.7374717791904, -122.387867242574) 10 3 8 58 1
172385 189665 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2585 03rd St 3 Sidewalk: Curb side : Cutout Tree DPW 1     19 Width 5ft   6015925.0907 2103156.83008 37.755762196379 -122.387878359099 (37.755762196379, -122.387878359099) 10 3 8 28856 29
177104 189664 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2585 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1     20 Width 5ft   6015924.43943 2103136.85911 37.7557073242394 -122.387879217958 (37.7557073242394, -122.387879217958) 10 3 8 28856 29
46082 189666 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2585 03rd St 4 Sidewalk: Curb side : Cutout Tree DPW 1     20 Width 5ft   6015923.45326 2103178.08659 37.7558204715491 -122.387885505106 (37.7558204715491, -122.387885505106) 10 3 8 28856 29
130208 21985 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2585 03rd St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x9   6015923.77814 2103194.18916 37.7558647037982 -122.387885505106 (37.7558647037982, -122.387885505106) 10 3 8 28856 29
98697 189667 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2585 03rd St 6 Sidewalk: Curb side : Cutout Tree DPW 1     17 Width 5ft   6015923.77839 2103213.67674 37.7559182125844 -122.387886863982 (37.7559182125844, -122.387886863982) 10 3 8 28856 29
49920 189668 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2585 03rd St 7 Sidewalk: Curb side : Cutout Tree DPW 1     19 Width 5ft   6015920.29776 2103253.32542 37.7560268866495 -122.387901667748 (37.7560268866495, -122.387901667748) 10 3 8 28856 29
78201 21988 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2585 03rd St 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x6   6015920.52958 2103275.9123 37.7560889182846 -122.387902442039 (37.7560889182846, -122.387902442039) 10 3 8 28856 29
79406 21989 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2585 03rd St 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x6   6015918.99863 2103291.42641 37.7561314319344 -122.387908819134 (37.7561314319344, -122.387908819134) 10 3 8 28856 29
179601 21990 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2585 03rd St 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x9   6015917.77015 2103307.70313 37.7561760563058 -122.387914203395 (37.7561760563058, -122.387914203395) 10 3 8 28856 29
179847 21993 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2585 03rd St 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x6   6015910.4355 2103353.33326 37.7563009406466 -122.387942753271 (37.7563009406466, -122.387942753271) 10 3 8 28856 29
115406 189661 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2585 03rd St 16 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6015908.09217 2103411.17152 37.7564596224378 -122.387954893205 (37.7564596224378, -122.387954893205) 10 3 8 28856 29
11696 189660 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2573 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 Width 4ft   6015900.45488 2103484.96239 37.7566618134199 -122.387986454936 (37.7566618134199, -122.387986454936) 10 3 8 28856 29
123483 189659 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2573 03rd St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 Width 4ft   6015895.51865 2103530.26934 37.7567859432258 -122.388006687875 (37.7567859432258, -122.388006687875) 10 3 8 28856 29
15334 59986 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1552 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/11/1982 12:00:00 AM 19 3x3 Permit Number 19470 6015757.2015 2097078.53248 37.7390631520541 -122.388034834851 (37.7390631520541, -122.388034834851) 10 3 8 58 1
169856 59984 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1562 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/11/1982 12:00:00 AM 20   Permit Number 19468 6015739.3496 2097091.61317 37.7390980799033 -122.388097471719 (37.7390980799033, -122.388097471719) 10 3 8 58 1
3467 189657 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2505 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 5ft   6015867.18038 2103823.80533 37.7575903607135 -122.388125177147 (37.7575903607135, -122.388125177147) 10 3 8 28856 29
105489 189658 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2505 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6015864.60954 2103849.31595 37.7576602650169 -122.388135848506 (37.7576602650169, -122.388135848506) 10 3 8 28856 29
58078 190349 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 446 Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6016076.82056 2114790.30571 37.7877135762729 -122.388165464973 (37.7877135762729, -122.388165464973) 6 2 9 28855 6
10227 189669 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2475 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     17 Width 5ft   6015848.0451 2104085.46802 37.7583077705949 -122.388209616279 (37.7583077705949, -122.388209616279) 10 3 8 28856 29
147386 189670 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2455 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6015847.32517 2104116.64553 37.7583933375103 -122.388214281986 (37.7583933375103, -122.388214281986) 10 3 8 28856 29
125173 189671 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2445 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6015841.1097 2104206.72552 37.7586403335901 -122.388242064727 (37.7586403335901, -122.388242064727) 10 3 8 28856 29
12239 189672 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2427 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6015841.43821 2104253.31303 37.7587682711682 -122.388244179947 (37.7587682711682, -122.388244179947) 10 3 8 28856 29
76317 190348 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 446 Spear St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6016052.98958 2114824.98528 37.7878074780845 -122.388250337589 (37.7878074780845, -122.388250337589) 6 2 9 28855 6
54846 189673 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2353 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6015829.00973 2104455.77471 37.7593234991101 -122.388301294093 (37.7593234991101, -122.388301294093) 10 3 8 28856 29
111433 189674 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2347 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6015825.57929 2104513.09616 37.7594807014943 -122.388317159013 (37.7594807014943, -122.388317159013) 10 3 8 28856 29
97635 192168 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1516 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     29 Width 4ft   6015644.07634 2096462.96533 37.737366661933 -122.388383020883 (37.737366661933, -122.388383020883) 10 3 8 58 1
190174 60020 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1575 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1982 12:00:00 AM 15   Permit Number 19507 6015654.88864 2097084.06623 37.7390726776667 -122.388388975278 (37.7390726776667, -122.388388975278) 10 3 8 58 1
43009 54186 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1536 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM 20 3x3 Permit Number 9921 6015571.57326 2096517.43556 37.7375122082315 -122.388637501128 (37.7375122082315, -122.388637501128) 10 3 8 58 1
130535 105165 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1600X OAKDALE AVE 4 Sidewalk: Curb side : Cutout Tree Arts Commission 19     16 3x3   6015006 2095503 37.7346954145828 -122.390522107646 (37.7346954145828, -122.390522107646) 10 3 8 58 1
10414 41425 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1568 Indiana St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/17/2000 12:00:00 AM 14   Permit Number 42032 6015102.0577 2101304.61846 37.7506307870794 -122.390595272152 (37.7506307870794, -122.390595272152) 10 3 8 28856 1
120784 46261 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1325 Indiana St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2002 12:00:00 AM 13   Permit Number 44545 6015094.37152 2102457.09283 37.7537948115904 -122.390702379615 (37.7537948115904, -122.390702379615) 10 3 8 28856 29
29246 46262 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1325 Indiana St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2002 12:00:00 AM 11   Permit Number 44545 6015093.12445 2102475.079 37.7538441286075 -122.390707949124 (37.7538441286075, -122.390707949124) 10 3 8 28856 29
168456 189662 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1177 Indiana St 1 Sidewalk: Curb side : Pot Tree Private 2     13 Width 4ft   6015057.63998 2103157.3463 37.7557155206704 -122.390878342778 (37.7557155206704, -122.390878342778) 10 3 8 28856 29
193781 189663 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1177 Indiana St 2 Sidewalk: Curb side : Pot Tree Private 2     11 Width 4ft   6015055.47575 2103171.59722 37.7557545305733 -122.390886823368 (37.7557545305733, -122.390886823368) 10 3 8 28856 29
185295 100274 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015236.2818 2113554.41618 37.7842734985691 -122.390987179627 (37.7842734985691, -122.390987179627) 6 2 9 28856 6
73963 100254 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2X Federal St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 2x2   6015227.31131 2113576.31726 37.7843331361945 -122.391019745885 (37.7843331361945, -122.391019745885) 6 2 9 28856 6
27303 100273 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 8 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015216.1617 2113535.8467 37.7842213945326 -122.391055490318 (37.7842213945326, -122.391055490318) 6 2 9 28856 6
65975 100272 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015193.56957 2113513.16529 37.7841578628497 -122.391132065814 (37.7841578628497, -122.391132065814) 6 2 9 28856 6
170477 100256 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2X Federal St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 2x2   6015186.92454 2113537.35467 37.7842239126372 -122.391156746807 (37.7842239126372, -122.391156746807) 6 2 9 28856 6
75484 100271 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 1x1   6015178.9141 2113499.10422 37.7841184410568 -122.391181785729 (37.7841184410568, -122.391181785729) 6 2 9 28856 6
74523 100257 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2X Federal St 3 Sidewalk: Curb side : Cutout Tree Private 2     24 2x2   6015171.2792 2113522.46957 37.784182173302 -122.391209833759 (37.784182173302, -122.391209833759) 6 2 9 28856 6
160742 100270 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015164.42669 2113486.59389 37.7840832865491 -122.391231032594 (37.7840832865491, -122.391231032594) 6 2 9 28856 6
87818 190350 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 4 Federal St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 2ft   6015151.51293 2113506.51683 37.7841372737458 -122.391277103055 (37.7841372737458, -122.391277103055) 6 2 9 28856 6
2982 100269 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015149.19988 2113471.58342 37.7840412261692 -122.391282662663 (37.7840412261692, -122.391282662663) 6 2 9 28856 6
47017 100268 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015133.4862 2113455.2111 37.7839953994148 -122.391335881848 (37.7839953994148, -122.391335881848) 6 2 9 28856 6
47380 190288 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 200 Steuart St 5 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft Permit Number 779216 6015182.77044 2116248.02621 37.7916665652214 -122.391360675282 (37.7916665652214, -122.391360675282) 6 2 9 28855 6
90950 100267 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015119.18661 2113440.63946 37.7839545953771 -122.391384334617 (37.7839545953771, -122.391384334617) 6 2 9 28856 6
59740 190351 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 6 Federal St 2 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 2ft   6015118.92917 2113473.33834 37.7840443647849 -122.391387511922 (37.7840443647849, -122.391387511922) 6 2 9 28856 6
116300 39875 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 301 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/21/1999 12:00:00 AM 14   Permit Number 41173 6015122.44889 2113715.2291 37.7847087371596 -122.391392250474 (37.7847087371596, -122.391392250474) 6 2 9 28856 6
41969 190287 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 200 Steuart St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft Permit Number 779216 6015169.04888 2116262.66084 37.7917059869819 -122.391409175691 (37.7917059869819, -122.391409175691) 6 2 9 28855 6
125536 39874 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 301 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/21/1999 12:00:00 AM 11   Permit Number 41173 6015106.35848 2113700.77588 37.7846681588638 -122.391446907649 (37.7846681588638, -122.391446907649) 6 2 9 28856 6
90814 100266 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2017 12:00:00 AM 3 1x1 Permit Number 779105 6015095.83494 2113421.2206 37.7838999795421 -122.391463765467 (37.7838999795421, -122.391463765467) 6 2 9 28856 6
29466 190286 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 200 Steuart St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft Permit Number 779216 6015153.32574 2116277.33628 37.791745409684 -122.391464604522 (37.791745409684, -122.391464604522) 6 2 9 28855 6
175116 190347 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 75 Howard St 5 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6015078.15625 2116306.22722 37.7918205651212 -122.391726713716 (37.7918205651212, -122.391726713716) 6 2 9 28855 6
19192 173595 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 75 Howard St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779216 6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
135695 173594 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 75 Howard St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779216 6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
136494 190346 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 75 Howard St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6015051.30484 2116280.75436 37.7917491319689 -122.391817838416 (37.7917491319689, -122.391817838416) 6 2 9 28855 6
54698 190345 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 75 Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6015041.59438 2116270.26796 37.7917197996771 -122.391850703268 (37.7917197996771, -122.391850703268) 6 2 9 28855 6
67992 190344 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 75 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6015032.67079 2116261.93292 37.791696418196 -122.391880996008 (37.791696418196, -122.391880996008) 6 2 9 28855 6
90317 190297 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 225 Main St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6015009.1682 2115480.58395 37.7895497094874 -122.39190765463 (37.7895497094874, -122.39190765463) 6 2 9 28855 6
26206 190356 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 20 Federal St 5 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6014957.44747 2113321.82053 37.7836193676832 -122.391935585771 (37.7836193676832, -122.391935585771) 6 2 9 28856 6
165961 190298 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 225 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 5ft   6014996.87623 2115494.03882 37.7895859710557 -122.391951125143 (37.7895859710557, -122.391951125143) 6 2 9 28855 6
176775 190299 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 225 Main St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6014982.16356 2115508.5855 37.7896250960729 -122.39200304752 (37.7896250960729, -122.39200304752) 6 2 9 28855 6
167781 190266 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 88 Howard St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6014977.64863 2116290.90122 37.7917729037345 -122.392073400593 (37.7917729037345, -122.392073400593) 12 2 9 28855 6
45894 190104 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333 Bryant St 10 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6014895.60705 2113505.18566 37.7841194132319 -122.392162359709 (37.7841194132319, -122.392162359709) 6 2 9 28856 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)
);