Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3379 | 3379 | 188227 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 4 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 5 | Width 3ft | Permit Number 37286 | 6013561.10942 | 2105252.84027 | 37.7613861409778 | -122.39620071499901 | (37.7613861409778, -122.396200714999) | |
23955 | 23955 | 204246 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 81 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997506.8200199995 | 2099205.04953 | 37.7438740375718 | -122.45128934072399 | (37.7438740375718, -122.451289340724) | |||
29030 | 29030 | 205556 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5995160.10892 | 2100068.40682 | 37.746109952717 | -122.45946618093299 | (37.746109952717, -122.459466180933) | |||
29270 | 29270 | 125699 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2107 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5999372.165130001 | 2116056.16018 | 37.79024957900621 | -122.446051241271 | (37.7902495790062, -122.446051241271) | |||
30473 | 30473 | 221155 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 449 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008058.6001 | 2096752.2718 | 37.7377377824817 | -122.41463008643 | (37.7377377824817, -122.41463008643) | |||
35434 | 35434 | 205594 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 600x Laguna Honda Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5995579.6801 | 2099892.46812 | 37.745650984616105 | -122.458002636835 | (37.7456509846161, -122.458002636835) | |||
36456 | 36456 | 205583 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994004.16046 | 2096866.7723599998 | 37.737252533472706 | -122.46323099482001 | (37.7372525334727, -122.46323099482) | |||
40154 | 40154 | 247360 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 717 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003117.4357 | 2109597.3047 | 37.7727283414985 | -122.432631332795 | (37.7727283414985, -122.432631332795) | |||
41287 | 41287 | 205601 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 404 Baden St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6000770.98031 | 2095275.60302 | 37.7332710603101 | -122.43972100331699 | (37.7332710603101, -122.439721003317) | ||||
44247 | 44247 | 204234 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1315 07th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993917.53437 | 2106478.71882 | 37.7636394975886 | -122.464228110963 | (37.7636394975886, -122.464228110963) | |||
46436 | 46436 | 125695 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3011 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000226.0917 | 2116100.01999 | 37.790418732490004 | -122.443099878582 | (37.79041873249, -122.443099878582) | |||
52040 | 52040 | 48559 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1407 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2002 12:00:00 AM | 5 | Permit Number 45875 | 5999686.8778 | 2113772.6173 | 37.7839975324947 | -122.444798150334 | (37.7839975324947, -122.444798150334) | ||
52243 | 52243 | 140387 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1701 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003030.1364 | 2113397.2369999997 | 37.783157057463605 | -122.433204874911 | (37.7831570574636, -122.433204874911) | |||
53802 | 53802 | 205582 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994001.091440001 | 2096883.9077299999 | 37.7372994061387 | -122.463242848772 | (37.7372994061387, -122.463242848772) | |||
55359 | 55359 | 125693 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3651 Baker St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999120.54197 | 2121369.94055 | 37.804825426501395 | -122.447304447454 | (37.8048254265014, -122.447304447454) | |||
56413 | 56413 | 204233 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1315 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993916.4357199995 | 2106511.98623 | 37.7637307778784 | -122.464234326155 | (37.7637307778784, -122.464234326155) | |||
58759 | 58759 | 221135 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 30 Hill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005916.813159999 | 2103474.04706 | 37.7560736810601 | -122.422512780845 | (37.7560736810601, -122.422512780845) | |||
62715 | 62715 | 204307 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992607.73976 | 2098817.35145 | 37.7425277857408 | -122.468200875098 | (37.7425277857408, -122.468200875098) | |||
63357 | 63357 | 205567 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 7 Locksley Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994181.5204 | 2105002.6453 | 37.759601795201704 | -122.463207960474 | (37.7596017952017, -122.463207960474) | |||
63444 | 63444 | 34710 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 810 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38366 | 5981708.71753 | 2110203.70271 | 37.7731559703061 | -122.50673015139499 | (37.7731559703061, -122.506730151395) | |
66094 | 66094 | 204267 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 602 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992346.7328699995 | 2104590.8969900003 | 37.7583653730678 | -122.469523541303 | (37.7583653730678, -122.469523541303) | |||
69083 | 69083 | 204328 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600x Portola Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5992078.39374 | 2096541.4666900001 | 37.7362481967035 | -122.469865516581 | (37.7362481967035, -122.469865516581) | |||
75669 | 75669 | 221143 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1260 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003205.08154 | 2100879.73263 | 37.748796953421 | -122.431705632822 | (37.748796953421, -122.431705632822) | |||
75940 | 75940 | 118109 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3595 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5984506.18513 | 2111050.5276 | 37.775645439688894 | -122.497116013795 | (37.7756454396889, -122.497116013795) | |||
76957 | 76957 | 204251 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 535 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996289.61918 | 2089877.93605 | 37.7181942580441 | -122.454824354468 | (37.7181942580441, -122.454824354468) | |||
131052 | 131052 | 204331 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600x Portola Dr | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5992122.89854 | 2096586.89794 | 37.7363755119059 | -122.46971495297899 | (37.7363755119059, -122.469714952979) | |||
134148 | 134148 | 205600 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 651 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997690.37831 | 2098126.30275 | 37.7409225696214 | -122.45057688613501 | (37.7409225696214, -122.450576886135) | |||
135182 | 135182 | 105522 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1790 27TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | 5 | 3x3 | Permit Number 772657 | 5987869.5 | 2103119.5 | 37.7540655437983 | -122.484899652045 | (37.7540655437983, -122.484899652045) | |
147647 | 147647 | 125711 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 954 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6008937.17158 | 2118714.51142 | 37.798090319168 | -122.413144960375 | (37.798090319168, -122.413144960375) | ||||
152015 | 152015 | 183584 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2609 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5988610.1868 | 2097562.569 | 37.7388507932479 | -122.48193117307501 | (37.7388507932479, -122.481931173075) | |||
155264 | 155264 | 204322 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 270 San Fernando Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992107.8063 | 2095069.8675799998 | 37.7322092550468 | -122.46965672727801 | (37.7322092550468, -122.469656727278) | |||
158194 | 158194 | 33163 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1900 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | 5 | Permit Number 37385 | 5986968.1646 | 2099642.2172 | 37.7444653222212 | -122.487761192729 | (37.7444653222212, -122.487761192729) | ||
158678 | 158678 | 52682 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 5 | Permit Number 48754 | 5984583.26235 | 2111053.32202 | 37.7756576289957 | -122.496849595053 | (37.7756576289957, -122.496849595053) | ||
159448 | 159448 | 52683 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 700 REVISED 37th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 5 | Permit Number 48754 | 5984474.1727 | 2110997.72398 | 37.7754985800658 | -122.49722285223801 | (37.7754985800658, -122.497222852238) | ||
162837 | 162837 | 204306 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Forest Side Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992602.3256 | 2098798.4802200003 | 37.7424756574394 | -122.46821822299201 | (37.7424756574394, -122.468218222992) | |||
172101 | 172101 | 246810 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 161 Brewster St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6010258.54095 | 2098989.94927 | 37.744005315193895 | -122.407181484852 | (37.7440053151939, -122.407181484852) | |||
173112 | 173112 | 31244 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2530 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 5 | Permit Number 34927 | 5991119.10611 | 2098174.96045 | 37.740677856906 | -122.47330123797701 | (37.740677856906, -122.473301237977) | |
173956 | 173956 | 205586 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1991 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993454.343119999 | 2101948.18333 | 37.7511731133615 | -122.46550098617901 | (37.7511731133615, -122.465500986179) | |||
174981 | 174981 | 204305 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 50 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992596.75916 | 2098788.27183 | 37.7424473062996 | -122.468236727452 | (37.7424473062996, -122.468236727452) | |||
177906 | 177906 | 221149 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 164 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997548.8030199995 | 2106785.1121799997 | 37.7646894057032 | -122.451690854773 | (37.7646894057032, -122.451690854773) | |||
178883 | 178883 | 204268 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 602 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992330.82571 | 2104590.62293 | 37.7583637012301 | -122.469578534842 | (37.7583637012301, -122.469578534842) | |||
180426 | 180426 | 205557 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5995171.1293 | 2100080.94883 | 37.746145023587204 | -122.459428982288 | (37.7461450235872, -122.459428982288) | |||
181411 | 181411 | 204252 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 266 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995670.74275 | 2091750.5226599998 | 37.7233004170603 | -122.457098912605 | (37.7233004170603, -122.457098912605) | |||
182801 | 182801 | 204224 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1749 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5993399.01633 | 2103583.1375 | 37.75565908549979 | -122.465811089536 | (37.7556590854998, -122.465811089536) | |||
185565 | 185565 | 205565 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 7 Locksley Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994158.07056 | 2104987.77665 | 37.7595596188099 | -122.463287982171 | (37.7595596188099, -122.463287982171) | |||
185843 | 185843 | 205560 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 417 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5995109.52867 | 2100320.3860400002 | 37.7467989161433 | -122.45965932743799 | (37.7467989161433, -122.459659327438) | |||
186861 | 186861 | 41550 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2271 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2000 12:00:00 AM | 5 | Permit Number 42072 | 6003891.05094 | 2116280.93986 | 37.7911237785009 | -122.430432278226 | (37.7911237785009, -122.430432278226) |
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");