Have you tried manually refreshing the MV?
On Tuesday, November 17, 2020 at 8:27:04 AM UTC gabriel.c...@gmail.com
wrote:
> Hello,
>
> It has been imported to arches around 180.000 features, under 2 different
> resources (Information and Heritage), but just the information resources
> (111.000) are being shown in materialised views, mostly of the remaining
> have geometry.
>
> When I try to get those one coming from the Information Resource
> ("resource_model_id": "35b99cb7-379a-11ea-9989-06f597a7d5ce" from mapping
> document) and after run the following query I got all the features expected:
> SELECT row_number() OVER () AS gid,
> mv.resourceinstanceid,
> mv.tileid,
> mv.nodeid,
> st_geometrytype(mv.geom) AS geom_type,
> mv.geom
> FROM mv_geojson_geoms mv
> WHERE (( SELECT resource_instances.graphid
> FROM resource_instances
> WHERE mv.resourceinstanceid =
> resource_instances.resourceinstanceid)) =
> '35b99cb7-379a-11ea-9989-06f597a7d5ce'::uuid;
>
> But when I do the same for Heritage resources, using the mapping document
> (resource_model_id": "34cfe98e-c2c0-11ea-9026-02e7594ce0a0)for this
> resource doesnt show any feature (logical because neither appear anyone in
> mv_geojson_geoms mv).
>
> I have downloaded some examples of the resources uploaded from heritage,
> the geometry seems to be ok and in the columns of Heritage Resource
> Instance appears in white (Probably its normal but I am not sure).
>
> Do someone have any idea what could be wrong or have experienced the same
> issue?
>
> Regards,
>
>
>
>
--
-- To post, send email to archesproject@googlegroups.com. To unsubscribe, send
email to archesproject+unsubscr...@googlegroups.com. For more information,
visit https://groups.google.com/d/forum/archesproject?hl=en
---
You received this message because you are subscribed to the Google Groups
"Arches Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to archesproject+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/archesproject/7da14efc-6f83-4aef-882f-18eedf325c63n%40googlegroups.com.
