Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 136180 | 136180 | 122800 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1223 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6017230.3941 | 2093111.7012 | 37.7282525286375 | -122.382665199331 | (37.7282525286375, -122.382665199331) | |||
| 28030 | 28030 | 197577 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 299x Cashmere St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6016820.77887 | 2095888.49241 | 37.735854408739 | -122.38427457691002 | (37.735854408739, -122.38427457691) | ||||
| 165542 | 165542 | 197578 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 299x Cashmere St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6016803.94707 | 2095896.67464 | 37.7358759448203 | -122.384333341329 | (37.7358759448203, -122.384333341329) | ||||
| 134997 | 134997 | 200682 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6015703.0041 | 2095289.1037 | 37.7341467406335 | -122.388097383825 | (37.7341467406335, -122.388097383825) | |||
| 46443 | 46443 | 200679 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6015689.2638 | 2095313.8362 | 37.7342138898064 | -122.388146614226 | (37.7342138898064, -122.388146614226) | |||
| 135451 | 135451 | 200680 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6015687.0653 | 2095298.4471 | 37.734171512631 | -122.388153141599 | (37.734171512631, -122.388153141599) | |||
| 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) | ||
| 153579 | 153579 | 200677 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6015676.0731 | 2095323.7293 | 37.734240323410894 | -122.38819290927401 | (37.7342403234109, -122.388192909274) | |||
| 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) | ||
| 38279 | 38279 | 200678 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015671.6762 | 2095312.1874 | 37.734208388060104 | -122.388207305661 | (37.7342083880601, -122.388207305661) | |||
| 44139 | 44139 | 200675 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015661.7831 | 2095333.6223 | 37.7342666958117 | -122.388243005014 | (37.7342666958117, -122.388243005014) | |||
| 28864 | 28864 | 200676 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015656.8366 | 2095323.7293 | 37.7342392575487 | -122.388259416585 | (37.7342392575487, -122.388259416585) | |||
| 23500 | 23500 | 200674 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6015639.7987 | 2095348.4618 | 37.7343062239298 | -122.38832004816099 | (37.7343062239298, -122.388320048161) | |||
| 171607 | 171607 | 200673 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6015618.3638 | 2095361.6525 | 37.734341255175096 | -122.38839507653 | (37.7343412551751, -122.38839507653) | |||
| 15868 | 15868 | 16559 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 702X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015638.3263 | 2097400.20162 | 37.7399398030878 | -122.388468300865 | (37.7399398030878, -122.388468300865) | |||
| 46462 | 46462 | 200672 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6015595.8297 | 2095380.8889 | 37.734392825730794 | -122.388474327143 | (37.7343928257308, -122.388474327143) | |||
| 16050 | 16050 | 22178 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3950X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015635.4577 | 2097953.7776 | 37.7414596503706 | -122.38851684958999 | (37.7414596503706, -122.38851684959) | |||
| 14374 | 14374 | 26131 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1500 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x3 | 6015558.456 | 2095125.3192 | 37.7336890117673 | -122.388585707606 | (37.7336890117673, -122.388585707606) | |||
| 16514 | 16514 | 22196 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4049 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015606.879 | 2097560.5249 | 37.7403782752921 | -122.38858822178001 | (37.7403782752921, -122.38858822178) | |||
| 15206 | 15206 | 26133 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1504 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 5x5 | 6015522.1816 | 2095153.8991 | 37.7337654760523 | -122.388713114387 | (37.7337654760523, -122.388713114387) | |||
| 96864 | 96864 | 16562 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 700X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015552.29216 | 2097280.01448 | 37.7396050257983 | -122.388757385673 | (37.7396050257983, -122.388757385673) | |||
| 59752 | 59752 | 98611 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1537 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6015388.0762 | 2094133.544 | 37.730956353088004 | -122.38910554087299 | (37.730956353088, -122.389105540873) | |||
| 130526 | 130526 | 98610 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1537 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | 6015377.6336 | 2094141.2385 | 37.7309769017577 | -122.389142180051 | (37.7309769017577, -122.389142180051) | |||
| 54130 | 54130 | 200066 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1563 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6015094.0337 | 2094004.9347 | 37.730586913455205 | -122.39011312209601 | (37.7305869134552, -122.390113122096) | |||
| 53238 | 53238 | 50628 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1198 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.720375661427205 | -122.39176255443 | (37.7203756614272, -122.39176255443) | |||
| 120812 | 120812 | 50629 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1198 Gilman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.720375661427205 | -122.39176255443 | (37.7203756614272, -122.39176255443) | |||
| 119968 | 119968 | 104734 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 5490x 03RD ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 9x9 | 6014203.0 | 2093127.0 | 37.7281268221954 | -122.39313217573601 | (37.7281268221954, -122.393132175736) | |||
| 2263 | 2263 | 22364 | Landmark tree 9 | Schinus terebinthifolius :: Brazilian Pepper 25 | 5490X 03rd St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 40TR | 6014151.6099 | 2093070.9929 | 37.7279701830365 | -122.393305916851 | (37.7279701830365, -122.393305916851) | |||
| 18401 | 18401 | 102831 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | |||
| 88486 | 88486 | 102833 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Lansing St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | |||
| 111674 | 111674 | 102835 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Lansing St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | |||
| 116969 | 116969 | 102832 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Lansing St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | |||
| 121462 | 121462 | 102834 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Lansing St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | |||
| 131632 | 131632 | 49833 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 418@ 19th ST Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 12 | Permit Number 46616 | 6014316.078509999 | 2105148.78787 | 37.761142414816604 | -122.393582289386 | (37.7611424148166, -122.393582289386) | |
| 106307 | 106307 | 102836 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X LANSING ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6014464.0 | 2114267.0 | 37.7861872071537 | -122.393708916182 | (37.7861872071537, -122.393708916182) | |||
| 94019 | 94019 | 34503 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1x GUY PL | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462.0 | 2114376.0 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | |||
| 95570 | 95570 | 34506 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1x GUY PL | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462.0 | 2114376.0 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | |||
| 97485 | 97485 | 34505 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1x GUY PL | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462.0 | 2114376.0 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | |||
| 99960 | 99960 | 34514 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1x GUY PL | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462.0 | 2114376.0 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | |||
| 97675 | 97675 | 34504 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | |||
| 104953 | 104953 | 34513 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | |||
| 111072 | 111072 | 34510 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | |||
| 112313 | 112313 | 34507 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | |||
| 117849 | 117849 | 34509 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | |||
| 186565 | 186565 | 197542 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 346 01st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014414.15376 | 2114458.74368 | 37.7867109212046 | -122.393894799306 | (37.7867109212046, -122.393894799306) | |||
| 75265 | 75265 | 197541 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 33 Guy Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014357.779 | 2114449.44998 | 37.7866822697032 | -122.394089193158 | (37.7866822697032, -122.394089193158) | |||
| 158566 | 158566 | 197540 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 33 Guy Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6014343.28071 | 2114436.43625 | 37.78664573117229 | -122.39413844273399 | (37.7866457311723, -122.394138442734) | |||
| 43437 | 43437 | 197539 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 33 Guy Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014318.065 | 2114410.62146 | 37.7865734481466 | -122.394223875652 | (37.7865734481466, -122.394223875652) | |||
| 71377 | 71377 | 197538 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 33 Guy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6014309.72341 | 2114400.37585 | 37.7865448523989 | -122.39425201814 | (37.7865448523989, -122.39425201814) | |||
| 84868 | 84868 | 119660 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699x Missouri St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 109554 | 109554 | 119661 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699x Missouri St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 119456 | 119456 | 119671 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699x Missouri St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 138965 | 138965 | 119669 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699x Missouri St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 72176 | 72176 | 197536 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Missouri St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6013614.8063 | 2103893.08079 | 37.7576555255942 | -122.39591971103201 | (37.7576555255942, -122.395919711032) | ||||
| 43291 | 43291 | 197532 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Missouri St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6013605.01625 | 2103874.9640900004 | 37.757605236406995 | -122.39595229975299 | (37.757605236407, -122.395952299753) | ||||
| 30401 | 30401 | 197533 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Missouri St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6013601.75095 | 2103896.53741 | 37.757664290394295 | -122.395965104316 | (37.7576642903943, -122.395965104316) | ||||
| 61560 | 61560 | 197535 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Missouri St | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6013599.31223 | 2104067.77122 | 37.7581343255511 | -122.39598553779499 | (37.7581343255511, -122.395985537795) | |||
| 148239 | 148239 | 197534 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Missouri St | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6013594.2637 | 2104046.7535 | 37.758076334581105 | -122.396001525061 | (37.7580763345811, -122.396001525061) | ||||
| 67706 | 67706 | 197576 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1121 Jamestown Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6013293.0543 | 2090118.55817 | 37.7198156565414 | -122.39606716838101 | (37.7198156565414, -122.396067168381) | ||||
| 144920 | 144920 | 32954 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 673X Missouri St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554.0 | 2103938.0 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | |||
| 171132 | 171132 | 197575 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1121 Jamestown Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 6013269.3073 | 2090137.6242 | 37.719866686770395 | -122.396150589498 | (37.7198666867704, -122.396150589498) | ||||
| 185286 | 185286 | 197529 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1399 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6013534.71133 | 2105671.7280099997 | 37.762534845926396 | -122.396321376134 | (37.7625348459264, -122.396321376134) | |||
| 165244 | 165244 | 197530 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1400 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6013404.893999999 | 2105708.82045 | 37.7626294689928 | -122.39677297068899 | (37.7626294689928, -122.396772970689) | |||
| 43292 | 43292 | 113589 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6013618.317290001 | 2118086.59987 | 37.796627904610204 | -122.39690267003799 | (37.7966279046102, -122.396902670038) | |||
| 71184 | 71184 | 113590 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 2 | 3x3 | 6013615.62221 | 2118103.5659 | 37.7966743392965 | -122.396913185795 | (37.7966743392965, -122.396913185795) | ||
| 93575 | 93575 | 117571 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 DRUMM ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013616.0 | 2118213.0 | 37.7969748404412 | -122.396919555024 | (37.7969748404412, -122.396919555024) | ||||
| 177879 | 177879 | 113591 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6013610.58042 | 2118128.2339 | 37.796741791142004 | -122.39693236204799 | (37.796741791142, -122.396932362048) | |||
| 54975 | 54975 | 113592 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6013608.47765 | 2118139.1354900002 | 37.7967716072789 | -122.39694040288799 | (37.7967716072789, -122.396940402888) | |||
| 154397 | 154397 | 113593 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6013606.07873 | 2118153.0691400003 | 37.796809732248896 | -122.39694968118299 | (37.7968097322489, -122.396949681183) | |||
| 164274 | 164274 | 113594 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6013595.86878 | 2118231.42432 | 37.797024308676896 | -122.396990506826 | (37.7970243086769, -122.396990506826) | |||
| 168129 | 168129 | 113595 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 2 | 3x3 | 6013594.82153 | 2118250.31526 | 37.7970761204252 | -122.39699545579201 | (37.7970761204252, -122.396995455792) | ||
| 178033 | 178033 | 113596 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6013590.96742 | 2118268.55465 | 37.797125986926204 | -122.397010071555 | (37.7971259869262, -122.397010071555) | |||
| 130459 | 130459 | 113597 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6013588.4505 | 2118285.15352 | 37.7971714233818 | -122.39701994521099 | (37.7971714233818, -122.397019945211) | |||
| 25697 | 25697 | 136427 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6013551.1495199995 | 2118058.04 | 37.796545747032 | -122.397133083548 | (37.796545747032, -122.397133083548) | |||
| 138261 | 138261 | 136426 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013550.70975 | 2118074.47295 | 37.796590843538496 | -122.39713575811199 | (37.7965908435385, -122.397135758112) | |||
| 24938 | 24938 | 136425 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6013547.46214 | 2118092.2461 | 37.7966394636056 | -122.397148242524 | (37.7966394636056, -122.397148242524) | |||
| 121244 | 121244 | 136424 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013541.7115 | 2118113.66267 | 37.7966979482953 | -122.39716964367202 | (37.7966979482953, -122.397169643672) | |||
| 173822 | 173822 | 136423 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013540.78751 | 2118131.64516 | 37.796747272512604 | -122.397174102497 | (37.7967472725126, -122.397174102497) | |||
| 65568 | 65568 | 136422 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013539.98314 | 2118153.1822099998 | 37.7968063633679 | -122.397178396789 | (37.7968063633679, -122.397178396789) | |||
| 159729 | 159729 | 136421 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013535.0626 | 2118179.75007 | 37.796879038483894 | -122.39719728705 | (37.7968790384839, -122.39719728705) | |||
| 59700 | 59700 | 136420 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013531.80462 | 2118197.0098599996 | 37.7969262483997 | -122.39720977141701 | (37.7969262483997, -122.397209771417) | |||
| 172147 | 172147 | 136419 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013531.07074 | 2118211.65227 | 37.7969664121295 | -122.397213338118 | (37.7969664121295, -122.397213338118) | |||
| 173345 | 173345 | 136418 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013527.00347 | 2118227.13229 | 37.797008690162 | -122.397228498003 | (37.797008690162, -122.397228498003) | |||
| 30125 | 30125 | 136417 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6013524.76569 | 2118243.85815 | 37.797054490825 | -122.397237414787 | (37.797054490825, -122.397237414787) | |||
| 154840 | 154840 | 136416 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6013522.9960199995 | 2118258.2651 | 37.797093950371 | -122.397244549101 | (37.797093950371, -122.397244549101) | |||
| 34052 | 34052 | 136411 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 160 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6013483.17698 | 2118325.06374 | 37.797275146684 | -122.397387020609 | (37.797275146684, -122.397387020609) | |||
| 153666 | 153666 | 197537 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 266 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6012934.68235 | 2095259.36475 | 37.7339113173389 | -122.39766632393601 | (37.7339113173389, -122.397666323936) | |||
| 155966 | 155966 | 49096 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 550 Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 3 | Permit Number 46244 | 6013227.233659999 | 2118310.02974 | 37.7972196135456 | -122.398271600054 | (37.7972196135456, -122.398271600054) | ||
| 74775 | 74775 | 136412 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 550 Davis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6013223.706619999 | 2118326.48177 | 37.797264590440605 | -122.39828495948099 | (37.7972645904406, -122.398284959481) | |||
| 67118 | 67118 | 136413 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 550 Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6013222.1695 | 2118341.7234900002 | 37.797306354955204 | -122.39829134828399 | (37.7973063549552, -122.398291348284) | |||
| 60479 | 60479 | 136414 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 640 Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013178.6157 | 2118647.5125700003 | 37.798143552740505 | -122.398463524392 | (37.7981435527405, -122.398463524392) | |||
| 51181 | 51181 | 136415 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 640 Davis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013156.852000001 | 2118810.40691 | 37.7985896092893 | -122.398550270302 | (37.7985896092893, -122.398550270302) | |||
| 25693 | 25693 | 101868 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2014 12:00:00 AM | 6 | 3x3 | Permit Number 771222 | 6012702.0 | 2113175.0 | 37.7830907593936 | -122.39972830907101 | (37.7830907593936, -122.399728309071) | |
| 72835 | 72835 | 101867 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769242 | 6012649.1 | 2113074.7 | 37.7828124097662 | -122.399904277178 | (37.7828124097662, -122.399904277178) | |
| 33129 | 33129 | 101872 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6012644.6557 | 2113099.5202 | 37.782880312512 | -122.39992139618 | (37.782880312512, -122.39992139618) | |||
| 156728 | 156728 | 101871 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6012623.9262 | 2113078.7907 | 37.782822238396605 | -122.39999165586799 | (37.7828222383966, -122.399991655868) | |||
| 16678 | 16678 | 101870 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779151 | 6012595.5925 | 2113052.7427 | 37.782749136894296 | -122.40008784930299 | (37.7827491368943, -122.400087849303) | |
| 181360 | 181360 | 101869 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6012583.9023 | 2113041.0524 | 37.7827163862355 | -122.400127471434 | (37.7827163862355, -122.400127471434) | |||
| 55960 | 55960 | 197531 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2006 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6012046.11634 | 2103763.76948 | 37.7572130681337 | -122.40133582769501 | (37.7572130681337, -122.401335827695) | |||
| 154363 | 154363 | 197560 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011918.46378 | 2107507.65941 | 37.7674858323444 | -122.40204049418502 | (37.7674858323444, -122.402040494185) |
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");