Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2610 | 2610 | 253145 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 801X Santiago St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5990274.0 | 2099728.0 | 37.7448931297685 | -122.47633667765699 | (37.7448931297685, -122.476336677657) | |||||
| 26288 | 26288 | 247985 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 495 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009773.5395 | 2099699.6998799997 | 37.7459269802441 | -122.40890858338001 | (37.7459269802441, -122.40890858338) | ||||
| 34805 | 34805 | 236092 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 200 Corbin Pl | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 3ft | 6000056.44576 | 2105686.72803 | 37.761816809218296 | -122.44293872364099 | (37.7618168092183, -122.442938723641) | |||
| 39131 | 39131 | 234106 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 10 Crescent Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 3ft | 6005252.57338 | 2095904.2217 | 37.735251176793604 | -122.424271584978 | (37.7352511767936, -122.424271584978) | |||
| 42630 | 42630 | 201727 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1411 Phelps St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6013753.9526 | 2095943.1082 | 37.7358343232928 | -122.394881707251 | (37.7358343232928, -122.394881707251) | ||||
| 43890 | 43890 | 249771 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6010450.87532 | 2121165.29 | 37.8049044157696 | -122.408080009188 | (37.8049044157696, -122.408080009188) | |||
| 51586 | 51586 | 194761 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 900 Quint St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 3ft | 6014176.55403 | 2097659.59689 | 37.7405709356069 | -122.39354069034799 | (37.7405709356069, -122.393540690348) | |||
| 53370 | 53370 | 249773 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6010432.56007 | 2121153.50484 | 37.80487103114871 | -122.40814255972602 | (37.8048710311487, -122.408142559726) | |||
| 58384 | 58384 | 236089 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 198 Corbin Pl | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 3ft | 6000079.09557 | 2105681.45742 | 37.761803628741795 | -122.442860008701 | (37.7618036287418, -122.442860008701) | |||
| 64330 | 64330 | 236093 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 200 Corbin Pl | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 3ft | 6000063.11815 | 2105682.66467 | 37.7618060326498 | -122.44291535476201 | (37.7618060326498, -122.442915354762) | |||
| 64938 | 64938 | 249772 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6010438.89548 | 2121163.96639 | 37.8049001107042 | -122.40812137351801 | (37.8049001107042, -122.408121373518) | |||
| 73975 | 73975 | 247997 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 346 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6009761.42839 | 2099270.1592099997 | 37.744746877282 | -122.40892016123199 | (37.744746877282, -122.408920161232) | ||||
| 147088 | 147088 | 247846 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 149 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6009148.8704 | 2098211.07705 | 37.7418045383459 | -122.410963488373 | (37.7418045383459, -122.410963488373) | ||||
| 148101 | 148101 | 236091 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 200 Corbin Pl | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 3ft | 6000061.20427 | 2105698.96506 | 37.7618506803725 | -122.44292314469101 | (37.7618506803725, -122.442923144691) | |||
| 151115 | 151115 | 248085 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 15 Montcalm St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6010679.730830001 | 2100354.6756 | 37.7477761194855 | -122.405821210793 | (37.7477761194855, -122.405821210793) | ||||
| 158327 | 158327 | 194694 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1750 22nd St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6012866.59255 | 2103798.94499 | 37.757355394863794 | -122.398500751831 | (37.7573553948638, -122.398500751831) | ||||
| 160232 | 160232 | 194783 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1998 Revere Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6013039.99864 | 2095949.41878 | 37.735811926582706 | -122.39735058635901 | (37.7358119265827, -122.397350586359) | ||||
| 169254 | 169254 | 236090 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 200 Corbin Pl | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 3ft | 6000058.01731 | 2105721.74002 | 37.7619130330791 | -122.442935802668 | (37.7619130330791, -122.442935802668) | |||
| 176991 | 176991 | 194762 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 900 Quint St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 3ft | 6014169.91323 | 2097651.03706 | 37.7405470630994 | -122.393563052915 | (37.7405470630994, -122.393563052915) | |||
| 182365 | 182365 | 201726 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1411 Phelps St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6013752.92787 | 2095946.3891599998 | 37.735843275152995 | -122.394885479886 | (37.735843275153, -122.394885479886) | ||||
| 186431 | 186431 | 211852 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 714 Detroit St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 5999466.29609 | 2095415.22212 | 37.7335800736498 | -122.44424166861602 | (37.7335800736498, -122.444241668616) |
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");