Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53 | 53 | 251187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000800.0 | 2109063.0 | 37.771129578660705 | -122.440609247553 | (37.7711295786607, -122.440609247553) | ||||
| 352 | 352 | 14742 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004772.182 | 2111961.3352 | 37.779313094037704 | -122.427075791541 | (37.7793130940377, -122.427075791541) | |||
| 1570 | 1570 | 5344 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 180 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6004766.753190001 | 2107347.6889299997 | 37.7666448358082 | -122.42676592392999 | (37.7666448358082, -122.42676592393) | |||
| 1987 | 1987 | 123759 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 201 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2016 12:00:00 AM | 18 | Width 5ft | 5994972.5884300005 | 2110752.02511 | 37.775433631632296 | -122.46088876401501 | (37.7754336316323, -122.460888764015) | ||
| 4909 | 4909 | 5262 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1234 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001365.3782 | 2112681.2883 | 37.7810966664945 | -122.438912929299 | (37.7810966664945, -122.438912929299) | |||
| 9240 | 9240 | 18089 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3000 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5999515.0867 | 2114695.0726 | 37.786520549411996 | -122.445458834419 | (37.786520549412, -122.445458834419) | |||
| 13580 | 13580 | 44030 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 96 Lafayette St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52444 | 6007681.41962 | 2109502.84398 | 37.7727267448872 | -122.416837272729 | (37.7727267448872, -122.416837272729) | |
| 14450 | 14450 | 28531 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 241 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2012 12:00:00 AM | 18 | 3X3 | Permit Number 769387 | 6010735.412690001 | 2111831.43795 | 37.77929182908439 | -122.406437232011 | (37.7792918290844, -122.406437232011) | |
| 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) | ||
| 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) | |||
| 16984 | 16984 | 10523 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5997295.7816 | 2108435.9791 | 37.769207770213704 | -122.452685140494 | (37.7692077702137, -122.452685140494) | |||
| 19194 | 19194 | 5349 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/22/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53640 | 6004790.705569999 | 2107143.57223 | 37.7660857344886 | -122.426668539926 | (37.7660857344886, -122.426668539926) | |
| 20052 | 20052 | 24345 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 95 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6006134.19272 | 2108466.72229 | 37.7697946537198 | -122.42211568701201 | (37.7697946537198, -122.422115687012) | |||
| 20272 | 20272 | 5372 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 266 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6004807.33386 | 2106790.92069 | 37.7651183778313 | -122.426585912012 | (37.7651183778313, -122.426585912012) | |||
| 20711 | 20711 | 10425 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1419 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 5999323.0709 | 2108716.5502 | 37.7700941010229 | -122.445693060933 | (37.7700941010229, -122.445693060933) | |||
| 23959 | 23959 | 123754 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5995442.56449 | 2110764.4731099997 | 37.7754948416879 | -122.45926391827801 | (37.7754948416879, -122.459263918278) | |||
| 24460 | 24460 | 239706 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4922 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5997784.7842 | 2105653.4799099998 | 37.7615957414698 | -122.450793062454 | (37.7615957414698, -122.450793062454) | |||
| 24499 | 24499 | 114998 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 460 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6009108.5473 | 2121165.2365 | 37.8048290202645 | -122.412725294876 | (37.8048290202645, -122.412725294876) | |||
| 25405 | 25405 | 33648 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 530 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37739 | 6004854.057893401 | 2110753.28886702 | 37.7760007246145 | -122.426706497307 | (37.7760007246145, -122.426706497307) | |||
| 26858 | 26858 | 138325 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2492 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001603.2252 | 2114641.6748 | 37.7864929170324 | -122.438230579455 | (37.7864929170324, -122.438230579455) | |||
| 29182 | 29182 | 136399 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1667 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005091.5128 | 2118475.84475 | 37.7972183598879 | -122.42643506691999 | (37.7972183598879, -122.42643506692) | |||
| 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) | |||
| 30904 | 30904 | 214185 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 333 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5992626.04523 | 2094642.7577 | 37.731066456833794 | -122.467834020931 | (37.7310664568338, -122.467834020931) | |||
| 33568 | 33568 | 179425 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006737.87137 | 2087492.2529799999 | 37.712237478839796 | -122.418540048182 | (37.7122374788398, -122.418540048182) | |||
| 34171 | 34171 | 239736 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1449 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003316.36973 | 2099822.47009 | 37.745900265003705 | -122.431245341824 | (37.7459002650037, -122.431245341824) | |||
| 34575 | 34575 | 179465 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 291 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6001702.1853 | 2090068.84403 | 37.719027441244705 | -122.43612910838101 | (37.7190274412447, -122.436129108381) | |||
| 34902 | 34902 | 215020 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 501 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5998758.39397 | 2094948.38752 | 37.732257843614704 | -122.44665550384701 | (37.7322578436147, -122.446655503847) | |||
| 35663 | 35663 | 217714 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1199 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5996346.1405 | 2091806.7339 | 37.7234935241877 | -122.45476826329599 | (37.7234935241877, -122.454768263296) | |||
| 36473 | 36473 | 123827 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1501 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5993999.90025 | 2112075.9753799997 | 37.77901282804729 | -122.46434964043002 | (37.7790128280473, -122.46434964043) | |||
| 37342 | 37342 | 142551 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 451 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6009269.3434 | 2121145.5233 | 37.80478391634529 | -122.41216744681101 | (37.8047839163453, -122.412167446811) | |||
| 37529 | 37529 | 114872 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 735 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6002556.26502 | 2089229.80958 | 37.7167721250182 | -122.43311697309099 | (37.7167721250182, -122.433116973091) | ||||
| 39125 | 39125 | 197507 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6009714.36956 | 2109423.2134700003 | 37.772622236462205 | -122.409799423029 | (37.7726222364622, -122.409799423029) | |||
| 41432 | 41432 | 245059 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000823.1995 | 2109073.1196 | 37.77115868561361 | -122.44052972578001 | (37.7711586856136, -122.44052972578) | |||
| 41498 | 41498 | 214201 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 145 Maywood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5994272.70142 | 2095629.8656 | 37.733871759758394 | -122.462212852568 | (37.7338717597584, -122.462212852568) | |||
| 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) | |||
| 44413 | 44413 | 200830 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1550 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6011811.2987 | 2107032.5363 | 37.766175269536205 | -122.402377754798 | (37.7661752695362, -122.402377754798) | |||
| 44525 | 44525 | 21850 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 199X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5995144.904080001 | 2110755.8457 | 37.775454035467796 | -122.46029296446699 | (37.7754540354678, -122.460292964467) | |||
| 45178 | 45178 | 239695 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6004807.135419999 | 2101616.24717 | 37.7509099321629 | -122.426218161243 | (37.7509099321629, -122.426218161243) | |||
| 45696 | 45696 | 40608 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2756 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/1999 12:00:00 AM | 12 | Permit Number 41618 | 5996415.12538 | 2111289.35266 | 37.7769918898751 | -122.45593757087 | (37.7769918898751, -122.45593757087) | ||
| 46348 | 46348 | 197519 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1055 Natoma St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6007591.229180001 | 2109427.92338 | 37.772515957284206 | -122.417143942455 | (37.7725159572842, -122.417143942455) | |||
| 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) | |||
| 48306 | 48306 | 179432 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6006549.425009999 | 2086808.7283400001 | 37.7103500527955 | -122.419142922204 | (37.7103500527955, -122.419142922204) | |||
| 48668 | 48668 | 179445 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 50 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006641.641 | 2087043.6428599998 | 37.7110002716098 | -122.418840853438 | (37.7110002716098, -122.418840853438) | |||
| 50722 | 50722 | 240572 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 210 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6002036.98136 | 2104624.07975 | 37.7590117527075 | -122.436012807155 | (37.7590117527075, -122.436012807155) | |||
| 50851 | 50851 | 200842 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1919 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6010705.6887 | 2106916.0312 | 37.7657935922594 | -122.40619365455 | (37.7657935922594, -122.40619365455) | |||
| 51097 | 51097 | 47786 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 445 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | 8 | Permit Number 45558 | 6009129.7041 | 2121124.5774 | 37.804718567986704 | -122.41264920318999 | (37.8047185679867, -122.41264920319) | ||
| 51841 | 51841 | 179460 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6000997.30077 | 2089688.71555 | 37.7179436214658 | -122.43853839394698 | (37.7179436214658, -122.438538393947) | |||
| 51874 | 51874 | 183899 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5989428.0919 | 2100803.1123 | 37.747796012582704 | -122.479340275734 | (37.7477960125827, -122.479340275734) | |||
| 51882 | 51882 | 179443 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 20 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6006639.5983 | 2087274.4168099998 | 37.711633813430204 | -122.418864269997 | (37.7116338134302, -122.418864269997) | |||
| 52151 | 52151 | 239712 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 88 Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006164.570119999 | 2097549.79113 | 37.7398209981319 | -122.421235287575 | (37.7398209981319, -122.421235287575) | |||
| 52358 | 52358 | 43759 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 249 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2000 12:00:00 AM | 9 | Permit Number 43395 | 5990535.981790001 | 2113705.55195 | 37.783286919680705 | -122.476451677439 | (37.7832869196807, -122.476451677439) | ||
| 53204 | 53204 | 240563 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 10 Hancock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004179.51855 | 2105131.83325 | 37.7605274080343 | -122.42863909661999 | (37.7605274080343, -122.42863909662) | |||
| 54642 | 54642 | 214183 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 347 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5992610.48002 | 2094547.7964400002 | 37.730804817991704 | -122.467880927762 | (37.7308048179917, -122.467880927762) | |||
| 55609 | 55609 | 136404 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6008943.49637 | 2119016.81507 | 37.7989207252599 | -122.413144462145 | (37.7989207252599, -122.413144462145) | |||
| 56016 | 56016 | 124457 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 41 Willard St North | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996114.41784 | 2111533.6822599997 | 37.7776454910208 | -122.456995481723 | (37.7776454910208, -122.456995481723) | |||
| 56147 | 56147 | 179476 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 245 Wilson St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5994306.081069999 | 2086649.9682200002 | 37.7092170428021 | -122.461446662549 | (37.7092170428021, -122.461446662549) | ||||
| 56877 | 56877 | 239719 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4818 25th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 10ft | 5999936.15376 | 2101092.9328900003 | 37.7491965123129 | -122.44302484724199 | (37.7491965123129, -122.443024847242) | |||
| 57171 | 57171 | 197523 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1919 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010718.525880001 | 2106914.57132 | 37.7657903018022 | -122.40614915038799 | (37.7657903018022, -122.406149150388) | |||
| 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) | |||
| 61007 | 61007 | 215018 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 113 Stillings Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6000011.08105 | 2095687.8075 | 37.734359595202996 | -122.442377758036 | (37.734359595203, -122.442377758036) | ||||
| 61979 | 61979 | 138491 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1800 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002045.7921 | 2114746.8959 | 37.786806988291204 | -122.43670694528 | (37.7868069882912, -122.43670694528) | |||
| 63279 | 63279 | 239715 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 875 Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000941.552 | 2099644.41912 | 37.745276511409 | -122.439444352976 | (37.745276511409, -122.439444352976) | |||
| 65250 | 65250 | 239739 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4195 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6002669.07226 | 2100621.06715 | 37.7480563212454 | -122.433540666185 | (37.7480563212454, -122.433540666185) | |||
| 66303 | 66303 | 240534 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3250 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6006614.52941 | 2103803.76084 | 37.7570183352315 | -122.420123238094 | (37.7570183352315, -122.420123238094) | |||
| 67361 | 67361 | 35126 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 766 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 7 | Permit Number 38660 | 6001721.91154 | 2089504.55342 | 37.717479145922496 | -122.43602056561001 | (37.7174791459225, -122.43602056561) | |
| 68087 | 68087 | 214999 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 325 Holloway Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995798.02713 | 2091198.56158 | 37.7217921721658 | -122.456619019966 | (37.7217921721658, -122.456619019966) | |||
| 69921 | 69921 | 138488 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1850 PIERCE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002039.4918 | 2114807.7995 | 37.7869738559463 | -122.43673310408998 | (37.7869738559463, -122.43673310409) | |||
| 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) | ||
| 72617 | 72617 | 46330 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 548 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2002 12:00:00 AM | 11 | Permit Number 44580 | 5996909.4172 | 2109622.8664 | 37.7724445099575 | -122.454107281383 | (37.7724445099575, -122.454107281383) | ||
| 73324 | 73324 | 239692 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3591 21st St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 4ft | 6004466.4231900005 | 2103643.72661 | 37.7564576520127 | -122.427540804958 | (37.7564576520127, -122.427540804958) | |||
| 73355 | 73355 | 240571 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 387 Eureka St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001511.27704 | 2103588.18103 | 37.7561375464167 | -122.43775674549101 | (37.7561375464167, -122.437756745491) | |||
| 73869 | 73869 | 138389 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1955 STEINER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002444.1157 | 2115010.1115 | 37.7875523399426 | -122.435347676 | (37.7875523399426, -122.435347676) | |||
| 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) | |||
| 75112 | 75112 | 123757 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 103 Cabrillo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5995251.69378 | 2110760.6379299997 | 37.7754733358801 | -122.459923903312 | (37.7754733358801, -122.459923903312) | |||
| 75191 | 75191 | 197527 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 301 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010651.56665 | 2106560.0309099997 | 37.7648130687996 | -122.406355766009 | (37.7648130687996, -122.406355766009) | |||
| 75642 | 75642 | 117921 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 701 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5983188.84619 | 2110935.7089 | 37.7752528931729 | -122.50166444280799 | (37.7752528931729, -122.501664442808) | |||
| 76141 | 76141 | 140194 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2177 FELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997033.6803 | 2109487.6013 | 37.772080231598004 | -122.45366767652 | (37.772080231598, -122.45366767652) | |||
| 76650 | 76650 | 246228 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5999452.5303 | 2107741.8948 | 37.7674253335335 | -122.44517518096501 | (37.7674253335335, -122.445175180965) | |||
| 76738 | 76738 | 239680 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 14 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6005352.16587 | 2103533.57017 | 37.7562052473857 | -122.42446975599701 | (37.7562052473857, -122.424469755997) | |||
| 82237 | 82237 | 98255 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1375 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 5x5 | Permit Number 25808 | 6003289.0 | 2100236.0 | 37.7470341706262 | -122.431369496968 | (37.7470341706262, -122.431369496968) | ||
| 82265 | 82265 | 40570 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1750 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1999 12:00:00 AM | Permit Number 41613 | 6008764.95036499 | 2118846.2736549 | 37.79844243583229 | -122.41375022293 | (37.7984424358323, -122.41375022293) | |||
| 84221 | 84221 | 27409 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2178 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5997014.41754 | 2109490.27003 | 37.7720864549253 | -122.453734500333 | (37.7720864549253, -122.453734500333) | ||
| 84317 | 84317 | 5480 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 695 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 8 | 6005032.869109999 | 2104338.69015 | 37.7583978815122 | -122.425631294213 | (37.7583978815122, -122.425631294213) | |||
| 84818 | 84818 | 7143 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 405X CABRILLO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5994263.0 | 2110752.0 | 37.7753927075385 | -122.463343377573 | (37.7753927075385, -122.463343377573) | |||
| 85224 | 85224 | 112022 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101x 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5x5 | 6011761.0 | 2103726.0 | 37.757093449930004 | -122.402319220858 | (37.75709344993, -122.402319220858) | ||||
| 85400 | 85400 | 14754 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 950X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | |||
| 86167 | 86167 | 52688 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1401@ RIVOLI Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | Permit Number 48758 | 5997782.141834901 | 2105912.5855129 | 37.76230702883 | -122.45082088432301 | (37.76230702883, -122.450820884323) | |||
| 87625 | 87625 | 22676 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1340 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003587.617269999 | 2112577.2889400003 | 37.780937293905204 | -122.431217671135 | (37.7809372939052, -122.431217671135) | |||
| 89144 | 89144 | 31499 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3244 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 35060 | 6006677.13820069 | 2103812.71234735 | 37.7570464414299 | -122.41990734792401 | (37.7570464414299, -122.419907347924) | ||||
| 92734 | 92734 | 50056 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 646 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2003 12:00:00 AM | Permit Number 46785 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341001 | (37.7605408596837, -122.42837316341) | |||
| 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) | |||
| 95701 | 95701 | 142670 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 444 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009183.2325 | 2121175.0028 | 37.8048600276109 | -122.412467528668 | (37.8048600276109, -122.412467528668) | |||
| 96083 | 96083 | 19297 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 40X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5995496.87098 | 2110852.98465 | 37.775740993063394 | -122.459082470822 | (37.7757409930634, -122.459082470822) | |||
| 98091 | 98091 | 112610 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 333 SANTA ANA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992649.0 | 2094625.0 | 37.7310190240744 | -122.46775337202101 | (37.7310190240744, -122.467753372021) | ||||
| 98999 | 98999 | 111027 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 150 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | ||||
| 99577 | 99577 | 41627 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1095 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42109 | 6007646.45182189 | 2109473.56842462 | 37.7726443942379 | -122.416956155908 | (37.7726443942379, -122.416956155908) | |||
| 99834 | 99834 | 40859 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1670 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42380 | 6009721.65724328 | 2100087.27684169 | 37.746988275084895 | -122.409115329349 | (37.7469882750849, -122.409115329349) | ||
| 100108 | 100108 | 2750 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 59 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5995436.711 | 2110737.12628 | 37.7754194179801 | -122.459282185974 | (37.7754194179801, -122.459282185974) | |||
| 101227 | 101227 | 87200 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 123 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 2 | 3x3 | 5995204.25641 | 2110758.6189099997 | 37.77546506387571 | -122.460087853041 | (37.7754650638757, -122.460087853041) | ||
| 102317 | 102317 | 32425 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 275 Maywood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 36952 | 5994490.2461397005 | 2094811.13335462 | 37.7316362454296 | -122.461401406739 | (37.7316362454296, -122.461401406739) |
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");