[postgis-users] Point cloud insert and selective spacial location

[Pawel Pocwiardowski]

Thank you all very much

I wil lcheck that.

kind regards
Pawel


On Fri, Mar 22, 2019 at 2:49 AM Felix Kunde <felix-kunde at gmx.de> wrote:

> I thought so. So it's an option for Pawel if he's really only working in
> one area of the pointcloud. Sounds unlikely, but good to know anyway :)
>
>
> On Fri, Mar 22, 2019 at 12:25 PM Felix Kunde <felix-kunde at gmx.de> wrote:
>
>> yup, probably indexing.
>>
>> If it's a big pointcloud a BRIN index can make sense.
>> For some guidance, I just gave a talk on this subject recently:
>> https://slides.com/fxku/postgis-indexing#/
>> More details here:
>> https://postgis.net/docs/manual-2.5/using_postgis_dbmanagement.html#idm2246
>>
>> Btw: I was wondering if PostGIS supports partial indexes, e.g. CREATE
>> INDEX ... WHERE geom && <area_of_interest>; ?
>> So, that the spatial index doesn't get too big. Will do a test myself
>> this weekend but maybe somebody can already tell yes or no.
>>
>> Cheers
>> Felix
>>
>>
>> Hi,
>>
>> Thing you explain may be called Indexing. Have a look here:
>> http://postgis.net/workshops/postgis-intro/indexing.html
>>
>> On Thu, Mar 21, 2019 at 10:11 PM Pawel Pocwiardowski <pocwiard at gmail.com>
>> wrote:
>>
>>> Hi
>>>
>>> I am complete newbe in postGIS so I appology for stupid question.
>>>
>>> Is there a mechanism in PostGIS's insert selective query which will
>>> limit the search to some approximate area instead of searching through all
>>> data in database?
>>>
>>> Say, we have large (maybe global)  coverage of some point cloud data but
>>> user is interested is searching and replacing only specific small part of
>>> the  data in specific region and prevent the database from search through
>>> all the data.
>>> Is there a mechanism (or structure of the database tables) which
>>> facilitates that?
>>>
>>> Is there any white paper to refer to?
>>>
>>> Thanks in advance
>>>
>>> Pawel
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
>>
>>
>> --
>> Darafei Praliaskouski
>> Support me: http://patreon.com/komzpa
>> _______________________________________________ postgis-users mailing
>> list postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
>
> --
> Darafei Praliaskouski
> Support me: http://patreon.com/komzpa
> _______________________________________________ postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190322/78a833dd/attachment.html>