Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
142332 | 142332 | 95517 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | 3x3 | 5985993.99278 | 2111923.13747 | 37.778128454962 | -122.49203365493601 | (37.778128454962, -122.492033654936) | |||
123561 | 123561 | 95485 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | 3x3 | 5986006.6183 | 2111569.83262 | 37.777159118639496 | -122.49196396094601 | (37.7771591186395, -122.491963960946) | |||
83999 | 83999 | 26042 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2003 12:00:00 AM | 10 | 3X3 | 5996190.731819999 | 2088089.91613 | 37.7132791004475 | -122.455037033861 | (37.7132791004475, -122.455037033861) | ||
159162 | 159162 | 219449 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 339 Detroit St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999411.789580001 | 2094299.60071 | 37.7305137290122 | -122.444349966799 | (37.7305137290122, -122.444349966799) | |||
147132 | 147132 | 68240 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3235 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32038 | 6000367.65651 | 2119408.48932 | 37.799510988101396 | -122.442847752719 | (37.7995109881014, -122.442847752719) | |
168983 | 168983 | 68254 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3835 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32056 | 6000569.04912 | 2121537.58273 | 37.8053683895105 | -122.44230379238199 | (37.8053683895105, -122.442303792382) | |
144893 | 144893 | 117180 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 8 KNOTT CT | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000120.0 | 2086463.0 | 37.7090365866676 | -122.44133950250601 | (37.7090365866676, -122.441339502506) | |||
52023 | 52023 | 68238 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 290 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32036 | 6000949.5088599995 | 2120925.17442 | 37.8037085566624 | -122.440943204485 | (37.8037085566624, -122.440943204485) | |
184089 | 184089 | 180430 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 122 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000838.328869999 | 2091757.95651 | 37.723616244584704 | -122.43923612035299 | (37.7236162445847, -122.439236120353) | |||
92825 | 92825 | 25288 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 110X Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1996 12:00:00 AM | 10 | 3x3 | 6000890.43944 | 2091777.01619 | 37.7236715433472 | -122.43905734896299 | (37.7236715433472, -122.439057348963) | ||
27006 | 27006 | 35019 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 27 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | 10 | Permit Number 38594 | 6001880.48988 | 2120550.7716599996 | 37.8027335251878 | -122.437694670695 | (37.8027335251878, -122.437694670695) | ||
37559 | 37559 | 35018 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 15 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | 10 | Permit Number 38593 | 6001898.27273 | 2120571.24867 | 37.8027907607435 | -122.437634600462 | (37.8027907607435, -122.437634600462) | ||
148867 | 148867 | 44382 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1257 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | 10 | Permit Number 43744 | 6001457.21112 | 2087559.6242799999 | 37.71212376138379 | -122.43679636128901 | (37.7121237613838, -122.436796361289) | |
76747 | 76747 | 69489 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 675 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 10 | Permit Number 33611 | 6001629.6307 | 2093134.5419700001 | 37.7274410333571 | -122.436599219094 | (37.7274410333571, -122.436599219094) | |
26966 | 26966 | 70402 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 212 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 6006462.64225 | 2092921.27798 | 37.727128920939606 | -122.419876323835 | (37.7271289209396, -122.419876323835) | ||
162109 | 162109 | 70404 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 218 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 6006477.26442 | 2092881.04144 | 37.7270192639056 | -122.41982292118601 | (37.7270192639056, -122.419822921186) | ||
50620 | 50620 | 180458 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008265.9310099995 | 2092323.59976 | 37.725589251032 | -122.41360010007901 | (37.725589251032, -122.413600100079) | |||
23892 | 23892 | 180452 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008393.709980001 | 2091906.0725900002 | 37.724449984452704 | -122.413128866997 | (37.7244499844527, -122.413128866997) | |||
48947 | 48947 | 180450 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008413.5895 | 2091843.5213400002 | 37.7242793479848 | -122.413055725159 | (37.7242793479848, -122.413055725159) | |||
112572 | 112572 | 45297 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 608 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | 10 | 2x3 | Permit Number 44137 | 6008675.13295434 | 2095998.82519754 | 37.7357036012205 | -122.412445185237 | (37.7357036012205, -122.412445185237) |
46135 | 46135 | 180483 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 321 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009804.862930001 | 2094010.61906 | 37.7303077455958 | -122.40839905808998 | (37.7303077455958, -122.40839905809) | |||
67824 | 67824 | 198414 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3310 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013355.178590001 | 2089895.60565 | 37.71920692974621 | -122.39583681063299 | (37.7192069297462, -122.395836810633) | |||
15030 | 15030 | 101775 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1700 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 3x3 | Permit Number 19103 | 6014052.75296 | 2093112.8912 | 37.728079734566606 | -122.393650601914 | (37.7280797345666, -122.393650601914) | |
13359 | 13359 | 99591 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1855X Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769738 | 6014314.47679 | 2099474.93569 | 37.745563139741996 | -122.39319079741301 | (37.745563139742, -122.393190797413) | |
15099 | 15099 | 99592 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1855X Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014373.22453 | 2099430.50237 | 37.7454443986533 | -122.392984546922 | (37.7454443986533, -122.392984546922) |
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");