Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 153689 | 153689 | 135873 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1002 Vallejo St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6008628.64799 | 2118672.57502 | 37.7979578472257 | -122.414209576908 | (37.7979578472257, -122.414209576908) | ||||
| 10146 | 10146 | 173882 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 201x Howth St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997459.0 | 2090748.0 | 37.7206502603184 | -122.450845024895 | (37.7206502603184, -122.450845024895) | |||||
| 1772 | 1772 | 173895 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 326x Dellbrook Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 3x3 | 5997295.0 | 2102064.0 | 37.7517118802849 | -122.452228008054 | (37.7517118802849, -122.452228008054) | |||
| 10199 | 10199 | 173896 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 326x Dellbrook Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997295.0 | 2102064.0 | 37.7517118802849 | -122.452228008054 | (37.7517118802849, -122.452228008054) | ||||
| 10196 | 10196 | 173897 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 90x Knollview Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997593.0 | 2101480.0 | 37.7501254274205 | -122.451155378281 | (37.7501254274205, -122.451155378281) | ||||
| 10223 | 10223 | 173927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 240 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | |||||
| 35110 | 35110 | 176590 | Undocumented 2 | Juglans nigra :: Eastern black walnut 288 | 4103 Alemany Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | Width 10ft | 5991596.71486 | 2086796.0596 | 37.7094618598487 | -122.470821200944 | (37.7094618598487, -122.470821200944) | |||
| 13268 | 13268 | 187627 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 88 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | |||||
| 13301 | 13301 | 187651 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 175 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998689.0 | 2104063.0 | 37.7572803991188 | -122.447551270828 | (37.7572803991188, -122.447551270828) | |||||
| 13315 | 13315 | 187668 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 100x OGDEN AVE | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6007659.0 | 2096105.0 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | |||||
| 13321 | 13321 | 187670 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 230 Victoria St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5993274.0 | 2088748.0 | 37.7149182807441 | -122.465165952001 | (37.7149182807441, -122.465165952001) | ||||
| 30471 | 30471 | 188564 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Vermont St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | 6011131.87643 | 2106822.77201 | 37.7655613532939 | -122.404712987912 | (37.7655613532939, -122.404712987912) | ||||
| 147650 | 147650 | 189462 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6014132.345380001 | 2095385.42746 | 37.7343240791916 | -122.393534426582 | (37.7343240791916, -122.393534426582) | ||||
| 74942 | 74942 | 189463 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 22 | 6014124.78069 | 2095373.74732 | 37.7342915875929 | -122.393559763171 | (37.7342915875929, -122.393559763171) | ||||
| 134977 | 134977 | 189464 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6014119.82993 | 2095366.8489 | 37.7342723708559 | -122.39357639702699 | (37.7342723708559, -122.393576397027) | ||||
| 182994 | 182994 | 191809 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | 6011127.66334 | 2106895.1514 | 37.76575985524929 | -122.404732656101 | (37.7657598552493, -122.404732656101) | ||||
| 183262 | 183262 | 191810 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6011130.07486 | 2106859.15267 | 37.7656611456652 | -122.40472178059099 | (37.7656611456652, -122.404721780591) | ||||
| 73889 | 73889 | 191811 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | 6011131.47947 | 2106831.70462 | 37.76558585803421 | -122.40471498982299 | (37.7655858580342, -122.404714989823) | ||||
| 172941 | 172941 | 191812 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 6011136.684719999 | 2106709.3643099996 | 37.765250230128004 | -122.404688372578 | (37.765250230128, -122.404688372578) | ||||
| 60639 | 60639 | 191813 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 6011137.70759 | 2106686.95849 | 37.7651887659782 | -122.40468325722901 | (37.7651887659782, -122.404683257229) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 158786 | 158786 | 195955 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015700.85592 | 2100342.37267 | 37.7480218628289 | -122.38845740468399 | (37.7480218628289, -122.388457404684) | ||||
| 74084 | 74084 | 195956 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | 6015682.424790001 | 2100340.57249 | 37.748015898531605 | -122.388521013727 | (37.7480158985316, -122.388521013727) | ||||
| 60765 | 60765 | 195957 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 6015667.37966 | 2100340.53223 | 37.7480149542209 | -122.38857303683399 | (37.7480149542209, -122.388573036834) | ||||
| 31601 | 31601 | 195958 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015649.240619999 | 2100340.8983400003 | 37.7480149542299 | -122.388635787013 | (37.7480149542299, -122.388635787013) | ||||
| 179584 | 179584 | 195959 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015616.60441 | 2100338.74984 | 37.7480072461368 | -122.388748492749 | (37.7480072461368, -122.388748492749) | ||||
| 46092 | 46092 | 195960 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015597.7328 | 2100337.72732 | 37.748003392560896 | -122.38881367921302 | (37.7480033925609, -122.388813679213) | ||||
| 175233 | 175233 | 195961 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015577.60391 | 2100335.50195 | 37.7479961664858 | -122.388883129368 | (37.7479961664858, -122.388883129368) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 186211 | 186211 | 197763 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1405 Minnesota St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6015410.29997 | 2101920.42662 | 37.7523387624307 | -122.389572339186 | (37.7523387624307, -122.389572339186) | ||||
| 155707 | 155707 | 203875 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992168.26739 | 2088231.33888 | 37.7134358290799 | -122.468950218092 | (37.7134358290799, -122.468950218092) | ||||
| 161892 | 161892 | 203876 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 5992169.18145 | 2088225.46502 | 37.7134197536892 | -122.468946631609 | (37.7134197536892, -122.468946631609) | ||||
| 157520 | 157520 | 203877 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Ralston St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992177.10886 | 2088222.03993 | 37.7134108072361 | -122.468918982843 | (37.7134108072361, -122.468918982843) | ||||
| 184062 | 184062 | 204381 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 47 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992175.93878 | 2088248.61457 | 37.7134837071825 | -122.46892495972901 | (37.7134837071825, -122.468924959729) | ||||
| 154924 | 154924 | 204382 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 41 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992173.48186 | 2088232.60675 | 37.7134396116198 | -122.46893228741999 | (37.7134396116198, -122.46893228742) | ||||
| 179961 | 179961 | 204383 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 41 Ralston St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5992172.93339 | 2088222.9751099998 | 37.7134131337717 | -122.46893348261699 | (37.7134131337717, -122.468933482617) | ||||
| 186880 | 186880 | 206444 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 75 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992169.96835 | 2088350.8654599998 | 37.71376411849379 | -122.46895303206301 | (37.7137641184938, -122.468953032063) | ||||
| 167246 | 167246 | 206445 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 53 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 5992171.9093 | 2088272.93373 | 37.7135502489179 | -122.46894065561001 | (37.7135502489179, -122.46894065561) | ||||
| 150424 | 150424 | 206446 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 53 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 5992168.00552 | 2088268.19461 | 37.7135370108901 | -122.468953803676 | (37.7135370108901, -122.468953803676) | ||||
| 188401 | 188401 | 207079 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 59 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5992173.18035 | 2088300.4585900002 | 37.7136258989769 | -122.46893826428699 | (37.7136258989769, -122.468938264287) | ||||
| 136701 | 136701 | 207107 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 89 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | 5992169.5585900005 | 2088419.4087099999 | 37.7139522980308 | -122.46895943344299 | (37.7139522980308, -122.468959433443) | ||||
| 71643 | 71643 | 207108 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 89 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | 5992168.92954 | 2088415.8272900002 | 37.7139424279717 | -122.468961347182 | (37.7139424279717, -122.468961347182) | ||||
| 153486 | 153486 | 207109 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 75 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | 5992170.77084 | 2088338.0326 | 37.713728928924105 | -122.46894932506599 | (37.7137289289241, -122.468949325066) | ||||
| 162496 | 162496 | 207110 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992170.63195 | 2088310.84387 | 37.7136542672107 | -122.468947827707 | (37.7136542672107, -122.468947827707) | ||||
| 171720 | 171720 | 207111 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | 5992171.5605 | 2088305.6585 | 37.713640083085 | -122.468944241206 | (37.713640083085, -122.468944241206) | ||||
| 31147 | 31147 | 207112 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5992171.746719999 | 2088295.8735200001 | 37.7136132266511 | -122.46894288591899 | (37.7136132266511, -122.468942885919) | ||||
| 68946 | 68946 | 207113 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 53 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992170.39113 | 2088282.9530900002 | 37.7135776719473 | -122.468946631596 | (37.7135776719473, -122.468946631596) | ||||
| 188129 | 188129 | 207114 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 53 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992175.21623 | 2088282.1627599997 | 37.7135757806697 | -122.468929896991 | (37.7135757806697, -122.468929896991) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 177754 | 177754 | 209147 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 75 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | 5992171.618 | 2088327.33496 | 37.7136996047335 | -122.46894561897 | (37.7136996047335, -122.46894561897) | ||||
| 174819 | 174819 | 209181 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5994876.85162 | 2098459.48593 | 37.7416759667651 | -122.46032908762699 | (37.7416759667651, -122.460329087627) | |||
| 48281 | 48281 | 209182 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 3ft | 5994867.86795 | 2098472.15279 | 37.7417102300345 | -122.46036106750799 | (37.7417102300345, -122.460361067508) | |||
| 2864 | 2864 | 209183 | Undocumented 2 | Tree(s) :: 17 | 140 Kensington Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780524 | 5994862.40668 | 2098482.07156 | 37.741737150351 | -122.460380669142 | (37.741737150351, -122.460380669142) | |
| 48070 | 48070 | 209184 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 3ft | 5994856.4919300005 | 2098484.57238 | 37.7417436767315 | -122.460401301401 | (37.7417436767315, -122.460401301401) | |||
| 27119 | 27119 | 209185 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 3ft | 5994853.690119999 | 2098493.2474700003 | 37.741767335194105 | -122.460411617495 | (37.7417673351941, -122.460411617495) | |||
| 177691 | 177691 | 209186 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 3ft | 5994849.5459 | 2098494.81966 | 37.741771413634794 | -122.46042606063 | (37.7417714136348, -122.46042606063) | |||
| 182862 | 182862 | 209187 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 156 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 3ft | 5994832.7400400005 | 2098518.64338 | 37.7418358608449 | -122.460485895213 | (37.7418358608449, -122.460485895213) | |||
| 2887 | 2887 | 209188 | Undocumented 2 | Tree(s) :: 17 | 156 Kensington Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780524 | 5994823.818630001 | 2098534.27999 | 37.7418782818471 | -122.46051787510599 | (37.7418782818471, -122.460517875106) | |
| 189024 | 189024 | 209189 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 156 Kensington Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 3ft | 5994812.38667 | 2098544.02713 | 37.7419043873887 | -122.460558108972 | (37.7419043873887, -122.460558108972) | |||
| 47848 | 47848 | 209611 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 77 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | 5992168.85342 | 2088365.8404 | 37.7138051716457 | -122.468957974754 | (37.7138051716457, -122.468957974754) | ||||
| 38627 | 38627 | 210531 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 47 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992169.14182 | 2088256.46113 | 37.7135048592377 | -122.46894902289 | (37.7135048592377, -122.46894902289) | ||||
| 29851 | 29851 | 210532 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 47 Ralston St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 5992170.38695 | 2088246.7586700001 | 37.7134782905637 | -122.46894401367099 | (37.7134782905637, -122.468944013671) | ||||
| 147254 | 147254 | 211258 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 426 Los Palmos Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5997445.84853 | 2095752.3652400002 | 37.734390310651605 | -122.451251210378 | (37.7343903106516, -122.451251210378) | |||
| 175716 | 175716 | 211722 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 47 Ralston St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992176.846480001 | 2088244.58976 | 37.7134727084689 | -122.468921529709 | (37.7134727084689, -122.468921529709) | ||||
| 170319 | 170319 | 211723 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 47 Ralston St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992174.6999 | 2088241.1909400001 | 37.7134632521081 | -122.468928701793 | (37.7134632521081, -122.468928701793) | ||||
| 37767 | 37767 | 211724 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992178.335940001 | 2088233.1934099998 | 37.71344150289679 | -122.468915552827 | (37.7134415028968, -122.468915552827) | ||||
| 188904 | 188904 | 211725 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992180.34622 | 2088219.99909 | 37.7134053906231 | -122.468907645067 | (37.7134053906231, -122.468907645067) | ||||
| 180672 | 180672 | 211726 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992180.41529 | 2088216.9630599997 | 37.7133970584078 | -122.46890718553699 | (37.7133970584078, -122.468907185537) | ||||
| 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) | ||||
| 28538 | 28538 | 212784 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 739 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 3ft | 5998105.0801800005 | 2095806.61255 | 37.734576984727795 | -122.448975948078 | (37.7345769847278, -122.448975948078) | |||
| 68601 | 68601 | 212785 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 743 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 3ft | 5998104.46417 | 2095821.7845 | 37.734618608054795 | -122.448979170379 | (37.7346186080548, -122.448979170379) | |||
| 25761 | 25761 | 217537 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 89 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 5992163.635980001 | 2088434.33055 | 37.713992927605204 | -122.468980989298 | (37.7139929276052, -122.468980989298) | ||||
| 30020 | 30020 | 218148 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 5994122.86099 | 2090034.3755400002 | 37.7184992748049 | -122.462325196761 | (37.7184992748049, -122.462325196761) | ||||
| 176884 | 176884 | 218149 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5994121.0220800005 | 2090034.4141 | 37.7184992747921 | -122.462331555861 | (37.7184992747921, -122.462331555861) | ||||
| 61253 | 61253 | 218150 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5994126.47455 | 2090031.2465099997 | 37.7184908913149 | -122.46231247944999 | (37.7184908913149, -122.46231247945) | ||||
| 161920 | 161920 | 218151 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | 5994130.74614 | 2090030.24083 | 37.7184883759248 | -122.46229764153799 | (37.7184883759248, -122.462297641538) | ||||
| 149374 | 149374 | 218737 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998790.02414 | 2095935.97535 | 37.7349713329455 | -122.446617181062 | (37.7349713329455, -122.446617181062) | |||
| 43628 | 43628 | 218738 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998805.22806 | 2095928.00663 | 37.734950321189 | -122.446564042812 | (37.734950321189, -122.446564042812) |
JSON shape: default, array, newline-delimited
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");