Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
62777 | 62777 | 49327 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 650 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 17 | Permit Number 46321 | 6013204.31889 | 2110464.18207 | 37.77567546267289 | -122.397800268992 | (37.7756754626729, -122.397800268992) | ||
154853 | 154853 | 93871 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 400-422X Tocoloma Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2010 12:00:00 AM | 17 | 3x3 | Permit Number 53366 | 6012449.21929 | 2086625.36701 | 37.7101770646038 | -122.398739010112 | (37.7101770646038, -122.398739010112) | |
158682 | 158682 | 65148 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 7330 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | 17 | Permit Number 27125 | 5984217.18812 | 2112512.23092 | 37.7796419140825 | -122.498223688652 | (37.7796419140825, -122.498223688652) | ||
27436 | 27436 | 244863 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 117 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6006906.41702 | 2098789.62543 | 37.7432671013094 | -122.418758192246 | (37.7432671013094, -122.418758192246) | |||
28270 | 28270 | 217447 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 395 Faxon Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 5994720.00419 | 2091109.04775 | 37.721484434931796 | -122.460338956771 | (37.7214844349318, -122.460338956771) | |||
31642 | 31642 | 217485 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 616 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 5998040.52965 | 2095018.98025 | 37.7324106420337 | -122.449142396404 | (37.7324106420337, -122.449142396404) | |||
31881 | 31881 | 199455 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1401 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6015625.9056 | 2108540.0716 | 37.7705268376657 | -122.389288938555 | (37.7705268376657, -122.389288938555) | |||
33585 | 33585 | 137505 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2521 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6007440.6556 | 2121042.48362 | 37.8043982179661 | -122.41848851434601 | (37.8043982179661, -122.418488514346) | |||
39171 | 39171 | 181241 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6011651.716019999 | 2087377.2812700002 | 37.712197204501294 | -122.401548169322 | (37.7121972045013, -122.401548169322) | |||
42207 | 42207 | 203193 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 47 Ceres St | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 2ft | 6013909.9694300005 | 2093925.2511200001 | 37.7303023748506 | -122.39420106345301 | (37.7303023748506, -122.394201063453) | |||
43226 | 43226 | 118483 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 8349 Geary Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5981073.18846 | 2112308.0171 | 37.7788963529663 | -122.50908477858499 | (37.7788963529663, -122.509084778585) | ||||
43297 | 43297 | 181269 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 37 Alpha St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6011324.26316 | 2088509.61111 | 37.7152880772715 | -122.402759532751 | (37.7152880772715, -122.402759532751) | |||
48922 | 48922 | 181271 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 40 Tomaso Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6009195.7252 | 2086405.87787 | 37.7093925805717 | -122.409968299499 | (37.7093925805717, -122.409968299499) | |||
50210 | 50210 | 182350 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1501 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5985255.7552 | 2104953.475 | 37.7589485494212 | -122.49407363959699 | (37.7589485494212, -122.494073639597) | |||
50846 | 50846 | 124333 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 172 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5995945.982919999 | 2113131.373 | 37.782022652324294 | -122.45769378533001 | (37.7820226523243, -122.45769378533) | |||
51345 | 51345 | 217449 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1038 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5995950.204940001 | 2090812.4665700002 | 37.7207407828315 | -122.45606508435101 | (37.7207407828315, -122.456065084351) | |||
52810 | 52810 | 217443 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 290 Granada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5995680.04385 | 2091933.48805 | 37.7238033305439 | -122.45707998906 | (37.7238033305439, -122.45707998906) | |||
59002 | 59002 | 181991 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2492 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5987080.0862 | 2098302.9304 | 37.740794524211104 | -122.48727584365601 | (37.7407945242111, -122.487275843656) | |||
62447 | 62447 | 217442 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 290 Granada Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5995679.46627 | 2091923.3244 | 37.723775390416 | -122.457081250809 | (37.723775390416, -122.457081250809) | |||
62584 | 62584 | 246277 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2027 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6006848.1122 | 2106486.1456 | 37.764396697974796 | -122.419505718376 | (37.7643966979748, -122.419505718376) | |||
66149 | 66149 | 181268 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1116 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6011841.7145 | 2089718.86782 | 37.7186373306372 | -122.401055901109 | (37.7186373306372, -122.401055901109) | |||
67531 | 67531 | 108537 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 400-422X Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 6012472.22935 | 2086696.28114 | 37.710373062836794 | -122.39866445541 | (37.7103730628368, -122.39866445541) | ||||
67886 | 67886 | 181273 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 328 Palmetto Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 6ft | 5993253.89248 | 2087254.87445 | 37.710817354905295 | -122.465127066954 | (37.7108173549053, -122.465127066954) | |||
72545 | 72545 | 247324 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2998 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6006942.8105 | 2106758.6304 | 37.765150210855204 | -122.419197512578 | (37.7651502108552, -122.419197512578) | |||
72808 | 72808 | 203199 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 690 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6013299.63411 | 2110362.29852 | 37.77540102106779 | -122.397463400913 | (37.7754010210678, -122.397463400913) | |||
77203 | 77203 | 199458 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6015604.63296 | 2108887.78773 | 37.77148041042871 | -122.389386807278 | (37.7714804104287, -122.389386807278) | |||
130131 | 130131 | 118484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 8349 Geary Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5981049.15965 | 2112307.0389 | 37.7788922504996 | -122.50916782963499 | (37.7788922504996, -122.509167829635) | ||||
132521 | 132521 | 199450 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1455 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6015636.18722 | 2108347.40225 | 37.7699983798625 | -122.389239918305 | (37.7699983798625, -122.389239918305) | |||
138237 | 138237 | 217446 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 395 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 5994720.49228 | 2091159.88936 | 37.7216240618899 | -122.46034095147101 | (37.7216240618899, -122.460340951471) | |||
149287 | 149287 | 199447 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6015650.089459999 | 2108116.21417 | 37.7693643586962 | -122.389175685108 | (37.7693643586962, -122.389175685108) | |||
150476 | 150476 | 187460 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4900 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6001022.9031 | 2090418.7219 | 37.7199495109601 | -122.438502172843 | (37.7199495109601, -122.438502172843) | |||
150487 | 150487 | 217444 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Holloway Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 5994706.40918 | 2091208.56862 | 37.721756913341295 | -122.46039315802601 | (37.7217569133413, -122.460393158026) | |||
151947 | 151947 | 244830 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3048 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007105.07881 | 2100690.50599 | 37.7484976752464 | -122.418206010299 | (37.7484976752464, -122.418206010299) | |||
156385 | 156385 | 246276 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2035 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6006852.6619 | 2106436.8579 | 37.764261621768206 | -122.419486485202 | (37.7642616217682, -122.419486485202) | |||
156480 | 156480 | 247960 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 14 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6010368.04056 | 2098905.3223200003 | 37.743779075439704 | -122.406796895161 | (37.7437790754397, -122.406796895161) | ||||
160793 | 160793 | 203207 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6013251.61126 | 2107360.27951 | 37.7671554771575 | -122.397418946544 | (37.7671554771575, -122.397418946544) | |||
161827 | 161827 | 203197 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 10ft | 6013808.49559 | 2116854.49545 | 37.7932554199655 | -122.39615821213499 | (37.7932554199655, -122.396158212135) | |||
161830 | 161830 | 115081 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1546 33RD AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 5985952.0 | 2104698.0 | 37.7582878007794 | -122.491646926351 | (37.7582878007794, -122.491646926351) | |||
164885 | 164885 | 199495 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6010059.4721800005 | 2112539.81003 | 37.78119901506621 | -122.408825592144 | (37.7811990150662, -122.408825592144) | |||
169757 | 169757 | 244829 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3038 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007106.51614 | 2100714.99964 | 37.748565010173294 | -122.418202776331 | (37.7485650101733, -122.418202776331) | |||
169980 | 169980 | 203189 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 889 Vermont St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6011337.056059999 | 2104206.57613 | 37.758389331013205 | -122.403819204816 | (37.7583893310132, -122.403819204816) | ||||
171385 | 171385 | 244815 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 451 Florida St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 9ft | 6009251.4171400005 | 2106274.41145 | 37.7639503995181 | -122.411178363391 | (37.7639503995181, -122.411178363391) | |||
171883 | 171883 | 187455 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4779 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6001879.4074 | 2091666.3162 | 37.7234238086089 | -122.435630746292 | (37.7234238086089, -122.435630746292) | |||
174438 | 174438 | 203177 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1301 Minnesota St | 61 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6015358.55131 | 2102374.09965 | 37.7535815832452 | -122.38978298111401 | (37.7535815832452, -122.389782981114) | ||||
184081 | 184081 | 244828 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3032 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007106.122 | 2100726.18303 | 37.7485956950473 | -122.418204932034 | (37.7485956950473, -122.418204932034) | |||
188646 | 188646 | 100874 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 995 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 6010596.8170300005 | 2112015.71985 | 37.7797900696951 | -122.40692968637501 | (37.7797900696951, -122.406929686375) | ||||
32721 | 32721 | 217463 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 50 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 5996525.6642 | 2088997.67416 | 37.7157908018682 | -122.45394491554701 | (37.7157908018682, -122.453944915547) | |||
35685 | 35685 | 244827 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1450x Dolores St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6005245.250469999 | 2099669.70272 | 37.745589922449604 | -122.424564667746 | (37.7455899224496, -122.424564667746) | ||||
118576 | 118576 | 28468 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400X Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 17 | 3X3 | 5991972.677497401 | 2094408.8386932998 | 37.7303864239 | -122.470075778183 | (37.7303864239, -122.470075778183) | ||
135771 | 135771 | 244825 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 500x Dolores St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6004935.84357 | 2105248.4287099997 | 37.760890325850795 | -122.42603161307501 | (37.7608903258508, -122.426031613075) | ||||
180976 | 180976 | 217454 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 5996047.542640001 | 2089003.42322 | 37.7157791619486 | -122.45559792969601 | (37.7157791619486, -122.455597929696) |
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");