Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2725 | 2725 | 141994 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 0ft | 6003989.735 | 2111607.5325 | 37.7782973627546 | -122.429757359707 | (37.7782973627546, -122.429757359707) | |||
3262 | 3262 | 253382 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
8983 | 8983 | 23748 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 38 | 4x4 | 6003941.8583 | 2111953.2204 | 37.779243824898295 | -122.42994764790701 | (37.7792438248983, -122.429947647907) | |||
19125 | 19125 | 28638 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.777378207850795 | -122.42957257421499 | (37.7773782078508, -122.429572574215) | |||
20858 | 20858 | 14357 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002936.44481 | 2106655.1660700003 | 37.764639683102395 | -122.43304715512899 | (37.7646396831024, -122.433047155129) | |||
34669 | 34669 | 128830 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 435 Locust St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997658.68844 | 2114896.31526 | 37.7869669572999 | -122.451896004506 | (37.7869669572999, -122.451896004506) | |||
53143 | 53143 | 225823 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6011090.95025 | 2102601.58592 | 37.7539686316657 | -122.404557371938 | (37.7539686316657, -122.404557371938) | |||
53618 | 53618 | 138097 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1716 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003549.5370000005 | 2114696.9008 | 37.7867550577771 | -122.43150077205 | (37.7867550577771, -122.43150077205) | |||
55255 | 55255 | 218981 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991484.23887 | 2094055.3535200001 | 37.7293875934485 | -122.47173861195 | (37.7293875934485, -122.47173861195) | |||
63548 | 63548 | 140250 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 707 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 5999174.9773 | 2110335.2771 | 37.7745302567897 | -122.446321776898 | (37.7745302567897, -122.446321776898) | |||
65804 | 65804 | 245998 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1211 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999402.4121 | 2108663.858 | 37.769953951156 | -122.445414832365 | (37.769953951156, -122.445414832365) | |||
70390 | 70390 | 142068 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1000 WEBSTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003893.9859 | 2112297.2467 | 37.780185724477604 | -122.43013780751001 | (37.7801857244776, -122.43013780751) | |||
71343 | 71343 | 138432 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1601 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003502.2144 | 2114406.5958 | 37.785955271305 | -122.43164376298 | (37.785955271305, -122.43164376298) | |||
73871 | 73871 | 247012 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Valley St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6002599.35575 | 2099199.8727700002 | 37.744150098849204 | -122.43368018521299 | (37.7441500988492, -122.433680185213) | ||||
74402 | 74402 | 225834 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6010880.09664 | 2102425.6694099996 | 37.7534738174881 | -122.40527417026001 | (37.7534738174881, -122.40527417026) | |||
77445 | 77445 | 121460 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 58 Liberty St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005944.89012346 | 2104064.54703238 | 37.757696640503895 | -122.42245763762101 | (37.7576966405039, -122.422457637621) | |||||
79285 | 79285 | 107390 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 773951 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | ||||
96160 | 96160 | 23803 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1160 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6003835.7537369 | 2112705.7306783 | 37.7813040215007 | -122.430368411811 | (37.7813040215007, -122.430368411811) | |||
96659 | 96659 | 10421 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1219X Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999421.35342 | 2108678.34127 | 37.7699947998181 | -122.44535035645 | (37.7699947998181, -122.44535035645) | |||
96681 | 96681 | 52015 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 282 29th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.42625790812401 | (37.7437962026999, -122.426257908124) | |||
110605 | 110605 | 23778 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1006 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1992 12:00:00 AM | 40 | 3X3 | 6003898.5093138 | 2112170.2011072 | 37.779837145034705 | -122.430113093173 | (37.7798371450347, -122.430113093173) | ||
110610 | 110610 | 23784 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1010 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6003903.8361546 | 2112182.8886988997 | 37.7798722837048 | -122.430095570639 | (37.7798722837048, -122.430095570639) | |||
112090 | 112090 | 23724 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 802X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6003990.015324599 | 2111477.493419 | 37.7779403234669 | -122.429747112563 | (37.7779403234669, -122.429747112563) | |||
116039 | 116039 | 14534 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
148323 | 148323 | 128833 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2610 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6002164.86487 | 2116089.53084 | 37.7905002856984 | -122.436391110584 | (37.7905002856984, -122.436391110584) | |||
149834 | 149834 | 246978 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 201 Noe St | 4 | : 4 | Tree 1 | Private 1 | 21 | Width 8ft | 6002919.18964 | 2107068.61942 | 37.765773946726604 | -122.433136379546 | (37.7657739467266, -122.433136379546) | |||
151797 | 151797 | 139228 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1401 WEBSTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003615.5139999995 | 2113580.969 | 37.7836947290906 | -122.43119282453002 | (37.7836947290906, -122.43119282453) | |||
154368 | 154368 | 103290 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6011095.04469 | 2121443.6930299997 | 37.8057048879202 | -122.405870402816 | (37.8057048879202, -122.405870402816) | |||
158033 | 158033 | 225852 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 58 Liberty St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 9ft | 6005926.4648400005 | 2104057.0106 | 37.7576749077845 | -122.422520824396 | (37.7576749077845, -122.422520824396) | |||
161108 | 161108 | 247739 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6001290.39565 | 2108693.08102 | 37.7701417866389 | -122.43888644146799 | (37.7701417866389, -122.438886441468) | ||||
171482 | 171482 | 246263 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2298 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002944.8745 | 2106661.4314 | 37.7646573643321 | -122.433018446764 | (37.7646573643321, -122.433018446764) | |||
185136 | 185136 | 225866 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 5ft | 6006516.03586 | 2098775.00428 | 37.7432049671495 | -122.42010699366199 | (37.7432049671495, -122.420106993662) |
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");