Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26378 | 26378 | 118551 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 8140 Geary Blvd | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 5981667.59483 | 2112398.2493 | 37.7791791285325 | -122.50703522193999 | (37.7791791285325, -122.50703522194) | ||||
29143 | 29143 | 248220 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 70 Fair Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007112.652530001 | 2099342.90806 | 37.7447979012027 | -122.41808429785499 | (37.7447979012027, -122.418084297855) | ||||
30481 | 30481 | 247913 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Franconia St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009968.0552900005 | 2098803.93583 | 37.743478301698296 | -122.40817280665001 | (37.7434783016983, -122.40817280665) | ||||
35294 | 35294 | 177823 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009246.7312 | 2086449.12039 | 37.7095141743011 | -122.409795064007 | (37.7095141743011, -122.409795064007) | |||
40576 | 40576 | 177849 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 104 Woolsey St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6011561.92381 | 2092191.20992 | 37.7254102643617 | -122.40219675676799 | (37.7254102643617, -122.402196756768) | ||||
45261 | 45261 | 177822 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 15 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | Width 3ft | 6009243.51838 | 2086439.4286099998 | 37.7094873825954 | -122.40980548443899 | (37.7094873825954, -122.409805484439) | |||
48879 | 48879 | 177820 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009221.96633 | 2086380.57337 | 37.7093245702546 | -122.409875820418 | (37.7093245702546, -122.409875820418) | |||
52499 | 52499 | 248193 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 216 Esmeralda Ave | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6007342.31013 | 2098763.52222 | 37.74321996062879 | -122.417249134357 | (37.7432199606288, -122.417249134357) | ||||
52509 | 52509 | 177834 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6005075.62014 | 2092583.76802 | 37.7261239546294 | -122.424647248878 | (37.7261239546294, -122.424647248878) | ||||
56892 | 56892 | 248221 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 70 Fair Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6007127.43713 | 2099336.46972 | 37.744781055094705 | -122.418032719051 | (37.7447810550947, -122.418032719051) | ||||
65111 | 65111 | 248192 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 216 Esmeralda Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6007348.90224 | 2098760.26711 | 37.7432113936915 | -122.41722610990101 | (37.7432113936915, -122.417226109901) | ||||
65623 | 65623 | 177843 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 51 | 6005078.05129 | 2092608.48476 | 37.726191958666796 | -122.424640601997 | (37.7261919586668, -122.424640601997) | ||||
70150 | 70150 | 248180 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 218 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6007468.18996 | 2098662.76578 | 37.7429503870626 | -122.416806737143 | (37.7429503870626, -122.416806737143) | ||||
119320 | 119320 | 177821 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6009239.86768 | 2086426.74333 | 37.7094523468075 | -122.40981720709101 | (37.7094523468075, -122.409817207091) | |||
130946 | 130946 | 177832 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6005040.015980001 | 2092604.7564 | 37.7261795732245 | -122.424771822965 | (37.7261795732245, -122.424771822965) | ||||
134143 | 134143 | 247904 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 582 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009836.26109 | 2098719.48806 | 37.743239046039 | -122.408622563902 | (37.743239046039, -122.408622563902) | ||||
153822 | 153822 | 177840 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 655 Peru Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6005146.609019999 | 2092568.42927 | 37.7260858467747 | -122.424400753697 | (37.7260858467747, -122.424400753697) | ||||
154289 | 154289 | 177842 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6005092.77094 | 2092617.82642 | 37.726218440119 | -122.42459038114599 | (37.726218440119, -122.424590381146) | ||||
164474 | 164474 | 177818 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009189.876619999 | 2086285.53025 | 37.7090618027185 | -122.409980023068 | (37.7090618027185, -122.409980023068) | |||
165962 | 165962 | 210573 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 300 Melrose Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5998016.4865 | 2095547.09873 | 37.7338593545253 | -122.449263553965 | (37.7338593545253, -122.449263553965) | ||||
168100 | 168100 | 177841 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6005100.14116 | 2092616.6598200002 | 37.726215653124704 | -122.424564819721 | (37.7262156531247, -122.424564819721) | ||||
168635 | 168635 | 177817 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009184.18934 | 2086265.3806200002 | 37.7090061571804 | -122.409998257729 | (37.7090061571804, -122.409998257729) | |||
172858 | 172858 | 187572 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 73 Bishop St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010864.17104 | 2089487.4487 | 37.7179473203875 | -122.404418609237 | (37.7179473203875, -122.404418609237) | ||||
175058 | 175058 | 177833 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6005045.58694 | 2092601.1582099998 | 37.726170008036 | -122.42475230858601 | (37.726170008036, -122.424752308586) | ||||
182180 | 182180 | 210572 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 300 Melrose Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998021.954 | 2095543.6754599998 | 37.7338502677764 | -122.449244404708 | (37.7338502677764, -122.449244404708) | ||||
182795 | 182795 | 177819 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009193.28856 | 2086304.97531 | 37.709115386123 | -122.40996960262501 | (37.709115386123, -122.409969602625) | |||
188202 | 188202 | 248243 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 296 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6006794.0541900005 | 2099005.53684 | 37.743853618456995 | -122.41916202653299 | (37.743853618457, -122.419162026533) | ||||
189026 | 189026 | 248177 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 218 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6007380.96811 | 2098703.14115 | 37.743056342490796 | -122.417111187331 | (37.7430563424908, -122.417111187331) |
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");