Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109889 | 109889 | 93903 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 546 Page St | Front Yard : 25 | Tree 1 | Private 1 | 6003947.0 | 2109752.0 | 37.773200107256606 | -122.42977281454901 | (37.7732001072566, -122.429772814549) | ||||||
| 96749 | 96749 | 93115 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 397 San Jose Ave | 1 | Sidewalk: Curb side : 21 | Landscaping 2 | Private 1 | 02/02/2009 12:00:00 AM | 26x6 | Permit Number 53167 | 6006259.6 | 2100887.6 | 37.7489912240508 | -122.42114365927 | (37.7489912240508, -122.42114365927) | ||
| 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) | ||||
| 137301 | 137301 | 248045 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 38 Rutledge St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6010553.45752 | 2099414.8881099997 | 37.7451886053837 | -122.40619165772699 | (37.7451886053837, -122.406191657727) | ||||
| 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) | ||||
| 181473 | 181473 | 218224 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399 Claremont Blvd | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 5993477.431469999 | 2097858.26435 | 37.7399445640996 | -122.465124117182 | (37.7399445640996, -122.465124117182) | ||||
| 10337 | 10337 | 1859 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6010721.136519999 | 2086497.1887700001 | 37.7097286779125 | -122.404702624138 | (37.7097286779125, -122.404702624138) | |||
| 10446 | 10446 | 1841 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011283.06964 | 2087344.7309400002 | 37.712087250691 | -122.40282003911301 | (37.712087250691, -122.402820039113) | |||
| 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) | ||
| 10981 | 10981 | 1860 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6010703.231369999 | 2086455.7019 | 37.709613762523205 | -122.404761589082 | (37.7096137625232, -122.404761589082) | |||
| 11132 | 11132 | 1820 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 3 | 6 | 6011846.03792 | 2087600.59079 | 37.7128212089973 | -122.400892211026 | (37.7128212089973, -122.400892211026) | ||
| 11170 | 11170 | 1796 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012245.53967 | 2088092.97358 | 37.714195470207 | -122.39954594300899 | (37.714195470207, -122.399545943009) | |||
| 11400 | 11400 | 1858 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010736.7682300005 | 2086529.19155 | 37.709817424799 | -122.404650849269 | (37.709817424799, -122.404650849269) | |||
| 11567 | 11567 | 1857 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010751.52595 | 2086559.13987 | 37.7099004816803 | -122.404601950438 | (37.7099004816803, -122.404601950438) | |||
| 11580 | 11580 | 1821 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 6 | 6 | 6011817.461569999 | 2087571.87835 | 37.712740776339295 | -122.400988964593 | (37.7127407763393, -122.400988964593) | ||
| 11630 | 11630 | 1793 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012296.32723 | 2088174.84774 | 37.7144231111167 | -122.399376144697 | (37.7144231111167, -122.399376144697) | |||
| 11710 | 11710 | 1795 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012264.68095 | 2088118.8470599998 | 37.714267580549105 | -122.399481598293 | (37.7142675805491, -122.399481598293) | |||
| 11934 | 11934 | 1822 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011791.38112 | 2087549.257 | 37.7126772077525 | -122.401077519005 | (37.7126772077525, -122.401077519005) | |||
| 12160 | 12160 | 1842 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6011254.373459999 | 2087325.01114 | 37.7120315017345 | -122.402917835889 | (37.7120315017345, -122.402917835889) | |||
| 12292 | 12292 | 1840 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011305.78262 | 2087356.70002 | 37.7121213835762 | -122.40274237725401 | (37.7121213835762, -122.402742377254) | |||
| 13232 | 13232 | 1794 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012280.2141 | 2088145.3083400002 | 37.7143411037303 | -122.399429765893 | (37.7143411037303, -122.399429765893) | |||
| 17162 | 17162 | 25069 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005114.64614 | 2102050.12648 | 37.752118640770995 | -122.42518562892599 | (37.752118640771, -122.425185628926) | |||
| 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) | |||
| 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) | |||
| 18277 | 18277 | 25059 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005094.91106 | 2102418.8508099997 | 37.7531299572042 | -122.425280111693 | (37.7531299572042, -122.425280111693) | |||
| 18428 | 18428 | 25049 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 900X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/20/1999 12:00:00 AM | 30 | 20 | 6005065.417330001 | 2102966.79857 | 37.7546328277698 | -122.425421098419 | (37.7546328277698, -122.425421098419) | ||
| 18812 | 18812 | 25066 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005105.419480001 | 2102158.55982 | 37.7524158523077 | -122.425225251269 | (37.7524158523077, -122.425225251269) | |||
| 19141 | 19141 | 25104 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1400X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005230.71957 | 2100053.05302 | 37.7466416939779 | -122.424642178499 | (37.7466416939779, -122.424642178499) | |||
| 19386 | 19386 | 25103 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1400X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005223.79386 | 2100066.14764 | 37.746677257659705 | -122.424667058263 | (37.7466772576597, -122.424667058263) | |||
| 19459 | 19459 | 15076 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 Minerva St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 11 | 5995952.59829 | 2089005.6317099999 | 37.7157797770894 | -122.455926258705 | (37.7157797770894, -122.455926258705) | |||
| 19986 | 19986 | 15072 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1X Minerva St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 11 | 5995966.887709999 | 2089005.2550700002 | 37.71577956305239 | -122.45587684097 | (37.7157795630524, -122.45587684097) | |||
| 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) | |||
| 20631 | 20631 | 25060 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005096.113419999 | 2102391.61943 | 37.7530552540956 | -122.425274016077 | (37.7530552540956, -122.425274016077) | |||
| 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) | |||
| 21404 | 21404 | 15067 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 Minerva St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996019.74584 | 2089003.9616 | 37.7157790450506 | -122.455694046564 | (37.7157790450506, -122.455694046564) | |||
| 21785 | 21785 | 25131 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1600X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005285.7039 | 2098966.45887 | 37.74366125975121 | -122.42437477586901 | (37.7436612597512, -122.424374775869) | |||
| 21999 | 21999 | 25056 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 900X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005074.95095 | 2102753.03228 | 37.7540464140318 | -122.42537291722999 | (37.7540464140318, -122.42537291723) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 27734 | 27734 | 181258 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010956.04386 | 2086896.41565 | 37.7108380015362 | -122.403918812817 | (37.7108380015362, -122.403918812817) | |||
| 29208 | 29208 | 181257 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010977.11587 | 2086929.96483 | 37.7109312981009 | -122.40384834192801 | (37.7109312981009, -122.403848341928) | |||
| 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) | |||
| 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) | |||
| 33738 | 33738 | 181254 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011072.17285 | 2087082.1734200001 | 37.711354542437 | -122.403530502643 | (37.711354542437, -122.403530502643) | |||
| 35882 | 35882 | 181250 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011135.05622 | 2087186.9706 | 37.7116458067799 | -122.403320528015 | (37.7116458067799, -122.403320528015) | |||
| 40752 | 40752 | 181255 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011058.3910300005 | 2087059.24952 | 37.71129082818 | -122.403576524557 | (37.71129082818, -122.403576524557) | |||
| 40806 | 40806 | 217440 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 601x Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 4ft | 5997608.12096 | 2094709.9328599998 | 37.731537330169 | -122.450615054238 | (37.731537330169, -122.450615054238) | |||
| 42000 | 42000 | 181235 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100x Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 6ft | 6011766.34512 | 2087531.33968 | 37.7126266136928 | -122.401162793634 | (37.7126266136928, -122.401162793634) | |||
| 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) | |||
| 42329 | 42329 | 181252 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011104.47177 | 2087135.7976799998 | 37.711503587981205 | -122.403422638862 | (37.7115035879812, -122.403422638862) | |||
| 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) | |||
| 44652 | 44652 | 181259 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010937.034659999 | 2086861.99587 | 37.710742429686206 | -122.40398209272499 | (37.7107424296862, -122.403982092725) | |||
| 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) | |||
| 45676 | 45676 | 181228 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 6012082.02881 | 2087884.13753 | 37.7136129325747 | -122.400096445907 | (37.7136129325747, -122.400096445907) | |||
| 48782 | 48782 | 181251 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011120.84177 | 2087163.22682 | 37.7115798172183 | -122.40336798793999 | (37.7115798172183, -122.40336798794) | |||
| 50630 | 50630 | 217460 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 40 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 5996389.15784 | 2088998.26407 | 37.715784593857606 | -122.454416784407 | (37.7157845938576, -122.454416784407) | |||
| 52430 | 52430 | 217461 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 5996430.050430001 | 2088999.1612900002 | 37.7157894025409 | -122.454275506331 | (37.7157894025409, -122.454275506331) | |||
| 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) | |||
| 57972 | 57972 | 181260 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010918.05044 | 2086828.8185599998 | 37.7106502707697 | -122.40404537351601 | (37.7106502707697, -122.404045373516) | |||
| 59418 | 59418 | 217432 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 501x Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 4ft | 5998518.5429 | 2094695.27928 | 37.731549164350795 | -122.44746650799999 | (37.7315491643508, -122.447466508) | |||
| 60011 | 60011 | 181246 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011206.95507 | 2087284.9541099998 | 37.711918865232 | -122.403078912559 | (37.711918865232, -122.403078912559) | |||
| 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) | |||
| 62268 | 62268 | 181231 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6012012.90847 | 2087803.8646200001 | 37.713388665025 | -122.40032971745 | (37.713388665025, -122.40032971745) | |||
| 64053 | 64053 | 217436 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 601x Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 4ft | 5997812.19906 | 2094707.93376 | 37.7315435201955 | -122.449909376021 | (37.7315435201955, -122.449909376021) | |||
| 78182 | 78182 | 16288 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 700X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096626998 | (37.7316223027997, -122.45117096627) | |||
| 79235 | 79235 | 6115 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 80227 | 80227 | 6116 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 81891 | 81891 | 1801 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | ||
| 82072 | 82072 | 1811 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2040 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012267.4866135 | 2088237.9390645002 | 37.7145947398058 | -122.399480256716 | (37.7145947398058, -122.399480256716) | |||
| 82314 | 82314 | 16263 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 636X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997868.038561299 | 2094745.6362508 | 37.731650237153104 | -122.449719044874 | (37.7316502371531, -122.449719044874) | ||
| 83701 | 83701 | 16214 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 530X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5998569.7206668 | 2094722.0869743999 | 37.731625696446706 | -122.44729150596599 | (37.7316256964467, -122.447291505966) | ||
| 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) | ||
| 87834 | 87834 | 27695 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 91674 | 91674 | 1776 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | |||
| 93045 | 93045 | 6109 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 97172 | 97172 | 16261 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 636X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997868.038561299 | 2094745.6362508 | 37.731650237153104 | -122.449719044874 | (37.7316502371531, -122.449719044874) | ||
| 97318 | 97318 | 1810 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2040 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012267.4866135 | 2088237.9390645002 | 37.7145947398058 | -122.399480256716 | (37.7145947398058, -122.399480256716) | ||
| 97785 | 97785 | 1774 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | |||
| 98783 | 98783 | 1777 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | |||
| 101360 | 101360 | 6110 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 101386 | 101386 | 1800 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | ||
| 104622 | 104622 | 27693 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 104786 | 104786 | 16262 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 636X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997868.038561299 | 2094745.6362508 | 37.731650237153104 | -122.449719044874 | (37.7316502371531, -122.449719044874) | ||
| 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) | |||
| 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) | |||
| 111393 | 111393 | 1809 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2040 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012267.4866135 | 2088237.9390645002 | 37.7145947398058 | -122.399480256716 | (37.7145947398058, -122.399480256716) | |||
| 111730 | 111730 | 27692 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 112272 | 112272 | 1797 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2010 Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6012333.445831 | 2088436.5537268997 | 37.7151437722719 | -122.399266207491 | (37.7151437722719, -122.399266207491) | |||
| 112905 | 112905 | 6111 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 117607 | 117607 | 16269 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 670X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997650.6660656 | 2094749.4324283001 | 37.731648221723205 | -122.450470814769 | (37.7316482217232, -122.450470814769) | ||
| 118455 | 118455 | 16270 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 670X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997650.6660656 | 2094749.4324283001 | 37.731648221723205 | -122.450470814769 | (37.7316482217232, -122.450470814769) | ||
| 122506 | 122506 | 1775 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | |||
| 123108 | 123108 | 6114 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 127634 | 127634 | 27696 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 128687 | 128687 | 6108 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 130553 | 130553 | 181234 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6011952.76833 | 2087732.27923 | 37.7131887520264 | -122.40053255865601 | (37.7131887520264, -122.400532558656) | |||
| 130918 | 130918 | 217435 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 601x Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 4ft | 5997833.6645599995 | 2094705.98375 | 37.7315393941237 | -122.449835025492 | (37.7315393941237, -122.449835025492) | |||
| 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) |
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");