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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13075 | 13075 | 15809 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4971 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 16 | 3x3 | 6000847.9253 | 2090031.6718 | 37.7188768038041 | -122.43907928418501 | (37.7188768038041, -122.439079284185) | ||
13867 | 13867 | 102421 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 101 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010161.06831 | 2112431.87946 | 37.780908353287394 | -122.40846650275199 | (37.7809083532874, -122.408466502752) | |||
14256 | 14256 | 102418 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 201 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010625.41098 | 2111944.3761400003 | 37.7795957765601 | -122.406825737323 | (37.7795957765601, -122.406825737323) | |||
15166 | 15166 | 102426 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010110.9527900005 | 2112392.33205 | 37.780796958746 | -122.408637087058 | (37.780796958746, -122.408637087058) | |||
16698 | 16698 | 102419 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 201 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010609.192559999 | 2111959.7498 | 37.7796370815369 | -122.40688292791799 | (37.7796370815369, -122.406882927918) | |||
16718 | 16718 | 102428 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 184 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010438.87034 | 2112046.078 | 37.779864586616505 | -122.407478236832 | (37.7798645866165, -122.407478236832) | |||
21746 | 21746 | 28469 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400X Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 16 | 3x3 | 5991803.10743 | 2094513.5211900002 | 37.7306640516002 | -122.47066962200199 | (37.7306640516002, -122.470669622002) | ||
27968 | 27968 | 199441 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013426.97714 | 2107527.99953 | 37.767625761459705 | -122.39682413764 | (37.7676257614597, -122.39682413764) | |||
31002 | 31002 | 203209 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013274.2221800005 | 2107384.36901 | 37.767222880462796 | -122.39734242771401 | (37.7672228804628, -122.397342427714) | |||
32638 | 32638 | 199456 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015610.82208 | 2108808.9255 | 37.77126421521471 | -122.38935989056299 | (37.7712642152147, -122.389359890563) | |||
32830 | 32830 | 203205 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013159.72459 | 2107270.14751 | 37.7669028782866 | -122.397730448328 | (37.7669028782866, -122.397730448328) | |||
34846 | 34846 | 243945 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 142 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007159.400359999 | 2109389.15821 | 37.7723852147468 | -122.41863493565901 | (37.7723852147468, -122.418634935659) | |||
40393 | 40393 | 244837 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6006731.37022 | 2107461.01908 | 37.7670668948411 | -122.41997868286998 | (37.7670668948411, -122.41997868287) | |||
45056 | 45056 | 217450 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 127 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5996493.32654 | 2090728.3649400002 | 37.720541019141706 | -122.454181619786 | (37.7205410191417, -122.454181619786) | |||
46987 | 46987 | 102441 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1007X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010078.92624 | 2112396.7113200002 | 37.7808071894337 | -122.408748191999 | (37.7808071894337, -122.408748191999) | |||
50542 | 50542 | 56949 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/27/1974 12:00:00 AM | 16 | Permit Number 14201 | 6010069.06775 | 2112529.00786 | 37.7811698923233 | -122.408791633752 | (37.7811698923233, -122.408791633752) | ||
51238 | 51238 | 244854 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 633 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6010136.631019999 | 2105337.9481099998 | 37.7614286878927 | -122.40805061214199 | (37.7614286878927, -122.408050612142) | |||
54749 | 54749 | 137504 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2521 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6007440.32409 | 2121045.18765 | 37.8044056238841 | -122.41848985342399 | (37.8044056238841, -122.418489853424) | |||
59148 | 59148 | 49326 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 690 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 16 | Permit Number 46321 | 6013271.22314 | 2110393.4980200003 | 37.7754851058895 | -122.39756387047501 | (37.7754851058895, -122.397563870475) | ||
59377 | 59377 | 199500 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 184 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6010448.06676 | 2112033.83872 | 37.7798314951708 | -122.40744555907601 | (37.7798314951708, -122.407445559076) | |||
65089 | 65089 | 199459 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015601.45578 | 2108929.3451900003 | 37.7715943419254 | -122.389400699999 | (37.7715943419254, -122.389400699999) | |||
65873 | 65873 | 199487 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015516.37079 | 2108841.48357 | 37.7713483755645 | -122.38968887873399 | (37.7713483755645, -122.389688878734) | |||
66564 | 66564 | 199468 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015459.06425 | 2109878.23066 | 37.77419187628129 | -122.38995953961799 | (37.7741918762813, -122.389959539618) | |||
69461 | 69461 | 49325 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 690 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 16 | Permit Number 46321 | 6013241.30936 | 2110424.30224 | 37.7755680215912 | -122.397669511153 | (37.7755680215912, -122.397669511153) | ||
74492 | 74492 | 187444 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 5025 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6000645.4005 | 2089706.7167 | 37.7179730245698 | -122.43975604576299 | (37.7179730245698, -122.439756045763) | |||
146398 | 146398 | 199506 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 121 07th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6009672.01904 | 2111627.24224 | 37.778671609854 | -122.410101548456 | (37.778671609854, -122.410101548456) | |||
154699 | 154699 | 244850 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 300 San Carlos St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006698.31057 | 2104297.86513 | 37.7583797514472 | -122.41986855099199 | (37.7583797514472, -122.419868550992) | |||
156855 | 156855 | 199448 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015646.98681 | 2108156.1809400003 | 37.7694739267051 | -122.389189208225 | (37.7694739267051, -122.389189208225) | |||
162092 | 162092 | 244864 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 367 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6006463.24291 | 2097111.21935 | 37.7386336115438 | -122.420171483141 | (37.7386336115438, -122.420171483141) | |||
165973 | 165973 | 245406 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3158 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6006782.0924 | 2100045.1278 | 37.7467074273685 | -122.419277118857 | (37.7467074273685, -122.419277118857) | |||
173858 | 173858 | 246344 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1800 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6006725.8095 | 2107628.1183 | 37.7675253965504 | -122.420009776033 | (37.7675253965504, -122.420009776033) | |||
174835 | 174835 | 199436 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013326.10031 | 2107431.53826 | 37.767355284933 | -122.39716629548599 | (37.767355284933, -122.397166295486) | |||
177521 | 177521 | 199484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015511.156140001 | 2108923.75767 | 37.7715739929801 | -122.38971266400401 | (37.7715739929801, -122.389712664004) | |||
180435 | 180435 | 187439 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4620 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002001.2284 | 2091970.7345 | 37.7242665912846 | -122.435231397877 | (37.7242665912846, -122.435231397877) | |||
184866 | 184866 | 199501 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1012 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6010462.04247 | 2111980.9380099997 | 37.7796870244685 | -122.40739348023199 | (37.7796870244685, -122.407393480232) | |||
185654 | 185654 | 243921 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 755 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6009331.41321 | 2104703.53182 | 37.759641608198706 | -122.41079073042101 | (37.7596416081987, -122.410790730421) | |||
46093 | 46093 | 181993 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2488 30th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5987080.4247 | 2098320.1899 | 37.7408419339653 | -122.487275940676 | (37.7408419339653, -122.487275940676) | |||
157013 | 157013 | 181997 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2478 30th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5987077.3789 | 2098383.8132 | 37.741016449074294 | -122.487291143841 | (37.7410164490743, -122.487291143841) | |||
162871 | 162871 | 183526 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2550 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5987093.1088 | 2097910.6765 | 37.739718258195296 | -122.487202013829 | (37.7397182581953, -122.487202013829) | |||
72078 | 72078 | 244818 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 150x Dolores St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6004818.66782 | 2107349.3149200003 | 37.7666522354392 | -122.426586475898 | (37.7666522354392, -122.426586475898) | ||||
129607 | 129607 | 244817 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 150x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6004826.7042 | 2107360.62058 | 37.7666837323921 | -122.426559484554 | (37.7666837323921, -122.426559484554) | ||||
133845 | 133845 | 247651 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 7 | : 4 | Tree 1 | Private 1 | 16 | Width 5ft | 6001551.81383 | 2108298.34241 | 37.7690728021064 | -122.437953921852 | (37.7690728021064, -122.437953921852) | |||
24537 | 24537 | 217484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 554 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5997767.10933 | 2095284.1068799999 | 37.7331229743458 | -122.450106772723 | (37.7331229743458, -122.450106772723) | ||||
41733 | 41733 | 203194 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1998 Revere Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6012994.12431 | 2096000.54159 | 37.7359497449792 | -122.3975127773 | (37.7359497449792, -122.3975127773) | ||||
130191 | 130191 | 217445 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 395 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5994721.42442 | 2091190.6109200001 | 37.721708469553 | -122.46033995415199 | (37.721708469553, -122.460339954152) | |||
137787 | 137787 | 217451 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 248 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5994521.5845800005 | 2089667.4223099998 | 37.7175146601568 | -122.460920402674 | (37.7175146601568, -122.460920402674) | ||||
147977 | 147977 | 181274 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 328 Palmetto Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 5993286.62087 | 2087254.83892 | 37.7108191445702 | -122.46501394844 | (37.7108191445702, -122.46501394844) | |||
158497 | 158497 | 181270 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 37 Alpha St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 6011335.815769999 | 2088522.23161 | 37.715323375648296 | -122.40272048866899 | (37.7153233756483, -122.402720488669) | |||
181853 | 181853 | 201499 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1038 Innes Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6018416.79538 | 2095102.4725900001 | 37.7337842710237 | -122.37870189547701 | (37.7337842710237, -122.378701895477) | ||||
69642 | 69642 | 243914 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 569 Peralta Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 4ft | 6009859.0295 | 2098846.17451 | 37.743588174566895 | -122.408552771098 | (37.7435881745669, -122.408552771098) | |||
42000 | 42000 | 181235 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100x Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 6ft | 6011766.34512 | 2087531.33968 | 37.7126266136928 | -122.401162793634 | (37.7126266136928, -122.401162793634) | |||
165812 | 165812 | 217459 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 5996291.57105 | 2089000.5851900002 | 37.715785369974796 | -122.45475425500099 | (37.7157853699748, -122.454754255001) | |||
174904 | 174904 | 217433 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 501x Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 4ft | 5998496.43118 | 2094696.04115 | 37.731549992634605 | -122.447543007012 | (37.7315499926346, -122.447543007012) | |||
179057 | 179057 | 217462 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 5996487.36469 | 2088998.4739599999 | 37.7157908018916 | -122.454077353311 | (37.7157908018916, -122.454077353311) |
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");