5,599 rows where qSpecies_id = 38 sorted by Neighborhoods (old) descending

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) ▲
489 225574 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 99 Carmelita St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6002579.4442 2108765.68107 37.7704143837497 -122.434432832327 (37.7704143837497, -122.434432832327) 15 5 5 29492 9
3237 225589 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 574 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002963.17537 2108925.95481 37.7708762305838 -122.433116959576 (37.7708762305838, -122.433116959576) 15 5 11 29492 9
38573 225588 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 574 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002974.20041 2108926.43451 37.770878173112 -122.43307885801 (37.770878173112, -122.43307885801) 15 5 11 29492 9
46555 225578 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 65 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002844.97725 2108658.99607 37.7701365220099 -122.433506728452 (37.7701365220099, -122.433506728452) 15 5 5 29492 9
55228 225300 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 211 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6003287.35354 2109023.39168 37.7711621520335 -122.432002579076 (37.7711621520335, -122.432002579076) 15 9 11 29492 9
62775 225576 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 643 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002628.7314 2108833.7485 37.7706040777465 -122.434267214971 (37.7706040777465, -122.434267214971) 15 5 5 29492 9
67059 225299 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 221 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6003274.14308 2109066.3045 37.7712792311695 -122.432051339418 (37.7712792311695, -122.432051339418) 15 9 11 29492 9
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
80165 225582 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 522 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6003246.02864 2108961.15709 37.770988928222 -122.432141078263 (37.770988928222, -122.432141078263) 15 5 11 29492 9
83585 225301 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 211 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6003291.01939 2108992.95445 37.7710787866887 -122.431987724972 (37.7710787866887, -122.431987724972) 15 9 11 29492 9
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
88939 224892 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 198 Carl St 2 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 5ft   5997360.43615 2107105.4638 37.7655582200627 -122.452365481195 (37.7655582200627, -122.452365481195) 15 5 11 29492 9
92508 225590 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 574 Waller St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002879.79488 2108914.58573 37.7708402837701 -122.433404561864 (37.7708402837701, -122.433404561864) 15 5 11 29492 9
96279 255302 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1576 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1           5998599.10204 2108661.87853 37.7699026256233 -122.448193312417 (37.7699026256233, -122.448193312417) 15 5 11 29492 9
96972 224891 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 950 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5997254.06668 2107165.46874 37.7657168838478 -122.452737718683 (37.7657168838478, -122.452737718683) 15 5 11 29492 9
98365 225587 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 538 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6003122.79624 2108947.07187 37.770943266058 -122.432566336171 (37.770943266058, -122.432566336171) 15 5 11 29492 9
100561 225583 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 522 Waller St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6003217.89719 2108958.19966 37.7709792128517 -122.432238174463 (37.7709792128517, -122.432238174463) 15 5 11 29492 9
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
104154 225581 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 522 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6003268.16607 2108966.36138 37.7710044730146 -122.432064875993 (37.7710044730146, -122.432064875993) 15 5 11 29492 9
108522 225577 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 611 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002745.77151 2108846.89793 37.7706468252076 -122.433863312344 (37.7706468252076, -122.433863312344) 15 5 5 29492 9
116977 225586 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 532 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6003145.61474 2108950.84672 37.7709549248554 -122.432487676083 (37.7709549248554, -122.432487676083) 15 5 11 29492 9
121250 224893 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1104 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5997326.68958 2106652.02615 37.7643112623778 -122.452449477855 (37.7643112623778, -122.452449477855) 15 5 11 29492 9
121458 225584 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 522 Waller St 4 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6003199.3113 2108952.9224 37.7709636689664 -122.43230208659 (37.7709636689664, -122.43230208659) 15 5 11 29492 9
124128 224843 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 136 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   5997834.59787 2106822.47641 37.7648083617534 -122.450705064691 (37.7648083617534, -122.450705064691) 15 5 11 29492 9
124130 225572 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 99 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6002575.26449 2108799.82425 37.7705078952528 -122.434449731496 (37.7705078952528, -122.434449731496) 15 5 5 29492 9
128388 224840 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 859 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5998028.72415 2107228.24111 37.7659335988803 -122.450062883111 (37.7659335988803, -122.450062883111) 15 5 11 29492 9
137468 225585 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 522 Waller St 5 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6003180.08818 2108951.19631 37.7709578395549 -122.432368456556 (37.7709578395549, -122.432368456556) 15 5 11 29492 9
139402 226532 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 138 Scott St 1 Sidewalk: Curb side : Pot Tree Private 2     14 Width 4ft   6002359.73994 2109019.27309 37.7710982111319 -122.435210930252 (37.7710982111319, -122.435210930252) 15 5 11 29492 9
159597 224842 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 102 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5997969.62507 2107187.74579 37.7658190270475 -122.450264374404 (37.7658190270475, -122.450264374404) 15 5 11 29492 9
162270 247218 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 898 Duboce Ave 2 : Tree Private 2     17 Width 3ft   6001717.2937 2108310.88188 37.7691166413408 -122.43738243597 (37.7691166413408, -122.43738243597) 15 5 5 29492 9
163635 224841 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5997991.47518 2107190.00433 37.7658264788437 -122.450188962655 (37.7658264788437, -122.450188962655) 15 5 11 29492 9
167618 225579 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 81 Potomac St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6003074.04768 2108821.14114 37.770594726591 -122.432725961361 (37.770594726591, -122.432725961361) 15 5 5 29492 9
167824 225580 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 56 Potomac St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003134.5643 2108628.68734 37.7700697275663 -122.432502885425 (37.7700697275663, -122.432502885425) 15 5 5 29492 9
178581 224844 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 136 Parnassus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5997818.47263 2106817.04538 37.7647925264819 -122.450760445847 (37.7647925264819, -122.450760445847) 15 5 11 29492 9
184094 225573 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 99 Carmelita St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002575.91941 2108784.24181 37.7704651468881 -122.434446351835 (37.7704651468881, -122.434446351835) 15 5 5 29492 9
191520 247220 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 898 Duboce Ave 4 : Tree Private 2     17 Width 3ft   6001660.99493 2108696.8913 37.7701733267561 -122.437604817625 (37.7701733267561, -122.437604817625) 15 5 5 29492 9
77 225344 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 207 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6004214.46195 2097518.65353 37.7396253677099 -122.42797572342 (37.7396253677099, -122.42797572342) 2 7 5 63 7
1273 246677 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 25 Randall St 2 Sidewalk: Property side : Yard Tree Private 2     14     6005248.94304 2097610.63078 37.7399363874552 -122.424405469757 (37.7399363874552, -122.424405469757) 2 7 5 63 7
6294 5744 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1759 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 6x6   6005374.75018 2098167.61874 37.7414728539803 -122.424010079215 (37.7414728539803, -122.424010079215) 2 7 5 28859 7
11943 246684 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 65 Randall St 7 Sidewalk: Property side : Yard Tree Private 2     17 Width 4ft   6004997.42528 2097597.83608 37.7398870497478 -122.425274204056 (37.7398870497478, -122.425274204056) 2 7 5 63 7
19004 224884 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 486 Laidley St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6003425.22105 2096310.99057 37.7362647190293 -122.430618425309 (37.7362647190293, -122.430618425309) 2 7 5 63 7
19698 225323 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 47 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6004900.68553 2098061.45779 37.74115458393 -122.425641678722 (37.74115458393, -122.425641678722) 2 7 5 63 7
22402 104719 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 61- 63 SUSSEX ST   Sidewalk: Curb side : Cutout Tree Private 2     14 3x3 Permit Number 771137 6002409.7 2096544.3 37.7368477492981 -122.434146170859 (37.7368477492981, -122.434146170859) 2 7 5 63 7
26032 30564 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 633 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1995 12:00:00 AM 9   Permit Number 34542 6002889.41967 2095678.38488 37.7344973596725 -122.432425741574 (37.7344973596725, -122.432425741574) 2 7 5 63 7
27700 224876 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 630 Chenery St 5 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6002697.41175 2095710.10509 37.7345735664086 -122.433091841534 (37.7345735664086, -122.433091841534) 2 7 5 63 7
28246 105037 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 60 Hiliritas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 770444 6001403.1 2096820.4 37.7375486740807 -122.437646191192 (37.7375486740807, -122.437646191192) 2 7 5 63 7
28681 225348 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 5407 Diamond Heights Blvd 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6002089.89728 2098106.21858 37.7411182594017 -122.435363562302 (37.7411182594017, -122.435363562302) 2 7 5 63 7
28995 224886 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2830 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6002399.50987 2095496.07417 37.7339689836782 -122.434106491738 (37.7339689836782, -122.434106491738) 2 7 5 63 7
29236 5745 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1764 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 4X6   6005291.38109 2098122.5242 37.7413443273726 -122.424295134606 (37.7413443273726, -122.424295134606) 2 7 5 63 7
31064 246678 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 65 Randall St 1 Sidewalk: Property side : Yard Tree Private 2     19 Width 4ft   6005222.8012 2097609.38503 37.7399314906489 -122.424495768869 (37.7399314906489, -122.424495768869) 2 7 5 63 7
31623 246675 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 950 San Jose Ave 5 Front Yard : Yard Tree Private 2     19 Width 8ft   6005283.66351 2097689.92499 37.7401560720365 -122.424291058881 (37.7401560720365, -122.424291058881) 2 7 5 28859 7
34945 246685 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 65 Randall St 8 Sidewalk: Property side : Yard Tree Private 2     16 Width 4ft   6004978.80333 2097597.3431 37.7398846440669 -122.425338555951 (37.7398846440669, -122.425338555951) 2 7 5 63 7
37029 224875 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 630 Chenery St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 1ft   6002716.38989 2095711.86883 37.7345794857458 -122.433026353782 (37.7345794857458, -122.433026353782) 2 7 5 63 7
37569 225324 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 47 Chenery St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6004897.32694 2098075.53928 37.74119305872 -122.425654293515 (37.74119305872, -122.425654293515) 2 7 5 63 7
37620 246674 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 950 San Jose Ave 4 Front Yard : Yard Tree Private 2     16 Width 8ft   6005286.18809 2097704.16876 37.7401953247637 -122.424283342697 (37.7401953247637, -122.424283342697) 2 7 5 28859 7
38202 5734 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1725 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3x3   6005365.37115 2098326.96084 37.7419098417621 -122.424053837524 (37.7419098417621, -122.424053837524) 2 7 5 28859 7
39188 224872 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 630 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 1ft   6002774.43666 2095713.13572 37.734586256738 -122.432825757301 (37.734586256738, -122.432825757301) 2 7 5 63 7
42361 224879 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 670 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 2x2   6002563.91545 2095705.58789 37.7345535897736 -122.433553059737 (37.7345535897736, -122.433553059737) 2 7 5 63 7
44033 246682 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 65 Randall St 5 Sidewalk: Property side : Yard Tree Private 2     16 Width 4ft   6005028.19634 2097600.03774 37.7398948333787 -122.425167967128 (37.7398948333787, -122.425167967128) 2 7 5 63 7
44647 225328 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1893 Church St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6004620.6476 2097622.71658 37.7399340725935 -122.426578715634 (37.7399340725935, -122.426578715634) 2 7 5 63 7
46496 225347 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 5407 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree Private 2     13 Width 4ft   6002088.49796 2098106.80956 37.7411198026258 -122.435368442903 (37.7411198026258, -122.435368442903) 2 7 5 63 7
52122 224882 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 470 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6003486.83593 2096359.19569 37.7364005697204 -122.430408835608 (37.7364005697204, -122.430408835608) 2 7 5 63 7
61301 225326 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 130 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004713.98377 2097574.34607 37.7398065343366 -122.426252554911 (37.7398065343366, -122.426252554911) 2 7 5 63 7
63882 4311 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 704 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6002439.77272 2095706.35497 37.7345486515816 -122.433982316925 (37.7345486515816, -122.433982316925) 2 7 5 63 7
64772 225332 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 18 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6004251.30124 2098200.3736 37.7414992994585 -122.427896913128 (37.7414992994585, -122.427896913128) 2 7 5 63 7
65990 225343 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 359 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6004180.48098 2098361.98479 37.7419390400607 -122.428153299956 (37.7419390400607, -122.428153299956) 2 7 5 63 7
72110 104720 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 63 SUSSEX ST   Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6002455.5 2096493.1 37.7367097651894 -122.433984161514 (37.7367097651894, -122.433984161514) 2 7 5 63 7
72997 224888 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 204 Sussex St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001640.90489 2096431.24793 37.736493671139 -122.436796139152 (37.736493671139, -122.436796139152) 2 7 5 63 7
74493 225327 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1893 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6004623.32854 2097601.54751 37.7398760987005 -122.426567939052 (37.7398760987005, -122.426567939052) 2 7 5 63 7
74676 225325 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 44 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6004860.59218 2098037.89112 37.7410876096139 -122.425778630199 (37.7410876096139, -122.425778630199) 2 7 5 63 7
77324 246681 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 65 Randall St 4 Sidewalk: Property side : Yard Tree Private 2     18 Width 4ft   6005137.38612 2097606.83226 37.7399196573536 -122.424790917387 (37.7399196573536, -122.424790917387) 2 7 5 63 7
79835 224887 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 204 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001690.70121 2096422.54487 37.7364726045189 -122.436623349686 (37.7364726045189, -122.436623349686) 2 7 5 63 7
82363 225337 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3121 Castro St 4 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6002904.9845 2095758.97313 37.7347195191986 -122.432377682707 (37.7347195191986, -122.432377682707) 2 7 5 63 7
98504 224873 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 630 Chenery St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 1ft   6002752.39129 2095712.47226 37.7345831846595 -122.432901928087 (37.7345831846595, -122.432901928087) 2 7 5 63 7
106743 2016 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 598 Bosworth St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3 Permit Number 772999 6002387.1334523 2095371.0933821 37.7336251126369 -122.434140349269 (37.7336251126369, -122.434140349269) 2 7 5 63 7
108532 5118 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2721 Diamond St 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 4X4   6002423.4063 2096112.93814 37.7356641067988 -122.434067955786 (37.7356641067988, -122.434067955786) 2 7 5 63 7
108625 225341 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 120 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6002714.46502 2096770.94289 37.7374873509646 -122.433108653456 (37.7374873509646, -122.433108653456) 2 7 5 63 7
114913 225330 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 63 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6004305.07252 2097879.01532 37.740619964851 -122.427688099527 (37.740619964851, -122.427688099527) 2 7 5 63 7
117278 224871 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 243 Chenery St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6004648.05495 2096912.10282 37.7379844377336 -122.42643336811 (37.7379844377336, -122.42643336811) 2 7 5 63 7
117366 225338 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3045 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6002897.89077 2095961.40859 37.7352749584633 -122.432416662015 (37.7352749584633, -122.432416662015) 2 7 5 63 7
121166 224885 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 486 Laidley St 4 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6003400.61193 2096293.50679 37.7362153183682 -122.430702261917 (37.7362153183682, -122.430702261917) 2 7 5 63 7
122710 246687 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 65 Randall St 10 Sidewalk: Property side : Yard Tree Private 2     14 Width 9ft   6004944.1218 2097602.36636 37.7398964773322 -122.425458827663 (37.7398964773322, -122.425458827663) 2 7 5 63 7
122950 224883 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 486 Laidley St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6003443.08851 2096324.3523 37.7363024195061 -122.430557603265 (37.7363024195061, -122.430557603265) 2 7 5 63 7
123788 225345 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 230 Beacon St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6003063.3105 2097714.60702 37.7400982177717 -122.431969895896 (37.7400982177717, -122.431969895896) 2 7 5 63 7
124184 225342 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2409 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6001890.8012 2097157.51545 37.7385020326503 -122.435984095409 (37.7385020326503, -122.435984095409) 2 7 5 63 7
125015 246679 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 65 Randall St 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005202.46496 2097607.42576 37.7399249624788 -122.424565943861 (37.7399249624788, -122.424565943861) 2 7 5 63 7
125271 246673 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 950 San Jose Ave 3 Front Yard : Yard Tree Private 2     15 Width 8ft   6005263.853 2097708.23975 37.7402052415794 -122.424360857976 (37.7402052415794, -122.424360857976) 2 7 5 63 7
132068 224881 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 631 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6002911.10799 2095680.36201 37.7345040182354 -122.432350899088 (37.7345040182354, -122.432350899088) 2 7 5 63 7
139294 224877 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 654 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6002658.40723 2095708.21632 37.7345661676825 -122.433226558173 (37.7345661676825, -122.433226558173) 2 7 5 63 7
144337 225322 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 51 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6004900.45261 2098012.16019 37.7410192107607 -122.425638976271 (37.7410192107607, -122.425638976271) 2 7 5 63 7
146815 4953 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 598 Bosworth St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3 Permit Number 772999 6002387.1334523 2095371.0933821 37.7336251126369 -122.434140349269 (37.7336251126369, -122.434140349269) 2 7 5 63 7
146835 5746 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1765 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/02/1998 12:00:00 AM 50 3x3   6005379.08907 2098105.72339 37.7413031483252 -122.423990676354 (37.7413031483252, -122.423990676354) 2 7 5 28859 7
147141 225333 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 52 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6004265.12769 2097918.21951 37.740725351001 -122.427829006197 (37.740725351001, -122.427829006197) 2 7 5 63 7
150765 225346 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 230 Beacon St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6003056.67817 2097724.21809 37.7401242315531 -122.431993513899 (37.7401242315531, -122.431993513899) 2 7 5 63 7
151431 246683 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 65 Randall St 6 Sidewalk: Property side : Yard Tree Private 2     17 Width 4ft   6005013.28889 2097598.95016 37.7398910049652 -122.425219433535 (37.7398910049652, -122.425219433535) 2 7 5 63 7
153007 5730 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1703 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 3x3   6005364.14251 2098372.71448 37.7420354015178 -122.424061338766 (37.7420354015178, -122.424061338766) 2 7 5 28859 7
153098 246676 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 25 Randall St 1 Sidewalk: Property side : Yard Tree Private 2     15     6005260.16764 2097612.18333 37.739941284251 -122.424366770116 (37.739941284251, -122.424366770116) 2 7 5 28859 7
155657 225349 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 204 Addison St 11 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6002618.38259 2097557.08683 37.7396404700191 -122.433497019365 (37.7396404700191, -122.433497019365) 2 7 5 63 7
156873 246680 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 65 Randall St 3 Sidewalk: Property side : Yard Tree Private 2     18 Width 4ft   6005184.39895 2097607.58215 37.7399243716053 -122.424628419782 (37.7399243716053, -122.424628419782) 2 7 5 63 7
163906 224878 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 660 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6002621.84248 2095706.54676 37.7345595091169 -122.433352855352 (37.7345595091169, -122.433352855352) 2 7 5 63 7

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