Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4795 | 4795 | 106876 | Permitted Site 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 3200X Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2014 12:00:00 AM | 21 | 3x3 | Permit Number 772880 | 5999360.60795 | 2115700.2414599997 | 37.7892716598179 | -122.446065616935 | (37.7892716598179, -122.446065616935) | |
| 5439 | 5439 | 18984 | DPW Maintained 3 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 2924 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000584.255030001 | 2115541.8727 | 37.7889066204895 | -122.44182058485701 | (37.7889066204895, -122.441820584857) | |||
| 5499 | 5499 | 106877 | Permitted Site 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 3200X Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2014 12:00:00 AM | 12 | 3x3 | Permit Number 772880 | 5999315.5996900005 | 2115694.92297 | 37.789254486352206 | -122.446220956829 | (37.7892544863522, -122.446220956829) | |
| 24977 | 24977 | 136363 | Undocumented 2 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 3258 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5999008.9173099995 | 2120036.67955 | 37.801158273583205 | -122.447594701857 | (37.8011582735832, -122.447594701857) | ||||
| 27563 | 27563 | 197474 | DPW Maintained 3 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 1700x Quesada Ave | 47 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6014305.55494 | 2095325.1628400001 | 37.7341682275767 | -122.392931365507 | (37.7341682275767, -122.392931365507) | ||||
| 27856 | 27856 | 63041 | Permitted Site 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 446 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/1986 12:00:00 AM | 6 | Permit Number 23511 | 5983797.44561 | 2112800.44683 | 37.780408650405796 | -122.4996970443 | (37.7804086504058, -122.4996970443) | ||
| 41924 | 41924 | 214148 | Undocumented 2 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 1200 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994560.23843 | 2107256.02071 | 37.7658107892659 | -122.46206158748998 | (37.7658107892659, -122.46206158749) | |||
| 52585 | 52585 | 239559 | Undocumented 2 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 850 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 6002419.2495099995 | 2103265.93732 | 37.7553043290595 | -122.434593632903 | (37.7553043290595, -122.434593632903) | |||
| 59689 | 59689 | 214149 | Undocumented 2 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 193 Del Sur Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5996242.3628 | 2098535.08925 | 37.7419620096322 | -122.45561309857099 | (37.7419620096322, -122.455613098571) | |||
| 61832 | 61832 | 30879 | Permitted Site 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 887 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | 9 | Permit Number 34712 | 6003127.606980001 | 2103199.82394 | 37.7551629843999 | -122.43213920136999 | (37.7551629843999, -122.43213920137) | ||
| 62838 | 62838 | 239560 | Undocumented 2 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 960 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003105.5689199995 | 2102623.67498 | 37.7535797666026 | -122.43217427221799 | (37.7535797666026, -122.432174272218) | |||
| 74512 | 74512 | 214150 | Undocumented 2 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 19 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 6000833.087859999 | 2094320.24642 | 37.730651407126004 | -122.43943782211299 | (37.730651407126, -122.439437822113) | |||
| 148468 | 148468 | 239562 | Undocumented 2 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 737 Sanchez St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6003703.284 | 2103987.00302 | 37.757357013643606 | -122.430204497936 | (37.7573570136436, -122.430204497936) | |||
| 163376 | 163376 | 32448 | Permitted Site 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 4302 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 7 | Permit Number 36967 | 6000728.25925 | 2105820.59303 | 37.7622226489821 | -122.440624795915 | (37.7622226489821, -122.440624795915) | |
| 164698 | 164698 | 247637 | Undocumented 2 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 360 Bradford St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6009458.82615 | 2096582.35495 | 37.7373497969565 | -122.409776819464 | (37.7373497969565, -122.409776819464) | ||||
| 166524 | 166524 | 110526 | Permitted Site 1 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 21311 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2015 12:00:00 AM | 2 | 4x4 | Permit Number 775214 | 6001840.45625 | 2115879.31101 | 37.789904637731105 | -122.43749848178801 | (37.7899046377311, -122.437498481788) | |
| 168292 | 168292 | 239561 | Undocumented 2 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 3637 22nd St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6004045.51841 | 2103028.99771 | 37.7547459354811 | -122.428952616494 | (37.7547459354811, -122.428952616494) |
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");