Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 295 | 295 | 230413 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 310 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2016 08:33:00 AM | 1 | Width 7ft | 6004826.22566 | 2106515.9879900003 | 37.7643645463025 | -122.42650099174601 | (37.7643645463025, -122.426500991746) | ||
| 313 | 313 | 230412 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 310 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2016 08:29:00 AM | 1 | Width 6ft | 6004822.22232 | 2106544.83878 | 37.7644435373721 | -122.426516892666 | (37.7644435373721, -122.426516892666) | ||
| 31334 | 31334 | 230397 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 635 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010452.60466 | 2105203.30463 | 37.7610766734566 | -122.406948295125 | (37.7610766734566, -122.406948295125) | |||
| 39159 | 39159 | 208859 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 157 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995398.10832 | 2089609.6071400002 | 37.7174063107347 | -122.45788650015699 | (37.7174063107347, -122.457886500157) | |||
| 45892 | 45892 | 230421 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2851 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6009338.5093 | 2104971.08738 | 37.76037665287679 | -122.41078508446002 | (37.7603766528768, -122.41078508446) | |||
| 67791 | 67791 | 230398 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 625 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010441.3524 | 2105364.41642 | 37.761518420453896 | -122.40699856812901 | (37.7615184204539, -122.406998568129) | |||
| 68017 | 68017 | 208858 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 438 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995058.10493 | 2088636.3102900002 | 37.7147143277695 | -122.458991293911 | (37.7147143277695, -122.458991293911) | |||
| 70771 | 70771 | 193438 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 170 Scotia Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012250.26105 | 2094642.5839099998 | 37.7321796295918 | -122.39998929257601 | (37.7321796295918, -122.399989292576) | |||
| 147472 | 147472 | 230408 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Potrero Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010466.90309 | 2104889.86859 | 37.7602168487345 | -122.40687675138001 | (37.7602168487345, -122.40687675138) | |||
| 149115 | 149115 | 93670 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 12 Robblee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 54071 | 6012650.87025 | 2095997.96753 | 37.735923558519104 | -122.39869937070299 | (37.7359235585191, -122.398699370703) | |
| 155237 | 155237 | 131012 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1661 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006845.959840001 | 2116366.0433 | 37.7915243922801 | -122.420214413174 | (37.7915243922801, -122.420214413174) | |||
| 162305 | 162305 | 230396 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 675 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010452.66825 | 2105159.82839 | 37.7609573010551 | -122.406945010817 | (37.7609573010551, -122.406945010817) | |||
| 174880 | 174880 | 46981 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1310 Minnesota St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | 1 | Permit Number 44998 | 6015319.9852 | 2102418.03165 | 37.7537000725041 | -122.389919420856 | (37.7537000725041, -122.389919420856) | ||
| 179529 | 179529 | 230395 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 675 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010455.482030001 | 2105111.38251 | 37.760824437031395 | -122.40693186450899 | (37.7608244370314, -122.406931864509) |
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");