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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
113837 | 113837 | 116669 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Esmeralda Ave | 6 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 20 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | ||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
1822 | 1822 | 251717 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000X San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004710.0 | 2096486.0 | 37.736817957153605 | -122.426188866367 | (37.7368179571536, -122.426188866367) | |||||
67961 | 67961 | 206836 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100x Idora Ave | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 66 | Width 9ft | 5995604.17085 | 2099350.4744700002 | 37.7441642119029 | -122.45787873812799 | (37.7441642119029, -122.457878738128) | |||
187642 | 187642 | 206837 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100x Idora Ave | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 63 | Width 9ft | 5995840.17489 | 2099294.03492 | 37.7440227989188 | -122.45705861128401 | (37.7440227989188, -122.457058611284) | |||
102194 | 102194 | 101037 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1010X Portola Dr | 11 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||||
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 | ||||||||
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 | ||||||||
32031 | 32031 | 190995 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 10x Cashmere St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6017237.22965 | 2095860.87095 | 37.7358015834667 | -122.38283280631599 | (37.7358015834667, -122.382832806316) | ||||
142607 | 142607 | 11185 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 110 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 5995900.4612004 | 2099322.604417 | 37.744104705607704 | -122.45685222203001 | (37.7441047056077, -122.45685222203) | |||
7419 | 7419 | 97731 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1150 Francisco St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | Permit Number 50638 | 6005778.11415 | 2120709.05822 | 37.803388983478605 | -122.42421815984501 | (37.8033889834786, -122.424218159845) | |
24947 | 24947 | 206807 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 11x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5991689.221530001 | 2095992.9314700002 | 37.734719554257296 | -122.471171081279 | (37.7347195542573, -122.471171081279) | ||||
158032 | 158032 | 206808 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 11x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 5991782.03455 | 2095997.5477200001 | 37.734737597362205 | -122.470850534124 | (37.7347375973622, -122.470850534124) | ||||
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) | |||
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) | ||
173128 | 173128 | 185117 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200x Sloat Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 5987506.2336 | 2095918.1597 | 37.7342714110431 | -122.485627430105 | (37.7342714110431, -122.485627430105) | |||
181042 | 181042 | 186841 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200x Sunset Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 5984746.1314 | 2106971.8455 | 37.764460596444295 | -122.495985031222 | (37.7644605964443, -122.495985031222) | |||
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) | |||
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) | |||
79366 | 79366 | 20549 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
85580 | 85580 | 20539 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
94781 | 94781 | 20541 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
96354 | 96354 | 20544 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
96636 | 96636 | 20528 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
96863 | 96863 | 20540 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
102455 | 102455 | 20538 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
108770 | 108770 | 20531 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
111174 | 111174 | 20524 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
115048 | 115048 | 20527 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
115611 | 115611 | 20542 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
116613 | 116613 | 20526 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
127519 | 127519 | 20547 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
139297 | 139297 | 20530 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
142008 | 142008 | 20523 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
146309 | 146309 | 20535 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
25946 | 25946 | 126425 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1306x Montgomery St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 6011438.821769999 | 2120037.4711599997 | 37.8018629670555 | -122.40458165273701 | (37.8018629670555, -122.404581652737) | |||
39759 | 39759 | 126424 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1306x Montgomery St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6011439.456040001 | 2120033.94187 | 37.801853311934096 | -122.404579209268 | (37.8018533119341, -122.404579209268) | |||
38782 | 38782 | 139327 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1350x GEARY BLVD | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 6005396.3086 | 2114138.3218 | 37.785325835852795 | -122.425071614426 | (37.7853258358528, -122.425071614426) | |||
54250 | 54250 | 139328 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1350x GEARY BLVD | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6005318.1985 | 2114131.1202 | 37.7853016493854 | -122.42534133927 | (37.7853016493854, -122.42534133927) | |||
72905 | 72905 | 139357 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1350x GEARY BLVD | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 0ft | 6005019.8844 | 2114088.1873 | 37.785166908017004 | -122.426370358064 | (37.785166908017, -122.426370358064) | |||
90982 | 90982 | 20574 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1392X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984737.8310875995 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | |||
99122 | 99122 | 20576 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1392X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | 5984737.8310875995 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | |||
99295 | 99295 | 20577 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1392X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984737.8310875995 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | |||
117082 | 117082 | 20566 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1392X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984737.8310875995 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | |||
9916 | 9916 | 173733 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 14 Richland Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 3x3 | 6004601.0 | 2096122.0 | 37.7358123337564 | -122.426539816145 | (37.7358123337564, -122.426539816145) | ||||
84848 | 84848 | 20592 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984800.4502922995 | 2105635.4093669 | 37.760794298851295 | -122.495698574627 | (37.7607942988513, -122.495698574627) | |||
84860 | 84860 | 20603 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984800.4502922995 | 2105635.4093669 | 37.760794298851295 | -122.495698574627 | (37.7607942988513, -122.495698574627) | |||
120013 | 120013 | 20593 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984800.4502922995 | 2105635.4093669 | 37.760794298851295 | -122.495698574627 | (37.7607942988513, -122.495698574627) | |||
141352 | 141352 | 109893 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1408x SUNSET BLVD | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 3x3 | 5984818.0 | 2105324.0 | 37.7599402834086 | -122.49561490918 | (37.7599402834086, -122.49561490918) | |||
127498 | 127498 | 11191 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 148 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 5995624.0655798 | 2099382.6906533 | 37.7442538125131 | -122.457812277707 | (37.7442538125131, -122.457812277707) | |||
66637 | 66637 | 20618 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1492X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984803.7392562 | 2105036.6950477003 | 37.759150589029495 | -122.495643037613 | (37.7591505890295, -122.495643037613) | |||
85885 | 85885 | 20639 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1492X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984803.7392562 | 2105036.6950477003 | 37.759150589029495 | -122.495643037613 | (37.7591505890295, -122.495643037613) | |||
93133 | 93133 | 20621 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1492X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984803.7392562 | 2105036.6950477003 | 37.759150589029495 | -122.495643037613 | (37.7591505890295, -122.495643037613) | |||
94819 | 94819 | 20619 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1492X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 60 | 5984803.7392562 | 2105036.6950477003 | 37.759150589029495 | -122.495643037613 | (37.7591505890295, -122.495643037613) | |||
104956 | 104956 | 20637 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1492X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984803.7392562 | 2105036.6950477003 | 37.759150589029495 | -122.495643037613 | (37.7591505890295, -122.495643037613) | |||
129401 | 129401 | 20638 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1492X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984803.7392562 | 2105036.6950477003 | 37.759150589029495 | -122.495643037613 | (37.7591505890295, -122.495643037613) | |||
140332 | 140332 | 20627 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1492X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984803.7392562 | 2105036.6950477003 | 37.759150589029495 | -122.495643037613 | (37.7591505890295, -122.495643037613) | |||
4098 | 4098 | 8400 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6003921.0381 | 2113941.5724 | 37.7847021645415 | -122.430161561145 | (37.7847021645415, -122.430161561145) | |||
4214 | 4214 | 8397 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6004036.9348 | 2113953.0096 | 37.7847401317276 | -122.42976141314301 | (37.7847401317276, -122.429761413143) | |||
6096 | 6096 | 8399 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6003960.687000001 | 2113944.6223 | 37.7847127843654 | -122.430024606782 | (37.7847127843654, -122.430024606782) | |||
6510 | 6510 | 8398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6003997.2859 | 2113948.4347 | 37.784725324941604 | -122.429898258777 | (37.7847253249416, -122.429898258777) | |||
6794 | 6794 | 8396 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/1994 12:00:00 AM | 6 | 8 | 6004125.3824 | 2113965.9717 | 37.7847807304874 | -122.429456338379 | (37.7847807304874, -122.429456338379) | ||
7230 | 7230 | 8401 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6003886.7265 | 2113933.9476 | 37.7846792853457 | -122.43027972368401 | (37.7846792853457, -122.430279723684) | |||
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) |
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");