Street_Tree_List

Data source: data.sfgov.org

575 rows where qSiteInfo = 13 sorted by SiteOrder descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▲ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
74522 74522 249896 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 230 Greenwich St 32 Back Yard : Yard 13 Tree 1 Private 1     24 Width 0ft   6011386.30387 2120437.51769 37.8029584618196 -122.404791570676 (37.8029584618196, -122.404791570676)
61728 61728 249895 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 230 Greenwich St 31 Back Yard : Yard 13 Tree 1 Private 1     18 Width 0ft   6011395.76102 2120447.38073 37.8029860719045 -122.404759538639 (37.8029860719045, -122.404759538639)
33977 33977 249894 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 230 Greenwich St 30 Back Yard : Yard 13 Tree 1 Private 1     24 Width 0ft   6011403.76038 2120447.63681 37.802987222140395 -122.40473187458599 (37.8029872221404, -122.404731874586)
185525 185525 249893 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 230 Greenwich St 29 Back Yard : Yard 13 Tree 1 Private 1     13 Width 0ft   6011394.800530001 2120441.53452 37.8029699659579 -122.404762450627 (37.8029699659579, -122.404762450627)
67699 67699 249892 Undocumented 2 Phoenix dactylifera :: Date Palm 65 230 Greenwich St 28 Back Yard : Yard 13 Tree 1 Private 1     36 Width 0ft   6011427.28959 2120425.37078 37.80292740013321 -122.404648882458 (37.8029274001332, -122.404648882458)
38350 38350 239199 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 27 Back Yard : Yard 13 Tree 1 Private 1     2     6005974.4493 2108807.19348 37.770720494984495 -122.422692434815 (37.7707204949845, -122.422692434815)
51583 51583 249891 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 230 Greenwich St 27 Back Yard : Yard 13 Tree 1 Private 1     15 Width 0ft   6011455.072819999 2120426.06234 37.8029308517393 -122.404552786308 (37.8029308517393, -122.404552786308)
130200 130200 239200 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 26 Back Yard : Yard 13 Tree 1 Private 1     2     6005967.71166 2108818.2564 37.7707504909794 -122.422716526767 (37.7707504909794, -122.422716526767)
158045 158045 249890 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 230 Greenwich St 26 Back Yard : Yard 13 Tree 1 Private 1     11 Width 0ft   6011458.55673 2120431.8571900004 37.8029469576839 -122.40454113827101 (37.8029469576839, -122.404541138271)
133851 133851 239201 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 25 Back Yard : Yard 13 Tree 1 Private 1     3     6005958.49088 2108828.3343599997 37.7707776424043 -122.422749137971 (37.7707776424043, -122.422749137971)
171235 171235 249889 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 230 Greenwich St 25 Back Yard : Yard 13 Tree 1 Private 1     8 Width 0ft   6011472.47528 2120454.19881 37.8030090801563 -122.404494546207 (37.8030090801563, -122.404494546207)
49446 49446 195978 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 24 Back Yard : Yard 13 Tree 1 Private 1     9 Width 4ft   6015236.23042 2100312.22008 37.747913311958605 -122.390061968785 (37.7479133119586, -122.390061968785)
56133 56133 249888 Undocumented 2 Calocedrus decurrens :: Incense Cedar 177 230 Greenwich St 24 Back Yard : Yard 13 Tree 1 Private 1     5 Width 0ft   6011477.22379 2120439.43792 37.80296881573079 -122.404477074154 (37.8029688157308, -122.404477074154)
180826 180826 239202 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 24 Back Yard : Yard 13 Tree 1 Private 1     2     6005953.73874 2108834.81297 37.7707951629947 -122.422766036225 (37.7707951629947, -122.422766036225)
31427 31427 223996 Undocumented 2 Eucalyptus rudis :: Swamp Gum: Flooded Gum 287 100 Hwy 101 Southbound 23 Back Yard : Yard 13 Tree 1 Private 1     18     6005945.0032 2108837.4935 37.770802030213105 -122.42279644320699 (37.7708020302131, -122.422796443207)
42525 42525 195977 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 23 Back Yard : Yard 13 Tree 1 Private 1     5 Width 4ft   6015256.877230001 2100313.90806 37.7479190918917 -122.389990690329 (37.7479190918917, -122.389990690329)
76843 76843 249887 Undocumented 2 Pinus radiata :: Monterey Pine 3 230 Greenwich St 23 Back Yard : Yard 13 Tree 1 Private 1     9 Width 0ft   6011491.952269999 2120439.55706 37.802969965942104 -122.40442611408399 (37.8029699659421, -122.404426114084)
59769 59769 239203 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 22 Back Yard : Yard 13 Tree 1 Private 1     3     6005946.44181 2108844.1649 37.7708204294492 -122.42279194121402 (37.7708204294492, -122.422791941214)
133072 133072 249886 Undocumented 2 Brugmansia spp :: Angel trumpet 137 230 Greenwich St 22 Back Yard : Yard 13 Tree 1 Private 1     10 Width 0ft   6011494.30214 2120434.10693 37.8029551325349 -122.404417598416 (37.8029551325349, -122.404417598416)
147625 147625 195976 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 22 Back Yard : Yard 13 Tree 1 Private 1     5 Width 4ft   6015275.57642 2100315.1093900003 37.7479234275315 -122.38992611271401 (37.7479234275315, -122.389926112714)
45307 45307 239204 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 21 Back Yard : Yard 13 Tree 1 Private 1     4     6005940.87649 2108850.7859900002 37.7708382953675 -122.422811662426 (37.7708382953675, -122.422811662426)
61234 61234 195975 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 21 Back Yard : Yard 13 Tree 1 Private 1     9 Width 4ft   6015294.9834 2100316.47199 37.747928245201 -122.389859098828 (37.747928245201, -122.389859098828)
171499 171499 249885 Undocumented 2 Brugmansia spp :: Angel trumpet 137 230 Greenwich St 21 Back Yard : Yard 13 Tree 1 Private 1     9 Width 0ft   6011498.61175 2120434.8744 37.8029574806516 -122.404402738904 (37.8029574806516, -122.404402738904)
158664 158664 239205 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 20 Back Yard : Yard 13 Tree 1 Private 1     2     6005934.94283 2108857.8407799997 37.7708573313359 -122.422832688574 (37.7708573313359, -122.422832688574)
171805 171805 195974 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 20 Back Yard : Yard 13 Tree 1 Private 1     12 Width 4ft   6015315.44713 2100317.81293 37.7479330619596 -122.389788429193 (37.7479330619596, -122.389788429193)
173534 173534 249884 Undocumented 2 Brugmansia spp :: Angel trumpet 137 230 Greenwich St 20 Back Yard : Yard 13 Tree 1 Private 1     5 Width 0ft   6011503.3679 2120436.4879799997 37.8029621769312 -122.404386393712 (37.8029621769312, -122.404386393712)
3750 3750 253551 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 19 Back Yard : Yard 13 Tree 1 DPW 2   09/22/2017 04:40:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
34978 34978 249883 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 230 Greenwich St 19 Back Yard : Yard 13 Tree 1 Private 1     14 Width 0ft   6011507.08304 2120427.1107900003 37.802936637067496 -122.40437287690901 (37.8029366370675, -122.404372876909)
173877 173877 195973 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 19 Back Yard : Yard 13 Tree 1 Private 1     10 Width 4ft   6015335.01264 2100318.2949099997 37.747935470342895 -122.38972080559601 (37.7479354703429, -122.389720805596)
183663 183663 239206 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 19 Back Yard : Yard 13 Tree 1 Private 1     3     6005929.117819999 2108865.00797 37.7708766820544 -122.42285334689899 (37.7708766820544, -122.422853346899)
3837 3837 253550 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 18 Back Yard : Yard 13 Tree 1 DPW 2   09/27/2017 11:43:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
23421 23421 195972 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 18 Back Yard : Yard 13 Tree 1 Private 1     10 Width 4ft   6015355.8319 2100319.8042599997 37.7479407691514 -122.389648918288 (37.7479407691514, -122.389648918288)
37934 37934 249882 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 230 Greenwich St 18 Back Yard : Yard 13 Tree 1 Private 1     27 Width 0ft   6011509.072430001 2120419.3733099997 37.8029155030083 -122.40436544761499 (37.8029155030083, -122.404365447615)
186175 186175 239207 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 18 Back Yard : Yard 13 Tree 1 Private 1     2     6005923.40296 2108870.98166 37.7708927619194 -122.422873539387 (37.7708927619194, -122.422873539387)
3841 3841 253549 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 17 Back Yard : Yard 13 Tree 1 DPW 2   09/27/2017 11:46:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
27098 27098 249881 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 230 Greenwich St 17 Back Yard : Yard 13 Tree 1 Private 1     16 Width 0ft   6011514.20842 2120460.74576 37.803029388647104 -122.404350588107 (37.8030293886471, -122.404350588107)
60490 60490 239208 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 17 Back Yard : Yard 13 Tree 1 Private 1     3     6005920.35776 2108877.05935 37.7709092779754 -122.42288450484 (37.7709092779754, -122.42288450484)
171288 171288 195971 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 17 Back Yard : Yard 13 Tree 1 Private 1     10 Width 4ft   6015377.86647 2100320.4119700002 37.7479436595871 -122.389572765484 (37.7479436595871, -122.389572765484)
3758 3758 253548 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 16 Back Yard : Yard 13 Tree 1 DPW 2   09/22/2017 04:31:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
33236 33236 195970 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 16 Back Yard : Yard 13 Tree 1 Private 1     8     6015399.1088 2100325.42161 37.747958592828205 -122.389499659601 (37.7479585928282, -122.389499659601)
133186 133186 249880 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 230 Greenwich St 16 Back Yard : Yard 13 Tree 1 Private 1     11 Width 0ft   6011523.78476 2120446.01272 37.8029894704488 -122.404316411196 (37.8029894704488, -122.404316411196)
163778 163778 223997 Undocumented 2 Eucalyptus rudis :: Swamp Gum: Flooded Gum 287 100 Hwy 101 Southbound 16 Back Yard : Yard 13 Tree 1 Private 1     18     6005905.0919699995 2108895.1603 37.770958117464396 -122.42293859636601 (37.7709581174644, -122.422938596366)
3842 3842 253547 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 15 Back Yard : Yard 13 Tree 1 DPW 2   09/27/2017 11:40:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
26205 26205 195969 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 15 Back Yard : Yard 13 Tree 1 Private 1     8     6015417.97335 2100326.09336 37.7479614832509 -122.389434473133 (37.7479614832509, -122.389434473133)
74282 74282 249879 Undocumented 2 Salix spp :: Willow 218 230 Greenwich St 15 Back Yard : Yard 13 Tree 1 Private 1     31 Width 0ft   6011548.40111 2120431.82846 37.8029518994613 -122.404230226458 (37.8029518994613, -122.404230226458)
84714 84714 92484 Permitted Site 1 Tree(s) :: 17 155 Greenwich St 15 Back Yard : Yard 13 Tree 1 Private 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
163352 163352 223998 Undocumented 2 Eucalyptus rudis :: Swamp Gum: Flooded Gum 287 100 Hwy 101 Southbound 15 Back Yard : Yard 13 Tree 1 Private 1     23     6005894.41752 2108909.3321599998 37.770996427668 -122.422976527055 (37.770996427668, -122.422976527055)
3840 3840 253546 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 14 Back Yard : Yard 13 Tree 1 DPW 2   09/27/2017 11:50:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
35375 35375 239209 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 14 Back Yard : Yard 13 Tree 1 Private 1     2     6005896.875990001 2108918.25042 37.7710210537973 -122.42296865708299 (37.7710210537973, -122.422968657083)
38396 38396 195968 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 14 Back Yard : Yard 13 Tree 1 Private 1     7     6015437.03514 2100327.8138099997 37.747967264084295 -122.389368677829 (37.7479672640843, -122.389368677829)
38814 38814 221775 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 21 Addison St 14 Back Yard : Yard 13 Tree 1 Private 1     10 Width 3ft   6003667.46569 2096848.61536 37.737754634878 -122.429819221204 (37.737754634878, -122.429819221204)
54971 54971 249878 Undocumented 2 Cedrus deodara :: Deodar Cedar 129 230 Greenwich St 14 Back Yard : Yard 13 Tree 1 Private 1     23 Width 0ft   6011550.21069 2120457.44752 37.803022344253705 -122.40422576851299 (37.8030223442537, -122.404225768513)
73581 73581 191844 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1501 Davidson Ave 14 Back Yard : Yard 13 Tree 1 Private 1     27     6015247.82087 2099125.91751 37.7446566150196 -122.38993903417 (37.7446566150196, -122.38993903417)
3832 3832 253545 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1000 Cayuga Ave 13 Back Yard : Yard 13 Tree 1 DPW 2   09/27/2017 11:58:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
33201 33201 195967 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 13 Back Yard : Yard 13 Tree 1 Private 1     5     6015456.783980001 2100328.64296 37.747970635647 -122.389300444473 (37.747970635647, -122.389300444473)
51644 51644 249877 Undocumented 2 Magnolia x soulangiana :: Saucer Magnolia 92 230 Greenwich St 13 Back Yard : Yard 13 Tree 1 Private 1     39 Width 0ft   6011569.83125 2120441.49442 37.802979637259 -122.404156747344 (37.802979637259, -122.404156747344)
162015 162015 245786 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 13 Back Yard : Yard 13 Tree 1 Private 1     2 Width 3ft   6003641.8158599995 2096850.294 37.73775779149221 -122.429908024732 (37.7377577914922, -122.429908024732)
170487 170487 239210 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 13 Back Yard : Yard 13 Tree 1 Private 1     3     6005891.00584 2108925.69957 37.771041176138795 -122.422989491673 (37.7710411761388, -122.422989491673)
3902 3902 253544 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 12 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 02:38:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
24155 24155 249927 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 358 Greenwich St 12 Back Yard : Yard 13 Tree 1 Private 1     31 Width 0ft   6011132.35015 2120388.99651 37.8028110368738 -122.40566696715099 (37.8028110368738, -122.405666967151)
38334 38334 195966 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 12 Back Yard : Yard 13 Tree 1 Private 1     6     6015475.98989 2100328.78152 37.7479720808553 -122.389234040342 (37.7479720808553, -122.389234040342)
43026 43026 245785 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 12 Back Yard : Yard 13 Tree 1 Private 1     2 Width 4ft   6003634.59217 2096849.8681700001 37.7377562131711 -122.42993297014401 (37.7377562131711, -122.429932970144)
47640 47640 249876 Undocumented 2 Calocedrus decurrens :: Incense Cedar 177 230 Greenwich St 12 Back Yard : Yard 13 Tree 1 Private 1     29 Width 0ft   6011590.626680001 2120460.04582 37.8030317367952 -122.40408609031 (37.8030317367952, -122.40408609031)
128270 128270 92481 Permitted Site 1 Tree(s) :: 17 155 Greenwich St 12 Back Yard : Yard 13 Tree 1 Private 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
183112 183112 233517 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 100 Hwy 101 Southbound 12 Back Yard : Yard 13 Tree 1 Private 1     7     6005882.82166 2108930.28485 37.771053304398606 -122.42301812700501 (37.7710533043986, -122.423018127005)
3900 3900 253543 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 11 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 02:35:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
27650 27650 239211 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 11 Back Yard : Yard 13 Tree 1 Private 1     5     6005882.93751 2108938.64172 37.7710762568972 -122.42301832034501 (37.7710762568972, -122.423018320345)
137968 137968 195965 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 11 Back Yard : Yard 13 Tree 1 Private 1     8     6015497.16873 2100330.63483 37.747978343742794 -122.389160933554 (37.7479783437428, -122.389160933554)
145573 145573 92485 Permitted Site 1 Tree(s) :: 17 155 Greenwich St 11 Back Yard : Yard 13 Tree 1 Private 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
171246 171246 249875 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 230 Greenwich St 11 Back Yard : Yard 13 Tree 1 Private 1     19 Width 0ft   6011656.00691 2120465.5569700003 37.803050521838706 -122.40386022737499 (37.8030505218387, -122.403860227375)
172795 172795 191843 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1501 Davidson Ave 11 Back Yard : Yard 13 Tree 1 Private 1     20     6015141.47385 2099207.7707599998 37.7448754686187 -122.390312482158 (37.7448754686187, -122.390312482158)
176393 176393 249926 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 358 Greenwich St 11 Back Yard : Yard 13 Tree 1 Private 1     24 Width 0ft   6011142.49576 2120408.96257 37.8028664261111 -122.405633265077 (37.8028664261111, -122.405633265077)
176501 176501 245784 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 11 Back Yard : Yard 13 Tree 1 Private 1     4 Width 4ft   6003626.79774 2096849.74169 37.7377554244689 -122.429959910226 (37.7377554244689, -122.429959910226)
3896 3896 253542 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 10 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 02:42:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
32290 32290 239198 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 10 Back Yard : Yard 13 Tree 1 Private 1     3     6005918.91365 2109064.99496 37.771425222619705 -122.42290285910299 (37.7714252226197, -122.422902859103)
41322 41322 211727 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 41 Ralston St 10 Back Yard : Yard 13 Tree 1 Private 1     6     5992176.51123 2088212.22362 37.7133838194885 -122.468920334526 (37.7133838194885, -122.468920334526)
65985 65985 195964 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 10 Back Yard : Yard 13 Tree 1 Private 1     8     6015516.57214 2100331.8217700003 37.7479826784534 -122.38909391965001 (37.7479826784534, -122.38909391965)
104140 104140 92480 Permitted Site 1 Tree(s) :: 17 155 Greenwich St 10 Back Yard : Yard 13 Tree 1 Private 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
133552 133552 249874 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 230 Greenwich St 10 Back Yard : Yard 13 Tree 1 Private 1     21 Width 0ft   6011664.0982800005 2120483.35155 37.803099833442296 -122.403833479743 (37.8030998334423, -122.403833479743)
160995 160995 245783 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 10 Back Yard : Yard 13 Tree 1 Private 1     6 Width 8ft   6003607.92987 2096849.5108400001 37.73775372205 -122.430025129081 (37.73775372205, -122.430025129081)
176394 176394 249925 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 358 Greenwich St 10 Back Yard : Yard 13 Tree 1 Private 1     14 Width 0ft   6011155.36985 2120409.86411 37.802869621408796 -122.40558877741002 (37.8028696214088, -122.40558877741)
179625 179625 233518 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 100 Hwy 101 Southbound 10 Back Yard : Yard 13 Tree 1 Private 1     7     6005873.996719999 2108944.2877 37.7710912548825 -122.42304964824301 (37.7710912548825, -122.423049648243)
180957 180957 191842 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1501 Davidson Ave 10 Back Yard : Yard 13 Tree 1 Private 1     15     6015112.514169999 2099226.0983 37.744924185813396 -122.390413900506 (37.7449241858134, -122.390413900506)
3899 3899 253541 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 9 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 03:59:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
52205 52205 249810 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 258 Chestnut St 9 Back Yard : Yard 13 Tree 1 Private 1     5 Width 0ft   6010696.08755 2121019.21593 37.804517058874396 -122.407221117962 (37.8045170588744, -122.407221117962)
59360 59360 207117 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 41 Ralston St 9 Back Yard : Yard 13 Tree 1 Private 1     19     5992170.67066 2088214.0686700002 37.7133885481037 -122.46894065558399 (37.7133885481037, -122.468940655584)
63607 63607 191841 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1501 Davidson Ave 9 Back Yard : Yard 13 Tree 1 Private 1     23     6015067.74656 2099262.4877299997 37.7450216201491 -122.39057124226801 (37.7450216201491, -122.390571242268)
74090 74090 195963 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 9 Back Yard : Yard 13 Tree 1 Private 1     8     6015537.22246 2100333.68578 37.7479889413373 -122.389022641203 (37.7479889413373, -122.389022641203)
131807 131807 249873 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 230 Greenwich St 9 Back Yard : Yard 13 Tree 1 Private 1     26 Width 0ft   6011670.78297 2120474.23594 37.8030751776447 -122.403809705266 (37.8030751776447, -122.403809705266)
145164 145164 116308 Significant Tree 6 Cedrus deodara :: Deodar Cedar 129 699X DETROIT ST 9 Back Yard : Yard 13 Tree 1 Private 1       3x20   5999400.0 2095202.0 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893)
152126 152126 239212 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 9 Back Yard : Yard 13 Tree 1 Private 1     6     6005873.5433 2108954.58543 37.7711195043932 -122.42305194869301 (37.7711195043932, -122.423051948693)
156630 156630 249923 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 358 Greenwich St 9 Back Yard : Yard 13 Tree 1 Private 1     33 Width 0ft   6011163.06331 2120405.05222 37.8028568393309 -122.40556181483801 (37.8028568393309, -122.405561814838)
164753 164753 207116 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 47 Ralston St 9 Back Yard : Yard 13 Tree 1 Private 1     8     5992178.8337 2088240.4151599999 37.7134613608383 -122.46891435762801 (37.7134613608383, -122.468914357628)
166869 166869 239197 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 9 Back Yard : Yard 13 Tree 1 Private 1     4     6005924.85036 2109052.04357 37.7713899961886 -122.42288140308001 (37.7713899961886, -122.42288140308)
3906 3906 253540 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 8 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 04:11:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
43212 43212 245782 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 8 Back Yard : Yard 13 Tree 1 Private 1     6 Width 8ft   6003599.488059999 2096849.28505 37.7377526239794 -122.43005430038299 (37.7377526239794, -122.430054300383)
60662 60662 207115 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 47 Ralston St 8 Back Yard : Yard 13 Tree 1 Private 1     8     5992168.43399 2088239.2563900002 37.7134575782774 -122.468950218099 (37.7134575782774, -122.468950218099)
62177 62177 195962 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 8 Back Yard : Yard 13 Tree 1 Private 1     9     6015556.6084199995 2100333.99599 37.7479908676843 -122.388955626422 (37.7479908676843, -122.388955626422)
71300 71300 191840 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1501 Davidson Ave 8 Back Yard : Yard 13 Tree 1 Private 1     16     6015034.2062 2099284.7294900003 37.7450808306162 -122.39068877377701 (37.7450808306162, -122.390688773777)
75553 75553 239196 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 8 Back Yard : Yard 13 Tree 1 Private 1     3     6005930.84591 2109041.9421200003 37.771362598325 -122.42285994612499 (37.771362598325, -122.422859946125)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 409.531ms · Data source: data.sfgov.org