Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCareAssistant, 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) | ||
| 463 | 463 | 234072 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 4 | Width 3ft | 6011140.67766 | 2101759.7310900004 | 37.7516598624171 | -122.404326151746 | (37.7516598624171, -122.404326151746) | ||
| 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) | ||
| 1400 | 1400 | 235284 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 4235 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/07/1990 12:00:00 AM | 11 | Width 3ft | 6001885.77275 | 2104671.54401 | 37.7591334867264 | -122.43653915428499 | (37.7591334867264, -122.436539154285) | ||
| 1405 | 1405 | 228661 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4235 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/07/1990 12:00:00 AM | 13 | Width 3ft | 6001838.07707 | 2104669.16217 | 37.7591242363206 | -122.436703937943 | (37.7591242363206, -122.436703937943) | ||
| 1407 | 1407 | 220312 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 4235 19th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 08/05/1995 12:00:00 AM | 15 | Width 3ft | 6002007.42492 | 2104678.29116 | 37.759158924972404 | -122.436118906483 | (37.7591589249724, -122.436118906483) | ||
| 1420 | 1420 | 228662 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4235 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/07/1990 12:00:00 AM | 16 | Width 3ft | 6001863.4982 | 2104671.44362 | 37.7591319452903 | -122.436616182999 | (37.7591319452903, -122.436616182999) | ||
| 1421 | 1421 | 228663 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4235 19th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 06/23/2015 07:36:00 AM | 2 | Width 3ft | 6001958.87793 | 2104675.64602 | 37.7591489038263 | -122.436286615639 | (37.7591489038263, -122.436286615639) | ||
| 1431 | 1431 | 220311 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 4235 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 08/05/1995 12:00:00 AM | 18 | Width 3ft | 6001938.02984 | 2104676.35813 | 37.7591496745354 | -122.436358769151 | (37.7591496745354, -122.436358769151) | ||
| 1449 | 1449 | 234076 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12 | Width 4ft | 6011147.1312 | 2101589.6307 | 37.751193164657 | -122.40429186329901 | (37.751193164657, -122.404291863299) | |||
| 1454 | 1454 | 234074 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 11 | Width 3ft | 6011143.5049 | 2101689.8522900003 | 37.751468148541996 | -122.40431145682301 | (37.751468148542, -122.404311456823) | |||
| 1461 | 1461 | 234073 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 17 | Width 3ft | 6011143.13167 | 2101723.71293 | 37.7515611015794 | -122.404315130536 | (37.7515611015794, -122.404315130536) | |||
| 1464 | 1464 | 234075 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 14 | Width 4ft | 6011146.17896 | 2101629.85029 | 37.75130354562771 | -122.404297986789 | (37.7513035456277, -122.404297986789) | |||
| 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) | ||
| 4367 | 4367 | 253150 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/11/2017 09:41:00 AM | 3 | 3x3 | 6003965.721940001 | 2090553.1315400002 | 37.7204855291627 | -122.42833943800899 | (37.7204855291627, -122.428339438009) | |
| 4558 | 4558 | 142520 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 7 | Width 0ft | 6009467.3323 | 2121175.1455 | 37.8048763586912 | -122.411484377145 | (37.8048763586912, -122.411484377145) | |||
| 4564 | 4564 | 142521 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 05/04/2013 12:00:00 AM | 0 | Width 0ft | 6009485.2617 | 2121177.5361 | 37.8048839283261 | -122.41142249927401 | (37.8048839283261, -122.411422499274) | ||
| 4565 | 4565 | 142525 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 301 FRANCISCO ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 23 | Width 0ft | 6009759.5801 | 2121214.59 | 37.8050010513122 | -122.410475804946 | (37.8050010513122, -122.410475804946) | |||
| 4568 | 4568 | 142545 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301 FRANCISCO ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 20 | Width 0ft | 6009562.3577 | 2121186.5007 | 37.80491286675579 | -122.41115633279499 | (37.8049128667558, -122.411156332795) | |||
| 4570 | 4570 | 142547 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301 FRANCISCO ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 20 | Width 0ft | 6009612.5597 | 2121193.6724 | 37.804935373675605 | -122.41098310943799 | (37.8049353736756, -122.410983109438) | |||
| 4571 | 4571 | 142549 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 9 | Width 0ft | 6009666.9453 | 2121202.0395 | 37.8049613971858 | -122.41079549257799 | (37.8049613971858, -122.410795492578) | |||
| 4573 | 4573 | 142546 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/26/2016 09:47:00 AM | 23 | Width 0ft | 6009592.8375 | 2121191.8795 | 37.8049293448711 | -122.411051233847 | (37.8049293448711, -122.411051233847) | ||
| 4581 | 4581 | 142526 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | Width 0ft | 6009810.3798 | 2121222.957 | 37.8050268727325 | -122.410300597206 | (37.8050268727325, -122.410300597206) | |||
| 4583 | 4583 | 142550 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/26/2016 09:53:00 AM | 22 | Width 0ft | 6009784.6811 | 2121219.3711 | 37.805015586162796 | -122.41038927752199 | (37.8050155861628, -122.410389277522) | ||
| 4590 | 4590 | 142522 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | Width 0ft | 6009689.0581 | 2121206.8206 | 37.804975764730294 | -122.410719306308 | (37.8049757647303, -122.410719306308) | |||
| 4591 | 4591 | 142544 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/23/2016 02:55:00 PM | 26 | Width 0ft | 6009534.8661 | 2121184.7078 | 37.8049064021217 | -122.41125134413299 | (37.8049064021217, -122.411251344133) | ||
| 4595 | 4595 | 142523 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 7 | Width 0ft | 6009712.3662 | 2121206.8206 | 37.804977071531404 | -122.410638645677 | (37.8049770715314, -122.410638645677) | |||
| 4605 | 4605 | 142542 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | Width 0ft | 6009433.8643 | 2121170.962 | 37.8048629945672 | -122.411599901453 | (37.8048629945672, -122.411599901453) | |||
| 4611 | 4611 | 142519 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | Width 0ft | 6009452.9889 | 2121171.5596 | 37.804865708173104 | -122.411533760714 | (37.8048657081731, -122.411533760714) | |||
| 4612 | 4612 | 142548 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 7 | Width 0ft | 6009639.4537 | 2121197.2583 | 37.8049467277157 | -122.410890292822 | (37.8049467277157, -122.410890292822) | |||
| 4622 | 4622 | 142543 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | Width 0ft | 6009503.7886 | 2121178.1337 | 37.8048866083098 | -122.411358426924 | (37.8048866083098, -122.411358426924) | |||
| 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) | ||
| 4955 | 4955 | 253734 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4956 | 4956 | 253729 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4965 | 4965 | 253732 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4968 | 4968 | 253724 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4982 | 4982 | 253733 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4986 | 4986 | 253726 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4993 | 4993 | 253727 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5004 | 5004 | 253731 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5021 | 5021 | 253725 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5028 | 5028 | 253730 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5029 | 5029 | 251680 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5037 | 5037 | 253728 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 9776 | 9776 | 99552 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Henry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12/28/2016 06:02:00 AM | 3 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | |
| 10038 | 10038 | 96503 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | |||
| 10282 | 10282 | 173941 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3750 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 6004590.0 | 2105440.0 | 37.7613967828987 | -122.42724138037701 | (37.7613967828987, -122.427241380377) | ||||
| 10289 | 10289 | 77643 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006923.4408599995 | 2093174.3728599998 | 37.7278498138936 | -122.41830128179899 | (37.7278498138936, -122.418301281799) | |
| 10302 | 10302 | 76353 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 6 | 3x3 | 6006742.79477 | 2093189.9157 | 37.7278823207912 | -122.418926882581 | (37.7278823207912, -122.418926882581) | |
| 10418 | 10418 | 77647 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | |
| 10658 | 10658 | 75132 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 148X Paris St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 6 | 3x3 | 6002992.1034699995 | 2092540.72564 | 37.725887878997504 | -122.431846767938 | (37.7258878789975, -122.431846767938) | |
| 10784 | 10784 | 77645 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006883.8507199995 | 2093162.97754 | 37.727816296176705 | -122.41843733843201 | (37.7278162961767, -122.418437338432) | |
| 10794 | 10794 | 77662 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 3 | 3x3 | 6006681.78325 | 2093389.6875599998 | 37.728427415183894 | -122.419151965791 | (37.7284274151839, -122.419151965791) |
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");