Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
87892 | 87892 | 54921 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 363 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 13 | 4x6 | Permit Number 10790 | 5992776.0461415 | 2094204.68994573 | 37.7298722918639 | -122.467283605749 | (37.7298722918639, -122.467283605749) | |
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) | ||
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) | ||
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) | ||||
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) | ||
89768 | 89768 | 40147 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 580X Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642.0 | 2110547.0 | 37.7754223144781 | -122.42742536240299 | (37.7754223144781, -122.427425362403) | |
90105 | 90105 | 40145 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 580X Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642.0 | 2110547.0 | 37.7754223144781 | -122.42742536240299 | (37.7754223144781, -122.427425362403) | |
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) | ||
91463 | 91463 | 21851 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 199X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 5995125.29913 | 2110753.8462799997 | 37.7754474178474 | -122.46036063726801 | (37.7754474178474, -122.460360637268) | |||
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) | ||
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) | |||
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) | |||
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) | ||
94486 | 94486 | 80829 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3100 Turk Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.45692919798401 | (37.7774658426, -122.456929197984) | |
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) | ||
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) | |||
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) | |||
96083 | 96083 | 19297 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 40X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5995496.87098 | 2110852.98465 | 37.775740993063394 | -122.459082470822 | (37.7757409930634, -122.459082470822) | |||
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) | ||
97107 | 97107 | 21857 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 215X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4.5X4.5 | 5994989.01038 | 2110754.0886 | 37.775440242331705 | -122.460832106591 | (37.7754402423317, -122.460832106591) | |||
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) | ||
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) | ||
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) | ||||
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) | |||
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) | ||
100932 | 100932 | 66607 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1991 12:00:00 AM | 12 | Permit Number 29802 | 5989869.39246895 | 2090726.40504468 | 37.7201535727537 | -122.477078065149 | (37.7201535727537, -122.477078065149) | ||
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) | |||
101099 | 101099 | 51012 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 85 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2016 12:00:00 AM | 3 | Permit Number 778086 | 6001486.35916374 | 2107715.14620283 | 37.7674677672856 | -122.438138542404 | (37.7674677672856, -122.438138542404) | ||
101227 | 101227 | 87200 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 123 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 2 | 3x3 | 5995204.25641 | 2110758.6189099997 | 37.77546506387571 | -122.460087853041 | (37.7754650638757, -122.460087853041) | ||
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) | |||||
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) | ||||
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) | |||
105147 | 105147 | 32286 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1800 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | Permit Number 36869 | 6001579.61916409 | 2114619.58179026 | 37.7864309126762 | -122.438310666952 | (37.7864309126762, -122.438310666952) | |||
105988 | 105988 | 80832 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3100 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.45692919798401 | (37.7774658426, -122.456929197984) | |
106242 | 106242 | 30959 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2401 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34753 | 6002022.0507416995 | 2114644.40993289 | 37.7865242387809 | -122.436781745524 | (37.7865242387809, -122.436781745524) | ||
106261 | 106261 | 40584 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 16 | 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) | ||
106967 | 106967 | 33954 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1999 12:00:00 AM | Permit Number 48991 | 6002287.323724099 | 2097040.91143479 | 37.7382043832783 | -122.43460477820899 | (37.7382043832783, -122.434604778209) | |||
107562 | 107562 | 98700 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2490X Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000865.0 | 2116767.3 | 37.7922873178989 | -122.440937193321 | (37.7922873178989, -122.440937193321) | ||||
108097 | 108097 | 40150 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 560X Stanyan St | 2 | 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) | |||
108452 | 108452 | 111033 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 150 15th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | ||||
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) | |||
109087 | 109087 | 67802 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4022 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31449 | 6003744.51176452 | 2100434.22126683 | 37.7476042452744 | -122.429808512801 | (37.7476042452744, -122.429808512801) | ||
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) | |||
109688 | 109688 | 34444 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 74 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38188 | 6004269.61043081 | 2097757.70943651 | 37.7402848805672 | -122.42780207260401 | (37.7402848805672, -122.427802072604) | ||
109737 | 109737 | 47778 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 872 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | Permit Number 45554 | 5999190.57637215 | 2107256.51251673 | 37.7660776404196 | -122.446046324392 | (37.7660776404196, -122.446046324392) | |||
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) | |||
110282 | 110282 | 40593 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 18 | 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) | ||
110371 | 110371 | 40595 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 23 | 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) | ||
110730 | 110730 | 30946 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 14 | 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) | ||
111007 | 111007 | 62345 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 21 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/1989 12:00:00 AM | Permit Number 27053 | 6005775.86880093 | 2099617.25647877 | 37.7454758690666 | -122.42272614169201 | (37.7454758690666, -122.422726141692) | ||
111072 | 111072 | 34510 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 3 | 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) | |||
111494 | 111494 | 46758 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1180X Bush St | 3 | 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) | |||
111649 | 111649 | 30955 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 3 | 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) | ||
111874 | 111874 | 40571 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1750 Taylor St | 3 | 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) | |||
111998 | 111998 | 34446 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 84 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38190 | 6004274.31729793 | 2097673.91474862 | 37.7400550657314 | -122.427779829106 | (37.7400550657314, -122.427779829106) | ||
112313 | 112313 | 34507 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 8 | 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) | |||
112849 | 112849 | 50043 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3920@ SANCHEZ 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2003 12:00:00 AM | Permit Number 46774 | 6003513.59033802 | 2104807.4010588 | 37.759598884966 | -122.43091908204799 | (37.759598884966, -122.430919082048) | |||
112946 | 112946 | 68795 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2574 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32734 | 5991441.9162308 | 2097904.96501407 | 37.7399552051973 | -122.472165418715 | (37.7399552051973, -122.472165418715) | ||
113099 | 113099 | 40587 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 24 | 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) | ||
113112 | 113112 | 66524 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 625 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1992 12:00:00 AM | Permit Number 30334 | 6002498.75858532 | 2099723.40130775 | 37.7455818770993 | -122.434065444251 | (37.7455818770993, -122.434065444251) | ||
113178 | 113178 | 62792 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23149 | 6001049.88033752 | 2093967.86468253 | 37.7296961834546 | -122.438663099148 | (37.7296961834546, -122.438663099148) | ||
113251 | 113251 | 30948 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 11 | 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) |
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");