Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27763 | 27763 | 187876 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 12 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015130.16483 | 2100787.65085 | 37.749212862006296 | -122.39046195666701 | (37.7492128620063, -122.390461956667) | |||
30483 | 30483 | 187888 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1799 Indiana St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6015216.20725 | 2100273.8122 | 37.747806741405 | -122.390128525805 | (37.747806741405, -122.390128525805) | |||
33887 | 33887 | 187873 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015126.80958 | 2100859.52415 | 37.7494100248665 | -122.390478580644 | (37.7494100248665, -122.390478580644) | |||
44777 | 44777 | 187875 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015128.62493 | 2100811.61735 | 37.7492785835592 | -122.390468956103 | (37.7492785835592, -122.390468956103) | |||
50858 | 50858 | 187901 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2240 Silver Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6012923.64855 | 2096289.98894 | 37.7367405826988 | -122.39777673821101 | (37.7367405826988, -122.397776738211) | |||
55799 | 55799 | 187878 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 14 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015135.58598 | 2100692.8078900003 | 37.7489527438721 | -122.39043658410401 | (37.7489527438721, -122.390436584104) | |||
59063 | 59063 | 187896 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 7 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6015200.4277800005 | 2100533.54912 | 37.748519049422704 | -122.390201234205 | (37.7485190494227, -122.390201234205) | |||
59265 | 59265 | 187867 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015121.61936 | 2100940.75662 | 37.74963278423721 | -122.390502204035 | (37.7496327842372, -122.390502204035) | |||
60719 | 60719 | 187894 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6015203.0238 | 2100485.5663 | 37.748387442638396 | -122.390188905397 | (37.7483874426384, -122.390188905397) | |||
64781 | 64781 | 220404 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1728 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6009447.09485 | 2106640.63695 | 37.7649669427944 | -122.41052743231899 | (37.7649669427944, -122.410527432319) | |||
65808 | 65808 | 187874 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 10 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015128.5311900005 | 2100832.02716 | 37.749334619411705 | -122.390470706171 | (37.7493346194117, -122.390470706171) | |||
66051 | 66051 | 220406 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1798 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009456.39848 | 2106458.4435400004 | 37.7644672030258 | -122.410482387068 | (37.7644672030258, -122.410482387068) | |||
66367 | 66367 | 187886 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1798 Indiana St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6015167.00373 | 2100296.44162 | 37.7478661479108 | -122.39030025137698 | (37.7478661479108, -122.390300251377) | |||
67284 | 67284 | 187895 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 6 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6015201.97274 | 2100509.17213 | 37.7484522010065 | -122.39019418890601 | (37.7484522010065, -122.390194188906) | |||
71615 | 71615 | 187880 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 16 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015140.70101 | 2100612.12131 | 37.7487314791912 | -122.39041325927099 | (37.7487314791912, -122.390413259271) | |||
73657 | 73657 | 187884 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 21 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015147.0673400005 | 2100472.1184400003 | 37.7483474138047 | -122.390381463732 | (37.7483474138047, -122.390381463732) | |||
73751 | 73751 | 187877 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015133.83892 | 2100719.04605 | 37.749024691439296 | -122.39044445856399 | (37.7490246914393, -122.390444458564) | |||
73989 | 73989 | 187879 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 15 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015136.98664 | 2100642.09831 | 37.74881358370121 | -122.390428197897 | (37.7488135837012, -122.390428197897) | |||
124105 | 124105 | 187892 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6015206.13934 | 2100438.08 | 37.74825722800529 | -122.39017481481501 | (37.7482572280053, -122.390174814815) | |||
129642 | 129642 | 187897 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 6ft | 6015199.38185 | 2100557.40869 | 37.7485845047902 | -122.39020651771999 | (37.7485845047902, -122.39020651772) | |||
132208 | 132208 | 187887 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1798 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6015168.3741 | 2100272.0996 | 37.7477993858291 | -122.39029381222299 | (37.7477993858291, -122.390293812223) | |||
133115 | 133115 | 187891 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6015208.193580001 | 2100413.69272 | 37.7481903795776 | -122.390166007757 | (37.7481903795776, -122.390166007757) | |||
147150 | 147150 | 187882 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 18 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015144.03762 | 2100560.1109700003 | 37.74858885479 | -122.390398087715 | (37.74858885479, -122.390398087715) | |||
148176 | 148176 | 187885 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 23 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015152.389769999 | 2100397.43257 | 37.748142637288 | -122.390357841268 | (37.748142637288, -122.390357841268) | |||
149627 | 149627 | 187893 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6015205.088280001 | 2100461.68616 | 37.7483219872815 | -122.390180098326 | (37.7483219872815, -122.390180098326) | |||
149677 | 149677 | 187890 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6015208.72001 | 2100389.3363099997 | 37.7481235311712 | -122.39016248603001 | (37.7481235311712, -122.39016248603) | |||
156616 | 156616 | 187883 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 20 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015144.844880001 | 2100499.87807 | 37.748423512649495 | -122.390391088302 | (37.7484235126495, -122.390391088302) | |||
157299 | 157299 | 187889 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1799 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6015203.04299 | 2100298.1861 | 37.747872936885706 | -122.390175750107 | (37.7478729368857, -122.390175750107) | |||
159444 | 159444 | 187870 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015123.316980001 | 2100924.59748 | 37.74958850880971 | -122.390495204594 | (37.7495885088097, -122.390495204594) | |||
159899 | 159899 | 187898 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 7 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6015180.25331 | 2100882.371 | 37.749475722127 | -122.390295365361 | (37.749475722127, -122.390295365361) | |||
171631 | 171631 | 187872 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015125.026930001 | 2100883.99929 | 37.7494771295685 | -122.390486455093 | (37.7494771295685, -122.390486455093) | |||
174445 | 174445 | 187881 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 17 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015141.96127 | 2100582.57644 | 37.748650425082005 | -122.39040683722601 | (37.748650425082, -122.390406837226) | |||
178281 | 178281 | 187871 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015124.4326599995 | 2100904.6710900003 | 37.7495338570216 | -122.39048995434601 | (37.7495338570216, -122.390489954346) | |||
178826 | 178826 | 187900 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 6ft | 6015174.133909999 | 2101026.33165 | 37.749870668392504 | -122.390326583523 | (37.7498706683925, -122.390326583523) | |||
181437 | 181437 | 220405 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1730 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6009447.51093 | 2106617.76818 | 37.7649041737225 | -122.410524378206 | (37.7649041737225, -122.410524378206) | |||
183183 | 183183 | 187866 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015120.62012 | 2100986.30773 | 37.7497578025782 | -122.390508841934 | (37.7497578025782, -122.390508841934) | |||
186986 | 186986 | 187899 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 8 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6015181.09261 | 2100903.60273 | 37.7495340665546 | -122.39029394621201 | (37.7495340665546, -122.390293946212) |
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");