Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
421 | 421 | 236222 | DPW Maintained 3 | Platanus racemosa :: California Sycamore 81 | 758 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006212.30332 | 2105198.62923 | 37.7608256474983 | -122.42161335716801 | (37.7608256474983, -122.421613357168) | |||
672 | 672 | 23002 | Permitted Site 1 | Platanus racemosa :: California Sycamore 81 | 742 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1994 12:00:00 AM | 20 | 3X3 | 6006210.140269999 | 2105247.24413 | 37.7609590106658 | -122.421624291141 | (37.7609590106658, -122.421624291141) | ||
716 | 716 | 236224 | DPW Maintained 3 | Platanus racemosa :: California Sycamore 81 | 740 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1994 12:00:00 AM | 7 | Width 3ft | 6006211.6156 | 2105275.09716 | 37.7610355717565 | -122.421621166906 | (37.7610355717565, -122.421621166906) | ||
2616 | 2616 | 236243 | DPW Maintained 3 | Platanus racemosa :: California Sycamore 81 | 504 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/24/2017 02:20:00 PM | 3 | Width 3ft | 6006138.12079 | 2106622.15868 | 37.7647301413986 | -122.421971048125 | (37.7647301413986, -122.421971048125) | ||
5143 | 5143 | 236219 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 786 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006236.0 | 2105017.0 | 37.760328272277 | -122.42151850101101 | (37.760328272277, -122.421518501011) | |||
7948 | 7948 | 6357 | Permitted Site 1 | Platanus racemosa :: California Sycamore 81 | 2020X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2012 12:00:00 AM | 12 | 4X4 | Permit Number 768573 | 6001173.6622 | 2112841.531 | 37.781525742569606 | -122.439587660215 | (37.7815257425696, -122.439587660215) | |
17151 | 17151 | 22968 | Permitted Site 1 | Platanus racemosa :: California Sycamore 81 | 572 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/04/2010 12:00:00 AM | 3 | 3x3 | 6006154.71472 | 2106264.74945 | 37.763749715787796 | -122.421888263744 | (37.7637497157878, -122.421888263744) | ||
19364 | 19364 | 23004 | DPW Maintained 3 | Platanus racemosa :: California Sycamore 81 | 762 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6006215.9045 | 2105176.06867 | 37.760763904540894 | -122.42159929989401 | (37.7607639045409, -122.421599299894) | |||
21160 | 21160 | 22965 | Permitted Site 1 | Platanus racemosa :: California Sycamore 81 | 522 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6006140.66017 | 2106547.90509 | 37.7645264017829 | -122.42195698992201 | (37.7645264017829, -122.421956989922) | |||
23100 | 23100 | 22998 | DPW Maintained 3 | Platanus racemosa :: California Sycamore 81 | 714 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1994 12:00:00 AM | 8 | 6006205.20873 | 2105402.95089 | 37.7613862668816 | -122.421652406646 | (37.7613862668816, -122.421652406646) | |||
23261 | 23261 | 22995 | DPW Maintained 3 | Platanus racemosa :: California Sycamore 81 | 692 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/2017 12:00:00 AM | 7 | 3X6 | 6006189.8131800005 | 2105598.89712 | 37.7619234211376 | -122.42171957161699 | (37.7619234211376, -122.421719571617) | ||
23429 | 23429 | 236236 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 546 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006147.12053 | 2106400.7179900003 | 37.764122625071 | -122.421924188966 | (37.764122625071, -122.421924188966) | |||
23682 | 23682 | 236235 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 550 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006150.31645 | 2106380.41521 | 37.7640670586624 | -122.42191169288 | (37.7640670586624, -122.42191169288) | |||
23932 | 23932 | 236238 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 540 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006147.07627 | 2106442.5416200003 | 37.76423746040079 | -122.42192731322201 | (37.7642374604008, -122.421927313222) | |||
30796 | 30796 | 236217 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 328 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007040.37256 | 2096523.99487 | 37.7370537248361 | -122.418134418894 | (37.7370537248361, -122.418134418894) | |||
33124 | 33124 | 236228 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 584 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006156.95969 | 2106198.1458400004 | 37.763566964567794 | -122.421875767666 | (37.7635669645678, -122.421875767666) | |||
33842 | 33842 | 236246 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 525 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006205.9381 | 2106515.9841400003 | 37.764442435690704 | -122.421728943463 | (37.7644424356907, -122.421728943463) | |||
36268 | 36268 | 236248 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 3436 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006579.89851 | 2105554.96639 | 37.761824787108296 | -122.42036729883002 | (37.7618247871083, -122.42036729883) | |||
38081 | 38081 | 236240 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 528 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006144.582330001 | 2106497.00749 | 37.76438687018221 | -122.42193980837901 | (37.7643868701822, -122.421939808379) | |||
44009 | 44009 | 211865 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 1274 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993644.4480099995 | 2106831.85611 | 37.764593376104706 | -122.46519827530199 | (37.7645933761047, -122.465198275302) | |||
53353 | 53353 | 236223 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 748 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006211.88041 | 2105222.0235900003 | 37.7608898590889 | -122.42161648143299 | (37.7608898590889, -122.421616481433) | |||
64292 | 64292 | 236245 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 521 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006205.90235 | 2106536.22169 | 37.7644980012145 | -122.42173050465799 | (37.7644980012145, -122.421730504658) | |||
65262 | 65262 | 236229 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 582 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006153.79144 | 2106219.79715 | 37.763626235291206 | -122.421888263736 | (37.7636262352912, -122.421888263736) | |||
65417 | 65417 | 236225 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 720 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006208.17404 | 2105371.4094 | 37.7612998285493 | -122.421639910554 | (37.7612998285493, -122.421639910554) | |||
67515 | 67515 | 236247 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 533 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006207.2084800005 | 2106489.87514 | 37.764370818170796 | -122.421722694953 | (37.7643708181708, -122.421722694953) | |||
71751 | 71751 | 236230 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 580 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006152.8066300005 | 2106237.8056900003 | 37.7636756269614 | -122.421892949195 | (37.7636756269614, -122.421892949195) | |||
88484 | 88484 | 110114 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 463 TEXAS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013849.1 | 2104943.7 | 37.760553329450005 | -122.395183013377 | (37.76055332945, -122.395183013377) | ||||
91682 | 91682 | 112037 | Permitted Site 1 | Platanus racemosa :: California Sycamore 81 | 147 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775853 | 6001347.6 | 2108501.5 | 37.7696190072387 | -122.438674842908 | (37.7696190072387, -122.438674842908) | |
119312 | 119312 | 236211 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 332 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007085.90123 | 2096525.95828 | 37.737061678439204 | -122.417977144556 | (37.7370616784392, -122.417977144556) | |||
132923 | 132923 | 142617 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 725 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009365.5599 | 2120118.4807 | 37.801969311442704 | -122.411761862829 | (37.8019693114427, -122.411761862829) | |||
136888 | 136888 | 245048 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 156 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6000820.7156 | 2109539.1628 | 37.772438181941396 | -122.440571749918 | (37.7724381819414, -122.440571749918) | |||
150935 | 150935 | 236244 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 515 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006205.617980001 | 2106566.35806 | 37.7645807325428 | -122.42173362891701 | (37.7645807325428, -122.421733628917) | |||
151954 | 151954 | 236226 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 686 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006191.11311 | 2105618.20849 | 37.7619765189329 | -122.42171644736099 | (37.7619765189329, -122.421716447361) | |||
153099 | 153099 | 236237 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 542 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006148.19059 | 2106430.82622 | 37.7642053555191 | -122.421922626833 | (37.7642053555191, -122.421922626833) | |||
154907 | 154907 | 236208 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 147 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5997930.122930001 | 2105328.91939 | 37.7607128985969 | -122.45026700134501 | (37.7607128985969, -122.450267001345) | |||
156292 | 156292 | 236239 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 538 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006143.586130001 | 2106470.4953400004 | 37.7643140178894 | -122.42194137050501 | (37.7643140178894, -122.421941370505) | |||
156799 | 156799 | 236242 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 510 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006140.292769999 | 2106573.99555 | 37.7645980193081 | -122.42196011418301 | (37.7645980193081, -122.421960114183) | |||
163751 | 163751 | 236216 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 156 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007329.10102 | 2098137.78644 | 37.741501086420996 | -122.41725047612499 | (37.741501086421, -122.417250476125) | |||
168318 | 168318 | 70648 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 239 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 7 | 6004288.7476699995 | 2092010.61731 | 37.7245057379221 | -122.42732661165701 | (37.7245057379221, -122.427326611657) | ||
170364 | 170364 | 236215 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 158 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007320.88948 | 2098123.5529099996 | 37.7414615423295 | -122.417277860482 | (37.7414615423295, -122.417277860482) | |||
170720 | 170720 | 236220 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 780 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006220.52605 | 2105093.22352 | 37.7605366917327 | -122.421577431964 | (37.7605366917327, -122.421577431964) | |||
171552 | 171552 | 236221 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 766 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006214.88989 | 2105148.6562099997 | 37.7606885791281 | -122.42160086200501 | (37.7606885791281, -122.421600862005) | |||
184513 | 184513 | 236212 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 1440 Treat Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008697.402919999 | 2100727.7342 | 37.748689395406 | -122.41270239321001 | (37.748689395406, -122.41270239321) | |||
185075 | 185075 | 236233 | Undocumented 2 | Platanus racemosa :: California Sycamore 81 | 560 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006154.35869 | 2106335.36124 | 37.763943579046895 | -122.42189451133301 | (37.7639435790469, -122.421894511333) |
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");