Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38258 | 38258 | 113355 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 5982766.03998 | 2112575.4615 | 37.779730331527404 | -122.503248436763 | (37.7797303315274, -122.503248436763) | |||
43685 | 43685 | 46431 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2St. Ankeny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2002 12:00:00 AM | 1 | Permit Number 44652 | 6011089.42189 | 2089718.35805 | 37.7185939356546 | -122.40365624942899 | (37.7185939356546, -122.403656249429) | ||
46553 | 46553 | 95899 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1700 23rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989072.0669 | 2103701.2996 | 37.7557329794721 | -122.480783524363 | (37.7557329794721, -122.480783524363) |
52735 | 52735 | 176874 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012843.86934 | 2086597.3532 | 37.7101221250005 | -122.397373047849 | (37.7101221250005, -122.397373047849) | |||
52877 | 52877 | 118595 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982415.15882 | 2112561.71552 | 37.7796719571588 | -122.504461248614 | (37.7796719571588, -122.504461248614) | |||
68212 | 68212 | 119242 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981417.66127 | 2111333.86508 | 37.7762419210818 | -122.507820820241 | (37.7762419210818, -122.507820820241) | |||
148319 | 148319 | 207042 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 40 Vasquez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995660.33467 | 2100048.89738 | 37.746085134133 | -122.45773506422701 | (37.746085134133, -122.457735064227) | |||
153201 | 153201 | 98850 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795X 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095.0 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | |
175623 | 175623 | 184549 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3501 Moraga St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5983411.1343 | 2103548.3965 | 37.754982490057 | -122.50034921882099 | (37.754982490057, -122.500349218821) | |||
178920 | 178920 | 201812 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021065.67541 | 2093224.76894 | 37.728774126326705 | -122.369414113788 | (37.7287741263267, -122.369414113788) | |||
180010 | 180010 | 118666 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 465 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5982506.22463 | 2112651.7557200002 | 37.779924536981504 | -122.50415288931299 | (37.7799245369815, -122.504152889313) | |||
187445 | 187445 | 176900 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 167 Madison St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6005606.72127 | 2092829.9713400002 | 37.7268299557374 | -122.42282875044701 | (37.7268299557374, -122.422828750447) |
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");