Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21110 | 21110 | 4447 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1361 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6004544.06336 | 2100936.2409900003 | 37.7490279200058 | -122.42707946086 | (37.7490279200058, -122.42707946086) | |||
59468 | 59468 | 98817 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 290 Napoleon St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6011799.60927 | 2099715.83427 | 37.7460845639436 | -122.401903804432 | (37.7460845639436, -122.401903804432) | |||
66645 | 66645 | 89559 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 5227 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982413.61439 | 2111658.5087 | 37.777191925470206 | -122.504399660112 | (37.7771919254702, -122.504399660112) | ||
67514 | 67514 | 113714 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 498x 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5989413.63244 | 2111977.09724 | 37.778475910189705 | -122.480207969324 | (37.7784759101897, -122.480207969324) | |||
82199 | 82199 | 90695 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4100X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982874.37736 | 2110367.17949 | 37.773673400846704 | -122.50271015187 | (37.7736734008467, -122.50271015187) | ||
84419 | 84419 | 89512 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4700X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984063.36258 | 2111770.60585 | 37.777596605922106 | -122.498701028226 | (37.7775966059221, -122.498701028226) | ||
85136 | 85136 | 89524 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4840X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983565.288790001 | 2111753.60264 | 37.7775206958325 | -122.50042274829201 | (37.7775206958325, -122.500422748292) | ||
88681 | 88681 | 90738 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4451X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981732.83736 | 2110270.97597 | 37.7733421032725 | -122.506651709597 | (37.7733421032725, -122.506651709597) | ||
88733 | 88733 | 90730 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4575X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981423.242190001 | 2110260.00092 | 37.773293734399 | -122.507721808797 | (37.773293734399, -122.507721808797) | ||
90674 | 90674 | 47490 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 99X LYELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 2 | 3x3 | Permit Number 45384 | 6003192.0 | 2094433.0 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | |
91363 | 91363 | 91015 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4001X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5983165.84214 | 2110322.7958400003 | 37.773568660348296 | -122.501698662328 | (37.7735686603483, -122.501698662328) | ||
91720 | 91720 | 90745 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4345 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982053.54954 | 2110284.79915 | 37.7733989368092 | -122.505543365519 | (37.7733989368092, -122.505543365519) | ||
93763 | 93763 | 90729 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4601X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981296.19925 | 2110254.1964 | 37.7732703114755 | -122.508160828969 | (37.7732703114755, -122.508160828969) | ||
94036 | 94036 | 121634 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 349 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5990532.0 | 2113054.0 | 37.7814977082044 | -122.47641784169501 | (37.7814977082044, -122.476417841695) | |||
97898 | 97898 | 90702 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4150 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982693.082780001 | 2110362.14824 | 37.7736489307149 | -122.503336894741 | (37.7736489307149, -122.503336894741) | ||
99932 | 99932 | 90693 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4046 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982986.41354 | 2110371.00337 | 37.773690483490206 | -122.50232289085 | (37.7736904834902, -122.50232289085) | ||
108366 | 108366 | 91013 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4243 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5982353.14616 | 2110293.5731900004 | 37.773440654471 | -122.504507686123 | (37.773440654471, -122.504507686123) | ||
108464 | 108464 | 90718 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4606 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981306.68716 | 2110312.4984 | 37.773431009678895 | -122.50812887858801 | (37.7734310096789, -122.508128878588) | ||
108855 | 108855 | 90703 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4200X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982542.19786 | 2110357.81222 | 37.773628154302294 | -122.503858498829 | (37.7736281543023, -122.503858498829) | ||
109433 | 109433 | 90737 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4501X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981620.20205 | 2110267.22621 | 37.773325174636 | -122.507041045742 | (37.773325174636, -122.507041045742) | ||
111566 | 111566 | 90739 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4451X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981746.10841 | 2110271.13179 | 37.7733433125324 | -122.50660581555 | (37.7733433125324, -122.50660581555) | ||
114807 | 114807 | 90744 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4401 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981925.61643 | 2110279.1737 | 37.7733759612739 | -122.505985479448 | (37.7733759612739, -122.505985479448) | ||
115946 | 115946 | 98813 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 290 Napoleon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3x3 | 6011920.40954 | 2099763.4920200002 | 37.7462221629395 | -122.40148943908702 | (37.7462221629395, -122.401489439087) | |||
116905 | 116905 | 91014 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4139 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5982669.850769999 | 2110306.1682599997 | 37.7734938602238 | -122.503413110518 | (37.7734938602238, -122.503413110518) | ||
120834 | 120834 | 90736 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4501X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981602.49176 | 2110266.28486 | 37.77332154692 | -122.507102237161 | (37.77332154692, -122.507102237161) | ||
125453 | 125453 | 91012 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4301X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5982213.29166 | 2110288.86252 | 37.7734194931658 | -122.504991105508 | (37.7734194931658, -122.504991105508) | ||
126476 | 126476 | 90722 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4650X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981131.941430001 | 2110306.4934400003 | 37.773404223233904 | -122.508732892327 | (37.7734042232339, -122.508732892327) | ||
128060 | 128060 | 90721 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4650X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981150.165159999 | 2110306.92668 | 37.7734064869384 | -122.508669887159 | (37.7734064869384, -122.508669887159) | ||
139067 | 139067 | 90717 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4600X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981323.93536 | 2110313.64162 | 37.7734351649753 | -122.50806930052099 | (37.7734351649753, -122.508069300521) | ||
140329 | 140329 | 90712 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4508 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981619.82432 | 2110323.60403 | 37.773479949383294 | -122.50704653532101 | (37.7734799493833, -122.507046535321) | ||
142970 | 142970 | 90710 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4450 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981744.51954 | 2110327.1512700003 | 37.773497032089 | -122.50661546708 | (37.773497032089, -122.50661546708) | ||
143900 | 143900 | 90686 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4000X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983182.62546 | 2110378.7442099997 | 37.7737232641716 | -122.501644747223 | (37.7737232641716, -122.501644747223) | ||
144018 | 144018 | 90711 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4500 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981635.19797 | 2110323.94692 | 37.773481796264 | -122.506993382003 | (37.773481796264, -122.506993382003) | ||
153004 | 153004 | 98814 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 290 Napoleon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6011900.23089 | 2099755.59596 | 37.7461993561215 | -122.401558659925 | (37.7461993561215, -122.401558659925) | |||
163577 | 163577 | 92398 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1919 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52800 | 6012329.06895 | 2103729.7014200003 | 37.757135307361295 | -122.400354868801 | (37.7571353073613, -122.400354868801) | |
188262 | 188262 | 32743 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 31 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 12 | 3x3 | Permit Number 37126 | 5996349.198890001 | 2089288.18101 | 37.7165783462864 | -122.454575832225 | (37.7165783462864, -122.454575832225) |
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");