Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4027 | 4027 | 253600 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
4041 | 4041 | 253601 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
4864 | 4864 | 253698 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2200 Ofarrell St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Width 0ft | 6000775.0 | 2113124.0 | 37.7822786323031 | -122.440987106931 | (37.7822786323031, -122.440987106931) | ||||
17355 | 17355 | 18407 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 06/02/1992 12:00:00 AM | 12 | 3X3 | 6010549.786619999 | 2103464.28095 | 37.7563071414784 | -122.4064896391 | (37.7563071414784, -122.4064896391) | ||
18091 | 18091 | 18397 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 3X3 | 6010576.96525 | 2102937.51144 | 37.7548622699958 | -122.406358530544 | (37.7548622699958, -122.406358530544) | |||
20353 | 20353 | 18398 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 05/23/1997 12:00:00 AM | 3 | 3X3 | 6010574.371780001 | 2102982.33848 | 37.7549852100133 | -122.40637065790101 | (37.7549852100133, -122.406370657901) | ||
20727 | 20727 | 18395 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 3x3 | 6010583.3123699995 | 2102829.86253 | 37.7545670450388 | -122.406328995892 | (37.7545670450388, -122.406328995892) | |||
20860 | 20860 | 18406 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 24 | 3x3 | 6010555.16427 | 2103408.27395 | 37.7561536595775 | -122.406467094883 | (37.7561536595775, -122.406467094883) | |||
21450 | 21450 | 18404 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 12 | 3x3 | 6010558.96581 | 2103310.46639 | 37.755885314463605 | -122.40644705620001 | (37.7558853144636, -122.4064470562) | |||
22206 | 22206 | 18402 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 3x3 | 6010563.4475 | 2103210.4803400002 | 37.755611025734 | -122.40642451198299 | (37.755611025734, -122.406424511983) | |||
23146 | 23146 | 18396 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X3 | 6010579.89975 | 2102879.8481400004 | 37.7547041035309 | -122.406344319459 | (37.7547041035309, -122.406344319459) | |||
23258 | 23258 | 18405 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 15 | 3X3 | 6010556.98057 | 2103355.2247200003 | 37.756008099814295 | -122.406457075558 | (37.7560080998143, -122.406457075558) | |||
23324 | 23324 | 18403 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/14/1991 12:00:00 AM | 10 | 3X3 | 6010561.22501 | 2103261.37452 | 37.7557506454989 | -122.406435784089 | (37.7557506454989, -122.406435784089) | ||
39918 | 39918 | 98828 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1020 Union St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 6008042.556030001 | 2119299.03058 | 37.7996449996806 | -122.41628202140801 | (37.7996449996806, -122.416282021408) | |||
43836 | 43836 | 92597 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2201 Baker St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52915 | 5999793.65637 | 2116453.71477 | 37.7913652194864 | -122.44462150359301 | (37.7913652194864, -122.444621503593) | |
45206 | 45206 | 98827 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1020 Union St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 3x3 | 6008062.2749 | 2119302.48836 | 37.7996556026694 | -122.416214031774 | (37.7996556026694, -122.416214031774) | |||
66090 | 66090 | 121506 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 300 Folsom St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 3x3 | 6012227.3168 | 2112699.1751 | 37.7817577819585 | -122.40133708037901 | (37.7817577819585, -122.401337080379) | |||
66608 | 66608 | 113772 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2550 Broadway | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 6001375.31674 | 2117310.7972 | 37.793808671186106 | -122.439210462719 | (37.7938086711861, -122.439210462719) | ||||
66846 | 66846 | 112874 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2636 Vallejo St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2015 12:00:00 AM | 13 | 3x3 | Permit Number 776037 | 6000935.48392 | 2117605.97258 | 37.794594107573104 | -122.440753504176 | (37.7945941075731, -122.440753504176) | |
76011 | 76011 | 18432 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 01/20/2016 12:00:00 AM | 40 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | ||
79579 | 79579 | 25482 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 3x3 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
79829 | 79829 | 26416 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 34 Maple St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996568.2197254 | 2116061.2858977 | 37.790103136313206 | -122.455752999345 | (37.7901031363132, -122.455752999345) | |||
80814 | 80814 | 105835 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2205 Pacific Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/28/2014 12:00:00 AM | Permit Number 772662 | 6003508.7 | 2117188.3 | 37.7935934914571 | -122.431820013768 | (37.7935934914571, -122.431820013768) | |||
92671 | 92671 | 25483 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 12 | 3X3 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
92972 | 92972 | 18426 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 01/20/2016 12:00:00 AM | 30 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | ||
99627 | 99627 | 18428 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 24 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | |||
103504 | 103504 | 18429 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 30 | 3x3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | |||
107467 | 107467 | 18427 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 40 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | |||
108153 | 108153 | 93190 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 651 24th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/18/2010 12:00:00 AM | 3x3 | Permit Number 53197 | 5988426.1 | 2111542.8 | 37.777226019991204 | -122.483592327097 | (37.7772260199912, -122.483592327097) | ||
112444 | 112444 | 18430 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 30 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | |||
126196 | 126196 | 18399 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 24 | 4x4 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
128737 | 128737 | 18408 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 05/23/1997 12:00:00 AM | 18 | 2X4 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | ||
137020 | 137020 | 113771 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2550 Broadway | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 6001386.1067 | 2117311.2447 | 37.79381051388621 | -122.439173160634 | (37.7938105138862, -122.439173160634) | ||||
138503 | 138503 | 18401 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 4x4 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
142641 | 142641 | 18431 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 01/20/2016 12:00:00 AM | 24 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | ||
152984 | 152984 | 92598 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2201 Baker St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52915 | 5999796.94168 | 2116437.53805 | 37.7913209899324 | -122.44460897334 | (37.7913209899324, -122.44460897334) | |
161406 | 161406 | 92599 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2201 Baker St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52915 | 5999799.49653 | 2116432.67643 | 37.7913077869862 | -122.444599784076 | (37.7913077869862, -122.444599784076) | |
165797 | 165797 | 121508 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 300 Folsom St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 3x3 | 6012258.9126 | 2112729.3972 | 37.78184252759429 | -122.401229897449 | (37.7818425275943, -122.401229897449) | |||
180960 | 180960 | 92658 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2201 Baker St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 5 | Permit Number 52915 | 5999791.1848 | 2116474.20228 | 37.7914213317691 | -122.44463152831699 | (37.7914213317691, -122.444631528317) | ||
183154 | 183154 | 113770 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2550 Broadway | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 6001403.30227 | 2117311.89486 | 37.7938132775122 | -122.43911370912501 | (37.7938132775122, -122.439113709125) | ||||
187249 | 187249 | 98829 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1020 Union St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 21 | 3x3 | 6008023.617869999 | 2119295.81426 | 37.7996351035429 | -122.41634732658702 | (37.7996351035429, -122.416347326587) |
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");