Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Longitude, Location
Latitude ✖
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2500 | 2500 | 22606 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 930 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2014 12:00:00 AM | 3 | 3X3 | Permit Number 773338 | 6005716.49366 | 2112844.2148599997 | 37.7817906187885 | -122.42387181652501 | (37.7817906187885, -122.423871816525) | |
19345 | 19345 | 562 | DPW Maintained 3 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 2946 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2016 07:44:00 AM | 3 | 3x3 | 6009264.69318 | 2102193.2743900004 | 37.752745265894106 | -122.410844191525 | (37.7527452658941, -122.410844191525) | ||
21965 | 21965 | 26186 | DPW Maintained 3 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 538 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/18/2015 12:00:00 AM | 2 | 3X6 | Permit Number 772904 | 6002328.19294 | 2105046.72262 | 37.7601887674112 | -122.435035888908 | (37.7601887674112, -122.435035888908) | |
48555 | 48555 | 105747 | Undocumented 2 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 428A Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 2 | 4x4 | Permit Number 771653 | 6002700.0 | 2110005.0 | 37.7738240899214 | -122.434104437093 | (37.7738240899214, -122.434104437093) | |
78056 | 78056 | 75714 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 40 Lomita Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2013 12:00:00 AM | Permit Number 769934 | 5991382.48989166 | 2104778.11125906 | 37.758823639987796 | -122.47287193809099 | (37.7588236399878, -122.472871938091) | |||
84404 | 84404 | 107316 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 1400X Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2014 12:00:00 AM | 3x3 | Permit Number 770271 | 6000871.66317 | 2110692.9632900003 | 37.775609128624 | -122.440478284704 | (37.775609128624, -122.440478284704) | ||
86649 | 86649 | 75767 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 40 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2013 12:00:00 AM | Permit Number 769934 | 5991382.48989166 | 2104778.11125906 | 37.758823639987796 | -122.47287193809099 | (37.7588236399878, -122.472871938091) | |||
86744 | 86744 | 105726 | Undocumented 2 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 428A PIERCE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 4x4 | 6002769.7 | 2110121.3 | 37.7741473764159 | -122.43387164824 | (37.7741473764159, -122.43387164824) | |||
87599 | 87599 | 100422 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 1701X 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2012 12:00:00 AM | 3x4 | Permit Number 769064 | 5993374.0 | 2103847.1 | 37.7563824151434 | -122.465916782185 | (37.7563824151434, -122.465916782185) | ||
90055 | 90055 | 106359 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 276 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770436 | 6009994.6 | 2121304.9 | 37.805262192623 | -122.40966886664499 | (37.805262192623, -122.409668866645) | ||||
91352 | 91352 | 107317 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 1400X Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2014 12:00:00 AM | 3x3 | Permit Number 770271 | 6000871.66317 | 2110692.9632900003 | 37.775609128624 | -122.440478284704 | (37.775609128624, -122.440478284704) | ||
92254 | 92254 | 107318 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 1400X Grove St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2014 12:00:00 AM | 3x3 | Permit Number 770271 | 6000871.66317 | 2110692.9632900003 | 37.775609128624 | -122.440478284704 | (37.775609128624, -122.440478284704) | ||
93933 | 93933 | 75468 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 40 Lomita Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2013 12:00:00 AM | Permit Number 769934 | 5991382.48989166 | 2104778.11125906 | 37.758823639987796 | -122.47287193809099 | (37.7588236399878, -122.472871938091) | |||
95519 | 95519 | 86743 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 2690 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
95996 | 95996 | 100421 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 1701X 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2012 12:00:00 AM | 3x4 | Permit Number 769064 | 5993374.0 | 2103847.1 | 37.7563824151434 | -122.465916782185 | (37.7563824151434, -122.465916782185) | ||
96708 | 96708 | 102042 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 307 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2012 12:00:00 AM | 3x3 | Permit Number 769064 | 5993385.6 | 2103903.0 | 37.7565365712381 | -122.465880727208 | (37.7565365712381, -122.465880727208) | ||
99486 | 99486 | 100420 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 1701X 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2012 12:00:00 AM | 3x4 | Permit Number 769064 | 5993374.0 | 2103847.1 | 37.7563824151434 | -122.465916782185 | (37.7563824151434, -122.465916782185) | ||
99628 | 99628 | 107313 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 1400X Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2014 12:00:00 AM | 3x3 | Permit Number 770271 | 6000871.66317 | 2110692.9632900003 | 37.775609128624 | -122.440478284704 | (37.775609128624, -122.440478284704) | ||
99662 | 99662 | 96086 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 2120 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2011 12:00:00 AM | Permit Number 767147 | 6004557.0 | 2116744.0 | 37.7924329253555 | -122.42816113061501 | (37.7924329253555, -122.428161130615) | |||
102063 | 102063 | 99618 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 1590X Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2012 12:00:00 AM | 24 | 3x3 | Permit Number 768864 | 6006002.5 | 2118362.3 | 37.7969580495509 | -122.423274742897 | (37.7969580495509, -122.423274742897) | |
106727 | 106727 | 93912 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 2690 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
107132 | 107132 | 107315 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 1400X Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2014 12:00:00 AM | 3x3 | Permit Number 770271 | 6000871.66317 | 2110692.9632900003 | 37.775609128624 | -122.440478284704 | (37.775609128624, -122.440478284704) | ||
110364 | 110364 | 99619 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 1590X Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2012 12:00:00 AM | 24 | 3x3 | Permit Number 768864 | 6006002.5 | 2118362.3 | 37.7969580495509 | -122.423274742897 | (37.7969580495509, -122.423274742897) | |
110917 | 110917 | 107314 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 1400X Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2014 12:00:00 AM | 3x3 | Permit Number 770271 | 6000871.66317 | 2110692.9632900003 | 37.775609128624 | -122.440478284704 | (37.775609128624, -122.440478284704) | ||
110990 | 110990 | 75531 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 40 Lomita Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2013 12:00:00 AM | Permit Number 769934 | 5991382.48989166 | 2104778.11125906 | 37.758823639987796 | -122.47287193809099 | (37.7588236399878, -122.472871938091) | |||
112490 | 112490 | 19209 | DPW Maintained 3 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 395X Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/25/2014 02:29:00 PM | 3 | 3.5x3. 5 | 6012205.797263901 | 2118092.2355744 | 37.7965646535307 | -122.401790730678 | (37.7965646535307, -122.401790730678) | ||
115502 | 115502 | 86745 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 2690 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
118539 | 118539 | 99617 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 1590X Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2012 12:00:00 AM | 24 | 3x3 | Permit Number 768864 | 6006002.5 | 2118362.3 | 37.7969580495509 | -122.423274742897 | (37.7969580495509, -122.423274742897) | |
119437 | 119437 | 109873 | Undocumented 2 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 400 PIERCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 1 | 4x4 | 6002729.7 | 2109998.5 | 37.773807928081006 | -122.434001235387 | (37.773807928081, -122.434001235387) | ||
123529 | 123529 | 112879 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 755 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2015 12:00:00 AM | Permit Number 772774 | 5995320.1 | 2110503.8 | 37.774772060652396 | -122.459668664517 | (37.7747720606524, -122.459668664517) | |||
125274 | 125274 | 75595 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 40 Lomita Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2013 12:00:00 AM | Permit Number 769934 | 5991382.48989166 | 2104778.11125906 | 37.758823639987796 | -122.47287193809099 | (37.7588236399878, -122.472871938091) | |||
126679 | 126679 | 75656 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 40 Lomita Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2013 12:00:00 AM | Permit Number 769934 | 5991382.48989166 | 2104778.11125906 | 37.758823639987796 | -122.47287193809099 | (37.7588236399878, -122.472871938091) | |||
127533 | 127533 | 87568 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 1590X Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2012 12:00:00 AM | 24 | 3x3 | Permit Number 768864 | 6006002.5 | 2118362.3 | 37.7969580495509 | -122.423274742897 | (37.7969580495509, -122.423274742897) | |
138472 | 138472 | 109875 | Undocumented 2 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 400 PIERCE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 1 | 4x4 | 6002729.7 | 2109998.5 | 37.773807928081006 | -122.434001235387 | (37.773807928081, -122.434001235387) | ||
138623 | 138623 | 86744 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 2690 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
141278 | 141278 | 105737 | Undocumented 2 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 419 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 2 | 4x4 | 6002669.0 | 2109966.0 | 37.773715246164606 | -122.434208882327 | (37.7737152461646, -122.434208882327) | ||
165708 | 165708 | 62051 | Permitted Site 1 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 179 | 276 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1985 12:00:00 AM | 17 | 7x15 | Permit Number 770436 | 6010004.5465 | 2121290.7324 | 37.8052238492822 | -122.40963344479201 | (37.8052238492822, -122.409633444792) |
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");