Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29712 | 29712 | 244826 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 500x Dolores St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6004940.864159999 | 2105188.02891 | 37.760724766043 | -122.42600994929501 | (37.760724766043, -122.426009949295) | ||||
54238 | 54238 | 181285 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 55 Stoneyford Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6006176.18741 | 2094039.87064 | 37.7301841895453 | -122.420945981966 | (37.7301841895453, -122.420945981966) | ||||
55931 | 55931 | 181279 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 164 Otsego Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6000580.61226 | 2092352.75488 | 37.725234756259105 | -122.440169631943 | (37.7252347562591, -122.440169631943) | ||||
63685 | 63685 | 84744 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 20 | Permit No. 49304 | 6015122.21866 | 2111558.9441 | 37.7787880531604 | -122.391242266936 | (37.7787880531604, -122.391242266936) | ||
74085 | 74085 | 218197 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399 Claremont Blvd | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5993480.75094 | 2097837.1493599997 | 37.7398867790468 | -122.465111106706 | (37.7398867790468, -122.465111106706) | ||||
154180 | 154180 | 84748 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 20 | Permit No. 49304 | 6015067.98121 | 2111507.0743 | 37.7786426202078 | -122.391426270004 | (37.7786426202078, -122.391426270004) | ||
173440 | 173440 | 247055 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 500 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6002656.51125 | 2099493.5306599997 | 37.7449596577675 | -122.433503535865 | (37.7449596577675, -122.433503535865) | ||||
19337 | 19337 | 28465 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400X Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 20 | 3X3 | 5991890.46795 | 2094463.9111900001 | 37.7305328863621 | -122.470363994616 | (37.7305328863621, -122.470363994616) | ||
110383 | 110383 | 28467 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400X Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 20 | 3X3 | 5991972.677497401 | 2094408.8386932998 | 37.7303864239 | -122.470075778183 | (37.7303864239, -122.470075778183) | ||
102666 | 102666 | 121415 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 366 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6006692.0 | 2103986.0 | 37.757523086513096 | -122.419868246156 | (37.7575230865131, -122.419868246156) | |||
146701 | 146701 | 102431 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 982 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6010575.8749400005 | 2112088.03468 | 37.7799874573922 | -122.40700723309601 | (37.7799874573922, -122.407007233096) | |||
129269 | 129269 | 28636 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 955 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 20 | 5X5 | 5996968.04232 | 2091607.5946900002 | 37.7229823879791 | -122.452604107446 | (37.7229823879791, -122.452604107446) | ||
6773 | 6773 | 45307 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 561 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 20 | 5x5 | Permit Number 44145 | 6000554.5197 | 2110946.4965 | 37.7762872030081 | -122.44159355669599 | (37.7762872030081, -122.441593556696) |
27550 | 27550 | 217457 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 5996170.11239 | 2089001.42717 | 37.7157807141869 | -122.455174130483 | (37.7157807141869, -122.455174130483) | |||
174465 | 174465 | 217456 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 5996127.26791 | 2089002.03978 | 37.715779938072295 | -122.455322264126 | (37.7157799380723, -122.455322264126) | |||
66362 | 66362 | 202177 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 2ft | 6013132.229119999 | 2093003.70662 | 37.7277287417687 | -122.396825253678 | (37.7277287417687, -122.396825253678) | |||
62292 | 62292 | 217468 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 870 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5992024.3496199995 | 2105944.9682299998 | 37.76206465879179 | -122.47073710353999 | (37.7620646587918, -122.47073710354) | |||
161568 | 161568 | 217470 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 870 Judah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5991963.05013 | 2105942.50613 | 37.7620543534437 | -122.47094893346501 | (37.7620543534437, -122.470948933465) | |||
165440 | 165440 | 217469 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 870 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5991984.27655 | 2105943.70129 | 37.7620588626465 | -122.470875607232 | (37.7620588626465, -122.470875607232) | |||
165669 | 165669 | 244853 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 641 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6010137.48456 | 2105315.52441 | 37.7613671652728 | -122.408046078658 | (37.7613671652728, -122.408046078658) | |||
171005 | 171005 | 203191 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 242 Texas St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 3ft | 6013713.77325 | 2105932.1269099996 | 37.7632598065236 | -122.395720307939 | (37.7632598065236, -122.395720307939) | |||
183675 | 183675 | 217467 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 870 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5992049.56384 | 2105945.3755799998 | 37.762067235345796 | -122.47064992776801 | (37.7620672353458, -122.470649927768) | |||
34386 | 34386 | 199497 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 72 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6010024.2102 | 2112481.0403 | 37.7810356721041 | -122.408943433887 | (37.7810356721041, -122.408943433887) | |||
38867 | 38867 | 199498 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1008 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6010028.2471900005 | 2112434.38373 | 37.780907790314394 | -122.40892617503 | (37.7809077903144, -122.40892617503) | |||
52792 | 52792 | 217434 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 501x Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 4ft | 5998476.13751 | 2094696.7655200001 | 37.7315508218058 | -122.44761321800101 | (37.7315508218058, -122.447613218001) | |||
148787 | 148787 | 137501 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2317 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6000760.82972 | 2119605.96149 | 37.8000756013698 | -122.44150141455401 | (37.8000756013698, -122.441501414554) | |||
27009 | 27009 | 199444 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6015656.62698 | 2107992.23345 | 37.769024297155205 | -122.389144413879 | (37.7690242971552, -122.389144413879) | |||
52239 | 52239 | 199453 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1401 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6015629.79574 | 2108466.51232 | 37.7703250756792 | -122.389270345061 | (37.7703250756792, -122.389270345061) | |||
67150 | 67150 | 199493 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 281 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6010934.97193 | 2111623.29262 | 37.7787314723253 | -122.405732204886 | (37.7787314723253, -122.405732204886) | |||
77197 | 77197 | 199469 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6015461.94108 | 2109832.83992 | 37.7740674029079 | -122.389946416702 | (37.7740674029079, -122.389946416702) | |||
117029 | 117029 | 199490 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 483 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6010121.32315 | 2112524.17075 | 37.7811595375133 | -122.408610513875 | (37.7811595375133, -122.408610513875) | |||
45408 | 45408 | 244813 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 45 Hoff St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 6ft | 6006570.0042 | 2106423.3785 | 37.7642086856934 | -122.42046316294599 | (37.7642086856934, -122.420463162946) | |||
153688 | 153688 | 217480 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 6ft | 5999643.16837 | 2095215.32408 | 37.7330412898258 | -122.44361581691099 | (37.7330412898258, -122.443615816911) | |||
25274 | 25274 | 203174 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 331 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 6014370.72377 | 2105559.7788 | 37.7622739427176 | -122.39342205628999 | (37.7622739427176, -122.39342205629) | |||
156331 | 156331 | 202029 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1331 Fitzgerald Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 6013954.19623 | 2091006.8516900002 | 37.7222914964254 | -122.39384396154199 | (37.7222914964254, -122.393843961542) | |||
188775 | 188775 | 246732 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 101 Ripley St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 6008546.25114 | 2099104.34804 | 37.7442234529633 | -122.41311030320101 | (37.7442234529633, -122.413110303201) |
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");