Result for D9CE0286C5D797BE6B54CED9B3F061ACC931E159

Query result

Key Value
FileSize102744
MD5DECCAA618AF5374C5BC19FB40E23A853
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-1D9CE0286C5D797BE6B54CED9B3F061ACC931E159
SHA-2569D17C5CB0CD4D97BD435A4FFB5E82923C4547CA2908781188AF7A1FDD8B4DBDC
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/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464
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
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.index.bc
FileSize10264
MD5E7E0B89DB5CF3B0DCBB529C49DB66642
SHA-1070ACEDEDC3EB006ADC394FC5715E35885DFBF9E
SHA-256717A6378CEBB565DC36B3F34DD58F13395D2A45A34A481084AC3A87DBC120E6F
SSDEEP192:l5M6uePHvwk11JrVz6FV5rgDm+xWVBwTaBrKbYjDY+lFyRnefWA5QkIHcTOdLgTA:ljPjBNiD0q2WETWrKbcY4in6h5Mhp
TLSHT192228DC6E7A89225DA4AF1DAC8DF0DFD04D6106B10560B9FD9ED3E07380A30DA59E87C
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize15560
MD5506F988BBB695D0941838F9004DE555D
SHA-12F2A5C320437F82B8EBA42DDA471FD4FEA80CC8F
SHA-2562C3A0F279CA605C136F7756B640BB2CF6094CEE7E973CF6D17D5E5EBE293E2DA
SSDEEP384:kE6r3Ornx1Vxvd8SoDkkyU5MD0+oYii/bdW:BESLxvd8S/loRi/bdW
TLSHT10F62D71AB6D486D2D696473D183F019B93BAF508DF1693933B8C333C6DB1244E9B057A
Key Value
FileName./usr/lib/postgresql/13/bin/ogr_fdw_info
FileSize30480
MD542056A84746EE45ADC641157CD56D4B0
SHA-1B90EDECE17EAC456E9826D3BE817A521668ACEB6
SHA-2564B725D32D419286ABA9BEBF7F90ED53372C190197AAD31FCC98F622E8155123A
SSDEEP768:+vWmSssROafTRlHCvNpXi47oiJ3WOZV1Pfn7H:8potiD7oiNW2
TLSHT165D2E76BFB42C8B1E0B204F914672BA461706849D973FEE3FA0D375C18B1399E91527C
Key Value
FileName./usr/lib/postgresql/13/lib/ogr_fdw.so
FileSize71160
MD523F3472A684D8AC843F0B5E8B8D8C736
SHA-1F0BABE63EF5691B5F6ACFDA084A18ADE76C59110
SHA-25690B3C054482612CBF7583B8A4BE007B3B60034B31CA554423EE78362F678D701
SSDEEP1536:UCh7CXbmdtXWpnUuCzboZ70DeqohzSqzhDMM9lV+W:UMCXbU1W1UuCz0ZIK71vV+
TLSHT10863095EF746D8B0F25340F805DB92326E605649D073F3E2FE893749B462389ED2A276
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize23676
MD5724F9A7008CC190028CFA5F6461D76B5
SHA-176A177C69D821D8864F54603201A9D8EBCAC6F8B
SHA-256DCB9DE7BBCDDAECD13B1FF5264A3747F9B5BD725F4753F02C4A2CBACDBD13A4B
SSDEEP384:kYO7oQFgoUD307WuwQr3wSjs8cW6vfpXHVa9rJsHhQ+B5Q3:FqwtDk7jw61QfW+fO9reHhQ+BG3
TLSHT158B28D2EF2A55A52C548173C4CBF02DB17E6B488EF048347A64E672C7EB2384AF71579
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize9980
MD55733189C215E35E9D6D6FAE3462D0BE0
SHA-1A0DFDE9DE4756065461147F233F80D1ADA74774B
SHA-2567BAEEE9BB1B857BCB9BB7914938F1E2E6EFEB76532F558588B00F0017D326464
SSDEEP192:kqb0cp+Ptr3wnKtTFaDGyXjbFihw0TWuCJML:kqx01r3wxqUBihXW
TLSHT1C8222A2FB3DD4A90E5490B3C4CEB425DA36AF445CF159BA7BB92793CBDB013A94E0121
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize63784
MD510CF88A0E5ED22A64AD499FE465A5B9D
SHA-149D0A62C70C3B972BF496A114AE165C181CBEF9C
SHA-256B02FA764446499D5E8D5654E99A2A3CC63E08672BC5429BDE4D94B38E55ED40C
SSDEEP768:lnwIpmCHOBkKyReIXbeBKRZC8UnYJYkoIXsmDqaBFZpwr/A7de68oBeJ2:FwFoNRhlgYJYkLrDqsFZpwbYF8LJ2
TLSHT196537C2D35659381D88D173E4CFF1ACE07A2A508DF06865736999B2C3D71344FA72ABC
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/changelog.Debian.gz
FileSize1531
MD5BB1F73C9C547BA5937B8C85DE0B5261F
SHA-1909565F4A19E1251BBFB8405575B7DF832C3F60A
SHA-256DE88B285B27D97593EAC7EE1204BF1957EB89FE96FCA610778A6E0F7F8C73380
SSDEEP24:XIS1fX06dPb7fZft+H1P3ox8+pafYysZuAqAtS+niZL2P4Ad7Xe3iTkEH6MKbV3X:XIcHRft+HBYxd6Y6d07XeizHs3X
TLSHT14C31B599588D42B179AAA913850F494B6F6A6C43BEC30549E2F8034E90B8B6F4B69021
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize5892
MD50B8CE4FD6B620F64FF040BC839CABF6A
SHA-101645D36DB5B2A16D4ABDBA53A241C72DEFB0410
SHA-256B3CAA0FCF770077CBBCAF7CFEC23C7D47841CA0AC0402D5A9261A432367E80C4
SSDEEP96:kg9XJxc21qJ7W/mGJ7W/mr/9HTn3mexSrnwU8KtZDy+YsWg417BoYqXW1oYmwgbG:kIUW/Wa/tr3aw3KtTFWJ17ngy
TLSHT1B7C10B2A739806E2C25A073D9C6D83C92725F5089F959B477659772CBAF135FE4000B3