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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | ||||
| 127993 | 127993 | 122585 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500X Lyon St | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 70 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
| 91300 | 91300 | 112804 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 219 UPPER TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 5999620.0 | 2106355.0 | 37.7636268249183 | -122.444496241129 | (37.7636268249183, -122.444496241129) | |||
| 139589 | 139589 | 109576 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 21X STILLINGS AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 60 | 6000417.0 | 2095694.0 | 37.7343997262189 | -122.44097481223999 | (37.7343997262189, -122.44097481224) | ||||
| 127597 | 127597 | 114509 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3X VULCAN STWY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 56 | 6000640.0 | 2106231.0 | 37.7633444989385 | -122.440959493883 | (37.7633444989385, -122.440959493883) | ||||
| 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) | |||
| 135635 | 135635 | 240594 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 216 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | 6003152.3623 | 2096416.5644900003 | 37.736539139077394 | -122.43156934507401 | (37.7365391390774, -122.431569345074) | ||||
| 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) | |||
| 116259 | 116259 | 122587 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500X Lyon St | 7 | Median : Cutout 11 | Tree 1 | Private 1 | 45 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
| 85994 | 85994 | 104510 | Private 5 | Sequoia sempervirens :: Coast Redwood 116 | 254 ALLISON ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 40 | 6000052.0 | 2087408.0 | 37.7116274717654 | -122.441642291463 | (37.7116274717654, -122.441642291463) | ||||
| 106535 | 106535 | 113163 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1300X STANYAN ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | |||
| 112251 | 112251 | 113162 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1300X STANYAN ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | |||
| 131190 | 131190 | 246442 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 485 Duncan St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6003379.46073 | 2099778.50621 | 37.7457831256083 | -122.431024044746 | (37.7457831256083, -122.431024044746) | ||||
| 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 | ||||||||
| 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 | ||||||||
| 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) | ||||
| 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) | |||
| 72190 | 72190 | 179498 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 892 Peru Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6005545.45161 | 2091807.84398 | 37.7240199601485 | -122.422967943043 | (37.7240199601485, -122.422967943043) | ||||
| 104001 | 104001 | 197581 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2101 17th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 6011118.65336 | 2106461.14792 | 37.7645676761706 | -122.40473326313601 | (37.7645676761706, -122.404733263136) | ||||
| 150118 | 150118 | 240628 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 32 Harry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6003238.63031 | 2097694.69053 | 37.740053469295795 | -122.431362290536 | (37.7400534692958, -122.431362290536) | ||||
| 137793 | 137793 | 53580 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 148 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1973 12:00:00 AM | 34 | Permit Number 12426 | 5993993.6857199995 | 2114568.59854 | 37.7858565385613 | -122.46455217907699 | (37.7858565385613, -122.464552179077) | ||
| 171498 | 171498 | 215042 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 689 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 10ft | 5996876.31142 | 2095244.7341099998 | 37.732963851 | -122.453183641224 | (37.732963851, -122.453183641224) | |||
| 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) | |||
| 187854 | 187854 | 197590 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 200 Kansas St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 4ft | 6011401.81383 | 2107103.92491 | 37.7663484192558 | -122.403799114839 | (37.7663484192558, -122.403799114839) | |||
| 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) | ||||
| 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) | ||||
| 169341 | 169341 | 197582 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 851 Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 10ft | 6014984.28202 | 2104444.32589 | 37.7592452203005 | -122.39122199711399 | (37.7592452203005, -122.391221997114) | |||
| 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) | |||
| 97021 | 97021 | 106360 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1820 POST ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6003351.1 | 2114201.6 | 37.785383838011 | -122.43215193232099 | (37.785383838011, -122.432151932321) | ||||
| 125999 | 125999 | 106361 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1645 WEBSTER ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | ||||
| 148759 | 148759 | 119951 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 300 28th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 3ft | 5987162.07649 | 2113890.44215 | 37.783598323431 | -122.488137483705 | (37.783598323431, -122.488137483705) | |||
| 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) | ||||
| 65961 | 65961 | 250201 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 203 Union St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 29 | Width 0ft | 6011763.02504 | 2119743.5219400004 | 37.8010739675505 | -122.40343905958099 | (37.8010739675505, -122.403439059581) | |||
| 149631 | 149631 | 197584 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 851 Indiana St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 10ft | 6014983.28625 | 2104495.6281 | 37.7593860298711 | -122.391229027092 | (37.7593860298711, -122.391229027092) | |||
| 76485 | 76485 | 197585 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 900x Carolina St | 75 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6012517.30691 | 2102783.51804 | 37.7545477896502 | -122.399637433715 | (37.7545477896502, -122.399637433715) | ||||
| 151692 | 151692 | 240595 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 San Jose Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6003654.00301 | 2095729.23304 | 37.7346803033401 | -122.429785949874 | (37.7346803033401, -122.429785949874) | ||||
| 180000 | 180000 | 240618 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 69 Levant St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 3ft | 6000370.536280001 | 2106394.5334900003 | 37.7637781703576 | -122.441903216369 | (37.7637781703576, -122.441903216369) | |||
| 170029 | 170029 | 197583 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 851 Indiana St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 8ft | 6014993.182580001 | 2104474.00413 | 37.7593272043051 | -122.39119328893801 | (37.7593272043051, -122.391193288938) | |||
| 87470 | 87470 | 102106 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 50X Noe St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/19/2012 12:00:00 AM | 25 | Permit Number 769282 | 6002816.1 | 2107996.5 | 37.7683158318555 | -122.433559261751 | (37.7683158318555, -122.433559261751) | ||
| 154287 | 154287 | 215034 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 5ft | 5999319.41307 | 2097556.59014 | 37.7394513821643 | -122.444903362803 | (37.7394513821643, -122.444903362803) | |||
| 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 | ||||||||
| 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 | ||||||||
| 114763 | 114763 | 112145 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 401X ROOSEVELT WAY | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6000065.0 | 2106738.0 | 37.764703828929896 | -122.44298463673401 | (37.7647038289299, -122.442984636734) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 187882 | 187882 | 215035 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 639 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 5997171.50868 | 2094376.6234 | 37.7305971411271 | -122.452100459987 | (37.7305971411271, -122.452100459987) | ||||
| 75876 | 75876 | 240607 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 888 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6000718.67811 | 2102015.72187 | 37.751774854241795 | -122.44038504473 | (37.7517748542418, -122.44038504473) | |||
| 147227 | 147227 | 240599 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3229 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6006780.56286 | 2103771.69804 | 37.75693965177221 | -122.41954675558 | (37.7569396517722, -122.41954675558) | |||
| 167940 | 167940 | 240620 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 272 Corbett Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | Width 3ft | 5999634.90147 | 2105345.61253 | 37.7608561480145 | -122.44437215754401 | (37.7608561480145, -122.444372157544) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 70736 | 70736 | 247974 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 346 Peralta Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6009790.92788 | 2099185.07173 | 37.7445148980554 | -122.408812155357 | (37.7445148980554, -122.408812155357) | ||||
| 176998 | 176998 | 136430 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1101 Greenwich St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6007579.05475 | 2119893.16835 | 37.8012502787406 | -122.417928048762 | (37.8012502787406, -122.417928048762) | ||||
| 74221 | 74221 | 215021 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2624 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5992112.26225 | 2097456.03758 | 37.7387613350595 | -122.469814985494 | (37.7387613350595, -122.469814985494) | |||
| 131451 | 131451 | 136444 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013387.59339 | 2118931.12048 | 37.798933912018704 | -122.397760298614 | (37.7989339120187, -122.397760298614) | ||||
| 153291 | 153291 | 136440 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013367.06255 | 2118933.3720400003 | 37.7989389509345 | -122.397831500623 | (37.7989389509345, -122.397831500623) | ||||
| 183846 | 183846 | 136437 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013352.957 | 2118919.28443 | 37.798899484176204 | -122.397879322098 | (37.7988994841762, -122.397879322098) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 70280 | 70280 | 248053 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 19 Rutledge St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010622.547590001 | 2099378.6850900003 | 37.7450930640901 | -122.405950205054 | (37.7450930640901, -122.405950205054) | ||||
| 166697 | 166697 | 136434 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 12 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6012298.4076 | 2120549.33954 | 37.8033164360554 | -122.401643063984 | (37.8033164360554, -122.401643063984) | ||||
| 153969 | 153969 | 215031 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 5999287.157930001 | 2097565.9418 | 37.739475218703106 | -122.445015558643 | (37.7394752187031, -122.445015558643) | |||
| 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) | ||||
| 72927 | 72927 | 120273 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 5988307.3728 | 2115160.02273 | 37.787150979882796 | -122.484268387653 | (37.7871509798828, -122.484268387653) | ||||
| 77228 | 77228 | 136442 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6013378.377640001 | 2118933.3014 | 37.7989393870992 | -122.397792341438 | (37.7989393870992, -122.397792341438) | ||||
| 101507 | 101507 | 381 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 105060 | 105060 | 380 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 134490 | 134490 | 215036 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 694 Hearst Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5996922.84392 | 2094438.19015 | 37.7307519414457 | -122.45296456906901 | (37.7307519414457, -122.452964569069) | ||||
| 136684 | 136684 | 120271 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 5988306.39603 | 2115180.23903 | 37.7872064312039 | -122.48427325023998 | (37.7872064312039, -122.48427325024) | ||||
| 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) | ||||
| 69856 | 69856 | 136428 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 7 Kimball Pl | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 6007991.83691 | 2116437.43612 | 37.791784918695 | -122.41625474228901 | (37.791784918695, -122.416254742289) | |||
| 70268 | 70268 | 120281 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5988339.230269999 | 2115128.3543599998 | 37.7870658824376 | -122.484155845816 | (37.7870658824376, -122.484155845816) | ||||
| 111685 | 111685 | 107343 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 110 JULIAN AVE | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6006340.8 | 2107214.1 | 37.7663669011591 | -122.421312071366 | (37.7663669011591, -122.421312071366) | ||||
| 117092 | 117092 | 113150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 45 BRONTE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6009384.0 | 2097185.0 | 37.7390003361927 | -122.410078062228 | (37.7390003361927, -122.410078062228) | |||
| 134244 | 134244 | 120280 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5988322.2380099995 | 2115131.91384 | 37.7870746664109 | -122.48421489568199 | (37.7870746664109, -122.484214895682) | ||||
| 152027 | 152027 | 136436 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6013350.43599 | 2118931.2626099996 | 37.7989322330038 | -122.397888886371 | (37.7989322330038, -122.397888886371) | ||||
| 161342 | 161342 | 240629 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 32 Harry St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6003236.62583 | 2097684.70359 | 37.740025933855705 | -122.431368508471 | (37.7400259338557, -122.431368508471) | ||||
| 161479 | 161479 | 136432 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 13 MacOndray Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6008638.14667 | 2119166.05389 | 37.799313351297606 | -122.414211640849 | (37.7993133512976, -122.414211640849) | ||||
| 162555 | 162555 | 120268 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 107 24th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5988313.3781 | 2115206.48473 | 37.7872789009445 | -122.48425101963899 | (37.7872789009445, -122.484251019639) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 147246 | 147246 | 215043 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 798 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5996915.73734 | 2095029.5626400001 | 37.732375301382 | -122.453031809567 | (37.732375301382, -122.453031809567) | ||||
| 164614 | 164614 | 215027 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 100 Terrace Dr | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5993761.26762 | 2096568.1489799998 | 37.7364185921533 | -122.464049108976 | (37.7364185921533, -122.464049108976) | ||||
| 186205 | 186205 | 240616 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 685 Sanchez St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 5ft | 6003715.87711 | 2104249.40994 | 37.758078233932096 | -122.430179665856 | (37.7580782339321, -122.430179665856) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 65616 | 65616 | 247596 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 900 Tompkins Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6009145.02453 | 2096408.71868 | 37.73685543873 | -122.410849521814 | (37.73685543873, -122.410849521814) | |||
| 154917 | 154917 | 215038 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 314 Staples Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5997989.53732 | 2093829.39983 | 37.7291414193406 | -122.449233015693 | (37.7291414193406, -122.449233015693) | ||||
| 167020 | 167020 | 179495 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 350x Winding Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6001141.4285699995 | 2086583.09342 | 37.7094244714452 | -122.43781789759 | (37.7094244714452, -122.43781789759) |
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");