Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68 | 68 | 251188 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000800.0 | 2109063.0 | 37.771129578660705 | -122.440609247553 | (37.7711295786607, -122.440609247553) | ||||
2523 | 2523 | 141904 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6004738.7382 | 2111954.0648 | 37.7792912400822 | -122.42719096962601 | (37.7792912400822, -122.427190969626) | |||
3190 | 3190 | 9537 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6004100.4915 | 2112210.9093 | 37.779960357201205 | -122.429417251502 | (37.7799603572012, -122.429417251502) | ||
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) | |||
28030 | 28030 | 197577 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 299x Cashmere St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6016820.77887 | 2095888.49241 | 37.735854408739 | -122.38427457691002 | (37.735854408739, -122.38427457691) | ||||
30303 | 30303 | 179468 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 291 France Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001647.16213 | 2090105.1251700001 | 37.719123934899294 | -122.436321896962 | (37.7191239348993, -122.436321896962) | |||
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) | |||
35537 | 35537 | 141930 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1050 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004152.017000001 | 2111873.3634 | 37.7790364568014 | -122.42921492627701 | (37.7790364568014, -122.429214926277) | |||
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) | |||
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) | |||
44139 | 44139 | 200675 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015661.7831 | 2095333.6223 | 37.7342666958117 | -122.388243005014 | (37.7342666958117, -122.388243005014) | |||
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) | |||
49033 | 49033 | 118221 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5984455.23409 | 2111482.2118900004 | 37.776827734448105 | -122.49732413820101 | (37.7768277344481, -122.497324138201) | |||
52817 | 52817 | 197564 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011853.28866 | 2107502.0789900003 | 37.7674668719146 | -122.402265535131 | (37.7674668719146, -122.402265535131) | |||
53158 | 53158 | 197573 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 801 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011805.47785 | 2113169.35516 | 37.7830252422689 | -122.402829531459 | (37.7830252422689, -122.402829531459) | |||
55379 | 55379 | 179487 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Capistrano Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6001448.45649 | 2093575.59463 | 37.728641765884106 | -122.437257104634 | (37.7286417658841, -122.437257104634) | |||
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) | |||
70585 | 70585 | 197524 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 301 Utah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010641.49765 | 2106679.01368 | 37.7651392052289 | -122.406398976647 | (37.7651392052289, -122.406398976647) | |||
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) | ||||
78791 | 78791 | 21853 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 199X Cabrillo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5995153.19322 | 2110756.08274 | 37.7754551631243 | -122.46026430774201 | (37.7754551631243, -122.460264307742) | |||
80962 | 80962 | 109300 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 251 RHODE ISLAND ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011759.4 | 2107238.5 | 37.766737902166795 | -122.402571748171 | (37.7667379021668, -122.402571748171) | ||||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | |||
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) | ||||
111674 | 111674 | 102835 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Lansing St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | |||
116067 | 116067 | 30952 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 5 | 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) | ||
117303 | 117303 | 35113 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 594 Lisbon St | 5 | 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) | ||
119335 | 119335 | 40149 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 580X Stanyan St | 5 | 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) | |
141343 | 141343 | 103006 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 41X Beulah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5997709.4 | 2107777.7 | 37.767423995375204 | -122.451206983541 | (37.7674239953752, -122.451206983541) | |||
143137 | 143137 | 76749 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200X Farallones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1989 12:00:00 AM | 8 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) | |
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) | |||
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) | |||
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) | |||
154792 | 154792 | 239731 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1709 Castro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6002630.2192400005 | 2100589.8349099997 | 37.7479683603545 | -122.433672786481 | (37.7479683603545, -122.433672786481) | |||
156728 | 156728 | 101871 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6012623.9262 | 2113078.7907 | 37.782822238396605 | -122.39999165586799 | (37.7828222383966, -122.399991655868) | |||
158354 | 158354 | 240568 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 250 Douglass St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001090.59678 | 2104810.17001 | 37.759468901480105 | -122.43929918261298 | (37.7594689014801, -122.439299182613) | |||
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) | |||
159303 | 159303 | 75536 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 701 38th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 12 | 5984118.85326 | 2110953.37322 | 37.7753559754601 | -122.498448691476 | (37.7753559754601, -122.498448691476) | ||
162638 | 162638 | 246599 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 52 Waller St | 5 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6005448.395330001 | 2109271.63735 | 37.771966052416204 | -122.42454510838999 | (37.7719660524162, -122.42454510839) | |||
167852 | 167852 | 239710 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1132 Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5997732.52597 | 2106583.54789 | 37.7641464813941 | -122.451040872449 | (37.7641464813941, -122.451040872449) | |||
171132 | 171132 | 197575 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1121 Jamestown Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 6013269.3073 | 2090137.6242 | 37.719866686770395 | -122.396150589498 | (37.7198666867704, -122.396150589498) | ||||
173328 | 173328 | 197547 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6011743.058130001 | 2107162.2739 | 37.7665276901155 | -122.402622911324 | (37.7665276901155, -122.402622911324) | |||
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) | |||
184083 | 184083 | 140668 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 544 Stanyan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5996917.2741 | 2109577.8331 | 37.7723213107109 | -122.454076850691 | (37.7723213107109, -122.454076850691) | |||
188040 | 188040 | 197520 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98 Lafayette St | 5 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6007717.2402800005 | 2109472.44967 | 37.7726453040621 | -122.416711211162 | (37.7726453040621, -122.416711211162) | |||
188921 | 188921 | 138402 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1850 PIERCE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002032.4913 | 2114879.2037 | 37.7871695157566 | -122.43676243751001 | (37.7871695157566, -122.43676243751) |
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");