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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23657 | 23657 | 196979 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1551 20th St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013315.21298 | 2104723.80911 | 37.7599198521353 | -122.39701407983802 | (37.7599198521353, -122.397014079838) | |||
32983 | 32983 | 196995 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 8 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6013853.97089 | 2100136.72086 | 37.7473546683845 | -122.394829506973 | (37.7473546683845, -122.394829506973) | |||
38113 | 38113 | 196990 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6014143.12746 | 2100151.41021 | 37.7474110756645 | -122.39383064437901 | (37.7474110756645, -122.393830644379) | |||
39431 | 39431 | 241273 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 55 Haight St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005874.88911 | 2109629.37494 | 37.7729723901943 | -122.423095264536 | (37.7729723901943, -122.423095264536) | |||
40771 | 40771 | 241272 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 67 Webster St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6004275.92505 | 2108860.93687 | 37.770772085482605 | -122.428571490982 | (37.7707720854826, -122.428571490982) | |||
51103 | 51103 | 196994 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 7 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6013884.28274 | 2100137.93009 | 37.7473596740254 | -122.39472477462401 | (37.7473596740254, -122.394724774624) | |||
69932 | 69932 | 197000 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 15 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6013614.06576 | 2100123.51682 | 37.7473050707808 | -122.39565816299401 | (37.7473050707808, -122.395658162994) | |||
70562 | 70562 | 197002 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2251 Silver Ave | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012830.37736 | 2096288.90355 | 37.736732407869205 | -122.398099143384 | (37.7367324078692, -122.398099143384) | |||
73978 | 73978 | 196978 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1551 20th St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6013296.03231 | 2104723.49575 | 37.7599179239891 | -122.397080394946 | (37.7599179239891, -122.397080394946) | |||
75172 | 75172 | 196997 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 11 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6013762.67186 | 2100131.60985 | 37.747335557807496 | -122.395144856947 | (37.7473355578075, -122.395144856947) | |||
130649 | 130649 | 197001 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 16 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6013598.90827 | 2100122.82985 | 37.7473023413409 | -122.395710528743 | (37.7473023413409, -122.395710528743) | |||
134526 | 134526 | 196998 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 13 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013702.500030001 | 2100126.86267 | 37.7473191766464 | -122.39535259585101 | (37.7473191766464, -122.395352595851) | |||
134822 | 134822 | 246838 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 399 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001188.47767 | 2109990.61312 | 37.7736986862745 | -122.43933199347201 | (37.7736986862745, -122.439331993472) | |||
135846 | 135846 | 201661 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 149 Dore St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6009207.44548 | 2109499.9434599997 | 37.772804497555704 | -122.411558355748 | (37.7728044975557, -122.411558355748) | |||
152365 | 152365 | 196991 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6014086.846369999 | 2100149.18925 | 37.7474018495283 | -122.394025106589 | (37.7474018495283, -122.394025106589) | |||
152370 | 152370 | 196996 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 10 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6013793.66265 | 2100133.46781 | 37.7473423827584 | -122.395037822335 | (37.7473423827584, -122.395037822335) | |||
161791 | 161791 | 246445 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 457 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6003558.45361 | 2099788.20108 | 37.7458198862793 | -122.43040580490101 | (37.7458198862793, -122.430405804901) | |||
173145 | 173145 | 196992 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6013942.24849 | 2100140.56785 | 37.747370139416205 | -122.394524516312 | (37.7473701394162, -122.394524516312) | |||
173275 | 173275 | 246856 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 425 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6001680.71036 | 2109929.19364 | 37.773558043107 | -122.43762488777901 | (37.773558043107, -122.437624887779) | |||
174204 | 174204 | 196999 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 14 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6013629.21679 | 2100123.8728 | 37.7473068910098 | -122.39560579639401 | (37.7473068910098, -122.395605796394) | |||
178824 | 178824 | 196980 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 320 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6013452.78538 | 2105563.26016 | 37.76223245789279 | -122.396597126255 | (37.7622324578928, -122.396597126255) | |||
187168 | 187168 | 196993 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 6 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6013912.096059999 | 2100139.0238799998 | 37.7473642236913 | -122.39462867398501 | (37.7473642236913, -122.394628673985) |
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");