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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48922 | 48922 | 181271 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 40 Tomaso Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6009195.7252 | 2086405.87787 | 37.7093925805717 | -122.409968299499 | (37.7093925805717, -122.409968299499) | |||
| 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) | |||
| 154853 | 154853 | 93871 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 400-422X Tocoloma Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2010 12:00:00 AM | 17 | 3x3 | Permit Number 53366 | 6012449.21929 | 2086625.36701 | 37.7101770646038 | -122.398739010112 | (37.7101770646038, -122.398739010112) | |
| 4287 | 4287 | 181059 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 5810 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:37:00 PM | 3 | Width 3ft | 5997243.54219 | 2086644.28205 | 37.7093700633606 | -122.451293980329 | (37.7093700633606, -122.451293980329) | ||
| 67531 | 67531 | 108537 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 400-422X Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 6012472.22935 | 2086696.28114 | 37.710373062836794 | -122.39866445541 | (37.7103730628368, -122.39866445541) | ||||
| 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) | |||
| 161683 | 161683 | 181245 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 299 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012169.9653 | 2086851.4027900002 | 37.7107821509505 | -122.399720034648 | (37.7107821509505, -122.399720034648) | |||
| 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) | |||
| 11231 | 11231 | 16408 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1186X Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 42 | TR | 6001104.60764 | 2087178.31507 | 37.7110567247495 | -122.43798776335 | (37.7110567247495, -122.43798776335) | |||
| 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) | |||
| 147977 | 147977 | 181274 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 328 Palmetto Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 5993286.62087 | 2087254.83892 | 37.7108191445702 | -122.46501394844 | (37.7108191445702, -122.46501394844) | |||
| 67886 | 67886 | 181273 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 328 Palmetto Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 6ft | 5993253.89248 | 2087254.87445 | 37.710817354905295 | -122.465127066954 | (37.7108173549053, -122.465127066954) | |||
| 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) | |||
| 75130 | 75130 | 181288 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6002649.9412 | 2087357.15211 | 37.7116355320158 | -122.432659488848 | (37.7116355320158, -122.432659488848) | |||
| 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) | |||
| 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) | |||
| 64658 | 64658 | 181240 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6011635.880469999 | 2087370.3686799998 | 37.71217734028421 | -122.40160241642499 | (37.7121773402842, -122.401602416425) | |||
| 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) | |||
| 39171 | 39171 | 181241 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6011651.716019999 | 2087377.2812700002 | 37.712197204501294 | -122.401548169322 | (37.7121972045013, -122.401548169322) | |||
| 181637 | 181637 | 181239 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6011624.41356 | 2087381.7363 | 37.7122079136246 | -122.40164284814699 | (37.7122079136246, -122.401642848147) | |||
| 45399 | 45399 | 181238 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6011635.346940001 | 2087388.95322 | 37.7122283399444 | -122.401605565857 | (37.7122283399444, -122.401605565857) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 176643 | 176643 | 181263 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 6009475.51838 | 2087694.07697 | 37.7129453900797 | -122.40909212061199 | (37.7129453900797, -122.409092120612) | |||
| 183191 | 183191 | 181262 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 6009462.97914 | 2087698.55594 | 37.7129569859491 | -122.409135776392 | (37.7129569859491, -122.409135776392) | |||
| 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) | |||
| 116440 | 116440 | 187523 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 65 Megan Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6012557.25141 | 2087947.38565 | 37.713813084777605 | -122.39845832991199 | (37.7138130847776, -122.398458329912) | ||||
| 182881 | 182881 | 187524 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 65 Megan Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6012544.21435 | 2087950.6846900003 | 37.7138214169992 | -122.398503622458 | (37.7138214169992, -122.398503622458) | ||||
| 175090 | 175090 | 187522 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 65 Megan Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6012564.1625 | 2087957.56317 | 37.713841415230604 | -122.398435156171 | (37.7138414152306, -122.398435156171) | ||||
| 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) | |||
| 43297 | 43297 | 181269 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 37 Alpha St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6011324.26316 | 2088509.61111 | 37.7152880772715 | -122.402759532751 | (37.7152880772715, -122.402759532751) | |||
| 158497 | 158497 | 181270 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 37 Alpha St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 6011335.815769999 | 2088522.23161 | 37.715323375648296 | -122.40272048866899 | (37.7153233756483, -122.402720488669) | |||
| 130520 | 130520 | 181272 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4061 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 5991602.94551 | 2088924.16966 | 37.7153054953149 | -122.47095459108299 | (37.7153054953149, -122.470954591083) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");