Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3401 | 3401 | 29754 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 532 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6009953.7417 | 2119408.8277 | 37.800053757708994 | -122.40967634888099 | (37.800053757709, -122.409676348881) | |||
16152 | 16152 | 35693 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
16815 | 16815 | 15113 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6013991.513259999 | 2116128.24604 | 37.7912714903321 | -122.395474051105 | (37.7912714903321, -122.395474051105) | |||
29650 | 29650 | 129819 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 241 Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012648.9601 | 2117092.8382099997 | 37.793845267304505 | -122.400187054399 | (37.7938452673045, -122.400187054399) | |||
30478 | 30478 | 140287 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1960 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998483.9171 | 2110037.6666 | 37.7736736024147 | -122.448690838206 | (37.7736736024147, -122.448690838206) | |||
31897 | 31897 | 129849 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 103 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6012584.80341 | 2118810.70115 | 37.798558531416795 | -122.400529771657 | (37.7985585314168, -122.400529771657) | |||
37396 | 37396 | 7768 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 325X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006199.471782 | 2111757.686674 | 37.7788345313197 | -122.42212372172101 | (37.7788345313197, -122.422123721721) | |||
46251 | 46251 | 129796 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1180 Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6011917.98876 | 2120230.87285 | 37.8024207688713 | -122.402937111974 | (37.8024207688713, -122.402937111974) | |||
54619 | 54619 | 129787 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011959.4647699995 | 2119924.96913 | 37.801583147494604 | -122.402772057584 | (37.8015831474946, -122.402772057584) | |||
55636 | 55636 | 129757 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2315 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6003704.65718 | 2116456.32668 | 37.7915947858084 | -122.431089717742 | (37.7915947858084, -122.431089717742) | |||
57959 | 57959 | 129812 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 435 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012517.23545 | 2117156.65433 | 37.794013145532 | -122.40064732203301 | (37.794013145532, -122.400647322033) | |||
62368 | 62368 | 39387 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 7 | Permit Number 40925 | 6000579.41048 | 2117201.67826 | 37.7934637371134 | -122.44195652817899 | (37.7934637371134, -122.441956528179) | ||
65786 | 65786 | 129752 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2407 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6003040.06059 | 2116163.9449299998 | 37.790754298317204 | -122.43336831020201 | (37.7907542983172, -122.433368310202) | |||
69203 | 69203 | 129829 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012523.949659999 | 2117203.16491 | 37.7941412269928 | -122.400627358876 | (37.7941412269928, -122.400627358876) | |||
74895 | 74895 | 200358 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1150 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6014239.8641 | 2096632.70057 | 37.7377548084229 | -122.393249946754 | (37.7377548084229, -122.393249946754) | |||
75521 | 75521 | 228848 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004199.57922 | 2104548.6925 | 37.7589273774242 | -122.42852814905599 | (37.7589273774242, -122.428528149056) | |||
83384 | 83384 | 17658 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
85626 | 85626 | 17642 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 6 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
87097 | 87097 | 100696 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
87423 | 87423 | 97618 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 333 Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012618.0 | 2117355.0 | 37.7945633749541 | -122.400312601987 | (37.7945633749541, -122.400312601987) | |||||
89013 | 89013 | 108651 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
91941 | 91941 | 52992 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1800 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 48973 | 6013995.42685531 | 2096291.44248921 | 37.7368042013217 | -122.394071207374 | (37.7368042013217, -122.394071207374) | |||
113579 | 113579 | 108037 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1527 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010078.267999999 | 2119414.52002 | 37.800076364716396 | -122.4092458402 | (37.8000763647164, -122.4092458402) | |||||
116567 | 116567 | 32408 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36942 | 6014160.17669171 | 2116306.66761031 | 37.7917707740774 | -122.394902977188 | (37.7917707740774, -122.394902977188) | |||
128349 | 128349 | 96320 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
129659 | 129659 | 129843 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6012472.985859999 | 2118729.7445099996 | 37.7983300073669 | -122.40091100686399 | (37.7983300073669, -122.400911006864) | |||
130651 | 130651 | 129836 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 733 Front St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6012782.07244 | 2118635.55361 | 37.7980886176578 | -122.399834849323 | (37.7980886176578, -122.399834849323) | |||
142828 | 142828 | 50615 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2004 12:00:00 AM | Permit Number 47216 | 6004288.29588296 | 2104553.28636794 | 37.7589450112214 | -122.42822165267 | (37.7589450112214, -122.42822165267) | |||
149913 | 149913 | 129804 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6010351.68054 | 2116862.21581 | 37.793083672815705 | -122.408119621635 | (37.7930836728157, -122.408119621635) | |||
153734 | 153734 | 129816 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 433 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012609.05006 | 2117170.5257599996 | 37.7940563534572 | -122.400330606896 | (37.7940563534572, -122.400330606896) | |||
156528 | 156528 | 129824 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 504 Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012608.14 | 2117404.20841 | 37.794697939723704 | -122.40035017702499 | (37.7946979397237, -122.400350177025) | |||
172062 | 172062 | 129771 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 80 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012935.02914 | 2119270.4372 | 37.79984038189279 | -122.399350164196 | (37.7998403818928, -122.399350164196) | |||
175699 | 175699 | 200345 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6014658.54117 | 2097192.95407 | 37.7393164002222 | -122.391841530176 | (37.7393164002222, -122.391841530176) | |||
176983 | 176983 | 129765 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1379 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006424.31939 | 2118660.7850599997 | 37.797801411063396 | -122.421836357588 | (37.7978014110634, -122.421836357588) | |||
177605 | 177605 | 129841 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 238 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6012688.5511300005 | 2118531.3338 | 37.7977972409088 | -122.400151139076 | (37.7977972409088, -122.400151139076) | |||
181097 | 181097 | 208169 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2590 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991440.6028 | 2097828.1323700002 | 37.7397441663462 | -122.472164360908 | (37.7397441663462, -122.472164360908) | |||
186583 | 186583 | 200362 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6014166.7855 | 2096532.27247 | 37.7374749933851 | -122.39349559025801 | (37.7374749933851, -122.393495590258) |
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");