Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1701 | 1701 | 239730 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1709 Castro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779965 | 6002631.28239 | 2100576.89579 | 37.747932892899705 | -122.43366818554199 | (37.7479328928997, -122.433668185542) | |
2520 | 2520 | 141903 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004752.7943 | 2111956.4883 | 37.7792986892944 | -122.42714251637699 | (37.7792986892944, -122.427142516377) | |||
5116 | 5116 | 123752 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995621.16362 | 2110827.61225 | 37.77567847155 | -122.45865067705799 | (37.77567847155, -122.458650677058) | |||
7072 | 7072 | 5264 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1234 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001356.2408 | 2112747.2805 | 37.7812773444135 | -122.438949270784 | (37.7812773444135, -122.438949270784) | |||
7831 | 7831 | 9536 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004118.455 | 2112215.6365 | 37.779974353933 | -122.42935544491999 | (37.779974353933, -122.42935544492) | ||
18917 | 18917 | 40148 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 580X Stanyan St | 4 | 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) | |
23500 | 23500 | 200674 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6015639.7987 | 2095348.4618 | 37.7343062239298 | -122.38832004816099 | (37.7343062239298, -122.388320048161) | |||
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) | |||
24944 | 24944 | 240564 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 10 Hancock St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004144.38287 | 2105130.57099 | 37.7605219536452 | -122.428760524878 | (37.7605219536452, -122.428760524878) | |||
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) | |||
35423 | 35423 | 138401 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1850 PIERCE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002032.4913 | 2114859.6026 | 37.7871156961534 | -122.43676103385599 | (37.7871156961534, -122.436761033856) | |||
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) | ||||
39538 | 39538 | 75600 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 701 38th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 9 | 5984118.61972 | 2110981.94357 | 37.775434407710705 | -122.49845161010599 | (37.7754344077107, -122.498451610106) | ||
44607 | 44607 | 197563 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011871.68658 | 2107504.14213 | 37.767473563784996 | -122.40220204389799 | (37.767473563785, -122.402202043898) | |||
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) | |||
49879 | 49879 | 200844 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1919 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010817.914 | 2106923.6397 | 37.7658207601783 | -122.40580602510201 | (37.7658207601783, -122.405806025102) | |||
50273 | 50273 | 179467 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 291 France Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001663.653519999 | 2090093.9083 | 37.7190940729046 | -122.436264090339 | (37.7190940729046, -122.436264090339) | |||
54299 | 54299 | 118236 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 680 38th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5984154.15255 | 2111259.59719 | 37.7761988481286 | -122.49834920754101 | (37.7761988481286, -122.498349207541) | |||
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) | |||
54777 | 54777 | 114770 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | ||||
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) | |||
56840 | 56840 | 248529 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 45 Beulah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997709.9004 | 2107802.0064 | 37.7674907631986 | -122.451207005854 | (37.7674907631986, -122.451207005854) | |||
57850 | 57850 | 141929 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1050 MCALLISTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 6004201.9404 | 2111879.6644 | 37.7790565838512 | -122.429042670434 | (37.7790565838512, -122.429042670434) | |||
59988 | 59988 | 197546 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011743.17098 | 2107136.9679900003 | 37.7664582120893 | -122.402620741247 | (37.7664582120893, -122.402620741247) | |||
60273 | 60273 | 197525 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 301 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6010642.38182 | 2106636.04966 | 37.7650212852405 | -122.406392890941 | (37.7650212852405, -122.406392890941) | |||
61113 | 61113 | 197521 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1919 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010803.25942 | 2106918.3413 | 37.765805392423395 | -122.40585633919301 | (37.7658053924234, -122.405856339193) | |||
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) | |||
65713 | 65713 | 246598 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 52 Waller St | 4 | : 4 | Tree 1 | Private 1 | 20 | Width 3ft | 6005467.40356 | 2109274.31341 | 37.7719744736758 | -122.424479547814 | (37.7719744736758, -122.424479547814) | |||
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) | |||
71565 | 71565 | 246230 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999421.9446 | 2107737.958 | 37.767412778225896 | -122.445280689263 | (37.7674127782259, -122.445280689263) | |||
72835 | 72835 | 101867 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769242 | 6012649.1 | 2113074.7 | 37.7828124097662 | -122.399904277178 | (37.7828124097662, -122.399904277178) | |
74853 | 74853 | 239701 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 157 Rivoli St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997898.2539099995 | 2105921.10359 | 37.76233706342371 | -122.450419912162 | (37.7623370634237, -122.450419912162) | |||
75265 | 75265 | 197541 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 33 Guy Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014357.779 | 2114449.44998 | 37.7866822697032 | -122.394089193158 | (37.7866822697032, -122.394089193158) | |||
75649 | 75649 | 179486 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Capistrano Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6001448.8581300005 | 2093594.99443 | 37.7286950561315 | -122.437257104643 | (37.7286950561315, -122.437257104643) | |||
78221 | 78221 | 35112 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 594 Lisbon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.719033250553295 | -122.43595568834999 | (37.7190332505533, -122.43595568835) | ||
81830 | 81830 | 21852 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 199X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5995138.68645 | 2110755.95244 | 37.775453970893004 | -122.460314480311 | (37.775453970893, -122.460314480311) | |||
83330 | 83330 | 2752 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 59 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5995436.711 | 2110737.12628 | 37.7754194179801 | -122.459282185974 | (37.7754194179801, -122.459282185974) | |||
84335 | 84335 | 111029 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 150 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | ||||
90237 | 90237 | 10520 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 HAIGHT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5997298.0 | 2108414.0 | 37.7691475483634 | -122.452675880715 | (37.7691475483634, -122.452675880715) | |||
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) | |||
96864 | 96864 | 16562 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 700X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015552.29216 | 2097280.01448 | 37.7396050257983 | -122.388757385673 | (37.7396050257983, -122.388757385673) | |||
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) | |||
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) | |||
109884 | 109884 | 112024 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101x 22nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5x5 | 6011761.0 | 2103726.0 | 37.757093449930004 | -122.402319220858 | (37.75709344993, -122.402319220858) | ||||
116980 | 116980 | 30953 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 4 | 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) | ||
117003 | 117003 | 40142 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 560X Stanyan St | 4 | 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) | |||
117849 | 117849 | 34509 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 4 | 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) | |||
118171 | 118171 | 239711 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1210 Shrader St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5997773.63679 | 2106292.89727 | 37.763350781929 | -122.450877723736 | (37.763350781929, -122.450877723736) | |||
121462 | 121462 | 102834 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Lansing St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | |||
127222 | 127222 | 1631 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 20X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5995606.71843 | 2110827.0926 | 37.7756762144924 | -122.458700608592 | (37.7756762144924, -122.458700608592) | |||
127285 | 127285 | 14744 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | |||
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) | |||
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) | |||||
133559 | 133559 | 240523 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 395 Sussex St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000924.48322 | 2096677.9902700002 | 37.7371304253124 | -122.439290787446 | (37.7371304253124, -122.439290787446) | |||
135551 | 135551 | 183901 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101 22nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5989435.1836 | 2100729.0432 | 37.7475930502179 | -122.47931033546699 | (37.7475930502179, -122.479310335467) | |||
138250 | 138250 | 215016 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Rosewood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994826.24251 | 2095308.69182 | 37.7330217520514 | -122.460275845063 | (37.7330217520514, -122.460275845063) | |||
138632 | 138632 | 14752 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 940 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | |||
139008 | 139008 | 7138 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 336X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994611.623430001 | 2110790.08992 | 37.775517371009 | -122.46214017921899 | (37.775517371009, -122.462140179219) | |||
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) | |||
142046 | 142046 | 2772 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5994610.57975 | 2110790.94437 | 37.775519657009994 | -122.462143851512 | (37.77551965701, -122.462143851512) | |||
142558 | 142558 | 7684 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 315X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5994678.74309 | 2110742.5512099997 | 37.7753907066265 | -122.46190454994301 | (37.7753907066265, -122.461904549943) | |||
153183 | 153183 | 140667 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 542 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5996918.4239 | 2109564.4189 | 37.772284544724705 | -122.45407190445499 | (37.7722845447247, -122.454071904455) | |||
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) | |||
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) | |||
158626 | 158626 | 179458 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Italy Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6001021.22839 | 2089673.6831200002 | 37.7179037068739 | -122.438454610411 | (37.7179037068739, -122.438454610411) | |||
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) | |||
167234 | 167234 | 118220 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5984456.55861 | 2111461.63296 | 37.7767713082661 | -122.497318036821 | (37.7767713082661, -122.497318036821) | |||
167374 | 167374 | 138391 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1955 STEINER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002452.5162 | 2114975.8094 | 37.787458632196206 | -122.435316157397 | (37.7874586321962, -122.435316157397) | |||
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) | |||
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) | |||
171956 | 171956 | 179479 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989502.72531 | 2090743.3416900001 | 37.7201787974032 | -122.478346734135 | (37.7201787974032, -122.478346734135) | ||||
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) | |||
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) | |||
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) | |||
179734 | 179734 | 123733 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 398 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5994463.58559 | 2110785.44478 | 37.7754960920711 | -122.46265193681299 | (37.7754960920711, -122.462651936813) | |||
180793 | 180793 | 123756 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Cabrillo St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5995405.24475 | 2110764.0495 | 37.77549153290371 | -122.45939298463101 | (37.7754915329037, -122.459392984631) | |||
186755 | 186755 | 197572 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 801 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011789.60702 | 2113153.20247 | 37.7829800045728 | -122.40288330192 | (37.7829800045728, -122.40288330192) |
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");