Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25422 | 25422 | 240306 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 134 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003388.16897 | 2105086.9505 | 37.7603593535203 | -122.43137280722901 | (37.7603593535203, -122.431372807229) | |||
26786 | 26786 | 118668 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 4240 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5982392.892440001 | 2111033.85887 | 37.7754756009165 | -122.504425054608 | (37.7754756009165, -122.504425054608) | |||
30625 | 30625 | 240316 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 310 Liberty St | 48 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003835.66179 | 2103919.1699900003 | 37.75717825719121 | -122.429741845306 | (37.7571782571912, -122.429741845306) | |||
30649 | 30649 | 240300 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Clipper St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002726.96622 | 2100956.54522 | 37.748980749680705 | -122.433364440431 | (37.7489807496807, -122.433364440431) | |||
31729 | 31729 | 240297 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Clipper St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002954.68882 | 2100970.7991299997 | 37.74903280421721 | -122.432577993181 | (37.7490328042172, -122.432577993181) | |||
33136 | 33136 | 240242 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 351 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006956.98547 | 2096047.9435299998 | 37.73574189906971 | -122.41838898186701 | (37.7357418990697, -122.418388981867) | |||
35779 | 35779 | 136278 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2507 Larkin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006657.1862 | 2120015.9614 | 37.8015355122184 | -122.421126848223 | (37.8015355122184, -122.421126848223) | |||
37017 | 37017 | 240304 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 4185 25th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002908.0812800005 | 2101214.2225599997 | 37.7496985444673 | -122.43275654908899 | (37.7496985444673, -122.432756549089) | |||
41790 | 41790 | 240299 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Clipper St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002905.19719 | 2100966.1852 | 37.7490173286825 | -122.432748805907 | (37.7490173286825, -122.432748805907) | |||
47788 | 47788 | 240303 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 4185 25th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002751.21968 | 2101207.63188 | 37.7496715504081 | -122.43329851112101 | (37.7496715504081, -122.433298511121) | |||
51279 | 51279 | 240322 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 355 Masonic Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 3ft | 6000307.84049 | 2106905.2867400004 | 37.7651769992311 | -122.442156727144 | (37.7651769992311, -122.442156727144) | |||
53346 | 53346 | 240262 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 316 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006842.705 | 2097236.1672799997 | 37.7389980645073 | -122.41886834032302 | (37.7389980645073, -122.418868340323) | |||
53903 | 53903 | 240323 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 355 Masonic Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 3ft | 6000286.14451 | 2106902.79812 | 37.7651689296139 | -122.442231589424 | (37.7651689296139, -122.442231589424) | |||
54509 | 54509 | 240318 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 675 Sanchez St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6003704.19448 | 2104452.4816799997 | 37.7586351588904 | -122.430234556877 | (37.7586351588904, -122.430234556877) | |||
57304 | 57304 | 240309 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 3962 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003941.52222 | 2104241.24585 | 37.7580685950116 | -122.429398706289 | (37.7580685950116, -122.429398706289) | |||
58605 | 58605 | 123184 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 695 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993153.85102 | 2110782.22133 | 37.775411724638296 | -122.467182349196 | (37.7754117246383, -122.467182349196) | |||
58756 | 58756 | 240302 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 4185 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002703.68408 | 2101206.46382 | 37.7496656463533 | -122.43346280736601 | (37.7496656463533, -122.433462807366) | |||
58988 | 58988 | 240249 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005950.84346 | 2096924.8962700001 | 37.7380931253039 | -122.42192988707501 | (37.7380931253039, -122.421929887075) | |||
59516 | 59516 | 240248 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005969.6802 | 2096914.3608799998 | 37.7380652597989 | -122.421864010821 | (37.7380652597989, -122.421864010821) | |||
60357 | 60357 | 240277 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 877 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007991.30005 | 2102784.81683 | 37.7542980236532 | -122.415289699587 | (37.7542980236532, -122.415289699587) | |||
60937 | 60937 | 240295 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003122.09767 | 2100979.63955 | 37.7490665701795 | -122.431999723717 | (37.7490665701795, -122.431999723717) | |||
61908 | 61908 | 240245 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006078.33577 | 2096854.32708 | 37.737906547445995 | -122.42148407153 | (37.737906547446, -122.42148407153) | |||
63067 | 63067 | 240291 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2854 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009093.93311 | 2103358.72756 | 37.7559357619427 | -122.411517046282 | (37.7559357619427, -122.411517046282) | |||
64858 | 64858 | 179339 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 340 Tocoloma Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6012524.83653 | 2086861.1237299999 | 37.7108286189149 | -122.398494192156 | (37.7108286189149, -122.398494192156) | |||
67579 | 67579 | 240292 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2858 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009059.85584 | 2103354.08041 | 37.7559210904145 | -122.41163456879801 | (37.7559210904145, -122.411634568798) | |||
71105 | 71105 | 240301 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Clipper St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002699.64344 | 2100954.0355700003 | 37.7489723086445 | -122.43345874332701 | (37.7489723086445, -122.433458743327) | |||
71624 | 71624 | 240279 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1369 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006475.19087 | 2101646.9491 | 37.7510883747358 | -122.42045203565701 | (37.7510883747358, -122.420452035657) | |||
129558 | 129558 | 240310 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 310 Liberty St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6004042.34228 | 2103935.98204 | 37.757236120457705 | -122.429028262938 | (37.7572361204577, -122.429028262938) | |||
130604 | 130604 | 240317 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 755 Sanchez St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 3ft | 6003689.25928 | 2103856.71067 | 37.756998467428396 | -122.43024370570299 | (37.7569984674284, -122.430243705703) | |||
130914 | 130914 | 240307 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 362 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001774.63442 | 2103722.50053 | 37.7565213267127 | -122.43685558343 | (37.7565213267127, -122.43685558343) | |||
132723 | 132723 | 240325 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 704 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002296.51471 | 2108833.13942 | 37.770583543537704 | -122.43541631111601 | (37.7705835435377, -122.435416311116) | |||
132823 | 132823 | 197171 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 670 Illinois St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015971.35988 | 2105878.87725 | 37.763238920671704 | -122.38790827595301 | (37.7632389206717, -122.387908275953) | |||
132846 | 132846 | 240246 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006060.34827 | 2096863.0798900002 | 37.7379295664827 | -122.42154688469 | (37.7379295664827, -122.42154688469) | |||
132874 | 132874 | 240216 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 39 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004715.06571 | 2103431.30025 | 37.7558884396031 | -122.426665784406 | (37.7558884396031, -122.426665784406) | |||
133100 | 133100 | 240209 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 51 13th St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008179.63015 | 2108279.36025 | 37.769395356528605 | -122.41502728728202 | (37.7693953565286, -122.415027287282) | |||
134628 | 134628 | 240298 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Clipper St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002933.56975 | 2100969.69822 | 37.7490285837034 | -122.432650944393 | (37.7490285837034, -122.432650944393) | |||
144795 | 144795 | 240305 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1239 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003249.69063 | 2101046.30006 | 37.749256837043205 | -122.431563264742 | (37.7492568370432, -122.431563264742) | |||
154049 | 154049 | 240294 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 415 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6001830.81477 | 2103405.33682 | 37.7556536644037 | -122.436638590514 | (37.7556536644037, -122.436638590514) | |||
154861 | 154861 | 240313 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 310 Liberty St | 43 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6003879.74355 | 2103931.05559 | 37.757213388313296 | -122.42959024121001 | (37.7572133883133, -122.42959024121) | |||
158149 | 158149 | 240324 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2 Mars St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5999606.450540001 | 2105654.07611 | 37.761701489158604 | -122.444492726082 | (37.7617014891586, -122.444492726082) | |||
158404 | 158404 | 240312 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 310 Liberty St | 40 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6003905.5772400005 | 2103937.67287 | 37.7572330205097 | -122.42950137019699 | (37.7572330205097, -122.429501370197) | |||
160693 | 160693 | 240314 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 310 Liberty St | 46 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003848.60579 | 2103923.79505 | 37.75719168946971 | -122.42969740982299 | (37.7571916894697, -122.429697409823) | |||
161702 | 161702 | 240311 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 310 Liberty St | 39 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6003913.51755 | 2103937.88547 | 37.757234053829 | -122.42947392468001 | (37.757234053829, -122.42947392468) | |||
163784 | 163784 | 240319 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2253 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002534.36967 | 2107063.1831400003 | 37.765737183339205 | -122.434466999375 | (37.7657371833392, -122.434466999375) | |||
166413 | 166413 | 240293 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2956 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008497.1632199995 | 2103323.50605 | 37.7558055598955 | -122.413578388654 | (37.7558055598955, -122.413578388654) | |||
167928 | 167928 | 240247 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006044.64817 | 2096875.3158599997 | 37.7379622784463 | -122.421602036525 | (37.7379622784463, -122.421602036525) | |||
169941 | 169941 | 240278 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1369 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006475.64332 | 2101625.7090000003 | 37.7510300797762 | -122.420448963552 | (37.7510300797762, -122.420448963552) | |||
173896 | 173896 | 240214 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2044 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009526.406280001 | 2105174.74243 | 37.7609463769885 | -122.41014961181999 | (37.7609463769885, -122.41014961182) | |||
174577 | 174577 | 240308 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 602 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002991.75361 | 2104713.00594 | 37.759310117186295 | -122.43271710933399 | (37.7593101171863, -122.432717109334) | |||
178119 | 178119 | 240326 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 343 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004069.13295 | 2109034.20183 | 37.771236123981204 | -122.429299145951 | (37.7712361239812, -122.429299145951) | |||
178465 | 178465 | 240296 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Clipper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003086.5248 | 2100976.27468 | 37.7490553142577 | -122.43212249467399 | (37.7490553142577, -122.432122494674) | |||
178874 | 178874 | 240321 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 355 Masonic Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 3ft | 6000321.62859 | 2106905.9805400004 | 37.765179690012395 | -122.442109087376 | (37.7651796900124, -122.442109087376) | |||
179217 | 179217 | 240290 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 177 Powhattan Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 3ft | 6008169.50136 | 2098124.42294 | 37.741511638152204 | -122.414343705408 | (37.7415116381522, -122.414343705408) | |||
180346 | 180346 | 240320 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 355 Masonic Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6000338.4074800005 | 2106908.57124 | 37.76518775962779 | -122.442051239382 | (37.7651877596278, -122.442051239382) | |||
185288 | 185288 | 240315 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 310 Liberty St | 47 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003842.5075900005 | 2103921.28681 | 37.757184457125895 | -122.429718320863 | (37.7571844571259, -122.429718320863) |
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");