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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
129 | 129 | 20398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
618 | 618 | 20377 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
886 | 886 | 19568 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 100ST | ||||||||
1098 | 1098 | 251438 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501X Santiago St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
1898 | 1898 | 20392 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
5557 | 5557 | 20407 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 52 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
5855 | 5855 | 19776 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY18 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
6006 | 6006 | 20312 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 101X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
6023 | 6023 | 19905 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 120ST | ||||||||
6115 | 6115 | 20296 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
6147 | 6147 | 19906 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 120ST | ||||||||
6357 | 6357 | 20291 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
6360 | 6360 | 20424 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 453X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
6399 | 6399 | 20412 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 453X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
6517 | 6517 | 19907 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 120ST | ||||||||
6533 | 6533 | 19565 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | -11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 100ST | ||||||||
6834 | 6834 | 19955 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2ST | ||||||||
6952 | 6952 | 19935 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
7006 | 7006 | 20417 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 453X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
7548 | 7548 | 20317 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 101X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
7732 | 7732 | 19948 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 25ST | ||||||||
7886 | 7886 | 19945 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
7938 | 7938 | 19700 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 40ST | ||||||||
8196 | 8196 | 20297 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
8406 | 8406 | 20373 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
8739 | 8739 | 20365 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
8750 | 8750 | 20413 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 453X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
8903 | 8903 | 19566 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | -9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 100ST | ||||||||
9072 | 9072 | 19804 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY22 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 20 | ||||||||
9473 | 9473 | 20455 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 495X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
9584 | 9584 | 20422 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 453X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
77993 | 77993 | 12500 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X Lake Merced Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | |||
90329 | 90329 | 12501 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X Lake Merced Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | |||
91431 | 91431 | 12502 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X Lake Merced Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | |||
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) | |||
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) | |||
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) | |||
149883 | 149883 | 2256 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 5990689.72825 | 2088261.00769 | 37.7134317560555 | -122.47406268136801 | (37.7134317560555, -122.474062681368) | ||||
186596 | 186596 | 2255 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 5990660.02895 | 2088282.4204099998 | 37.713488829713796 | -122.474166893001 | (37.7134888297138, -122.474166893001) | ||||
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) | |
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) | |
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) | |
184827 | 184827 | 176107 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 46 | Median : Cutout 11 | Tree 1 | DPW 2 | 61 | Width 0ft | 6008982.60232 | 2089910.3513099998 | 37.7190031946297 | -122.41095224595699 | (37.7190031946297, -122.410952245957) | |||
40380 | 40380 | 176106 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6009144.0469 | 2089931.11882 | 37.719069269612206 | -122.410395658243 | (37.7190692696122, -122.410395658243) | |||
148568 | 148568 | 176105 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 105 | Width 0ft | 6009225.48687 | 2089982.90412 | 37.7192160263732 | -122.41011780460899 | (37.7192160263732, -122.410117804609) | |||
58718 | 58718 | 22877 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 951X Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3X100 | 6009106.075933999 | 2090003.4402518997 | 37.7192657205166 | -122.410532013931 | (37.7192657205166, -122.410532013931) | |||
113957 | 113957 | 22878 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 951X Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1992 12:00:00 AM | 3 | 3X100 | 6009106.075933999 | 2090003.4402518997 | 37.7192657205166 | -122.410532013931 | (37.7192657205166, -122.410532013931) | ||
176077 | 176077 | 176104 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6009423.2681599995 | 2090026.7428 | 37.7193474820922 | -122.409437239052 | (37.7193474820922, -122.409437239052) | |||
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) | ||||
82353 | 82353 | 109678 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 7 | 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) | |||||
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) | |||||
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) | ||||
141517 | 141517 | 109677 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
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) | |||||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | |||
78166 | 78166 | 111586 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | ||||
89354 | 89354 | 111589 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | Permit Number 774260 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | |||
92075 | 92075 | 111588 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | |||
142323 | 142323 | 111587 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | ||||
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) | ||
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) |
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");