Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
83784 | 83784 | 47253 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 1001 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52373 | 6013117.42744406 | 2089558.25653077 | 37.718267407089 | -122.39663499597201 | (37.718267407089, -122.396634995972) | ||
105830 | 105830 | 79561 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 1001 Le Conte Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52373 | 6013117.42744406 | 2089558.25653077 | 37.718267407089 | -122.39663499597201 | (37.718267407089, -122.396634995972) | ||
138883 | 138883 | 79132 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 1001 Le Conte Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52373 | 6013117.42744406 | 2089558.25653077 | 37.718267407089 | -122.39663499597201 | (37.718267407089, -122.396634995972) | ||
151005 | 151005 | 36798 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 1355 Donner Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | 6 | Permit Number 39528 | 6015230.5975 | 2090758.0224 | 37.7216791113631 | -122.38941433805701 | (37.7216791113631, -122.389414338057) | |
89975 | 89975 | 36802 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 1365 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39529 | 6015184.51378884 | 2090800.41329061 | 37.72179295326 | -122.389576597698 | (37.72179295326, -122.389576597698) | ||
95946 | 95946 | 36801 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 1365 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39529 | 6015184.51378884 | 2090800.41329061 | 37.72179295326 | -122.389576597698 | (37.72179295326, -122.389576597698) | ||
53021 | 53021 | 36796 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 1350 Donner Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2015 12:00:00 AM | 5 | Permit Number 39527 | 6015132.5367 | 2090909.0726 | 37.7220884281377 | -122.38976385626002 | (37.7220884281377, -122.38976385626) | ||
170346 | 170346 | 38578 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 1539 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2005 12:00:00 AM | 4 | Permit Number 40538 | 6015192.4143 | 2094984.0689 | 37.733280874609704 | -122.38984136904499 | (37.7332808746097, -122.389841369045) | |
104961 | 104961 | 41701 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 34 Natick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42151 | 6003036.29664011 | 2095600.66365718 | 37.734292282497 | -122.431912391757 | (37.734292282497, -122.431912391757) | ||
102987 | 102987 | 46811 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 172 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44893 | 5994497.83320908 | 2096348.9473150002 | 37.7358591414077 | -122.461486623647 | (37.7358591414077, -122.461486623647) | ||
142349 | 142349 | 46812 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 172 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44893 | 5994497.83320908 | 2096348.9473150002 | 37.7358591414077 | -122.461486623647 | (37.7358591414077, -122.461486623647) | ||
109787 | 109787 | 36542 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 190 Gates St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39415 | 6008260.22671845 | 2097736.01770388 | 37.7404502589313 | -122.414002536769 | (37.7404502589313, -122.414002536769) | ||
94572 | 94572 | 98483 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 531X Franconia St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
95056 | 95056 | 98485 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 531X Franconia St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
139243 | 139243 | 98475 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 531X Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
143298 | 143298 | 98479 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 531X Franconia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
143504 | 143504 | 98481 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 531X Franconia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
144928 | 144928 | 98487 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 531X Franconia St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
145314 | 145314 | 55969 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 35 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2000 12:00:00 AM | Permit Number 770524 | 6007464.012592 | 2099914.14210495 | 37.7463861516938 | -122.416909822502 | (37.7463861516938, -122.416909822502) | ||
107365 | 107365 | 39492 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 3927 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40950 | 6004349.113469999 | 2100706.94457928 | 37.74838729928089 | -122.42773726390399 | (37.7483872992809, -122.427737263904) | ||
78326 | 78326 | 39114 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 501 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1998 12:00:00 AM | Permit Number 40801 | 6006834.26665835 | 2100862.7419909 | 37.7489553490953 | -122.419154691519 | (37.7489553490953, -122.419154691519) | |||
118734 | 118734 | 39113 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 501 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1998 12:00:00 AM | Permit Number 40801 | 6006834.26665835 | 2100862.7419909 | 37.7489553490953 | -122.419154691519 | (37.7489553490953, -122.419154691519) | |||
142511 | 142511 | 63790 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 4064 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24476 | 6003436.69055965 | 2101294.50423962 | 37.7499489448753 | -122.430934327568 | (37.7499489448753, -122.430934327568) | ||
106729 | 106729 | 37269 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 3720 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2002 12:00:00 AM | Permit Number 44410 | 6003590.32041295 | 2103642.33347016 | 37.7564042340637 | -122.430570577111 | (37.7564042340637, -122.430570577111) | ||
126405 | 126405 | 63533 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 368 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1987 12:00:00 AM | Permit Number 24146 | 6006703.62861604 | 2103973.71687458 | 37.7574900150011 | -122.419827158071 | (37.7574900150011, -122.419827158071) | ||
117868 | 117868 | 63534 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 345 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1987 12:00:00 AM | Permit Number 24147 | 6006748.16886694 | 2104110.61481304 | 37.757868414154295 | -122.41968283278798 | (37.7578684141543, -122.419682832788) | ||
63417 | 63417 | 31615 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 750 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1995 12:00:00 AM | Permit Number 35136 | 6005596.48777411 | 2104595.39586612 | 37.75913456673371 | -122.423700300709 | (37.7591345667337, -122.423700300709) | |||
109042 | 109042 | 31399 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 3850 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1995 12:00:00 AM | Permit Number 34990 | 6003938.7782539 | 2105415.4152023997 | 37.7612924290105 | -122.429491931159 | (37.7612924290105, -122.429491931159) | |||
123786 | 123786 | 31397 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 3850 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1995 12:00:00 AM | Permit Number 34990 | 6003938.7782539 | 2105415.4152023997 | 37.7612924290105 | -122.429491931159 | (37.7612924290105, -122.429491931159) | |||
141780 | 141780 | 31398 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 3850 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1995 12:00:00 AM | Permit Number 34990 | 6003938.7782539 | 2105415.4152023997 | 37.7612924290105 | -122.429491931159 | (37.7612924290105, -122.429491931159) | |||
90164 | 90164 | 36714 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 39 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39500 | 6006465.12887792 | 2105724.70992559 | 37.762284395060796 | -122.420776293192 | (37.7622843950608, -122.420776293192) | |||
93836 | 93836 | 47725 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 85 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2002 12:00:00 AM | Permit Number 45520 | 6006351.18478147 | 2105818.87737664 | 37.7625365339004 | -122.421177070604 | (37.7625365339004, -122.421177070604) | ||
102740 | 102740 | 47727 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 85 Sycamore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2002 12:00:00 AM | Permit Number 45520 | 6006351.18478147 | 2105818.87737664 | 37.7625365339004 | -122.421177070604 | (37.7625365339004, -122.421177070604) | |||
115772 | 115772 | 47723 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 85 Sycamore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2002 12:00:00 AM | Permit Number 45520 | 6006351.18478147 | 2105818.87737664 | 37.7625365339004 | -122.421177070604 | (37.7625365339004, -122.421177070604) | |||
119934 | 119934 | 47726 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 85 Sycamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2002 12:00:00 AM | Permit Number 45520 | 6006351.18478147 | 2105818.87737664 | 37.7625365339004 | -122.421177070604 | (37.7625365339004, -122.421177070604) | |||
153345 | 153345 | 31802 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 55 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35272 | 6001924.59605 | 2107955.77099 | 37.768153377501505 | -122.43663996825701 | (37.7681533775015, -122.436639968257) | |
43415 | 43415 | 82842 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 624 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52445 | 6009524.75632 | 2111364.58269 | 37.7779421535385 | -122.4105924362 | (37.7779421535385, -122.4105924362) | |
133807 | 133807 | 111385 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 340 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6014582.17665 | 2112417.55167 | 37.7811156101297 | -122.39317059416099 | (37.7811156101297, -122.393170594161) | |||
30779 | 30779 | 60998 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 340 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1991 12:00:00 AM | 6 | 3x3 | Permit Number 30085 | 6014626.949469999 | 2112460.0438599996 | 37.7812347712083 | -122.393018675278 | (37.7812347712083, -122.393018675278) |
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");