trees

5,599 rows where qSpecies_id = 38 sorted by SiteOrder descending

✎ 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)
1163 127620 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 888 O'Farrell St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6007042.74082 2114007.27438 37.7850588791954 -122.419366145639 (37.7850588791954, -122.419366145639) 13 9 9 28858 36
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
6165 128151 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 580 North Point St 9 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007611.87437 2121662.99743 37.806111628806 -122.417940009725 (37.806111628806, -122.417940009725) 5 1 10 308 23
8438 189632 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 9 : Tree Private 2     7 Width 3ft   6007298.00895 2110457.3775 37.7753260931545 -122.4182312237 (37.7753260931545, -122.4182312237) 8 2 9 28853 34
12134 192099 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 999 Brannan St 9 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6010725.77317 2108634.41691 37.7705130105866 -122.406245268117 (37.7705130105866, -122.406245268117) 14 2 9 28853 34
12804 128534 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 400 California St 9 Sidewalk: Curb side : Pot Tree Private 2     7 Width 4ft   6012182.93636 2116816.58192 37.7930607374112 -122.40178012248 (37.7930607374112, -122.40178012248) 4 1 10 28854 6
14745 128030 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2601 Jones St 9 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007872.77059 2121403.52137 37.8054138529431 -122.41701873613 (37.8054138529431, -122.41701873613) 5 1 10 308 23
15447 128076 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2015 12:00:00 AM 7 Width 4ft   6009546.7837 2121872.26218 37.8067949229139 -122.411258701628 (37.8067949229139, -122.411258701628) 3 1 10 308 23
16022 189735 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 601 Carolina St 9 Sidewalk: Curb side : Yard Tree Private 2     18 Width 4ft   6012410.52829 2105115.38305 37.7609446260225 -122.400170465508 (37.7609446260225, -122.400170465508) 10 3 8 28856 29
23397 124713 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3801 Jackson St 9 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5996049.91136 2115838.85181 37.7894626335257 -122.457530193146 (37.7894626335257, -122.457530193146) 11 6 1 54 31
27788 128189 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 151 Beach St 9 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009528.34804 2122220.78416 37.8077508429053 -122.411347139176 (37.8077508429053, -122.411347139176) 3 1 10 308 23
28732 190212 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Main St 9 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6013901.3012 2116638.71234 37.7926680934122 -122.395821969133 (37.7926680934122, -122.395821969133) 12 2 9 28855 6
30666 128452 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 251 Leidesdorff St 9 Sidewalk: Curb side : Pot Tree Private 2     3 Width 4ft   6012151.25811 2116572.97679 37.7923900877774 -122.401872599739 (37.7923900877774, -122.401872599739) 4 1 10 28854 6
30903 128329 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 149 Union St 9 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6012232.63736 2119812.905 37.8012906951799 -122.401818868842 (37.8012906951799, -122.401818868842) 3 1 10 28860 6
32617 128360 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1335 Battery St 9 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6012168.05905 2120565.84348 37.8033544773788 -122.402095303366 (37.8033544773788, -122.402095303366) 3 1 10 28860 6
33865 192078 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 121 Vermont St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6011151.47451 2107676.74683 37.7679072699252 -122.404705326615 (37.7679072699252, -122.404705326615) 8 2 8 28853 20
36036 126686 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2801 Divisadero St 9 Sidewalk: Curb side : Yard Tree Private 2     10 Width 5ft   6000576.75881 2117918.99228 37.7954331417917 -122.44201721444 (37.7954331417917, -122.44201721444) 13 9 1 57 17
37397 192113 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 367 Tehama St 9 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6011501.93196 2112608.02873 37.7814670175328 -122.403840169795 (37.7814670175328, -122.403840169795) 6 2 9 28853 34
50192 126993 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3298 Lyon St 9 Sidewalk: Property side : Yard Tree Private 2     8     5998985.37551 2120178.14936 37.8015453660859 -122.447686356233 (37.8015453660859, -122.447686356233) 13 9 1 57 17
52459 128697 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300 Washington St 9 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6012777.65332 2117891.02411 37.7960440710348 -122.399797834099 (37.7960440710348, -122.399797834099) 3 1 10 28860 6
54981 128067 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 262 North Point St 9 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6009106.30735 2121812.3096 37.8066055949469 -122.412778821206 (37.8066055949469, -122.412778821206) 3 1 10 308 23
62522 224416 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401 Treat Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6008516.77997 2105987.6049 37.7631216679456 -122.413698975134 (37.7631216679456, -122.413698975134) 8 4 7 28859 19
63261 190308 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 250 Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6014212.34397 2115184.6648 37.7886929154874 -122.39464387162 (37.7886929154874, -122.39464387162) 6 2 9 28855 6
63931 102343 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401X Shotwell St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007842 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168) 2 4 7 28859 19
69661 128278 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Francisco St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6011061.67313 2121388.29143 37.8055509024268 -122.405981985279 (37.8055509024268, -122.405981985279) 3 1 10 308 23
69729 128092 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 103 North Point St 9 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6009993.77559 2121931.64675 37.8069830367907 -122.409715985714 (37.8069830367907, -122.409715985714) 3 1 10 308 23
70102 218860 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1251 Funston Ave 9 Sidewalk: Property side : Yard Tree Private 2     13 Width 5ft   5992040.08055 2106742.72997 37.7642560107433 -122.470740807837 (37.7642560107433, -122.470740807837) 11 8 11 56 12
70260 128018 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 590 Bay St 9 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008038.597 2121376.6539 37.8053494084019 -122.416442965895 (37.8053494084019, -122.416442965895) 5 1 10 308 23
71057 128423 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 555 California St 9 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6011652.82402 2116681.38522 37.7926599221578 -122.403604835222 (37.7926599221578, -122.403604835222) 4 1 10 28854 6
71207 128686 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 200 Washington St 9 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6012997.95384 2117920.58434 37.796137515079 -122.399037621889 (37.796137515079, -122.399037621889) 3 1 10 28860 6
72325 189618 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1022 Harrison St 9 Sidewalk: Curb side : Yard Tree Private 2     23 Width 0ft   6010891.12293 2110540.49572 37.7757559115527 -122.405807604052 (37.7757559115527, -122.405807604052) 14 2 9 28853 34
72487 190248 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 60 New Montgomery St 9 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   6012269.23486 2114994.91979 37.7880636994144 -122.401353446303 (37.7880636994144, -122.401353446303) 12 2 9 28855 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
77185 128757 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 145 Geary St 9 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   6010952.86492 2114849.98538 37.7875922118533 -122.405897664862 (37.7875922118533, -122.405897664862) 5 1 10 28857 6
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
84694 190103 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333 Bryant St 9 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6014885.29467 2113497.67268 37.7840982117166 -122.392197511514 (37.7840982117166, -122.392197511514) 6 2 9 28856 6
90853 128135 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2600 Jones St 9 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007852.40976 2121884.93258 37.8067345406434 -122.417123330884 (37.8067345406434, -122.417123330884) 5 1 10 308 23
92309 128339 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 190 Greenwich St 9 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6011923.93675 2120509.9323 37.8031873303005 -122.402936167667 (37.8031873303005, -122.402936167667) 3 1 10 28860 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
110758 128157 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 200 Beach St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008823.92017 2122168.8612 37.8075687418561 -122.413781315277 (37.8075687418561, -122.413781315277) 3 1 10 308 23
112454 190181 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 20 Spear St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6014094.61012 2116862.47667 37.7932932499214 -122.395168788833 (37.7932932499214, -122.395168788833) 12 2 9 28855 6
113955 192089 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 655 09th St 9 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6010646.91946 2108374.21926 37.7697941564051 -122.406499687216 (37.7697941564051, -122.406499687216) 14 2 9 28853 34
116726 189706 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 500 Wisconsin St 9 Sidewalk: Curb side : Yard Tree Private 2     16 Width 4ft   6012644.06418 2105069.38054 37.7608313321313 -122.399359532434 (37.7608313321313, -122.399359532434) 10 3 8 28856 29
119403 192029 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 601 Brannan St 9 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6012902.72158 2110721.58768 37.7763654396501 -122.398861645263 (37.7763654396501, -122.398861645263) 14 2 9 28856 20
120317 128226 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 68 Green St 9 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6012467.83694 2119552.09835 37.8005877059291 -122.40098663443 (37.8005877059291, -122.40098663443) 3 1 10 28860 6
124416 127927 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2801 Leavenworth St 9 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6007301.7835 2122057.61602 37.80717769417 -122.419041140535 (37.80717769417, -122.419041140535) 5 1 1 308 32
126628 128595 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 200 Clay St 9 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6013078.47756 2117624.40892 37.7953287745432 -122.398738196213 (37.7953287745432, -122.398738196213) 3 1 10 28860 6
129933 127601 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 7 Ada Ct 9 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008097.93593 2114185.63609 37.785607990854 -122.415728126257 (37.785607990854, -122.415728126257) 13 10 9 28858 36
133976 128260 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 350 Union St 9 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 5ft   6011214.5858 2119722.17794 37.8009847143318 -122.40533540152 (37.8009847143318, -122.40533540152) 3 1 10 308 23
140131 190238 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 536 Mission St 9 Sidewalk: Curb side : Pot Tree Private 2     6 Width 4ft   6013026.80272 2115299.87413 37.7889432705555 -122.398753786863 (37.7889432705555, -122.398753786863) 12 2 9 28855 6
141274 189822 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 601 15th St 9 Sidewalk: Curb side : Yard Tree Private 2     5 Width 9ft   6010499.44736 2107381.21521 37.7670593432431 -122.406939792959 (37.7670593432431, -122.406939792959) 8 4 8 28853 19
143386 128118 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2300 Stockton St 9 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6009758.48929 2122143.44991 37.8075514074356 -122.410545211918 (37.8075514074356, -122.410545211918) 3 1 10 308 23
153881 127645 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 30 Grove St 9 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6007914.85136 2111702.90673 37.7787807209819 -122.416185649145 (37.7787807209819, -122.416185649145) 7 10 9 28852 36
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
155677 127669 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 330 Gough St 9 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6005967.66445 2111019.78524 37.7767953560506 -122.422873178776 (37.7767953560506, -122.422873178776) 7 9 11 28852 10
160043 127698 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 751 Powell St 9 Sidewalk: Property side : Yard Tree Private 2     16 Width 5ft   6010051.43478 2116188.24535 37.7912162971438 -122.409110915531 (37.7912162971438, -122.409110915531) 5 1 10 28857 21
165846 246686 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 65 Randall St 9 Sidewalk: Property side : Yard Tree Private 2     15 Width 4ft   6004961.87116 2097597.94468 37.7398853392354 -122.425397143159 (37.7398853392354, -122.425397143159) 2 7 5 63 7
167008 126887 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Laurel St 9 Sidewalk: Property side : Yard Tree Private 2     3 Width 5ft   5997958.22351 2116171.20498 37.7904846177085 -122.450951650704 (37.7904846177085, -122.450951650704) 11 6 1 54 31
171273 128578 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 201 Washington St 9 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6012817.38168 2117842.31547 37.7959125433723 -122.399656943619 (37.7959125433723, -122.399656943619) 3 1 10 28860 6
174536 127636 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 11 Hyde St 9 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6008243.47914 2111763.69267 37.7789660973341 -122.415053096938 (37.7789660973341, -122.415053096938) 7 10 9 28852 36
176561 190106 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 201 Utah St 9 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6010614.87251 2107171.01836 37.7664886487543 -122.406525739687 (37.7664886487543, -122.406525739687) 8 4 8 28853 19
176977 192127 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 9 Sidewalk: Curb side : Cutout Tree Private 2     28 Width 4ft   6011174.16734 2113444.92425 37.7837466199541 -122.405033027869 (37.7837466199541, -122.405033027869) 12 2 9 28853 34
178013 128101 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2201 Grant Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6010201.67943 2122072.10494 37.8073803482992 -122.409006405322 (37.8073803482992, -122.409006405322) 3 1 10 308 23
178059 225362 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 127 Otis St 9 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6007088.61853 2109536.64947 37.7727862053595 -122.418890239704 (37.7727862053595, -122.418890239704) 8 2 9 28853 19
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
178782 117412 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Beach St 9 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6010061.45891 2122289.54556 37.8079695301268 -122.409507028246 (37.8079695301268, -122.409507028246) 3 1 10 308 23
180914 117221 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 601 04th St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013696.95586 2111359.64962 37.7781616357824 -122.396158874945 (37.7781616357824, -122.396158874945) 6 2 9 28856 34
183147 189814 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 220 San Bruno Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6010837.6944 2107202.68017 37.766588048125 -122.405757265404 (37.766588048125, -122.405757265404) 8 4 8 28853 19
183456 190161 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 70 Steuart St 9 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6014398.2376 2117062.09788 37.7938582436193 -122.394132190649 (37.7938582436193, -122.394132190649) 12 2 9 28855 6
184023 128604 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 302 Clay St 9 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6012720.62392 2117571.18335 37.7951626850618 -122.399972696483 (37.7951626850618, -122.399972696483) 3 1 10 28860 6
184781 116053 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 650x Kansas St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   11 4x4   6011508.10962 2105241.51829 37.7612406063998 -122.403300427289 (37.7612406063998, -122.403300427289) 10 3 8 28856 29
184863 23534 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2750 Van Ness Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6005725.00193 2119903.11609 37.8011730737373 -122.42434460005 (37.8011730737373, -122.42434460005) 13 9 1 28858 32
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
187712 128175 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 211 Beach St 9 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009042.02771 2122152.12434 37.80753503259 -122.413025316376 (37.80753503259, -122.413025316376) 3 1 10 308 23
191525 127096 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1550 Bay St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003346.89879 2120714.49093 37.8032663249393 -122.432631856298 (37.8032663249393, -122.432631856298) 13 9 1 57 17
192288 127515 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 335 Powell St 9 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   6010244.58304 2114855.01998 37.7875663986225 -122.408348546747 (37.7875663986225, -122.408348546747) 5 1 10 28852 36
192348 192069 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 400 15th St 9 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6011186.3676 2107464.93063 37.7673276208966 -122.404569722336 (37.7673276208966, -122.404569722336) 8 2 8 28853 20
193180 127069 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3252 Pierce St 9 : Tree Private 2     9 Width 3ft   6001380.49031 2119587.4899 37.8000601663034 -122.439355830906 (37.8000601663034, -122.439355830906) 13 9 1 57 17
1548 128066 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 262 North Point St 8 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6009084.93005 2121810.40932 37.8065991773678 -122.412852667211 (37.8065991773678, -122.412852667211) 3 1 10 308 23
11125 127105 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1601 Beach St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002505.01994 2121244.09156 37.8046726892538 -122.435583111981 (37.8046726892538, -122.435583111981) 13 9 1 57 17
12427 189631 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 8 : Tree Private 2     9 Width 3ft   6007308.18753 2110441.11785 37.7752820209699 -122.418194860528 (37.7752820209699, -122.418194860528) 8 2 9 28853 34
13311 192077 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 121 Vermont St 8 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6011151.74903 2107654.57043 37.7678463939135 -122.404702815691 (37.7678463939135, -122.404702815691) 8 2 8 28853 20
15886 189725 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 645 Carolina St 8 Sidewalk: Curb side : Yard Tree Private 2     20 Width 4ft   6012416.08183 2104951.55133 37.7604950899983 -122.400139751846 (37.7604950899983, -122.400139751846) 10 3 8 28856 29
20350 190119 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Potrero Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 4ft   6010301.85923 2107798.08422 37.7681929117011 -122.407652618992 (37.7681929117011, -122.407652618992) 8 4 8 28853 19
22601 126687 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2801 Divisadero St 8 Sidewalk: Curb side : Yard Tree Private 2     9 Width 5ft   6000575.90002 2117927.00422 37.7954550915302 -122.442020761354 (37.7954550915302, -122.442020761354) 13 9 1 57 17
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
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
27898 128493 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 201 Montgomery St 8 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   6011961.6023 2116106.47919 37.791098610068 -122.402495999902 (37.791098610068, -122.402495999902) 4 1 10 28854 6
31888 127996 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 260 Bay St 8 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6009391.12172 2121556.20408 37.8059183752988 -122.411775055496 (37.8059183752988, -122.411775055496) 3 1 10 308 23
32622 128270 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2 Lombard St 8 Sidewalk: Curb side : Pot Tree Private 2     6 Width 4ft   6011859.51793 2120856.45591 37.8041352022456 -122.40318348214 (37.8041352022456, -122.40318348214) 3 1 10 28860 6
33850 127619 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 888 O'Farrell St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6007064.46096 2114011.06844 37.7850705200433 -122.419291269882 (37.7850705200433, -122.419291269882) 13 9 9 28858 36
34774 128075 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 111 North Point St 8 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6009525.60238 2121869.50761 37.806786171612 -122.411331809333 (37.806786171612, -122.411331809333) 3 1 10 308 23
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
35062 128315 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1150 Sansome St 8 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6011980.53416 2119746.61642 37.8010946105983 -122.402686597724 (37.8010946105983, -122.402686597724) 3 1 10 28860 6
37478 192126 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 8 Sidewalk: Curb side : Cutout Tree Private 2     28 Width 4ft   6011150.07784 2113419.14707 37.7836744952253 -122.405114553219 (37.7836744952253, -122.405114553219) 12 2 9 28853 34
38447 190237 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 536 Mission St 8 Sidewalk: Curb side : Pot Tree Private 2     6 Width 4ft   6013038.17401 2115310.45321 37.7889729517976 -122.398715186183 (37.7889729517976, -122.398715186183) 12 2 9 28855 6
40636 127635 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 11 Hyde St 8 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6008240.08971 2111777.143 37.7790028382582 -122.415065774669 (37.7790028382582, -122.415065774669) 7 10 9 28852 36
44841 192088 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 655 09th St 8 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   6010663.09055 2108361.27431 37.7697595172036 -122.406442839286 (37.7697595172036, -122.406442839286) 14 2 9 28853 34
47992 128412 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 251 Sutter St 8 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6011365.53208 2115598.62793 37.7896708769491 -122.404522629328 (37.7896708769491, -122.404522629328) 5 1 10 28857 6
48885 98651 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2110 Greenwich St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   23 5x5   6002674.17203 2119228.66956 37.7991484749737 -122.434853527066 (37.7991484749737, -122.434853527066) 13 9 1 57 17

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