Result for 7788867AE417A19094CCA04B9E322739A38DA412

Query result

Key Value
FileSize106488
MD5541FBCF288DA55906F63D7CBCAF251A0
PackageDescriptionPostgreSQL foreign data wrapper for OGR OGR is the vector half of the GDAL spatial data access library. It allows access to a large number of GIS data formats using a simple C API for data reading and writing. Since OGR exposes a simple table structure and PostgreSQL foreign data wrappers allow access to table structures, the fit seems pretty perfect. . This implementation currently has the following limitations: * Only non-spatial query restrictions are pushed down to the OGR driver. PostgreSQL foreign data wrappers support delegating portions of the SQL query to the underlying data source, in this case OGR. This implementation currently pushes down only non-spatial query restrictions, and only for the small subset of comparison operators (>, <, <=, >=, =) supported by OGR. * Spatial restrictions are not pushed down. OGR can handle basic bounding box restrictions and even (for some drivers) more explicit intersection restrictions, but those are not passed to the OGR driver yet. * OGR connections every time Rather than pooling OGR connections, each query makes (and disposes of) two new ones, which seems to be the largest performance drag at the moment for restricted (small) queries. * All columns are retrieved every time. PostgreSQL foreign data wrappers don't require all columns all the time, and some efficiencies can be gained by only requesting the columns needed to fulfill a query. This would be a minimal efficiency improvement, but can be removed given some development time, since the OGR API supports returning a subset of columns.
PackageMaintainerDebian GIS Project <pkg-grass-devel@lists.alioth.debian.org>
PackageNamepostgresql-13-ogr-fdw
PackageSectiondatabase
PackageVersion1.1.1-1+b1
SHA-17788867AE417A19094CCA04B9E322739A38DA412
SHA-25656EF1F6E84FCB9D852D4EBE4F9EA00963D51A68318766D4BED64AEC2EC248D78
hashlookup:children-total15
hashlookup:trust50

Network graph view

Children (Total: 15)

The searched file hash includes 15 children files known and seen by metalookup. A sample is included below:

Key Value
FileName./usr/lib/postgresql/13/lib/ogr_fdw.so
FileSize133304
MD5E2AF685B39C98F6A4E2C0B6C61560815
SHA-16E3942A5FB5449D86AF428AA5536A5880CC41D5A
SHA-2562F543E987A4BE4DE67DE1BD41F4F8F518FDA39F7F9E21F3162BCD2C67EB2F8D1
SSDEEP1536:SRhwa2NO5rgp9T5PGVvMEqIT+SD4xqWTYXmCEXYtrBHEzdXSTcDaj:SRhwa29p9T5oMEKSD4xq3XmCoS1HE9a
TLSHT1ADD3E877326C5B01CB41B43E86EE4621B3A77C4F46344753A210532F6EEE71DCA62E6A
Key Value
FileNameogr_fdw--1.0--1.1.sql
FileSize299
MD51EF554C616399D0FB6F06EA3F98F8207
RDS:package_id285120
SHA-130C012FEA931EA588C3F6A149ED4824C112DE8AB
SHA-256AA6E1255A8A15EA871B2BA23E9A48A4C44F694AEDC97C360A09146030F14DD93
SSDEEP6:ecUhTaUxCii752Jr6AgFeBzUhTCxCijw52JZzAgFeB5:ecURxZoFFeBzU0/l7zFFeB5
TLSHT12EE0CD0BAD675523D292BF349402C9BF4F13038F446BE95050BB741C8E5380C8B25EEB
insert-timestamp1662198435.8497121
sourcedelta.db
Key Value
FileName./usr/lib/postgresql/13/bin/ogr_fdw_info
FileSize68392
MD52DB0C8E23DD9BAE90FF5E784C6D65441
SHA-1F637BB9B047468C7FE9C9190FF65732202CF1EFC
SHA-2567D7A8142F56B05923CD8A87DC881564FB1A0145DCDA4F083C7D69516BB511D7C
SSDEEP1536:X+iLkle/YpyjMdmXABa701Ovo5iTctWHQR243f3cP9zGh5bw:uT3fcP9zSw
TLSHT13963A6B3372C9703DB42B93E86ABA52173763D0E47645343A210632F2DEA71ECF25656
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize11044
MD5D71793BEB282A259CE7EEB25103FEA91
SHA-1A84C17CB45DD1BF41A31DCB6DC6D7E6EEA08FD25
SHA-25630B03690826D691C5B27D6E8AA021790FB517AFA2896FACB653EB677E434EC91
SSDEEP192:kaNL9vhCMKMcuYb7y6tr3ruBk30KtTTADQxFbGFZkwguOCEz9cTWPJML:kazVK1fyKr3ruf0TbGFZkwBOCsmW
TLSHT1F9323B1BB2681A65D28D1B3C4CFB028EA7F5E041CF2462B7B7A36A3CADB51665490291
Key Value
FileNameogr_fdw.control
FileSize152
MD5408F173AC888FA17C052E673078E59A0
RDS:package_id285118
SHA-1ABDA8467690571C922AFF0388ABD42855D6818F7
SHA-256163D3B61CC6DC3415543E755617DDC9579E6E42149687D2AA0A0A0C5A43773A0
SSDEEP3:SJFAYT8XqgSZVQisnqBCv2DB4AGNRKmVVERNwoCEHBYjQCvcTpdFR1n:SJFzT8XqgSZVgD2GNRKm/ErwoXHBYcPv
TLSHT158C08C2113AA84A20814BF28D9000020DEA43AB82212242712C8888C3BA0789B241B09
insert-timestamp1662198435.5457163
sourcedelta.db
Key Value
FileNamesnap-hashlookup-import/usr/share/lintian/overrides/libhdf4-0-alt
FileSize63
MD572EE11F9626FF424B93B5AF1F353BCBA
RDS:package_id293681
SHA-18B1072FD9A6A5C0ACC44BD875330A469DF2C4A09
SHA-256571DA562A54CEA577DAF5A18A413B8A1D02E78769BCB1E7254E9153B260D8C58
SHA-512B914B2C5B4B7400CB7BA0AD16C21E7F68BF2D612FC7E71D07E92D8D03BE24BB17C5F0BD8CBF70377651AF16C5E5BDE3EE10050BC446709E95947716C501BF79F
SSDEEP3:SLfELcAGAI+GAWZGOrtRogPvvn:SALccI+G1Zrnv
TLSHT169A002544D11155A575277107F311705627B617196A442406128154A7406FB422D262E
insert-timestamp1728263316.5318696
mimetypetext/plain
sourcesnap:2ZmiMNpbuanFwhJ4sSt9y1DaYHITLCyb_103
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/changelog.Debian.ppc64el.gz
FileSize226
MD557B690B20AD8BE4C0BFFFAE4AF33B05E
SHA-109CAC48261FBDE4BD76F52C9038CB0EAA3F5EEC2
SHA-256ECD91935308F9BFC8B3D517F1B6A6B2E3E8A7AB27EC25C9D910AF1B2D0C77FBB
SSDEEP3:Ftt/Gye0cNEl0GexzT1INCTJKVd/NR1Uqrj4ZHPJQV4GyRzaJiLFbZnWwMw2LfyU:XtcCo1T1I4e/NRXg+VXyhCMZCDLso/
TLSHT1EBD0A75A4126B513D8C6CF6205F59887EC016E707A4AB15D7468EC45950DC9D0C41F25
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/changelog.Debian.gz
FileSize1585
MD583C3310E2A14F704F922D940954E2AF2
SHA-12D7DA18BF5A42B2CE51EE8F9A31D961F94A85307
SHA-256F45A09F7287DAEA7BE98FDA0D1D7F8CC58594145B6321D3283309006210E29C5
SSDEEP48:XJy/LznL9R1sC9GUBih1TfrKmyJg7hZdms1xT0x:efxHvGUBihVFGSt0x
TLSHT187310A2C3F7A52D76ABA1CECAFF6053E9712435843606059E452A9B55338B0981CFFA4
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw.index.bc
FileSize10244
MD5CD70FD281C3A85C950F173895B720D85
SHA-163D93F6DA60B2A5DB3CBBDD6A93DD1E24C7DBA13
SHA-25615D1DA1D18B375F477FE8C31B73E65351D242261D4342A46AB2A3817CD30D7BD
SSDEEP192:SAhbFfkGW/NWJ7IlYo7A+3MWQCQHJZEeut0qh3nADp15R6Ay80IasBj1vBc4:SAhbFZW/N+S3MW80tX3ADp15mXIasBjF
TLSHT14B227EDBF7098874E966A2568CEF9DF955E8031B41A328EBE75C3C42399631D50CEC70
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize65960
MD5AA10752DA7C1990F2E4451C92741F2D2
SHA-1AFA771938D66549C1E281D5DD9C430890B8772BA
SHA-25675125051C0F0884E2022CBB924EC0E88725B44B97FE33F0149D19CBE25C5E0F7
SSDEEP1536:fTBB1hjUAnghMQL6Yuqw6cZYoZQFdJF8WJ:fTBB1hjUAg4ZXZYleW
TLSHT13A537B19B5A0D2E1D488167E4CBF12CE1BB6B108DF09A6233395772C3E70195F6726BE
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize24472
MD589467D50AE84E4DCB468DB278CB434CE
SHA-1D45A9004CD487A27EA89B2C67452B115597D2D7D
SHA-25602EFD67F2DD544B3C4434539CC715A66B4CB9AC62678576BCE4D97F172F68BFC
SSDEEP384:kc4tMWHOyOXwAlNcZI0r3mS3gJVWxvKQMiIblBtuSz7+KRB5Q8:RheOAAlNcmWNCCUaKRBG8
TLSHT112B28D18F2958253C5CC027D4A7F03AB0BE6B54CEF0482837299B73C7D76684AE725B9
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize16624
MD52BB5E7C631552326FFA82176AD6CB905
SHA-138D301E14AF55EB06CACC64E640987C1943FF121
SHA-256AE0E04FBFFA24F66ED41F7AD2F50574A52099C142111382DD70D5F414D7A7099
SSDEEP384:kI0VKpr33r3cr3KilK1kpua8s0SoMfWYiiCJdW:RLTuvFd8vGWRiCJdW
TLSHT123721A2EB6A94782D189037E183F01CA57FAE408EF16539726D9733C7C70209E9F1A79
Key Value
FileNameogr_fdw--1.1.sql
FileSize767
MD5117BF214A9335C66AB3A7A7CD81D993B
RDS:package_id285120
SHA-13A2503FBEACD0C4038357414816667E81AF7B531
SHA-2567ED528C0611FFD669276F6E38F047C9CFE9E0CDC2E348245C1D49D241A955780
SSDEEP12:UtjGFoUEeBNFY/9UOeSxdcSewsncDS/WuAMVsEURxZoFFeBzU0/l7zFFeB5:qyto7ezSeDGS/WFb9p8eBIyl3eB5
TLSHT14A014C0F596DE1238391BE78A406887FDB12434E4817AAC0909B651C5EC6A094725FFA
insert-timestamp1662198435.6775877
sourcedelta.db
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize6288
MD58C31F847A3F402274EECDE64D6166381
SHA-14C4B20E566737E70F27F411F076ECD4D3C567447
SHA-25672E27958513C8A36FCACA5EB7EBAEEBD664BD54689E71D4D5A9B448C10E46AAB
SSDEEP96:kA9cXSFkqwSJ7Wwo2T/EhC8mwKD9HTn3E+J6g5AGKtZDy+KiwH31oyToYqXWri5G:kocqTb/YhCMKDtr3Ex7GKtTP2lstgL
TLSHT1A6D14C2973640791C29D063DE97E42DA6779E904DF82726B6386B62CBAB022E3910572
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464