Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 838 | 838 | 19815 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY24 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 100ST | ||||||||
| 1817 | 1817 | 251719 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Clayton St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5999055.0 | 2105304.0 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | |||||
| 3280 | 3280 | 253389 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 30X Grand View Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 6000475.0 | 2103841.0 | 37.756772747069604 | -122.44135867200701 | (37.7567727470696, -122.441358672007) | ||||
| 3355 | 3355 | 253433 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Vulcan Stwy | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6000640.0 | 2106231.0 | 37.7633444989385 | -122.440959493883 | (37.7633444989385, -122.440959493883) | ||||
| 4452 | 4452 | 19593 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY4 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
| 5737 | 5737 | 20074 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY55 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 27X | ||||||||
| 6387 | 6387 | 19592 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY4 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
| 7219 | 7219 | 20014 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY47 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 7290 | 7290 | 19816 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY24 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 100ST | ||||||||
| 10060 | 10060 | 19578 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY4 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 8 | ||||||||
| 11264 | 11264 | 117179 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 350x Winding Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 3x3 | 6001167.67306 | 2086580.24641 | 37.7094181465037 | -122.43772698870701 | (37.7094181465037, -122.437726988707) | |||
| 12451 | 12451 | 20015 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY47 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 12707 | 12707 | 107222 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 327 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2014 12:00:00 AM | 3 | 6x5 | Permit Number 773943 | 6003989.6035400005 | 2091508.12122 | 37.7231090719178 | -122.42832491578301 | (37.7231090719178, -122.428324915783) | |
| 13822 | 13822 | 20456 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 495X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 14101 | 14101 | 96173 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767806 | |||||||||
| 15735 | 15735 | 19811 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY24 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 100ST | ||||||||
| 20116 | 20116 | 2370 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2516 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4PL | 6009703.1421 | 2102664.68486 | 37.7540642287015 | -122.40936121487499 | (37.7540642287015, -122.409361214875) | |||
| 20974 | 20974 | 109568 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 95 Nordhoff St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 777169 | 6000348.8 | 2095645.6 | 37.734262946491704 | -122.44120712981501 | (37.7342629464917, -122.441207129815) | ||||
| 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) | ||
| 22599 | 22599 | 2580 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 1668 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005450.60125 | 2115176.6463599997 | 37.7881798837348 | -122.424957678647 | (37.7881798837348, -122.424957678647) | |||
| 24557 | 24557 | 136431 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 13 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6008632.90068 | 2119166.6230200003 | 37.799314619318 | -122.414229834152 | (37.799314619318, -122.414229834152) | ||||
| 25384 | 25384 | 185213 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985153.279 | 2098105.011 | 37.740138541922 | -122.49392333934799 | (37.740138541922, -122.493923339348) | |||
| 26484 | 26484 | 184736 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984658.5537 | 2106283.3352 | 37.762565010947704 | -122.49623713063801 | (37.7625650109477, -122.496237130638) | |||
| 27330 | 27330 | 187124 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985135.2439 | 2097353.8058 | 37.738074878751895 | -122.493930349328 | (37.7380748787519, -122.493930349328) | |||
| 27359 | 27359 | 240611 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 255 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003497.9531 | 2101542.75011 | 37.750634040826796 | -122.43074019171699 | (37.7506340408268, -122.430740191717) | |||
| 29043 | 29043 | 181547 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984881.425 | 2105994.983 | 37.761786329172104 | -122.495445043427 | (37.7617863291721, -122.495445043427) | |||
| 29532 | 29532 | 186369 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1801 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984816.0737 | 2102538.2484 | 37.7522912688492 | -122.495416115464 | (37.7522912688492, -122.495416115464) | |||
| 29906 | 29906 | 250138 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2550x Lyon St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 101 | 5999227.62567 | 2117605.22496 | 37.7944946461503 | -122.446662836939 | (37.7944946461503, -122.446662836939) | ||||
| 29908 | 29908 | 249959 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 273 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | Width 0ft | 6011558.5565599995 | 2120064.53903 | 37.801943979781896 | -122.40416921824301 | (37.8019439797819, -122.404169218243) | |||
| 30053 | 30053 | 240601 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 609 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001917.090969999 | 2099400.07719 | 37.744661076553 | -122.43605362647301 | (37.744661076553, -122.436053626473) | |||
| 30220 | 30220 | 181484 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1400 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984898.4123 | 2105356.9862 | 37.7600355628364 | -122.49533923888201 | (37.7600355628364, -122.495339238882) | |||
| 31261 | 31261 | 215028 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 100 Terrace Dr | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5993755.12546 | 2096561.9752 | 37.7364012864951 | -122.464069896803 | (37.7364012864951, -122.464069896803) | ||||
| 33291 | 33291 | 240614 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3637 22nd St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003933.5831699995 | 2103025.57629 | 37.7547302045579 | -122.429339475147 | (37.7547302045579, -122.429339475147) | |||
| 34861 | 34861 | 240630 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 32 Harry St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6003226.48563 | 2097681.33135 | 37.7400160997695 | -122.43140332841999 | (37.7400160997695, -122.43140332842) | ||||
| 35086 | 35086 | 185875 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2000 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985024.3241 | 2101081.1994 | 37.74830280287971 | -122.494588557862 | (37.7483028028797, -122.494588557862) | |||
| 35152 | 35152 | 215041 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 497 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998794.49638 | 2094951.64479 | 37.732268849509104 | -122.44653092436701 | (37.7322688495091, -122.446530924367) | |||
| 35177 | 35177 | 184804 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984679.0585 | 2105723.8188 | 37.7610299368102 | -122.496124931271 | (37.7610299368102, -122.496124931271) | |||
| 35570 | 35570 | 240617 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 685 Sanchez St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 6003712.72581 | 2104261.51662 | 37.7581112975082 | -122.43019142809099 | (37.7581112975082, -122.430191428091) | |||
| 36125 | 36125 | 186472 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1601 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984790.3524 | 2103740.0582 | 37.755589600564704 | -122.495593697553 | (37.7555896005647, -122.495593697553) | |||
| 36375 | 36375 | 136443 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6013384.0493 | 2118922.9353099996 | 37.7989112401317 | -122.39777198798201 | (37.7989112401317, -122.397771987982) | ||||
| 36809 | 36809 | 215040 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 88 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5994178.77111 | 2090487.7098599998 | 37.71974724151371 | -122.46216479907 | (37.7197472415137, -122.46216479907) | ||||
| 37950 | 37950 | 247598 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 900 Tompkins Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6009167.823059999 | 2096407.9062599998 | 37.7368544863348 | -122.410770639572 | (37.7368544863348, -122.410770639572) | |||
| 38099 | 38099 | 200496 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3239 Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6013542.8885 | 2090062.874 | 37.7196766561509 | -122.39519967454399 | (37.7196766561509, -122.395199674544) | |||
| 38278 | 38278 | 215037 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 314 Staples Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5997982.72892 | 2093830.4607099998 | 37.7291439428352 | -122.449256629186 | (37.7291439428352, -122.449256629186) | ||||
| 38586 | 38586 | 246713 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Bonview St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6007763.89494 | 2099225.75212 | 37.7445128502976 | -122.415824124379 | (37.7445128502976, -122.415824124379) | ||||
| 38662 | 38662 | 215039 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 179 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 5994134.23715 | 2091156.84385 | 37.721581958319504 | -122.462367242757 | (37.7215819583195, -122.462367242757) | ||||
| 39303 | 39303 | 118611 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 349 Point Lobos Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5981718.6857199995 | 2112644.15815 | 37.7798573303546 | -122.506876725888 | (37.7798573303546, -122.506876725888) | ||||
| 39748 | 39748 | 240597 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 523 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | 6008567.55649 | 2098119.2319799997 | 37.741519737445294 | -122.412966995358 | (37.7415197374453, -122.412966995358) | ||||
| 40236 | 40236 | 120278 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5988337.84774 | 2115148.37916 | 37.7871207843354 | -122.48416209808799 | (37.7871207843354, -122.484162098088) | ||||
| 40320 | 40320 | 187361 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2200 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985088.1562 | 2099814.8531 | 37.7448294961486 | -122.49427450340099 | (37.7448294961486, -122.494274503401) | |||
| 40443 | 40443 | 120276 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 5988325.261 | 2115160.84311 | 37.787154273948204 | -122.484206559328 | (37.7871542739482, -122.484206559328) | ||||
| 40656 | 40656 | 186033 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1900 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985025.9241 | 2102045.6103 | 37.7509509050251 | -122.49465411447399 | (37.7509509050251, -122.494654114474) | |||
| 40766 | 40766 | 120272 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 5988314.622169999 | 2115170.4665900003 | 37.7871800778407 | -122.48424407294901 | (37.7871800778407, -122.484244072949) | ||||
| 40898 | 40898 | 185564 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2201 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984920.5667 | 2099758.7289 | 37.744665585625896 | -122.494849850524 | (37.7446655856259, -122.494849850524) | |||
| 41136 | 41136 | 250136 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2550x Lyon St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 100 | 5999230.194080001 | 2117561.109 | 37.794373662156296 | -122.446650774326 | (37.7943736621563, -122.446650774326) | ||||
| 41346 | 41346 | 181435 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1500 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984924.5894 | 2104933.1403 | 37.7588733327201 | -122.495217449651 | (37.7588733327201, -122.495217449651) | |||
| 41820 | 41820 | 136433 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2671 Leavenworth St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 6007318.566930001 | 2121838.23641 | 37.8065762788357 | -122.418967487863 | (37.8065762788357, -122.418967487863) | ||||
| 42971 | 42971 | 111268 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 700X BOSWORTH ST | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 43173 | 43173 | 112929 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | |||
| 43258 | 43258 | 240627 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5413 Diamond Heights Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002066.06456 | 2097929.8821400004 | 37.7406327271153 | -122.43543335598 | (37.7406327271153, -122.43543335598) | ||||
| 43998 | 43998 | 136441 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6013371.772919999 | 2118938.4754 | 37.798953225861 | -122.397815559237 | (37.798953225861, -122.397815559237) | ||||
| 44071 | 44071 | 181543 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984893.6781 | 2105927.5909 | 37.761602006776 | -122.49539769507 | (37.761602006776, -122.49539769507) | |||
| 44202 | 44202 | 186673 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1401 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984739.5822 | 2105465.3048 | 37.7603236745559 | -122.495896538326 | (37.7603236745559, -122.495896538326) | |||
| 45421 | 45421 | 240621 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 219 Upper Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 3ft | 5999599.462169999 | 2106267.78648 | 37.7633861864367 | -122.444561006196 | (37.7633861864367, -122.444561006196) | |||
| 45602 | 45602 | 109669 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 200X GELLERT DR | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/26/2015 01:37:00 PM | 3 | 30x200 | 5985380.0 | 2094516.3 | 37.730298158604995 | -122.492875173009 | (37.730298158605, -122.492875173009) | ||
| 46422 | 46422 | 248058 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 17 Rutledge St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6010687.47782 | 2099346.1468700003 | 37.7450073524216 | -122.405723395139 | (37.7450073524216, -122.405723395139) | ||||
| 47297 | 47297 | 240626 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5413 Diamond Heights Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6002059.772469999 | 2097912.30108 | 37.740584096269295 | -122.435453854224 | (37.7405840962693, -122.435453854224) | ||||
| 47580 | 47580 | 186579 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1501 Sunset Blvd | 50 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984739.2681 | 2104595.0921 | 37.7579342947119 | -122.495833430643 | (37.7579342947119, -122.495833430643) | |||
| 47961 | 47961 | 136435 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6013344.909530001 | 2118921.0971 | 37.7989040131614 | -122.39790729640801 | (37.7989040131614, -122.397907296408) | ||||
| 48209 | 48209 | 136445 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6013392.00591 | 2118921.55061 | 37.79890788115829 | -122.397744358119 | (37.7989078811583, -122.397744358119) | ||||
| 48439 | 48439 | 181387 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1500 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984939.8638 | 2104520.2223 | 37.757740468934294 | -122.495134175513 | (37.7577404689343, -122.495134175513) | |||
| 50051 | 50051 | 120239 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 288 24th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5988397.09206 | 2114077.36637 | 37.784183536793705 | -122.483878566436 | (37.7841835367937, -122.483878566436) | |||
| 50092 | 50092 | 372 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 50233 | 50233 | 187392 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2100 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985024.2566 | 2100630.9061 | 37.7470664162932 | -122.494555600597 | (37.7470664162932, -122.494555600597) | |||
| 50578 | 50578 | 136439 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6013363.76971 | 2118922.4292 | 37.7989087211284 | -122.397842127014 | (37.7989087211284, -122.397842127014) | ||||
| 50596 | 50596 | 120279 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5988331.03377 | 2115139.5257599996 | 37.787096078694205 | -122.484185023117 | (37.7870960786942, -122.484185023117) | ||||
| 51336 | 51336 | 197580 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2151 17th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010976.50521 | 2106453.15639 | 37.764537787215 | -122.405224355037 | (37.764537787215, -122.405224355037) | ||||
| 51589 | 51589 | 184745 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984671.0844 | 2106181.5705 | 37.7622863276384 | -122.496186283596 | (37.7622863276384, -122.496186283596) | |||
| 52535 | 52535 | 187380 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2200 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985069.8747 | 2100065.0386 | 37.7455153678045 | -122.494356154683 | (37.7455153678045, -122.494356154683) | |||
| 53755 | 53755 | 136438 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6013355.98644 | 2118932.3733599996 | 37.798935591968004 | -122.39786975780301 | (37.798935591968, -122.397869757803) | ||||
| 54165 | 54165 | 240598 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2106 Folsom St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 2ft | 6008077.42241 | 2106097.35182 | 37.763398325498 | -122.415226338718 | (37.763398325498, -122.415226338718) | |||
| 54404 | 54404 | 215029 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 100 Terrace Dr | 24 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5993749.23334 | 2096552.6449799999 | 37.736375328444296 | -122.464089591065 | (37.7363753284443, -122.464089591065) | ||||
| 55401 | 55401 | 181491 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1400 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984894.5136 | 2105385.9481 | 37.760114855862604 | -122.49535485835699 | (37.7601148558626, -122.495354858357) | |||
| 55573 | 55573 | 184741 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984704.12 | 2106224.4787 | 37.76240607654479 | -122.496075193313 | (37.7624060765448, -122.496075193313) | |||
| 57134 | 57134 | 186036 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1900 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985023.9883 | 2102086.2614 | 37.7510624084937 | -122.49466380518 | (37.7510624084937, -122.49466380518) | |||
| 57311 | 57311 | 197586 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Jack Balestreri Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | Width 10ft | 6012374.628719999 | 2104733.59825 | 37.7598943275787 | -122.400267811735 | (37.7598943275787, -122.400267811735) | |||
| 57707 | 57707 | 120269 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 107 24th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5988324.11159 | 2115191.8605299997 | 37.78723937201521 | -122.48421281158701 | (37.7872393720152, -122.484212811587) | ||||
| 58796 | 58796 | 240619 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 104 Saturn St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6000003.92034 | 2105982.96119 | 37.762627197305605 | -122.443141663776 | (37.7626271973056, -122.443141663776) | |||
| 59035 | 59035 | 186092 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1901 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984860.3007 | 2101794.0493 | 37.750250492095795 | -122.495208298659 | (37.7502504920958, -122.495208298659) | |||
| 59256 | 59256 | 187358 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2200 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985096.2813 | 2099797.9258 | 37.7447834938464 | -122.494245161303 | (37.7447834938464, -122.494245161303) | |||
| 60028 | 60028 | 215024 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 100 Terrace Dr | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5993634.34816 | 2096702.85203 | 37.7367811376468 | -122.46449769711201 | (37.7367811376468, -122.464497697112) | ||||
| 60441 | 60441 | 215023 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 100 Terrace Dr | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5993620.60867 | 2096711.6491200002 | 37.736804500228 | -122.464545838734 | (37.736804500228, -122.464545838734) | ||||
| 60464 | 60464 | 186891 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2700 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985178.2577 | 2096509.7223 | 37.7357597676042 | -122.493719449451 | (37.7357597676042, -122.493719449451) | |||
| 60533 | 60533 | 250200 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 203 Union St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 33 | Width 0ft | 6011776.4013 | 2119745.07747 | 37.8010789857668 | -122.403392881194 | (37.8010789857668, -122.403392881194) | |||
| 60921 | 60921 | 240596 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 San Jose Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6003644.77453 | 2095717.8337299998 | 37.7346484808287 | -122.429817043043 | (37.7346484808287, -122.429817043043) | ||||
| 60930 | 60930 | 52819 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 1327@ JUDAH 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Permit Number 48844 | 5987385.2929 | 2106232.8495 | 37.7625857382219 | -122.48680274332399 | (37.7625857382219, -122.486802743324) | |||
| 61564 | 61564 | 136429 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1101 Greenwich St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6007562.303180001 | 2119880.18015 | 37.801213673635004 | -122.41798509543301 | (37.801213673635, -122.417985095433) | ||||
| 62319 | 62319 | 120275 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 5988318.18285 | 2115148.99603 | 37.78712133312521 | -122.48423017871299 | (37.7871213331252, -122.484230178713) | ||||
| 62574 | 62574 | 240606 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2112 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 35 | Width 10ft | 6002638.80724 | 2099263.13099 | 37.7443260296246 | -122.43354829062099 | (37.7443260296246, -122.433548290621) | |||
| 63075 | 63075 | 179496 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 653 Peru Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6005058.40423 | 2092646.41058 | 37.726294985004294 | -122.424711217658 | (37.7262949850043, -122.424711217658) |
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");