Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92 | 92 | 98091 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007129.633230001 | 2115568.12393 | 37.789349482642606 | -122.41917628075599 | (37.7893494826426, -122.419176280756) | ||
| 590 | 590 | 98625 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 6002285.2374 | 2120040.8430000003 | 37.8013564005351 | -122.43625752618999 | (37.8013564005351, -122.43625752619) | ||
| 1706 | 1706 | 192430 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 340 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | DPW for City Agency 2 | 9 | Width 3ft | 6011111.5516 | 2111334.7393 | 37.7779490450386 | -122.405101020214 | (37.7779490450386, -122.405101020214) | ||
| 1845 | 1845 | 98642 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6002233.86885 | 2120387.2869599997 | 37.8023047257379 | -122.436460093962 | (37.8023047257379, -122.436460093962) | ||
| 2181 | 2181 | 98628 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x4 | 6002274.71062 | 2120096.76485 | 37.801509349129795 | -122.43629795788999 | (37.8015093491298, -122.43629795789) | ||
| 2216 | 2216 | 122752 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 6011278.80569 | 2105286.3398 | 37.7613508668666 | -122.404096651066 | (37.7613508668666, -122.404096651066) | |||
| 2219 | 2219 | 122754 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 693 Vermont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 6011277.363419999 | 2105334.1858 | 37.761482160689894 | -122.404105006665 | (37.7614821606899, -122.404105006665) | |||
| 2231 | 2231 | 122750 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 6011285.1392 | 2105241.4016400003 | 37.761227830607204 | -122.40407158333299 | (37.7612278306072, -122.404071583333) | |||
| 2232 | 2232 | 122753 | DPW Maintained 3 | Podocarpus gracilor :: Fern Pine 13 | 693 Vermont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 15 | 6011277.810190001 | 2105311.62173 | 37.7614202297665 | -122.404101873421 | (37.7614202297665, -122.404101873421) | |||
| 2233 | 2233 | 122749 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 6011285.506709999 | 2105214.92948 | 37.761155164510605 | -122.404068449214 | (37.7611551645106, -122.404068449214) | |||
| 2240 | 2240 | 122755 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 693 Vermont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 6011274.22678 | 2105356.76628 | 37.7615439863765 | -122.40411744427601 | (37.7615439863765, -122.404117444276) | |||
| 2558 | 2558 | 98632 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x4 | 6002258.48202 | 2120196.40471 | 37.801782011886 | -122.43636125128799 | (37.801782011886, -122.436361251288) | ||
| 2613 | 2613 | 98090 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007144.43128 | 2115568.9527 | 37.7893525915946 | -122.419125139911 | (37.7893525915946, -122.419125139911) | ||
| 3431 | 3431 | 98631 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 4x4 | 6002262.16905 | 2120180.85898 | 37.801739536897294 | -122.436347379249 | (37.8017395368973, -122.436347379249) | ||
| 4107 | 4107 | 98607 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6002988.210519999 | 2116859.68166 | 37.792661671341705 | -122.43359745208599 | (37.7926616713417, -122.433597452086) | ||
| 4753 | 4753 | 98088 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007178.15894 | 2115574.08384 | 37.7893685797349 | -122.41900880992901 | (37.7893685797349, -122.419008809929) | ||
| 5294 | 5294 | 97730 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | Permit Number 50638 | 6005803.34745 | 2120703.57786 | 37.8033753605476 | -122.424130448959 | (37.8033753605476, -122.424130448959) | |
| 5471 | 5471 | 98637 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6002243.51572 | 2120296.51697 | 37.8020560434066 | -122.43642021082898 | (37.8020560434066, -122.436420210829) | ||
| 5496 | 5496 | 99696 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1451 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 6007201.17567 | 2117403.71838 | 37.794393599230204 | -122.41905900288799 | (37.7943935992302, -122.419059002888) | ||
| 5535 | 5535 | 98626 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 6x6 | 6002283.11168 | 2120054.94147 | 37.8013949904512 | -122.43626589165301 | (37.8013949904512, -122.436265891653) | ||
| 5546 | 5546 | 98615 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005320.03726 | 2118764.37328 | 37.798023501349505 | -122.42566486054 | (37.7980235013495, -122.42566486054) | ||
| 5696 | 5696 | 98622 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 6x6 | 6002297.34528 | 2119958.5907400004 | 37.8011312453645 | -122.436209738003 | (37.8011312453645, -122.436209738003) | ||
| 5699 | 5699 | 97727 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | Permit Number 50638 | 6005898.3389 | 2120719.3141099997 | 37.8034239311172 | -122.42380284664699 | (37.8034239311172, -122.423802846647) | |
| 5787 | 5787 | 98633 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6002258.36283 | 2120214.87059 | 37.801832707561495 | -122.43636298608801 | (37.8018327075615, -122.436362986088) | ||
| 5819 | 5819 | 99697 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1451 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6007296.6569 | 2117418.12417 | 37.794438530258 | -122.41872964778099 | (37.794438530258, -122.418729647781) | ||
| 5823 | 5823 | 98617 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005326.63971 | 2118722.15466 | 37.7979079528477 | -122.425639007743 | (37.7979079528477, -122.425639007743) | ||
| 5958 | 5958 | 98639 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 6002240.752780001 | 2120332.50299 | 37.8021546945469 | -122.436432348976 | (37.8021546945469, -122.436432348976) | ||
| 6105 | 6105 | 98613 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005313.74464 | 2118810.3056400004 | 37.798149264334604 | -122.42568990577601 | (37.7981492643346, -122.425689905776) | ||
| 6270 | 6270 | 98640 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6002237.13778 | 2120351.54005 | 37.8022067598879 | -122.43644622191002 | (37.8022067598879, -122.43644622191) | ||
| 6303 | 6303 | 98641 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6002235.030730001 | 2120370.79549 | 37.802259510526596 | -122.436454892273 | (37.8022595105266, -122.436454892273) | ||
| 6347 | 6347 | 98618 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005334.04674 | 2118673.6419900004 | 37.797775167941 | -122.42560992276199 | (37.797775167941, -122.425609922762) | ||
| 6478 | 6478 | 98738 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1150 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 3 | 4X4 | 6001885.6171 | 2112431.4484 | 37.780440254610205 | -122.43709527307301 | (37.7804402546102, -122.437095273073) | ||
| 6762 | 6762 | 98635 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 6002251.83785 | 2120250.68488 | 37.8019306734253 | -122.436388130233 | (37.8019306734253, -122.436388130233) | ||
| 6818 | 6818 | 98620 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005340.01128 | 2118634.45898 | 37.797667918390005 | -122.42558649363998 | (37.79766791839, -122.42558649364) | ||
| 6931 | 6931 | 98630 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6002266.09398 | 2120152.5833099997 | 37.8016621223571 | -122.436331772404 | (37.8016621223571, -122.436331772404) | ||
| 6975 | 6975 | 98619 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005336.89801 | 2118653.3555400004 | 37.7977196276222 | -122.425598612003 | (37.7977196276222, -122.425598612003) | ||
| 6980 | 6980 | 98636 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 6x6 | 6002249.0569400005 | 2120273.69699 | 37.8019937006086 | -122.436399401415 | (37.8019937006086, -122.436399401415) | ||
| 7173 | 7173 | 98621 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005341.92436 | 2118613.95929 | 37.797611739554 | -122.42557841412399 | (37.797611739554, -122.425578414124) | ||
| 7261 | 7261 | 98606 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 4.5x4.5 | 6003043.17178 | 2116866.41104 | 37.7926832667819 | -122.43340776527398 | (37.7926832667819, -122.433407765274) | ||
| 7275 | 7275 | 98612 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005312.4459 | 2118826.60748 | 37.7981939516456 | -122.42569556069598 | (37.7981939516456, -122.425695560696) | ||
| 7339 | 7339 | 97732 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | Permit Number 50638 | 6005757.30775 | 2120698.05289 | 37.8033575908394 | -122.424289378073 | (37.8033575908394, -122.424289378073) | |
| 7387 | 7387 | 98089 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007160.90241 | 2115572.1732 | 37.789362361841505 | -122.41906838009899 | (37.7893623618415, -122.419068380099) | ||
| 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) | |
| 7476 | 7476 | 98608 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6002968.64851 | 2116857.31006 | 37.7926540495901 | -122.433664967757 | (37.7926540495901, -122.433664967757) | ||
| 7587 | 7587 | 98602 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6003137.34298 | 2116882.04608 | 37.792731538790704 | -122.433083047059 | (37.7927315387907, -122.433083047059) | ||
| 7724 | 7724 | 98603 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6003120.0075900005 | 2116875.00163 | 37.7927112131931 | -122.433142524628 | (37.7927112131931, -122.433142524628) | ||
| 7814 | 7814 | 98604 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6003077.63265 | 2116870.32542 | 37.792695969686 | -122.43328880923401 | (37.792695969686, -122.433288809234) | ||
| 7989 | 7989 | 97733 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1150 Francisco St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | Permit Number 50638 | 6005736.8865 | 2120695.23683 | 37.8033487055393 | -122.42435984622801 | (37.8033487055393, -122.424359846228) | |
| 8022 | 8022 | 98629 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 6x6 | 6002271.7566599995 | 2120123.5232700002 | 37.8015826528763 | -122.43631009602801 | (37.8015826528763, -122.436310096028) | ||
| 8207 | 8207 | 98634 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6002253.74096 | 2120233.67924 | 37.8018840885493 | -122.436380326794 | (37.8018840885493, -122.436380326794) | ||
| 8255 | 8255 | 98623 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 6x6 | 6002295.23154 | 2119980.02637 | 37.80118998188 | -122.43621858733299 | (37.80118998188, -122.436218587333) | ||
| 8363 | 8363 | 97734 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | Permit Number 50638 | 6005715.837730001 | 2120693.51258 | 37.8033427825912 | -122.424432563629 | (37.8033427825912, -122.424432563629) | |
| 8365 | 8365 | 98605 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6003064.1459800005 | 2116869.6787900003 | 37.7926934290995 | -122.433335427386 | (37.7926934290995, -122.433335427386) | ||
| 8457 | 8457 | 98627 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 6x6 | 6002279.94472 | 2120071.20683 | 37.801439470916 | -122.43627801543998 | (37.801439470916, -122.43627801544) | ||
| 8576 | 8576 | 97728 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | Permit Number 50638 | 6005878.13407 | 2120716.4935 | 37.8034150458325 | -122.423872565669 | (37.8034150458325, -122.423872565669) | |
| 8784 | 8784 | 98624 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 6x6 | 6002286.82962 | 2120018.90884 | 37.801296265561 | -122.436250445798 | (37.801296265561, -122.436250445798) | ||
| 8790 | 8790 | 105143 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 432 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | DPW for City Agency 2 | 3 | 4x4 | 6005556.0703 | 2110851.1612 | 37.776309122873705 | -122.42428501193301 | (37.7763091228737, -122.424285011933) | ||
| 8823 | 8823 | 98616 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005322.90286 | 2118744.78417 | 37.7979698765663 | -122.425653549774 | (37.7979698765663, -122.425653549774) | ||
| 8829 | 8829 | 98614 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005316.8578699995 | 2118791.40908 | 37.7980975551137 | -122.425677787418 | (37.7980975551137, -122.425677787418) | ||
| 8881 | 8881 | 97729 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1150 Francisco St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | Permit Number 50638 | 6005819.00921 | 2120706.70735 | 37.80338483759171 | -122.42407647347099 | (37.8033848375917, -122.424076473471) | |
| 9734 | 9734 | 173682 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 450x Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6008515.0 | 2088365.0 | 37.71473375007071 | -122.41245939537501 | (37.7147337500707, -122.412459395375) | |||
| 9739 | 9739 | 173683 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 450x Raymond Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6008515.0 | 2088365.0 | 37.71473375007071 | -122.41245939537501 | (37.7147337500707, -122.412459395375) | |||
| 10863 | 10863 | 99498 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 125 Excelsior Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6002794.02408 | 2092508.7984200001 | 37.725788983259605 | -122.432529234659 | (37.7257889832596, -122.432529234659) | ||
| 14458 | 14458 | 94035 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1300X Lane St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 32 | 5x5 | 6015684.8669 | 2095240.1882 | 37.7340114236329 | -122.388156677838 | (37.7340114236329, -122.388156677838) | ||
| 15674 | 15674 | 94034 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1300X Lane St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 6015674.4242 | 2095246.7836 | 37.7340289546749 | -122.388193241926 | (37.7340289546749, -122.388193241926) | ||
| 16453 | 16453 | 96769 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 1 | 4x4 | 6015646.9436 | 2095179.7309 | 37.7338433188148 | -122.388283573512 | (37.7338433188148, -122.388283573512) | ||
| 17867 | 17867 | 98680 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 24331 | 24331 | 116062 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2100x 19th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 22 | 3x3 | 6011361.02056 | 2105129.82914 | 37.7609257168785 | -122.40380128939199 | (37.7609257168785, -122.403801289392) | ||
| 24594 | 24594 | 115551 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 18x7 | 6015277.41921 | 2104189.44931 | 37.7585616474178 | -122.39019037219299 | (37.7585616474178, -122.390190372193) | ||
| 25232 | 25232 | 116051 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Kansas St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 4x4 | 6011500.28754 | 2105307.1354099996 | 37.761420339490705 | -122.40333209689699 | (37.7614203394907, -122.403332096897) | ||
| 29352 | 29352 | 110960 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 5x5 | 6008419.49323 | 2119686.5094 | 37.8007301081687 | -122.415005118088 | (37.8007301081687, -122.415005118088) | ||
| 30215 | 30215 | 116049 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 650x Kansas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 4x4 | 6011498.3385 | 2105356.0244 | 37.761554468880206 | -122.403342277248 | (37.7615544688802, -122.403342277248) | ||
| 33468 | 33468 | 95148 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 5988724.779619999 | 2113566.5271900003 | 37.78279998730721 | -122.482707449869 | (37.7827999873072, -122.482707449869) | |||
| 35622 | 35622 | 116053 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650x Kansas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 4x4 | 6011508.109619999 | 2105241.51829 | 37.761240606399795 | -122.40330042728901 | (37.7612406063998, -122.403300427289) | ||
| 41129 | 41129 | 95156 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 21 | 5988717.78601 | 2113765.0163 | 37.7833445754979 | -122.48274619510799 | (37.7833445754979, -122.482746195108) | |||
| 41571 | 41571 | 95149 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 15 | 5988721.12033 | 2113580.3815900004 | 37.7828378146839 | -122.48272112492901 | (37.7828378146839, -122.482721124929) | |||
| 46599 | 46599 | 97073 | DPW Maintained 3 | Tree(s) :: 17 | 1551 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | ||
| 46988 | 46988 | 116060 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100x 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7 | 3x3 | 6011408.71891 | 2105130.5396 | 37.7609303321981 | -122.403636370817 | (37.7609303321981, -122.403636370817) | ||
| 55870 | 55870 | 108611 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2025x Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 1 | 3x3 | 6008581.83386 | 2119799.52206 | 37.8010495338737 | -122.414451351572 | (37.8010495338737, -122.414451351572) | ||
| 58238 | 58238 | 116047 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 650x Kansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 5x12 | 6011496.1211 | 2105415.8281900003 | 37.761718552879 | -122.403354153666 | (37.761718552879, -122.403354153666) | ||
| 60314 | 60314 | 95147 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 13 | 5988726.59645 | 2113538.2792 | 37.7827225319963 | -122.48269909375901 | (37.7827225319963, -122.482699093759) | |||
| 61694 | 61694 | 99372 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 499X 29th Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 3x3 | 5986859.5 | 2112566.5 | 37.7799454996166 | -122.48908690310101 | (37.7799454996166, -122.489086903101) | ||
| 63647 | 63647 | 95150 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 5988721.361169999 | 2113591.74757 | 37.7828690364709 | -122.482721124926 | (37.7828690364709, -122.482721124926) | |||
| 64195 | 64195 | 116061 | Undocumented 2 | Melaleuca spp :: Melaleuca spp 130 | 2100x 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 3x3 | 6011385.89017 | 2105128.48272 | 37.7609234092204 | -122.403715181115 | (37.7609234092204, -122.403715181115) | ||
| 65849 | 65849 | 116063 | Undocumented 2 | Brachychiton discolor :: 440 | 2100x 19th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 19 | 3x3 | 6011332.66531 | 2105125.78364 | 37.760913024731295 | -122.403899073603 | (37.7609130247313, -122.403899073603) | ||
| 67897 | 67897 | 110959 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 5x5 | 6008435.0253800005 | 2119688.1206900002 | 37.800735405160296 | -122.414951484348 | (37.8007354051603, -122.414951484348) | ||
| 70878 | 70878 | 95154 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 5988718.8555 | 2113711.8550400003 | 37.783198671909794 | -122.48273859805 | (37.7831986719098, -122.48273859805) | |||
| 72161 | 72161 | 99692 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1550X Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 2x2 | 6007274.7 | 2117123.2 | 37.7936275055362 | -122.41878469564101 | (37.7936275055362, -122.418784695641) | ||
| 72275 | 72275 | 110957 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 5x5 | 6008462.007069999 | 2119690.6551900003 | 37.800743880377205 | -122.41485829568998 | (37.8007438803772, -122.41485829569) | ||
| 73832 | 73832 | 110956 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7 | 5x5 | 6008474.06115 | 2119692.72385 | 37.800750237701294 | -122.414816729923 | (37.8007502377013, -122.414816729923) | ||
| 77312 | 77312 | 96772 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6015407.2 | 2095381.5 | 37.73438404885479 | -122.38912652987801 | (37.7343840488548, -122.389126529878) | ||
| 77569 | 77569 | 98569 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301X Francisco St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 77788 | 77788 | 98940 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400X San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6011147.5 | 2101806.3 | 37.7517881116631 | -122.40430583648501 | (37.7517881116631, -122.404305836485) | ||
| 77797 | 77797 | 116382 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2501 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | DPW for City Agency 2 | 3x3 | 6011435.88896489 | 2101815.42613948 | 37.7518292809831 | -122.403309184671 | (37.7518292809831, -122.403309184671) | |||
| 77873 | 77873 | 99668 | DPW Maintained 3 | Tree(s) :: 17 | 150X Alma St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
| 77973 | 77973 | 95480 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5986567.36684 | 2111939.07455 | 37.7782057127303 | -122.490051346189 | (37.7782057127303, -122.490051346189) | ||
| 78146 | 78146 | 95448 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986572.26887 | 2111788.56268 | 37.777792736173794 | -122.49002331517599 | (37.7777927361738, -122.490023315176) | ||
| 78240 | 78240 | 99345 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 30th Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 4x4 | 5986571.27659 | 2113136.01167 | 37.7814923890114 | -122.490125885703 | (37.7814923890114, -122.490125885703) | ||
| 78641 | 78641 | 116976 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 7 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 79218 | 79218 | 99026 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351X 23rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | Permit Number 41415 | 6006571.0 | 2102346.4 | 37.753014305467794 | -122.420170352411 | (37.7530143054678, -122.420170352411) |
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");