Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
83620 | 83620 | 12440 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1595X Laguna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004488.80475 | 2114299.5475 | 37.785717215657 | -122.428222797765 | (37.785717215657, -122.428222797765) | |||
6496 | 6496 | 23490 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2500X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005777.87956 | 2119177.1307599996 | 37.799182688783496 | -122.424109961515 | (37.7991826887835, -122.424109961515) | |||
605 | 605 | 23903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 6003560.4697 | 2114360.5617 | 37.7858321751093 | -122.431438928251 | (37.7858321751093, -122.431438928251) | |||
46253 | 46253 | 27745 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1399 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6014867.852606599 | 2101105.5872465 | 37.7500712934283 | -122.391391267014 | (37.7500712934283, -122.391391267014) | ||
118003 | 118003 | 27753 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1299 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | ||
7475 | 7475 | 28644 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003694.7628 | 2113348.3634 | 37.7830605429851 | -122.430902047868 | (37.7830605429851, -122.430902047868) | ||
54410 | 54410 | 34473 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1725 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | 3 | Permit Number 38203 | 6008692.20922 | 2118946.49843 | 37.7987135430497 | -122.414009024508 | (37.7987135430497, -122.414009024508) | ||
120783 | 120783 | 35303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3459 17th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/1998 12:00:00 AM | Permit Number 38773 | 6005812.46547868 | 2106053.59345559 | 37.763150623964 | -122.423056990755 | (37.763150623964, -122.423056990755) | |||
78214 | 78214 | 36247 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 134 Surrey St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39267 | 6002197.13789926 | 2096205.20394281 | 37.735904603360794 | -122.43485684800899 | (37.7359046033608, -122.434856848009) | |||
117736 | 117736 | 36258 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 25 Elmhurst Dr | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39270 | 5991200.33310514 | 2094436.30103714 | 37.7304171492597 | -122.472747856373 | (37.7304171492597, -122.472747856373) | ||
18485 | 18485 | 36424 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Montecito Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39337 | 5996091.95170793 | 2094186.31684288 | 37.7300127063789 | -122.455818876187 | (37.7300127063789, -122.455818876187) | |||
145244 | 145244 | 36433 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 435 Montecito Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39339 | 5995738.77288151 | 2093964.11788292 | 37.7293823258224 | -122.457023785093 | (37.7293823258224, -122.457023785093) | ||
77370 | 77370 | 37268 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
130997 | 130997 | 38752 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012228.62933 | 2112416.55663 | 37.780981850378105 | -122.40131267285 | (37.7809818503781, -122.40131267285) | ||
141976 | 141976 | 42760 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |||
99451 | 99451 | 43832 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2690 35th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43458 | 5985573.35768067 | 2097037.8388718998 | 37.737232941963605 | -122.492392332362 | (37.7372329419636, -122.492392332362) | ||
104218 | 104218 | 45546 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Sloat Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | Permit Number 44299 | 5990416.87578702 | 2095931.52068495 | 37.734477258874605 | -122.47556548665399 | (37.7344772588746, -122.475565486654) | ||
113658 | 113658 | 48787 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1405 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | |||
106418 | 106418 | 49406 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 288@ OCEAN Onondaga Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2003 12:00:00 AM | Permit Number 46355 | 5999928.15335168 | 2091616.69162038 | 37.7231765280064 | -122.44237229181101 | (37.7231765280064, -122.442372291811) | |||
112052 | 112052 | 50550 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 60 29th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180.0 | 2099188.0 | 37.74432002092679 | -122.421298240567 | (37.7443200209268, -122.421298240567) | |||
115980 | 115980 | 88231 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2108 Hayes St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51222 | 5997802.0 | 2109918.0 | 37.7733060118428 | -122.451041052194 | (37.7733060118428, -122.451041052194) | ||
143083 | 143083 | 101447 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||||
70581 | 70581 | 106985 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1737-1795 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2010 12:00:00 AM | 4 | 6003795.2547 | 2114190.67 | 37.7853789990287 | -122.430614510729 | (37.7853789990287, -122.430614510729) | |||
87562 | 87562 | 107757 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 400X Lily St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | |||||
97014 | 97014 | 109160 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200 Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||||
117462 | 117462 | 110548 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2x LILY ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6006369.0 | 2110405.0 | 37.775129941044604 | -122.421441165405 | (37.7751299410446, -122.421441165405) | ||||
101341 | 101341 | 115455 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 300 Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
103534 | 103534 | 115686 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
115442 | 115442 | 117169 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
68693 | 68693 | 118431 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5981816.64658 | 2111695.18358 | 37.7772574943259 | -122.506467446284 | (37.7772574943259, -122.506467446284) | |||
124671 | 124671 | 119865 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451X Octavia St Frontage West | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
102125 | 102125 | 119872 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 400X Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
149958 | 149958 | 120890 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009870.8927 | 2087557.0134 | 37.71259118267999 | -122.40771591213999 | (37.71259118268, -122.40771591214) | |||
1998 | 1998 | 135937 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 98 Spruce St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780098 | 5997052.02369 | 2116054.59656 | 37.7901125223289 | -122.45407860247299 | (37.7901125223289, -122.454078602473) | |
2550 | 2550 | 138186 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1865 Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 0ft | 6003941.622 | 2114719.9923 | 37.786840675810396 | -122.43014589889499 | (37.7868406758104, -122.430145898895) | |||
28014 | 28014 | 138798 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1827 Broderick St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000492.2704 | 2114959.4269 | 37.7873021338531 | -122.44209701285101 | (37.7873021338531, -122.442097012851) | |||
153848 | 153848 | 138873 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 OCTAVIA ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005564.9563 | 2110783.2259 | 37.7761230908013 | -122.42424943998002 | (37.7761230908013, -122.42424943998) | |||
154438 | 154438 | 138976 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 459 Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005452.3041 | 2110848.8680000002 | 37.776296966508106 | -122.42464380515499 | (37.7762969665081, -122.424643805155) | |||
172231 | 172231 | 139146 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004372.8447 | 2114064.6435 | 37.7850656661829 | -122.428607235997 | (37.7850656661829, -122.428607235997) | |||
185222 | 185222 | 142763 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010767.3863 | 2120009.5113 | 37.8017486483835 | -122.406903172911 | (37.8017486483835, -122.406903172911) | |||
151052 | 151052 | 178883 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003694.22054 | 2090531.28472 | 37.7204101758585 | -122.42927637423 | (37.7204101758585, -122.42927637423) | |||
34928 | 34928 | 178912 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5993780.74611 | 2086770.03775 | 37.709516474781104 | -122.463270994886 | (37.7095164747811, -122.463270994886) | ||||
46811 | 46811 | 178935 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000079.03218 | 2091613.78256 | 37.7231771388895 | -122.44185052598 | (37.7231771388895, -122.44185052598) | |||
130753 | 130753 | 183940 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1809 Quintara St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987813.0153 | 2100978.3126 | 37.7481831275412 | -122.484937911261 | (37.7481831275412, -122.484937911261) | |||
148188 | 148188 | 196382 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012355.92865 | 2112312.32296 | 37.780702750265704 | -122.400864953468 | (37.7807027502657, -122.400864953468) | |||
24998 | 24998 | 238025 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Alma St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997578.60338 | 2106127.58066 | 37.762885697531296 | -122.451540352327 | (37.7628856975313, -122.451540352327) |
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");