<div dir="ltr"><div dir="ltr"><p class="MsoNormal">I am interested in what a data quality assurance expert can use these to assess in the context of data quality assurance.</p><p class="MsoNormal"><br></p><p class="MsoNormal">Can anyone expand further on the use of following scripts for assessment of network data?</p><p class="MsoNormal"><br></p><p class="MsoNormal">Though there be a lot of solutions available, there is a lack of literature on the uses of such brilliant codes.</p><p class="MsoNormal"> </p><h1 style="margin:0cm;background:rgb(249,248,246);vertical-align:baseline"><span style="font-family:"Segoe UI",sans-serif;color:rgb(35,38,41)"><a href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgis.stackexchange.com%2Fquestions%2F94203%2Fgrouping-connected-linestrings-in-postgis&data=04%7C01%7Cshaozhong.shi%40os.uk%7C5031d35b4b9148e0985608d9f520c5ef%7C7988742dc5434b9a87a910a7b354d289%7C0%7C0%7C637810343364343710%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=wxnY0o8kdeeGS2rPjtqYSoySV5VkSBbWC4sJVluoRFU%3D&reserved=0" target="_blank"><span style="border:1pt none windowtext;padding:0cm;font-weight:normal">Grouping connected linestrings in PostGIS?</span></a></span></h1><h1 style="margin:0cm;background:rgb(249,248,246);vertical-align:baseline"><span style="color:black"><a href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgis.stackexchange.com%2Fquestions%2F94203%2Fgrouping-connected-linestrings-in-postgis&data=04%7C01%7Cshaozhong.shi%40os.uk%7C5031d35b4b9148e0985608d9f520c5ef%7C7988742dc5434b9a87a910a7b354d289%7C0%7C0%7C637810343364343710%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=wxnY0o8kdeeGS2rPjtqYSoySV5VkSBbWC4sJVluoRFU%3D&reserved=0" target="_blank">Grouping connected linestrings in PostGIS? - Geographic Information Systems Stack Exchange</a><br>This looks as though it could be very useful to determine the size of isolated networks, something that is required to help with the decision as to how serious a break in the network is.</span></h1><h1 style="margin:0cm;background:rgb(249,248,246);vertical-align:baseline"> </h1><h1 style="margin:0cm;background:rgb(249,248,246);vertical-align:baseline"><span style="font-family:"Segoe UI",sans-serif;color:rgb(35,38,41)"><a href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgis.stackexchange.com%2Fquestions%2F144866%2Fcreating-polygons-from-line-segments-using-postgresql-and-postgis&data=04%7C01%7Cshaozhong.shi%40os.uk%7C5031d35b4b9148e0985608d9f520c5ef%7C7988742dc5434b9a87a910a7b354d289%7C0%7C0%7C637810343364343710%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=2BWWXXcroBSHIoDEzic9M5JINCCT%2BE%2Bk32UdWhTLIEI%3D&reserved=0" target="_blank"><span style="border:1pt none windowtext;padding:0cm;font-weight:normal">Creating polygons from line segments using PostgreSQL and PostGIS</span></a></span></h1><h1 style="margin:0cm;background:rgb(249,248,246);vertical-align:baseline"><span style="color:black"><a href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgis.stackexchange.com%2Fquestions%2F144866%2Fcreating-polygons-from-line-segments-using-postgresql-and-postgis&data=04%7C01%7Cshaozhong.shi%40os.uk%7C5031d35b4b9148e0985608d9f520c5ef%7C7988742dc5434b9a87a910a7b354d289%7C0%7C0%7C637810343364343710%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=2BWWXXcroBSHIoDEzic9M5JINCCT%2BE%2Bk32UdWhTLIEI%3D&reserved=0" target="_blank">qgis - Creating polygons from line segments using PostgreSQL and PostGIS - Geographic Information Systems Stack Exchange</a></span></h1><h1 style="margin:0cm;background:rgb(249,248,246);vertical-align:baseline"><span style="color:black">Having read the limited documentation on ST_Polygonize and</span></h1><h1 style="margin:0cm;background:rgb(249,248,246);vertical-align:baseline"><span style="color:black">ST_BuildArea it is not clear to me whether these will create polygons only from single closed lines or from multiple lines that form the boundary of a polygon. I think you will have to create a small test data set of line geometries and experiment.<br>Something like the example in your link.<br><img border="0" width="1080" height="890" alt="line geometry" style="height: 9.27in; width: 11.25in;"></span></h1><h1 style="margin:0cm;background:rgb(249,248,246);vertical-align:baseline"> </h1><h1 style="margin:0cm;background:rgb(249,248,246);vertical-align:baseline"><span style="font-size:11pt"> </span></h1><h1 style="margin:0cm;background:rgb(249,248,246);vertical-align:baseline"><span style="color:black">Are these useful in relation to what we do?  As these just codes, what are the likely applications beyond the codes themselves.  Any gaps need to be filled.</span></h1><h1 style="margin:0cm;background:rgb(249,248,246);vertical-align:baseline"><span style="font-weight:normal"> </span></h1><h1 style="margin:0cm;background:rgb(249,248,246);vertical-align:baseline"><span style="color:black;font-weight:normal">Regards,</span></h1><div><span style="color:black;font-weight:normal"><br></span></div><div><span style="color:black;font-weight:normal">David</span></div></div></div>