Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, PlantType, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12077 | 12077 | 94990 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 48 Leland Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010713.1186 | 2087200.5157 | 37.7116594240627 | -122.40477981842301 | (37.7116594240627, -122.404779818423) | ||||
| 12485 | 12485 | 94989 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 44 Leland Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010751.8878 | 2087184.0277 | 37.711616318234206 | -122.404644660956 | (37.7116163182342, -122.404644660956) | ||||
| 19641 | 19641 | 94973 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 230 Seacliff Ave | 5 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | |||
| 46832 | 46832 | 94612 | Permitted Site 1 | Tristania conferta :: 79 | 5600@ Armstrong 03rd St | 3 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 4 | Permit Number 53777 | 6013990.2772 | 2092621.1644 | 37.726726080275604 | -122.393832179047 | (37.7267260802756, -122.393832179047) | ||
| 51239 | 51239 | 94972 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 230 Seacliff Ave | 4 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | |||
| 52627 | 52627 | 98408 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 24 19th Ave | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | 3 | Permit Number 768590 | 5989918.49451 | 2114923.36913 | 37.7865948726066 | -122.478677005621 | (37.7865948726066, -122.478677005621) | ||
| 69957 | 69957 | 98409 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 55 19th Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||||
| 77885 | 77885 | 93935 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 230 Seacliff Ave | 3 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 37x6 | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | ||
| 78378 | 78378 | 93933 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 230 Seacliff Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 37x6 | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | ||
| 78494 | 78494 | 94522 | Permitted Site 1 | Tree(s) :: 17 | 524 Howard St | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 08/30/2010 12:00:00 AM | Permit Number 53710 | 6013519.0 | 2114878.0 | 37.7878123136723 | -122.397021246793 | (37.7878123136723, -122.397021246793) | ||||
| 87250 | 87250 | 93936 | Permitted Site 1 | Tree(s) :: 17 | 230 Seacliff Ave | Sidewalk: Curb side : 21 | Landscaping 2 | Private 1 | 04/26/2010 12:00:00 AM | 37x6 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | ||||
| 88454 | 88454 | 94991 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 48 Leland Ave | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010722.4 | 2087213.8 | 37.7116964188451 | -122.40474867386699 | (37.7116964188451, -122.404748673867) | ||||
| 89118 | 89118 | 98412 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 19th Ave | 4 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||
| 90271 | 90271 | 94521 | Permitted Site 1 | Tree(s) :: 17 | 524 Howard St | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 08/30/2010 12:00:00 AM | Permit Number 53710 | 6013519.0 | 2114878.0 | 37.7878123136723 | -122.397021246793 | (37.7878123136723, -122.397021246793) | ||||
| 91295 | 91295 | 98410 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 19th Ave | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||
| 96447 | 96447 | 98411 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 19th Ave | 3 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||
| 96749 | 96749 | 93115 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 397 San Jose Ave | 1 | Sidewalk: Curb side : 21 | Landscaping 2 | Private 1 | 02/02/2009 12:00:00 AM | 26x6 | Permit Number 53167 | 6006259.6 | 2100887.6 | 37.7489912240508 | -122.42114365927 | (37.7489912240508, -122.42114365927) | ||
| 100055 | 100055 | 94492 | Permitted Site 1 | Tree(s) :: 17 | 246 29th Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 5986862.8 | 2114289.3 | 37.7846760086181 | -122.489202186141 | (37.7846760086181, -122.489202186141) | |||||
| 104277 | 104277 | 93116 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 397 San Jose Ave | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | Permit 53167 | 6006259.6 | 2100887.6 | 37.7489912240508 | -122.42114365927 | (37.7489912240508, -122.42114365927) | |||
| 112064 | 112064 | 94614 | Permitted Site 1 | Alnus rhombifolia :: White Alder 204 | 5600@ Bancroft 03rd St | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | Permit Number 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | |||
| 117984 | 117984 | 91210 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 333 Haight St | 1 | Sidewalk: Curb side : 21 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 6004540.59043 | 2109422.99046 | 37.7723303224715 | -122.427696060061 | (37.7723303224715, -122.427696060061) | |||
| 122113 | 122113 | 93934 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 230 Seacliff Ave | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 37x6 | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | ||
| 138606 | 138606 | 94563 | Section 143 8 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301X Oak St | 3 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 09/15/2010 12:00:00 AM | Permit Number 53745 | 6005493.0 | 2110231.0 | 37.7746027492624 | -122.42445906794902 | (37.7746027492624, -122.424459067949) | |||
| 155501 | 155501 | 98407 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 24 19th Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | 3 | Permit Number 768590 | 5989919.44776 | 2114906.64899 | 37.7865490191546 | -122.47867248440201 | (37.7865490191546, -122.478672484402) | ||
| 176682 | 176682 | 98235 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 42 19th Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 01/09/2012 12:00:00 AM | 3 | Permit Number 768620 | 5989920.54745 | 2114876.2625700003 | 37.7864656504451 | -122.47866645673 | (37.7864656504451, -122.47866645673) |
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");