Writing a table (no geometry) to GeoPackage using RWriting multiple layers to GeoPackage using writeOGR() in...

Sometimes a banana is just a banana

Wardrobe above a wall with fuse boxes

Can metaphors be used for other purposes than for stylistic effect and to form an allegory?

How to fix my table, centering of columns

I encountered my boss during an on-site interview at another company. Should I bring it up when seeing him next time?

Has Wakanda ever accepted refugees?

Why won't the strings command stop?

How do you say “my friend is throwing a party, do you wanna come?” in german

School performs periodic password audits. Is my password compromised?

Every subset equal to original set?

How does insurance birth control work?

How can I be pwned if I'm not registered on the compromised site?

3.5% Interest Student Loan or use all of my savings on Tuition?

Misplaced tyre lever - alternatives?

Would the melodic leap of the opening phrase of Mozart's K545 be considered dissonant?

How to disable or uninstall iTunes under High Sierra without disabling SIP

1970s scifi/horror novel where protagonist is used by a crablike creature to feed its larvae, goes mad, and is defeated by retraumatising him

PTIJ: Aharon, King of Egypt

Meaning of word ягоза

The need of reserving one's ability in job interviews

Can a space-faring robot still function over a billion years?

I can't die. Who am I?

Reason why dimensional travelling would be restricted

Difference between 'stomach' and 'uterus'



Writing a table (no geometry) to GeoPackage using R


Writing multiple layers to GeoPackage using writeOGR() in R?Calculating distances between two geometry columns using R?How to get a sf with line segments from a data table?Selecting features “above” or “below” a line using RError when reading Layer from .gpkg with readOGR into R and writing it to PostgreSQLExported GeoPackage from R not drawing in ArcMapCalculating distances between consecutive points using R?Remove Duplicate Spatial Lines in R using SF PackageConvert geometry set to simple features collection using `sf` in RDoes GeoPackage impose a maximum number of (non-geometry) columns per feature?













0















I'm trying to do something so incredibly simple: write a table (with no geometry) to a GeoPackage. I can store tables in a GeoPackage using QGIS, so it stands to reason I'd be able to write one from R. So far no luck. Here's an example:



library(sf)

t1 <- data.frame(numbers=c(1:5), letters=c(LETTERS[1:5]))

st_write(t1, dsn="NewGeopackage.gpkg", layer="t1")


I've tried converting the table to other formats (using st_as_sf, for example) but I always get the same error:



Error in st_sf(x, ..., agr = agr, sf_column_name = sf_column_name) : 
no simple features geometry column present


Any idea how to do this?









share







New contributor




Mike is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    I'm trying to do something so incredibly simple: write a table (with no geometry) to a GeoPackage. I can store tables in a GeoPackage using QGIS, so it stands to reason I'd be able to write one from R. So far no luck. Here's an example:



    library(sf)

    t1 <- data.frame(numbers=c(1:5), letters=c(LETTERS[1:5]))

    st_write(t1, dsn="NewGeopackage.gpkg", layer="t1")


    I've tried converting the table to other formats (using st_as_sf, for example) but I always get the same error:



    Error in st_sf(x, ..., agr = agr, sf_column_name = sf_column_name) : 
    no simple features geometry column present


    Any idea how to do this?









    share







    New contributor




    Mike is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      I'm trying to do something so incredibly simple: write a table (with no geometry) to a GeoPackage. I can store tables in a GeoPackage using QGIS, so it stands to reason I'd be able to write one from R. So far no luck. Here's an example:



      library(sf)

      t1 <- data.frame(numbers=c(1:5), letters=c(LETTERS[1:5]))

      st_write(t1, dsn="NewGeopackage.gpkg", layer="t1")


      I've tried converting the table to other formats (using st_as_sf, for example) but I always get the same error:



      Error in st_sf(x, ..., agr = agr, sf_column_name = sf_column_name) : 
      no simple features geometry column present


      Any idea how to do this?









      share







      New contributor




      Mike is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      I'm trying to do something so incredibly simple: write a table (with no geometry) to a GeoPackage. I can store tables in a GeoPackage using QGIS, so it stands to reason I'd be able to write one from R. So far no luck. Here's an example:



      library(sf)

      t1 <- data.frame(numbers=c(1:5), letters=c(LETTERS[1:5]))

      st_write(t1, dsn="NewGeopackage.gpkg", layer="t1")


      I've tried converting the table to other formats (using st_as_sf, for example) but I always get the same error:



      Error in st_sf(x, ..., agr = agr, sf_column_name = sf_column_name) : 
      no simple features geometry column present


      Any idea how to do this?







      r sf





      share







      New contributor




      Mike is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.










      share







      New contributor




      Mike is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.








      share



      share






      New contributor




      Mike is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 5 mins ago









      MikeMike

      1




      1




      New contributor




      Mike is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Mike is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Mike is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "79"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          Mike is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f314655%2fwriting-a-table-no-geometry-to-geopackage-using-r%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          Mike is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          Mike is a new contributor. Be nice, and check out our Code of Conduct.













          Mike is a new contributor. Be nice, and check out our Code of Conduct.












          Mike is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Geographic Information Systems Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f314655%2fwriting-a-table-no-geometry-to-geopackage-using-r%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          (145452) 2005 RN43 Классификация | Примечания | Ссылки |...

          Щит и меч (фильм) Содержание Названия серий | Сюжет |...

          Энтрерриос (город) Содержание История | Географическое...