Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1534 | 1534 | 196952 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 7 Richards Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 3ft | 6016313.63012 | 2095884.37873 | 37.735815058901 | -122.386027719813 | (37.735815058901, -122.386027719813) | |||
| 3254 | 3254 | 244746 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 98 12th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6007069.86029 | 2109755.10428 | 37.7733849739584 | -122.418970623803 | (37.7733849739584, -122.418970623803) | |||
| 8466 | 8466 | 59594 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1447 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1981 12:00:00 AM | 15 | 3x3 | Permit Number 18991 | 6000147.142999999 | 2113940.7254 | 37.7844853693895 | -122.44321788363199 | (37.7844853693895, -122.443217883632) | |
| 30928 | 30928 | 140171 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 227 COLE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997820.2409 | 2109762.5656 | 37.7728802733323 | -122.450966744377 | (37.7728802733323, -122.450966744377) | |||
| 36597 | 36597 | 248167 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201 Franconia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010183.09284 | 2099483.3725 | 37.7453559251449 | -122.407477148673 | (37.7453559251449, -122.407477148673) | |||
| 45339 | 45339 | 105506 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 184 HARTFORD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | 6002645.1 | 2104805.9 | 37.7595455158901 | -122.433922644582 | (37.7595455158901, -122.433922644582) | |||
| 48452 | 48452 | 239048 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6006902.036859999 | 2109961.28236 | 37.7739416381364 | -122.41956578074199 | (37.7739416381364, -122.419565780742) | |||
| 55173 | 55173 | 240084 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3536 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004751.60712 | 2103704.69949 | 37.75664119554779 | -122.42655887928301 | (37.7566411955478, -122.426558879283) | |||
| 63377 | 63377 | 71449 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 372 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 15 | 6011710.51408 | 2119095.9218900003 | 37.7992928818086 | -122.403575181848 | (37.7992928818086, -122.403575181848) | ||
| 63533 | 63533 | 136156 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 774 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6007537.99806 | 2120955.25152 | 37.8041641801856 | -122.41814546343599 | (37.8041641801856, -122.418145463436) | |||
| 66604 | 66604 | 239073 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 420 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009168.47089 | 2100058.07051 | 37.7468770753292 | -122.411026144157 | (37.7468770753292, -122.411026144157) | |||
| 80477 | 80477 | 115875 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 225 COLE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2016 12:00:00 AM | 15 | 3x3 | 5997789.0 | 2109771.0 | 37.7729016434693 | -122.45107541813299 | (37.7729016434693, -122.451075418133) | ||
| 166988 | 166988 | 240096 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2246 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002574.9176199995 | 2107108.53702 | 37.7658640156337 | -122.43432999572599 | (37.7658640156337, -122.434329995726) | |||
| 172769 | 172769 | 240055 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 335 Collingwood St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6002120.8328 | 2103881.11635 | 37.7569765176616 | -122.435669655535 | (37.7569765176616, -122.435669655535) | |||
| 175021 | 175021 | 139406 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1449 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000145.7511 | 2113965.7789 | 37.7845540804536 | -122.443224499142 | (37.7845540804536, -122.443224499142) | |||
| 178273 | 178273 | 248163 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 157 Rutledge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010185.03691 | 2099524.5674099997 | 37.7454691461902 | -122.407473330135 | (37.7454691461902, -122.407473330135) | |||
| 185119 | 185119 | 238862 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1745 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6008032.75507 | 2108079.03464 | 37.768837054702296 | -122.41552113829201 | (37.7688370547023, -122.415521138292) |
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");