Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, PlantDate, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1687 | 1687 | 18887 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2407 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003191.46268 | 2115855.10762 | 37.789914898090004 | -122.432822394747 | (37.78991489809, -122.432822394747) | |||
3267 | 3267 | 2831 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1200 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6008484.02773 | 2116302.9533599997 | 37.791443325609606 | -122.414542237062 | (37.7914433256096, -122.414542237062) | |||
6574 | 6574 | 2832 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1200 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6008465.75544 | 2116301.4842 | 37.7914382651038 | -122.414605355047 | (37.7914382651038, -122.414605355047) | |||
8703 | 8703 | 2829 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1200 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6008547.0936900005 | 2116310.73962 | 37.7914682476113 | -122.414324580422 | (37.7914682476113, -122.414324580422) | |||
10811 | 10811 | 823 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1381 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5981813.5224 | 2105689.4462 | 37.760767297588295 | -122.50603285620599 | (37.7607672975883, -122.506032856206) | |||
11806 | 11806 | 15748 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 4617 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002094.7066 | 2092005.3194 | 37.7243668615839 | -122.43491072988998 | (37.7243668615839, -122.43491072989) | |||
12649 | 12649 | 24533 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1395 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5981505.7764 | 2105644.9273 | 37.7606269413357 | -122.507093890918 | (37.7606269413357, -122.507093890918) | |||
13014 | 13014 | 24510 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1400 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5981246.2202 | 2105482.1578 | 37.7601647328681 | -122.507979481979 | (37.7601647328681, -122.507979481979) | |||
14337 | 14337 | 19746 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | ||||||||
16910 | 16910 | 7017 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1055 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002366.0432 | 2110180.0215 | 37.774285696400206 | -122.435272167554 | (37.7742856964002, -122.435272167554) | |||
17169 | 17169 | 29607 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991176.48666 | 2091034.59302 | 37.7210755258009 | -122.472582381082 | (37.7210755258009, -122.472582381082) | ||
17876 | 17876 | 4225 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3982 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004042.0862300005 | 2100445.7636700002 | 37.747652784654704 | -122.428780340555 | (37.7476527846547, -122.428780340555) | |||
18962 | 18962 | 29617 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991168.23882 | 2090896.94142 | 37.7206970910675 | -122.472600860348 | (37.7206970910675, -122.472600860348) | ||
20221 | 20221 | 4226 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3982 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004028.819080001 | 2100444.38934 | 37.7476482601598 | -122.42882611964501 | (37.7476482601598, -122.428826119645) | |||
20519 | 20519 | 29614 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991166.98096 | 2090921.81223 | 37.720765307364395 | -122.47260702069599 | (37.7207653073644, -122.472607020696) | ||
20958 | 20958 | 3909 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1000X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002142.832230001 | 2107666.80115 | 37.7673723370035 | -122.43586443430901 | (37.7673723370035, -122.435864434309) | |||
22423 | 22423 | 18155 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1355 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005677.61973 | 2114458.9667 | 37.7862221342749 | -122.42412117337099 | (37.7862221342749, -122.424121173371) | |||
22671 | 22671 | 18156 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1355 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005730.74632 | 2114465.38856 | 37.786242766547105 | -122.42393782586399 | (37.7862427665471, -122.423937825864) | |||
23093 | 23093 | 26475 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 106 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6001338.90016 | 2098832.9571 | 37.7430710337942 | -122.438012277952 | (37.7430710337942, -122.438012277952) | |||
23165 | 23165 | 25259 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1630 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5994884.3509 | 2092299.7091 | 37.724763157858796 | -122.45985706395399 | (37.7247631578588, -122.459857063954) | |||
69884 | 69884 | 6036 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1826 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001703.73225 | 2112585.2403700002 | 37.7808521880762 | -122.43773551469499 | (37.7808521880762, -122.437735514695) | |||
81459 | 81459 | 25185 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3638 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 3X3 | 6000425.6878797 | 2103367.625274 | 37.7554701662116 | -122.441495243201 | (37.7554701662116, -122.441495243201) | |||
83716 | 83716 | 15788 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 4840 Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001135.36791 | 2090627.3686 | 37.7205288045244 | -122.438128360054 | (37.7205288045244, -122.438128360054) | |||
87683 | 87683 | 24704 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 7040 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5985122.8914 | 2112550.40448 | 37.7797997921083 | -122.49509333148701 | (37.7797997921083, -122.495093331487) | |||
88219 | 88219 | 2210 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1145 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000813.81573 | 2112576.3555400004 | 37.7807771513392 | -122.44081352531 | (37.7807771513392, -122.44081352531) | |||
88268 | 88268 | 16577 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
88353 | 88353 | 16576 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
89335 | 89335 | 1457 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 160 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/1996 12:00:00 AM | 18 | 3X3 | 5995550.62433 | 2115045.99929 | 37.78725698253879 | -122.459200223243 | (37.7872569825388, -122.459200223243) | ||
89711 | 89711 | 1458 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 166 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5995549.24707 | 2115014.62054 | 37.7871707457756 | -122.45920271513799 | (37.7871707457756, -122.459202715138) | |||
90108 | 90108 | 18157 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1355 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005683.2980159 | 2114458.6818444002 | 37.7862216727319 | -122.42410150769899 | (37.7862216727319, -122.424101507699) | |||
92309 | 92309 | 5042 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 5399X Diamond Heights Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002053.1297196 | 2098277.9970185 | 37.741587834770705 | -122.435502976689 | (37.7415878347707, -122.435502976689) | |||
92712 | 92712 | 16571 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
94849 | 94849 | 16581 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
105214 | 105214 | 16574 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
107168 | 107168 | 1459 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 170 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | 3X3 | 5995550.04473 | 2115004.5648 | 37.7871431812831 | -122.45919922698299 | (37.7871431812831, -122.459199226983) | ||
109368 | 109368 | 16575 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
109611 | 109611 | 1678 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 315 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2000 12:00:00 AM | 3 | 3X3 | 5994577.07747 | 2111415.6823400003 | 37.7772330921215 | -122.46230506404801 | (37.7772330921215, -122.462305064048) | ||
110475 | 110475 | 15781 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 4840 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 12 | 3X3 | 6001135.36791 | 2090627.3686 | 37.7205288045244 | -122.438128360054 | (37.7205288045244, -122.438128360054) | ||
110532 | 110532 | 16573 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
113804 | 113804 | 2665 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2031 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1991 12:00:00 AM | 12 | 3X3 | 6003805.33763 | 2114874.02287 | 37.787255885128396 | -122.430628406293 | (37.7872558851284, -122.430628406293) | ||
117072 | 117072 | 1782 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2001X Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6012442.836211099 | 2088493.8744970001 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | |||
122129 | 122129 | 16579 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
124560 | 124560 | 16578 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
124877 | 124877 | 16572 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
138760 | 138760 | 25260 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1630 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5995011.81264 | 2092264.9607400002 | 37.7246750767236 | -122.45941393184799 | (37.7246750767236, -122.459413931848) | |||
144084 | 144084 | 833 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1400 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5981556.8759975 | 2105533.8452968 | 37.760324951376504 | -122.50690892383801 | (37.7603249513765, -122.506908923838) |
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");