Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 140619 | 140619 | 95331 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 390X Filbert St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | ||||
| 103346 | 103346 | 95333 | DPW Maintained 3 | Tree(s) :: 17 | 399X Filbert St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | ||||
| 53598 | 53598 | 95407 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2X Cranleigh Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 80 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | ||||
| 142482 | 142482 | 96128 | DPW Maintained 3 | Tree(s) :: 17 | 1420X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016441.6 | 2096581.1 | 37.7377351967413 | -122.385633815961 | (37.7377351967413, -122.385633815961) | ||||
| 102603 | 102603 | 96129 | DPW Maintained 3 | Tree(s) :: 17 | 1424X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016423.9 | 2096594.4 | 37.7377707364606 | -122.385695940665 | (37.7377707364606, -122.385695940665) | ||||
| 94441 | 94441 | 96130 | DPW Maintained 3 | Tree(s) :: 17 | 1428X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016403.1 | 2096603.7 | 37.737795121412795 | -122.385768505015 | (37.7377951214128, -122.385768505015) | ||||
| 109811 | 109811 | 96135 | DPW Maintained 3 | Tree(s) :: 17 | 1444X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016335.2 | 2096661.0 | 37.7379486980737 | -122.386007263552 | (37.7379486980737, -122.386007263552) | ||||
| 82638 | 82638 | 96136 | DPW Maintained 3 | Tree(s) :: 17 | 1454X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016287.8 | 2096690.3 | 37.7380265265677 | -122.386173192236 | (37.7380265265677, -122.386173192236) | ||||
| 129100 | 129100 | 96137 | DPW Maintained 3 | Tree(s) :: 17 | 1454X Innes Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016287.8 | 2096690.3 | 37.7380265265677 | -122.386173192236 | (37.7380265265677, -122.386173192236) | ||||
| 115913 | 115913 | 96138 | DPW Maintained 3 | Tree(s) :: 17 | 1454X Innes Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016287.8 | 2096690.3 | 37.7380265265677 | -122.386173192236 | (37.7380265265677, -122.386173192236) | ||||
| 91583 | 91583 | 96139 | DPW Maintained 3 | Tree(s) :: 17 | 1460X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016261.2 | 2096710.2 | 37.738079695647706 | -122.386266549459 | (37.7380796956477, -122.386266549459) | ||||
| 144035 | 144035 | 96140 | DPW Maintained 3 | Tree(s) :: 17 | 1460X Innes Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016261.2 | 2096710.2 | 37.738079695647706 | -122.386266549459 | (37.7380796956477, -122.386266549459) | ||||
| 79938 | 79938 | 96141 | DPW Maintained 3 | Tree(s) :: 17 | 1468X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016228.8 | 2096740.9 | 37.738162198215 | -122.386380713289 | (37.738162198215, -122.386380713289) | ||||
| 145563 | 145563 | 96142 | DPW Maintained 3 | Tree(s) :: 17 | 1468X Innes Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016228.8 | 2096740.9 | 37.738162198215 | -122.386380713289 | (37.738162198215, -122.386380713289) | ||||
| 145598 | 145598 | 96143 | DPW Maintained 3 | Tree(s) :: 17 | 1470X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016219.9 | 2096747.5 | 37.738179827823 | -122.38641194538201 | (37.738179827823, -122.386411945382) | ||||
| 120340 | 120340 | 96144 | DPW Maintained 3 | Tree(s) :: 17 | 1484X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016157.8 | 2096794.1 | 37.7383043442369 | -122.386629906827 | (37.7383043442369, -122.386629906827) | ||||
| 84421 | 84421 | 96975 | DPW Maintained 3 | Tree(s) :: 17 | 399X Filbert St | 4 | Median : Yard 3 | Tree 1 | Private 1 | 24 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | ||||
| 93919 | 93919 | 96976 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 390X Filbert St | 1 | Median : Yard 3 | Tree 1 | Rec/Park 3 | 28 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | ||||
| 142749 | 142749 | 97395 | DPW Maintained 3 | Araucaria heterophylla :: Norfolk Island Pine 24 | 1203X Sunset Blvd | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 5989104.6 | 2108557.5 | 37.7690686805765 | -122.48102656954599 | (37.7690686805765, -122.481026569546) | |||||
| 128569 | 128569 | 97396 | DPW Maintained 3 | Araucaria heterophylla :: Norfolk Island Pine 24 | 1203X Sunset Blvd | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 5989104.6 | 2108557.5 | 37.7690686805765 | -122.48102656954599 | (37.7690686805765, -122.481026569546) | |||||
| 116741 | 116741 | 97397 | DPW Maintained 3 | Butia capitata :: Pindo Palm 149 | 1203X Sunset Blvd | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 5989104.6 | 2108557.5 | 37.7690686805765 | -122.48102656954599 | (37.7690686805765, -122.481026569546) | |||||
| 104474 | 104474 | 97692 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 70x Benton Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 11/05/2011 12:00:00 AM | 6004768.61645 | 2094959.0484200001 | 37.732628603868704 | -122.425877544976 | (37.7326286038687, -122.425877544976) | ||||
| 104032 | 104032 | 98994 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 745X SANCHEZ ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
| 116375 | 116375 | 99101 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 55x Santa Monica Way | 1 | Median : Yard 3 | Tree 1 | Private 1 | 04/07/2012 12:00:00 AM | Permit Number 768464 | 5993693.6 | 2097654.3 | 37.739396991894104 | -122.464361897304 | (37.7393969918941, -122.464361897304) | |||
| 81264 | 81264 | 99456 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Miramar Ave | 6 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.45812076272101 | (37.7250639553871, -122.458120762721) | |
| 85151 | 85151 | 99471 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Miramar Ave | 7 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995435.2 | 2093399.0 | 37.727813210556704 | -122.458032376835 | (37.7278132105567, -122.458032376835) | |
| 19556 | 19556 | 99478 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 650X Miramar Ave | 4 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |
| 138714 | 138714 | 99482 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Miramar Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | |
| 123683 | 123683 | 99488 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |
| 98576 | 98576 | 99490 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 4 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |
| 87236 | 87236 | 99491 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 5 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |
| 129469 | 129469 | 101030 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1010X Portola Dr | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | ||||
| 121860 | 121860 | 102111 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 18 Saturn St | 1 | Median : Yard 3 | Tree 1 | Private 1 | 24 | 6000559.0 | 2106017.0 | 37.7627522940794 | -122.441224290546 | (37.7627522940794, -122.441224290546) | ||||
| 92518 | 92518 | 102573 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Park St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004982.6 | 2096420.1 | 37.7366524147431 | -122.425241679782 | (37.7366524147431, -122.425241679782) | ||||
| 19618 | 19618 | 102860 | DPW Maintained 3 | Calocedrus decurrens :: Incense Cedar 177 | 10X CRANLEIGH DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 03/06/2013 12:00:00 AM | 6 | 5991339.0 | 2095700.0 | 37.7338949747581 | -122.472360557436 | (37.7338949747581, -122.472360557436) | |||
| 109166 | 109166 | 103947 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2363X 36th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5985162.60331 | 2099213.25819 | 37.74318203563929 | -122.49397275511299 | (37.7431820356393, -122.493972755113) | ||||
| 142588 | 142588 | 104374 | Undocumented 2 | Tree(s) :: 17 | 22 GARDENSIDE DR | 1 | Median : Yard 3 | Landscaping 2 | Private 1 | 50x50 | 5999468.0 | 2101996.0 | 37.7516494117124 | -122.444708626009 | (37.7516494117124, -122.444708626009) | ||||
| 113148 | 113148 | 104375 | Undocumented 2 | Tree(s) :: 17 | 30 GARDENSIDE DR | 1 | Median : Yard 3 | Landscaping 2 | Private 1 | 50x50 | 5999465.0 | 2102094.0 | 37.7519183246276 | -122.444726043725 | (37.7519183246276, -122.444726043725) | ||||
| 141372 | 141372 | 104398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 3525X Ulloa St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 5985120.1668300005 | 2098189.34613 | 37.7403681660846 | -122.494044040088 | (37.7403681660846, -122.494044040088) | ||||
| 141156 | 141156 | 104399 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2440X 37th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5984875.46821 | 2098521.80546 | 37.7412666886784 | -122.49491460561501 | (37.7412666886784, -122.494914605615) | |||||
| 110858 | 110858 | 104466 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | ||||
| 108451 | 108451 | 104499 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 44X SATURN ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6000456.0 | 2106003.0 | 37.7627079858093 | -122.44157952536999 | (37.7627079858093, -122.44157952537) | ||||
| 95383 | 95383 | 104500 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 SATURN ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 45 | 6000539.0 | 2106092.0 | 37.762957086281396 | -122.441298844913 | (37.7629570862814, -122.441298844913) | ||||
| 100517 | 100517 | 104502 | Private 5 | Pinus radiata :: Monterey Pine 3 | 30X SATURN ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6000456.0 | 2106003.0 | 37.7627079858093 | -122.44157952536999 | (37.7627079858093, -122.44157952537) | ||||
| 85176 | 85176 | 104920 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 750 Gonzalez Dr | 1 | Median : Yard 3 | Tree 1 | Private 1 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | |||||
| 101258 | 101258 | 104921 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 750 Gonzalez Dr | 2 | Median : Yard 3 | Tree 1 | Private 1 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | |||||
| 111624 | 111624 | 104922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 750 Gonzalez Dr | 3 | Median : Yard 3 | Tree 1 | Private 1 | missing? | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | ||||
| 144760 | 144760 | 104926 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Gonzalez Dr | 1 | Median : Yard 3 | Tree 1 | Private 1 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | |||||
| 143894 | 143894 | 104927 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Gonzalez Dr | 2 | Median : Yard 3 | Tree 1 | Private 1 | 10 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | ||||
| 128606 | 128606 | 104928 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Gonzalez Dr | 3 | Median : Yard 3 | Tree 1 | Private 1 | 12 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | ||||
| 140384 | 140384 | 104978 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 66X San Lorenzo Way | 1 | Median : Yard 3 | Tree 1 | Private 1 | Permit Number 770332 | 5993690.5 | 2097533.7 | 37.7390656757525 | -122.46436386193301 | (37.7390656757525, -122.464363861933) | ||||
| 115289 | 115289 | 105020 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101X ORD ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6000863.0 | 2105739.0 | 37.7620062865301 | -122.44015292861602 | (37.7620062865301, -122.440152928616) | ||||
| 97142 | 97142 | 105761 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2400X CASTRO ST | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | ||||
| 125646 | 125646 | 105762 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2400X CASTRO ST | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | ||||
| 77799 | 77799 | 105836 | DPW Maintained 3 | Araucaria heterophylla :: Norfolk Island Pine 24 | 2100X SLOAT BLVD | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5984309.0 | 2095832.0 | 37.733848030924 | -122.49667476772 | (37.733848030924, -122.49667476772) | ||||
| 144906 | 144906 | 105837 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100X SLOAT BLVD | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5984309.0 | 2095832.0 | 37.733848030924 | -122.49667476772 | (37.733848030924, -122.49667476772) | ||||
| 122322 | 122322 | 105909 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1864X 14TH AVE | 1 | Median : Yard 3 | Tree 1 | Rec/Park 3 | 14 | 5991829.0 | 2102804.0 | 37.7534290869332 | -122.47118388851999 | (37.7534290869332, -122.47118388852) | ||||
| 108704 | 108704 | 106057 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 140X CANYON DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6002713.0 | 2086188.2 | 37.708429419739794 | -122.432358106226 | (37.7084294197398, -122.432358106226) | ||||
| 10408 | 10408 | 106060 | DPW Maintained 3 | Calocedrus decurrens :: Incense Cedar 177 | 12X Canyon Dr | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6003183.55845 | 2086355.5239400002 | 37.7089155261884 | -122.430743733243 | (37.7089155261884, -122.430743733243) | ||||
| 11659 | 11659 | 106061 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 12X Canyon Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 6003256.93175 | 2086330.4794599998 | 37.7088509162175 | -122.430488359046 | (37.7088509162175, -122.430488359046) | ||||
| 95665 | 95665 | 106062 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 140X CANYON DR | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6002713.0 | 2086188.2 | 37.708429419739794 | -122.432358106226 | (37.7084294197398, -122.432358106226) | ||||
| 94540 | 94540 | 106114 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1752X DOLORES ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6005197.0 | 2098194.1 | 37.741535528464496 | -122.424626562024 | (37.7415355284645, -122.424626562024) | |||||
| 85292 | 85292 | 106578 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 101240 | 101240 | 106579 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 121315 | 121315 | 106581 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 95732 | 95732 | 106583 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 107987 | 107987 | 106584 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 108041 | 108041 | 106585 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 141868 | 141868 | 106586 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 125322 | 125322 | 106587 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 118789 | 118789 | 106592 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 115315 | 115315 | 106597 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 10203 | 10203 | 106598 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001X SAN JOSE AVE | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 101111 | 101111 | 106599 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 107740 | 107740 | 107644 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400x KIRKWOOD AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 6015822.8 | 2096363.1 | 37.7371023539668 | -122.38775811873998 | (37.7371023539668, -122.38775811874) | |||||
| 18076 | 18076 | 107933 | DPW Maintained 3 | Tree(s) :: 17 | 3098X Market St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5999920.0 | 2105144.0 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | |||||
| 123876 | 123876 | 107934 | DPW Maintained 3 | Tree(s) :: 17 | 3098X Market St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 5999920.0 | 2105144.0 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | |||||
| 79307 | 79307 | 107935 | DPW Maintained 3 | Tree(s) :: 17 | 1099X Market St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6009025.86197 | 2112294.38137 | 37.7804671773494 | -122.41238403194401 | (37.7804671773494, -122.412384031944) | |||||
| 142186 | 142186 | 107936 | DPW Maintained 3 | Tree(s) :: 17 | 3098X Market St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 5999920.0 | 2105144.0 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | |||||
| 113179 | 113179 | 108043 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD OFF RAMP | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 5985539.0 | 2095817.0 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | ||||
| 128096 | 128096 | 108044 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD OFF RAMP | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 99 | 5985539.0 | 2095817.0 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | ||||
| 106620 | 106620 | 108045 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD OFF RAMP | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 5985539.0 | 2095817.0 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | ||||
| 144456 | 144456 | 108046 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD ON RAMP | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 99 | 5985273.0 | 2095807.0 | 37.733835821368295 | -122.493340136435 | (37.7338358213683, -122.493340136435) | ||||
| 127178 | 127178 | 108238 | Undocumented 2 | Tree(s) :: 17 | 764x JUNIPERO SERRA BLVD | 1 | Median : Yard 3 | Tree 1 | Private 1 | 5991289.6 | 2092496.8 | 37.7250969308873 | -122.47229792145599 | (37.7250969308873, -122.472297921456) | |||||
| 84882 | 84882 | 108688 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1x MONTEZUMA ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6007361.0 | 2099793.0 | 37.7460477277002 | -122.417257445993 | (37.7460477277002, -122.417257445993) | ||||
| 109029 | 109029 | 108973 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 3485X SAN BRUNO AVE | 1 | Median : Yard 3 | Tree 1 | DPW for City Agency 10 | 6011510.0 | 2091910.0 | 37.724635221414 | -122.402356490066 | (37.724635221414, -122.402356490066) | |||||
| 118269 | 118269 | 109197 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | ||||
| 125797 | 125797 | 109198 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 86474 | 86474 | 109199 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 123401 | 123401 | 109201 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 83073 | 83073 | 109202 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 128009 | 128009 | 109203 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 85810 | 85810 | 109204 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 123260 | 123260 | 109205 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 105675 | 105675 | 109208 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 91226 | 91226 | 109209 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2401x CASTRO ST | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 86719 | 86719 | 109347 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 59x BURNSIDE AVE | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6001229.7 | 2095779.3 | 37.7346801948558 | -122.438171157158 | (37.7346801948558, -122.438171157158) | ||||
| 146161 | 146161 | 109674 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
| 109683 | 109683 | 109675 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
| 83234 | 83234 | 109676 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) |
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");