Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, PlantDate, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12296 | 12296 | 19104 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 10X Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/29/2007 12:00:00 AM | 3 | 4X30 | 6011705.43586 | 2090789.4617400002 | 37.721569360619604 | -122.40160216911 | (37.7215693606196, -122.40160216911) | ||
17712 | 17712 | 5442 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 6 | 6004907.01705 | 2105068.65381 | 37.7603950772802 | -122.426118512771 | (37.7603950772802, -122.426118512771) | |||
18074 | 18074 | 112652 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | ||||
18744 | 18744 | 5437 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 25 | 6 | 6004897.82208 | 2105221.96635 | 37.760815517531206 | -122.426161228775 | (37.7608155175312, -122.426161228775) | |||
18991 | 18991 | 5440 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004903.17124 | 2105121.8240799997 | 37.7605408528978 | -122.426135598976 | (37.7605408528978, -122.426135598976) | |||
19884 | 19884 | 5444 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 6 | 6004913.15076 | 2105006.62195 | 37.760225099135795 | -122.426092882994 | (37.7602250991358, -122.426092882994) | |||
20609 | 20609 | 5438 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/19/1992 12:00:00 AM | 20 | 6 | 6004899.41142 | 2105199.1804 | 37.7607530425379 | -122.426154109737 | (37.7607530425379, -122.426154109737) | ||
20901 | 20901 | 5441 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004905.78091 | 2105098.60706 | 37.76047725195271 | -122.426124920443 | (37.7604772519527, -122.426124920443) | |||
20994 | 20994 | 5443 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/19/1992 12:00:00 AM | 80 | 6 | 6004908.86181 | 2105038.27798 | 37.7603117767003 | -122.426109970095 | (37.7603117767003, -122.426109970095) | ||
21952 | 21952 | 5447 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004926.667780001 | 2104747.1594700003 | 37.7595134404185 | -122.42602766326401 | (37.7595134404185, -122.426027663264) | |||
48565 | 48565 | 112649 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | ||||
81721 | 81721 | 112650 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | ||||
85991 | 85991 | 5471 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/02/1992 12:00:00 AM | 25 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
90787 | 90787 | 112647 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | |||
91762 | 91762 | 5469 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/02/1992 12:00:00 AM | 25 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
97474 | 97474 | 112653 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | ||||
100994 | 100994 | 5461 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/11/2006 12:00:00 AM | 3 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
103125 | 103125 | 112648 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | ||||
105022 | 105022 | 5464 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | |||
106129 | 106129 | 101314 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 4244X 19th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10 | 4x4 | 6001912.0 | 2104709.0 | 37.7592378221466 | -122.43645112889901 | (37.7592378221466, -122.436451128899) | |||
110081 | 110081 | 112655 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | ||||
111960 | 111960 | 5468 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/01/1990 12:00:00 AM | 25 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
115430 | 115430 | 5466 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/20/1990 12:00:00 AM | 25 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
115857 | 115857 | 5470 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/10/2006 12:00:00 AM | 3 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
116727 | 116727 | 5487 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 700X Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
117932 | 117932 | 112654 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | ||||
140981 | 140981 | 112651 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | ||||
141306 | 141306 | 5462 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/02/1992 12:00:00 AM | 25 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
142678 | 142678 | 5488 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 700X Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) |
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");