<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi Hugo, nice to hear from you<div class=""><br class=""></div><div class="">Just exclude the geometry from the list of fields in the select statement, otherwise, by definition, it will be repeated. </div><div class=""><br class=""></div><div class="">If you simply want to define the relationship to enforce referential integrity then create a foreign key.</div><div class=""><br class=""></div><div class="">Hope this helps. If you need professional support or consulting, Kartoza does offer these. See the options in the Solutions section of our website of contact me directly. </div><div class=""><br class=""></div><div class="">regards</div><div class=""><br class=""></div><div class="">Gavin<br class=""><div class="">
<div class="moz-signature">-- <br class="">
<div style="text-align:center" class="">Gavin Fleming - Joint MD - PrGISc
[PGP1234]</div>
<div style="text-align:center" class="">
<div class="">Skype: phlemingo</div>
<div class="">Office: +27(0)878092702</div>
<div style="text-align:center" class=""><a href="https://calendly.com/gavin-kartoza" target="_blank" class="">Schedule a meeting</a></div>
<div style="text-align:center" class="">
------------------------------------------------------------------------------------------</div>
<div style="text-align:center" class=""><img src="http://kartoza.com/media/uploads/kartozanewlogothumbnail.jpg" moz-do-not-send="true" height="118" width="150" class=""></div>
<div style="text-align:center" class=""><span style="text-align:start" class="">Visit
</span><a href="http://kartoza.com/" style="text-align:start" target="_blank" class="">http://kartoza.com</a><span style="text-align:start" class=""> to find out about open source:</span><br style="text-align:start" class="">
<span style="text-align:start" class=""> * Full stack web, desktop and mobile geospatial software development</span><br style="text-align:start" class=""></div>
<div style="text-align:center" class=""><span style="text-align:start" class="">*
GIS training</span></div>
<div style="text-align:center" class=""><span style="text-align:start" class="">*
Support, hosting and maintenance</span></div>
<div style="text-align:center" class=""><span style="text-align:start" class="">*
Consulting services</span></div>
-------------------------------------------------------------------------------------------</div>
</div>
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On 17 Aug 2020, at 21:06, Hugo Paul <<a href="mailto:hugopaul@live.com" class="">hugopaul@live.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class=""><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Hi Everyone<o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">I am looking for some guidance/assistance please. I am building a web app using ArcGIS JS API 4.16 and our GeoDBMS is Postgres with PostGIS layers served through Geoserver 2.17.<o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">We<span class="Apple-converted-space"> </span><b class="">do not</b><span class="Apple-converted-space"> </span>have an Arc Enterprise license and therefor use the Geoserver, OGCFeatureLayer, wms, etc. method to load layers into our web app.<span class="Apple-converted-space"> </span><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">My problem is that when I want to make a one to many relationship in Postgres (where the geometry layer is the one and a non-spatial table is the many), it duplicates the geometry.<span class="Apple-converted-space"> </span><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Example: I have one high rise apartment block (1 polygon) with 50 living units (non-spatial table) when I try to relate (join) the non-spatial table to the spatial table it creates 50 duplicate polygons. I do this using views..<o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">All I want is a relationship between the spatial and non-spatial tables without creating duplicate geometries (Similar to the ArcGIS relate function).<o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Has anyone experienced this that might be able to give me some advise please? Or if anyone knows of a consultancy firm with PostGIS experience who might be able to assist, please advise.<o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Thank you in advance<o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Kind regards<o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Hugo<o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><br class=""></div><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">_______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">Africa mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="mailto:Africa@lists.osgeo.org" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">Africa@lists.osgeo.org</a><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">You can UNSUBSCRIBE at<span class="Apple-converted-space"> </span></span><a href="https://lists.osgeo.org/mailman/listinfo/africa" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">https://lists.osgeo.org/mailman/listinfo/africa</a></div></blockquote></div><br class=""></div></body></html>