Hello yes I tried with that, I change the MV and when I created again it appear the missing data.
Thanks for your answer. On Wednesday, 18 November 2020 at 11:41:34 UTC [email protected] wrote: > 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/3ae2de7f-9e44-4c77-8864-f9a7f74f983an%40googlegroups.com.
