Result for B18C43AD04CB30B974C2781529B199BE11CE8DF1

Query result

Key Value
FileSize103124
MD5BA16A02A080F3D9D9A38757312366F82
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-1B18C43AD04CB30B974C2781529B199BE11CE8DF1
SHA-256797F11C8C2C9CD2457D5F3307A8ADB7ACEBC46C1507E922FF7B33A0643AFAF30
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/share/doc/postgresql-13-ogr-fdw/changelog.Debian.i386.gz
FileSize225
MD594A1E83DCDCFA0EBF6123E5D0B8C7CEA
SHA-138F5F5883F16B585D442C17EE7CEBEBA3856FD43
SHA-256F09B8E7CAEC5FBD06C51DA7E28FDBA1CFDBD263695D01F5F2D5FC9A838EC745E
SSDEEP6:Xt62z2vs2pmuEGCZZIvxQ/Tn7hFAXQHh0s7UDFbSP30E7pnR/n:X9asZNG2SJ0Tn9cRbSJ7pR/n
TLSHT181D02376083E3C629D51073171D157B7DF7D42924474DBD288D71590C07DDADEB4458E
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize9980
MD54364143FA43AF9D757F2F90C678F0795
SHA-110FDF187EB8F85F19FBEE9B95E629FDE45DDB46F
SHA-2569AA6E310CE61A429B365E32E0E6D11156271E0D1ADB6A7CEEFA813DA4A8DFD4A
SSDEEP192:kqb0cp+Ptr3unKtTFaDGyXjbFihT0TWuCJML:kqx01r3uxqUBihMW
TLSHT188221A2FB3DD4B50E5490B3C4CEB425DA36AF445CF159B67BB92792CBDB013A94E0121
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/lib/bitcode/ogr_fdw.index.bc
FileSize10224
MD54E25873034BA86283EA4912A559399BD
SHA-176163096B3B9E983766EFE18BEE8B323131DAA31
SHA-2560F50C31D075D6E1ABA35905C2045AA5E3CF6C24DE7C0F76940D186AC9A79DE6C
SSDEEP192:ovjfpdfLmvggJWN3VvRo4dsD9eQIPC1zRa7FlPuhULdCOMX8wZD6P:Q6vgEWNlvRo48VIPC1zRulPumwOI8wZG
TLSHT1EF228ED6F7C6C2A2A245E2D0C4EF0EF861C00147525B4AD78B583D8A762631D4BEE73A
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize5888
MD5D935B2BB5E82F96714266F390D1EF3E3
SHA-1338ADD150B93B9EBD6D191C58B227E5E43B383D2
SHA-2566294D6640159B319E8A0C6BF1647BDB1C03D26D71F7034A4B6672D982802D3C5
SSDEEP96:kj9XJxc21qJ7W/mGJ7W/mr/9HTn3mex/SrnwUdKtZDy+YsWg417toYqXW1oYmwgF:kRUW/Wa/tr36w6KtTFWJ17rgF
TLSHT17EC11B1A739806E2C25A073D5C6E82D92729F5089F969B437659772CFAF135FE400073
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/ogr_fdw.so
FileSize71160
MD52A25733A607500B567680539A2904204
SHA-1DACA34FAA8C1F89AD819C605855A957C86771C06
SHA-256C2E694A0A2C402F9CAF79A078A48AE078EEAD4A8B82504D01044119E6362D4A7
SSDEEP1536:UBhWoXbVdtXWpUwWnflmz3MBDnADlzwLA4x0fa:U+oXbf1WFWnfMz3M5yRi
TLSHT19F63E79BF746D8B0F29240F805DB56336E6056499073F3F2F9893749A8B23C9ED29271
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize15560
MD543DA6B767D449CD1C6F56E42A79D7EC2
SHA-146C4F1E7624F21EFE2BEB7DA1DAE3478F2557B48
SHA-256D5B28D327CD14E26D8E3D57787841F10FCA0C1148CD5E0326C583B9F6D484EFE
SSDEEP384:kE6r3Orzx1Vxvd8SoDkkyUoMD0+oYii/mdW:BECLxvd8S4loRi/mdW
TLSHT11A62D71AB6D486D2D696473D183F019B93BAF508DF1693933B8C333C6DB1244E9B057A
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/ogr_fdw.bc
FileSize63784
MD5EE95716361F46A8602279E80760152F3
SHA-1FCE51563450E7EBC902DA59EBCEBD60EEAB507B1
SHA-256B7296906EB5E6B659E759C03C0AEC7C911405753837708A4A8F488D9EF84C6BD
SSDEEP768:lPcbvKM+BkTyLeZbeBV27C8JnQJUJoIXsmDqCZpwr/A7de68o6eJ2:OjKMWLAHrQJUJLrDqCZpwbYF8CJ2
TLSHT175537C2D35659391D88C173E4CBF1ACD07A1A508DF0696173799AB6C3D71384FA32ABC
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/bin/ogr_fdw_info
FileSize30480
MD5D9951AF89A393D2037C2B76241AB653C
SHA-19D9A2576D75CDCAF78FBF72FF89E42AA75EA1E98
SHA-256813AE49EA275B88A3BE8A960E18119F6B40F74E56494AB7C86D19D49D41EFC77
SSDEEP768:ltuWmX8sROafTRlHCvdpXibsbLiqHWOZ71i1/S:wsotynbLi0W0
TLSHT105D2E75EF746C871E0B284FA84A72BA461706C49D137F6E3FB0D33581DB13D9E9252A8
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize23680
MD5CC5BDBB23AA961AA47152FE3D958F86B
SHA-1B6974C36790AE5958A47A2A2C78850E6E2D8D836
SHA-256B2971C9B9BC0C58E482DE6BD57A7010AFA4C3E4679519A64C4FE0CDE71D3D51D
SSDEEP384:kDO7oQFgoUTKL07Wn1F1YPr3wS/s8OW6vfpXHVa9rJsHDQ+B5Qe:aqwtTKg7W1e1U1W+fO9reHDQ+BGe
TLSHT147B27D3FF2665A51C504163C4CBF02DB17E2B588EF14834BA659A72C7EB2384AF71635
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464