Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28890 | 28890 | 182659 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2252 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986985.3742 | 2102363.8158 | 37.7519391046129 | -122.487901613135 | (37.7519391046129, -122.487901613135) | |||
35363 | 35363 | 98849 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795X 31st Ave | 2 | 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) | |
43893 | 43893 | 117895 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 635 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5984097.32613 | 2111483.29523 | 37.7768097259285 | -122.498562310404 | (37.7768097259285, -122.498562310404) | |||
44865 | 44865 | 46434 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2St. Ankeny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011096.25435 | 2089701.2859 | 37.7185474406786 | -122.40363143174 | (37.7185474406786, -122.40363143174) | |
48201 | 48201 | 119241 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981435.03386 | 2111334.77238 | 37.776245435782 | -122.50776079209999 | (37.776245435782, -122.5077607921) | |||
56930 | 56930 | 207038 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 270 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994641.46146 | 2100307.8933900003 | 37.7467376875983 | -122.461276941602 | (37.7467376875983, -122.461276941602) | |||
64913 | 64913 | 201811 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021050.71889 | 2093203.62599 | 37.7287152512926 | -122.369464359799 | (37.7287152512926, -122.369464359799) | |||
66467 | 66467 | 176899 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 167 Madison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6005613.54422 | 2092807.28897 | 37.7267680598911 | -122.422803552358 | (37.7267680598911, -122.422803552358) | |||
66926 | 66926 | 184599 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983770.6594 | 2102984.6576 | 37.7534557168171 | -122.499064248064 | (37.7534557168171, -122.499064248064) | |||
70354 | 70354 | 207004 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 171 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992803.19794 | 2098037.0989599996 | 37.7403966964551 | -122.46746831791 | (37.7403966964551, -122.46746831791) | |||
122015 | 122015 | 88207 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 187 Beaumont Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51211 | 5996848.1239 | 2111670.4224 | 37.7780630497691 | -122.454467238117 | (37.7780630497691, -122.454467238117) | |
133488 | 133488 | 118589 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 150 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982275.325019999 | 2112634.79146 | 37.779864376411 | -122.50495040283998 | (37.779864376411, -122.50495040284) | |||
138540 | 138540 | 176888 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 13 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002306.40089 | 2092528.2983099998 | 37.7258148612434 | -122.43421630345301 | (37.7258148612434, -122.434216303453) | |||
145461 | 145461 | 111714 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 3038 CLEMENT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051.0 | 2113265.0 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | |
153240 | 153240 | 95898 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1700 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989073.1619 | 2103670.6386 | 37.755648856222 | -122.48077749293999 | (37.755648856222, -122.48077749294) |
157031 | 157031 | 206985 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1498 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990877.17813 | 2105275.0931700002 | 37.760158953986604 | -122.474655794123 | (37.7601589539866, -122.474655794123) | |||
161979 | 161979 | 117687 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 8ft | 5982599.26265 | 2112595.13886 | 37.7797745547632 | -122.50382684040501 | (37.7797745547632, -122.503826840405) | |||
172906 | 172906 | 207014 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 651 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5997782.54111 | 2094977.3620200001 | 37.732281609092496 | -122.45003132048201 | (37.7322816090925, -122.450031320482) | |||
172938 | 172938 | 176884 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 96 Alpha St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011062.55449 | 2088258.87965 | 37.7145850034576 | -122.40364648639601 | (37.7145850034576, -122.403646486396) | ||||
176471 | 176471 | 182700 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1651 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989102.9459 | 2103739.8915 | 37.7558407372502 | -122.48067956122401 | (37.7558407372502, -122.480679561224) | |||
180870 | 180870 | 227099 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 75 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010635.77556 | 2100089.10311 | 37.7470444571367 | -122.40595450111401 | (37.7470444571367, -122.405954501114) |
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");