Result for 61B65DBA1122DD624306BFF6499165FA9B55C63F

Query result

Key Value
FileSize99460
MD5F71E23CD216BF044A6E0CBE1F53CED49
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.0-1
SHA-161B65DBA1122DD624306BFF6499165FA9B55C63F
SHA-256C4DBE6F79B93738F9C39CB7F49C0FD391920156B6EEDA4ED0AD45DF027A4E982
hashlookup:children-total14
hashlookup:trust50

Network graph view

Children (Total: 14)

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

Key Value
FileName./usr/lib/postgresql/13/bin/ogr_fdw_info
FileSize27352
MD5E9E1850561A4CD420E06ACAB7E8A4FF2
SHA-188E5732ADCEF8EA3225A28E97C7ECAFC2B164DE8
SHA-256A58BA4AAA0BF47A9A208E09338CF3FBC668A8EAC2DA33FFF1B6753EF89D00652
SSDEEP384:Amrm5BhnkdoQG/IcpTIlsnOelJb/h+vY:9rm5yW/IeTqwOEJbp
TLSHT122C2B66EF958D967C98AE3345D9F8272B3235108D336C3F37148065D6E8B7FA8D60990
Key Value
FileName./usr/lib/postgresql/13/lib/ogr_fdw.so
FileSize63576
MD568902527A659C99EC78A5435FF027EF6
SHA-11A5D13D245A27B4F61F26924DB578AF65B2B0EBF
SHA-25612CBC752A0076BC875D510C79CA4270B6ACC42A9CC727A01653D02168BC10A84
SSDEEP768:X6CQTPSQIoaED4oW/PYsXpqGZ9m9/RImTV+u1zMR6Tbbtcl:XaTPZD4oWYkpq1ZJ+UzbX
TLSHT161532B1DF40ED5E3C746F33509CA5661F733201CF16E4AE233285B696E4B24EAEB2958
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
FileNameogr_fdw.control
FileSize152
MD5408F173AC888FA17C052E673078E59A0
RDS:package_id285118
SHA-1ABDA8467690571C922AFF0388ABD42855D6818F7
SHA-256163D3B61CC6DC3415543E755617DDC9579E6E42149687D2AA0A0A0C5A43773A0
SSDEEP3:SJFAYT8XqgSZVQisnqBCv2DB4AGNRKmVVERNwoCEHBYjQCvcTpdFR1n:SJFzT8XqgSZVgD2GNRKm/ErwoXHBYcPv
TLSHT158C08C2113AA84A20814BF28D9000020DEA43AB82212242712C8888C3BA0789B241B09
insert-timestamp1662198435.5457163
sourcedelta.db
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize63736
MD5C53CE27E07DD6726F9F4E25DEAF4A40D
SHA-101854836D075959C6F5BB9F540D35530860DC37E
SHA-2562CCBF2CC3048A2225BF958260ABD65457058EABF1A8C3F53D99343F11D83D333
SSDEEP1536:STxeVToIZV4Zl4NxQgGBQw/c2ZK0JaF8mJ:STxeVToIZuZSTQg1l9em
TLSHT11B536B2E72A0D2D2D44C537D4CBF02CE07B5BA04AF15525737A8672DBCB1288EA7297D
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/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize23692
MD5ADCC50671F0DE3BEC65BA97C926ADA48
SHA-1285DF245D77731CBD061576591A7123A9372204E
SHA-25675603C0E6E135287B0435A49C9DAC000B48AF058128316C69675235283D3EE6A
SSDEEP384:kK4tMWHOyOXZw1/fx5KJ/r3TzkgWRYK6N4slXE+t2Sr2+PB5QAJ:TheOK1RsJ7nDWVsFPr1PBGk
TLSHT117B28D19F5A6561BC488463E4EBF02DB47E6F148DF0482437A49672CBE723849F7117E
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize5864
MD5AFCB0A44C45407A62471B4695F5738F1
SHA-125DEEA0025689AE84720916DE1B8202392F6998B
SHA-256A2502591A576AEF6AE993337612FCFD54DA936AA67E3109D6F3E19B0A8E01483
SSDEEP96:kL9cXSFkq6JVRWE8SEh7q/mHTn3ZHGmG6pKtZDy+KacJ1okP3oYqXWf7oYmwgbBF:k5cq6nmh7q/0r3gOpKtT+dP3gcA
TLSHT1D9C12A2933681A91C05E073DEDBF42C65739EA049FC2A6577689B72CBDF031F69105B2
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw.index.bc
FileSize10248
MD5D6474A15970A51A160093DFB50458353
SHA-10FFD37D12EB2B756C7BFC1E571BBB5CE3A08A7E9
SHA-25696F4A5BC9776C769383438F636FE7473E40F537461425DA16274E9052987916E
SSDEEP192:YABFvKREArF9OYO27eUFUT0g2RJ9qDOaeyPfnbGZ5fDQEXRmdyF3v0VUuPu:VBFErFLSUCTiRJKOafbGZ57zKyGuum
TLSHT184227BCBE3E89524E446D4A3C1FF9CB9D2E88213126364CBD0996E5B3F6536B42DD0B4
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize15532
MD5A1E6B153A3D35F571C6C21976C2A504E
SHA-16AD66C10139D0FE818CF833F92F01AA1AC863EB6
SHA-256521A6C52E12B957864AE0104FAF43B734F456842E2CC68EE70E9BB9AD54DEF96
SSDEEP192:kDLL3h7Jr3tYwnXKOjfx07HYPsvCbYzKtTcwG7pw7La/5zLmGSRY/FZLLcYGdicm:kD/Hr3wexDPdGtKLa/IMgYiiCQ4dW
TLSHT1C862E72ABA944392D188433D197F02CB93BAF10CCF1A9743269C773D6975245E9B1E3E
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/changelog.Debian.gz
FileSize1531
MD5BB1F73C9C547BA5937B8C85DE0B5261F
SHA-1909565F4A19E1251BBFB8405575B7DF832C3F60A
SHA-256DE88B285B27D97593EAC7EE1204BF1957EB89FE96FCA610778A6E0F7F8C73380
SSDEEP24:XIS1fX06dPb7fZft+H1P3ox8+pafYysZuAqAtS+niZL2P4Ad7Xe3iTkEH6MKbV3X:XIcHRft+HBYxd6Y6d07XeizHs3X
TLSHT14C31B599588D42B179AAA913850F494B6F6A6C43BEC30549E2F8034E90B8B6F4B69021
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/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize10484
MD5816F007CB9F10BB301A756E186F6E61B
SHA-142D249C287FD2EF53CC64A61400AF73D59A422CF
SHA-2569A9865FA3FD749F4E4391D2BAA467541DC59EF733AE9F53C483603C3387E44C0
SSDEEP192:kas23h7EZ5Yl71NVp0r38G4E5KtTyFKfg6DGo++AfIeFPA3guJlHdTMJML/g:kaJWSnVar3hRFegaG7+Af7FPA3BJ9JDg
TLSHT17D223A2FF75466D1C08857381CEB42CE96E9A4408FB0767BABB35A3CBEB217758B0550