Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2620 | 2620 | 23170 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 202X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006871.78386 | 2111296.65749 | 37.7776065535391 | -122.41976520271601 | (37.7776065535391, -122.419765202716) | |||
| 5451 | 5451 | 23407 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1748X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006159.63822 | 2116414.10982 | 37.791617675355795 | -122.422592496742 | (37.7916176753558, -122.422592496742) | |||
| 7149 | 7149 | 23486 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005800.3407 | 2119014.80575 | 37.7987382537111 | -122.424020688524 | (37.7987382537111, -122.424020688524) | |||
| 7447 | 7447 | 23391 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 9 | 6006253.0985199995 | 2115767.98121 | 37.789848839288 | -122.422223199151 | (37.789848839288, -122.422223199151) | ||
| 7904 | 7904 | 23169 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 202X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006882.10264 | 2111252.84384 | 37.777486833097896 | -122.419726396954 | (37.7774868330979, -122.419726396954) | |||
| 8048 | 8048 | 23233 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006624.19189 | 2113053.59601 | 37.782416729491 | -122.42074646829799 | (37.782416729491, -122.420746468298) | |||
| 8553 | 8553 | 23232 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006628.60579 | 2113016.72655 | 37.7823157437221 | -122.42072857987301 | (37.7823157437221, -122.420728579873) | |||
| 8649 | 8649 | 23408 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1748X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006154.759930001 | 2116452.2699700003 | 37.7917221783851 | -122.42261208848801 | (37.7917221783851, -122.422612088488) | |||
| 9682 | 9682 | 13402 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Marietta Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | 5x10 | 5999116.0 | 2097588.0 | 37.7395260150228 | -122.445608931545 | (37.7395260150228, -122.445608931545) | |||
| 9685 | 9685 | 111779 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 356 Marietta Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 5999368.0 | 2097504.0 | 37.7393097549515 | -122.44473159198601 | (37.7393097549515, -122.444731591986) | ||||
| 10926 | 10926 | 15989 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 236 Moncada Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35M | 5992398.75579 | 2093455.53191 | 37.7277935021904 | -122.468533444909 | (37.7277935021904, -122.468533444909) | |||
| 13311 | 13311 | 29591 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991298.8544 | 2091955.25413 | 37.7236105159064 | -122.47222647259899 | (37.7236105159064, -122.472226472599) | ||
| 16230 | 16230 | 11782 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991290.0959 | 2091855.3897900002 | 37.7233358062868 | -122.472249472731 | (37.7233358062868, -122.472249472731) | ||
| 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) | ||
| 17196 | 17196 | 11780 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991289.71415 | 2091805.7046599998 | 37.7231993611319 | -122.47224717228599 | (37.7231993611319, -122.472247172286) | ||
| 17538 | 17538 | 30052 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 5991303.9336 | 2092006.82804 | 37.723752419029005 | -122.4722126725 | (37.723752419029, -122.4722126725) | |||
| 17711 | 17711 | 29585 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991398.016530001 | 2093471.7437599998 | 37.7277801578055 | -122.47199416782101 | (37.7277801578055, -122.471994167821) | ||
| 17715 | 17715 | 16378 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Moraga St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 5991088.16435 | 2103840.65792 | 37.756232597572605 | -122.473821451692 | (37.7562325975726, -122.473821451692) | |||
| 17761 | 17761 | 11776 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991282.42505 | 2091712.4343599998 | 37.7229428421321 | -122.47226557329701 | (37.7229428421321, -122.472265573297) | ||
| 17868 | 17868 | 11672 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 710X Junipero Serra Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991310.6193982 | 2092985.7524279999 | 37.7264406890913 | -122.472260886614 | (37.7264406890913, -122.472260886614) | ||
| 17935 | 17935 | 29599 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Junipero Serra Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991176.65606 | 2091094.6598 | 37.7212404641514 | -122.472586172621 | (37.7212404641514, -122.472586172621) | ||
| 17949 | 17949 | 11779 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991286.49524 | 2091779.26927 | 37.723126589806704 | -122.47225637323 | (37.7231265898067, -122.47225637323) | ||
| 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) | ||
| 18870 | 18870 | 16690 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 950X Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/07/2014 11:22:00 AM | 3 | 8 | 5991053.49575 | 2103158.03284 | 37.7543562808184 | -122.473891546652 | (37.7543562808184, -122.473891546652) | ||
| 18901 | 18901 | 29590 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991297.67299 | 2091930.7639 | 37.723543203431504 | -122.47222877213301 | (37.7235432034315, -122.472228772133) | ||
| 18990 | 18990 | 16587 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 7X Noe St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3X3 | 6002822.0682 | 2108265.0608599996 | 37.7690535728051 | -122.433557813564 | (37.7690535728051, -122.433557813564) | |||
| 19341 | 19341 | 11783 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991294.00766 | 2091883.13578 | 37.7234122162896 | -122.472237972213 | (37.7234122162896, -122.472237972213) | ||
| 19957 | 19957 | 13396 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 5 | 5999058.18381 | 2097687.6567700002 | 37.7397963477092 | -122.44581599931999 | (37.7397963477092, -122.44581599932) | |||
| 19985 | 19985 | 29967 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Junipero Serra Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991402.13289 | 2093572.36272 | 37.7280566705545 | -122.471987268219 | (37.7280566705545, -122.471987268219) | ||
| 20071 | 20071 | 99485 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Miramar Ave | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | |||
| 20180 | 20180 | 11683 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Junipero Serra Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991304.64081 | 2092852.6411099997 | 37.7260748525524 | -122.47227185508301 | (37.7260748525524, -122.472271855083) | ||
| 20236 | 20236 | 29626 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Junipero Serra Blvd | 35 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991174.60245 | 2090776.1353200001 | 37.720365755664794 | -122.47257006037901 | (37.7203657556648, -122.472570060379) | ||
| 20304 | 20304 | 29965 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Junipero Serra Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 20 | 3x3 | 5991402.31851 | 2093518.0307 | 37.727907499130204 | -122.471982668166 | (37.7279074991302, -122.471982668166) | ||
| 20444 | 20444 | 29975 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Junipero Serra Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991414.71879 | 2093790.73319 | 37.72865698961311 | -122.471959668 | (37.7286569896131, -122.471959668) | ||
| 20515 | 20515 | 29969 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991404.41199 | 2093617.36709 | 37.728180373200495 | -122.471982668172 | (37.7281803732005, -122.471982668172) | ||
| 20900 | 20900 | 11781 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991290.20273 | 2091828.8846200001 | 37.7232630358375 | -122.472247172271 | (37.7232630358375, -122.472247172271) | ||
| 21009 | 21009 | 11768 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991277.20617 | 2091654.2371 | 37.7227827448208 | -122.472279373401 | (37.7227827448208, -122.472279373401) | ||
| 21040 | 21040 | 16351 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4-HOA | 5993490.85605 | 2095190.6948799998 | 37.7326208567505 | -122.464884023402 | (37.7326208567505, -122.464884023402) | |||
| 21262 | 21262 | 11775 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991281.15985 | 2091683.9699900001 | 37.722864612795 | -122.47226787285801 | (37.722864612795, -122.472267872858) | ||
| 21308 | 21308 | 16353 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 4-HOA | 5993459.40286 | 2095225.9506299999 | 37.7327158467563 | -122.464995323497 | (37.7327158467563, -122.464995323497) | |||
| 21730 | 21730 | 16356 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 4-HOA | 5993377.89298 | 2095299.30224 | 37.7329125518562 | -122.46528244733 | (37.7329125518562, -122.46528244733) | |||
| 21780 | 21780 | 16352 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 4-HOA | 5993475.48003 | 2095210.28877 | 37.7326737701714 | -122.46493860413099 | (37.7326737701714, -122.464938604131) | |||
| 21807 | 21807 | 16355 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 4-HOA | 5993419.93647 | 2095261.019 | 37.732809860079996 | -122.46513431370501 | (37.73280986008, -122.465134313705) | |||
| 21945 | 21945 | 16357 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500X Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 4-HOA | 5993334.84717 | 2095340.24029 | 37.7330224750874 | -122.465434239406 | (37.7330224750874, -122.465434239406) | |||
| 22027 | 22027 | 29592 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3X3 | 5991300.07797 | 2091981.73158 | 37.723683287234 | -122.472224172111 | (37.723683287234, -122.472224172111) | |||
| 22120 | 22120 | 11777 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991284.187940001 | 2091732.93739 | 37.7229992404026 | -122.472260973267 | (37.7229992404026, -122.472260973267) | ||
| 22280 | 22280 | 16692 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 950X Noriega St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/25/2016 08:08:00 AM | 3 | 8 | 5990985.786309999 | 2103156.72144 | 37.7543487579916 | -122.474125605135 | (37.7543487579916, -122.474125605135) | ||
| 22414 | 22414 | 9013 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5317 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 8M | 5990485.6581 | 2112681.4706 | 37.7804721580667 | -122.47655093756501 | (37.7804721580667, -122.476550937565) | ||
| 22482 | 22482 | 9050 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5500 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989756.3032 | 2112653.5115 | 37.7803530611008 | -122.47907204579799 | (37.7803530611008, -122.479072045798) | |||
| 30424 | 30424 | 205111 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 49 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991346.44389 | 2092729.4529400002 | 37.725739027717204 | -122.472118370494 | (37.7257390277172, -122.472118370494) | |||
| 31200 | 31200 | 205107 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5991336.964 | 2092532.2101 | 37.7251968993055 | -122.472136770613 | (37.7251968993055, -122.472136770613) | |||
| 31292 | 31292 | 205114 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5991407.36099 | 2093694.15878 | 37.7283913946494 | -122.471978068129 | (37.7283913946494, -122.471978068129) | |||
| 31562 | 31562 | 212298 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991179.120709999 | 2090094.55389 | 37.7184945623549 | -122.47250477768699 | (37.7184945623549, -122.472504777687) | |||
| 31596 | 31596 | 205081 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 5991210.7499 | 2090584.88401 | 37.7198427189488 | -122.47243117628099 | (37.7198427189488, -122.472431176281) | |||
| 31895 | 31895 | 206303 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Junipero Serra Blvd | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991439.20179 | 2094163.2193200001 | 37.7296811600564 | -122.47190216624901 | (37.7296811600564, -122.471902166249) | |||
| 32028 | 32028 | 212310 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 5991202.259869999 | 2090434.6504900001 | 37.7194297232904 | -122.472449576395 | (37.7194297232904, -122.472449576395) | |||
| 36236 | 36236 | 205097 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991311.65126 | 2092183.57203 | 37.7242381608387 | -122.47219887147499 | (37.7242381608387, -122.472198871475) | |||
| 37920 | 37920 | 205095 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991309.74373 | 2092124.64335 | 37.724076246906705 | -122.472201171954 | (37.7240762469067, -122.472201171954) | |||
| 38677 | 38677 | 212161 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Marietta Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 5ft | 5999206.26812 | 2097588.84406 | 37.7395334857736 | -122.445296885446 | (37.7395334857736, -122.445296885446) | |||
| 39182 | 39182 | 205077 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5991206.77223 | 2090490.8774299999 | 37.719584369801396 | -122.47243807587601 | (37.7195843698014, -122.472438075876) | |||
| 41461 | 41461 | 212306 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991196.13313 | 2090333.39999 | 37.719151359714395 | -122.472463376508 | (37.7191513597144, -122.472463376508) | |||
| 42384 | 42384 | 212160 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Marietta Dr | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 5ft | 5999181.20972 | 2097594.9111099998 | 37.7395487140123 | -122.44538396231 | (37.7395487140123, -122.44538396231) | |||
| 42645 | 42645 | 176013 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6010939.71676 | 2090487.4301 | 37.7206972862266 | -122.40422782077101 | (37.7206972862266, -122.404227820771) | |||
| 43527 | 43527 | 205098 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991316.70247 | 2092233.8206900002 | 37.724376423516105 | -122.472185071407 | (37.7243764235161, -122.472185071407) | |||
| 44624 | 44624 | 205088 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 5991229.30633 | 2090865.43732 | 37.7206141232198 | -122.47238747550301 | (37.7206141232198, -122.472387475503) | |||
| 45530 | 45530 | 206423 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 400x Marietta Dr | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 3ft | 5999166.42001 | 2097010.61151 | 37.737943522178504 | -122.445393096728 | (37.7379435221785, -122.445393096728) | |||
| 47528 | 47528 | 205105 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 39 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991330.58276 | 2092481.99012 | 37.7250586384304 | -122.472155170739 | (37.7250586384304, -122.472155170739) | |||
| 48363 | 48363 | 205112 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 50 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5991349.718230001 | 2092758.5362599997 | 37.7258190727658 | -122.47210917039699 | (37.7258190727658, -122.472109170397) | |||
| 51690 | 51690 | 251039 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5400x Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5990159.2899 | 2112663.7273 | 37.780404505362 | -122.47767868930201 | (37.780404505362, -122.477678689302) | |||
| 52489 | 52489 | 212303 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5991192.118419999 | 2090269.21075 | 37.7189748794765 | -122.47247257657601 | (37.7189748794765, -122.472472576576) | |||
| 52662 | 52662 | 205115 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5991409.19346 | 2093717.97139 | 37.728456884165 | -122.471973468125 | (37.728456884165, -122.471973468125) | |||
| 55512 | 55512 | 206300 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Junipero Serra Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991425.03969 | 2093964.76062 | 37.7291354226469 | -122.471936666969 | (37.7291354226469, -122.471936666969) | |||
| 55711 | 55711 | 205076 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5991204.8696099995 | 2090463.7504 | 37.7195097755318 | -122.472442675902 | (37.7195097755318, -122.472442675902) | |||
| 56441 | 56441 | 205091 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991304.49196 | 2092033.3191900002 | 37.7238251894741 | -122.472212672491 | (37.7238251894741, -122.472212672491) | |||
| 58519 | 58519 | 212305 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991194.3003 | 2090309.58448 | 37.7190858620976 | -122.47246797653901 | (37.7190858620976, -122.472467976539) | |||
| 60017 | 60017 | 176014 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Mansell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | Width 0ft | 6010647.65151 | 2090407.8799299998 | 37.7204625334973 | -122.405231805915 | (37.7204625334973, -122.405231805915) | |||
| 61723 | 61723 | 205092 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991305.54801 | 2092051.8490000002 | 37.723876128855 | -122.472210372006 | (37.723876128855, -122.472210372006) | |||
| 62175 | 62175 | 212292 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5991164.37326 | 2089829.54432 | 37.7177660575462 | -122.472536442798 | (37.7177660575462, -122.472536442798) | |||
| 65755 | 65755 | 205087 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 40 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991229.32936 | 2090834.95737 | 37.7205304341251 | -122.47238517504499 | (37.7205304341251, -122.472385175045) | |||
| 66048 | 66048 | 205106 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 40 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5991333.82922 | 2092509.74916 | 37.7251350457334 | -122.47214597065901 | (37.7251350457334, -122.472145970659) | |||
| 66442 | 66442 | 212308 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991201.47803 | 2090397.56088 | 37.7193278390954 | -122.47244957640801 | (37.7193278390954, -122.472449576408) | |||
| 67053 | 67053 | 212297 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991177.8274300005 | 2090064.7629799999 | 37.7184126889791 | -122.47250707726002 | (37.7184126889791, -122.47250707726) | |||
| 67638 | 67638 | 205084 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991220.51447 | 2090732.43963 | 37.720248435491904 | -122.472408175222 | (37.7202484354919, -122.472408175222) | |||
| 67761 | 67761 | 206306 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Junipero Serra Blvd | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991444.74092 | 2094236.6421299998 | 37.7298830812226 | -122.471888366154 | (37.7298830812226, -122.471888366154) | |||
| 68407 | 68407 | 212307 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5991200.212719999 | 2090369.09522 | 37.7192496061609 | -122.47245187595 | (37.7192496061609, -122.47245187595) | |||
| 68941 | 68941 | 205108 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 5991339.84346 | 2092605.6938200002 | 37.7253988339751 | -122.472132170572 | (37.7253988339751, -122.472132170572) | |||
| 69407 | 69407 | 205083 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 35 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5991217.1837 | 2090700.70485 | 37.720161106826 | -122.472417376171 | (37.720161106826, -122.472417376171) | |||
| 69825 | 69825 | 205093 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991307.52024 | 2092082.28561 | 37.7239598143777 | -122.472205771982 | (37.7239598143777, -122.472205771982) | |||
| 70422 | 70422 | 205090 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991232.93514 | 2090942.88536 | 37.7208269864641 | -122.472380575028 | (37.7208269864641, -122.472380575028) | |||
| 70458 | 70458 | 205113 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 52 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5991352.77429 | 2092808.82601 | 37.7259573327624 | -122.47210226989701 | (37.7259573327624, -122.472102269897) | |||
| 70511 | 70511 | 212162 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Marietta Dr | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 5ft | 5999237.80706 | 2097579.98932 | 37.7395109730464 | -122.445187201442 | (37.7395109730464, -122.445187201442) | |||
| 71529 | 71529 | 176016 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Mansell St | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 0ft | 6009216.97292 | 2089964.58671 | 37.7191652533595 | -122.410145941702 | (37.7191652533595, -122.410145941702) | |||
| 72304 | 72304 | 205082 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991216.27623 | 2090657.6545099998 | 37.720042848675604 | -122.47241737616501 | (37.7200428486756, -122.472417376165) | |||
| 73785 | 73785 | 205079 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 5991209.0936900005 | 2090537.87387 | 37.7197135448202 | -122.47243347583 | (37.7197135448202, -122.47243347583) | |||
| 74365 | 74365 | 217779 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 498x West Portal Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 4ft | 5991539.5981 | 2096085.91428 | 37.734966205933794 | -122.471695149536 | (37.7349662059338, -122.471695149536) | |||
| 75985 | 75985 | 176015 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 600x Mansell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 6010073.5317400005 | 2090236.70222 | 37.7199604006417 | -122.40720430245399 | (37.7199604006417, -122.407204302454) | |||
| 77692 | 77692 | 3754 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1020 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 18 | 6012443.0515847 | 2103208.5839527003 | 37.755710788358 | -122.399924077269 | (37.755710788358, -122.399924077269) | |||
| 78281 | 78281 | 111082 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 130 JUNIPERO SERRA BLVD | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | 5991393.0 | 2095322.0 | 37.7328602072681 | -122.472146321186 | (37.7328602072681, -122.472146321186) | ||||
| 78324 | 78324 | 30038 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.47158589282199 | (37.7138086207581, -122.471585892822) | ||
| 79082 | 79082 | 11840 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) |
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");