Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 78112 | 78112 | 99445 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601X 15th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5991576.7 | 2104258.5 | 37.7574081656565 | -122.472162400604 | (37.7574081656565, -122.472162400604) | |||||
| 83636 | 83636 | 99447 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601X 15th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 5991576.7 | 2104258.5 | 37.7574081656565 | -122.472162400604 | (37.7574081656565, -122.472162400604) | |||||
| 99046 | 99046 | 99444 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5991576.7 | 2104258.5 | 37.7574081656565 | -122.472162400604 | (37.7574081656565, -122.472162400604) | |||||
| 108645 | 108645 | 99448 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601X 15th Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 5991576.7 | 2104258.5 | 37.7574081656565 | -122.472162400604 | (37.7574081656565, -122.472162400604) | |||||
| 121873 | 121873 | 99446 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601X 15th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5991576.7 | 2104258.5 | 37.7574081656565 | -122.472162400604 | (37.7574081656565, -122.472162400604) | |||||
| 164549 | 164549 | 206889 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1646x 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 3ft | 5991480.90681 | 2104023.08965 | 37.7567562467267 | -122.472476526376 | (37.7567562467267, -122.472476526376) | |||
| 5090 | 5090 | 253789 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991453.0 | 2104016.0 | 37.756735165128205 | -122.47257252055401 | (37.7567351651282, -122.472572520554) | ||||
| 5101 | 5101 | 253790 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651X 15th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991453.0 | 2104016.0 | 37.756735165128205 | -122.47257252055401 | (37.7567351651282, -122.472572520554) | ||||
| 138140 | 138140 | 206890 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651x 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 3ft | 5991488.45245 | 2104026.5026700003 | 37.756766054720295 | -122.47245067984801 | (37.7567660547203, -122.472450679848) | |||
| 5083 | 5083 | 253786 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1675X 15th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
| 5102 | 5102 | 253784 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1709X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991403.0 | 2103783.0 | 37.756092514171904 | -122.472728448949 | (37.7560925141719, -122.472728448949) | ||||
| 4399 | 4399 | 8467 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6002321.2505 | 2113708.7369 | 37.783972118374 | -122.435679623339 | (37.783972118374, -122.435679623339) | |||
| 4512 | 4512 | 8466 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6002359.1538 | 2113715.5053 | 37.7839928555225 | -122.435548976348 | (37.7839928555225, -122.435548976348) | |||
| 5929 | 5929 | 8470 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6002187.2355 | 2113695.2 | 37.7839273365059 | -122.43614229642701 | (37.7839273365059, -122.436142296427) | |||
| 6463 | 6463 | 8468 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6002285.3778 | 2113701.9684 | 37.7839514961521 | -122.435803245129 | (37.7839514961521, -122.435803245129) | |||
| 6721 | 6721 | 8476 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 6001756.762999999 | 2113633.6072 | 37.783733752237 | -122.437627157513 | (37.783733752237, -122.437627157513) | |||
| 8647 | 8647 | 8473 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 6001933.4192 | 2113657.2968 | 37.7838088404542 | -122.437017691332 | (37.7838088404542, -122.437017691332) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 106203 | 106203 | 23597 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X Vasquez Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 40 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
| 118670 | 118670 | 23595 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X Vasquez Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5994508.862234999 | 2099085.9891 | 37.7433750129667 | -122.461646875513 | (37.7433750129667, -122.461646875513) | |||
| 503 | 503 | 8533 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6001504.6387 | 2113566.4305 | 37.783534963845 | -122.43849459602801 | (37.783534963845, -122.438494596028) | |||
| 815 | 815 | 8534 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001381.7916 | 2113512.2830000003 | 37.78337929999999 | -122.43891571692801 | (37.7833793, -122.438915716928) | ||
| 8879 | 8879 | 8531 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6001578.5839 | 2113601.7956 | 37.783636273313604 | -122.43824130906401 | (37.7836362733136, -122.438241309064) | |||
| 90449 | 90449 | 8221 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100X Funston Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992292.4750795 | 2101127.8707395 | 37.748853667046106 | -122.46945910791901 | (37.7488536670461, -122.469459107919) | |||
| 95966 | 95966 | 8220 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100X Funston Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992292.4750795 | 2101127.8707395 | 37.748853667046106 | -122.46945910791901 | (37.7488536670461, -122.469459107919) | |||
| 105287 | 105287 | 105889 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2150X 09TH AVE | 11 | Median : Cutout 11 | Tree 1 | Private 1 | 03/21/2014 12:00:00 AM | 40 | 5993666.0 | 2101247.0 | 37.7492600480712 | -122.46471814740102 | (37.7492600480712, -122.464718147401) | |||
| 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) | |||
| 1561 | 1561 | 8580 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/01/1994 12:00:00 AM | 6 | 6 | 6000778.3855 | 2113430.8926 | 37.783121473536795 | -122.44099741813 | (37.7831214735368, -122.44099741813) | ||
| 1776 | 1776 | 8585 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/01/1994 12:00:00 AM | 6 | 6 | 6000465.007 | 2113386.3901 | 37.78298142730029 | -122.442078382069 | (37.7829814273003, -122.442078382069) | ||
| 5633 | 5633 | 8583 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 6000590.222999999 | 2113406.0186 | 37.7830424571155 | -122.441646596602 | (37.7830424571155, -122.441646596602) | |||
| 6839 | 6839 | 8584 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 6000533.0297 | 2113398.5733 | 37.7830187554699 | -122.441843926918 | (37.7830187554699, -122.441843926918) | |||
| 7140 | 7140 | 8579 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6000836.5941 | 2113437.661 | 37.7831433729932 | -122.440796526182 | (37.7831433729932, -122.440796526182) | |||
| 185443 | 185443 | 142131 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200x GEARY BLVD | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6000333.6993 | 2113366.7616 | 37.7829200486713 | -122.442531241518 | (37.7829200486713, -122.442531241518) | |||
| 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) | |||
| 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) | |||
| 105313 | 105313 | 110264 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 220x CASHMERE ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5x40 | 6015982.5 | 2095938.0 | 37.735943960522796 | -122.38717631599701 | (37.7359439605228, -122.387176315997) | ||||
| 41855 | 41855 | 205878 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2270x 09th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 3ft | 5993161.62229 | 2100566.3961 | 37.747362192108795 | -122.46641282052 | (37.7473621921088, -122.46641282052) | |||
| 110448 | 110448 | 15988 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 236 Moncada Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 35M | 5992398.75579 | 2093455.53191 | 37.7277935021904 | -122.468533444909 | (37.7277935021904, -122.468533444909) | |||
| 2531 | 2531 | 8603 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 5999987.1554 | 2113318.7057 | 37.782768340075606 | -122.443726682203 | (37.7827683400756, -122.443726682203) | |||
| 7773 | 7773 | 8602 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 6000066.0077 | 2113328.1816 | 37.7827988555755 | -122.44345456827601 | (37.7827988555755, -122.443454568276) | |||
| 130519 | 130519 | 142132 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400x GEARY BLVD | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 46 | Width 0ft | 6000134.3689 | 2113338.3342 | 37.7828306302801 | -122.443218797439 | (37.7828306302801, -122.443218797439) | |||
| 8960 | 8960 | 8622 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2600 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999315.0497 | 2113216.8408 | 37.782450288182 | -122.44604454634701 | (37.782450288182, -122.446044546347) | |||
| 53249 | 53249 | 115326 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 86075 | 86075 | 115328 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 88444 | 88444 | 115331 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 89993 | 89993 | 21392 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | |||
| 95094 | 95094 | 115327 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 95571 | 95571 | 115323 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 95584 | 95584 | 115324 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 95694 | 95694 | 115330 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 105689 | 105689 | 115322 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 120822 | 120822 | 115325 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 138329 | 138329 | 115329 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 121496 | 121496 | 21457 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701X Sunset Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | |||
| 142101 | 142101 | 21456 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701X Sunset Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/11/2016 05:16:00 AM | 3 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | ||
| 8713 | 8713 | 8650 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5998245.1291 | 2113130.374 | 37.7821517178635 | -122.449739754186 | (37.7821517178635, -122.449739754186) | |||
| 129499 | 129499 | 138267 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800x GEARY BLVD | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5998264.7576 | 2113134.0967 | 37.782163062403704 | -122.44967211707899 | (37.7821630624037, -122.449672117079) | |||
| 176150 | 176150 | 138268 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800x GEARY BLVD | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | Width 0ft | 5998223.1317 | 2113127.3282 | 37.782142096338795 | -122.449815635357 | (37.7821420963388, -122.449815635357) | |||
| 39207 | 39207 | 186925 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800x Sunset Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 5985117.1657 | 2095920.8688 | 37.734139358467104 | -122.493887283293 | (37.7341393584671, -122.493887283293) | |||
| 88922 | 88922 | 21516 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801X Sunset Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/11/2016 05:13:00 AM | 3 | 5985158.491992299 | 2096224.0649069 | 37.7349742721437 | -122.49376674256901 | (37.7349742721437, -122.493766742569) | |||
| 89136 | 89136 | 99125 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 8 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 90362 | 90362 | 99136 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 19 | Median : Cutout 11 | Tree 1 | Private 1 | 36 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 96303 | 96303 | 99148 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 32 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 96326 | 96326 | 99151 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 35 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 96426 | 96426 | 99143 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 26 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 98538 | 98538 | 98820 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 28 | Median : Cutout 11 | Tree 1 | Private 1 | 05/09/2010 12:00:00 AM | Permit Number 768820 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | |||
| 103186 | 103186 | 99154 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 37 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 114310 | 114310 | 99153 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 41 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 115225 | 115225 | 99164 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 48 | Median : Cutout 11 | Tree 1 | Private 1 | 24 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 118159 | 118159 | 99144 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 27 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 119431 | 119431 | 99122 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 48 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 122205 | 122205 | 99146 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 30 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 138905 | 138905 | 99128 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 11 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 141458 | 141458 | 99133 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 16 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 141756 | 141756 | 99152 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 36 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 142441 | 142441 | 99120 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 121423 | 121423 | 96856 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 324X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 410x30 | 6008894.018569999 | 2095530.1163 | 37.73442890905461 | -122.4116553033 | (37.7344289090546, -122.4116553033) | |||
| 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) |
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");