Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16779 | 16779 | 6759 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1275 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2015 12:51:00 PM | 3 | 3x3 | 6017200.097680001 | 2096971.1659799998 | 37.7388481798969 | -122.38303843809099 | (37.7388481798969, -122.383038438091) | ||
| 23175 | 23175 | 25492 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/2001 12:00:00 AM | 5 | 3X3 | 6003043.5783 | 2109236.3656 | 37.7717331028377 | -122.43286102333299 | (37.7717331028377, -122.432861023333) | ||
| 23437 | 23437 | 139746 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1314 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004648.3504 | 2113539.1351 | 37.783638338734995 | -122.427616619318 | (37.783638338735, -122.427616619318) | |||
| 27224 | 27224 | 190666 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6013164.18283 | 2111305.0882200003 | 37.7779821643861 | -122.397998114425 | (37.7779821643861, -122.397998114425) | |||
| 30267 | 30267 | 228488 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2880 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008610.437969999 | 2106311.71269 | 37.7640168522296 | -122.413397964868 | (37.7640168522296, -122.413397964868) | |||
| 40233 | 40233 | 129086 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1201 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008124.6291 | 2115843.7412 | 37.7901622440508 | -122.41575322364599 | (37.7901622440508, -122.415753223646) | |||
| 46133 | 46133 | 228504 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 60 Brady St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006682.42728 | 2109519.39101 | 37.7727159377106 | -122.420294078716 | (37.7727159377106, -122.420294078716) | |||
| 50889 | 50889 | 228496 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004270.1448800005 | 2105926.96043 | 37.762715766133 | -122.428382334783 | (37.762715766133, -122.428382334783) | |||
| 54440 | 54440 | 228473 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 214 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004983.40723 | 2109552.71485 | 37.7727115526285 | -122.426173552181 | (37.7727115526285, -122.426173552181) | |||
| 56681 | 56681 | 190671 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013262.027919999 | 2111394.33223 | 37.7782326570475 | -122.397665892288 | (37.7782326570475, -122.397665892288) | |||
| 68617 | 68617 | 228483 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 950 Corbett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999780.4847 | 2102039.74605 | 37.751787354827 | -122.44363115936198 | (37.751787354827, -122.443631159362) | |||
| 71808 | 71808 | 190649 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1164 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6014097.05519 | 2105748.35032 | 37.7627765099393 | -122.394381783993 | (37.7627765099393, -122.394381783993) | |||
| 82897 | 82897 | 15297 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1625 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/02/1995 12:00:00 AM | 0 | 3X3 | 6007067.55267 | 2109351.08159 | 37.7722754939412 | -122.4189499451 | (37.7722754939412, -122.4189499451) | ||
| 83968 | 83968 | 49189 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 301 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46293 | 6005519.89358109 | 2107236.54938111 | 37.7663822259368 | -122.424153033894 | (37.7663822259368, -122.424153033894) | |||
| 86257 | 86257 | 49459 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 175 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013251.15232562 | 2111133.20769228 | 37.7775150629692 | -122.397685195261 | (37.7775150629692, -122.397685195261) | |
| 90692 | 90692 | 6807 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1395 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6016583.3780675 | 2097443.6071151 | 37.7401113108781 | -122.385203697211 | (37.7401113108781, -122.385203697211) | ||
| 104221 | 104221 | 6822 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
| 104856 | 104856 | 10264 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 212 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005102.223809999 | 2109572.2105099997 | 37.7727717979426 | -122.42576394022 | (37.7727717979426, -122.42576394022) | |||
| 105341 | 105341 | 122811 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1801 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005422.0 | 2107198.0 | 37.7662708507612 | -122.424488887708 | (37.7662708507612, -122.424488887708) | ||||
| 105952 | 105952 | 67708 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 57 Stillman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | Permit Number 31319 | 6013961.97114475 | 2112919.16578606 | 37.78245845414779 | -122.395351361788 | (37.7824584541478, -122.395351361788) | ||
| 110522 | 110522 | 6249 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1310X Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2013 12:00:00 AM | 18 | 4X4 | 6004670.79192 | 2113352.05321 | 37.7831259277051 | -122.42752564758699 | (37.7831259277051, -122.427525647587) | ||
| 113346 | 113346 | 106355 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2014 12:00:00 AM | 3x3 | Permit Number 771746 | 6006716.8 | 2109464.1 | 37.772566058604205 | -122.420171254703 | (37.7725660586042, -122.420171254703) | ||
| 113347 | 113347 | 49191 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 113551 | 113551 | 39284 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3000X 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 139363 | 139363 | 93304 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004236.0 | 2105969.0 | 37.7628292645514 | -122.428503426462 | (37.7628292645514, -122.428503426462) | ||
| 147535 | 147535 | 129089 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6011405.84379 | 2120790.43469 | 37.8039285776094 | -122.40474881240601 | (37.8039285776094, -122.404748812406) | |||
| 148748 | 148748 | 246382 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1655 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6006956.341 | 2109096.7729 | 37.77157095990471 | -122.41931659334999 | (37.7715709599047, -122.41931659335) | |||
| 160222 | 160222 | 228451 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009297.41402 | 2106368.8801700003 | 37.7642123684355 | -122.411025946309 | (37.7642123684355, -122.411025946309) | |||
| 174866 | 174866 | 228507 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006742.36606 | 2109459.07113 | 37.772553691019894 | -122.420082461948 | (37.7725536910199, -122.420082461948) |
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");