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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 138250 | 138250 | 215016 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Rosewood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994826.24251 | 2095308.69182 | 37.7330217520514 | -122.460275845063 | (37.7330217520514, -122.460275845063) | |||
| 186011 | 186011 | 215015 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Fernwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994765.23071 | 2095304.12361 | 37.7330056991393 | -122.460486446495 | (37.7330056991393, -122.460486446495) | |||
| 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) | |||
| 26211 | 26211 | 123755 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5995425.063709999 | 2110766.6471700002 | 37.7754998049095 | -122.459324614731 | (37.7754998049095, -122.459324614731) | |||
| 53232 | 53232 | 123753 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5995463.5723 | 2110766.04178 | 37.7755003566036 | -122.459191361341 | (37.7755003566036, -122.459191361341) | |||
| 180793 | 180793 | 123756 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Cabrillo St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5995405.24475 | 2110764.0495 | 37.77549153290371 | -122.45939298463101 | (37.7754915329037, -122.459392984631) | |||
| 9811 | 9811 | 219588 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98x Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005256.0 | 2109297.0 | 37.7720248250001 | -122.42521242385 | (37.7720248250001, -122.42521242385) | ||||
| 146656 | 146656 | 240556 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 985 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003810.48686 | 2102527.4663299997 | 37.7533555422307 | -122.42972965052401 | (37.7533555422307, -122.429729650524) | |||
| 19216 | 19216 | 5559 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 984 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005041.33516 | 2102650.51852 | 37.753763035857794 | -122.425481873703 | (37.7537630358578, -122.425481873703) | |||
| 134958 | 134958 | 240557 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 983 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003809.26979 | 2102545.9517099997 | 37.753406229815 | -122.429735177759 | (37.753406229815, -122.429735177759) | |||
| 181053 | 181053 | 240558 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 983 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003807.25002 | 2102556.49662 | 37.7534350692835 | -122.42974291460199 | (37.7534350692835, -122.429742914602) | |||
| 167575 | 167575 | 240559 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 981 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003807.83193 | 2102569.2157400004 | 37.7534700259438 | -122.42974180934999 | (37.7534700259438, -122.42974180935) | |||
| 130577 | 130577 | 246583 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98 Waller St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6005277.33485 | 2109248.26095 | 37.7718922045878 | -122.425135156289 | (37.7718922045878, -122.425135156289) | |||
| 188040 | 188040 | 197520 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98 Lafayette St | 5 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6007717.2402800005 | 2109472.44967 | 37.7726453040621 | -122.416711211162 | (37.7726453040621, -122.416711211162) | |||
| 75506 | 75506 | 123747 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5995457.51702 | 2110823.6074099997 | 37.7756580685065 | -122.45921647732901 | (37.7756580685065, -122.459216477329) | |||
| 148167 | 148167 | 123746 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5995436.312030001 | 2110822.24381 | 37.7756531053071 | -122.45928973136101 | (37.7756531053071, -122.459289731361) | |||
| 166446 | 166446 | 123745 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 5995418.55494 | 2110821.8121700003 | 37.775650899214895 | -122.459351125835 | (37.7756508992149, -122.459351125835) | |||
| 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) | |
| 69078 | 69078 | 239724 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 957 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6000323.356319999 | 2102545.02834 | 37.7532056846093 | -122.441790101437 | (37.7532056846093, -122.441790101437) | |||
| 140342 | 140342 | 65162 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 957 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 14 | 4x12 | Permit Number 27142 | 6000403.82793053 | 2102538.64719816 | 37.7531927484611 | -122.44151135728501 | (37.7531927484611, -122.441511357285) |
| 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) | |||
| 115140 | 115140 | 98795 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 950@Washington Clay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.794749768385294 | -122.40882353278799 | (37.7947497683853, -122.408823532788) | |||
| 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) | |||
| 21799 | 21799 | 24344 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 95 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006121.89128 | 2108467.81183 | 37.7697969514995 | -122.42215831485201 | (37.7697969514995, -122.422158314852) | |||
| 158818 | 158818 | 179457 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 949 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 1ft | 6002045.648159999 | 2088406.8974 | 37.714483612097 | -122.434823106621 | (37.714483612097, -122.434823106621) | |||
| 103612 | 103612 | 12645 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 944 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5992509.49668 | 2114843.34604 | 37.786525248314206 | -122.469707022996 | (37.7865252483142, -122.469707022996) | |||
| 109971 | 109971 | 12646 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 944 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5992487.23998 | 2114843.45413 | 37.786524258671896 | -122.469784032853 | (37.7865242586719, -122.469784032853) | |||
| 81770 | 81770 | 14749 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 940 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | |||
| 113480 | 113480 | 14751 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 940 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | |||
| 138632 | 138632 | 14752 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 940 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | |||
| 104993 | 104993 | 71234 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 921 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1989 12:00:00 AM | 6000521.03642361 | 2102545.13668815 | 37.753217243878495 | -122.44110649339301 | (37.7532172438785, -122.441106493393) | ||||
| 156612 | 156612 | 239725 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 921 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6000349.32495 | 2102545.17891 | 37.753207577688606 | -122.44170030773701 | (37.7532075776886, -122.441700307737) | |||
| 100668 | 100668 | 14745 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 910 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | |||
| 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) | |||
| 126979 | 126979 | 14743 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | |||
| 127285 | 127285 | 14744 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | |||
| 2520 | 2520 | 141903 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004752.7943 | 2111956.4883 | 37.7792986892944 | -122.42714251637699 | (37.7792986892944, -122.427142516377) | |||
| 2521 | 2521 | 141908 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004604.7205 | 2111934.4347 | 37.779229760906205 | -122.42765319377199 | (37.7792297609062, -122.427653193772) | |||
| 2523 | 2523 | 141904 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6004738.7382 | 2111954.0648 | 37.7792912400822 | -122.42719096962601 | (37.7792912400822, -122.427190969626) | |||
| 2527 | 2527 | 141910 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6004551.4043 | 2111926.6796 | 37.7792054513567 | -122.42783708385099 | (37.7792054513567, -122.427837083851) | |||
| 2534 | 2534 | 141911 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004522.3227 | 2111922.8021 | 37.7791931595072 | -122.427937412735 | (37.7791931595072, -122.427937412735) | |||
| 2547 | 2547 | 141912 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6004447.1952 | 2111915.047 | 37.7791676154415 | -122.42819675688 | (37.7791676154415, -122.42819675688) | |||
| 66832 | 66832 | 141902 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004761.5188 | 2111959.3964 | 37.7793071675848 | -122.42711254187901 | (37.7793071675848, -122.427112541879) | |||
| 74285 | 74285 | 141901 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004790.1275 | 2111962.5056 | 37.7793173224289 | -122.427013793928 | (37.7793173224289, -122.427013793928) | |||
| 65100 | 65100 | 179463 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 90 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6000843.6616 | 2089782.45527 | 37.7181922687385 | -122.439076170523 | (37.7181922687385, -122.439076170523) | |||
| 158081 | 158081 | 179462 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 90 Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000856.84082 | 2089774.2647900002 | 37.7181705294179 | -122.43903002902 | (37.7181705294179, -122.43903002902) | |||
| 170497 | 170497 | 215013 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 9 Locksley Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5994094.36202 | 2104778.03714 | 37.75898005791429 | -122.463493095026 | (37.7589800579143, -122.463493095026) | |||
| 40850 | 40850 | 136407 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6009007.217180001 | 2119024.8122799997 | 37.798946260622294 | -122.412924532036 | (37.7989462606223, -122.412924532036) | |||
| 49719 | 49719 | 136405 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6008967.16736 | 2119019.94772 | 37.7989306555735 | -122.413062774033 | (37.7989306555735, -122.413062774033) | |||
| 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) | |||
| 139881 | 139881 | 136406 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6008985.36131 | 2119021.64248 | 37.7989363302909 | -122.412999936617 | (37.7989363302909, -122.412999936617) | |||
| 152764 | 152764 | 136403 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6008921.12724 | 2119013.91425 | 37.7989115045253 | -122.41322166175699 | (37.7989115045253, -122.413221661757) | |||
| 52898 | 52898 | 47230 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 890 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 6 | Permit Number 46770 | 6011503.10296 | 2090822.5709799998 | 37.7216489793918 | -122.40230391012 | (37.7216489793918, -122.40230391012) | |
| 187260 | 187260 | 179473 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 890 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011506.9921 | 2090808.93918 | 37.7216117663527 | -122.402289508352 | (37.7216117663527, -122.402289508352) | |||
| 73634 | 73634 | 239669 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 89 Webster St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 6004261.58964 | 2108988.28216 | 37.7711209334157 | -122.428630156483 | (37.7711209334157, -122.428630156483) | |||
| 114215 | 114215 | 116981 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 89 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004230.0 | 2108988.0 | 37.7711183708566 | -122.428739406059 | (37.7711183708566, -122.428739406059) | |||||
| 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) | |||
| 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) | |||
| 46150 | 46150 | 239714 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 872 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000978.62192 | 2099691.67862 | 37.745408384388 | -122.43931955855 | (37.745408384388, -122.43931955855) | |||
| 76917 | 76917 | 240526 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 872 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999192.4287 | 2107247.1158 | 37.766051945173004 | -122.446039241644 | (37.766051945173, -122.446039241644) | |||
| 109737 | 109737 | 47778 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 872 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | Permit Number 45554 | 5999190.57637215 | 2107256.51251673 | 37.7660776404196 | -122.446046324392 | (37.7660776404196, -122.446046324392) | |||
| 180187 | 180187 | 240525 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 870 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5999190.09937 | 2107262.31066 | 37.7660935334247 | -122.446048391324 | (37.7660935334247, -122.446048391324) | |||
| 184658 | 184658 | 124347 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 850 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 8ft | 5992970.95796 | 2111419.69143 | 37.777151486539104 | -122.46786138931499 | (37.7771514865391, -122.467861389315) | |||
| 101099 | 101099 | 51012 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 85 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2016 12:00:00 AM | 3 | Permit Number 778086 | 6001486.35916374 | 2107715.14620283 | 37.7674677672856 | -122.438138542404 | (37.7674677672856, -122.438138542404) | ||
| 30260 | 30260 | 66355 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 842 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1992 12:00:00 AM | 15 | Permit Number 30970 | 6006677.47104 | 2121530.77464 | 37.8056959468756 | -122.421164278004 | (37.8056959468756, -122.421164278004) | ||
| 133390 | 133390 | 136409 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 842 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006660.27823 | 2121526.69808 | 37.805683784442394 | -122.421223486682 | (37.8056837844424, -122.421223486682) | |||
| 111998 | 111998 | 34446 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 84 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38190 | 6004274.31729793 | 2097673.91474862 | 37.7400550657314 | -122.427779829106 | (37.7400550657314, -122.427779829106) | ||
| 131458 | 131458 | 240590 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 84 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004278.144169999 | 2097692.06256 | 37.7401051119636 | -122.42776789007799 | (37.7401051119636, -122.427767890078) | |||
| 76343 | 76343 | 35154 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 838 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/2004 12:00:00 AM | Permit Number 47291 | 6002552.46430035 | 2109566.25151631 | 37.7726110209677 | -122.43458340802 | (37.7726110209677, -122.43458340802) | ||
| 162855 | 162855 | 247472 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 838 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002550.7646 | 2109563.4235 | 37.772603159446 | -122.434589085205 | (37.772603159446, -122.434589085205) | |||
| 168951 | 168951 | 239716 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 833 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001151.75386 | 2099655.0922 | 37.7453177777039 | -122.438718276345 | (37.7453177777039, -122.438718276345) | |||
| 48286 | 48286 | 215017 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 832 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999463.89862 | 2095685.88724 | 37.734323119609606 | -122.44426940102801 | (37.7343231196096, -122.444269401028) | |||
| 71512 | 71512 | 65156 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 832 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27135 | 6001006.03746235 | 2102623.98500372 | 37.7534613558838 | -122.439434917257 | (37.7534613558838, -122.439434917257) | ||
| 104260 | 104260 | 239742 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 832 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6000856.10408 | 2102607.88191 | 37.75340860674 | -122.43995226311199 | (37.75340860674, -122.439952263112) | |||
| 22077 | 22077 | 5514 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 827 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X5 | 6005075.88619 | 2103522.4766599997 | 37.7561591814037 | -122.425424436705 | (37.7561591814037, -122.425424436705) | |||
| 152541 | 152541 | 239717 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 819 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001263.113030001 | 2099661.6065599998 | 37.7453419991489 | -122.43833368217399 | (37.7453419991489, -122.438333682174) | |||
| 51758 | 51758 | 197569 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 801 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011744.637069999 | 2113111.42965 | 37.7828627950365 | -122.403035941152 | (37.7828627950365, -122.403035941152) | |||
| 53158 | 53158 | 197573 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 801 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011805.47785 | 2113169.35516 | 37.7830252422689 | -122.402829531459 | (37.7830252422689, -122.402829531459) | |||
| 119653 | 119653 | 86882 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 801 Howard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49807 | 6011833.0 | 2113224.2 | 37.7831773700909 | -122.40273817385099 | (37.7831773700909, -122.402738173851) | |||
| 154079 | 154079 | 197570 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 801 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011756.09586 | 2113120.18338 | 37.7828874706141 | -122.40299691419901 | (37.7828874706141, -122.402996914199) | |||
| 163708 | 163708 | 197571 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 801 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011772.19211 | 2113135.08358 | 37.782929281905105 | -122.40294227588801 | (37.7829292819051, -122.402942275888) | |||
| 171932 | 171932 | 197574 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 801 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011821.05226 | 2113183.26768 | 37.7830643124058 | -122.402776628832 | (37.7830643124058, -122.402776628832) | |||
| 186755 | 186755 | 197572 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 801 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011789.60702 | 2113153.20247 | 37.7829800045728 | -122.40288330192 | (37.7829800045728, -122.40288330192) | |||
| 25617 | 25617 | 214202 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 80 El Verano Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5994588.98117 | 2094805.70057 | 37.7316270105613 | -122.461059668986 | (37.7316270105613, -122.461059668986) | |||
| 1891 | 1891 | 240582 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 8 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | 15 | Width 3ft | Permit Number 9985 | 6003834.4345 | 2107034.98465 | 37.765733469154796 | -122.429968344076 | (37.7657334691548, -122.429968344076) | |
| 147404 | 147404 | 69407 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 795 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 12 | Permit Number 33511 | 6002413.58939 | 2087078.56796 | 37.7108571939861 | -122.43345648782 | (37.7108571939861, -122.43345648782) | |
| 186144 | 186144 | 72398 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 791 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 11 | 5990047.515430001 | 2110000.36847 | 37.7730851702984 | -122.477870609559 | (37.7730851702984, -122.477870609559) | ||
| 26696 | 26696 | 69405 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 781 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 11 | Permit Number 33509 | 6002439.0824 | 2087100.62464 | 37.7109192031396 | -122.43336995327 | (37.7109192031396, -122.43336995327) | |
| 130153 | 130153 | 179493 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 781 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6002457.74986 | 2087117.22162 | 37.710965833866 | -122.43330661939899 | (37.710965833866, -122.433306619399) | |||
| 173561 | 173561 | 179492 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 781 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6002448.847080001 | 2087107.83027 | 37.7109395422009 | -122.433336718839 | (37.7109395422009, -122.433336718839) | |||
| 114701 | 114701 | 104774 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 781 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | Permit Number 778365 | 6002484.5 | 2103704.0 | 37.756510848262295 | -122.43439929586201 | (37.7565108482623, -122.434399295862) | ||
| 125697 | 125697 | 34445 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 78 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38189 | 6004271.49317697 | 2097724.19157363 | 37.7401929546681 | -122.427793175192 | (37.7401929546681, -122.427793175192) | ||
| 172534 | 172534 | 240589 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 78 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004277.11991 | 2097713.84146 | 37.7401648539148 | -122.42777298293998 | (37.7401648539148, -122.42777298294) | |||
| 58405 | 58405 | 240539 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 78 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6005465.00298 | 2099647.78115 | 37.745542138759205 | -122.423803237831 | (37.7455421387592, -122.423803237831) | |||
| 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) | |
| 148495 | 148495 | 35125 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 766 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 5 | Permit Number 38660 | 6001731.36417 | 2089519.53162 | 37.7175208097275 | -122.43598896344 | (37.7175208097275, -122.43598896344) | |
| 59654 | 59654 | 239671 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 761 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6005055.20153 | 2103892.3256200003 | 37.7571735312626 | -122.425522291914 | (37.7571735312626, -122.425522291914) | |||
| 122210 | 122210 | 5499 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 761 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 5X5 | 6005058.980136599 | 2103927.2718726 | 37.75726969897129 | -122.42551171102 | (37.7572696989713, -122.42551171102) | |||
| 160905 | 160905 | 240540 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 76 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6005479.08955 | 2099648.54226 | 37.745545023799295 | -122.423754582708 | (37.7455450237993, -122.423754582708) | |||
| 170220 | 170220 | 179470 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 755 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6002483.16702 | 2089112.03412 | 37.716444592826704 | -122.43336122533998 | (37.7164445928267, -122.43336122534) |
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");