geom | General geometry parsing for binary and text formats | Parser library

I have a table with ID duplicates and I'm doing a group by for eliminating them. The unique values that are not groupeable are the values of the geom column (geometry type). For this column I tryied FIRST () as agreggation method, but it outputs me this error:

ERROR: the function first(geometry) does not exist.

I also tryied MIN ()function instead, but it outputs me the data of de column geom in text type.

Do you know any alternative for FIRST () function to use at geometry type?

Thanks!

I need to project longitude/latitude coordinates in the terra package, but I don't believe it is working correctly, as I am trying to extract data from a raster with this projection, but the data is not being extracted correctly.

Here's my lon/lat points and the code I am using to try to project them.

I have stumbled upon a problem, where I can change all the text in a biplot image to the another font, with the exception of labels.

A simple example of the problem is seen below, with label text clearly differing:

Code that I used is also attached. I cannot find the solution to this issue, hopefully someone can help.

Have created a map on which have added multiple markers:

This is an example of my data:

I'm working with house price indices and I have a question on how to add another geom to a ggplot. This is an example data that I made for this question. I have housing data from a census and from online postings. rooms a variable for a housing characteristic (many or few rooms), and value is the percentage of homes for each source that has that characteristic. Then, houses and apts show the percentage of houses and apts that the city has for that data source. So for example, city 1 has 40% houses and 60% apartments in the census data and 45% houses and 55% apartments in the zillow data. I made a geom_bar faceting by rooms and filling by source so I have two plots, one for rooms=1 and another for rooms=2, each one of them with two bars for each city (one for each source). Now, I want to fill those same bars with the percentage of houses and apartments for each city and source.

I'd be very grateful if someone can help me with this.

The code I'm currently using for the plot is the following:

Long story short, I ran a bunch of stochastic simulations for each of 15 groups, and have one integer per group that I need to add to each violin in the plot, and can't seem to figure out how to do it. Here's a reproducible example:

I have a table with 50M entries with its latitude and longitude, the geom is created as I imported from QGIS. I am trying to create a buffer of 100m for all the points in the table by calling the table in jupyter notebook. I have also tried to convert the coordinate system using SRID:25832 for the buffer in meters but I cannot see the points projected to the right place in postgresql view.

I have a spatial database with multiple tables, I have created a buffer for a table with points and wanted to add the buffer to the existing table. And wanted to do a spatial join like using this buffer and another table with points to count the number of points inside each buffer and add it as a new column in the existing buffer table. I cannot figure it out.