Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, PlantDate, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 150822 | 150822 | 181256 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010998.20467 | 2086964.34233 | 37.7110268699605 | -122.40377787107799 | (37.7110268699605, -122.403777871078) | |||
| 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) | |||
| 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) | |||
| 148566 | 148566 | 181253 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011090.2657 | 2087112.4680700002 | 37.7114387360727 | -122.403470098762 | (37.7114387360727, -122.403470098762) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 136903 | 136903 | 181233 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 6011973.9880099995 | 2087758.6255 | 37.7132622770132 | -122.400461065249 | (37.7132622770132, -122.400461065249) | |||
| 159892 | 159892 | 181232 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6011994.15316 | 2087783.96312 | 37.713332973598 | -122.400393145741 | (37.713332973598, -122.400393145741) | |||
| 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) | |||
| 148463 | 148463 | 181230 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6012037.58461 | 2087834.57577 | 37.713474367712294 | -122.400246583207 | (37.7134743677123, -122.400246583207) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 187703 | 187703 | 187521 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 100x Mary Teresa St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 9ft | 6012597.41848 | 2087914.4030799998 | 37.7137247587658 | -122.398317184005 | (37.7137247587658, -122.398317184005) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 139686 | 139686 | 1799 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | |||
| 141476 | 141476 | 1802 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/11/2007 12:00:00 AM | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | ||
| 144221 | 144221 | 1803 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/11/2007 12:00:00 AM | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 160884 | 160884 | 217455 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 0ft | 5996102.296490001 | 2089002.27895 | 37.7157791619582 | -122.455408593627 | (37.7157791619582, -122.455408593627) | |||
| 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) | |||
| 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) | |||
| 174465 | 174465 | 217456 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 5996127.26791 | 2089002.03978 | 37.715779938072295 | -122.455322264126 | (37.7157799380723, -122.455322264126) | |||
| 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) | |||
| 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) | |||
| 165812 | 165812 | 217459 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 5996291.57105 | 2089000.5851900002 | 37.715785369974796 | -122.45475425500099 | (37.7157853699748, -122.454754255001) | |||
| 170196 | 170196 | 217458 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 5996270.87292 | 2089001.5829099999 | 37.7157869222056 | -122.454825868913 | (37.7157869222056, -122.454825868913) | |||
| 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) | |||
| 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) | |||
| 179057 | 179057 | 217462 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 5996487.36469 | 2088998.4739599999 | 37.7157908018916 | -122.454077353311 | (37.7157908018916, -122.454077353311) | |||
| 10771 | 10771 | 28544 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5060 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000449.8979 | 2089508.0094 | 37.7174162891529 | -122.440417567822 | (37.7174162891529, -122.440417567822) | ||
| 11001 | 11001 | 15823 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5051 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000607.6416 | 2089644.9294 | 37.717801221251 | -122.439882133799 | (37.717801221251, -122.439882133799) | ||
| 10709 | 10709 | 28542 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5036 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000555.9648 | 2089678.6918 | 37.7178909833984 | -122.44006317666401 | (37.7178909833984, -122.440063176664) | ||
| 97788 | 97788 | 15799 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4950 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000922.5163 | 2090289.03562 | 37.7195877108284 | -122.438839886053 | (37.7195877108284, -122.438839886053) | ||
| 106605 | 106605 | 15797 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4950 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000922.5163 | 2090289.03562 | 37.7195877108284 | -122.438839886053 | (37.7195877108284, -122.438839886053) | ||
| 121532 | 121532 | 28775 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4950 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000922.5163 | 2090289.03562 | 37.7195877108284 | -122.438839886053 | (37.7195877108284, -122.438839886053) | |||
| 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) | ||
| 11493 | 11493 | 15784 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4840 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2015 02:53:00 PM | 3 | 3X3 | 6001135.2157 | 2090596.8347 | 37.7204449566644 | -122.438126700052 | (37.7204449566644, -122.438126700052) | ||
| 105609 | 105609 | 28635 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1001 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 21 | 5X5 | 5996764.463409999 | 2091686.23626 | 37.723186652559 | -122.45331350914 | (37.723186652559, -122.45331350914) | ||
| 80612 | 80612 | 28634 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1001 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 25 | 5X5 | 5996752.18528 | 2091690.06821 | 37.7231964704228 | -122.453356228535 | (37.7231964704228, -122.453356228535) | ||
| 89453 | 89453 | 28583 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296002 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | ||
| 102619 | 102619 | 28582 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296002 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | ||
| 128162 | 128162 | 28610 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1107 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 5X5 | 5996451.82773 | 2091748.4966099998 | 37.7233396801105 | -122.45439871889799 | (37.7233396801105, -122.454398718898) | ||
| 103090 | 103090 | 15755 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4669 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2006 12:00:00 AM | 12 | 3x3 | 6001907.5344845 | 2091721.0874415 | 37.7235757956571 | -122.43553743265801 | (37.7235757956571, -122.435537432658) | ||
| 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) | ||
| 122891 | 122891 | 97689 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 290X Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 15 | 3x3 | 5995676.6687900005 | 2091928.33915 | 37.723788999067395 | -122.45709128373899 | (37.7237889990674, -122.457091283739) | ||
| 142883 | 142883 | 97690 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 290X Granada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 15 | 3x3 | 5995677.088719999 | 2091935.1945900002 | 37.7238078465863 | -122.457090327774 | (37.7238078465863, -122.457090327774) | ||
| 141877 | 141877 | 28584 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1150 Ocean Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 18 | 3X3 | 5996037.5543 | 2091961.1786900002 | 37.72389988729329 | -122.455846143025 | (37.7238998872933, -122.455846143025) | ||
| 17291 | 17291 | 28608 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1345 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/24/2015 09:29:00 AM | 3 | 3X3 | 5995740.3284 | 2091982.407 | 37.7239411121873 | -122.456875133176 | (37.7239411121873, -122.456875133176) | ||
| 115989 | 115989 | 87714 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1298X Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 24 | 3x3 | 5995838.896292 | 2092008.0569689998 | 37.7240172004189 | -122.456536255807 | (37.7240172004189, -122.456536255807) | ||
| 89640 | 89640 | 28591 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1298 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5995836.7436481 | 2092012.5698365 | 37.7240294680883 | -122.45654402330901 | (37.7240294680883, -122.456544023309) | ||
| 97244 | 97244 | 87718 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1405X Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 4x4 | 5995623.94864 | 2092020.8189400001 | 37.724039898691004 | -122.457280214367 | (37.724039898691, -122.457280214367) | ||
| 122285 | 122285 | 87719 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1405X Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 5995623.94864 | 2092020.8189400001 | 37.724039898691004 | -122.457280214367 | (37.724039898691, -122.457280214367) | |||
| 90307 | 90307 | 87716 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1490 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 3x4 | 5995451.1237 | 2092197.4835700002 | 37.724515049874505 | -122.457890417782 | (37.7245150498745, -122.457890417782) | ||
| 97655 | 97655 | 87715 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1490 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 4x3 | 5995451.1237 | 2092197.4835700002 | 37.724515049874505 | -122.457890417782 | (37.7245150498745, -122.457890417782) |
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");