Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29577 | 29577 | 213706 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 1444 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5990875.43177 | 2105581.50007 | 37.7610001645442 | -122.474684197434 | (37.7610001645442, -122.474684197434) | |||
| 31907 | 31907 | 246740 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 132 Ripley St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 8ft | 6008857.53269 | 2099073.06292 | 37.7441550208325 | -122.41203174448201 | (37.7441550208325, -122.412031744482) | |||
| 40302 | 40302 | 238539 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 4079 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003407.21225 | 2100365.41325 | 37.7473962080773 | -122.430969964019 | (37.7473962080773, -122.430969964019) | |||
| 41059 | 41059 | 196515 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 2075 Palou Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6012358.51021 | 2097085.95445 | 37.7388946487629 | -122.399786553923 | (37.7388946487629, -122.399786553923) | |||
| 41681 | 41681 | 43655 | Permitted Site 1 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 152 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 2 | Permit Number 43299 | 5992759.135869999 | 2114454.8579 | 37.785472992325396 | -122.468815060585 | (37.7854729923254, -122.468815060585) | |
| 46132 | 46132 | 238538 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 2766 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009533.48603 | 2103380.6247400003 | 37.7560205320462 | -122.409998467263 | (37.7560205320462, -122.409998467263) | |||
| 62751 | 62751 | 136028 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 701 Buchanan St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 6ft | 6004477.21749 | 2110912.17552 | 37.7764156757853 | -122.428021412563 | (37.7764156757853, -122.428021412563) | |||
| 85147 | 85147 | 48680 | Permitted Site 1 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 23 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2014 12:00:00 AM | 3x3 | Permit Number 773002 | 6012118.7327785995 | 2095652.09441988 | 37.734944200728606 | -122.40051490481399 | (37.7349442007286, -122.400514904814) | ||
| 88578 | 88578 | 99514 | Permitted Site 1 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 154 Miraloma Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2012 12:00:00 AM | Permit Number 768163 | 5994585.5 | 2096588.5 | 37.73652193950829 | -122.461200886189 | (37.7365219395083, -122.461200886189) | |||
| 114831 | 114831 | 102471 | Permitted Site 1 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 66 Sotelo Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2013 12:00:00 AM | 6/15 | Permit Number 769896 | 5993897.9 | 2101386.8 | 37.7496572701738 | -122.46392638569701 | (37.7496572701738, -122.463926385697) | ||
| 137653 | 137653 | 213707 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 1907 16th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5991230.22664 | 2102378.81623 | 37.752226991095704 | -122.473223546438 | (37.7522269910957, -122.473223546438) | |||
| 146532 | 146532 | 196514 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 2200 Alameda St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6010334.79158 | 2107884.9177 | 37.7684331799705 | -122.40754483165199 | (37.7684331799705, -122.407544831652) | |||
| 148814 | 148814 | 123973 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 67 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993617.7484800005 | 2115063.03526 | 37.7871924476765 | -122.46588874556801 | (37.7871924476765, -122.465888745568) | |||
| 165110 | 165110 | 238540 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 217 Montcalm St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6009894.85304 | 2099616.29886 | 37.7457047739516 | -122.40848321393699 | (37.7457047739516, -122.408483213937) | |||
| 170495 | 170495 | 117867 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 842 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5983574.3920599995 | 2110074.48435 | 37.7729108571993 | -122.500267088216 | (37.7729108571993, -122.500267088216) | |||
| 173199 | 173199 | 136030 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 475 Marina Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6000838.224669999 | 2121681.08222 | 37.805777738417795 | -122.441382580867 | (37.8057777384178, -122.441382580867) | |||
| 177121 | 177121 | 117868 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 842 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5983575.47317 | 2110057.58486 | 37.7728645195254 | -122.500262098966 | (37.7728645195254, -122.500262098966) | |||
| 186749 | 186749 | 136029 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 3743 Scott St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000599.31455 | 2121234.7075799997 | 37.804538500507995 | -122.44217730004101 | (37.804538500508, -122.442177300041) | |||
| 186901 | 186901 | 238537 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 2766 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009544.770219999 | 2103381.35603 | 37.7560231724418 | -122.40995949424 | (37.7560231724418, -122.40995949424) |
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");