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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1516 | 1516 | 243951 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007014.66541 | 2110083.11128 | 37.774282494675795 | -122.419184822535 | (37.7742824946758, -122.419184822535) | |
1533 | 1533 | 243953 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007037.92355 | 2109985.61989 | 37.7740161163944 | -122.41909745161301 | (37.7740161163944, -122.419097451613) | |
12148 | 12148 | 15777 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4826 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2013 12:00:00 AM | 14 | 3X3 | 6001241.8395 | 2090763.6886 | 37.7209091632567 | -122.43777008073401 | (37.7209091632567, -122.437770080734) | ||
13194 | 13194 | 28543 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5050 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 14 | 3X3 | 6000463.3087 | 2089534.8309 | 37.717490698541106 | -122.44037313550601 | (37.7174906985411, -122.440373135506) | ||
28662 | 28662 | 247652 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 8 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001539.54665 | 2108297.82153 | 37.7690706742937 | -122.437996315894 | (37.7690706742937, -122.437996315894) | |||
31746 | 31746 | 243915 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 527 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6009846.89705 | 2099022.9743 | 37.744072948723996 | -122.408607191783 | (37.744072948724, -122.408607191783) | |||
32681 | 32681 | 181225 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012142.64872 | 2087966.32727 | 37.713841988985 | -122.399892688298 | (37.713841988985, -122.399892688298) | |||
33231 | 33231 | 181999 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2474 30th Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 5987078.0557 | 2098396.6732 | 37.7410517986936 | -122.487289748097 | (37.7410517986936, -122.487289748097) | |||
33501 | 33501 | 199465 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015601.020959999 | 2107350.5744 | 37.7672593587506 | -122.389291940488 | (37.7672593587506, -122.389291940488) | |||
43387 | 43387 | 247655 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 11 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001504.48718 | 2108295.83572 | 37.769063227919105 | -122.43811744198601 | (37.7690632279191, -122.438117441986) | |||
44505 | 44505 | 181226 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012120.3534699995 | 2087937.9432299999 | 37.713762809074 | -122.39996775739901 | (37.713762809074, -122.399967757399) | |||
48172 | 48172 | 181243 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6011666.62378 | 2087363.7492099998 | 37.7121608800013 | -122.40149569296699 | (37.7121608800013, -122.401495692967) | |||
50033 | 50033 | 246413 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2214 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6006845.3803 | 2105424.2757 | 37.7614808975479 | -122.419439828815 | (37.7614808975479, -122.419439828815) | |||
51983 | 51983 | 203178 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1301 Minnesota St | 65 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6015363.87101 | 2102334.663 | 37.75347359354279 | -122.38976182994 | (37.7534735935428, -122.38976182994) | ||||
52425 | 52425 | 247649 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 5 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001576.55462 | 2108299.96127 | 37.7690786539981 | -122.437868461073 | (37.7690786539981, -122.437868461073) | |||
60522 | 60522 | 247645 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001626.8491400005 | 2108303.83597 | 37.7690921528084 | -122.437694773193 | (37.7690921528084, -122.437694773193) | |||
60563 | 60563 | 181224 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012163.826230001 | 2087990.6147200002 | 37.713909858116104 | -122.39982119490601 | (37.7139098581161, -122.399821194906) | |||
60777 | 60777 | 181229 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012059.81705 | 2087859.8714700001 | 37.713545064337296 | -122.400171515023 | (37.7135450643373, -122.400171515023) | |||
62683 | 62683 | 33555 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 14 | Permit Number 37664 | 5996213.16627 | 2110420.4696400003 | 37.7745945717567 | -122.456573356196 | (37.7745945717567, -122.456573356196) | ||
69875 | 69875 | 244858 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 431x Precita Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6009361.35634 | 2100204.6117700003 | 37.747290259852 | -122.41036950684601 | (37.747290259852, -122.410369506846) | |||
103153 | 103153 | 101530 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1030 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x3 | 5995974.8 | 2090771.5 | 37.720629710016205 | -122.455977107218 | (37.7206297100162, -122.455977107218) | |||
122621 | 122621 | 101531 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1030 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x3 | 5995974.8 | 2090771.5 | 37.720629710016205 | -122.455977107218 | (37.7206297100162, -122.455977107218) | |||
131126 | 131126 | 187462 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4900 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000950.9727 | 2090300.4634 | 37.7196207078773 | -122.438742341247 | (37.7196207078773, -122.438742341247) | |||
131560 | 131560 | 183162 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2401 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5982053.1688 | 2098706.8368 | 37.7416091165514 | -122.50468665850401 | (37.7416091165514, -122.504686658504) | |||
136431 | 136431 | 181236 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100x Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6011740.78696 | 2087511.07022 | 37.712569531933 | -122.401249707721 | (37.712569531933, -122.401249707721) | |||
146874 | 146874 | 203201 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6013028.4198 | 2107143.70013 | 37.76654836912579 | -122.398175741313 | (37.7665483691258, -122.398175741313) | |||
146999 | 146999 | 243913 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 569 Peralta Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 6009859.67236 | 2098840.49646 | 37.743572619883 | -122.40855014778299 | (37.743572619883, -122.408550147783) | |||
147416 | 147416 | 244839 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6006735.47347 | 2107413.5556099997 | 37.766936802527205 | -122.419961121814 | (37.7669368025272, -122.419961121814) | |||
150225 | 150225 | 248044 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 38 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6010553.661280001 | 2099412.7108 | 37.7451826383612 | -122.40619079978501 | (37.7451826383612, -122.406190799785) | ||||
156279 | 156279 | 199472 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015475.23167 | 2109575.21201 | 37.7733607507341 | -122.389882442542 | (37.7733607507341, -122.389882442542) | |||
157229 | 157229 | 244857 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 431x Precita Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6009346.66532 | 2100208.95898 | 37.7473013727717 | -122.410420614427 | (37.7473013727717, -122.410420614427) | |||
157679 | 157679 | 245980 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2401 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6006965.6446 | 2104339.4738 | 37.758509056264295 | -122.41894694069799 | (37.7585090562643, -122.418946940698) | |||
160713 | 160713 | 203202 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6013039.197000001 | 2107156.64294 | 37.7665845074832 | -122.398139372753 | (37.7665845074832, -122.398139372753) | |||
164288 | 164288 | 199505 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 121 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009689.53245 | 2111610.6533 | 37.7786270421403 | -122.41003979110901 | (37.7786270421403, -122.410039791109) | |||
164636 | 164636 | 199489 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1500 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015558.23281 | 2108115.16925 | 37.7693563969951 | -122.389493342767 | (37.7693563969951, -122.389493342767) | |||
165364 | 165364 | 203196 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 10ft | 6013792.252169999 | 2116838.17263 | 37.7932096975269 | -122.39621327133301 | (37.7932096975269, -122.396213271333) | |||
165843 | 165843 | 181227 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012100.147000001 | 2087910.54687 | 37.713686457546395 | -122.400035676032 | (37.7136864575464, -122.400035676032) | |||
166180 | 166180 | 244836 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6006731.22327 | 2107487.4499 | 37.7671394593552 | -122.419981066981 | (37.7671394593552, -122.419981066981) | |||
167542 | 167542 | 181237 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100x Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6011709.60443 | 2087494.2224299998 | 37.712521531527294 | -122.40135630166 | (37.7125215315273, -122.40135630166) | |||
168793 | 168793 | 244848 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 300 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006695.182 | 2104327.73391 | 37.7584615879395 | -122.41988149046499 | (37.7584615879395, -122.419881490465) | |||
175922 | 175922 | 199480 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015500.51903 | 2109136.7123 | 37.7721581296349 | -122.389764335453 | (37.7721581296349, -122.389764335453) | |||
183212 | 183212 | 181247 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6011190.75371 | 2087265.8089 | 37.7118653915605 | -122.40313356348899 | (37.7118653915605, -122.403133563489) | |||
183629 | 183629 | 244832 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3048 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007100.0993800005 | 2100660.4969599997 | 37.748414996954395 | -122.418221101822 | (37.7484149969544, -122.418221101822) | |||
54279 | 54279 | 33558 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2001 12:00:00 AM | 14 | Permit Number 37664 | 5996252.18034 | 2110425.94618 | 37.7746118487481 | -122.456438795749 | (37.7746118487481, -122.456438795749) | |
155287 | 155287 | 46765 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 46 Admiral Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 14 | Permit Number 44862 | 6003326.43729 | 2094178.5740200002 | 37.7304039901516 | -122.430807830618 | (37.7304039901516, -122.430807830618) |
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");