This plugin allows users to create location inputs and store latitude and longitude values as geometry types in a PostGIS database. It also provides functionality to filter items based on their location.
License: MIT License
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot]")
It would be rad if the location data would be stored in the database following GeoJSON specifications.
So for example in the JSONB data field, instead of the actual:
{ "lat": 45.512861, "lng": 9.209278 }
recording:
[ 9.209278, 45.512861 ]
would permit right away to have a proper GeoJSON Feature that could be leveraged by other plugins or applications and used to build GeoJSON Feature Collections for various frontends.
A clear and concise description of what the bug is.
Nothing happened when requesting on :
http://localhost:1337/api/parkings?populate[address][fields][0]=coords&$location[address][coords]=23,14,3
{
"data": [{
...,
{
"id": 3,
...,
"address": {
"id": 13,
"coords": {
"lat": 48.947545,
"lng": 2.1423899
}
}
},
}]
}
I configured everything correctly, it took me a while to migrate my MySQL database to Postgres using the PostGis Docker image but I have no proof that this mechanism works, I always get a 200 response whatever the coordinates I use. enter I don't have the impression that the data is correct but the data from relation address not working
If applicable, add screenshots to help explain your problem.
If applicable, add code samples to help explain your problem.
plugin-version: "@notum-cz/strapi-plugin-location": "^1.1.4",
Add any other context about the problem here.
When making a request to the Strapi plugin with the $location[coords] parameter, I've observed an issue where if I set the radius to a value greater than 406, it results in an error: Error: Undefined attribute level operator 0. Upon further investigation, it seems that this error is related to a change in the data type of the variable when the array of IDs contains a large number of elements.
?$location[coords]=40.848557,14.255131,406.Error: Undefined attribute level operator 0.The plugin should handle requests with a radius greater than 406 without producing an error.
I noticed that when the array of IDs becomes large, the data type of the variable appears to change from an array of numbers to an array of objects. This transition in data types may be the root cause of the issue.
Please let me know if you need any more information or if there are specific steps to reproduce the issue.
When strapi is not using postgres, the server crashes on startup
The plugin should be disabled and the server should start without it
I noticed you already have a check in there for plugin disabled, I believe it just needs to be added to a few more places.
After testing out your v1.2.0 I receive now the following error when trying to start:
error:
UPDATE cities
SET ch_koordinate_geom = ST_SetSRID(ST_MakePoint(
CAST((ch_koordinate::json->'lng')::text AS DOUBLE PRECISION),
CAST((ch_koordinate::json->'lat')::text AS DOUBLE PRECISION)
), 4326)
WHERE (ch_koordinate::json->'lng')::text != 'null' AND
(ch_koordinate::json->'lat')::text != 'null'
- invalid input syntax for type double precision: ""13.537340924817212""
The plugin needs to incorporate a functionality where users can input an address, and it will automatically convert it into corresponding coordinates. This can be achieved through the utilization of the Google Maps API, which requires an API key. Developers will be given the choice to input this key into the configuration settings. Importantly, the plugin should gracefully handle situations where the API key is not provided, avoiding errors or any appearance of malfunction. In such cases, this specific feature should be smoothly disabled to prevent any dependency on Google features.
Using Postgres 15.3, with a schema different from the default one (public), location fields cannot be created.
This error doesn't seem to happen when using the default public schema.
CREATE SCHEMA IF NOT EXISTS strapi;)strapi-plugin-location plugin to Strapilocation fieldStrapi restarts and the database is updated
Strapi restart fails with the following error :
error:
ALTER TABLE user_profiles
ADD COLUMN address_geopoint_geom GEOMETRY(Point, 4326);
- relation "user_profiles" does not exist
Search within radius or exact search is not working when the content type has hyphen in the api url.
Works for below content type
http://localhost:1338/api/samples?$location[samloc]=18.516726,73.856255,5000
Does not work when content type has hyphen in URL
http://localhost:1338/api/sam-locs?$location[samloc]=18.516726,73.856255,5000
Location search should work independent of the collection name format.
"@notum-cz/strapi-plugin-location": "^1.0.1",
"@strapi/plugin-graphql": "^4.11.7",
"@strapi/plugin-i18n": "4.11.7",
"@strapi/plugin-users-permissions": "4.11.7",
"@strapi/strapi": "4.11.7",
"better-sqlite3": "8.0.1",
"pg": "^8.11.2",
"strapi-plugin-config-sync": "^1.1.2"
Description:
When attempting to build the Strapi plugin "strapi-plugin-location" using the command npm run build, I encounter TypeScript errors that indicate 'strapi.db' is possibly undefined.
Environment:
Steps to Reproduce:
npm install.npm run build.Error Messages:
server/bootstrap.ts:13:14 - error TS18048: 'strapi.db' is possibly 'undefined'. const db = strapi.db.connection;
Troubleshooting Steps Taken:
npm install but still the same issue.
Please let me know if you need any further assistance or have any specific details to add to the issue description.
A GraphQL interface will be developed to grant access to the filtering and searching API.
When PostGIS is already enabled on server, Strapi crashes on startup in developing environment (not tested in production).
This happens after enabling the plugin and adding the custom field to a collection, Strapi could not start and logs show the following:
[2023-08-08 18:57:53.332] info: Error Enabling PostGIS, create extension postgis; - extension "postgis" already exists
[2023-08-08 18:57:53.351] error: Error accessing POSTGIS
Error: Could not find Custom Field: plugin::location-plugin.location
On the server side, the Postgres logs show:
2023-08-08 17:22:32.530 UTC [476909] strapi@develop_strapi ERROR: function postgis_version() does not exist at character 8
2023-08-08 17:22:32.530 UTC [476909] strapi@develop_strapi HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2023-08-08 17:22:32.530 UTC [476909] strapi@develop_strapi STATEMENT: SELECT PostGIS_version();
2023-08-08 17:22:32.547 UTC [476909] strapi@develop_strapi ERROR: extension "postgis" already exists
2023-08-08 17:22:32.547 UTC [476909] strapi@develop_strapi STATEMENT: create extension postgis;
2023-08-08 17:22:32.566 UTC [476909] strapi@develop_strapi ERROR: function postgis_version() does not exist at character 8
2023-08-08 17:22:32.566 UTC [476909] strapi@develop_strapir HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2023-08-08 17:22:32.566 UTC [476909] strapi@develop_strapir STATEMENT: SELECT PostGIS_version();
2023-08-08 17:22:32.748 UTC [476909] strapi@develop_strapi LOG: could not receive data from client: Connection reset by peer
npm install && npm run build && npm run developStrapi should restart properly.
PostGIS has its own 'postgis' scheme enabled on the db, Strapi uses the 'public' scheme. The 'search_path' on the database is configured with 'public, postgis' values.
Running the command 'SELECT postgis_full_version();' on the database properly returns PostGIS version:
POSTGIS="3.2.0 c3e3cc0" [EXTENSION] PGSQL="140" GEOS="3.10.2-CAPI-1.16.0" PROJ="8.2.1" LIBXML="2.9.12" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"
We are having some issues using your plugin. When trying to start for a large database, that has already several 100k entries, I'm running into this issue and I don't know, how to solve it - I can't see the column "XXX_geom" anywhere, so I was wondering, how exactly the plugin works.
error:
UPDATE pois
SET ch_geo_points_geom = ST_SetSRID(ST_MakePoint(
CAST((ch_geo_points::json->'lng')::text AS DOUBLE PRECISION),
CAST((ch_geo_points::json->'lat')::text AS DOUBLE PRECISION)
), 4326)
WHERE (ch_geo_points::json->'lng')::text != 'null' AND
(ch_geo_points::json->'lat')::text != 'null'
- column "ch_geo_points_geom" of relation "pois" does not exist
-
A clear and concise description of what the bug is.
A clear and concise description of what you expected to happen.
If applicable, add screenshots to help explain your problem.
If applicable, add code samples to help explain your problem.
Add any other context about the problem here.
Although the geo fields are getting created in the tables for components with location custom field, none of the below approaches are able to search if the location field is inside the component. Below is the sample that I tried to pass as parameter. address is the component name and loc is location custom field.
$location[address][loc]
$location[address.loc]
When exiting an item that features the plugin custom fields, the user is warned about data loss and forced to click 'Save', even if nothing was updated.
Normally going back to the items list of the collection as no content was updated.
I am using your plugin for the strap, everything was going well,
but when I make api request, it pulls all the data
Api Url
http://localhost:1337/v1/articles?$location[coords]=49.200949303006055,16.623833585841673,5000&populate=*
Strapi crashes when a custom location fields name is containing capital letters.
How to fix:
The field should be created without crashing the application.
The plugin's functionality should be expanded to enable users to utilize not only a field for specifying single location coordinates, but also a field for defining location shapes (areas) composed of multiple location points.
Hi, I'd like to use this plugin, but I can't because my project uses a MySQL database. I guess more people are in a similar situation,
When trying to view the map the OpenStreetMap tiles do not load due to being blocked by strapi's default Content Security Policy.
Tiles are shown
N/A
The config/middlewares.ts needs to be adjusted to allow the browser to load the tiles from an external source. This configuration works for me:
export default [
"strapi::errors",
{
name: "strapi::security",
config: {
contentSecurityPolicy: {
useDefaults: true,
directives: {
"connect-src": ["'self'", "https:"],
"img-src": [
"'self'",
"data:",
"blob:",
"https://market-assets.strapi.io",
"https://tile.openstreetmap.org",
"https://a.tile.openstreetmap.org",
"https://b.tile.openstreetmap.org",
"https://c.tile.openstreetmap.org",
],
"media-src": ["'self'", "data:", "blob:"],
upgradeInsecureRequests: null,
},
},
},
},
"strapi::cors",
"strapi::poweredBy",
"strapi::logger",
"strapi::query",
"strapi::body",
"strapi::session",
"strapi::favicon",
"strapi::public",
];N/A
When a component embeds a plugin::location-plugin.location field, its value cannot be set.
This is the logged error :
error:
UPDATE components_address_adresses
SET geopoint_geom = ST_SetSRID(ST_MakePoint(-0.5870622786552258, 44.78683011143263), 4326)
WHERE id = 1;
- column "geopoint_geom" of relation "components_address_adresses" does not exist
address)location field in the componentuser-profile)address component field to user-profileuser-profile, and fill its address field.The user profile is created.
Save fails with the following error
error:
UPDATE components_address_adresses
SET geopoint_geom = ST_SetSRID(ST_MakePoint(-0.5870622786552258, 44.78683011143263), 4326)
WHERE id = 1;
- column "geopoint_geom" of relation "components_address_adresses" does not exist
Hi,
Thanks for your work !
After installing the plugin :
It seems to be well installed, but i can't see any location custom type in the content manager :
be able to use the custom type
I also try to modify the json directly by adding the custom type on a field named location but the create page was loading indefinitely
and i can't see the content manager which showed a blank page.
I'm ok to check the code, if you can tell me where i must take a look to eventually fix it (i already put a lot of console.log in the node_module)
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.