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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 106132 | 106132 | 97857 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 895 Indiana St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 121387 | 121387 | 97856 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 895 Indiana St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 123802 | 123802 | 97853 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 895 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 139938 | 139938 | 97854 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 895 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 88274 | 88274 | 3774 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 1098 Carolina St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.39983195341699 | (37.754754478768, -122.399831953417) | |||
| 157277 | 157277 | 197589 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Jack Balestreri Way | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012441.30894 | 2104748.70907 | 37.7599395365119 | -122.40003825707 | (37.7599395365119, -122.40003825707) | ||||
| 169778 | 169778 | 197588 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Jack Balestreri Way | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6012433.89716 | 2104751.224 | 37.7599460287107 | -122.400064067605 | (37.7599460287107, -122.400064067605) | ||||
| 174597 | 174597 | 197587 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Jack Balestreri Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6012433.76366 | 2104761.3607799998 | 37.7599738546281 | -122.400065241211 | (37.7599738546281, -122.400065241211) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 77818 | 77818 | 108026 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 862 Kansas St | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774734 | 6011570.0 | 2104296.0 | 37.758647879927395 | -122.403019866682 | (37.7586478799274, -122.403019866682) | |||||
| 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) | |||
| 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) | |||
| 105545 | 105545 | 54448 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 425 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3x5 | Permit Number 10233 | 6011220.56042251 | 2106374.73270267 | 37.764336094761 | -122.40437470921499 | (37.764336094761, -122.404374709215) | ||
| 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) | ||||
| 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) | ||||
| 183468 | 183468 | 187562 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 136 Alpha St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6010924.81275 | 2088138.49847 | 37.714246765754105 | -122.40411411319401 | (37.7142467657541, -122.404114113194) | |||
| 123320 | 123320 | 109532 | Sequoia sempervirens :: Coast Redwood 116 | 818 Goettingen St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010847.3 | 2090865.3 | 37.7217296747854 | -122.404573864697 | (37.7217296747854, -122.404573864697) | ||||||
| 73308 | 73308 | 187590 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 700 Goettingen St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010709.76883 | 2091388.9815099998 | 37.7231599087791 | -122.40508613194599 | (37.7231599087791, -122.405086131946) | ||||
| 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) | ||||
| 172692 | 172692 | 248065 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 18 Rutledge St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010648.08166 | 2099392.5913299997 | 37.7451326756473 | -122.405862891685 | (37.7451326756473, -122.405862891685) | ||||
| 65505 | 65505 | 248066 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 18 Rutledge St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6010646.65948 | 2099397.14706 | 37.7451451051559 | -122.405868130216 | (37.7451451051559, -122.405868130216) | ||||
| 166588 | 166588 | 248068 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 20 Rutledge St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010623.83336 | 2099392.33092 | 37.7451306044855 | -122.40594672016701 | (37.7451306044855, -122.405946720167) | ||||
| 146584 | 146584 | 248054 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 19 Rutledge St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6010623.789469999 | 2099366.66931 | 37.7450601408245 | -122.405945064536 | (37.7450601408245, -122.405945064536) | ||||
| 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) | ||||
| 64361 | 64361 | 248069 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 20 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010620.265980001 | 2099403.1540599996 | 37.7451601229588 | -122.405959817907 | (37.7451601229588, -122.405959817907) | ||||
| 114761 | 114761 | 112559 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1735x GRANT AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010373.0 | 2120454.0 | 37.8029470287696 | -122.40829930674299 | (37.8029470287696, -122.408299306743) | |||||
| 178655 | 178655 | 197579 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 428 08th St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010214.98706 | 2109650.78059 | 37.773275125388 | -122.408083778259 | (37.773275125388, -122.408083778259) | |||
| 102307 | 102307 | 99256 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 1466 York St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010099.0 | 2100741.0 | 37.7488043872035 | -122.407856595429 | (37.7488043872035, -122.407856595429) | ||||||
| 86911 | 86911 | 87150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 4 Bellair Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 50135 | 6010093.0 | 2120950.0 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | ||||
| 125077 | 125077 | 87149 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 4 Bellair Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010093.0 | 2120950.0 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | |||||
| 165286 | 165286 | 247908 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 582 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6009856.31482 | 2098721.18962 | 37.7432448412741 | -122.408553343056 | (37.7432448412741, -122.408553343056) | ||||
| 165892 | 165892 | 247905 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 582 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009839.52244 | 2098719.28889 | 37.7432386818184 | -122.40861127291099 | (37.7432386818184, -122.408611272911) | ||||
| 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) | ||||
| 89351 | 89351 | 116234 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 450 PERALTA AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6009750.0 | 2099218.0 | 37.744603019334 | -122.408955999129 | (37.744603019334, -122.408955999129) | ||||
| 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) | |||
| 154175 | 154175 | 246775 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 925 Esmeralda Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6009505.54739 | 2098718.43829 | 37.743217635879205 | -122.409766015896 | (37.7432176358792, -122.409766015896) | ||||
| 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) | |||
| 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) | |||
| 187074 | 187074 | 247597 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 900 Tompkins Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6009155.970980001 | 2096407.45458 | 37.7368525815689 | -122.41081158571001 | (37.7368525815689, -122.41081158571) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 99767 | 99767 | 122496 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 69x Bonview St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007716.0 | 2099172.0 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | ||||
| 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) | ||||
| 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) | ||||
| 153412 | 153412 | 179499 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1151 Felton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007548.787880001 | 2092831.16716 | 37.7269426263769 | -122.416115141404 | (37.7269426263769, -122.416115141404) | |||
| 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) | ||||
| 93306 | 93306 | 116660 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 199x Esmeralda Ave | 13 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 8 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | ||||
| 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) | |||
| 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) | ||||
| 172592 | 172592 | 240600 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 237 Murray St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6005707.57123 | 2095372.66085 | 37.7338173103055 | -122.422660726511 | (37.7338173103055, -122.422660726511) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 131189 | 131189 | 179497 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 653 Peru Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6005046.66321 | 2092646.92983 | 37.7262957476241 | -122.424751842734 | (37.7262957476241, -122.424751842734) | ||||
| 91222 | 91222 | 98597 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 400X Steiner St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 768529 | 6004639.0 | 2109849.0 | 37.7735056071657 | -122.42738600543899 | (37.7735056071657, -122.427386005439) | ||||
| 143568 | 143568 | 96273 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 55@ Alemany Trumbull St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | |||||
| 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) | |
| 149664 | 149664 | 240613 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3637 22nd St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6003938.94874 | 2103022.28304 | 37.754721465836894 | -122.42932068472 | (37.7547214658369, -122.42932068472) | |||
| 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) | |||
| 164767 | 164767 | 240612 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3637 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003932.88521 | 2103022.72642 | 37.7547223399723 | -122.429341685671 | (37.7547223399723, -122.429341685671) | |||
| 91679 | 91679 | 94535 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 265 Dorland St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003831.0 | 2105693.0 | 37.7620485075454 | -122.42988449123301 | (37.7620485075454, -122.429884491233) | |||||
| 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) | |||
| 74195 | 74195 | 240615 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 297 Cumberland St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6003715.872169999 | 2104475.4119700002 | 37.75869878143 | -122.430195805998 | (37.75869878143, -122.430195805998) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 107500 | 107500 | 54927 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 485 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1972 12:00:00 AM | 10 | Permit Number 10801 | 6003402.69319537 | 2099776.66443458 | 37.745779384936206 | -122.43094357883498 | (37.7457793849362, -122.430943578835) | ||
| 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) | ||||
| 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) | ||||
| 102600 | 102600 | 106362 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1645 WEBSTER ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) |
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");