Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26689 | 26689 | 193419 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 610 Illinois St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015956.40459 | 2106139.49843 | 37.763953701820604 | -122.387978189259 | (37.7639537018206, -122.387978189259) | |||
| 36116 | 36116 | 75673 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 618X Missouri St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 7 | 6013545.06469 | 2104202.26889 | 37.7585006086339 | -122.396182576568 | (37.7585006086339, -122.396182576568) | ||
| 40746 | 40746 | 193433 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 588 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013536.39974 | 2104342.74788 | 37.758885851209 | -122.396222389564 | (37.758885851209, -122.396222389564) | |||
| 44441 | 44441 | 230406 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010469.85138 | 2104738.84531 | 37.7598023377254 | -122.406855910494 | (37.7598023377254, -122.406855910494) | |||
| 46903 | 46903 | 193418 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 610 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015955.040580001 | 2106161.7939400002 | 37.7640148449206 | -122.387984462917 | (37.7640148449206, -122.387984462917) | |||
| 47570 | 47570 | 117158 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6014455.94065 | 2103803.2979900003 | 37.7574557609929 | -122.393004420141 | (37.7574557609929, -122.393004420141) | |||
| 61175 | 61175 | 117154 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6014461.75742 | 2103731.13458 | 37.757257938912 | -122.3929792544 | (37.757257938912, -122.3929792544) | |||
| 136176 | 136176 | 117160 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6014455.03317 | 2103837.45298 | 37.7575494928317 | -122.393009948265 | (37.7575494928317, -122.393009948265) | |||
| 138541 | 138541 | 230402 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 995 Potrero Ave | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6010527.0507 | 2103856.48907 | 37.7573827855076 | -122.406595905697 | (37.7573827855076, -122.406595905697) | |||
| 138689 | 138689 | 35331 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2222 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 7 | Permit Number 38797 | 6011102.74031 | 2105580.11017 | 37.7621476554073 | -122.404726272704 | (37.7621476554073, -122.404726272704) | |
| 163256 | 163256 | 193435 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 600 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013537.44197 | 2104295.86136 | 37.7587571690323 | -122.39621549896299 | (37.7587571690323, -122.396215498963) | |||
| 165780 | 165780 | 193423 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015877.90137 | 2105798.99134 | 37.7630143932264 | -122.388225945268 | (37.7630143932264, -122.388225945268) | |||
| 172396 | 172396 | 193422 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015855.7958 | 2105797.31045 | 37.763008553013 | -122.388302284235 | (37.763008553013, -122.388302284235) | |||
| 174486 | 174486 | 230411 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2901 Cesar Chavez St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6010009.797780001 | 2100525.6899 | 37.7482081987543 | -122.408149874844 | (37.7482081987543, -122.408149874844) | ||||
| 175041 | 175041 | 193421 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015817.08868 | 2105796.2011 | 37.763003362128 | -122.38843608266899 | (37.763003362128, -122.388436082669) |
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");