Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
156118 | 156118 | 199479 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015497.26335 | 2109186.83428 | 37.772295573003895 | -122.389779098738 | (37.7722955730039, -122.389779098738) | |||
156855 | 156855 | 199448 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015646.98681 | 2108156.1809400003 | 37.7694739267051 | -122.389189208225 | (37.7694739267051, -122.389189208225) | |||
9752 | 9752 | 173678 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
13652 | 13652 | 21866 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015620.2045 | 2106919.86703 | 37.766077793471396 | -122.38919550889099 | (37.7660777934714, -122.389195508891) | ||
17262 | 17262 | 25065 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005108.04672 | 2102186.2977 | 37.7524921625065 | -122.42521813940901 | (37.7524921625065, -122.425218139409) | |||
24199 | 24199 | 217439 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 601x Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 4ft | 5997627.34725 | 2094709.1564 | 37.7315362986663 | -122.450548529595 | (37.7315362986663, -122.450548529595) | |||
24682 | 24682 | 203198 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 10ft | 6013828.57328 | 2116873.69458 | 37.7933092533841 | -122.39609008760401 | (37.7933092533841, -122.396090087604) | |||
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) | |||
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) | ||||
34652 | 34652 | 243942 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Church St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 3ft | 6004361.46086 | 2104388.80864 | 37.7584975338534 | -122.427956893407 | (37.7584975338534, -122.427956893407) | |||
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) | ||||
38749 | 38749 | 181998 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2476 30th Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5987077.3789 | 2098389.2279 | 37.7410313164056 | -122.48729154146099 | (37.7410313164056, -122.487291541461) | |||
39492 | 39492 | 181267 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 6009562.93662 | 2087661.4051599998 | 37.7128605768164 | -122.40878766951799 | (37.7128605768164, -122.408787669518) | |||
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) | |||
63273 | 63273 | 199485 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015513.12326 | 2108880.27223 | 37.7714547006117 | -122.389702821822 | (37.7714547006117, -122.389702821822) | |||
90309 | 90309 | 26392 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1615X Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007128.16796 | 2109448.9564900002 | 37.772547648160895 | -122.418747213269 | (37.7725476481609, -122.418747213269) | |||
99232 | 99232 | 84714 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
99541 | 99541 | 15369 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1950X Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006764.6486243 | 2107014.2225799 | 37.7658419717714 | -122.419831870418 | (37.7658419717714, -122.419831870418) | |||
134129 | 134129 | 244845 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 8ft | 6006641.10837 | 2103579.2022 | 37.756403246631606 | -122.42001538241999 | (37.7564032466316, -122.42001538242) | |||
156982 | 156982 | 137506 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 150 Francisco St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6010570.56702 | 2121351.03968 | 37.8054211392381 | -122.407678906174 | (37.8054211392381, -122.407678906174) | |||
158491 | 158491 | 246371 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1999 Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6006821.6591 | 2106989.8678 | 37.765778310813204 | -122.41963295461001 | (37.7657783108132, -122.41963295461) | |||
159888 | 159888 | 181249 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011154.37999 | 2087216.41128 | 37.7117277242201 | -122.40325580920602 | (37.7117277242201, -122.403255809206) | |||
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) | |||
169617 | 169617 | 244822 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3700 Cesar Chavez St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6005751.99744 | 2100574.03456 | 37.7481016165112 | -122.42287667172899 | (37.7481016165112, -122.422876671729) | |||
189141 | 189141 | 199474 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6015480.23631 | 2109482.55519 | 37.7731066131226 | -122.389858657266 | (37.7731066131226, -122.389858657266) | |||
1521 | 1521 | 243954 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007048.80869 | 2109949.46518 | 37.773917457170796 | -122.41905723302 | (37.7739174571708, -122.41905723302) | |
13848 | 13848 | 21865 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015619.46662 | 2106949.47478 | 37.7661590490173 | -122.38920012868601 | (37.7661590490173, -122.389200128686) | ||
20931 | 20931 | 15064 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1X Minerva St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 11 | 5995989.76979 | 2089004.05491 | 37.715777580947 | -122.455797663726 | (37.715777580947, -122.455797663726) | |||
27658 | 27658 | 246312 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1601 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6007098.251 | 2109393.5574 | 37.7723938509682 | -122.418846769596 | (37.7723938509682, -122.418846769596) | |||
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) | |||
39669 | 39669 | 118709 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4201 Balboa St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5982467.72104 | 2110969.09723 | 37.7753021852736 | -122.504161410758 | (37.7753021852736, -122.504161410758) | |||
39967 | 39967 | 199470 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015462.75637 | 2109791.03207 | 37.7739526530238 | -122.38994067543001 | (37.7739526530238, -122.38994067543) | |||
40665 | 40665 | 244841 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6006736.38106 | 2107369.27612 | 37.766815272626296 | -122.41995484006901 | (37.7668152726263, -122.419954840069) | |||
45072 | 45072 | 181223 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6012185.06666 | 2088017.9901400001 | 37.7139862096601 | -122.399749700601 | (37.7139862096601, -122.399749700601) | |||
48576 | 48576 | 181244 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6011665.41223 | 2087374.1682099998 | 37.7121894208913 | -122.40150061225701 | (37.7121894208913, -122.401500612257) | |||
56176 | 56176 | 203206 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013175.33077 | 2107284.78304 | 37.7669439332411 | -122.39767749532899 | (37.7669439332411, -122.397677495329) | |||
61157 | 61157 | 243933 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 784 Duncan St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6001410.80109 | 2099722.64145 | 37.7455179856652 | -122.437827372845 | (37.7455179856652, -122.437827372845) | |||
68878 | 68878 | 199460 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015600.77794 | 2108970.35206 | 37.771706900189294 | -122.389405908858 | (37.7717069001893, -122.389405908858) | |||
106348 | 106348 | 6113 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
106675 | 106675 | 84713 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
133845 | 133845 | 247651 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 7 | : 4 | Tree 1 | Private 1 | 16 | Width 5ft | 6001551.81383 | 2108298.34241 | 37.7690728021064 | -122.437953921852 | (37.7690728021064, -122.437953921852) | |||
137678 | 137678 | 244821 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3700 Cesar Chavez St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6005757.946719999 | 2100569.56041 | 37.748089667204205 | -122.422855781374 | (37.7480896672042, -122.422855781374) | |||
142224 | 142224 | 15377 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1979 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006845.42112 | 2106936.21263 | 37.7656323248047 | -122.41954695962099 | (37.7656323248047, -122.419546959621) | |||
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) | |||
153281 | 153281 | 202068 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 Hwy 101 S On Ramp | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6013001.93809 | 2090218.0162799999 | 37.7200725469917 | -122.39708043181601 | (37.7200725469917, -122.397080431816) | ||||
157013 | 157013 | 181997 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2478 30th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5987077.3789 | 2098383.8132 | 37.741016449074294 | -122.487291143841 | (37.7410164490743, -122.487291143841) | |||
164681 | 164681 | 217438 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 601x Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 4ft | 5997647.71271 | 2094708.73187 | 37.731536298642396 | -122.45047809200399 | (37.7315362986424, -122.450478092004) | |||
167263 | 167263 | 199478 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015495.305819999 | 2109230.7911799997 | 37.7724161604052 | -122.38978894091801 | (37.7724161604052, -122.389788940918) | |||
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) | |||
175756 | 175756 | 181248 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011168.55226 | 2087238.084 | 37.7117880246642 | -122.403208349279 | (37.7117880246642, -122.403208349279) | |||
186670 | 186670 | 217476 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2 Castenada Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994389.54518 | 2101808.84982 | 37.7508444327326 | -122.46225687706101 | (37.7508444327326, -122.462256877061) | |||
188996 | 188996 | 181266 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6009541.56007 | 2087669.1100400002 | 37.712880535479 | -122.40886209741001 | (37.712880535479, -122.40886209741) | |||
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) | |
1938 | 1938 | 252827 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
10322 | 10322 | 15786 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4840 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2013 12:00:00 AM | 12 | 3x3 | 6001077.7653 | 2090502.844 | 37.7201836118857 | -122.43831855702 | (37.7201836118857, -122.43831855702) | ||
10723 | 10723 | 1798 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012206.26499 | 2088043.30695 | 37.714056906280604 | -122.39967820720899 | (37.7140569062806, -122.399678207209) | ||
17966 | 17966 | 25063 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005101.20924 | 2102268.05958 | 37.7527162753581 | -122.42524760211501 | (37.7527162753581, -122.425247602115) | |||
21746 | 21746 | 28469 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400X Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 16 | 3x3 | 5991803.10743 | 2094513.5211900002 | 37.7306640516002 | -122.47066962200199 | (37.7306640516002, -122.470669622002) | ||
32830 | 32830 | 203205 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013159.72459 | 2107270.14751 | 37.7669028782866 | -122.397730448328 | (37.7669028782866, -122.397730448328) | |||
36738 | 36738 | 181277 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5988402.74919 | 2089827.8491900002 | 37.7176011677477 | -122.482081905481 | (37.7176011677477, -122.482081905481) | ||||
42138 | 42138 | 181261 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010896.06222 | 2086791.14453 | 37.710545596879705 | -122.40411872042299 | (37.7105455968797, -122.404118720423) | |||
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) | |||
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) | |||
63268 | 63268 | 181996 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2480 30th Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5987079.7478 | 2098357.7547 | 37.740945037480294 | -122.487281039603 | (37.7409450374803, -122.487281039603) | |||
65089 | 65089 | 199459 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015601.45578 | 2108929.3451900003 | 37.7715943419254 | -122.389400699999 | (37.7715943419254, -122.389400699999) | |||
68787 | 68787 | 244840 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006736.135559999 | 2107390.90408 | 37.7668746440714 | -122.419957224157 | (37.7668746440714, -122.419957224157) | |||
72078 | 72078 | 244818 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 150x Dolores St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6004818.66782 | 2107349.3149200003 | 37.7666522354392 | -122.426586475898 | (37.7666522354392, -122.426586475898) | ||||
84266 | 84266 | 16289 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 700X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096626998 | (37.7316223027997, -122.45117096627) | ||
90707 | 90707 | 84712 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
97601 | 97601 | 98960 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 401 Grove St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6005778.2 | 2111279.0 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | |||||
110321 | 110321 | 6112 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
110616 | 110616 | 101905 | Property Tree 7 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
127168 | 127168 | 28626 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1299 Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2016 08:27:00 AM | 3 | 3X | 5996084.79184 | 2091881.76593 | 37.7236845496924 | -122.455677113986 | (37.7236845496924, -122.455677113986) | ||
128018 | 128018 | 93967 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
132921 | 132921 | 199473 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015478.1467 | 2109531.70871 | 37.7732414619454 | -122.389869319627 | (37.7732414619454, -122.389869319627) | |||
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) | ||||
137010 | 137010 | 244855 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 899 Hampshire St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6010216.96114 | 2104085.25819 | 37.7579935807494 | -122.407684453192 | (37.7579935807494, -122.407684453192) | |||
143339 | 143339 | 15367 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1950X Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006764.6486243 | 2107014.2225799 | 37.7658419717714 | -122.419831870418 | (37.7658419717714, -122.419831870418) | |||
145780 | 145780 | 28459 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2160X Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 19 | 3x3 | 5992788.04983 | 2093457.91659 | 37.727822529658 | -122.467187832651 | (37.727822529658, -122.467187832651) | ||
147181 | 147181 | 243932 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 784 Duncan St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6001413.8789800005 | 2099722.88395 | 37.745518826532 | -122.43781674736799 | (37.745518826532, -122.437816747368) | |||
155493 | 155493 | 247650 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 6 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001564.47006 | 2108298.85523 | 37.7690749298967 | -122.437910181532 | (37.7690749298967, -122.437910181532) | |||
155650 | 155650 | 181265 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 3ft | 6009530.324580001 | 2087672.9738099999 | 37.7128905152502 | -122.40890120353201 | (37.7128905152502, -122.408901203532) | |||
159602 | 159602 | 244820 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3700 Cesar Chavez St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6005758.41375 | 2100573.51884 | 37.748100562499204 | -122.422854447683 | (37.7481005624992, -122.422854447683) | |||
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) | |||
165043 | 165043 | 84749 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 21 | Permit No. 49304 | 6015056.82948 | 2111496.40969 | 37.7786127186366 | -122.391464102698 | (37.7786127186366, -122.391464102698) | ||
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) | |||
177521 | 177521 | 199484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015511.156140001 | 2108923.75767 | 37.7715739929801 | -122.38971266400401 | (37.7715739929801, -122.389712664004) | |||
179815 | 179815 | 217437 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 601x Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 4ft | 5997794.81955 | 2094706.79322 | 37.7315393941054 | -122.449969377904 | (37.7315393941054, -122.449969377904) | |||
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) | |||
1514 | 1514 | 243952 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007022.68787 | 2110044.22077 | 37.7741761624211 | -122.41915431212601 | (37.7741761624211, -122.419154312126) | |
1932 | 1932 | 252826 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
20590 | 20590 | 25105 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1400X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005226.29827 | 2100039.91633 | 37.7466053739367 | -122.424656532567 | (37.7466053739367, -122.424656532567) | |||
21592 | 21592 | 15389 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006783.5165 | 2106591.7718 | 37.764683084119895 | -122.419736632649 | (37.7646830841199, -122.419736632649) | |||
23356 | 23356 | 1808 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 6 | 6012226.450619999 | 2088069.6740700002 | 37.7141304303483 | -122.39961028768299 | (37.7141304303483, -122.399610287683) | |||
30281 | 30281 | 181242 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6011652.37664 | 2087363.09382 | 37.7121582854612 | -122.40154488951099 | (37.7121582854612, -122.401544889511) | |||
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) | |||
33283 | 33283 | 181264 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 6009517.64457 | 2087677.5938400002 | 37.712902490626895 | -122.40894535574499 | (37.7129024906269, -122.408945355745) | |||
39038 | 39038 | 203204 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013138.407819999 | 2107249.76439 | 37.766845723690096 | -122.397802750202 | (37.7668457236901, -122.397802750202) | |||
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) | |||
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) |
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");