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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53 | 53 | 251187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000800.0 | 2109063.0 | 37.771129578660705 | -122.440609247553 | (37.7711295786607, -122.440609247553) | ||||
| 68 | 68 | 251188 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000800.0 | 2109063.0 | 37.771129578660705 | -122.440609247553 | (37.7711295786607, -122.440609247553) | ||||
| 558 | 558 | 251320 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 35 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6004965.06472 | 2096463.48809 | 37.7367705580153 | -122.425305393447 | (37.7367705580153, -122.425305393447) | ||||
| 1683 | 1683 | 251669 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 203 Addison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002642.0 | 2097220.0 | 37.7387162474086 | -122.433391278876 | (37.7387162474086, -122.433391278876) | |||||
| 5144 | 5144 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Garfield St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x2 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 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) | ||||
| 9887 | 9887 | 51349 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 6401 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2004 12:00:00 AM | Permit Number 47697 | ||||||||
| 25405 | 25405 | 33648 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 530 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37739 | 6004854.057893401 | 2110753.28886702 | 37.7760007246145 | -122.426706497307 | (37.7760007246145, -122.426706497307) | |||
| 30533 | 30533 | 33010 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3622 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42195 | 6005636.60974519 | 2102002.04320044 | 37.7520160884207 | -122.423377179853 | (37.7520160884207, -122.423377179853) | ||
| 34304 | 34304 | 62258 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | Permit Number 22384 | 6001321.62543581 | 2093848.87962555 | 37.729384933111604 | -122.437715130621 | (37.7293849331116, -122.437715130621) | ||
| 53238 | 53238 | 50628 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1198 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.720375661427205 | -122.39176255443 | (37.7203756614272, -122.39176255443) | |||
| 54777 | 54777 | 114770 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | ||||
| 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) | ||
| 73839 | 73839 | 39484 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3828 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46800 | 6004242.77277465 | 2102507.2235091 | 37.7533244292691 | -122.428233272856 | (37.7533244292691, -122.428233272856) | ||
| 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) | ||
| 77638 | 77638 | 39764 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 670 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41130 | 6003007.22096458 | 2104433.1722566 | 37.7585426381862 | -122.432643626683 | (37.7585426381862, -122.432643626683) | ||
| 78221 | 78221 | 35112 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 594 Lisbon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.719033250553295 | -122.43595568834999 | (37.7190332505533, -122.43595568835) | ||
| 78819 | 78819 | 96967 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1060 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x9 | Created tree record on 8/15/2011; marked tree basin for expansion. C.Buck | 6003141.0 | 2102066.0 | 37.7520505318065 | -122.432011924137 | (37.7520505318065, -122.432011924137) | |||
| 79904 | 79904 | 64307 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1521 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1988 12:00:00 AM | Permit Number 25118 | 6003982.1529298 | 2099419.88813882 | 37.7448325757503 | -122.42891445905501 | (37.7448325757503, -122.428914459055) | ||
| 80238 | 80238 | 109298 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 251 RHODE ISLAND ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011759.4 | 2107238.5 | 37.766737902166795 | -122.402571748171 | (37.7667379021668, -122.402571748171) | ||||
| 80802 | 80802 | 40582 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 80962 | 80962 | 109300 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 251 RHODE ISLAND ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011759.4 | 2107238.5 | 37.766737902166795 | -122.402571748171 | (37.7667379021668, -122.402571748171) | ||||
| 81035 | 81035 | 67197 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 155 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30649 | 5997964.57682635 | 2106171.52478331 | 37.763028452475204 | -122.450208578402 | (37.7630284524752, -122.450208578402) | ||
| 81677 | 81677 | 30962 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1900 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34754 | 6002009.52813319 | 2115026.44418956 | 37.787572495360706 | -122.436852429478 | (37.7875724953607, -122.436852429478) | ||
| 82175 | 82175 | 67999 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31724 | 5995906.21686349 | 2090968.00525531 | 37.721165330271795 | -122.456228376798 | (37.7211653302718, -122.456228376798) | ||
| 82265 | 82265 | 40570 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1750 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1999 12:00:00 AM | Permit Number 41613 | 6008764.95036499 | 2118846.2736549 | 37.79844243583229 | -122.41375022293 | (37.7984424358323, -122.41375022293) | |||
| 82375 | 82375 | 88393 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 124 23rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51371 | 5988714.5 | 2114502.9 | 37.785370404226796 | -122.48281165726401 | (37.7853704042268, -122.482811657264) | |||
| 82950 | 82950 | 58367 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 48 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1994 12:00:00 AM | Permit Number 17397 | 6003645.80101321 | 2096628.46720423 | 37.7371489313999 | -122.42987842787 | (37.7371489313999, -122.42987842787) | ||
| 83675 | 83675 | 30943 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 84285 | 84285 | 109301 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 251 RHODE ISLAND ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011759.4 | 2107238.5 | 37.766737902166795 | -122.402571748171 | (37.7667379021668, -122.402571748171) | ||||
| 84335 | 84335 | 111029 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 150 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | ||||
| 84619 | 84619 | 33457 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37712 | 6006656.20982267 | 2098052.1703387 | 37.7412281240479 | -122.419571034944 | (37.7412281240479, -122.419571034944) | |||
| 84868 | 84868 | 119660 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699x Missouri St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 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) | ||||
| 85708 | 85708 | 46760 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1180X Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44858 | 6007776.04474552 | 2115482.02501481 | 37.7891494581332 | -122.41693366292101 | (37.7891494581332, -122.416933662921) | |||
| 85726 | 85726 | 40141 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 560X Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1999 12:00:00 AM | Permit Number 41343 | 5996910.70022428 | 2109465.35547876 | 37.772012099368204 | -122.454091465131 | (37.7720120993682, -122.454091465131) | |||
| 86021 | 86021 | 101807 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 733 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 19463 | 6008567.7 | 2104253.0 | 37.7583616995478 | -122.41340018034401 | (37.7583616995478, -122.413400180344) | ||||
| 86167 | 86167 | 52688 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1401@ RIVOLI Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | Permit Number 48758 | 5997782.141834901 | 2105912.5855129 | 37.76230702883 | -122.45082088432301 | (37.76230702883, -122.450820884323) | |||
| 88134 | 88134 | 63546 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1374 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1994 12:00:00 AM | Permit Number 33370 | 6001184.87437591 | 2111109.12550893 | 37.7767696347038 | -122.439424651157 | (37.7767696347038, -122.439424651157) | ||
| 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) | ||||
| 88953 | 88953 | 41713 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 395 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42160 | 6000832.46516562 | 2096676.37340252 | 37.7371207489149 | -122.43960881897499 | (37.7371207489149, -122.439608818975) | ||
| 89144 | 89144 | 31499 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3244 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 35060 | 6006677.13820069 | 2103812.71234735 | 37.7570464414299 | -122.41990734792401 | (37.7570464414299, -122.419907347924) | ||||
| 89422 | 89422 | 101259 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1830 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990081.34478 | 2106545.17551 | 37.763600113076 | -122.47750100502701 | (37.763600113076, -122.477501005027) | ||||
| 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) | ||||
| 89571 | 89571 | 47706 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45502 | 6004240.85369341 | 2097554.18637259 | 37.7397244258614 | -122.42788700337 | (37.7397244258614, -122.42788700337) | ||
| 90986 | 90986 | 114875 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1362 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3x3 | 5999587.7 | 2108019.3 | 37.768194732892205 | -122.444727590707 | (37.7681947328922, -122.444727590707) | |||
| 91011 | 91011 | 51492 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 375 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2005 12:00:00 AM | Permit Number 47803 | 6003974.63917877 | 2102132.0432857 | 37.75227909728871 | -122.429133785293 | (37.7522790972887, -122.429133785293) | ||
| 91197 | 91197 | 38649 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 594 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/1998 12:00:00 AM | Permit Number 40572 | 6001752.37819216 | 2090069.92124104 | 37.719033250553295 | -122.43595568834999 | (37.7190332505533, -122.43595568835) | ||
| 92161 | 92161 | 48868 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 351 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2002 12:00:00 AM | Permit Number 46076 | 5992826.30636272 | 2094323.11375055 | 37.7302003556086 | -122.467118458519 | (37.7302003556086, -122.467118458519) | |||
| 92312 | 92312 | 68409 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 175 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32245 | 5993925.68682399 | 2093845.21689491 | 37.7289515662137 | -122.463283120302 | (37.7289515662137, -122.463283120302) | ||
| 92734 | 92734 | 50056 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 646 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2003 12:00:00 AM | Permit Number 46785 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341001 | (37.7605408596837, -122.42837316341) | |||
| 92804 | 92804 | 40594 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 93076 | 93076 | 109306 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 251 RHODE ISLAND ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011759.4 | 2107238.5 | 37.766737902166795 | -122.402571748171 | (37.7667379021668, -122.402571748171) | ||||
| 93575 | 93575 | 117571 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 DRUMM ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013616.0 | 2118213.0 | 37.7969748404412 | -122.396919555024 | (37.7969748404412, -122.396919555024) | ||||
| 94019 | 94019 | 34503 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1x GUY PL | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462.0 | 2114376.0 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | |||
| 94103 | 94103 | 40573 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1750 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1999 12:00:00 AM | Permit Number 41613 | 6008764.95036499 | 2118846.2736549 | 37.79844243583229 | -122.41375022293 | (37.7984424358323, -122.41375022293) | |||
| 94392 | 94392 | 68407 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 165 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32242 | 5993958.38777264 | 2093823.43780185 | 37.7288936500159 | -122.463168491943 | (37.7288936500159, -122.463168491943) | ||
| 94478 | 94478 | 69541 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 643 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38636 | 6002429.0315791 | 2090033.16165602 | 37.7189707335787 | -122.43361413687 | (37.7189707335787, -122.43361413687) | ||
| 94893 | 94893 | 62793 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1759 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23150 | 6000967.03927329 | 2093906.16285207 | 37.7295220513987 | -122.43894506891701 | (37.7295220513987, -122.438945068917) | ||
| 95085 | 95085 | 68000 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1993 12:00:00 AM | Permit Number 31725 | 5995961.29385488 | 2091144.32738343 | 37.721652630536205 | -122.456050733712 | (37.7216526305362, -122.456050733712) | ||
| 95150 | 95150 | 40591 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 95570 | 95570 | 34506 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1x GUY PL | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462.0 | 2114376.0 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | |||
| 95729 | 95729 | 50433 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 403 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2004 12:00:00 AM | Permit Number 47583 | 5998845.21508396 | 2109355.09330434 | 37.771820083575896 | -122.447391918702 | (37.7718200835759, -122.447391918702) | |||
| 96108 | 96108 | 40569 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1750 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1999 12:00:00 AM | Permit Number 41613 | 6008764.95036499 | 2118846.2736549 | 37.79844243583229 | -122.41375022293 | (37.7984424358323, -122.41375022293) | |||
| 96376 | 96376 | 52283 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 176 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48441 | 6006024.37896521 | 2099203.00634212 | 37.744352450025794 | -122.421837411698 | (37.7443524500258, -122.421837411698) | ||
| 96521 | 96521 | 62611 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2262 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/1986 12:00:00 AM | Permit Number 22921 | 5989510.16412079 | 2099957.30856958 | 37.745478424066704 | -122.478994620655 | (37.7454784240667, -122.478994620655) | ||
| 96883 | 96883 | 40592 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 97485 | 97485 | 34505 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1x GUY PL | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462.0 | 2114376.0 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | |||
| 97675 | 97675 | 34504 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | |||
| 97705 | 97705 | 62343 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 14 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22485 | 6005822.8575705 | 2099672.01958419 | 37.7456288871148 | -122.422567552448 | (37.7456288871148, -122.422567552448) | ||
| 97723 | 97723 | 40574 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 98091 | 98091 | 112610 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 333 SANTA ANA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992649.0 | 2094625.0 | 37.7310190240744 | -122.46775337202101 | (37.7310190240744, -122.467753372021) | ||||
| 98778 | 98778 | 67011 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 319 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30366 | 5995876.19861024 | 2091190.26348134 | 37.72177387546721 | -122.456348203392 | (37.7217738754672, -122.456348203392) | ||
| 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) | |||
| 98865 | 98865 | 38979 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2222 17th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/1998 12:00:00 AM | Permit Number 40762 | 6010839.10372464 | 2106501.59245712 | 37.76466309906579 | -122.405703003871 | (37.7646630990658, -122.405703003871) | |||
| 98999 | 98999 | 111027 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 150 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | ||||
| 99203 | 99203 | 111030 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 150 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | ||||
| 99248 | 99248 | 62802 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1975 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23159 | 5999892.27432069 | 2092450.57844744 | 37.7254641444646 | -122.44255616077801 | (37.7254641444646, -122.442556160778) | ||
| 99289 | 99289 | 62804 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1999 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23161 | 5999778.16418017 | 2092287.72080324 | 37.725010469703896 | -122.442938938279 | (37.7250104697039, -122.442938938279) | ||
| 99577 | 99577 | 41627 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1095 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42109 | 6007646.45182189 | 2109473.56842462 | 37.7726443942379 | -122.416956155908 | (37.7726443942379, -122.416956155908) | |||
| 99834 | 99834 | 40859 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1670 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42380 | 6009721.65724328 | 2100087.27684169 | 37.746988275084895 | -122.409115329349 | (37.7469882750849, -122.409115329349) | ||
| 99960 | 99960 | 34514 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1x GUY PL | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462.0 | 2114376.0 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | |||
| 100190 | 100190 | 111034 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 150 15th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | ||||
| 100813 | 100813 | 62237 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 61 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | Permit Number 22363 | 6001374.44401127 | 2093790.00837779 | 37.7292262892939 | -122.437528318003 | (37.7292262892939, -122.437528318003) | ||
| 101528 | 101528 | 62348 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 57 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22491 | 6005543.85080152 | 2099604.02987317 | 37.745426458533004 | -122.42352748403799 | (37.745426458533, -122.423527484038) | ||
| 102317 | 102317 | 32425 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 275 Maywood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 36952 | 5994490.2461397005 | 2094811.13335462 | 37.7316362454296 | -122.461401406739 | (37.7316362454296, -122.461401406739) | ||||
| 102389 | 102389 | 30957 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 102531 | 102531 | 62344 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 16 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22486 | 6005809.69914418 | 2099671.2694643 | 37.7456260851044 | -122.422612999068 | (37.7456260851044, -122.422612999068) | ||
| 102630 | 102630 | 94890 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 491 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997284.0 | 2107398.0 | 37.7663570704681 | -122.452650969879 | (37.7663570704681, -122.452650969879) | |||||
| 102721 | 102721 | 109297 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 251 RHODE ISLAND ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011759.4 | 2107238.5 | 37.766737902166795 | -122.402571748171 | (37.7667379021668, -122.402571748171) | ||||
| 103250 | 103250 | 32424 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 275 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 36952 | 5994490.2461397005 | 2094811.13335462 | 37.7316362454296 | -122.461401406739 | (37.7316362454296, -122.461401406739) | ||||
| 103632 | 103632 | 95070 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2165 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989059.0 | 2106465.0 | 37.763320595920504 | -122.48103106212099 | (37.7633205959205, -122.481031062121) | ||||
| 104144 | 104144 | 67758 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4394 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1995 12:00:00 AM | Permit Number 31437 | 6001339.65304045 | 2101178.10506013 | 37.7495102967122 | -122.43817763611999 | (37.7495102967122, -122.43817763612) | ||
| 104206 | 104206 | 66239 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1023 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29337 | 5995901.80991046 | 2090714.82365274 | 37.720469900548004 | -122.45622531376301 | (37.720469900548, -122.456225313763) | ||
| 104296 | 104296 | 46759 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1180X Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44858 | 6007776.04474552 | 2115482.02501481 | 37.7891494581332 | -122.41693366292101 | (37.7891494581332, -122.416933662921) | |||
| 104336 | 104336 | 111031 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 150 15th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | ||||
| 104653 | 104653 | 30945 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 104742 | 104742 | 114771 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | ||||
| 104824 | 104824 | 67990 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 324 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31715 | 5995860.10496142 | 2091242.55276948 | 37.7219165255419 | -122.45640761373998 | (37.7219165255419, -122.45640761374) | ||
| 104953 | 104953 | 34513 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) |
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");