Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, PlantDate, PlotSize, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11646 | 11646 | 27701 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1136 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/26/2000 12:00:00 AM | 6 | 6008329.0437900005 | 2093834.9235 | 37.729742566663106 | -122.413488762206 | (37.7297425666631, -122.413488762206) | |||
11724 | 11724 | 25307 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 355 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/1996 12:00:00 AM | 6 | 3X3 | 5999438.14042 | 2091535.09661 | 37.7229245454182 | -122.444060305044 | (37.7229245454182, -122.444060305044) | ||
14420 | 14420 | 27150 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1735 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011122.20395 | 2095139.1072200001 | 37.73348002049129 | -122.403924187157 | (37.7334800204913, -122.403924187157) | |||
20345 | 20345 | 5583 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1069 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6005153.43733 | 2102137.63056 | 37.752361098006894 | -122.42505770847299 | (37.7523610980069, -122.425057708473) | |||
83003 | 83003 | 22765 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1674 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1997 12:00:00 AM | 6 | 4X4 | 6002010.254376 | 2112254.96617 | 37.7799627627699 | -122.436651458736 | (37.7799627627699, -122.436651458736) | ||
89638 | 89638 | 22703 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1410 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2001 12:00:00 AM | 6 | 3X3 | 6003133.70477 | 2112422.88036 | 37.7804875932729 | -122.432776943127 | (37.7804875932729, -122.432776943127) | ||
92194 | 92194 | 26649 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1686 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/1998 12:00:00 AM | 6 | 4X4 | 6001954.59403 | 2112257.165987 | 37.7799656396512 | -122.43684416995899 | (37.7799656396512, -122.436844169959) | ||
94151 | 94151 | 25287 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2390X Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992028.41499 | 2094382.48626 | 37.7303172887062 | -122.469881169704 | (37.7303172887062, -122.469881169704) | ||
96152 | 96152 | 15940 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5810X MISSION ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/1998 12:00:00 AM | 6 | 3X3 | 5997175.0 | 2086632.0 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | ||
104635 | 104635 | 22590 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 801 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/1997 12:00:00 AM | 6 | 4x4 | 6006166.11327 | 2112793.0062543997 | 37.781675384913605 | -122.422312701127 | (37.7816753849136, -122.422312701127) | ||
105817 | 105817 | 29733 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 622 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6010024.1062535 | 2119210.3696422 | 37.799512783441 | -122.409418845912 | (37.799512783441, -122.409418845912) | ||
108601 | 108601 | 22587 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 801 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/1997 12:00:00 AM | 6 | 4x4 | 6006166.11327 | 2112793.0062543997 | 37.781675384913605 | -122.422312701127 | (37.7816753849136, -122.422312701127) | ||
108794 | 108794 | 28590 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | ||
111383 | 111383 | 1199 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
111445 | 111445 | 29664 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2232 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 5992636.99947 | 2093738.93892 | 37.7285854269889 | -122.467730442067 | (37.7285854269889, -122.467730442067) | ||||
117268 | 117268 | 27148 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1735 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011160.620490001 | 2095185.02583 | 37.7336082495359 | -122.403794599522 | (37.7336082495359, -122.403794599522) | |||
117573 | 117573 | 28588 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |||
119764 | 119764 | 28589 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | ||
122804 | 122804 | 22761 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1640 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1997 12:00:00 AM | 6 | 3X3 | 6002164.690701 | 2112286.628689 | 37.7800584752671 | -122.436119461658 | (37.7800584752671, -122.436119461658) | ||
124759 | 124759 | 25215 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2411 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992017.8005099995 | 2094287.9738099999 | 37.730057167515604 | -122.469910986387 | (37.7300571675156, -122.469910986387) | ||
128364 | 128364 | 26781 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1762 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004617.6627263 | 2098622.9472722 | 37.7426803093545 | -122.426660244792 | (37.7426803093545, -122.426660244792) | |||
144194 | 144194 | 12106 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1281X La Salle Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/1996 12:00:00 AM | 6 | 3X3 | 6017033.141005999 | 2094557.4754692002 | 37.732211440602605 | -122.383447721977 | (37.7322114406026, -122.383447721977) |
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");