Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24810 | 24810 | 125700 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 900 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007433.50155 | 2114436.05545 | 37.786258207895706 | -122.418044641354 | (37.7862582078957, -122.418044641354) | |||
28253 | 28253 | 247297 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 251 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002733.6666 | 2109491.8212 | 37.7724169385487 | -122.43395128968099 | (37.7724169385487, -122.433951289681) | |||
32937 | 32937 | 40207 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 543 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 11 | Permit Number 41389 | 5982528.29213 | 2112062.1562099997 | 37.7783069675702 | -122.504032865431 | (37.7783069675702, -122.504032865431) | |
40423 | 40423 | 205523 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 141 Greenwood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5996002.48703 | 2093720.2917099998 | 37.7287279785 | -122.456094484996 | (37.7287279785, -122.456094484996) | |||
43264 | 43264 | 221106 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 9 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6009472.02471 | 2105439.84712 | 37.7616712458547 | -122.410356413623 | (37.7616712458547, -122.410356413623) | |||
43923 | 43923 | 205547 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 224 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5996070.70883 | 2094314.1494 | 37.730362484629005 | -122.45590155254 | (37.730362484629, -122.45590155254) | |||
44423 | 44423 | 38052 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2721 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 11 | Permit Number 40249 | 6000449.1918 | 2114423.1814 | 37.7858272875297 | -122.442207546183 | (37.7858272875297, -122.442207546183) | |
49732 | 49732 | 204271 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 347 Parnassus Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 5996376.07988 | 2106550.6126099997 | 37.7639782982901 | -122.455730018544 | (37.7639782982901, -122.455730018544) | |||
50526 | 50526 | 72443 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1069 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 11 | 6008813.774540001 | 2115937.32557 | 37.790457920444005 | -122.413375446746 | (37.790457920444, -122.413375446746) | ||
56659 | 56659 | 39383 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 442 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 11 | Permit Number 40924 | 6011035.938999999 | 2112201.64162 | 37.7803251294514 | -122.405423660089 | (37.7803251294514, -122.405423660089) | |
56691 | 56691 | 205562 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 20 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5996679.94493 | 2094606.7683599999 | 37.7312008937991 | -122.45381647346301 | (37.7312008937991, -122.453816473463) | |||
57560 | 57560 | 221158 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 160 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006960.355719999 | 2098557.64733 | 37.742633178187106 | -122.418555239545 | (37.7426331781871, -122.418555239545) | |||
58122 | 58122 | 125707 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 987 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008244.72432 | 2119269.3091700003 | 37.7995747581204 | -122.415580337966 | (37.7995747581204, -122.415580337966) | |||
74896 | 74896 | 183537 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1406 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5988583.1202 | 2097657.595 | 37.739110135695796 | -122.482031715061 | (37.7391101356958, -122.482031715061) | |||
108890 | 108890 | 68067 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 124 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 11 | Permit Number 31804 | 5993663.47634058 | 2103268.81441412 | 37.754811287000706 | -122.464873684633 | (37.7548112870007, -122.464873684633) | |
130136 | 130136 | 40664 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 37 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 11 | Permit Number 41655 | 6003638.4352 | 2093754.51209 | 37.7292572834764 | -122.429698976444 | (37.7292572834764, -122.429698976444) | |
138190 | 138190 | 205527 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1448 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995920.6034699995 | 2093687.8699299998 | 37.7286342556576 | -122.45637521646002 | (37.7286342556576, -122.45637521646) | |||
146788 | 146788 | 221099 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6009329.84306 | 2105433.4467700003 | 37.7616457005982 | -122.410847712362 | (37.7616457005982, -122.410847712362) | |||
147953 | 147953 | 33095 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1127 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 11 | Permit Number 37338 | 6011115.1734 | 2118807.4721 | 37.798467596260096 | -122.405614950876 | (37.7984675962601, -122.405614950876) | |
152385 | 152385 | 221153 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 445 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007892.34512 | 2096862.23202 | 37.7380303670096 | -122.415212693326 | (37.7380303670096, -122.415212693326) | |||
156838 | 156838 | 204236 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1330 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5993657.9849 | 2106425.1721 | 37.7634775090049 | -122.46512191475 | (37.7634775090049, -122.46512191475) | |||
157656 | 157656 | 205526 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 141 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995945.00881 | 2093703.6137400002 | 37.7286788854057 | -122.456291984186 | (37.7286788854057, -122.456291984186) | |||
158369 | 158369 | 175548 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 127 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 1ft | 5999115.8036400005 | 2089145.41882 | 37.7163446448588 | -122.44500284583 | (37.7163446448588, -122.44500284583) | |||
162449 | 162449 | 204304 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2554 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5990533.67464 | 2098000.2477599997 | 37.740164224398896 | -122.475312663464 | (37.7401642243989, -122.475312663464) | |||
164438 | 164438 | 205525 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 141 Greenwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995964.76572 | 2093711.7341900002 | 37.7287023163446 | -122.45622427066002 | (37.7287023163446, -122.45622427066) | |||
171437 | 171437 | 204355 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1234 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995887.801469999 | 2092235.32572 | 37.72464403389029 | -122.456383625117 | (37.7246440338903, -122.456383625117) | |||
173571 | 173571 | 204337 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 519 Wildwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994945.578980001 | 2093310.0260299998 | 37.7275407654953 | -122.45971855316999 | (37.7275407654953, -122.45971855317) | |||
174745 | 174745 | 221101 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6009367.670080001 | 2105435.00012 | 37.7616520866991 | -122.410716993221 | (37.7616520866991, -122.410716993221) | |||
174918 | 174918 | 221168 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 223 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003681.32414 | 2101551.82693 | 37.750669350924504 | -122.43010672724701 | (37.7506693509245, -122.430106727247) | |||
176817 | 176817 | 221151 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1103 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997674.15869 | 2106717.9873 | 37.764512276151294 | -122.451252443353 | (37.7645122761513, -122.451252443353) | |||
177639 | 177639 | 33154 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2326 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 11 | Permit Number 37377 | 5986110.8462 | 2099395.3559 | 37.7437374639566 | -122.490707423066 | (37.7437374639566, -122.490707423066) | |
179615 | 179615 | 185804 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2616 Pacheco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5986840.2263 | 2101683.0761 | 37.7500615094832 | -122.48835352551201 | (37.7500615094832, -122.488353525512) | |||
185444 | 185444 | 34477 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1818 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 11 | Permit Number 46532 | 6008722.614159999 | 2119125.18072 | 37.7992058679054 | -122.413916459984 | (37.7992058679054, -122.413916459984) |
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");