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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 155823 | 155823 | 136397 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3101 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005394.36926 | 2121578.01878 | 37.805753249883296 | -122.42560800722201 | (37.8057532498833, -122.425608007222) | |||
| 30260 | 30260 | 66355 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 842 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1992 12:00:00 AM | 15 | Permit Number 30970 | 6006677.47104 | 2121530.77464 | 37.8056959468756 | -122.421164278004 | (37.8056959468756, -122.421164278004) | ||
| 133390 | 133390 | 136409 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 842 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006660.27823 | 2121526.69808 | 37.805683784442394 | -122.421223486682 | (37.8056837844424, -122.421223486682) | |||
| 176319 | 176319 | 136396 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3651 Baker St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 5999117.86509 | 2121345.1324299998 | 37.8047571571746 | -122.447311924407 | (37.8047571571746, -122.447311924407) | |||
| 178125 | 178125 | 68986 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1990 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 18 | Permit Number 32976 | 5999758.99431 | 2121250.9256 | 37.8045351046614 | -122.44508646208999 | (37.8045351046614, -122.44508646209) | |
| 171198 | 171198 | 142669 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 444 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6009205.7299 | 2121176.5543 | 37.8048655501446 | -122.412389783451 | (37.8048655501446, -122.412389783451) | |||
| 95701 | 95701 | 142670 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 444 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009183.2325 | 2121175.0028 | 37.8048600276109 | -122.412467528668 | (37.8048600276109, -122.412467528668) | |||
| 189142 | 189142 | 142672 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 444 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6009151.8318 | 2121171.42 | 37.80484842791721 | -122.412575941125 | (37.8048484279172, -122.412575941125) | |||
| 62101 | 62101 | 142671 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 444 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6009139.9801 | 2121168.8436 | 37.804840688618896 | -122.41261677310301 | (37.8048406886189, -122.412616773103) | |||
| 171553 | 171553 | 114997 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 460 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009124.5214 | 2121167.813 | 37.8048369912448 | -122.41267019686899 | (37.8048369912448, -122.412670196869) | |||
| 24499 | 24499 | 114998 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 460 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6009108.5473 | 2121165.2365 | 37.8048290202645 | -122.412725294876 | (37.8048290202645, -122.412725294876) | |||
| 153302 | 153302 | 114999 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 460 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6009096.1804 | 2121164.206 | 37.804825496651894 | -122.41276801909599 | (37.8048254966519, -122.412768019096) | |||
| 30839 | 30839 | 115000 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 460 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6009069.9005 | 2121160.0836 | 37.804812702509 | -122.412858672154 | (37.804812702509, -122.412858672154) | |||
| 121189 | 121189 | 47784 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 411 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | Permit Number 45557 | 6009328.94293981 | 2121149.73408628 | 37.8047988220658 | -122.4119614934 | (37.8047988220658, -122.4119614934) | |||
| 125774 | 125774 | 47783 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 411 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | Permit Number 45557 | 6009328.94293981 | 2121149.73408628 | 37.8047988220658 | -122.4119614934 | (37.8047988220658, -122.4119614934) | |||
| 37342 | 37342 | 142551 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 451 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6009269.3434 | 2121145.5233 | 37.80478391634529 | -122.41216744681101 | (37.8047839163453, -122.412167446811) | |||
| 33092 | 33092 | 142733 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 451 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009242.9671 | 2121140.0929 | 37.8047675258137 | -122.412258341021 | (37.8047675258137, -122.412258341021) | |||
| 146268 | 146268 | 47788 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 445 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | Permit Number 45558 | 6009171.86340947 | 2121127.78288236 | 37.8047297355065 | -122.412503532854 | (37.8047297355065, -122.412503532854) | |||
| 169478 | 169478 | 47789 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 445 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | 7 | Permit Number 45558 | 6009148.3227 | 2121126.9048 | 37.8047260033811 | -122.41258493604401 | (37.8047260033811, -122.412584936044) | ||
| 51097 | 51097 | 47786 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 445 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | 8 | Permit Number 45558 | 6009129.7041 | 2121124.5774 | 37.804718567986704 | -122.41264920318999 | (37.8047185679867, -122.41264920319) | ||
| 188671 | 188671 | 47787 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 445 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | 7 | Permit Number 45558 | 6009109.534 | 2121122.2501 | 37.8047110457521 | -122.412718839471 | (37.8047110457521, -122.412718839471) | ||
| 149162 | 149162 | 68014 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3400 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1993 12:00:00 AM | 1 | Permit Number 31744 | 5999283.32146 | 2120515.0435200003 | 37.8024874104189 | -122.446679585917 | (37.8024874104189, -122.446679585917) | ||
| 44389 | 44389 | 59288 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2067 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1980 12:00:00 AM | 17 | Permit Number 18625 | 6003010.51633 | 2119230.45541 | 37.7991724689015 | -122.433689789967 | (37.7991724689015, -122.433689789967) | ||
| 40850 | 40850 | 136407 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6009007.217180001 | 2119024.8122799997 | 37.798946260622294 | -122.412924532036 | (37.7989462606223, -122.412924532036) | |||
| 139881 | 139881 | 136406 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6008985.36131 | 2119021.64248 | 37.7989363302909 | -122.412999936617 | (37.7989363302909, -122.412999936617) | |||
| 49719 | 49719 | 136405 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6008967.16736 | 2119019.94772 | 37.7989306555735 | -122.413062774033 | (37.7989306555735, -122.413062774033) | |||
| 55609 | 55609 | 136404 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6008943.49637 | 2119016.81507 | 37.7989207252599 | -122.413144462145 | (37.7989207252599, -122.413144462145) | |||
| 152764 | 152764 | 136403 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6008921.12724 | 2119013.91425 | 37.7989115045253 | -122.41322166175699 | (37.7989115045253, -122.413221661757) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 128654 | 128654 | 40572 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1750 Taylor St | 4 | 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) | |||
| 51181 | 51181 | 136415 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 640 Davis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013156.852000001 | 2118810.40691 | 37.7985896092893 | -122.398550270302 | (37.7985896092893, -122.398550270302) | |||
| 60479 | 60479 | 136414 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 640 Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013178.6157 | 2118647.5125700003 | 37.798143552740505 | -122.398463524392 | (37.7981435527405, -122.398463524392) | |||
| 171134 | 171134 | 136408 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1120 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008149.75151 | 2118608.08883 | 37.7977538729053 | -122.41586213153299 | (37.7977538729053, -122.415862131533) | |||
| 29182 | 29182 | 136399 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1667 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005091.5128 | 2118475.84475 | 37.7972183598879 | -122.42643506691999 | (37.7972183598879, -122.42643506692) | |||
| 135764 | 135764 | 40086 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1667 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/1999 12:00:00 AM | 9 | Permit Number 41307 | 6005062.9841 | 2118469.14548 | 37.797198352666605 | -122.426533306168 | (37.7971983526666, -122.426533306168) | ||
| 67118 | 67118 | 136413 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 550 Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6013222.1695 | 2118341.7234900002 | 37.797306354955204 | -122.39829134828399 | (37.7973063549552, -122.398291348284) | |||
| 173635 | 173635 | 40380 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1700 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1999 12:00:00 AM | 6 | Permit Number 41492 | 6008347.41967 | 2118338.8873799997 | 37.7970258231379 | -122.41515907753401 | (37.7970258231379, -122.415159077534) | ||
| 74775 | 74775 | 136412 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 550 Davis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6013223.706619999 | 2118326.48177 | 37.797264590440605 | -122.39828495948099 | (37.7972645904406, -122.398284959481) | |||
| 34052 | 34052 | 136411 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 160 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6013483.17698 | 2118325.06374 | 37.797275146684 | -122.397387020609 | (37.797275146684, -122.397387020609) | |||
| 72286 | 72286 | 136410 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1700 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008350.5752 | 2118320.27531 | 37.7969748963406 | -122.415146840471 | (37.7969748963406, -122.415146840471) | |||
| 155966 | 155966 | 49096 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 550 Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 3 | Permit Number 46244 | 6013227.233659999 | 2118310.02974 | 37.7972196135456 | -122.398271600054 | (37.7972196135456, -122.398271600054) | ||
| 130459 | 130459 | 113597 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6013588.4505 | 2118285.15352 | 37.7971714233818 | -122.39701994521099 | (37.7971714233818, -122.397019945211) | |||
| 178033 | 178033 | 113596 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6013590.96742 | 2118268.55465 | 37.797125986926204 | -122.397010071555 | (37.7971259869262, -122.397010071555) | |||
| 154840 | 154840 | 136416 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6013522.9960199995 | 2118258.2651 | 37.797093950371 | -122.397244549101 | (37.797093950371, -122.397244549101) | |||
| 168129 | 168129 | 113595 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 2 | 3x3 | 6013594.82153 | 2118250.31526 | 37.7970761204252 | -122.39699545579201 | (37.7970761204252, -122.396995455792) | ||
| 30125 | 30125 | 136417 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6013524.76569 | 2118243.85815 | 37.797054490825 | -122.397237414787 | (37.797054490825, -122.397237414787) | |||
| 164274 | 164274 | 113594 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6013595.86878 | 2118231.42432 | 37.797024308676896 | -122.396990506826 | (37.7970243086769, -122.396990506826) | |||
| 173345 | 173345 | 136418 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013527.00347 | 2118227.13229 | 37.797008690162 | -122.397228498003 | (37.797008690162, -122.397228498003) | |||
| 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) | ||||
| 172147 | 172147 | 136419 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013531.07074 | 2118211.65227 | 37.7969664121295 | -122.397213338118 | (37.7969664121295, -122.397213338118) | |||
| 59700 | 59700 | 136420 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013531.80462 | 2118197.0098599996 | 37.7969262483997 | -122.39720977141701 | (37.7969262483997, -122.397209771417) | |||
| 37833 | 37833 | 71250 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1240 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 11 | 6x3 | 6007647.94637 | 2118195.049 | 37.796591545013705 | -122.417569230932 | (37.7965915450137, -122.417569230932) | |
| 7015 | 7015 | 23458 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2252 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 4X4 | 6005965.50421 | 2118183.1057 | 37.7964639393172 | -122.423390011952 | (37.7964639393172, -122.423390011952) | |||
| 159729 | 159729 | 136421 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013535.0626 | 2118179.75007 | 37.796879038483894 | -122.39719728705 | (37.7968790384839, -122.39719728705) | |||
| 65568 | 65568 | 136422 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013539.98314 | 2118153.1822099998 | 37.7968063633679 | -122.397178396789 | (37.7968063633679, -122.397178396789) | |||
| 154397 | 154397 | 113593 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6013606.07873 | 2118153.0691400003 | 37.796809732248896 | -122.39694968118299 | (37.7968097322489, -122.396949681183) | |||
| 54975 | 54975 | 113592 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6013608.47765 | 2118139.1354900002 | 37.7967716072789 | -122.39694040288799 | (37.7967716072789, -122.396940402888) | |||
| 173822 | 173822 | 136423 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013540.78751 | 2118131.64516 | 37.796747272512604 | -122.397174102497 | (37.7967472725126, -122.397174102497) | |||
| 177879 | 177879 | 113591 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6013610.58042 | 2118128.2339 | 37.796741791142004 | -122.39693236204799 | (37.796741791142, -122.396932362048) | |||
| 121244 | 121244 | 136424 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013541.7115 | 2118113.66267 | 37.7966979482953 | -122.39716964367202 | (37.7966979482953, -122.397169643672) | |||
| 71184 | 71184 | 113590 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 2 | 3x3 | 6013615.62221 | 2118103.5659 | 37.7966743392965 | -122.396913185795 | (37.7966743392965, -122.396913185795) | ||
| 24938 | 24938 | 136425 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6013547.46214 | 2118092.2461 | 37.7966394636056 | -122.397148242524 | (37.7966394636056, -122.397148242524) | |||
| 43292 | 43292 | 113589 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6013618.317290001 | 2118086.59987 | 37.796627904610204 | -122.39690267003799 | (37.7966279046102, -122.396902670038) | |||
| 138261 | 138261 | 136426 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013550.70975 | 2118074.47295 | 37.796590843538496 | -122.39713575811199 | (37.7965908435385, -122.397135758112) | |||
| 25697 | 25697 | 136427 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6013551.1495199995 | 2118058.04 | 37.796545747032 | -122.397133083548 | (37.796545747032, -122.397133083548) | |||
| 162005 | 162005 | 57496 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2090 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1988 12:00:00 AM | 15 | Permit Number 25529 | 6003581.68174 | 2117969.3231200003 | 37.7957421173574 | -122.43162327739401 | (37.7957421173574, -122.431623277394) | ||
| 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) | |||
| 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) | ||||
| 162009 | 162009 | 46548 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3042 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2005 12:00:00 AM | 7 | Permit Number 47880 | 5999598.88033 | 2116387.07823 | 37.7911711367754 | -122.44529062887501 | (37.7911711367754, -122.445290628875) | ||
| 150999 | 150999 | 250462 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 290 Seacliff Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5986816.96544 | 2115727.4811 | 37.7886221640356 | -122.489466544563 | (37.7886221640356, -122.489466544563) | |||
| 128089 | 128089 | 39913 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2116 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | Permit Number 770988 | 6000956.0 | 2115624.0 | 37.78915329587029 | -122.440540293957 | (37.7891532958703, -122.440540293957) | ||
| 65990 | 65990 | 136400 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1128 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007907.63985 | 2115517.19966 | 37.7892534404542 | -122.416480851612 | (37.7892534404542, -122.416480851612) | |||
| 135164 | 135164 | 136401 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1128 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007893.037769999 | 2115514.03443 | 37.789243928322705 | -122.416531148891 | (37.7892439283227, -122.416531148891) | |||
| 152130 | 152130 | 136402 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1128 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007876.49139 | 2115513.01244 | 37.789240191634896 | -122.416588325105 | (37.7892401916349, -122.416588325105) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 151731 | 151731 | 138285 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2603 CALIFORNIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001869.0685 | 2115321.3526 | 37.788374254187396 | -122.437359516387 | (37.7883742541874, -122.437359516387) | |||
| 188954 | 188954 | 138288 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2605 CALIFORNIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001853.9989 | 2115318.2614 | 37.7883649098379 | -122.43741143323999 | (37.7883649098379, -122.43741143324) | |||
| 129664 | 129664 | 136395 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3395 Sacramento St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998880.24558 | 2115260.774 | 37.7880375552225 | -122.44769595741 | (37.7880375552225, -122.44769595741) | |||
| 180021 | 180021 | 136394 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3395 Sacramento St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998858.96294 | 2115256.3275900004 | 37.78802413016879 | -122.447769271056 | (37.7880241301688, -122.447769271056) | |||
| 152609 | 152609 | 136393 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3395 Sacramento St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5998838.23431 | 2115253.6710900003 | 37.7880156513567 | -122.447840796819 | (37.7880156513567, -122.447840796819) | |||
| 174770 | 174770 | 136392 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3395 Sacramento St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5998815.16498 | 2115250.29133 | 37.788005052827394 | -122.447920368844 | (37.7880050528274, -122.447920368844) | |||
| 131482 | 131482 | 136391 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3395 Sacramento St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5998783.391419999 | 2115244.6481 | 37.7879877418005 | -122.448029892768 | (37.7879877418005, -122.448029892768) | |||
| 37444 | 37444 | 136389 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3395 Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5998748.07929 | 2115242.8098299997 | 37.787980675804796 | -122.448151933487 | (37.7879806758048, -122.448151933487) | |||
| 178401 | 178401 | 136388 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3395 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998725.2896300005 | 2115240.45377 | 37.7879729038643 | -122.44823061157 | (37.7879729038643, -122.44823061157) | |||
| 179850 | 179850 | 136387 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3395 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998704.14947 | 2115236.6477799998 | 37.7879612450483 | -122.448303478237 | (37.7879612450483, -122.448303478237) | |||
| 173794 | 173794 | 136386 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3395 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998684.868290001 | 2115235.24815 | 37.7879562997004 | -122.44837008653 | (37.7879562997004, -122.44837008653) | |||
| 148392 | 148392 | 136385 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3395 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998661.8986 | 2115230.4511700002 | 37.787941815198 | -122.448449211579 | (37.787941815198, -122.448449211579) | |||
| 71747 | 71747 | 30965 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1932 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 12 | Permit Number 34756 | 6001977.8019 | 2115220.4687 | 37.7881034337143 | -122.436976091665 | (37.7881034337143, -122.436976091665) | |
| 182966 | 182966 | 56642 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 345 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1981 12:00:00 AM | 12 | Permit Number 19074 | 5997614.66831 | 2115182.9881700003 | 37.787751563636206 | -122.452068994515 | (37.7877515636362, -122.452068994515) | ||
| 168246 | 168246 | 136383 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 345 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5997619.24971 | 2115159.44048 | 37.7876871703592 | -122.452051444224 | (37.7876871703592, -122.452051444224) | |||
| 183612 | 183612 | 136384 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3604 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5997592.70923 | 2115124.52811 | 37.787589789978206 | -122.452140748718 | (37.7875897899782, -122.452140748718) | |||
| 64070 | 64070 | 138318 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1900 PIERCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001997.4008 | 2115093.6522 | 37.787756342072704 | -122.43689920077499 | (37.7877563420727, -122.436899200775) | |||
| 26091 | 26091 | 138387 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1905 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6001950.5989 | 2115065.5557 | 37.787676536151295 | -122.43705911384 | (37.7876765361513, -122.43705911384) | |||
| 141331 | 141331 | 30966 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1901X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 16 | 3x3 | Permit Number 34757 | 6001967.37934743 | 2115036.16142537 | 37.7875967808045 | -122.436998951614 | (37.7875967808045, -122.436998951614) |
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");