Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23692 | 23692 | 71227 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2270 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987645.1852 | 2099845.9848 | 37.7450642803204 | -122.48543517398599 | (37.7450642803204, -122.485435173986) | ||
| 32121 | 32121 | 66333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1291 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1990 12:00:00 AM | 6 | Permit Number 29454 | 5986445.8362 | 2106470.4022 | 37.763183176794705 | -122.490069413492 | (37.7631831767947, -122.490069413492) | |
| 40005 | 40005 | 32827 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4107 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | 3x3 | Permit Number 37185 | 6002480.53446063 | 2101776.94850735 | 37.751219399221604 | -122.434275246016 | (37.7512193992216, -122.434275246016) |
| 52984 | 52984 | 69922 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1479 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1990 12:00:00 AM | 6 | 5987109.7204 | 2105224.4854 | 37.7598009776001 | -122.487681752733 | (37.7598009776001, -122.487681752733) | ||
| 53715 | 53715 | 72507 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2135 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1996 12:00:00 AM | 6 | 5988189.7462 | 2100767.6803 | 37.747626723008295 | -122.48361976345801 | (37.7476267230083, -122.483619763458) | ||
| 56036 | 56036 | 42854 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2471 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 6 | Permit Number 42783 | 5987340.671 | 2098461.3118 | 37.74124459004229 | -122.486386476099 | (37.7412445900423, -122.486386476099) | |
| 57598 | 57598 | 43283 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 872 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 6 | Permit Number 43052 | 6010937.3393 | 2090651.3857900002 | 37.72114734204379 | -122.404247572584 | (37.7211473420438, -122.404247572584) | |
| 62412 | 62412 | 71226 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2267 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987603.3648 | 2099853.8795 | 37.745083520509894 | -122.485580358953 | (37.7450835205099, -122.485580358953) | ||
| 63241 | 63241 | 73536 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2270 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987645.1852 | 2099831.4757 | 37.7450244421871 | -122.485434109471 | (37.7450244421871, -122.485434109471) | ||
| 81184 | 81184 | 37591 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 662 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40019 | 6003651.61608784 | 2104418.27327771 | 37.7585382525557 | -122.430413956054 | (37.7585382525557, -122.430413956054) | |
| 143293 | 143293 | 43850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2674 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 6 | Permit Number 43472 | 5985253.1482 | 2097047.7977 | 37.7372415601551 | -122.493500160872 | (37.7372415601551, -122.493500160872) | |
| 151418 | 151418 | 47893 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 745 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 6 | Permit Number 48331 | 6000477.4696 | 2111570.4889 | 37.7779961374161 | -122.44190489030899 | (37.7779961374161, -122.441904890309) | |
| 152143 | 152143 | 45042 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1874 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2001 12:00:00 AM | 6 | Permit Number 43928 | 5988487.0359 | 2102578.4714 | 37.7526159729384 | -122.48272444408998 | (37.7526159729384, -122.48272444409) | |
| 160866 | 160866 | 44713 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1923 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 6 | Permit Number 43836 | 5990003.0613 | 2102262.9361 | 37.7518376831776 | -122.477458761132 | (37.7518376831776, -122.477458761132) | |
| 169020 | 169020 | 30735 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 281 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34629 | 6005244.0655 | 2109725.8172 | 37.773201579085004 | -122.42528422609699 | (37.773201579085, -122.425284226097) | |
| 181390 | 181390 | 46205 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1852 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2005 12:00:00 AM | 6 | Permit Number 44521 | 5988484.6348 | 2102686.0448 | 37.7529112010076 | -122.482740630037 | (37.7529112010076, -122.482740630037) | |
| 182510 | 182510 | 43851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2678 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 6 | Permit Number 43473 | 5985253.1482 | 2097007.4687 | 37.737130827494504 | -122.49349719028 | (37.7371308274945, -122.49349719028) | |
| 189022 | 189022 | 43336 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 423 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 6 | Permit Number 43093 | 6003416.5357 | 2091104.1943299999 | 37.7219675345615 | -122.430277093028 | (37.7219675345615, -122.430277093028) |
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");