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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 2263 | 2263 | 22364 | Landmark tree 9 | Schinus terebinthifolius :: Brazilian Pepper 25 | 5490X 03rd St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 40TR | 6014151.6099 | 2093070.9929 | 37.7279701830365 | -122.393305916851 | (37.7279701830365, -122.393305916851) | |||
| 64857 | 64857 | 239685 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1601x Alabama St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6009289.0171 | 2100045.3572 | 37.7468489265392 | -122.41060840725201 | (37.7468489265392, -122.410608407252) | |||
| 87349 | 87349 | 807 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600X 39th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983808.206040001 | 2111664.13118 | 37.7772892893219 | -122.49957581574499 | (37.7772892893219, -122.499575815745) | |||
| 104485 | 104485 | 24342 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600X 39th Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 119968 | 119968 | 104734 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 5490x 03RD ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 9x9 | 6014203.0 | 2093127.0 | 37.7281268221954 | -122.39313217573601 | (37.7281268221954, -122.393132175736) | |||
| 121730 | 121730 | 803 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 680X 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983825.76498 | 2111129.60729 | 37.7758226717015 | -122.499475562851 | (37.7758226717015, -122.499475562851) | |||
| 143285 | 143285 | 814 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600X 39th Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 145945 | 145945 | 805 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 680X 39th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983823.96426 | 2111160.91126 | 37.7759085177004 | -122.499484105844 | (37.7759085177004, -122.499484105844) | |||
| 170156 | 170156 | 117839 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600x 39th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 5983810.52385 | 2111649.02031 | 37.7772479352498 | -122.499566680778 | (37.7772479352498, -122.499566680778) | |||
| 22874 | 22874 | 179489 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 36 Goettingen St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6009813.802999999 | 2094277.0712700002 | 37.7310398674871 | -122.40838693792801 | (37.7310398674871, -122.408386937928) | |||
| 35849 | 35849 | 197509 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | 6009753.46902 | 2109444.94334 | 37.7726840927246 | -122.40966570732999 | (37.7726840927246, -122.40966570733) | ||||
| 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) | |||
| 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) | |||
| 56877 | 56877 | 239719 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4818 25th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 10ft | 5999936.15376 | 2101092.9328900003 | 37.7491965123129 | -122.44302484724199 | (37.7491965123129, -122.443024847242) | |||
| 59759 | 59759 | 239693 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3591 21st St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6004448.48684 | 2103643.67064 | 37.7564564838073 | -122.427602831218 | (37.7564564838073, -122.427602831218) | |||
| 66375 | 66375 | 239694 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3591 21st St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 4ft | 6004424.11255 | 2103642.04676 | 37.756450646292 | -122.427687010443 | (37.756450646292, -122.427687010443) | |||
| 73324 | 73324 | 239692 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3591 21st St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 4ft | 6004466.4231900005 | 2103643.72661 | 37.7564576520127 | -122.427540804958 | (37.7564576520127, -122.427540804958) | |||
| 73424 | 73424 | 197511 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | 6009774.86658 | 2109479.2363299998 | 37.772779452333204 | -122.40959411137699 | (37.7727794523332, -122.409594111377) | ||||
| 74711 | 74711 | 197510 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | 6009757.95432 | 2109468.4994900003 | 37.7727490237764 | -122.409651855072 | (37.7727490237764, -122.409651855072) | ||||
| 130197 | 130197 | 239721 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 400 Clipper St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 6002485.20231 | 2100944.35113 | 37.7489335487424 | -122.434199588643 | (37.7489335487424, -122.434199588643) | |||
| 132434 | 132434 | 197513 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | 6009803.31754 | 2109510.05508 | 37.7728656676608 | -122.409497871353 | (37.7728656676608, -122.409497871353) | ||||
| 137734 | 137734 | 197516 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6009818.3758 | 2109520.83011 | 37.772896097121894 | -122.40944654343299 | (37.7728960971219, -122.409446543433) | ||||
| 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) | |||
| 150992 | 150992 | 239722 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 400 Clipper St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6002450.40135 | 2100940.8188400003 | 37.7489218746471 | -122.434319677816 | (37.7489218746471, -122.434319677816) | |||
| 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) | |||
| 156380 | 156380 | 197515 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | 6009794.12284 | 2109513.9369200002 | 37.7728758110884 | -122.409529951052 | (37.7728758110884, -122.409529951052) | ||||
| 160321 | 160321 | 197508 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 6009725.72224 | 2109430.36659 | 37.7726425134742 | -122.409760657749 | (37.7726425134742, -122.409760657749) | ||||
| 168035 | 168035 | 239718 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4818 25th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 10ft | 5999936.3704699995 | 2101089.09136 | 37.74918597675529 | -122.44302382201401 | (37.7491859767553, -122.443023822014) | |||
| 169554 | 169554 | 197514 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | 6009780.84318 | 2109499.43172 | 37.7728352390743 | -122.409574863193 | (37.7728352390743, -122.409574863193) | ||||
| 183895 | 183895 | 197512 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6009788.18393 | 2109495.5877 | 37.7728250956205 | -122.40954919922899 | (37.7728250956205, -122.409549199229) | ||||
| 188316 | 188316 | 239691 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3591 21st St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 4ft | 6004486.515980001 | 2103644.80101 | 37.756461738522 | -122.427471393514 | (37.756461738522, -122.427471393514) | |||
| 27661 | 27661 | 179429 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Brookdale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6006237.48001 | 2087456.42565 | 37.712110920858706 | -122.420267010915 | (37.7121109208587, -122.420267010915) | |||
| 30401 | 30401 | 197533 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Missouri St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6013601.75095 | 2103896.53741 | 37.757664290394295 | -122.395965104316 | (37.7576642903943, -122.395965104316) | ||||
| 30646 | 30646 | 123738 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 301 Cabrillo St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5994608.02307 | 2110726.73042 | 37.775343195361295 | -122.46214803765801 | (37.7753431953613, -122.462148037658) | |||
| 33568 | 33568 | 179425 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006737.87137 | 2087492.2529799999 | 37.712237478839796 | -122.418540048182 | (37.7122374788398, -122.418540048182) | |||
| 34284 | 34284 | 179448 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006504.268209999 | 2087381.76307 | 37.7119209426602 | -122.419339618327 | (37.7119209426602, -122.419339618327) | |||
| 34902 | 34902 | 215020 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 501 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5998758.39397 | 2094948.38752 | 37.732257843614704 | -122.44665550384701 | (37.7322578436147, -122.446655503847) | |||
| 37203 | 37203 | 179446 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 127 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006032.90525 | 2087456.2020599998 | 37.712098777304 | -122.42097406600901 | (37.712098777304, -122.420974066009) | |||
| 37944 | 37944 | 179455 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1651 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006947.074519999 | 2087492.6533099997 | 37.7122503535477 | -122.417817006765 | (37.7122503535477, -122.417817006765) | |||
| 40375 | 40375 | 179440 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Blythdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007040.38457 | 2086896.48953 | 37.7106186631909 | -122.417452275027 | (37.7106186631909, -122.417452275027) | |||
| 43291 | 43291 | 197532 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Missouri St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6013605.01625 | 2103874.9640900004 | 37.757605236406995 | -122.39595229975299 | (37.757605236407, -122.395952299753) | ||||
| 44932 | 44932 | 179450 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006580.779159999 | 2087379.51909 | 37.7119190900695 | -122.41907501532499 | (37.7119190900695, -122.419075015325) | |||
| 46358 | 46358 | 179434 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6006514.55403 | 2086760.1932299999 | 37.710214821715496 | -122.419260003144 | (37.7102148217155, -122.419260003144) | |||
| 48306 | 48306 | 179432 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6006549.425009999 | 2086808.7283400001 | 37.7103500527955 | -122.419142922204 | (37.7103500527955, -122.419142922204) | |||
| 48668 | 48668 | 179445 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 50 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006641.641 | 2087043.6428599998 | 37.7110002716098 | -122.418840853438 | (37.7110002716098, -122.418840853438) | |||
| 51527 | 51527 | 179437 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 121 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6006551.53826 | 2086713.5575599999 | 37.71008885278471 | -122.419128872099 | (37.7100888527847, -122.419128872099) | |||
| 51699 | 51699 | 179433 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006535.42412 | 2086786.7518099998 | 37.7102889213719 | -122.419189754426 | (37.7102889213719, -122.419189754426) | |||
| 51882 | 51882 | 179443 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 20 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6006639.5983 | 2087274.4168099998 | 37.711633813430204 | -122.418864269997 | (37.7116338134302, -122.418864269997) | |||
| 54669 | 54669 | 179439 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006794.78813 | 2086912.99237 | 37.7106501547416 | -122.418302281839 | (37.7106501547416, -122.418302281839) | |||
| 56796 | 56796 | 215019 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 113 Stillings Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 10ft | 6000031.68078 | 2095690.19732 | 37.7343673311927 | -122.44230670979601 | (37.7343673311927, -122.442306709796) | |||
| 57884 | 57884 | 239673 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 51 Tiffany Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 6006373.75126 | 2099735.68708 | 37.7458347673547 | -122.420667160657 | (37.7458347673547, -122.420667160657) | |||
| 61007 | 61007 | 215018 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 113 Stillings Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6000011.08105 | 2095687.8075 | 37.734359595202996 | -122.442377758036 | (37.734359595203, -122.442377758036) | ||||
| 61560 | 61560 | 197535 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Missouri St | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6013599.31223 | 2104067.77122 | 37.7581343255511 | -122.39598553779499 | (37.7581343255511, -122.395985537795) | |||
| 62271 | 62271 | 179447 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 154 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6006213.66342 | 2087416.73528 | 37.712000597419795 | -122.420346512779 | (37.7120005974198, -122.420346512779) | |||
| 66751 | 66751 | 197556 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Kansas St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | Width 4ft | 6011387.43171 | 2107337.57251 | 37.7669891592581 | -122.403865303157 | (37.7669891592581, -122.403865303157) | |||
| 72176 | 72176 | 197536 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Missouri St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6013614.8063 | 2103893.08079 | 37.7576555255942 | -122.39591971103201 | (37.7576555255942, -122.395919711032) | ||||
| 74804 | 74804 | 197559 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Kansas St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 4ft | 6011390.59783 | 2107261.9100099998 | 37.7667815840329 | -122.403849027227 | (37.7667815840329, -122.403849027227) | |||
| 77723 | 77723 | 116380 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4299X 17TH ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 15 | 3x3 | 6000957.0 | 2105810.0 | 37.762206586209295 | -122.439832910658 | (37.7622065862093, -122.439832910658) | |||
| 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) | |||||
| 109554 | 109554 | 119661 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699x Missouri St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 119456 | 119456 | 119671 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699x Missouri St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 132286 | 132286 | 179436 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006488.6944 | 2086721.59328 | 37.7101073779209 | -122.419346642943 | (37.7101073779209, -122.419346642943) | |||
| 134909 | 134909 | 187383 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2200 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985095.2656 | 2100101.9401 | 37.745618175200704 | -122.49427107768601 | (37.7456181752007, -122.494271077686) | |||
| 138965 | 138965 | 119669 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699x Missouri St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 148239 | 148239 | 197534 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Missouri St | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6013594.2637 | 2104046.7535 | 37.758076334581105 | -122.396001525061 | (37.7580763345811, -122.396001525061) | ||||
| 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) | |||
| 152193 | 152193 | 197554 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Kansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 4ft | 6011382.26351 | 2107407.34025 | 37.7671804369461 | -122.40388808926201 | (37.7671804369461, -122.403888089262) | |||
| 154490 | 154490 | 179428 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006287.8718 | 2087448.27209 | 37.7120913722811 | -122.420092263655 | (37.7120913722811, -122.420092263655) | |||
| 155020 | 155020 | 240521 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 149 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 6003423.1831 | 2096576.8964099998 | 37.7369947203295 | -122.430644439989 | (37.7369947203295, -122.430644439989) | |||
| 157586 | 157586 | 179441 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007125.21698 | 2086870.4635 | 37.7105519739575 | -122.417157231746 | (37.7105519739575, -122.417157231746) | |||
| 158631 | 158631 | 179435 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006500.6084199995 | 2086740.91409 | 37.710161099825 | -122.41930683535 | (37.710161099825, -122.41930683535) | |||
| 161232 | 161232 | 179438 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 163 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6006665.75653 | 2086898.09687 | 37.7106019906608 | -122.41874718904499 | (37.7106019906608, -122.418747189045) | |||
| 163435 | 163435 | 179431 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 121 Blythdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006605.70519 | 2086910.12298 | 37.7106316305231 | -122.418955592547 | (37.7106316305231, -122.418955592547) | |||
| 167377 | 167377 | 179427 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006362.446930001 | 2087442.7546 | 37.7120804239565 | -122.419834118658 | (37.7120804239565, -122.419834118658) | |||
| 169589 | 169589 | 179454 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1657 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 6006909.47125 | 2087494.6948400002 | 37.71225384290071 | -122.417947119763 | (37.7122538429007, -122.417947119763) | |||
| 170161 | 170161 | 179449 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006550.96819 | 2087379.45579 | 37.711917237452 | -122.419178046153 | (37.711917237452, -122.419178046153) | |||
| 172689 | 172689 | 179451 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1848 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6006175.92265 | 2087836.6399400001 | 37.713151440055796 | -122.420506743187 | (37.7131514400558, -122.420506743187) | |||
| 175731 | 175731 | 197557 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Kansas St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 4ft | 6011388.35138 | 2107305.69041 | 37.766901669605105 | -122.403859878426 | (37.7669016696051, -122.403859878426) | |||
| 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) | |||
| 179328 | 179328 | 179430 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 241 Blythdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006173.52059 | 2087002.57891 | 37.7108611491941 | -122.42045587934099 | (37.7108611491941, -122.420455879341) | |||
| 181080 | 181080 | 197558 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Kansas St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6011389.0063 | 2107291.61952 | 37.7668630707131 | -122.40385662290701 | (37.7668630707131, -122.403856622907) | |||
| 183439 | 183439 | 240520 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 161 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 5ft | 6003392.36274 | 2096552.7059 | 37.7369265526056 | -122.43074927395399 | (37.7369265526056, -122.430749273954) | |||
| 184632 | 184632 | 179453 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1657 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6006878.87058 | 2087495.9574900002 | 37.7122555876031 | -122.418052974468 | (37.7122555876031, -122.418052974468) | |||
| 184658 | 184658 | 124347 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 850 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 8ft | 5992970.95796 | 2111419.69143 | 37.777151486539104 | -122.46786138931499 | (37.7771514865391, -122.467861389315) | |||
| 185054 | 185054 | 179452 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1851 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6006040.88882 | 2087844.33942 | 37.71316497035539 | -122.420974012957 | (37.7131649703554, -122.420974012957) | |||
| 185597 | 185597 | 179442 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 20 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6006642.58468 | 2087353.9641 | 37.711852401735705 | -122.418859586325 | (37.7118524017357, -122.418859586325) | |||
| 187434 | 187434 | 179444 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 50 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6006641.4754 | 2087068.60877 | 37.711068813438395 | -122.418843195273 | (37.7110688134384, -122.418843195273) | |||
| 187470 | 187470 | 179426 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 6ft | 6006719.22339 | 2087474.4297099998 | 37.7121874900245 | -122.41860323816401 | (37.7121874900245, -122.418603238164) | |||
| 189008 | 189008 | 197555 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Kansas St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 4ft | 6011386.38473 | 2107363.2099 | 37.7670594952368 | -122.403870728771 | (37.7670594952368, -122.403870728771) | |||
| 80137 | 80137 | 101978 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Tiffany Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6006502.0 | 2099737.0 | 37.7458455996049 | -122.420223786963 | (37.7458455996049, -122.420223786963) | ||||
| 116788 | 116788 | 101979 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Tiffany Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.42052904239901 | (37.7461054290546, -122.420529042399) | |||||
| 117685 | 117685 | 101980 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Tiffany Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.42052904239901 | (37.7461054290546, -122.420529042399) | |||||
| 129467 | 129467 | 101981 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Tiffany Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.42052904239901 | (37.7461054290546, -122.420529042399) | |||||
| 15674 | 15674 | 94034 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1300X Lane St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 6015674.4242 | 2095246.7836 | 37.7340289546749 | -122.388193241926 | (37.7340289546749, -122.388193241926) | ||
| 5171 | 5171 | 247184 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | |
| 5187 | 5187 | 247186 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | Permit Number 780753 | 6000985.28448 | 2108903.00262 | 37.770700815109294 | -122.439956869431 | (37.7707008151093, -122.439956869431) | ||
| 23825 | 23825 | 247187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6000970.93564 | 2108908.88323 | 37.770716144966 | -122.440006923906 | (37.770716144966, -122.440006923906) | |||
| 26119 | 26119 | 247188 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6000957.547669999 | 2108914.20808 | 37.7707300035244 | -122.440053614886 | (37.7707300035244, -122.440053614886) |
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");