Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
824 | 824 | 175557 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 80X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 3 | Width 3ft | 5991341.18573 | 2088991.3817 | 37.71547490063521 | -122.471864234655 | (37.7154749006352, -122.471864234655) | ||
6505 | 6505 | 20152 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1057 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1997 12:00:00 AM | 12 | 3X3 | 6002876.4729 | 2111952.9425 | 37.7791826693541 | -122.433633233262 | (37.7791826693541, -122.433633233262) | ||
10430 | 10430 | 86483 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1706 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987833.1754 | 2103641.2255 | 37.7554959453769 | -122.48506354557101 | (37.7554959453769, -122.485063545571) | ||
10488 | 10488 | 86479 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1750 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987839.9732 | 2103389.1385 | 37.7548041785464 | -122.485021542908 | (37.7548041785464, -122.485021542908) | ||
10877 | 10877 | 86480 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1742 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987841.1062 | 2103418.0293 | 37.754883570877105 | -122.485019744249 | (37.7548835708771, -122.485019744249) | ||
10966 | 10966 | 86558 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1867 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 7 | 3x3 | 5987816.4554 | 2102586.0208 | 37.7525976639013 | -122.48504395302 | (37.7525976639013, -122.48504395302) | ||
11268 | 11268 | 86482 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1722 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987834.8749 | 2103544.3561 | 37.7552300671815 | -122.48505056143499 | (37.7552300671815, -122.485050561435) | ||
11450 | 11450 | 86561 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1891 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987822.6937 | 2102437.7427 | 37.7521908954775 | -122.485011502397 | (37.7521908954775, -122.485011502397) | ||
11831 | 11831 | 86477 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1754 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987839.9732 | 2103364.7795 | 37.754737295309 | -122.485019755857 | (37.754737295309, -122.485019755857) | ||
15921 | 15921 | 29468 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1613 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/05/2015 07:24:00 AM | 3 | 3X3 | 6016802.5034 | 2093317.3698 | 37.7287936059494 | -122.384158766122 | (37.7287936059494, -122.384158766122) | ||
18354 | 18354 | 29366 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/25/2012 12:00:00 AM | 3 | 3X3 | 5992064.02141 | 2096527.0918599998 | 37.7362078962607 | -122.46991416090599 | (37.7362078962607, -122.469914160906) | ||
18576 | 18576 | 29362 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5991983.966469999 | 2096447.7248099998 | 37.7359853464519 | -122.470185163514 | (37.7359853464519, -122.470185163514) | ||
19218 | 19218 | 29363 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5992002.78104 | 2096471.37185 | 37.736051362971004 | -122.470121835975 | (37.736051362971, -122.470121835975) | ||
19222 | 19222 | 29357 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991847.829940001 | 2096308.81938 | 37.7355960757897 | -122.470645723443 | (37.7355960757897, -122.470645723443) | ||
19378 | 19378 | 27278 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 223X Duboce Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005367.959369999 | 2108416.37045 | 37.7696131525447 | -122.424762488 | (37.7696131525447, -122.424762488) | |||
19384 | 19384 | 27275 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 223X Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005306.02285 | 2108414.57657 | 37.7696047286145 | -122.424976596817 | (37.7696047286145, -122.424976596817) | |||
20563 | 20563 | 29361 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991939.73246 | 2096403.05712 | 37.735860142840096 | -122.470334844889 | (37.7358601428401, -122.470334844889) | ||
20784 | 20784 | 27276 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 223X Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005326.21516 | 2108415.83453 | 37.7696093232375 | -122.424906841772 | (37.7696093232375, -122.424906841772) | |||
20795 | 20795 | 29365 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992050.3612 | 2096514.70328 | 37.7361730907045 | -122.46996048768601 | (37.7361730907045, -122.469960487686) | ||
20927 | 20927 | 27318 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 326 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5993116.17703 | 2089857.5003900002 | 37.7179555995549 | -122.465792014904 | (37.7179555995549, -122.465792014904) | |||
20965 | 20965 | 29364 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992027.40322 | 2096494.06765 | 37.7361151033221 | -122.470038359996 | (37.7361151033221, -122.470038359996) | ||
21608 | 21608 | 19327 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 230 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5993348.8476 | 2089853.7551099998 | 37.717958734599705 | -122.46498750927601 | (37.7179587345997, -122.464987509276) | |||
21756 | 21756 | 29359 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991917.55406 | 2096377.82265 | 37.735789573027205 | -122.470409686474 | (37.7357895730272, -122.470409686474) | ||
22089 | 22089 | 29358 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991885.18 | 2096342.85411 | 37.735691686328295 | -122.470519069219 | (37.7356916863283, -122.470519069219) | ||
22144 | 22144 | 2049 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 701X Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001977.73953 | 2095412.31759 | 37.733715061000204 | -122.43555868909901 | (37.7337150610002, -122.435558689099) | |||
22167 | 22167 | 29360 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991958.47705 | 2096423.3893400002 | 37.73591705373521 | -122.470271518219 | (37.7359170537352, -122.470271518219) | ||
22191 | 22191 | 29356 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991811.277419999 | 2096273.10994 | 37.7354959129041 | -122.47076949802201 | (37.7354959129041, -122.470769498022) | ||
35434 | 35434 | 205594 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 600x Laguna Honda Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5995579.6801 | 2099892.46812 | 37.745650984616105 | -122.458002636835 | (37.7456509846161, -122.458002636835) | |||
51488 | 51488 | 205597 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 600x Laguna Honda Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5995496.70265 | 2099913.2188 | 37.7457031929561 | -122.45829106020001 | (37.7457031929561, -122.4582910602) | |||
51853 | 51853 | 204330 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600x Portola Dr | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5992106.1404800005 | 2096570.57144 | 37.73632971483521 | -122.46977170381099 | (37.7363297148352, -122.469771703811) | |||
61067 | 61067 | 221140 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 500x 27th St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 6002645.49983 | 2100054.48713 | 37.7464992881251 | -122.433581693237 | (37.7464992881251, -122.433581693237) | |||
64046 | 64046 | 221142 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 500x 27th St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 6002785.01882 | 2100065.1809099996 | 37.746536565911704 | -122.43310001635099 | (37.7465365659117, -122.433100016351) | |||
68629 | 68629 | 205598 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 600x Laguna Honda Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 5995474.65556 | 2099916.18224 | 37.745710062887 | -122.458367509749 | (37.745710062887, -122.458367509749) | |||
69083 | 69083 | 204328 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600x Portola Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5992078.39374 | 2096541.4666900001 | 37.7362481967035 | -122.469865516581 | (37.7362481967035, -122.469865516581) | |||
126856 | 126856 | 98969 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 825 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
131052 | 131052 | 204331 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600x Portola Dr | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5992122.89854 | 2096586.89794 | 37.7363755119059 | -122.46971495297899 | (37.7363755119059, -122.469714952979) | |||
134823 | 134823 | 204329 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600x Portola Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 5992093.44259 | 2096556.1613599998 | 37.736289414430296 | -122.469814556494 | (37.7362894144303, -122.469814556494) | |||
138893 | 138893 | 23604 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 200X Vasquez Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
144108 | 144108 | 86351 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 2423 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/2015 10:30:00 AM | 3 | 3x3 | 5988571.076426 | 2098824.756846 | 37.7423141562535 | -122.482158841615 | (37.7423141562535, -122.482158841615) | ||
156456 | 156456 | 205596 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 600x Laguna Honda Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5995525.67673 | 2099905.10703 | 37.745682584978205 | -122.458190285765 | (37.7456825849782, -122.458190285765) | |||
159052 | 159052 | 221141 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 500x 27th St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 4ft | 6002659.15171 | 2100055.38577 | 37.7465025301635 | -122.43353455080201 | (37.7465025301635, -122.433534550802) | |||
174036 | 174036 | 205595 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 600x Laguna Honda Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 5995550.17234 | 2099899.0902400003 | 37.74566747188229 | -122.458105148758 | (37.7456674718823, -122.458105148758) |
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");