Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 773 | 773 | 221437 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:48:00 AM | 1 | Width 3ft | 6005441.98545 | 2108105.3361400003 | 37.7687633076137 | -122.424484307027 | (37.7687633076137, -122.424484307027) | ||
| 1222 | 1222 | 119837 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 3111 | 3111 | 118355 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:48:00 AM | 3 | ||||||||
| 4359 | 4359 | 221446 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:45:00 AM | 1 | Width 3ft | 6005477.30623 | 2107402.8649 | 37.7668364840384 | -122.424312165974 | (37.7668364840384, -122.424312165974) | ||
| 4384 | 4384 | 221465 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:21:00 AM | 2 | Width 3ft | 6005511.348730001 | 2106807.4282299997 | 37.76520347889029 | -122.42415206777599 | (37.7652034788903, -122.424152067776) | ||
| 4419 | 4419 | 221477 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 05:29:00 AM | 1 | Width 3ft | 6005543.73868 | 2106251.90953 | 37.763679985054495 | -122.424000531101 | (37.7636799850545, -122.424000531101) | ||
| 4517 | 4517 | 221503 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:06:00 PM | 2 | Width 3ft | 6005610.53101 | 2105047.42068 | 37.7603765134773 | -122.423683871708 | (37.7603765134773, -122.423683871708) | ||
| 5113 | 5113 | 152421 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005642.99765 | 2104457.73967 | 37.7587592203909 | -122.42352966049 | (37.7587592203909, -122.42352966049) | |||
| 5494 | 5494 | 87738 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005444.64461 | 2121623.98788 | 37.8058823097966 | -122.425437295217 | (37.8058823097966, -122.425437295217) | ||
| 5633 | 5633 | 8583 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 6000590.222999999 | 2113406.0186 | 37.7830424571155 | -122.441646596602 | (37.7830424571155, -122.441646596602) | |||
| 6096 | 6096 | 8399 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6003960.687000001 | 2113944.6223 | 37.7847127843654 | -122.430024606782 | (37.7847127843654, -122.430024606782) | |||
| 8595 | 8595 | 28648 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003548.747 | 2114394.8281 | 37.7859255976047 | -122.43148193261601 | (37.7859255976047, -122.431481932616) | ||
| 8647 | 8647 | 8473 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 6001933.4192 | 2113657.2968 | 37.7838088404542 | -122.437017691332 | (37.7838088404542, -122.437017691332) | |||
| 8960 | 8960 | 8622 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2600 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999315.0497 | 2113216.8408 | 37.782450288182 | -122.44604454634701 | (37.782450288182, -122.446044546347) | |||
| 10228 | 10228 | 173922 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 11032 | 11032 | 24272 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001382.61488 | 2086464.9875900003 | 37.7091138905754 | -122.43697586956301 | (37.7091138905754, -122.436975869563) | |||
| 11290 | 11290 | 1302 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4000X Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991739.11571 | 2087020.66511 | 37.7100868068254 | -122.470345390352 | (37.7100868068254, -122.470345390352) | |||
| 13036 | 13036 | 112329 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 02:10:00 PM | 3 | 3x3 | 5998165.78515 | 2088385.61312 | 37.7142041252815 | -122.448231877823 | (37.7142041252815, -122.448231877823) | ||
| 14571 | 14571 | 6615 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016429.61259 | 2097949.5600400004 | 37.7414920473285 | -122.385770616219 | (37.7414920473285, -122.385770616219) | |||
| 15352 | 15352 | 97230 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 15x200 | 6016626.81073 | 2094919.21722 | 37.7331822459561 | -122.38487770274999 | (37.7331822459561, -122.38487770275) | |||
| 16318 | 16318 | 29651 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 1500X La Salle Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015684.3928 | 2096048.7707 | 37.7362316014874 | -122.388214728777 | (37.7362316014874, -122.388214728777) | ||
| 16768 | 16768 | 18555 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014626.04256 | 2095092.9200799998 | 37.733548332979105 | -122.39180709603201 | (37.7335483329791, -122.391807096032) | |||
| 17111 | 17111 | 29966 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991400.88182 | 2093544.5626 | 37.7279802659702 | -122.471989567778 | (37.7279802659702, -122.471989567778) | ||
| 17516 | 17516 | 16016 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4 | 6000925.306059999 | 2094658.03828 | 37.7315841533775 | -122.43914321141001 | (37.7315841533775, -122.43914321141) | |||
| 17725 | 17725 | 29321 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5994018.9916 | 2097886.0203400003 | 37.740051989006204 | -122.46325365505899 | (37.7400519890062, -122.463253655059) | ||
| 18437 | 18437 | 11778 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.6486 | 2091754.7927400002 | 37.723059276443294 | -122.472260973265 | (37.7230592764433, -122.472260973265) | ||
| 18548 | 18548 | 29266 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998997.2091 | 2100232.35941 | 37.7467800070095 | -122.446209824123 | (37.7467800070095, -122.446209824123) | ||
| 18820 | 18820 | 29289 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998035.9028 | 2099979.9539 | 37.7460320165688 | -122.44951572839099 | (37.7460320165688, -122.449515728391) | ||
| 19113 | 19113 | 4974 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200X Diamond Heights Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6000911.31432 | 2099444.9687099997 | 37.7447271470412 | -122.43953461434201 | (37.7447271470412, -122.439534614342) | |||
| 19203 | 19203 | 26914 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 10 Caine Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5997577.15723 | 2089606.82913 | 37.7175236335794 | -122.45035437405599 | (37.7175236335794, -122.450354374056) | |||
| 19542 | 19542 | 29962 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 400X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3x3 | 5991375.88875 | 2094170.02081 | 37.729696171533 | -122.472121539675 | (37.729696171533, -122.472121539675) | ||
| 19720 | 19720 | 8219 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992283.90112 | 2100578.3571900004 | 37.747344348682795 | -122.469448761774 | (37.7473443486828, -122.469448761774) | |||
| 20443 | 20443 | 16112 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999693.39114 | 2094677.85118 | 37.7315683792706 | -122.443403591302 | (37.7315683792706, -122.443403591302) | |||
| 20795 | 20795 | 29365 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992050.3612 | 2096514.70328 | 37.7361730907045 | -122.46996048768601 | (37.7361730907045, -122.469960487686) | ||
| 21212 | 21212 | 11673 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 700X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991295.1451900005 | 2092921.61878 | 37.7262636985024 | -122.47230970662399 | (37.7262636985024, -122.472309706624) | ||
| 21453 | 21453 | 25004 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6004910.30478 | 2105777.27345 | 37.762340964691504 | -122.42615759100599 | (37.7623409646915, -122.426157591006) | |||
| 21489 | 21489 | 29601 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991172.090009999 | 2091066.888 | 37.7211639453471 | -122.472599932234 | (37.7211639453471, -122.472599932234) | ||
| 21719 | 21719 | 29996 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005885.11752 | 2099395.68964 | 37.7448736601053 | -122.422332636749 | (37.7448736601053, -122.422332636749) | ||
| 21793 | 21793 | 29370 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/06/2005 12:00:00 AM | 3 | 3X3 | 6002650.152480001 | 2095274.05972 | 37.733373604614 | -122.433224085933 | (37.733373604614, -122.433224085933) | ||
| 21822 | 21822 | 18126 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 10 | 5992880.89673 | 2097291.14293 | 37.7383529745158 | -122.46714544600799 | (37.7383529745158, -122.467145446008) | |||
| 22227 | 22227 | 25067 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005110.57075 | 2102123.34784 | 37.7523194593995 | -122.425204931964 | (37.7523194593995, -122.425204931964) | |||
| 22465 | 22465 | 9099 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989192.0143 | 2112627.1655 | 37.780247936097396 | -122.481022231507 | (37.7802479360974, -122.481022231507) | |||
| 22696 | 22696 | 9182 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987952.9231 | 2112592.5712 | 37.780080843030795 | -122.485306225563 | (37.7800808430308, -122.485306225563) | |||
| 29724 | 29724 | 207328 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 400x Marietta Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5999485.75789 | 2097034.69989 | 37.738027887567796 | -122.444290723035 | (37.7380278875678, -122.444290723035) | |||
| 34779 | 34779 | 180046 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000892.57758 | 2090835.74953 | 37.72108716032729 | -122.438982533116 | (37.7210871603273, -122.438982533116) | |||
| 38671 | 38671 | 180422 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003342.53075 | 2094283.93013 | 37.7306941860739 | -122.43075970881901 | (37.7306941860739, -122.430759708819) | |||
| 42007 | 42007 | 180098 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200x Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 5999719.616830001 | 2089501.32474 | 37.7173563255146 | -122.44294132361 | (37.7173563255146, -122.44294132361) | |||
| 44505 | 44505 | 181226 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012120.3534699995 | 2087937.9432299999 | 37.713762809074 | -122.39996775739901 | (37.713762809074, -122.399967757399) | |||
| 45667 | 45667 | 222798 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6010362.72058 | 2100700.08083 | 37.7487067927886 | -122.406941762453 | (37.7487067927886, -122.406941762453) | |||
| 46886 | 46886 | 175915 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 350x Winding Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6000968.48443 | 2086648.8804900001 | 37.7095952724697 | -122.43842033004299 | (37.7095952724697, -122.438420330043) | |||
| 48782 | 48782 | 181251 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011120.84177 | 2087163.22682 | 37.7115798172183 | -122.40336798793999 | (37.7115798172183, -122.40336798794) | |||
| 51488 | 51488 | 205597 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 600x Laguna Honda Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5995496.70265 | 2099913.2188 | 37.7457031929561 | -122.45829106020001 | (37.7457031929561, -122.4582910602) | |||
| 52871 | 52871 | 113504 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | 3x3 | 6011150.15882 | 2090569.3770299999 | 37.7209340525347 | -122.403506146294 | (37.7209340525347, -122.403506146294) | |||
| 61181 | 61181 | 211251 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5993753.32003 | 2100266.28903 | 37.746572298679794 | -122.464345002125 | (37.7465722986798, -122.464345002125) | |||
| 61882 | 61882 | 211236 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 5ft | 5993665.945669999 | 2100370.25602 | 37.7468527288888 | -122.464654679171 | (37.7468527288888, -122.464654679171) | |||
| 66900 | 66900 | 221490 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005576.38505 | 2105666.63585 | 37.7620748049423 | -122.423845997918 | (37.7620748049423, -122.423845997918) | |||
| 67382 | 67382 | 244287 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005585.9927 | 2110033.3819999998 | 37.7740653890161 | -122.424123330561 | (37.7740653890161, -122.424123330561) | |||
| 69750 | 69750 | 244330 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005665.121 | 2109878.6077 | 37.7736448835433 | -122.42383860414199 | (37.7736448835433, -122.423838604142) | |||
| 70249 | 70249 | 176386 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 10x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6011666.66331 | 2090722.9963200002 | 37.7213846965192 | -122.40173152668501 | (37.7213846965192, -122.401731526685) | |||
| 72173 | 72173 | 176321 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6009491.13352 | 2090035.22052 | 37.7193745624679 | -122.409203250746 | (37.7193745624679, -122.409203250746) | |||
| 73396 | 73396 | 244466 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005631.2066 | 2109707.3231 | 37.7731726627699 | -122.423943736898 | (37.7731726627699, -122.423943736898) | |||
| 73902 | 73902 | 200534 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6016166.8048 | 2095673.2359 | 37.7352271762292 | -122.386520639457 | (37.7352271762292, -122.386520639457) | |||
| 76412 | 76412 | 244404 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005594.3943 | 2110164.7531 | 37.7744265766299 | -122.424103612435 | (37.7744265766299, -122.424103612435) | |||
| 77480 | 77480 | 8344 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/08/1994 12:00:00 AM | 12 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | ||
| 78636 | 78636 | 28030 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 10 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014322.16601 | 2117689.8700099997 | 37.795577730351205 | -122.39443938464899 | (37.7955777303512, -122.394439384649) | ||
| 79209 | 79209 | 30065 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 510X Brotherhood Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642523999 | 2087870.68608 | 37.7124705349467 | -122.46742958077101 | (37.7124705349467, -122.467429580771) | ||
| 79235 | 79235 | 6115 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 80104 | 80104 | 25796 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X The Embarcadero | 10 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012816.959009999 | 2119901.25001 | 37.80156586089179 | -122.399803052325 | (37.8015658608918, -122.399803052325) | ||
| 80123 | 80123 | 30074 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
| 80924 | 80924 | 25025 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
| 81207 | 81207 | 8745 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3300 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | |||
| 81226 | 81226 | 110627 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 05:29:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
| 81328 | 81328 | 25745 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 10 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | ||
| 81389 | 81389 | 120633 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1500 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004538.0 | 2114050.0 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | |||||
| 82073 | 82073 | 8933 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4600 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5992801.3833857 | 2112786.477091 | 37.7808945155903 | -122.468547465827 | (37.7808945155903, -122.468547465827) | |||
| 83194 | 83194 | 87400 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | |||
| 84021 | 84021 | 30019 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 710X San Jose Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005718.76576524 | 2099005.5772577 | 37.7437931149581 | -122.42288013057501 | (37.7437931149581, -122.422880130575) | ||
| 84807 | 84807 | 6518 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017386.15401 | 2097259.19601 | 37.739649331573794 | -122.38241516995899 | (37.7396493315738, -122.382415169959) | |||
| 85315 | 85315 | 119826 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 87518 | 87518 | 122881 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 87613 | 87613 | 8885 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4200 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.46426453234699 | (37.7810917943038, -122.464264532347) | |||
| 87630 | 87630 | 119692 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 88140 | 88140 | 2149 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Bosworth St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 88691 | 88691 | 18137 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
| 89892 | 89892 | 30039 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.47158589282199 | (37.7138086207581, -122.471585892822) | |||
| 89949 | 89949 | 16367 | DPW Maintained 3 | Cercis occidentalis :: Western Redbud 246 | 1300X Montgomery St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 8 | 6011500.916866099 | 2119743.0722499 | 37.8010580895294 | -122.404346040012 | (37.8010580895294, -122.404346040012) | |||
| 91003 | 91003 | 29344 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1500X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992236.5627249 | 2096694.9403025003 | 37.7366787380665 | -122.469329833584 | (37.7366787380665, -122.469329833584) | ||
| 92251 | 92251 | 114828 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 95066 | 95066 | 112245 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 5999054.92129 | 2088906.8460099997 | 37.715686103277505 | -122.44519614164 | (37.7156861032775, -122.44519614164) | |||||
| 95160 | 95160 | 24983 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 292 Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
| 95182 | 95182 | 16377 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1400X Montgomery St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | |||
| 95726 | 95726 | 23598 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 200X Vasquez Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
| 96137 | 96137 | 119790 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 96581 | 96581 | 99127 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 10 | Median : Cutout 11 | Tree 1 | Private 1 | 48 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 97179 | 97179 | 24969 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 198 Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6004804.6555297 | 2107199.7616194002 | 37.766240805753604 | -122.426624291348 | (37.7662408057536, -122.426624291348) | |||
| 99734 | 99734 | 4993 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 99950 | 99950 | 96227 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 14X CAINE AVE | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/24/2011 12:00:00 AM | 3 | 6x300 | 5997641.2 | 2089761.8 | 37.7179528127364 | -122.450144172407 | (37.7179528127364, -122.450144172407) | ||
| 99951 | 99951 | 119755 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 106x Octavia St Frontage West | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 100149 | 100149 | 29637 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 102576 | 102576 | 110781 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:26:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) |
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");