Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
656 | 656 | 23200 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006725.22564 | 2112390.29825 | 37.7806011691535 | -122.420349841196 | (37.7806011691535, -122.420349841196) | |||
7960 | 7960 | 23202 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6006708.88776 | 2112470.99571 | 37.7808218241176 | -122.420412091366 | (37.7808218241176, -122.420412091366) | |||
8841 | 8841 | 23183 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006719.9876 | 2112427.32903 | 37.780702551515496 | -122.42037059124901 | (37.7807025515155, -122.420370591249) | ||
12342 | 12342 | 24268 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 350X Winding Way | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6001111.916180001 | 2086587.12369 | 37.7094338594537 | -122.437920185566 | (37.7094338594537, -122.437920185566) | |||
12367 | 12367 | 24267 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 350X Winding Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6001124.44895 | 2086586.86413 | 37.7094338594468 | -122.43787685174401 | (37.7094338594468, -122.437876851744) | |||
19068 | 19068 | 26911 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 10 Caine Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997609.86555 | 2089654.4499099997 | 37.7176562610968 | -122.450244747607 | (37.7176562610968, -122.450244747607) | |||
19139 | 19139 | 29600 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900X Junipero Serra Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991176.92289 | 2091079.14193 | 37.7211978713578 | -122.472584119478 | (37.7211978713578, -122.472584119478) | ||
28512 | 28512 | 176338 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6011479.2515 | 2090641.1055 | 37.721149380822 | -122.402373605767 | (37.721149380822, -122.402373605767) | |||
38393 | 38393 | 176339 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6011461.59774 | 2090655.36204 | 37.7211875408569 | -122.402435631998 | (37.7211875408569, -122.402435631998) | |||
44177 | 44177 | 113502 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x MANSELL ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 3x3 | 6011136.0 | 2090597.0 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | |||
44888 | 44888 | 176341 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 500x Mansell St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6010266.44711 | 2090286.24099 | 37.7201072185592 | -122.406540946309 | (37.7201072185592, -122.406540946309) | |||
47690 | 47690 | 176337 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 59 | Width 0ft | 6011478.9031 | 2090656.6645400003 | 37.72119208331829 | -122.40237590353901 | (37.7211920833183, -122.402375903539) | |||
71413 | 71413 | 113506 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x Mansell St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 39 | 3x3 | 6011135.08211 | 2090555.5358799999 | 37.7208952054249 | -122.40355728893199 | (37.7208952054249, -122.403557288932) | |||
87799 | 87799 | 13410 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 364 Marietta Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999660.108164 | 2097381.7238333 | 37.738990678772396 | -122.443712833155 | (37.7389906787724, -122.443712833155) | |||
99315 | 99315 | 3751 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 990 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | 18 | 6012435.5557064 | 2103342.2152382 | 37.756077292734105 | -122.399959384248 | (37.7560772927341, -122.399959384248) | |||
106180 | 106180 | 106794 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 199X ARLINGTON ST | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | ||||
109383 | 109383 | 106792 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 199X ARLINGTON ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | ||||
112663 | 112663 | 114044 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 549X ARLINGTON ST | Median : Cutout 11 | Tree 1 | Private 1 | 70 | 6003400.0 | 2095634.0 | 37.734404428182295 | -122.430657330781 | (37.7344044281823, -122.430657330781) | |||||
113760 | 113760 | 106810 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 3500X MISSION ST | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
127427 | 127427 | 106795 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 199X ARLINGTON ST | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | ||||
139032 | 139032 | 30154 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 410X Mansell St | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
144679 | 144679 | 106811 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 3500X MISSION ST | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
149487 | 149487 | 208977 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 300x Marietta Dr | 45 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 5ft | 5999505.82373 | 2097502.74743 | 37.7393141797969 | -122.44425497048401 | (37.7393141797969, -122.444254970484) | |||
165255 | 165255 | 224249 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 500x 27th St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | Width 4ft | 6002852.0087 | 2100065.56768 | 37.7465414276517 | -122.432868400457 | (37.7465414276517, -122.432868400457) | |||
178271 | 178271 | 176340 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x Mansell St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6011135.84107 | 2090535.2556900003 | 37.720839562571996 | -122.403553239308 | (37.720839562572, -122.403553239308) |
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");