Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10134 | 10134 | 173877 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2651 San Jose Ave | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 3x3 | 5997397.0 | 2088796.0 | 37.7152869722449 | -122.450918658158 | (37.7152869722449, -122.450918658158) | ||||
10255 | 10255 | 112606 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Monument Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5999003.0 | 2105766.0 | 37.761974353511896 | -122.446587863076 | (37.7619743535119, -122.446587863076) | ||||
10256 | 10256 | 173933 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 Beacon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003193.0 | 2097540.0 | 37.739626138558705 | -122.43150902083299 | (37.7396261385587, -122.431509020833) | |||||
10549 | 10549 | 2290 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989540.89128 | 2088682.16282 | 37.714521528411495 | -122.478064194121 | (37.7145215284115, -122.478064194121) | |
10571 | 10571 | 19570 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 100ST | ||||||||
10618 | 10618 | 2271 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 14M | 5990752.82343 | 2088228.49759 | 37.71334614597279 | -122.47384223413499 | (37.7133461459728, -122.473842234135) | |||
10674 | 10674 | 19936 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
10701 | 10701 | 20452 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 495X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
10705 | 10705 | 19569 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 100ST | ||||||||
10816 | 10816 | 19910 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 120ST | ||||||||
10904 | 10904 | 19431 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X Sloat Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/13/2007 12:00:00 AM | 6 | 20 | 5987714.9376 | 2095926.0092 | 37.7343051218756 | -122.48490645815501 | (37.7343051218756, -122.484906458155) | ||
10938 | 10938 | 2269 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 14M | 5990714.96133 | 2088247.7727 | 37.7133968776506 | -122.473974502829 | (37.7133968776506, -122.473974502829) | |||
10949 | 10949 | 19933 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
11028 | 11028 | 2270 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 14M | 5990735.60667 | 2088236.9442599998 | 37.7133683412468 | -122.473902356505 | (37.7133683412468, -122.473902356505) | |||
11220 | 11220 | 19950 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
11591 | 11591 | 20428 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 485X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 40 | ||||||||
11826 | 11826 | 20419 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 453X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
11963 | 11963 | 2289 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989454.26944 | 2088678.0808599999 | 37.7145052920719 | -122.478363292437 | (37.7145052920719, -122.478363292437) | |
12151 | 12151 | 19869 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY33 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 25ST | ||||||||
12203 | 12203 | 2287 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989126.18342 | 2088688.6181299998 | 37.7145151729252 | -122.47949804711 | (37.7145151729252, -122.47949804711) | |
12480 | 12480 | 20434 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 485X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
12637 | 12637 | 19441 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300X Sloat Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 20 | 5986928.6035 | 2095895.7656 | 37.7341762495639 | -122.487622811763 | (37.7341762495639, -122.487622811763) | |||
12812 | 12812 | 19953 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
13158 | 13158 | 19753 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY15 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
13184 | 13184 | 20013 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY47 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 100ST | ||||||||
13268 | 13268 | 187627 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 88 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | |||||
13271 | 13271 | 187638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
13273 | 13273 | 20881 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1892X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2017 10:23:00 AM | 3 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | ||
13275 | 13275 | 187637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
13276 | 13276 | 20799 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1792X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2017 10:19:00 AM | 3 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.49540321629601 | (37.7535582155387, -122.495403216296) | |||
13278 | 13278 | 20803 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1792X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2017 10:15:00 AM | 3 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.49540321629601 | (37.7535582155387, -122.495403216296) | ||
13307 | 13307 | 187654 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 375 Woodside Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5997267.0 | 2099886.0 | 37.7457300260474 | -122.452167701039 | (37.7457300260474, -122.452167701039) | ||||
13314 | 13314 | 187669 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 554 Valley St | 1 | Median : Yard 3 | Tree 1 | Private 1 | 6002324.0 | 2099197.0 | 37.7441265828549 | -122.434632098307 | (37.7441265828549, -122.434632098307) | |||||
14158 | 14158 | 20429 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 485X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 30 | ||||||||
14206 | 14206 | 19813 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY24 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
14400 | 14400 | 19934 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
14425 | 14425 | 19694 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY7 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 12ST | ||||||||
14506 | 14506 | 20366 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
14521 | 14521 | 20280 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
14597 | 14597 | 20303 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 50X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
14923 | 14923 | 20430 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 485X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 30 | ||||||||
14992 | 14992 | 19932 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
15767 | 15767 | 19699 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 40ST | ||||||||
15771 | 15771 | 19908 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 120ST | ||||||||
15978 | 15978 | 19943 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
16086 | 16086 | 20423 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 453X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
16424 | 16424 | 19949 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 25ST | ||||||||
16454 | 16454 | 20294 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
16608 | 16608 | 19951 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
16721 | 16721 | 19947 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 25ST | ||||||||
16807 | 16807 | 106757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 36 | 6013321.202330001 | 2089752.82506 | 37.718812992515105 | -122.395944254446 | (37.7188129925151, -122.395944254446) | |||
16878 | 16878 | 19909 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 120ST | ||||||||
17092 | 17092 | 19978 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY45 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 30ST | ||||||||
17118 | 17118 | 11746 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Junipero Serra Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/03/2006 12:00:00 AM | 3 | 6X6 | 5991277.67104 | 2092671.80389 | 37.7255767576586 | -122.472351910013 | (37.7255767576586, -122.472351910013) | ||
17384 | 17384 | 16354 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 4-HOA | 5993443.33225 | 2095241.5642099997 | 37.7327577911269 | -122.465052016742 | (37.7327577911269, -122.465052016742) | |||
17468 | 17468 | 11748 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Junipero Serra Blvd | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991276.77165 | 2092652.88165 | 37.7255247498407 | -122.472353640304 | (37.7255247498407, -122.472353640304) | ||
17510 | 17510 | 23594 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 220X Vasquez Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5994483.09622 | 2099061.58793 | 37.7433065302734 | -122.461734198275 | (37.7433065302734, -122.461734198275) | |||
17727 | 17727 | 11703 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Junipero Serra Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991288.65534 | 2092789.2072 | 37.725899753665104 | -122.47232249319299 | (37.7258997536651, -122.472322493193) | ||
17929 | 17929 | 11710 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Junipero Serra Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991285.51963 | 2092735.44075 | 37.7257519428913 | -122.47232941528699 | (37.7257519428913, -122.472329415287) | ||
18087 | 18087 | 21247 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2401X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985051.1945321 | 2098862.1753589 | 37.7422115377949 | -122.49433209823401 | (37.7422115377949, -122.494332098234) | |||
18578 | 18578 | 29625 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991156.8644 | 2090780.0583900001 | 37.7203755006984 | -122.472631660317 | (37.7203755006984, -122.472631660317) | ||
18718 | 18718 | 21167 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5985027.9083074005 | 2099542.6271361 | 37.744078511576 | -122.49446276258301 | (37.744078511576, -122.494462762583) | |||
18889 | 18889 | 106642 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4540X 17TH ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5999139.0 | 2105833.0 | 37.762166086231204 | -122.446122313424 | (37.7621660862312, -122.446122313424) | ||||
19244 | 19244 | 20545 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
19606 | 19606 | 21428 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2692X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
19643 | 19643 | 21239 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2401X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985051.1945321 | 2098862.1753589 | 37.7422115377949 | -122.49433209823401 | (37.7422115377949, -122.494332098234) | |||
19685 | 19685 | 92559 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52905 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | |||
19930 | 19930 | 29624 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991155.39463 | 2090794.87778 | 37.720416106010795 | -122.472637820699 | (37.7204161060108, -122.472637820699) | ||
20248 | 20248 | 29611 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991160.04623 | 2090951.2024400001 | 37.72084560421371 | -122.47263313341499 | (37.7208456042137, -122.472633133415) | ||
20319 | 20319 | 11702 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Junipero Serra Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991290.07475 | 2092800.9455099998 | 37.7259320662922 | -122.47231844175501 | (37.7259320662922, -122.472318441755) | ||
20392 | 20392 | 106278 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | ||||
20621 | 20621 | 21114 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985004.6737667 | 2100227.1692458 | 37.745956718592794 | -122.494593556276 | (37.7459567185928, -122.494593556276) | |||
20640 | 20640 | 29609 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991172.14351 | 2091025.81173 | 37.7210511631493 | -122.472596754032 | (37.7210511631493, -122.472596754032) | ||
20801 | 20801 | 29578 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 400X Junipero Serra Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991374.0324099995 | 2094196.50916 | 37.729768794481004 | -122.472129887178 | (37.729768794481, -122.472129887178) | ||
21086 | 21086 | 23592 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X Vasquez Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994656.2966599995 | 2099224.9929400003 | 37.7437651683354 | -122.461147162215 | (37.7437651683354, -122.461147162215) | |||
21464 | 21464 | 23593 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 220X Vasquez Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994492.71955 | 2099073.95458 | 37.743341039961706 | -122.461701819996 | (37.7433410399617, -122.461701819996) | |||
21779 | 21779 | 29598 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/31/2014 08:52:00 AM | 3 | 5991178.77498 | 2091110.6465200002 | 37.7212844823864 | -122.472580013151 | (37.7212844823864, -122.472580013151) | |||
21913 | 21913 | 29618 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991164.47662 | 2090887.5563700001 | 37.720671104264 | -122.47261318107799 | (37.720671104264, -122.472613181078) | ||
22142 | 22142 | 8214 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2189X Funston Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992287.42413 | 2100535.51604 | 37.747226921486295 | -122.469433461595 | (37.7472269214863, -122.469433461595) | |||
22262 | 22262 | 29593 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991180.05944 | 2091153.1258900003 | 37.7214011945921 | -122.47257866867201 | (37.7214011945921, -122.472578668672) | ||
22920 | 22920 | 251148 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22923 | 22923 | 251152 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22924 | 22924 | 251154 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22925 | 22925 | 251150 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22926 | 22926 | 251147 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 113x Gladeview Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997915.0 | 2102038.0 | 37.7516759885035 | -122.450082102397 | (37.7516759885035, -122.450082102397) | ||||
22927 | 22927 | 251157 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22928 | 22928 | 251155 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22929 | 22929 | 251156 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22930 | 22930 | 251151 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22931 | 22931 | 251158 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22932 | 22932 | 251153 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22933 | 22933 | 251149 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22934 | 22934 | 251159 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
23006 | 23006 | 5050 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 6001979.62541 | 2098516.88417 | 37.7422395880754 | -122.43577421703002 | (37.7422395880754, -122.43577421703) | ||||
23021 | 23021 | 5047 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 6002007.86459 | 2098449.21717 | 37.7420553943514 | -122.43567173476002 | (37.7420553943514, -122.43567173476) | ||||
23079 | 23079 | 8464 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 8 | 6002427.515 | 2113723.6274 | 37.784019039174794 | -122.435313053048 | (37.7840190391748, -122.435313053048) | |||
23106 | 23106 | 5048 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 6002000.04243 | 2098472.35983 | 37.7421184943815 | -122.435700436623 | (37.7421184943815, -122.435700436623) | ||||
23130 | 23130 | 5046 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 6002013.964380001 | 2098440.0292 | 37.7420305128012 | -122.43564998647 | (37.7420305128012, -122.43564998647) | ||||
23272 | 23272 | 5052 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 6001966.9976699995 | 2098545.79058 | 37.742318241009606 | -122.43581994754999 | (37.7423182410096, -122.43581994755) | ||||
23275 | 23275 | 5049 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 39 | 6001985.29603 | 2098499.31047 | 37.7421916569134 | -122.43575335275101 | (37.7421916569134, -122.435753352751) |
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");