Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
208 | 208 | 100305 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3701 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003064.411830001 | 2121045.8637900003 | 37.804160163827206 | -122.433633107497 | (37.8041601638272, -122.433633107497) | |||
3364 | 3364 | 188226 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 3 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 6 | Width 3ft | Permit Number 37286 | 6013575.41694 | 2105253.06849 | 37.7613875637091 | -122.396151246903 | (37.7613875637091, -122.396151246903) | |
3371 | 3371 | 188225 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 2 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 6 | Width 3ft | Permit Number 37286 | 6013591.2999599995 | 2105254.0413599997 | 37.7613911187249 | -122.396096381957 | (37.7613911187249, -122.396096381957) | |
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) | |||
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) | |||
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) | |||
22355 | 22355 | 204264 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 12th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992423.56649 | 2104856.18392 | 37.7590982216204 | -122.469277127955 | (37.7590982216204, -122.469277127955) | |||
24322 | 24322 | 125703 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 23 Pleasant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008909.16091 | 2116830.53076 | 37.7929157990679 | -122.4131085999 | (37.7929157990679, -122.4131085999) | |||
26801 | 26801 | 221170 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 82 Hancock St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6003717.37028 | 2105106.00276 | 37.7604303181269 | -122.430235612701 | (37.7604303181269, -122.430235612701) | |||
27666 | 27666 | 183543 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2581 25th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5988605.1751 | 2097774.8752 | 37.7394334392266 | -122.481964049119 | (37.7394334392266, -122.481964049119) | |||
32074 | 32074 | 204315 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 140 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992371.69102 | 2098164.25102 | 37.740720902060204 | -122.468969536415 | (37.7407209020602, -122.468969536415) | |||
32639 | 32639 | 205566 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 7 Locksley Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994170.44899 | 2104994.66764 | 37.759579252803505 | -122.463245671761 | (37.7595792528035, -122.463245671761) | |||
33477 | 33477 | 221124 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 355 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007210.69865 | 2096548.51088 | 37.737130625862704 | -122.41754726049801 | (37.7371306258627, -122.417547260498) | |||
39607 | 39607 | 181953 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2213 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5986306.2848 | 2098879.0935 | 37.7423313601889 | -122.48999368848601 | (37.7423313601889, -122.489993688486) | |||
45789 | 45789 | 221177 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 60 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006666.2522599995 | 2109537.2409599996 | 37.772764037951 | -122.42035129716999 | (37.772764037951, -122.42035129717) | |||
52394 | 52394 | 204288 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5992460.26987 | 2103777.38754 | 37.7561382497077 | -122.46907167872801 | (37.7561382497077, -122.469071678728) | |||
56258 | 56258 | 205603 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 845 Detroit St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999427.00683 | 2095718.88382 | 37.7344116156036 | -122.44439931797501 | (37.7344116156036, -122.444399317975) | |||
57759 | 57759 | 52679 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 6 | Permit Number 48754 | 5984569.7272 | 2111052.9985 | 37.77565594760279 | -122.49689639188101 | (37.7756559476028, -122.496896391881) | ||
62837 | 62837 | 125708 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 987 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008267.41837 | 2119270.58084 | 37.7995795254212 | -122.41550189821001 | (37.7995795254212, -122.41550189821) | |||
73672 | 73672 | 204263 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 12th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992422.38407 | 2104872.65232 | 37.7591433711999 | -122.469282415954 | (37.7591433711999, -122.469282415954) | |||
75084 | 75084 | 125704 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 23 Pleasant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008924.73472 | 2116833.00784 | 37.792923474790896 | -122.413054888768 | (37.7929234747909, -122.413054888768) | |||
116425 | 116425 | 204265 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 12th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992424.423769999 | 2104838.80888 | 37.7590505638561 | -122.46927289844999 | (37.7590505638561, -122.46927289845) | |||
131099 | 131099 | 221146 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 563 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996904.68088 | 2107337.8973 | 37.766170302241704 | -122.45395861580099 | (37.7661703022417, -122.453958615801) | |||
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) | |||
135115 | 135115 | 34652 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1921 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 6 | Permit Number 38331 | 5988873.4566 | 2105098.7324 | 37.7595584078301 | -122.481572717376 | (37.7595584078301, -122.481572717376) | |
136087 | 136087 | 183538 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1408 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5988570.9251 | 2097656.2977 | 37.7391058643676 | -122.482073784664 | (37.7391058643676, -122.482073784664) | |||
137556 | 137556 | 204229 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 243 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5994968.46955 | 2106663.402 | 37.76420710740771 | -122.460606664293 | (37.7642071074077, -122.460606664293) | |||
147936 | 147936 | 204225 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1755 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993401.713269999 | 2103536.7053900003 | 37.75553175049821 | -122.46579838928001 | (37.7555317504982, -122.46579838928) | |||
150533 | 150533 | 205588 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1943 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993444.46485 | 2102246.46663 | 37.7519915530764 | -122.465556813412 | (37.7519915530764, -122.465556813412) | |||
154225 | 154225 | 52681 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 6 | Permit Number 48754 | 5984542.32395 | 2111051.13386 | 37.7756492220711 | -122.49699104738 | (37.7756492220711, -122.49699104738) | ||
156387 | 156387 | 221165 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1511 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002609.85714 | 2101016.35214 | 37.7491383207878 | -122.433773677812 | (37.7491383207878, -122.433773677812) | |||
158546 | 158546 | 204256 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Rossmoor Dr | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5991070.06293 | 2094489.8143 | 37.7305565412538 | -122.473202115591 | (37.7305565412538, -122.473202115591) | |||
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) | |||
160448 | 160448 | 32341 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 120 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2005 12:00:00 AM | 6 | Permit Number 47986 | 6010882.28946 | 2093426.3819099998 | 37.728763829978796 | -122.404633115548 | (37.7287638299788, -122.404633115548) | ||
162854 | 162854 | 137857 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1845 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004358.4918 | 2115232.5475 | 37.7882716253172 | -122.428740178583 | (37.7882716253172, -122.428740178583) | |||
164287 | 164287 | 221134 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2820 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008816.36555 | 2106342.1549299997 | 37.7641119995907 | -122.412687871844 | (37.7641119995907, -122.412687871844) | |||
170079 | 170079 | 204308 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992611.27218 | 2098826.2702099998 | 37.7425524784048 | -122.46818930979299 | (37.7425524784048, -122.468189309793) | |||
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) | |||
179197 | 179197 | 204323 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 240 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992369.60469 | 2095177.2479599998 | 37.73251922258721 | -122.468759450295 | (37.7325192225872, -122.468759450295) | |||
180730 | 180730 | 52680 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 6 | Permit Number 48754 | 5984555.73131 | 2111052.6848299997 | 37.7756542662383 | -122.496944783224 | (37.7756542662383, -122.496944783224) |
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");