Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7036 | 7036 | 16366 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 1306X Montgomery St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 8 | 6011454.042780001 | 2119896.37482 | 37.8014764015683 | -122.40451904281299 | (37.8014764015683, -122.404519042813) | |||
48830 | 48830 | 215419 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Minerva St | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5996348.606369999 | 2088999.95907 | 37.7157869222005 | -122.454557070559 | (37.7157869222005, -122.454557070559) | |||
48849 | 48849 | 198000 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 828x Jamestown Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 6014844.30096 | 2089001.4675099999 | 37.7168345316683 | -122.390626989449 | (37.7168345316683, -122.390626989449) | |||
55123 | 55123 | 198002 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 860x Jamestown Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 6014610.54339 | 2089241.6149400002 | 37.717480958049 | -122.39145176041 | (37.717480958049, -122.39145176041) | |||
55655 | 55655 | 198001 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 860x Jamestown Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 5ft | 6014795.93259 | 2089063.22643 | 37.7170014260431 | -122.390798490171 | (37.7170014260431, -122.390798490171) | |||
78446 | 78446 | 16228 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 564X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998342.280841901 | 2094738.2735002 | 37.731657141982204 | -122.44807897208 | (37.7316571419822, -122.44807897208) | ||
78727 | 78727 | 16285 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 700X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | G | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096626998 | (37.7316223027997, -122.45117096627) | ||
78838 | 78838 | 16202 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 500X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998782.1299536 | 2094714.7967047 | 37.7316178141427 | -122.446556643647 | (37.7316178141427, -122.446556643647) | ||
80434 | 80434 | 30020 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 710X San Jose Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005718.76576524 | 2099005.5772577 | 37.7437931149581 | -122.42288013057501 | (37.7437931149581, -122.422880130575) | ||
82547 | 82547 | 30021 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 710X San Jose Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005718.76576524 | 2099005.5772577 | 37.7437931149581 | -122.42288013057501 | (37.7437931149581, -122.422880130575) | ||
83323 | 83323 | 30003 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 610X San Jose Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6006030.83928578 | 2099887.5672939997 | 37.74623246341729 | -122.42186369026399 | (37.7462324634173, -122.421863690264) | ||
87474 | 87474 | 16273 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 692X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 3X3 | 5997509.7184819 | 2094751.8939266002 | 37.7316469123248 | -122.450958273614 | (37.7316469123248, -122.450958273614) | ||
87736 | 87736 | 16286 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 700X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096626998 | (37.7316223027997, -122.45117096627) | ||
96559 | 96559 | 16227 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 564X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998342.280841901 | 2094738.2735002 | 37.731657141982204 | -122.44807897208 | (37.7316571419822, -122.44807897208) | ||
97974 | 97974 | 16284 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 700X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | G | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096626998 | (37.7316223027997, -122.45117096627) | ||
109605 | 109605 | 16314 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 758X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.45247618016899 | (37.7316364140758, -122.452476180169) | ||
110655 | 110655 | 28415 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 692X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 3X3 | 5997509.7184819 | 2094751.8939266002 | 37.7316469123248 | -122.450958273614 | (37.7316469123248, -122.450958273614) | ||
111546 | 111546 | 28414 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 600X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998107.3609693 | 2094732.8027768002 | 37.7316286888145 | -122.448890739326 | (37.7316286888145, -122.448890739326) | ||
118733 | 118733 | 16313 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 758X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.45247618016899 | (37.7316364140758, -122.452476180169) | ||
132906 | 132906 | 198004 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 920x Jamestown Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 5ft | 6014389.315880001 | 2089371.37328 | 37.7178249676301 | -122.39222551819401 | (37.7178249676301, -122.392225518194) | |||
138600 | 138600 | 30004 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 610X San Jose Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6006030.83928578 | 2099887.5672939997 | 37.74623246341729 | -122.42186369026399 | (37.7462324634173, -122.421863690264) | ||
139874 | 139874 | 16201 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 500X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998782.1299536 | 2094714.7967047 | 37.7316178141427 | -122.446556643647 | (37.7316178141427, -122.446556643647) | ||
144031 | 144031 | 16312 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 758X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.45247618016899 | (37.7316364140758, -122.452476180169) | ||
178207 | 178207 | 198003 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 920x Jamestown Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 6014527.01214 | 2089285.60779 | 37.7175971171782 | -122.391743566112 | (37.7175971171782, -122.391743566112) |
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");