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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 83117 | 83117 | 14776 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1000X McAllister St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 06/30/1994 12:00:00 AM | 12 | 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) | |||
| 122469 | 122469 | 14777 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1000X McAllister St | 12 | 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) | |||
| 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) | ||
| 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) | |||
| 14458 | 14458 | 94035 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1300X Lane St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 32 | 5x5 | 6015684.8669 | 2095240.1882 | 37.7340114236329 | -122.388156677838 | (37.7340114236329, -122.388156677838) | ||
| 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) | ||
| 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) | ||||
| 88558 | 88558 | 112026 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101x 22nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5x5 | 6011761.0 | 2103726.0 | 37.757093449930004 | -122.402319220858 | (37.75709344993, -122.402319220858) | ||||
| 89475 | 89475 | 112027 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101x 22nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5x5 | 6011761.0 | 2103726.0 | 37.757093449930004 | -122.402319220858 | (37.75709344993, -122.402319220858) | ||||
| 109884 | 109884 | 112024 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101x 22nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5x5 | 6011761.0 | 2103726.0 | 37.757093449930004 | -122.402319220858 | (37.75709344993, -122.402319220858) | ||||
| 143137 | 143137 | 76749 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200X Farallones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1989 12:00:00 AM | 8 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) | |
| 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) | ||
| 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) | ||
| 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) | |||
| 14374 | 14374 | 26131 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1500 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x3 | 6015558.456 | 2095125.3192 | 37.7336890117673 | -122.388585707606 | (37.7336890117673, -122.388585707606) | |||
| 15206 | 15206 | 26133 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1504 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 5x5 | 6015522.1816 | 2095153.8991 | 37.7337654760523 | -122.388713114387 | (37.7337654760523, -122.388713114387) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 950 | 950 | 27411 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2198 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5996975.1116 | 2109480.4382 | 37.7720572057802 | -122.453869751853 | (37.7720572057802, -122.453869751853) | ||
| 1073 | 1073 | 22619 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1107 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6004653.0794 | 2112584.8191 | 37.7810182911755 | -122.42753224810801 | (37.7810182911755, -122.427532248108) | |||
| 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) | |||
| 2263 | 2263 | 22364 | Landmark tree 9 | Schinus terebinthifolius :: Brazilian Pepper 25 | 5490X 03rd St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 40TR | 6014151.6099 | 2093070.9929 | 37.7279701830365 | -122.393305916851 | (37.7279701830365, -122.393305916851) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 7331 | 7331 | 18088 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3000 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999530.9574 | 2114697.1427 | 37.7865271393644 | -122.445404074823 | (37.7865271393644, -122.445404074823) | |||
| 11322 | 11322 | 19745 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 STAIRWAY15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
| 11462 | 11462 | 26316 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2049 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999538.37389 | 2091931.2083 | 37.7240178943838 | -122.443742263404 | (37.7240178943838, -122.443742263404) | |||
| 12920 | 12920 | 26322 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1975 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999887.727969999 | 2092429.05718 | 37.7254047928689 | -122.44257033256201 | (37.7254047928689, -122.442570332562) | |||
| 15868 | 15868 | 16559 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 702X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015638.3263 | 2097400.20162 | 37.7399398030878 | -122.388468300865 | (37.7399398030878, -122.388468300865) | |||
| 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) | |||
| 16514 | 16514 | 22196 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4049 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015606.879 | 2097560.5249 | 37.7403782752921 | -122.38858822178001 | (37.7403782752921, -122.38858822178) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 18205 | 18205 | 24291 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006664.25165 | 2098042.76581 | 37.7412027542911 | -122.41954256203998 | (37.7412027542911, -122.41954256204) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 20738 | 20738 | 22897 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 201 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006097.55508 | 2108434.56296 | 37.7697042853598 | -122.422240130676 | (37.7697042853598, -122.422240130676) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 28030 | 28030 | 197577 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 299x Cashmere St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6016820.77887 | 2095888.49241 | 37.735854408739 | -122.38427457691002 | (37.735854408739, -122.38427457691) | ||||
| 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) | |||
| 51448 | 51448 | 92261 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4545 Anza St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52708 | 5984639.1399 | 2111735.34775 | 37.7775335493935 | -122.49670664793301 | (37.7775335493935, -122.496706647933) | |
| 64857 | 64857 | 239685 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1601x Alabama St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6009289.0171 | 2100045.3572 | 37.7468489265392 | -122.41060840725201 | (37.7468489265392, -122.410608407252) | |||
| 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) | |||
| 77723 | 77723 | 116380 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4299X 17TH ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 15 | 3x3 | 6000957.0 | 2105810.0 | 37.762206586209295 | -122.439832910658 | (37.7622065862093, -122.439832910658) | |||
| 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) | |||
| 78791 | 78791 | 21853 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 199X Cabrillo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5995153.19322 | 2110756.08274 | 37.7754551631243 | -122.46026430774201 | (37.7754551631243, -122.460264307742) | |||
| 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) | |||
| 82650 | 82650 | 21149 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2292X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 88014 | 88014 | 23587 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3251X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.42585514440701 | (37.8066799978444, -122.425855144407) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 96864 | 96864 | 16562 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 700X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015552.29216 | 2097280.01448 | 37.7396050257983 | -122.388757385673 | (37.7396050257983, -122.388757385673) | |||
| 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) | |||
| 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) | |||
| 100314 | 100314 | 19298 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 40X CABRILLO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5995512.0 | 2110798.0 | 37.7755908894339 | -122.459026153947 | (37.7755908894339, -122.459026153947) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 104059 | 104059 | 19296 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 40X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5995496.87098 | 2110852.98465 | 37.775740993063394 | -122.459082470822 | (37.7757409930634, -122.459082470822) | |||
| 104485 | 104485 | 24342 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600X 39th Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 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) | |||
| 105178 | 105178 | 21150 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2292X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
| 108026 | 108026 | 21856 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 215X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2003 12:00:00 AM | 18 | 4.5X4.5 | 5994989.01038 | 2110754.0886 | 37.775440242331705 | -122.460832106591 | (37.7754402423317, -122.460832106591) | ||
| 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) | ||
| 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) | |||
| 108652 | 108652 | 21148 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2292X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
| 109083 | 109083 | 26334 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1759 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000966.441902901 | 2093906.9648093998 | 37.729524219400794 | -122.43894719153 | (37.7295242194008, -122.43894719153) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 115289 | 115289 | 105020 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101X ORD ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6000863.0 | 2105739.0 | 37.7620062865301 | -122.44015292861602 | (37.7620062865301, -122.440152928616) |
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");