Have you tried manually refreshing the MV?

On Tuesday, November 17, 2020 at 8:27:04 AM UTC [email protected] 
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 [email protected]. To unsubscribe, send 
email to [email protected]. 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 [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/archesproject/7da14efc-6f83-4aef-882f-18eedf325c63n%40googlegroups.com.

Reply via email to