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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 124515 | 124515 | 701 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1401X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005272.9475237 | 2100137.7446563 | 37.7468766226068 | -122.424502181659 | (37.7468766226068, -122.424502181659) | |||
| 121730 | 121730 | 803 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 680X 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983825.76498 | 2111129.60729 | 37.7758226717015 | -122.499475562851 | (37.7758226717015, -122.499475562851) | |||
| 145945 | 145945 | 805 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 680X 39th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983823.96426 | 2111160.91126 | 37.7759085177004 | -122.499484105844 | (37.7759085177004, -122.499484105844) | |||
| 87349 | 87349 | 807 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600X 39th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983808.206040001 | 2111664.13118 | 37.7772892893219 | -122.49957581574499 | (37.7772892893219, -122.499575815745) | |||
| 143285 | 143285 | 814 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600X 39th Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 121708 | 121708 | 1355 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 293 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999960.7830229 | 2099345.3310648 | 37.744399421904504 | -122.442814204744 | (37.7443994219045, -122.442814204744) | |||
| 108390 | 108390 | 1630 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 20X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/06/2015 01:42:00 PM | 3 | 3X3 | 5995606.71843 | 2110827.0926 | 37.7756762144924 | -122.458700608592 | (37.7756762144924, -122.458700608592) | ||
| 127222 | 127222 | 1631 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 20X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5995606.71843 | 2110827.0926 | 37.7756762144924 | -122.458700608592 | (37.7756762144924, -122.458700608592) | |||
| 94837 | 94837 | 1676 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 251 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1991 12:00:00 AM | 12 | 3X3 | 5994751.99718 | 2111422.1356900004 | 37.7772608818646 | -122.46170043317801 | (37.7772608818646, -122.461700433178) | ||
| 100727 | 100727 | 2747 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 26 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5995511.8334800005 | 2110826.68765 | 37.7756696485776 | -122.459028807619 | (37.7756696485776, -122.459028807619) | |||
| 126726 | 126726 | 2748 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 27 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5995513.49163 | 2110771.02145 | 37.775516899200795 | -122.459019040214 | (37.7755168992008, -122.459019040214) | |||
| 120609 | 120609 | 2749 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 59 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5995436.711 | 2110737.12628 | 37.7754194179801 | -122.459282185974 | (37.7754194179801, -122.459282185974) | |||
| 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) | |||
| 90515 | 90515 | 2751 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 59 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5995436.711 | 2110737.12628 | 37.7754194179801 | -122.459282185974 | (37.7754194179801, -122.459282185974) | |||
| 83330 | 83330 | 2752 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 59 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5995436.711 | 2110737.12628 | 37.7754194179801 | -122.459282185974 | (37.7754194179801, -122.459282185974) | |||
| 122093 | 122093 | 2754 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 123 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 5995213.94147 | 2110758.8179 | 37.7754661672939 | -122.460054364765 | (37.7754661672939, -122.460054364765) | |||
| 108944 | 108944 | 2755 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 124 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5995208.65957 | 2110814.76075 | 37.7756194677712 | -122.46007668969101 | (37.7756194677712, -122.460076689691) | |||
| 109572 | 109572 | 2757 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 129 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5995181.4176 | 2110756.28559 | 37.7754573435652 | -122.460166688286 | (37.7754573435652, -122.460166688286) | |||
| 143530 | 143530 | 2769 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994681.187530001 | 2110791.87373 | 37.7755262738923 | -122.46189967141899 | (37.7755262738923, -122.461899671419) | |||
| 124242 | 124242 | 2770 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5994656.76542 | 2110790.98006 | 37.7755224141133 | -122.461984087937 | (37.7755224141133, -122.461984087937) | |||
| 117913 | 117913 | 2771 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 5994637.57621 | 2110789.5748099997 | 37.775517450891 | -122.46205036561301 | (37.775517450891, -122.462050365613) | |||
| 142046 | 142046 | 2772 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5994610.57975 | 2110790.94437 | 37.775519657009994 | -122.462143851512 | (37.77551965701, -122.462143851512) | |||
| 99181 | 99181 | 2773 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 324 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 5994596.42955 | 2110789.71407 | 37.775515464201895 | -122.462192710849 | (37.7755154642019, -122.462192710849) | |||
| 84806 | 84806 | 2774 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 325 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4X6 | 5994591.7075 | 2110737.91873 | 37.7753729760761 | -122.46220528818701 | (37.7753729760761, -122.462205288187) | |||
| 117637 | 117637 | 2775 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 325 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5994586.46007 | 2110712.87272 | 37.77530390424771 | -122.462221623284 | (37.7753039042477, -122.462221623284) | |||
| 145972 | 145972 | 2777 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 331 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4X6 | 5994569.06869 | 2110730.2609099997 | 37.7753506462039 | -122.46228304501801 | (37.7753506462039, -122.462283045018) | |||
| 109617 | 109617 | 2778 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 330 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3X3 | 5994563.2204599995 | 2110788.63831 | 37.775510598279205 | -122.462307510178 | (37.7755105982792, -122.462307510178) | |||
| 120228 | 120228 | 2780 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 410 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994353.307030001 | 2110782.9529 | 37.7754828983009 | -122.463033233018 | (37.7754828983009, -122.463033233018) | |||
| 108644 | 108644 | 2785 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 431 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 5994248.85209 | 2110724.78834 | 37.7753171764734 | -122.463390343008 | (37.7753171764734, -122.463390343008) | |||
| 141986 | 141986 | 2786 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 435 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994220.38396 | 2110725.0334799998 | 37.775316209380605 | -122.463488837884 | (37.7753162093806, -122.463488837884) | |||
| 87364 | 87364 | 2791 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 451 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5994200.86487 | 2110721.92095 | 37.775306538569296 | -122.463556132466 | (37.7753065385693, -122.463556132466) | |||
| 20406 | 20406 | 4151 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3713-3717 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/31/1989 12:00:00 AM | 6 | 3X3 | 6005727.50138 | 2100496.8829200002 | 37.7478883935431 | -122.422955895692 | (37.7478883935431, -122.422955895692) | ||
| 17081 | 17081 | 4153 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3721-3721 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/31/1989 12:00:00 AM | 6 | 3X3 | 6005701.8016 | 2100493.99134 | 37.7478790037267 | -122.423044558975 | (37.7478790037267, -122.423044558975) | ||
| 21727 | 21727 | 4159 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3736-3738 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1989 12:00:00 AM | 23 | 3X3 | 6005622.07663 | 2100534.0724299997 | 37.7479845580381 | -122.4233230934 | (37.7479845580381, -122.4233230934) | ||
| 20199 | 20199 | 4163 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3755 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1989 12:00:00 AM | 12 | 3X3 | 6005492.3082 | 2100481.8837200003 | 37.747833935087705 | -122.423768117516 | (37.7478339350877, -122.423768117516) | ||
| 20086 | 20086 | 4168 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3782-3788 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/1989 12:00:00 AM | 18 | 3X3 | 6005368.018130001 | 2100519.1181900003 | 37.747929155315596 | -122.42420055471901 | (37.7479291553156, -122.424200554719) | ||
| 18285 | 18285 | 4239 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4022 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003730.38902 | 2100426.5981900003 | 37.747582514323895 | -122.429856804747 | (37.7475825143239, -122.429856804747) | |||
| 103690 | 103690 | 5261 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1234 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001382.11052 | 2112701.66304 | 37.78115356232121 | -122.43885650447599 | (37.7811535623212, -122.438856504476) | |||
| 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) | |||
| 5323 | 5323 | 5263 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1234 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001361.3171 | 2112714.792 | 37.781188428076796 | -122.438929380366 | (37.7811884280768, -122.438929380366) | |||
| 7072 | 7072 | 5264 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1234 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001356.2408 | 2112747.2805 | 37.7812773444135 | -122.438949270784 | (37.7812773444135, -122.438949270784) | |||
| 17239 | 17239 | 5333 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 135 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6004851.68413 | 2107592.33342 | 37.767321372413704 | -122.42648958384399 | (37.7673213724137, -122.426489583844) | |||
| 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) | |||
| 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) | |
| 20111 | 20111 | 5352 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6004792.2174 | 2107120.31816 | 37.7660219698556 | -122.426661654709 | (37.7660219698556, -122.426661654709) | |||
| 17571 | 17571 | 5359 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 233 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6004883.71893 | 2107010.19311 | 37.765724765498206 | -122.426337327709 | (37.7657247654982, -122.426337327709) | |||
| 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) | |||
| 98864 | 98864 | 5405 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 381 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2016 12:00:00 AM | 3X3 | 6004938.1878622 | 2106152.8168866 | 37.7633736936511 | -122.426087889681 | (37.7633736936511, -122.426087889681) | |||
| 104503 | 104503 | 5421 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 445 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 5X5 | 6004959.0723832 | 2105770.0586221 | 37.7623239107578 | -122.42598840833999 | (37.7623239107578, -122.42598840834) | |||
| 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) | |||
| 95365 | 95365 | 5484 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 700X Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 35 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 88492 | 88492 | 5486 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 700X Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/28/2008 12:00:00 AM | 12 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 18248 | 18248 | 5692 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1546 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6005220.41395 | 2099376.74782 | 37.7447841325786 | -122.42462971298401 | (37.7447841325786, -122.424629712984) | |||
| 21881 | 21881 | 5738 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1740 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6005286.8727 | 2098237.12847 | 37.741658750152794 | -122.42431887223499 | (37.7416587501528, -122.424318872235) | |||
| 2300 | 2300 | 6356 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1234X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001371.4698 | 2112650.1535 | 37.7810115248297 | -122.438889623593 | (37.7810115248297, -122.438889623593) | |||
| 128634 | 128634 | 7135 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 336X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994611.623430001 | 2110790.08992 | 37.775517371009 | -122.46214017921899 | (37.775517371009, -122.462140179219) | |||
| 118361 | 118361 | 7137 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 336X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5994611.623430001 | 2110790.08992 | 37.775517371009 | -122.46214017921899 | (37.775517371009, -122.462140179219) | |||
| 139008 | 139008 | 7138 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 336X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994611.623430001 | 2110790.08992 | 37.775517371009 | -122.46214017921899 | (37.775517371009, -122.462140179219) | |||
| 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) | |||
| 142558 | 142558 | 7684 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 315X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5994678.74309 | 2110742.5512099997 | 37.7753907066265 | -122.46190454994301 | (37.7753907066265, -122.461904549943) | |||
| 8608 | 8608 | 9533 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6004176.1272 | 2112221.7819 | 37.7799944925987 | -122.429156369266 | (37.7799944925987, -122.429156369266) | |||
| 7831 | 7831 | 9536 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004118.455 | 2112215.6365 | 37.779974353933 | -122.42935544491999 | (37.779974353933, -122.42935544492) | ||
| 3190 | 3190 | 9537 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6004100.4915 | 2112210.9093 | 37.779960357201205 | -122.429417251502 | (37.7799603572012, -122.429417251502) | ||
| 139901 | 139901 | 9540 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004321.7721315995 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | ||
| 19927 | 19927 | 10223 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1377X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005871.04446 | 2100967.56548 | 37.7491888788632 | -122.42249296966999 | (37.7491888788632, -122.42249296967) | |||
| 81599 | 81599 | 10262 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 212 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005067.14002 | 2109566.5504900003 | 37.772754274276096 | -122.42588489611201 | (37.7727542742761, -122.425884896112) | |||
| 77447 | 77447 | 10384 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1330 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5999747.979280001 | 2108852.64514 | 37.770492033974705 | -122.44423309424 | (37.7704920339747, -122.44423309424) | |||
| 2506 | 2506 | 10385 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1330 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/17/2017 12:00:00 AM | 24 | 3X3 | 5999759.2979999995 | 2108827.6222 | 37.7704239730353 | -122.444192144461 | (37.7704239730353, -122.444192144461) | ||
| 17707 | 17707 | 10404 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1372 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5999585.1964 | 2108804.377 | 37.7703502135529 | -122.44479268919599 | (37.7703502135529, -122.444792689196) | |||
| 94120 | 94120 | 10424 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1417 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5999343.5805 | 2108720.18711 | 37.77010525801229 | -122.445622380313 | (37.7701052580123, -122.445622380313) | |||
| 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) | |||
| 17589 | 17589 | 10438 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1474 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5999064.8261 | 2108729.1491 | 37.770113946782 | -122.446587229644 | (37.770113946782, -122.446587229644) | |||
| 77938 | 77938 | 10458 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1568 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5998619.39853 | 2108748.68603 | 37.7701421372022 | -122.448129358985 | (37.7701421372022, -122.448129358985) | |||
| 23218 | 23218 | 10460 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1568 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/2008 12:00:00 AM | 12 | 3x3 | 5998627.6282 | 2108670.1782 | 37.7699270451307 | -122.448095239137 | (37.7699270451307, -122.448095239137) | ||
| 100986 | 100986 | 10490 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1687 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5997959.93364 | 2108479.83355 | 37.769366216326496 | -122.450391046811 | (37.7693662163265, -122.450391046811) | |||
| 20765 | 20765 | 10517 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1827 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1996 12:00:00 AM | 20 | 3X3 | 5997386.3275 | 2108448.0922 | 37.7692462174685 | -122.452372822905 | (37.7692462174685, -122.452372822905) | ||
| 90237 | 90237 | 10520 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 HAIGHT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5997298.0 | 2108414.0 | 37.7691475483634 | -122.452675880715 | (37.7691475483634, -122.452675880715) | |||
| 19376 | 19376 | 10521 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5997344.2343 | 2108442.9441 | 37.769229670497 | -122.452518048778 | (37.769229670497, -122.452518048778) | |||
| 23185 | 23185 | 10522 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5997273.9779 | 2108433.2536 | 37.7691990373323 | -122.452760361188 | (37.7691990373323, -122.452760361188) | |||
| 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) | |||
| 142048 | 142048 | 12322 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1008X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004729.34594 | 2112297.27395 | 37.7802330766406 | -122.427247915616 | (37.7802330766406, -122.427247915616) | |||
| 127798 | 127798 | 12333 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1105X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6004706.6254900005 | 2112590.71039 | 37.78103749568189 | -122.427347425327 | (37.7810374956819, -122.427347425327) | |||
| 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) | |||
| 8946 | 8946 | 14523 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 625 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4x4 | 5999129.3058 | 2110654.1301 | 37.7754031370148 | -122.446502707181 | (37.7754031370148, -122.446502707181) | |||
| 18223 | 18223 | 14566 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1030 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5999382.6721 | 2109282.399 | 37.771651181181504 | -122.445527596882 | (37.7716511811815, -122.445527596882) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 123500 | 123500 | 14771 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1000X McAllister St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 18 | 4x4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | |||
| 126868 | 126868 | 14772 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1000X McAllister St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 06/30/1994 12:00:00 AM | 18 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | ||
| 110180 | 110180 | 14775 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1000X McAllister St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) |
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");