Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlantDate, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
133064 | 133064 | 178900 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1128 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6009581.67769 | 2090926.3916900002 | 37.721826605402 | -122.40895311598699 | (37.721826605402, -122.408953115987) | |||
171106 | 171106 | 196409 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1143 Howard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6009598.37036 | 2111065.11658 | 37.7771240168943 | -122.41031662852801 | (37.7771240168943, -122.410316628528) | |||
177949 | 177949 | 178959 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1333 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007585.1415 | 2091886.2374099998 | 37.7243500958617 | -122.41592258217399 | (37.7243500958617, -122.415922582174) | |||
60283 | 60283 | 244907 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 150 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999911.6566 | 2109010.7372 | 37.7709354515424 | -122.443678294205 | (37.7709354515424, -122.443678294205) | |||
159636 | 159636 | 40022 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1535 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 9 | Permit Number 41267 | 6015717.1223 | 2095636.9971 | 37.7351027679039 | -122.388072841786 | (37.7351027679039, -122.388072841786) | |
156261 | 156261 | 237977 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 155 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997765.756440001 | 2104874.4673200003 | 37.759455679665706 | -122.45080270049401 | (37.7594556796657, -122.450802700494) | |||
182703 | 182703 | 41337 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 176 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2000 12:00:00 AM | 9 | Permit Number 41991 | 5996265.7 | 2113122.5903 | 37.7820168986492 | -122.456587081702 | (37.7820168986492, -122.456587081702) | ||
182867 | 182867 | 41338 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 176 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2000 12:00:00 AM | 9 | Permit Number 41991 | 5996265.0232 | 2113139.8498 | 37.7820642497954 | -122.456590671642 | (37.7820642497954, -122.456590671642) | ||
66227 | 66227 | 196412 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 18 Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6009772.78472 | 2111137.69481 | 37.7773330751096 | -122.409718395893 | (37.7773330751096, -122.409718395893) | |||
46789 | 46789 | 244991 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 213 Lily St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005531.8427 | 2110116.9147 | 37.7742916920696 | -122.424316587333 | (37.7742916920696, -122.424316587333) | |||
64163 | 64163 | 196408 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 22 Rausch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009625.06025 | 2110948.02453 | 37.776804005729204 | -122.41021603036002 | (37.7768040057292, -122.41021603036) | |||
138095 | 138095 | 66214 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2233 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1990 12:00:00 AM | 9 | Permit Number 29304 | 5989765.2961 | 2100174.6084 | 37.7460898851299 | -122.47812830871 | (37.7460898851299, -122.47812830871) | ||
64779 | 64779 | 183767 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2287 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5987606.1386 | 2099727.1382 | 37.744735684193 | -122.48556146831001 | (37.744735684193, -122.48556146831) | |||
33576 | 33576 | 196395 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 260 Clara St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6011460.59942 | 2111454.8789 | 37.7782984271806 | -122.40390199009501 | (37.7782984271806, -122.403901990095) | |||
140323 | 140323 | 114422 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 30X OGDEN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x9 | 6009444.0 | 2095952.0 | 37.735618147291795 | -122.40978359873999 | (37.7356181472918, -122.40978359874) | |||
182779 | 182779 | 31302 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 529 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 9 | Permit Number 34944 | 6005223.0006 | 2111465.2723 | 37.7779765092875 | -122.42548090783501 | (37.7779765092875, -122.425480907835) | |
170362 | 170362 | 118429 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5981844.98436 | 2111695.06236 | 37.7772588298958 | -122.50636940951 | (37.7772588298958, -122.50636940951) | |||
123837 | 123837 | 42457 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 571 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 9 | 3x3 | Permit Number 42600 | 5997658.92569742 | 2095237.95802388 | 37.732990069317296 | -122.45047746491899 | (37.7329900693173, -122.450477464919) |
70625 | 70625 | 178891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 579 Madrid St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6002452.87445 | 2090566.89512 | 37.720437599790394 | -122.43356984466999 | (37.7204375997904, -122.43356984467) | |||
50185 | 50185 | 238001 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 591 27th St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002762.01889 | 2100032.1411900003 | 37.746444541887705 | -122.43317718719601 | (37.7464445418877, -122.433177187196) | ||||
188281 | 188281 | 178950 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 609 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007192.0962 | 2091723.76737 | 37.723881882739704 | -122.417269780083 | (37.7238818827397, -122.417269780083) | |||
157232 | 157232 | 238013 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 77 Ashbury Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999618.479619999 | 2106729.8577400004 | 37.764656004003 | -122.44452844265899 | (37.764656004003, -122.444528442659) | |||
153810 | 153810 | 102572 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 778 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x9 | 5997324.2834 | 2112596.006 | 37.7806317567919 | -122.452886865809 | (37.7806317567919, -122.452886865809) | |||
159092 | 159092 | 196393 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013990.372330001 | 2112956.91555 | 37.7825636859099 | -122.395255750564 | (37.7825636859099, -122.395255750564) |
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");